PREVIEW / etf_1hour / 2000-07-27
file: by_date/etf_1hour/2000/2000-07-27.parquet size: 9 KB rows: 149
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-07-27 09:00:00 | SPY | ETF | 145.9375 | 146.625 | 145.625 | 146.3438 | 2023300.0 |
| 2000-07-27 10:00:00 | SPY | ETF | 146.2188 | 146.2812 | 144.6875 | 145.2812 | 1468000.0 |
| 2000-07-27 11:00:00 | SPY | ETF | 145.4375 | 145.625 | 145.0625 | 145.1562 | 375800.0 |
| 2000-07-27 12:00:00 | SPY | ETF | 145.125 | 145.6562 | 145.0 | 145.4375 | 380400.0 |
| 2000-07-27 13:00:00 | SPY | ETF | 145.4062 | 145.7812 | 145.0625 | 145.1875 | 378300.0 |
| 2000-07-27 14:00:00 | SPY | ETF | 145.125 | 145.7188 | 144.8125 | 145.625 | 568400.0 |
| 2000-07-27 15:00:00 | SPY | ETF | 145.75 | 146.375 | 145.2188 | 145.5 | 1605900.0 |
| 2000-07-27 16:00:00 | SPY | ETF | 145.2188 | 145.4375 | 145.125 | 145.375 | 594000.0 |
| 2000-07-27 09:00:00 | QQQ | ETF | 93.9375 | 95.0625 | 93.5625 | 94.125 | 3873200.0 |
| 2000-07-27 10:00:00 | QQQ | ETF | 94.125 | 94.375 | 92.0 | 92.8438 | 5505900.0 |
| 2000-07-27 11:00:00 | QQQ | ETF | 92.875 | 93.375 | 92.5 | 92.6875 | 2004400.0 |
| 2000-07-27 12:00:00 | QQQ | ETF | 92.8438 | 93.4375 | 92.1875 | 93.0938 | 3428900.0 |
| 2000-07-27 13:00:00 | QQQ | ETF | 93.0625 | 93.1875 | 92.375 | 92.375 | 1555400.0 |
| 2000-07-27 14:00:00 | QQQ | ETF | 92.4062 | 92.75 | 91.625 | 92.6875 | 2797100.0 |
| 2000-07-27 15:00:00 | QQQ | ETF | 92.625 | 93.875 | 91.875 | 91.9688 | 5609700.0 |
| 2000-07-27 16:00:00 | QQQ | ETF | 91.875 | 92.375 | 91.5625 | 91.75 | 1267800.0 |
| 2000-07-27 17:00:00 | QQQ | ETF | 91.75 | 91.875 | 91.625 | 91.875 | 7500.0 |
| 2000-07-27 18:00:00 | QQQ | ETF | 91.875 | 91.875 | 91.875 | 91.875 | 600.0 |
| 2000-07-27 09:00:00 | IWM | ETF | 51.1719 | 51.1719 | 50.8906 | 50.8906 | 20400.0 |
| 2000-07-27 10:00:00 | IWM | ETF | 50.9375 | 50.9375 | 50.3438 | 50.3438 | 65800.0 |
| 2000-07-27 11:00:00 | IWM | ETF | 50.4375 | 50.4531 | 50.3125 | 50.3125 | 4200.0 |
| 2000-07-27 12:00:00 | IWM | ETF | 50.4375 | 50.4375 | 50.3125 | 50.3125 | 1400.0 |
| 2000-07-27 13:00:00 | IWM | ETF | 50.3594 | 50.3906 | 50.3438 | 50.3906 | 34200.0 |
| 2000-07-27 14:00:00 | IWM | ETF | 50.3125 | 50.3125 | 50.2656 | 50.3125 | 5600.0 |
| 2000-07-27 15:00:00 | IWM | ETF | 50.3281 | 50.5625 | 50.0 | 50.0 | 130600.0 |
| 2000-07-27 16:00:00 | IWM | ETF | 49.9062 | 50.0 | 49.875 | 49.875 | 12800.0 |
| 2000-07-27 09:00:00 | DIA | ETF | 105.5625 | 106.4688 | 105.5625 | 106.0938 | 97500.0 |
| 2000-07-27 10:00:00 | DIA | ETF | 105.9688 | 106.125 | 105.1562 | 105.6875 | 262900.0 |
| 2000-07-27 11:00:00 | DIA | ETF | 105.7812 | 105.7812 | 105.3125 | 105.5 | 190700.0 |
| 2000-07-27 12:00:00 | DIA | ETF | 105.625 | 105.8125 | 105.4062 | 105.6875 | 47400.0 |
| 2000-07-27 13:00:00 | DIA | ETF | 105.6875 | 106.0 | 105.5625 | 105.7188 | 21100.0 |
| 2000-07-27 14:00:00 | DIA | ETF | 105.7188 | 106.1875 | 105.5 | 106.1562 | 65000.0 |
| 2000-07-27 15:00:00 | DIA | ETF | 106.1875 | 106.4375 | 105.8438 | 105.8438 | 78300.0 |
| 2000-07-27 16:00:00 | DIA | ETF | 105.75 | 106.0625 | 105.6875 | 106.0312 | 41500.0 |
> showing 34 of 149 rows — these rows as CSV