PREVIEW / etf_1hour / 2000-10-03
file: by_date/etf_1hour/2000/2000-10-03.parquet size: 9 KB rows: 180
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:00: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 | 144.1875 | 837800.0 |
| 2000-10-03 11:00:00 | SPY | ETF | 144.125 | 145.2188 | 143.7812 | 144.9375 | 888100.0 |
| 2000-10-03 12:00:00 | SPY | ETF | 144.9688 | 145.375 | 144.8438 | 145.1875 | 367100.0 |
| 2000-10-03 13:00:00 | SPY | ETF | 145.2188 | 145.6875 | 145.0312 | 145.5625 | 1378500.0 |
| 2000-10-03 14:00:00 | SPY | ETF | 145.6562 | 145.75 | 144.75 | 144.7812 | 1937600.0 |
| 2000-10-03 15:00:00 | SPY | ETF | 144.8438 | 144.8438 | 142.5312 | 142.625 | 2096600.0 |
| 2000-10-03 16:00:00 | SPY | ETF | 142.5625 | 142.75 | 142.2812 | 142.2812 | 1414700.0 |
| 2000-10-03 09:00: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 | 6037600.0 |
| 2000-10-03 11:00:00 | QQQ | ETF | 86.5 | 87.7188 | 85.875 | 87.5312 | 4037400.0 |
| 2000-10-03 12:00:00 | QQQ | ETF | 87.5 | 87.6875 | 86.8125 | 87.0312 | 2813400.0 |
| 2000-10-03 13:00:00 | QQQ | ETF | 87.0312 | 87.9688 | 86.75 | 87.8438 | 2822600.0 |
| 2000-10-03 14:00:00 | QQQ | ETF | 87.9062 | 88.5 | 86.2188 | 86.375 | 6396100.0 |
| 2000-10-03 15:00:00 | QQQ | ETF | 86.375 | 86.5312 | 83.5 | 83.625 | 8646000.0 |
| 2000-10-03 16:00:00 | QQQ | ETF | 83.5 | 84.0 | 83.25 | 83.75 | 885300.0 |
| 2000-10-03 17:00:00 | QQQ | ETF | 83.625 | 84.0 | 83.5 | 83.8125 | 18900.0 |
| 2000-10-03 18:00:00 | QQQ | ETF | 83.6875 | 87.75 | 83.5 | 84.0 | 11300.0 |
| 2000-10-03 09:00: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 | 50.9062 | 51.0 | 16800.0 |
| 2000-10-03 11:00:00 | IWM | ETF | 50.875 | 51.0469 | 50.6562 | 51.0469 | 23200.0 |
| 2000-10-03 12:00:00 | IWM | ETF | 50.9375 | 51.1406 | 50.9375 | 51.0625 | 6600.0 |
| 2000-10-03 13:00:00 | IWM | ETF | 51.0 | 51.0938 | 50.9375 | 51.0938 | 31400.0 |
| 2000-10-03 14:00:00 | IWM | ETF | 51.25 | 51.25 | 50.9688 | 50.9688 | 21000.0 |
| 2000-10-03 15:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.4688 | 50.5 | 50200.0 |
| 2000-10-03 16:00:00 | IWM | ETF | 50.2188 | 50.2188 | 50.2188 | 50.2188 | 1000.0 |
| 2000-10-03 09:00:00 | DIA | ETF | 107.4062 | 107.75 | 107.4062 | 107.6875 | 107100.0 |
| 2000-10-03 10:00:00 | DIA | ETF | 107.625 | 107.7188 | 107.2812 | 107.5 | 113700.0 |
| 2000-10-03 11:00:00 | DIA | ETF | 107.5625 | 108.4375 | 107.375 | 108.3438 | 488300.0 |
| 2000-10-03 12:00:00 | DIA | ETF | 108.2812 | 108.5625 | 108.0625 | 108.5312 | 120900.0 |
| 2000-10-03 13:00:00 | DIA | ETF | 108.5625 | 108.7812 | 108.3438 | 108.4375 | 161900.0 |
| 2000-10-03 14:00:00 | DIA | ETF | 108.4375 | 108.625 | 108.125 | 108.3125 | 246100.0 |
| 2000-10-03 15:00:00 | DIA | ETF | 108.25 | 108.3125 | 107.0625 | 107.25 | 983900.0 |
| 2000-10-03 16:00:00 | DIA | ETF | 107.0938 | 107.1875 | 107.0 | 107.0312 | 19500.0 |
> showing 34 of 180 rows — these rows as CSV