PREVIEW / etf_1hour / 2001-12-17
file: by_date/etf_1hour/2001/2001-12-17.parquet size: 13 KB rows: 279
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-17 09:00:00 | SPY | ETF | 112.99 | 113.36 | 112.9 | 113.21 | 2748000.0 |
| 2001-12-17 10:00:00 | SPY | ETF | 113.21 | 113.91 | 113.16 | 113.84 | 3370900.0 |
| 2001-12-17 11:00:00 | SPY | ETF | 113.81 | 114.19 | 113.81 | 113.97 | 1858100.0 |
| 2001-12-17 12:00:00 | SPY | ETF | 113.99 | 114.27 | 113.83 | 113.93 | 1287800.0 |
| 2001-12-17 13:00:00 | SPY | ETF | 113.93 | 114.31 | 113.91 | 114.28 | 761600.0 |
| 2001-12-17 14:00:00 | SPY | ETF | 114.31 | 114.36 | 113.9 | 114.03 | 910000.0 |
| 2001-12-17 15:00:00 | SPY | ETF | 114.05 | 114.26 | 113.71 | 113.99 | 2001100.0 |
| 2001-12-17 16:00:00 | SPY | ETF | 113.97 | 114.31 | 113.76 | 114.29 | 565000.0 |
| 2001-12-17 17:00:00 | SPY | ETF | 114.24 | 114.26 | 114.24 | 114.26 | 500.0 |
| 2001-12-17 09:00:00 | QQQ | ETF | 40.02 | 40.6 | 40.02 | 40.5 | 8387500.0 |
| 2001-12-17 10:00:00 | QQQ | ETF | 40.49 | 40.94 | 40.43 | 40.77 | 13344000.0 |
| 2001-12-17 11:00:00 | QQQ | ETF | 40.78 | 40.94 | 40.57 | 40.7 | 7757400.0 |
| 2001-12-17 12:00:00 | QQQ | ETF | 40.7 | 40.89 | 40.6 | 40.68 | 4848600.0 |
| 2001-12-17 13:00:00 | QQQ | ETF | 40.68 | 41.12 | 40.65 | 41.1 | 7605000.0 |
| 2001-12-17 14:00:00 | QQQ | ETF | 41.13 | 41.24 | 40.97 | 40.98 | 8489200.0 |
| 2001-12-17 15:00:00 | QQQ | ETF | 41.0 | 41.09 | 40.7 | 40.82 | 9146400.0 |
| 2001-12-17 16:00:00 | QQQ | ETF | 40.84 | 41.04 | 40.74 | 40.85 | 1524800.0 |
| 2001-12-17 17:00:00 | QQQ | ETF | 40.85 | 40.87 | 40.82 | 40.83 | 15200.0 |
| 2001-12-17 18:00:00 | QQQ | ETF | 40.83 | 40.86 | 40.82 | 40.86 | 6000.0 |
| 2001-12-17 09:00:00 | IWM | ETF | 46.83 | 47.19 | 46.83 | 47.165 | 20200.0 |
| 2001-12-17 10:00:00 | IWM | ETF | 47.165 | 47.595 | 47.13 | 47.535 | 127200.0 |
| 2001-12-17 11:00:00 | IWM | ETF | 47.525 | 47.54 | 47.295 | 47.315 | 148200.0 |
| 2001-12-17 12:00:00 | IWM | ETF | 47.38 | 47.4 | 47.03 | 47.16 | 65600.0 |
| 2001-12-17 13:00:00 | IWM | ETF | 47.16 | 47.35 | 47.1 | 47.2 | 108800.0 |
| 2001-12-17 14:00:00 | IWM | ETF | 47.315 | 47.4 | 47.15 | 47.325 | 108200.0 |
| 2001-12-17 15:00:00 | IWM | ETF | 47.35 | 47.57 | 47.175 | 47.57 | 119400.0 |
| 2001-12-17 16:00:00 | IWM | ETF | 47.07 | 47.85 | 47.07 | 47.85 | 48200.0 |
| 2001-12-17 09:00:00 | DIA | ETF | 98.35 | 98.75 | 98.34 | 98.67 | 488300.0 |
| 2001-12-17 10:00:00 | DIA | ETF | 98.67 | 99.2 | 98.6 | 99.16 | 733000.0 |
| 2001-12-17 11:00:00 | DIA | ETF | 99.24 | 99.5 | 99.15 | 99.37 | 370500.0 |
| 2001-12-17 12:00:00 | DIA | ETF | 99.29 | 99.6 | 99.1 | 99.2 | 363400.0 |
| 2001-12-17 13:00:00 | DIA | ETF | 99.28 | 99.49 | 99.25 | 99.45 | 53900.0 |
| 2001-12-17 14:00:00 | DIA | ETF | 99.4 | 99.52 | 99.1 | 99.22 | 164600.0 |
| 2001-12-17 15:00:00 | DIA | ETF | 99.22 | 99.43 | 99.01 | 99.16 | 207800.0 |
| 2001-12-17 16:00:00 | DIA | ETF | 99.21 | 99.3 | 99.2 | 99.3 | 12400.0 |
> showing 35 of 279 rows — these rows as CSV