PREVIEW / etf_1hour / 2000-02-03
file: by_date/etf_1hour/2000/2000-02-03.parquet size: 8 KB rows: 135
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-02-03 09:00:00 | SPY | ETF | 140.875 | 142.4062 | 140.875 | 142.0 | 791300.0 |
| 2000-02-03 10:00:00 | SPY | ETF | 142.0625 | 142.125 | 141.25 | 142.0625 | 641100.0 |
| 2000-02-03 11:00:00 | SPY | ETF | 142.125 | 142.2812 | 141.0625 | 141.0938 | 650800.0 |
| 2000-02-03 12:00:00 | SPY | ETF | 141.0625 | 141.5938 | 140.0 | 141.5625 | 2409000.0 |
| 2000-02-03 13:00:00 | SPY | ETF | 141.5625 | 142.125 | 141.3438 | 141.9688 | 752700.0 |
| 2000-02-03 14:00:00 | SPY | ETF | 141.8125 | 142.9688 | 141.4375 | 142.7188 | 895000.0 |
| 2000-02-03 15:00:00 | SPY | ETF | 142.7188 | 142.875 | 141.75 | 142.8438 | 1146100.0 |
| 2000-02-03 16:00:00 | SPY | ETF | 142.6875 | 143.25 | 142.6875 | 143.1875 | 549100.0 |
| 2000-02-03 09:00:00 | QQQ | ETF | 94.3125 | 94.9375 | 94.0312 | 94.625 | 3117200.0 |
| 2000-02-03 10:00:00 | QQQ | ETF | 94.625 | 95.0 | 93.9219 | 94.9375 | 3808000.0 |
| 2000-02-03 11:00:00 | QQQ | ETF | 94.9375 | 95.3125 | 93.9375 | 94.0 | 3894400.0 |
| 2000-02-03 12:00:00 | QQQ | ETF | 93.9375 | 94.4375 | 92.2812 | 94.125 | 6551200.0 |
| 2000-02-03 13:00:00 | QQQ | ETF | 94.0469 | 94.8594 | 94.0312 | 94.7344 | 2902600.0 |
| 2000-02-03 14:00:00 | QQQ | ETF | 94.7188 | 96.125 | 94.3125 | 95.7656 | 4207400.0 |
| 2000-02-03 15:00:00 | QQQ | ETF | 95.7656 | 96.4375 | 95.2812 | 96.125 | 4827200.0 |
| 2000-02-03 16:00:00 | QQQ | ETF | 96.125 | 96.5938 | 96.0156 | 96.125 | 948600.0 |
| 2000-02-03 17:00:00 | QQQ | ETF | 96.375 | 96.375 | 96.375 | 96.375 | 200.0 |
| 2000-02-03 18:00:00 | QQQ | ETF | 96.5 | 96.5 | 96.5 | 96.5 | 1000.0 |
| 2000-02-03 09:00:00 | DIA | ETF | 110.625 | 110.6562 | 110.0312 | 110.2188 | 155100.0 |
| 2000-02-03 10:00:00 | DIA | ETF | 110.4062 | 110.4062 | 109.6562 | 110.0938 | 146300.0 |
| 2000-02-03 11:00:00 | DIA | ETF | 110.125 | 110.2812 | 109.1562 | 109.4062 | 113200.0 |
| 2000-02-03 12:00:00 | DIA | ETF | 109.125 | 109.5 | 108.2188 | 109.3125 | 107400.0 |
| 2000-02-03 13:00:00 | DIA | ETF | 109.4688 | 110.0312 | 109.25 | 109.7188 | 54200.0 |
| 2000-02-03 14:00:00 | DIA | ETF | 109.75 | 110.5938 | 109.5 | 110.2188 | 136900.0 |
| 2000-02-03 15:00:00 | DIA | ETF | 110.125 | 110.5312 | 109.5312 | 110.0312 | 141800.0 |
| 2000-02-03 16:00:00 | DIA | ETF | 110.1875 | 110.5 | 110.1875 | 110.5 | 7200.0 |
> showing 26 of 135 rows — these rows as CSV