PREVIEW / etf_30min / 2000-10-03
file: by_date/etf_30min/2000/2000-10-03.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-10-03 09:30:00 | SPY | ETF | 144.5312 | 144.875 | 144.375 | 144.5312 | 610500.0 |
| 2000-10-03 10:00:00 | SPY | ETF | 144.5938 | 144.7188 | 143.8125 | 143.9375 | 400700.0 |
| 2000-10-03 10:30:00 | SPY | ETF | 143.9375 | 144.5625 | 143.875 | 144.1875 | 437100.0 |
| 2000-10-03 11:00:00 | SPY | ETF | 144.125 | 144.25 | 143.7812 | 144.0312 | 388400.0 |
| 2000-10-03 11:30:00 | SPY | ETF | 144.2812 | 145.2188 | 144.2188 | 144.9375 | 499700.0 |
| 2000-10-03 12:00:00 | SPY | ETF | 144.9688 | 145.1562 | 144.8438 | 145.0312 | 196500.0 |
| 2000-10-03 12:30:00 | SPY | ETF | 145.1562 | 145.375 | 145.0312 | 145.1875 | 170600.0 |
| 2000-10-03 13:00:00 | SPY | ETF | 145.2188 | 145.25 | 145.0312 | 145.25 | 597000.0 |
| 2000-10-03 13:30:00 | SPY | ETF | 145.25 | 145.6875 | 145.25 | 145.5625 | 781500.0 |
| 2000-10-03 14:00:00 | SPY | ETF | 145.6562 | 145.75 | 145.125 | 145.2188 | 993100.0 |
| 2000-10-03 14:30:00 | SPY | ETF | 145.2812 | 145.4062 | 144.75 | 144.7812 | 944500.0 |
| 2000-10-03 15:00:00 | SPY | ETF | 144.8438 | 144.8438 | 143.6875 | 143.6875 | 436900.0 |
| 2000-10-03 15:30:00 | SPY | ETF | 143.625 | 143.8438 | 142.5312 | 142.625 | 1659700.0 |
| 2000-10-03 16:00:00 | SPY | ETF | 142.5625 | 142.75 | 142.2812 | 142.2812 | 1414700.0 |
| 2000-10-03 09:30:00 | QQQ | ETF | 88.0625 | 88.5 | 87.625 | 87.75 | 3654500.0 |
| 2000-10-03 10:00:00 | QQQ | ETF | 87.6875 | 87.875 | 86.3125 | 86.5 | 3728300.0 |
| 2000-10-03 10:30:00 | QQQ | ETF | 86.5 | 87.2812 | 86.4375 | 86.5 | 2309300.0 |
| 2000-10-03 11:00:00 | QQQ | ETF | 86.5 | 86.5938 | 85.875 | 86.5625 | 1775000.0 |
| 2000-10-03 11:30:00 | QQQ | ETF | 86.5938 | 87.7188 | 86.5625 | 87.5312 | 2262400.0 |
| 2000-10-03 12:00:00 | QQQ | ETF | 87.5 | 87.6875 | 86.8125 | 87.0938 | 1828400.0 |
| 2000-10-03 12:30:00 | QQQ | ETF | 87.125 | 87.375 | 86.8125 | 87.0312 | 985000.0 |
| 2000-10-03 13:00:00 | QQQ | ETF | 87.0312 | 87.375 | 86.75 | 87.375 | 1016600.0 |
| 2000-10-03 13:30:00 | QQQ | ETF | 87.2812 | 87.9688 | 87.2812 | 87.8438 | 1806000.0 |
| 2000-10-03 14:00:00 | QQQ | ETF | 87.9062 | 88.5 | 87.0 | 87.25 | 3230600.0 |
| 2000-10-03 14:30:00 | QQQ | ETF | 87.2812 | 87.5312 | 86.2188 | 86.375 | 3165500.0 |
| 2000-10-03 15:00:00 | QQQ | ETF | 86.375 | 86.5312 | 84.75 | 84.9375 | 4085700.0 |
| 2000-10-03 15:30:00 | QQQ | ETF | 84.875 | 85.125 | 83.5 | 83.625 | 4560300.0 |
| 2000-10-03 16:00:00 | QQQ | ETF | 83.5 | 83.75 | 83.25 | 83.375 | 877900.0 |
| 2000-10-03 16:30:00 | QQQ | ETF | 83.8125 | 84.0 | 83.6875 | 83.75 | 7400.0 |
| 2000-10-03 17:00:00 | QQQ | ETF | 83.625 | 84.0 | 83.5 | 83.9375 | 11600.0 |
| 2000-10-03 17:30:00 | QQQ | ETF | 83.8125 | 83.875 | 83.75 | 83.8125 | 7300.0 |
| 2000-10-03 18:00:00 | QQQ | ETF | 83.6875 | 87.75 | 83.5 | 84.0 | 11300.0 |
| 2000-10-03 09:30:00 | IWM | ETF | 51.5781 | 51.5781 | 51.5781 | 51.5781 | 800.0 |
| 2000-10-03 10:00:00 | IWM | ETF | 51.2188 | 51.25 | 51.2188 | 51.25 | 6200.0 |
| 2000-10-03 10:30:00 | IWM | ETF | 50.9062 | 51.0 | 50.9062 | 51.0 | 10600.0 |
| 2000-10-03 11:00:00 | IWM | ETF | 50.875 | 50.9062 | 50.6562 | 50.6562 | 21400.0 |
| 2000-10-03 11:30:00 | IWM | ETF | 50.7188 | 51.0469 | 50.7188 | 51.0469 | 1800.0 |
| 2000-10-03 12:00:00 | IWM | ETF | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 200.0 |
| 2000-10-03 12:30:00 | IWM | ETF | 51.0938 | 51.1406 | 51.0625 | 51.0625 | 6400.0 |
| 2000-10-03 13:00:00 | IWM | ETF | 51.0 | 51.0 | 50.9375 | 50.9375 | 13600.0 |
| 2000-10-03 13:30:00 | IWM | ETF | 51.0938 | 51.0938 | 51.0938 | 51.0938 | 17800.0 |
| 2000-10-03 14:00:00 | IWM | ETF | 51.25 | 51.25 | 51.0312 | 51.0312 | 10400.0 |
| 2000-10-03 14:30:00 | IWM | ETF | 51.0312 | 51.0312 | 50.9688 | 50.9688 | 10600.0 |
| 2000-10-03 15:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.5312 | 50.5312 | 26600.0 |
| 2000-10-03 15:30:00 | IWM | ETF | 50.5312 | 50.625 | 50.4688 | 50.5 | 23600.0 |
| 2000-10-03 16:00:00 | IWM | ETF | 50.2188 | 50.2188 | 50.2188 | 50.2188 | 1000.0 |
| 2000-10-03 09:30:00 | DIA | ETF | 107.4062 | 107.75 | 107.4062 | 107.6875 | 107100.0 |
| 2000-10-03 10:00:00 | DIA | ETF | 107.625 | 107.6562 | 107.2812 | 107.2812 | 35700.0 |
| 2000-10-03 10:30:00 | DIA | ETF | 107.2812 | 107.7188 | 107.2812 | 107.5 | 78000.0 |
| 2000-10-03 11:00:00 | DIA | ETF | 107.5625 | 107.75 | 107.375 | 107.75 | 40200.0 |
> showing 50 of 276 rows — these rows as CSV