PREVIEW / etf_1hour / 2000-08-21
file: by_date/etf_1hour/2000/2000-08-21.parquet size: 9 KB rows: 177
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-21 09:00:00 | SPY | ETF | 150.0312 | 150.25 | 149.875 | 150.125 | 308600.0 |
| 2000-08-21 10:00:00 | SPY | ETF | 150.125 | 150.6875 | 150.0 | 150.4688 | 199200.0 |
| 2000-08-21 11:00:00 | SPY | ETF | 150.5625 | 150.7188 | 150.375 | 150.5 | 252500.0 |
| 2000-08-21 12:00:00 | SPY | ETF | 150.375 | 150.5625 | 150.1875 | 150.25 | 114300.0 |
| 2000-08-21 13:00:00 | SPY | ETF | 150.3438 | 150.3438 | 149.7812 | 149.875 | 215400.0 |
| 2000-08-21 14:00:00 | SPY | ETF | 149.7812 | 150.0938 | 149.4062 | 149.5625 | 394900.0 |
| 2000-08-21 15:00:00 | SPY | ETF | 149.625 | 150.4375 | 149.4375 | 150.3438 | 527300.0 |
| 2000-08-21 16:00:00 | SPY | ETF | 150.375 | 150.5625 | 150.25 | 150.5625 | 322000.0 |
| 2000-08-21 17:00:00 | SPY | ETF | 150.5 | 150.5 | 150.5 | 150.5 | 400.0 |
| 2000-08-21 09:00:00 | QQQ | ETF | 96.0 | 96.0938 | 95.25 | 95.875 | 1516100.0 |
| 2000-08-21 10:00:00 | QQQ | ETF | 95.9375 | 96.6875 | 95.7812 | 96.4062 | 2375500.0 |
| 2000-08-21 11:00:00 | QQQ | ETF | 96.5 | 96.6875 | 96.3125 | 96.4062 | 1225500.0 |
| 2000-08-21 12:00:00 | QQQ | ETF | 96.5 | 96.8438 | 96.0312 | 96.125 | 932300.0 |
| 2000-08-21 13:00:00 | QQQ | ETF | 96.125 | 96.1875 | 94.7812 | 95.0 | 2056200.0 |
| 2000-08-21 14:00:00 | QQQ | ETF | 94.875 | 95.4375 | 94.375 | 94.625 | 2056000.0 |
| 2000-08-21 15:00:00 | QQQ | ETF | 94.5625 | 95.5625 | 94.375 | 95.5 | 2820200.0 |
| 2000-08-21 16:00:00 | QQQ | ETF | 95.5312 | 95.75 | 95.0625 | 95.5 | 550300.0 |
| 2000-08-21 17:00:00 | QQQ | ETF | 95.875 | 95.875 | 95.5 | 95.5 | 2800.0 |
| 2000-08-21 18:00:00 | QQQ | ETF | 95.5 | 95.5 | 95.5 | 95.5 | 5000.0 |
| 2000-08-21 09:00:00 | IWM | ETF | 51.875 | 51.875 | 51.875 | 51.875 | 2800.0 |
| 2000-08-21 10:00:00 | IWM | ETF | 51.8438 | 51.9219 | 51.8438 | 51.9219 | 2800.0 |
| 2000-08-21 11:00:00 | IWM | ETF | 51.875 | 51.8906 | 51.875 | 51.8906 | 5600.0 |
| 2000-08-21 12:00:00 | IWM | ETF | 51.9062 | 51.9062 | 51.9062 | 51.9062 | 37800.0 |
| 2000-08-21 13:00:00 | IWM | ETF | 51.8906 | 51.8906 | 51.6094 | 51.6094 | 3400.0 |
| 2000-08-21 14:00:00 | IWM | ETF | 51.625 | 51.8125 | 51.4062 | 51.5312 | 24200.0 |
| 2000-08-21 15:00:00 | IWM | ETF | 51.5938 | 51.7344 | 51.5 | 51.7344 | 52600.0 |
| 2000-08-21 09:00:00 | DIA | ETF | 110.9375 | 111.0625 | 110.6562 | 110.7812 | 215600.0 |
| 2000-08-21 10:00:00 | DIA | ETF | 110.9375 | 111.0312 | 110.6875 | 110.875 | 137700.0 |
| 2000-08-21 11:00:00 | DIA | ETF | 111.0312 | 111.125 | 110.8125 | 110.9062 | 70800.0 |
| 2000-08-21 12:00:00 | DIA | ETF | 110.9062 | 111.0 | 110.7812 | 110.9375 | 46500.0 |
| 2000-08-21 13:00:00 | DIA | ETF | 110.75 | 110.875 | 110.6875 | 110.75 | 169800.0 |
| 2000-08-21 14:00:00 | DIA | ETF | 110.75 | 110.8438 | 110.3125 | 110.4062 | 33800.0 |
| 2000-08-21 15:00:00 | DIA | ETF | 110.4375 | 110.9688 | 110.2188 | 110.9688 | 53200.0 |
| 2000-08-21 16:00:00 | DIA | ETF | 110.875 | 111.0 | 110.7812 | 110.9062 | 27300.0 |
| 2000-08-21 17:00:00 | DIA | ETF | 111.0 | 111.0 | 111.0 | 111.0 | 200.0 |
| 2000-08-21 18:00:00 | DIA | ETF | 111.125 | 111.125 | 111.125 | 111.125 | 200.0 |
> showing 36 of 177 rows — these rows as CSV