PREVIEW / etf_1hour / 2000-08-10
file: by_date/etf_1hour/2000/2000-08-10.parquet size: 9 KB rows: 165
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-08-10 09:00:00 | SPY | ETF | 147.5312 | 147.8438 | 147.4062 | 147.6875 | 536700.0 |
| 2000-08-10 10:00:00 | SPY | ETF | 147.6875 | 147.6875 | 147.0 | 147.625 | 725000.0 |
| 2000-08-10 11:00:00 | SPY | ETF | 147.5625 | 147.5938 | 147.0625 | 147.125 | 249300.0 |
| 2000-08-10 12:00:00 | SPY | ETF | 147.1875 | 147.2188 | 146.75 | 146.9688 | 402300.0 |
| 2000-08-10 13:00:00 | SPY | ETF | 146.9688 | 147.125 | 146.8125 | 146.9688 | 352400.0 |
| 2000-08-10 14:00:00 | SPY | ETF | 146.8125 | 146.9375 | 146.5 | 146.625 | 524500.0 |
| 2000-08-10 15:00:00 | SPY | ETF | 146.625 | 146.8125 | 146.2812 | 146.5625 | 1096700.0 |
| 2000-08-10 16:00:00 | SPY | ETF | 146.4375 | 146.8125 | 146.4062 | 146.7188 | 205600.0 |
| 2000-08-10 17:00:00 | SPY | ETF | 146.7188 | 146.7188 | 146.7188 | 146.7188 | 600.0 |
| 2000-08-10 09:00:00 | QQQ | ETF | 91.8125 | 92.2188 | 91.0625 | 91.8438 | 2406900.0 |
| 2000-08-10 10:00:00 | QQQ | ETF | 91.9062 | 91.9688 | 91.125 | 91.875 | 2072500.0 |
| 2000-08-10 11:00:00 | QQQ | ETF | 91.8125 | 91.875 | 90.8125 | 90.875 | 1668900.0 |
| 2000-08-10 12:00:00 | QQQ | ETF | 90.875 | 91.125 | 90.25 | 90.6875 | 1973300.0 |
| 2000-08-10 13:00:00 | QQQ | ETF | 90.8125 | 91.0938 | 90.5 | 90.6875 | 899200.0 |
| 2000-08-10 14:00:00 | QQQ | ETF | 90.6875 | 90.6875 | 90.0 | 90.1875 | 2471300.0 |
| 2000-08-10 15:00:00 | QQQ | ETF | 90.3125 | 90.5938 | 89.6875 | 89.75 | 3469200.0 |
| 2000-08-10 16:00:00 | QQQ | ETF | 89.75 | 90.0625 | 89.6875 | 89.75 | 344000.0 |
| 2000-08-10 17:00:00 | QQQ | ETF | 89.75 | 89.8125 | 89.75 | 89.75 | 2300.0 |
| 2000-08-10 18:00:00 | QQQ | ETF | 89.75 | 90.0 | 89.75 | 89.8125 | 2500.0 |
| 2000-08-10 09:00:00 | IWM | ETF | 50.5469 | 50.5938 | 50.5469 | 50.5781 | 1800.0 |
| 2000-08-10 10:00:00 | IWM | ETF | 50.375 | 50.375 | 50.3281 | 50.3438 | 10600.0 |
| 2000-08-10 11:00:00 | IWM | ETF | 50.3125 | 50.3125 | 50.3125 | 50.3125 | 5200.0 |
| 2000-08-10 12:00:00 | IWM | ETF | 50.2812 | 50.3125 | 50.1406 | 50.3125 | 1200.0 |
| 2000-08-10 13:00:00 | IWM | ETF | 50.3125 | 50.4688 | 50.3125 | 50.4688 | 12800.0 |
| 2000-08-10 14:00:00 | IWM | ETF | 50.3438 | 50.3438 | 50.1406 | 50.1406 | 2800.0 |
| 2000-08-10 15:00:00 | IWM | ETF | 50.0938 | 50.25 | 50.0938 | 50.25 | 8600.0 |
| 2000-08-10 09:00:00 | DIA | ETF | 109.0312 | 109.4688 | 109.0312 | 109.3125 | 40000.0 |
| 2000-08-10 10:00:00 | DIA | ETF | 109.2188 | 109.3438 | 108.8438 | 109.3125 | 93500.0 |
| 2000-08-10 11:00:00 | DIA | ETF | 109.25 | 109.4375 | 109.125 | 109.1875 | 63900.0 |
| 2000-08-10 12:00:00 | DIA | ETF | 109.125 | 109.375 | 109.0 | 109.2188 | 17400.0 |
| 2000-08-10 13:00:00 | DIA | ETF | 109.25 | 109.4375 | 109.1875 | 109.25 | 24600.0 |
| 2000-08-10 14:00:00 | DIA | ETF | 109.2812 | 109.5938 | 109.0312 | 109.4062 | 118900.0 |
| 2000-08-10 15:00:00 | DIA | ETF | 109.3438 | 109.4688 | 109.0938 | 109.1875 | 70400.0 |
| 2000-08-10 16:00:00 | DIA | ETF | 109.2188 | 109.25 | 109.1875 | 109.1875 | 1100.0 |
> showing 34 of 165 rows — these rows as CSV