PREVIEW / etf_1hour / 2000-06-07
file: by_date/etf_1hour/2000/2000-06-07.parquet size: 9 KB rows: 151
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-06-07 09:00:00 | SPY | ETF | 146.625 | 146.9375 | 146.3438 | 146.6875 | 587500.0 |
| 2000-06-07 10:00:00 | SPY | ETF | 146.625 | 146.875 | 146.0 | 146.3125 | 644500.0 |
| 2000-06-07 11:00:00 | SPY | ETF | 146.3438 | 147.25 | 146.3125 | 146.875 | 984700.0 |
| 2000-06-07 12:00:00 | SPY | ETF | 146.9688 | 147.2188 | 146.625 | 146.7188 | 199200.0 |
| 2000-06-07 13:00:00 | SPY | ETF | 146.875 | 147.0938 | 146.5312 | 146.9688 | 155100.0 |
| 2000-06-07 14:00:00 | SPY | ETF | 147.0625 | 148.0 | 146.9688 | 147.75 | 741200.0 |
| 2000-06-07 15:00:00 | SPY | ETF | 147.6875 | 148.0 | 147.1875 | 147.5625 | 1057000.0 |
| 2000-06-07 16:00:00 | SPY | ETF | 147.6875 | 147.6875 | 147.1875 | 147.4688 | 525200.0 |
| 2000-06-07 09:00:00 | QQQ | ETF | 91.5625 | 92.25 | 90.375 | 91.5 | 3535900.0 |
| 2000-06-07 10:00:00 | QQQ | ETF | 91.5 | 91.875 | 89.5625 | 90.125 | 4260900.0 |
| 2000-06-07 11:00:00 | QQQ | ETF | 90.375 | 91.75 | 90.1562 | 91.375 | 2310100.0 |
| 2000-06-07 12:00:00 | QQQ | ETF | 91.3125 | 91.625 | 90.625 | 91.3125 | 1357900.0 |
| 2000-06-07 13:00:00 | QQQ | ETF | 91.25 | 91.625 | 90.6875 | 91.1875 | 1417900.0 |
| 2000-06-07 14:00:00 | QQQ | ETF | 91.2188 | 92.9688 | 91.0312 | 92.4375 | 4407400.0 |
| 2000-06-07 15:00:00 | QQQ | ETF | 92.375 | 93.125 | 91.4688 | 92.9375 | 4550400.0 |
| 2000-06-07 16:00:00 | QQQ | ETF | 93.0312 | 93.4375 | 92.875 | 93.4375 | 552200.0 |
| 2000-06-07 17:00:00 | QQQ | ETF | 93.4375 | 94.0 | 93.3125 | 93.3125 | 2500.0 |
| 2000-06-07 18:00:00 | QQQ | ETF | 93.4375 | 93.75 | 93.4375 | 93.6875 | 1100.0 |
| 2000-06-07 09:00:00 | IWM | ETF | 51.1875 | 51.3906 | 51.1875 | 51.375 | 2800.0 |
| 2000-06-07 10:00:00 | IWM | ETF | 51.125 | 51.125 | 50.7188 | 50.875 | 2800.0 |
| 2000-06-07 11:00:00 | IWM | ETF | 51.125 | 51.125 | 51.0625 | 51.0625 | 2400.0 |
| 2000-06-07 12:00:00 | IWM | ETF | 50.9844 | 51.125 | 50.9375 | 51.0312 | 107000.0 |
| 2000-06-07 13:00:00 | IWM | ETF | 51.0312 | 51.0938 | 51.0312 | 51.0938 | 4400.0 |
| 2000-06-07 14:00:00 | IWM | ETF | 51.0312 | 51.3125 | 51.0312 | 51.3125 | 4400.0 |
| 2000-06-07 15:00:00 | IWM | ETF | 51.25 | 51.5625 | 51.1094 | 51.5625 | 7200.0 |
| 2000-06-07 09:00:00 | DIA | ETF | 107.375 | 107.75 | 107.375 | 107.4375 | 80800.0 |
| 2000-06-07 10:00:00 | DIA | ETF | 107.5938 | 107.5938 | 107.0312 | 107.0312 | 35900.0 |
| 2000-06-07 11:00:00 | DIA | ETF | 107.3438 | 107.7188 | 107.2188 | 107.625 | 58600.0 |
| 2000-06-07 12:00:00 | DIA | ETF | 107.5 | 107.6875 | 107.375 | 107.4375 | 14000.0 |
| 2000-06-07 13:00:00 | DIA | ETF | 107.4375 | 107.75 | 107.25 | 107.625 | 119700.0 |
| 2000-06-07 14:00:00 | DIA | ETF | 107.625 | 108.625 | 107.5625 | 108.4375 | 290900.0 |
| 2000-06-07 15:00:00 | DIA | ETF | 108.4375 | 108.6875 | 108.0625 | 108.4062 | 270800.0 |
| 2000-06-07 16:00:00 | DIA | ETF | 108.3125 | 108.375 | 108.1875 | 108.3438 | 24600.0 |
> showing 33 of 151 rows — these rows as CSV