PREVIEW / etf_1hour / 2000-09-21
file: by_date/etf_1hour/2000/2000-09-21.parquet size: 9 KB rows: 175
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-21 09:00:00 | SPY | ETF | 144.4688 | 145.125 | 144.25 | 144.625 | 1085000.0 |
| 2000-09-21 10:00:00 | SPY | ETF | 144.4688 | 145.0 | 144.0625 | 144.5312 | 829400.0 |
| 2000-09-21 11:00:00 | SPY | ETF | 144.625 | 144.6562 | 143.75 | 144.0938 | 671900.0 |
| 2000-09-21 12:00:00 | SPY | ETF | 144.0625 | 144.8125 | 144.0625 | 144.5 | 354500.0 |
| 2000-09-21 13:00:00 | SPY | ETF | 144.5625 | 145.1875 | 144.4375 | 144.625 | 368200.0 |
| 2000-09-21 14:00:00 | SPY | ETF | 144.8438 | 144.8438 | 143.875 | 144.25 | 622900.0 |
| 2000-09-21 15:00:00 | SPY | ETF | 144.3438 | 145.5625 | 143.9062 | 145.0312 | 812200.0 |
| 2000-09-21 16:00:00 | SPY | ETF | 145.0 | 145.1875 | 143.0 | 143.0 | 1130900.0 |
| 2000-09-21 17:00:00 | SPY | ETF | 143.0 | 143.0 | 142.75 | 142.75 | 1000.0 |
| 2000-09-21 18:00:00 | SPY | ETF | 142.625 | 142.6875 | 142.625 | 142.6875 | 700.0 |
| 2000-09-21 09:00:00 | QQQ | ETF | 93.75 | 94.4688 | 93.25 | 93.7188 | 3503600.0 |
| 2000-09-21 10:00:00 | QQQ | ETF | 93.6875 | 93.9375 | 93.0 | 93.2812 | 3874000.0 |
| 2000-09-21 11:00:00 | QQQ | ETF | 93.4375 | 93.4688 | 92.125 | 92.875 | 5131200.0 |
| 2000-09-21 12:00:00 | QQQ | ETF | 92.875 | 93.6875 | 92.875 | 93.0 | 2366500.0 |
| 2000-09-21 13:00:00 | QQQ | ETF | 93.0 | 93.6875 | 92.8125 | 93.25 | 2056900.0 |
| 2000-09-21 14:00:00 | QQQ | ETF | 93.25 | 93.3438 | 92.1562 | 92.6875 | 3064400.0 |
| 2000-09-21 15:00:00 | QQQ | ETF | 92.6562 | 93.5938 | 92.0625 | 92.625 | 3672600.0 |
| 2000-09-21 16:00:00 | QQQ | ETF | 92.75 | 92.875 | 88.0 | 88.375 | 1015600.0 |
| 2000-09-21 17:00:00 | QQQ | ETF | 88.375 | 89.25 | 87.0 | 87.875 | 140100.0 |
| 2000-09-21 18:00:00 | QQQ | ETF | 87.9375 | 88.0625 | 87.5 | 87.75 | 39300.0 |
| 2000-09-21 09:00:00 | IWM | ETF | 52.0 | 52.0 | 51.8125 | 51.8125 | 22800.0 |
| 2000-09-21 10:00:00 | IWM | ETF | 52.0 | 52.0 | 51.7344 | 51.9219 | 2000.0 |
| 2000-09-21 11:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.6875 | 51.6875 | 3000.0 |
| 2000-09-21 12:00:00 | IWM | ETF | 51.6562 | 51.7188 | 51.625 | 51.625 | 4800.0 |
| 2000-09-21 13:00:00 | IWM | ETF | 51.5938 | 51.625 | 51.5938 | 51.625 | 1000.0 |
| 2000-09-21 14:00:00 | IWM | ETF | 51.6406 | 51.6406 | 51.4375 | 51.5625 | 66800.0 |
| 2000-09-21 15:00:00 | IWM | ETF | 51.4219 | 51.5 | 51.3125 | 51.3125 | 103800.0 |
| 2000-09-21 16:00:00 | IWM | ETF | 51.125 | 51.1562 | 50.9375 | 50.9375 | 3200.0 |
| 2000-09-21 09:00:00 | DIA | ETF | 106.5625 | 107.625 | 106.5625 | 107.125 | 311800.0 |
| 2000-09-21 10:00:00 | DIA | ETF | 107.1562 | 107.5312 | 106.9062 | 107.375 | 438300.0 |
| 2000-09-21 11:00:00 | DIA | ETF | 107.25 | 107.2812 | 106.5625 | 106.875 | 316600.0 |
| 2000-09-21 12:00:00 | DIA | ETF | 107.0312 | 107.375 | 106.875 | 107.25 | 251500.0 |
| 2000-09-21 13:00:00 | DIA | ETF | 107.1875 | 107.75 | 107.125 | 107.4375 | 133700.0 |
| 2000-09-21 14:00:00 | DIA | ETF | 107.5 | 107.5 | 106.9375 | 107.3125 | 260300.0 |
| 2000-09-21 15:00:00 | DIA | ETF | 107.375 | 108.0 | 107.0938 | 107.75 | 207100.0 |
| 2000-09-21 16:00:00 | DIA | ETF | 107.75 | 107.75 | 106.25 | 106.25 | 24100.0 |
| 2000-09-21 17:00:00 | DIA | ETF | 106.25 | 106.25 | 106.25 | 106.25 | 100.0 |
> showing 37 of 175 rows — these rows as CSV