PREVIEW / etf_30min / 2000-09-27
file: by_date/etf_30min/2000/2000-09-27.parquet size: 11 KB rows: 276
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-27 09:30:00 | SPY | ETF | 143.5625 | 143.7188 | 143.0938 | 143.4375 | 485900.0 |
| 2000-09-27 10:00:00 | SPY | ETF | 143.3125 | 143.5625 | 142.8438 | 143.1562 | 448500.0 |
| 2000-09-27 10:30:00 | SPY | ETF | 143.2812 | 143.3438 | 142.75 | 142.875 | 247300.0 |
| 2000-09-27 11:00:00 | SPY | ETF | 142.75 | 143.2812 | 142.5 | 142.875 | 937900.0 |
| 2000-09-27 11:30:00 | SPY | ETF | 142.9688 | 143.5 | 142.6875 | 143.125 | 329100.0 |
| 2000-09-27 12:00:00 | SPY | ETF | 143.125 | 143.4062 | 143.0312 | 143.1875 | 209900.0 |
| 2000-09-27 12:30:00 | SPY | ETF | 143.3125 | 143.9688 | 143.2812 | 143.4375 | 470900.0 |
| 2000-09-27 13:00:00 | SPY | ETF | 143.4375 | 143.625 | 143.25 | 143.4375 | 120100.0 |
| 2000-09-27 13:30:00 | SPY | ETF | 143.5312 | 143.5312 | 142.8438 | 143.0312 | 153500.0 |
| 2000-09-27 14:00:00 | SPY | ETF | 143.0625 | 143.125 | 142.3438 | 142.4375 | 259900.0 |
| 2000-09-27 14:30:00 | SPY | ETF | 142.5 | 143.0 | 142.1562 | 142.375 | 468200.0 |
| 2000-09-27 15:00:00 | SPY | ETF | 142.375 | 142.75 | 142.1875 | 142.375 | 393800.0 |
| 2000-09-27 15:30:00 | SPY | ETF | 142.4062 | 142.8438 | 142.125 | 142.8125 | 773900.0 |
| 2000-09-27 16:00:00 | SPY | ETF | 142.6875 | 143.1562 | 142.6562 | 143.1562 | 1795400.0 |
| 2000-09-27 09:30:00 | QQQ | ETF | 90.625 | 91.0 | 90.0 | 90.5938 | 3598200.0 |
| 2000-09-27 10:00:00 | QQQ | ETF | 90.625 | 90.75 | 89.875 | 90.125 | 1857200.0 |
| 2000-09-27 10:30:00 | QQQ | ETF | 90.2188 | 90.3438 | 89.5 | 89.5625 | 1676500.0 |
| 2000-09-27 11:00:00 | QQQ | ETF | 89.5 | 90.25 | 88.875 | 89.875 | 3131400.0 |
| 2000-09-27 11:30:00 | QQQ | ETF | 89.9062 | 90.9375 | 89.6875 | 90.5625 | 1683200.0 |
| 2000-09-27 12:00:00 | QQQ | ETF | 90.5625 | 90.8125 | 90.375 | 90.625 | 596400.0 |
| 2000-09-27 12:30:00 | QQQ | ETF | 90.625 | 91.1875 | 90.5938 | 90.625 | 1492400.0 |
| 2000-09-27 13:00:00 | QQQ | ETF | 90.6875 | 90.8125 | 90.3125 | 90.5625 | 724000.0 |
| 2000-09-27 13:30:00 | QQQ | ETF | 90.5625 | 90.6875 | 89.6875 | 89.9062 | 642500.0 |
| 2000-09-27 14:00:00 | QQQ | ETF | 89.8125 | 90.0625 | 89.0625 | 89.1875 | 1128100.0 |
| 2000-09-27 14:30:00 | QQQ | ETF | 89.1875 | 89.75 | 88.375 | 88.5625 | 2931500.0 |
| 2000-09-27 15:00:00 | QQQ | ETF | 88.625 | 89.2188 | 88.4375 | 88.75 | 3021100.0 |
| 2000-09-27 15:30:00 | QQQ | ETF | 88.6875 | 89.3125 | 88.0625 | 89.125 | 5217700.0 |
| 2000-09-27 16:00:00 | QQQ | ETF | 89.1875 | 89.625 | 89.0 | 89.5 | 577900.0 |
| 2000-09-27 16:30:00 | QQQ | ETF | 88.625 | 89.5 | 88.625 | 89.5 | 3800.0 |
| 2000-09-27 17:00:00 | QQQ | ETF | 89.5 | 89.75 | 89.5 | 89.5 | 500.0 |
| 2000-09-27 17:30:00 | QQQ | ETF | 89.5625 | 89.5625 | 89.5 | 89.5625 | 1300.0 |
| 2000-09-27 18:00:00 | QQQ | ETF | 89.5625 | 89.5625 | 89.5625 | 89.5625 | 1300.0 |
| 2000-09-27 09:30:00 | IWM | ETF | 51.1562 | 51.4062 | 51.1562 | 51.4062 | 1200.0 |
| 2000-09-27 10:00:00 | IWM | ETF | 51.25 | 51.3125 | 51.25 | 51.3125 | 600.0 |
| 2000-09-27 10:30:00 | IWM | ETF | 51.2188 | 51.2188 | 51.2188 | 51.2188 | 20000.0 |
| 2000-09-27 11:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 8800.0 |
| 2000-09-27 11:30:00 | IWM | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 200.0 |
| 2000-09-27 12:00:00 | IWM | ETF | 51.0781 | 51.2656 | 51.0781 | 51.2656 | 2000.0 |
| 2000-09-27 12:30:00 | IWM | ETF | 51.3438 | 51.3438 | 51.3438 | 51.3438 | 400.0 |
| 2000-09-27 13:00:00 | IWM | ETF | 51.3125 | 51.3125 | 51.3125 | 51.3125 | 200.0 |
| 2000-09-27 14:00:00 | IWM | ETF | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 600.0 |
| 2000-09-27 14:30:00 | IWM | ETF | 50.875 | 50.875 | 50.875 | 50.875 | 400.0 |
| 2000-09-27 15:00:00 | IWM | ETF | 50.9219 | 50.9219 | 50.7188 | 50.7188 | 2400.0 |
| 2000-09-27 15:30:00 | IWM | ETF | 50.5 | 50.6875 | 50.5 | 50.6875 | 6800.0 |
| 2000-09-27 09:30:00 | DIA | ETF | 106.875 | 106.9062 | 106.5 | 106.6562 | 92600.0 |
| 2000-09-27 10:00:00 | DIA | ETF | 106.5312 | 106.625 | 106.125 | 106.2812 | 63500.0 |
| 2000-09-27 10:30:00 | DIA | ETF | 106.2812 | 106.4062 | 106.0 | 106.0625 | 60100.0 |
| 2000-09-27 11:00:00 | DIA | ETF | 106.1875 | 106.4375 | 106.0 | 106.3125 | 71400.0 |
| 2000-09-27 11:30:00 | DIA | ETF | 106.375 | 106.4375 | 106.125 | 106.25 | 70800.0 |
| 2000-09-27 12:00:00 | DIA | ETF | 106.3125 | 106.5 | 106.25 | 106.5 | 8800.0 |
> showing 50 of 276 rows — these rows as CSV