PREVIEW / etf_30min / 2000-09-29
file: by_date/etf_30min/2000/2000-09-29.parquet size: 11 KB rows: 278
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-29 09:30:00 | SPY | ETF | 145.4688 | 145.6562 | 145.0625 | 145.625 | 803000.0 |
| 2000-09-29 10:00:00 | SPY | ETF | 145.5625 | 145.5625 | 144.75 | 145.0625 | 354000.0 |
| 2000-09-29 10:30:00 | SPY | ETF | 145.0 | 145.1562 | 144.6875 | 145.125 | 236100.0 |
| 2000-09-29 11:00:00 | SPY | ETF | 145.125 | 145.125 | 144.5 | 144.7188 | 749400.0 |
| 2000-09-29 11:30:00 | SPY | ETF | 144.7812 | 145.0938 | 144.375 | 144.5 | 298400.0 |
| 2000-09-29 12:00:00 | SPY | ETF | 144.4375 | 144.75 | 144.375 | 144.75 | 171400.0 |
| 2000-09-29 12:30:00 | SPY | ETF | 144.8125 | 145.125 | 144.625 | 145.0 | 353000.0 |
| 2000-09-29 13:00:00 | SPY | ETF | 144.9375 | 145.0 | 144.6562 | 144.9062 | 113700.0 |
| 2000-09-29 13:30:00 | SPY | ETF | 144.9062 | 145.5 | 144.7812 | 145.1875 | 542200.0 |
| 2000-09-29 14:00:00 | SPY | ETF | 145.3125 | 145.6875 | 145.0312 | 145.0312 | 326800.0 |
| 2000-09-29 14:30:00 | SPY | ETF | 145.0 | 145.1562 | 144.6562 | 144.875 | 808800.0 |
| 2000-09-29 15:00:00 | SPY | ETF | 144.8125 | 144.8438 | 144.3125 | 144.75 | 634400.0 |
| 2000-09-29 15:30:00 | SPY | ETF | 144.5625 | 145.125 | 143.75 | 143.7812 | 2129700.0 |
| 2000-09-29 16:00:00 | SPY | ETF | 143.9375 | 144.0 | 143.625 | 143.75 | 1666700.0 |
| 2000-09-29 09:30:00 | QQQ | ETF | 92.0 | 92.125 | 91.1875 | 91.9375 | 4589800.0 |
| 2000-09-29 10:00:00 | QQQ | ETF | 91.9375 | 91.9375 | 90.625 | 91.0938 | 3122700.0 |
| 2000-09-29 10:30:00 | QQQ | ETF | 91.125 | 91.2188 | 90.375 | 90.9375 | 1996600.0 |
| 2000-09-29 11:00:00 | QQQ | ETF | 90.9375 | 91.0 | 90.375 | 90.7812 | 1300900.0 |
| 2000-09-29 11:30:00 | QQQ | ETF | 90.7188 | 91.1875 | 90.25 | 90.4062 | 1787500.0 |
| 2000-09-29 12:00:00 | QQQ | ETF | 90.4375 | 90.6875 | 90.25 | 90.6875 | 745500.0 |
| 2000-09-29 12:30:00 | QQQ | ETF | 90.6562 | 91.0 | 90.4688 | 90.9375 | 813700.0 |
| 2000-09-29 13:00:00 | QQQ | ETF | 90.9062 | 90.9062 | 90.125 | 90.375 | 603500.0 |
| 2000-09-29 13:30:00 | QQQ | ETF | 90.375 | 90.9375 | 90.3125 | 90.625 | 1361000.0 |
| 2000-09-29 14:00:00 | QQQ | ETF | 90.625 | 90.9375 | 89.875 | 89.875 | 2106500.0 |
| 2000-09-29 14:30:00 | QQQ | ETF | 89.8125 | 90.125 | 89.5 | 89.6875 | 1526800.0 |
| 2000-09-29 15:00:00 | QQQ | ETF | 89.75 | 90.0 | 89.0625 | 89.875 | 2450600.0 |
| 2000-09-29 15:30:00 | QQQ | ETF | 89.8125 | 90.4375 | 88.875 | 89.125 | 3376400.0 |
| 2000-09-29 16:00:00 | QQQ | ETF | 89.0938 | 89.125 | 88.6875 | 88.9375 | 1175400.0 |
| 2000-09-29 16:30:00 | QQQ | ETF | 89.0 | 92.4375 | 88.6875 | 88.8125 | 14400.0 |
| 2000-09-29 17:00:00 | QQQ | ETF | 88.875 | 88.9375 | 88.8125 | 88.9375 | 8900.0 |
| 2000-09-29 17:30:00 | QQQ | ETF | 88.9375 | 89.25 | 88.8125 | 89.25 | 1200.0 |
| 2000-09-29 18:00:00 | QQQ | ETF | 88.75 | 89.0 | 88.75 | 88.75 | 7000.0 |
| 2000-09-29 09:30:00 | IWM | ETF | 52.0156 | 52.0156 | 51.8438 | 52.0 | 79000.0 |
| 2000-09-29 10:00:00 | IWM | ETF | 52.1562 | 52.1562 | 51.8125 | 51.8125 | 4600.0 |
| 2000-09-29 10:30:00 | IWM | ETF | 52.0312 | 52.0469 | 52.0312 | 52.0469 | 1200.0 |
| 2000-09-29 11:30:00 | IWM | ETF | 51.9375 | 52.0 | 51.9375 | 52.0 | 30200.0 |
| 2000-09-29 12:00:00 | IWM | ETF | 52.0312 | 52.0625 | 52.0312 | 52.0625 | 1200.0 |
| 2000-09-29 14:00:00 | IWM | ETF | 52.1875 | 52.1875 | 52.1875 | 52.1875 | 1200.0 |
| 2000-09-29 14:30:00 | IWM | ETF | 52.0312 | 52.0312 | 52.0 | 52.0 | 8000.0 |
| 2000-09-29 15:00:00 | IWM | ETF | 52.0625 | 52.0625 | 52.0625 | 52.0625 | 1000.0 |
| 2000-09-29 15:30:00 | IWM | ETF | 52.0 | 52.0 | 51.8438 | 51.8438 | 3200.0 |
| 2000-09-29 16:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 400.0 |
| 2000-09-29 16:30:00 | IWM | ETF | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 400.0 |
| 2000-09-29 09:30:00 | DIA | ETF | 107.9375 | 108.125 | 107.625 | 107.9062 | 127500.0 |
| 2000-09-29 10:00:00 | DIA | ETF | 108.0 | 108.0 | 107.25 | 107.5 | 66300.0 |
| 2000-09-29 10:30:00 | DIA | ETF | 107.5 | 107.6875 | 107.25 | 107.5625 | 36100.0 |
| 2000-09-29 11:00:00 | DIA | ETF | 107.625 | 107.625 | 107.0312 | 107.1875 | 31300.0 |
| 2000-09-29 11:30:00 | DIA | ETF | 107.1875 | 107.4688 | 107.0 | 107.0 | 17000.0 |
| 2000-09-29 12:00:00 | DIA | ETF | 107.0625 | 107.1562 | 107.0 | 107.125 | 17600.0 |
| 2000-09-29 12:30:00 | DIA | ETF | 107.1875 | 107.5312 | 107.125 | 107.25 | 78100.0 |
> showing 50 of 278 rows — these rows as CSV