PREVIEW / etf_30min / 2001-02-22
file: by_date/etf_30min/2001/2001-02-22.parquet size: 14 KB rows: 335
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2001-02-22 09:30:00 | SPY | ETF | 126.35 | 126.35 | 125.16 | 125.2 | 2329300.0 |
| 2001-02-22 10:00:00 | SPY | ETF | 125.13 | 125.5 | 124.08 | 124.26 | 2757100.0 |
| 2001-02-22 10:30:00 | SPY | ETF | 124.26 | 124.94 | 123.02 | 124.7 | 2413600.0 |
| 2001-02-22 11:00:00 | SPY | ETF | 124.73 | 124.99 | 124.2 | 124.69 | 1514100.0 |
| 2001-02-22 11:30:00 | SPY | ETF | 124.61 | 125.7 | 124.55 | 124.98 | 2279400.0 |
| 2001-02-22 12:00:00 | SPY | ETF | 124.98 | 125.18 | 124.65 | 124.88 | 855800.0 |
| 2001-02-22 12:30:00 | SPY | ETF | 124.7 | 125.68 | 124.7 | 125.36 | 2055600.0 |
| 2001-02-22 13:00:00 | SPY | ETF | 125.49 | 126.3 | 125.34 | 125.72 | 1206800.0 |
| 2001-02-22 13:30:00 | SPY | ETF | 125.7 | 126.06 | 125.35 | 125.94 | 465100.0 |
| 2001-02-22 14:00:00 | SPY | ETF | 126.0 | 126.54 | 125.6 | 125.6 | 737100.0 |
| 2001-02-22 14:30:00 | SPY | ETF | 125.53 | 125.78 | 124.78 | 125.15 | 1114900.0 |
| 2001-02-22 15:00:00 | SPY | ETF | 125.04 | 125.17 | 123.92 | 124.9 | 888600.0 |
| 2001-02-22 15:30:00 | SPY | ETF | 124.97 | 125.94 | 124.59 | 125.52 | 1086800.0 |
| 2001-02-22 16:00:00 | SPY | ETF | 125.34 | 125.96 | 125.34 | 125.34 | 555500.0 |
| 2001-02-22 16:30:00 | SPY | ETF | 125.1 | 125.1 | 125.1 | 125.1 | 62500.0 |
| 2001-02-22 09:30:00 | QQQ | ETF | 51.45 | 51.62 | 50.38 | 50.5 | 9724600.0 |
| 2001-02-22 10:00:00 | QQQ | ETF | 50.5 | 50.72 | 49.38 | 49.58 | 10111400.0 |
| 2001-02-22 10:30:00 | QQQ | ETF | 49.53 | 50.73 | 48.89 | 50.5 | 13294700.0 |
| 2001-02-22 11:00:00 | QQQ | ETF | 50.55 | 50.9 | 49.88 | 50.69 | 8176300.0 |
| 2001-02-22 11:30:00 | QQQ | ETF | 50.7 | 51.57 | 50.49 | 50.56 | 8827800.0 |
| 2001-02-22 12:00:00 | QQQ | ETF | 50.54 | 50.8 | 50.0 | 50.22 | 3871000.0 |
| 2001-02-22 12:30:00 | QQQ | ETF | 50.15 | 51.26 | 50.11 | 50.95 | 5424400.0 |
| 2001-02-22 13:00:00 | QQQ | ETF | 50.8 | 52.1 | 50.8 | 51.6 | 5809300.0 |
| 2001-02-22 13:30:00 | QQQ | ETF | 51.62 | 51.95 | 50.95 | 51.9 | 4785400.0 |
| 2001-02-22 14:00:00 | QQQ | ETF | 51.9 | 52.16 | 51.45 | 51.5 | 4636800.0 |
| 2001-02-22 14:30:00 | QQQ | ETF | 51.5 | 51.6 | 50.43 | 50.65 | 5845200.0 |
| 2001-02-22 15:00:00 | QQQ | ETF | 50.66 | 50.87 | 49.38 | 50.13 | 8777600.0 |
| 2001-02-22 15:30:00 | QQQ | ETF | 50.13 | 50.79 | 49.98 | 50.65 | 7358900.0 |
| 2001-02-22 16:00:00 | QQQ | ETF | 50.64 | 51.5 | 50.05 | 50.94 | 1666700.0 |
| 2001-02-22 16:30:00 | QQQ | ETF | 51.0 | 51.07 | 50.0 | 50.0 | 329400.0 |
| 2001-02-22 17:00:00 | QQQ | ETF | 50.01 | 50.35 | 49.7 | 50.2 | 241700.0 |
| 2001-02-22 17:30:00 | QQQ | ETF | 50.0 | 50.37 | 50.0 | 50.15 | 51500.0 |
| 2001-02-22 18:00:00 | QQQ | ETF | 50.2 | 50.75 | 50.2 | 50.55 | 54300.0 |
| 2001-02-22 09:30:00 | IWM | ETF | 48.175 | 48.245 | 47.93 | 48.025 | 25200.0 |
| 2001-02-22 10:00:00 | IWM | ETF | 48.0 | 48.0 | 47.425 | 47.425 | 10800.0 |
| 2001-02-22 10:30:00 | IWM | ETF | 47.2 | 47.55 | 47.2 | 47.55 | 3200.0 |
| 2001-02-22 11:00:00 | IWM | ETF | 47.5 | 47.5 | 47.495 | 47.495 | 17600.0 |
| 2001-02-22 11:30:00 | IWM | ETF | 47.485 | 47.745 | 47.485 | 47.745 | 9000.0 |
| 2001-02-22 12:00:00 | IWM | ETF | 47.415 | 47.415 | 47.15 | 47.15 | 19800.0 |
| 2001-02-22 12:30:00 | IWM | ETF | 47.15 | 47.55 | 47.15 | 47.425 | 74800.0 |
| 2001-02-22 13:00:00 | IWM | ETF | 47.3 | 47.675 | 47.3 | 47.55 | 57800.0 |
| 2001-02-22 13:30:00 | IWM | ETF | 47.45 | 47.585 | 47.4 | 47.425 | 73000.0 |
| 2001-02-22 14:00:00 | IWM | ETF | 47.5 | 47.75 | 47.5 | 47.7 | 87600.0 |
| 2001-02-22 14:30:00 | IWM | ETF | 47.6 | 47.62 | 47.425 | 47.425 | 31600.0 |
| 2001-02-22 15:00:00 | IWM | ETF | 47.5 | 47.5 | 47.125 | 47.25 | 55600.0 |
| 2001-02-22 15:30:00 | IWM | ETF | 47.3 | 47.735 | 47.3 | 47.5 | 49200.0 |
| 2001-02-22 09:30:00 | DIA | ETF | 105.6 | 105.85 | 105.15 | 105.2 | 540500.0 |
| 2001-02-22 10:00:00 | DIA | ETF | 105.2 | 105.55 | 104.6 | 104.61 | 223700.0 |
| 2001-02-22 10:30:00 | DIA | ETF | 104.61 | 105.1 | 103.8 | 104.96 | 595100.0 |
| 2001-02-22 11:00:00 | DIA | ETF | 104.96 | 105.0 | 104.44 | 104.71 | 117300.0 |
> showing 50 of 335 rows — these rows as CSV