PREVIEW / etf_1hour / 2001-12-26
file: by_date/etf_1hour/2001/2001-12-26.parquet size: 13 KB rows: 269
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-26 09:00:00 | SPY | ETF | 114.65 | 115.64 | 114.65 | 115.6 | 1480400.0 |
| 2001-12-26 10:00:00 | SPY | ETF | 115.65 | 116.21 | 115.6 | 115.97 | 1677600.0 |
| 2001-12-26 11:00:00 | SPY | ETF | 115.95 | 116.15 | 115.89 | 116.05 | 657000.0 |
| 2001-12-26 12:00:00 | SPY | ETF | 116.05 | 116.1 | 115.93 | 116.02 | 504100.0 |
| 2001-12-26 13:00:00 | SPY | ETF | 115.99 | 116.02 | 115.74 | 115.86 | 1488700.0 |
| 2001-12-26 14:00:00 | SPY | ETF | 115.83 | 116.07 | 115.83 | 116.0 | 638000.0 |
| 2001-12-26 15:00:00 | SPY | ETF | 116.03 | 116.03 | 115.19 | 115.25 | 2302500.0 |
| 2001-12-26 16:00:00 | SPY | ETF | 115.31 | 115.6 | 115.22 | 115.6 | 1307200.0 |
| 2001-12-26 17:00:00 | SPY | ETF | 115.54 | 115.54 | 115.54 | 115.54 | 3500.0 |
| 2001-12-26 09:00:00 | QQQ | ETF | 39.37 | 40.09 | 39.37 | 40.04 | 7376400.0 |
| 2001-12-26 10:00:00 | QQQ | ETF | 40.05 | 40.27 | 39.98 | 40.1 | 6907300.0 |
| 2001-12-26 11:00:00 | QQQ | ETF | 40.1 | 40.3 | 40.06 | 40.22 | 5696400.0 |
| 2001-12-26 12:00:00 | QQQ | ETF | 40.28 | 40.28 | 40.11 | 40.18 | 1495200.0 |
| 2001-12-26 13:00:00 | QQQ | ETF | 40.15 | 40.18 | 39.97 | 40.04 | 2442700.0 |
| 2001-12-26 14:00:00 | QQQ | ETF | 40.05 | 40.14 | 39.97 | 40.05 | 3088600.0 |
| 2001-12-26 15:00:00 | QQQ | ETF | 40.06 | 40.13 | 39.5 | 39.65 | 8647000.0 |
| 2001-12-26 16:00:00 | QQQ | ETF | 39.66 | 39.75 | 39.62 | 39.72 | 792100.0 |
| 2001-12-26 17:00:00 | QQQ | ETF | 39.7 | 39.74 | 39.65 | 39.69 | 23700.0 |
| 2001-12-26 18:00:00 | QQQ | ETF | 39.71 | 39.71 | 39.71 | 39.71 | 400.0 |
| 2001-12-26 09:00:00 | IWM | ETF | 48.3 | 48.62 | 48.3 | 48.61 | 56200.0 |
| 2001-12-26 10:00:00 | IWM | ETF | 48.615 | 48.87 | 48.615 | 48.795 | 91400.0 |
| 2001-12-26 11:00:00 | IWM | ETF | 48.775 | 48.785 | 48.61 | 48.7 | 95800.0 |
| 2001-12-26 12:00:00 | IWM | ETF | 48.7 | 48.745 | 48.61 | 48.71 | 12400.0 |
| 2001-12-26 13:00:00 | IWM | ETF | 48.715 | 48.735 | 48.6 | 48.705 | 177000.0 |
| 2001-12-26 14:00:00 | IWM | ETF | 48.705 | 48.705 | 48.605 | 48.605 | 77400.0 |
| 2001-12-26 15:00:00 | IWM | ETF | 48.66 | 48.74 | 48.5 | 48.74 | 252600.0 |
| 2001-12-26 16:00:00 | IWM | ETF | 48.75 | 48.75 | 48.71 | 48.71 | 200200.0 |
| 2001-12-26 09:00:00 | DIA | ETF | 100.49 | 101.07 | 100.46 | 101.04 | 119300.0 |
| 2001-12-26 10:00:00 | DIA | ETF | 101.09 | 101.71 | 101.09 | 101.58 | 232000.0 |
| 2001-12-26 11:00:00 | DIA | ETF | 101.61 | 101.7 | 101.46 | 101.7 | 168100.0 |
| 2001-12-26 12:00:00 | DIA | ETF | 101.7 | 101.74 | 101.55 | 101.66 | 340700.0 |
| 2001-12-26 13:00:00 | DIA | ETF | 101.61 | 101.7 | 101.42 | 101.57 | 220000.0 |
| 2001-12-26 14:00:00 | DIA | ETF | 101.63 | 101.8 | 101.56 | 101.7 | 110300.0 |
| 2001-12-26 15:00:00 | DIA | ETF | 101.66 | 101.72 | 100.93 | 101.01 | 250400.0 |
| 2001-12-26 16:00:00 | DIA | ETF | 101.0 | 101.15 | 101.0 | 101.15 | 8600.0 |
> showing 35 of 269 rows — these rows as CSV