PREVIEW / etf_1hour / 2000-11-14
file: by_date/etf_1hour/2000/2000-11-14.parquet size: 10 KB rows: 184
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-11-14 09:00:00 | SPY | ETF | 137.4688 | 137.9375 | 137.0 | 137.0625 | 1390000.0 |
| 2000-11-14 10:00:00 | SPY | ETF | 137.125 | 138.2188 | 137.0312 | 138.0625 | 1025900.0 |
| 2000-11-14 11:00:00 | SPY | ETF | 138.0 | 138.25 | 137.4062 | 137.8438 | 679700.0 |
| 2000-11-14 12:00:00 | SPY | ETF | 137.9375 | 139.625 | 137.6875 | 138.625 | 985500.0 |
| 2000-11-14 13:00:00 | SPY | ETF | 138.625 | 139.0938 | 138.5 | 139.0 | 898300.0 |
| 2000-11-14 14:00:00 | SPY | ETF | 139.0 | 139.5 | 138.625 | 138.75 | 1127800.0 |
| 2000-11-14 15:00:00 | SPY | ETF | 138.8438 | 139.3125 | 138.1562 | 138.75 | 1018000.0 |
| 2000-11-14 16:00:00 | SPY | ETF | 138.8438 | 139.125 | 138.5938 | 139.125 | 287500.0 |
| 2000-11-14 09:00:00 | QQQ | ETF | 73.0 | 74.1562 | 72.75 | 73.1875 | 9180300.0 |
| 2000-11-14 10:00:00 | QQQ | ETF | 73.0 | 74.75 | 72.9375 | 74.375 | 7877200.0 |
| 2000-11-14 11:00:00 | QQQ | ETF | 74.4688 | 74.75 | 73.5 | 73.8438 | 4933800.0 |
| 2000-11-14 12:00:00 | QQQ | ETF | 73.8438 | 75.625 | 73.75 | 74.6875 | 5608000.0 |
| 2000-11-14 13:00:00 | QQQ | ETF | 74.6875 | 75.25 | 74.5938 | 75.1875 | 4082800.0 |
| 2000-11-14 14:00:00 | QQQ | ETF | 75.0312 | 75.9375 | 74.9688 | 75.25 | 4141200.0 |
| 2000-11-14 15:00:00 | QQQ | ETF | 75.25 | 76.0 | 74.8438 | 75.6875 | 5479300.0 |
| 2000-11-14 16:00:00 | QQQ | ETF | 75.625 | 77.125 | 75.375 | 76.0 | 852700.0 |
| 2000-11-14 17:00:00 | QQQ | ETF | 76.0 | 76.3125 | 75.75 | 76.0 | 42900.0 |
| 2000-11-14 18:00:00 | QQQ | ETF | 76.0 | 76.1875 | 74.5 | 76.0 | 9100.0 |
| 2000-11-14 09:00:00 | IWM | ETF | 48.4375 | 48.5312 | 48.4375 | 48.5312 | 66000.0 |
| 2000-11-14 10:00:00 | IWM | ETF | 48.5 | 48.5625 | 48.5 | 48.5625 | 13600.0 |
| 2000-11-14 11:00:00 | IWM | ETF | 48.4375 | 48.4375 | 48.375 | 48.375 | 2200.0 |
| 2000-11-14 12:00:00 | IWM | ETF | 48.5 | 48.6875 | 48.4688 | 48.4688 | 6600.0 |
| 2000-11-14 13:00:00 | IWM | ETF | 48.625 | 48.6875 | 48.625 | 48.6875 | 2200.0 |
| 2000-11-14 14:00:00 | IWM | ETF | 48.6875 | 48.75 | 48.6875 | 48.7344 | 13600.0 |
| 2000-11-14 15:00:00 | IWM | ETF | 48.5 | 48.6875 | 48.5 | 48.6875 | 23400.0 |
| 2000-11-14 16:00:00 | IWM | ETF | 48.8125 | 48.8125 | 48.6562 | 48.6562 | 1200.0 |
| 2000-11-14 09:00:00 | DIA | ETF | 106.125 | 106.7188 | 106.0938 | 106.1875 | 442500.0 |
| 2000-11-14 10:00:00 | DIA | ETF | 106.1562 | 106.8125 | 106.1562 | 106.5625 | 356800.0 |
| 2000-11-14 11:00:00 | DIA | ETF | 106.5625 | 106.7188 | 106.0 | 106.5 | 319200.0 |
| 2000-11-14 12:00:00 | DIA | ETF | 106.5938 | 107.9375 | 106.25 | 106.8438 | 203400.0 |
| 2000-11-14 13:00:00 | DIA | ETF | 107.0 | 107.3125 | 106.6875 | 107.25 | 217500.0 |
| 2000-11-14 14:00:00 | DIA | ETF | 107.2812 | 107.5 | 106.875 | 107.1875 | 64900.0 |
| 2000-11-14 15:00:00 | DIA | ETF | 107.0 | 107.4688 | 106.75 | 107.125 | 117300.0 |
| 2000-11-14 16:00:00 | DIA | ETF | 107.0312 | 107.3125 | 107.0 | 107.3125 | 59200.0 |
> showing 34 of 184 rows — these rows as CSV