EnvpmBFc

1CREATE TABLE IF NOT EXISTS pricehistory (
2        id INTEGER(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3        price INTEGER NOT NULL,
4        region VARCHAR(20) NOT NULL,
5        timestamp TIMESTAMP NOT NULL,
6        is_from_api INTEGER DEFAULT 0)
7	
8SELECT MAX(price) AS price 
9FROM pricehistory 
10WHERE UNIX_TIMESTAMP(CONVERT_TZ(timestamp, '+00:00', 'SYSTEM')) 
11      > 
12      UNIX_TIMESTAMP(CONVERT_TZ(DATE_SUB(NOW(), INTERVAL 1000 DAY), '+00:00', 'SYSTEM')) 
13  AND region='us';
14	
15id: 1
16select_type: SIMPLE
17table: pricehistory
18type: ALL
19possible_keys: NULL
20key: NULL
21key_len: NULL
22ref: NULL
23rows: 368040
24Extra: Using where
25	
26SELECT MAX(price) AS price 
27  FROM pricehistory 
28  WHERE timestamp > DATE_SUB(NOW(), INTERVAL 1000 DAY)
29    AND region='us';