PREVIEW / etf_1hour / 2000-09-11
file: by_date/etf_1hour/2000/2000-09-11.parquet size: 10 KB rows: 188
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-11 09:00:00 | SPY | ETF | 149.75 | 149.8438 | 149.4375 | 149.4375 | 420600.0 |
| 2000-09-11 10:00:00 | SPY | ETF | 149.4375 | 151.1562 | 149.3125 | 151.125 | 680700.0 |
| 2000-09-11 11:00:00 | SPY | ETF | 151.0 | 151.1875 | 150.5 | 150.6875 | 348100.0 |
| 2000-09-11 12:00:00 | SPY | ETF | 150.5625 | 150.5625 | 150.25 | 150.3438 | 369100.0 |
| 2000-09-11 13:00:00 | SPY | ETF | 150.3438 | 150.5 | 150.0625 | 150.4375 | 304100.0 |
| 2000-09-11 14:00:00 | SPY | ETF | 150.4375 | 150.4375 | 149.0 | 149.25 | 801300.0 |
| 2000-09-11 15:00:00 | SPY | ETF | 149.1875 | 149.5625 | 148.6875 | 149.4688 | 748800.0 |
| 2000-09-11 16:00:00 | SPY | ETF | 149.4688 | 149.6875 | 149.375 | 149.5938 | 242400.0 |
| 2000-09-11 09:00:00 | QQQ | ETF | 94.5 | 94.7812 | 93.2812 | 93.4375 | 4105400.0 |
| 2000-09-11 10:00:00 | QQQ | ETF | 93.625 | 95.9375 | 93.0938 | 95.875 | 8623800.0 |
| 2000-09-11 11:00:00 | QQQ | ETF | 95.7188 | 96.125 | 95.0 | 95.4062 | 2390300.0 |
| 2000-09-11 12:00:00 | QQQ | ETF | 95.2188 | 95.3125 | 94.375 | 94.875 | 1633600.0 |
| 2000-09-11 13:00:00 | QQQ | ETF | 94.875 | 94.9062 | 94.0625 | 94.5938 | 1209600.0 |
| 2000-09-11 14:00:00 | QQQ | ETF | 94.5 | 94.8125 | 92.625 | 93.0625 | 2800800.0 |
| 2000-09-11 15:00:00 | QQQ | ETF | 93.0938 | 93.125 | 92.0 | 92.625 | 5813500.0 |
| 2000-09-11 16:00:00 | QQQ | ETF | 92.625 | 93.125 | 92.5 | 93.0 | 507200.0 |
| 2000-09-11 17:00:00 | QQQ | ETF | 92.875 | 93.0 | 92.625 | 92.625 | 5100.0 |
| 2000-09-11 18:00:00 | QQQ | ETF | 92.7812 | 92.8125 | 92.7812 | 92.8125 | 3000.0 |
| 2000-09-11 09:00:00 | IWM | ETF | 53.7031 | 53.7031 | 53.5625 | 53.5625 | 800.0 |
| 2000-09-11 10:00:00 | IWM | ETF | 53.6562 | 53.9062 | 53.5312 | 53.8906 | 99800.0 |
| 2000-09-11 11:00:00 | IWM | ETF | 53.875 | 53.9062 | 53.6875 | 53.75 | 75600.0 |
| 2000-09-11 12:00:00 | IWM | ETF | 53.7188 | 53.8281 | 53.6875 | 53.75 | 43800.0 |
| 2000-09-11 13:00:00 | IWM | ETF | 53.7812 | 53.8438 | 53.5938 | 53.7812 | 43000.0 |
| 2000-09-11 14:00:00 | IWM | ETF | 53.5312 | 53.7188 | 53.3438 | 53.3438 | 10800.0 |
| 2000-09-11 15:00:00 | IWM | ETF | 53.375 | 53.5312 | 53.3125 | 53.4688 | 39800.0 |
| 2000-09-11 16:00:00 | IWM | ETF | 53.5 | 53.5 | 53.5 | 53.5 | 1000.0 |
| 2000-09-11 09:00:00 | DIA | ETF | 111.9688 | 112.5 | 111.9688 | 112.1875 | 148500.0 |
| 2000-09-11 10:00:00 | DIA | ETF | 112.1875 | 113.0 | 112.0625 | 112.8125 | 279900.0 |
| 2000-09-11 11:00:00 | DIA | ETF | 112.8125 | 112.9688 | 112.625 | 112.875 | 79700.0 |
| 2000-09-11 12:00:00 | DIA | ETF | 112.875 | 112.875 | 112.4375 | 112.5312 | 52700.0 |
| 2000-09-11 13:00:00 | DIA | ETF | 112.375 | 112.5312 | 112.1562 | 112.3125 | 12400.0 |
| 2000-09-11 14:00:00 | DIA | ETF | 112.2812 | 112.4375 | 111.4062 | 111.7188 | 89700.0 |
| 2000-09-11 15:00:00 | DIA | ETF | 111.625 | 112.0938 | 111.5 | 112.0625 | 68000.0 |
| 2000-09-11 16:00:00 | DIA | ETF | 111.9375 | 112.1562 | 111.9062 | 112.125 | 49700.0 |
> showing 34 of 188 rows — these rows as CSV