PREVIEW / etf_1hour / 2002-01-10
file: by_date/etf_1hour/2002/2002-01-10.parquet size: 13 KB rows: 283
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-10 09:00:00 | SPY | ETF | 115.69 | 115.95 | 115.38 | 115.7 | 1902900.0 |
| 2002-01-10 10:00:00 | SPY | ETF | 115.66 | 116.02 | 115.3 | 115.73 | 2955100.0 |
| 2002-01-10 11:00:00 | SPY | ETF | 115.7 | 115.93 | 115.59 | 115.85 | 1148600.0 |
| 2002-01-10 12:00:00 | SPY | ETF | 115.84 | 115.98 | 115.53 | 115.7 | 903400.0 |
| 2002-01-10 13:00:00 | SPY | ETF | 115.7 | 116.1 | 115.57 | 116.06 | 1502000.0 |
| 2002-01-10 14:00:00 | SPY | ETF | 116.06 | 116.35 | 115.81 | 116.3 | 1732400.0 |
| 2002-01-10 15:00:00 | SPY | ETF | 116.29 | 116.32 | 115.71 | 115.97 | 1787200.0 |
| 2002-01-10 16:00:00 | SPY | ETF | 115.96 | 116.14 | 115.83 | 116.11 | 741900.0 |
| 2002-01-10 17:00:00 | SPY | ETF | 116.18 | 116.18 | 116.11 | 116.11 | 3200.0 |
| 2002-01-10 09:00:00 | QQQ | ETF | 41.17 | 41.25 | 40.68 | 41.09 | 14011500.0 |
| 2002-01-10 10:00:00 | QQQ | ETF | 41.08 | 41.35 | 40.73 | 41.02 | 16760200.0 |
| 2002-01-10 11:00:00 | QQQ | ETF | 41.03 | 41.22 | 40.93 | 41.14 | 7577200.0 |
| 2002-01-10 12:00:00 | QQQ | ETF | 41.15 | 41.3 | 40.93 | 41.06 | 7241300.0 |
| 2002-01-10 13:00:00 | QQQ | ETF | 41.05 | 41.47 | 40.94 | 41.42 | 6535500.0 |
| 2002-01-10 14:00:00 | QQQ | ETF | 41.4 | 41.54 | 41.19 | 41.51 | 9118500.0 |
| 2002-01-10 15:00:00 | QQQ | ETF | 41.49 | 41.53 | 41.08 | 41.24 | 10571700.0 |
| 2002-01-10 16:00:00 | QQQ | ETF | 41.25 | 41.4 | 41.22 | 41.35 | 2257000.0 |
| 2002-01-10 17:00:00 | QQQ | ETF | 41.35 | 41.4 | 41.35 | 41.4 | 10800.0 |
| 2002-01-10 18:00:00 | QQQ | ETF | 41.38 | 41.44 | 41.31 | 41.42 | 33400.0 |
| 2002-01-10 09:00:00 | IWM | ETF | 49.075 | 49.215 | 48.98 | 49.175 | 38000.0 |
| 2002-01-10 10:00:00 | IWM | ETF | 49.245 | 49.245 | 49.005 | 49.125 | 44400.0 |
| 2002-01-10 11:00:00 | IWM | ETF | 49.125 | 49.18 | 49.1 | 49.1 | 34200.0 |
| 2002-01-10 12:00:00 | IWM | ETF | 49.145 | 49.165 | 49.0 | 49.01 | 16200.0 |
| 2002-01-10 13:00:00 | IWM | ETF | 49.07 | 49.195 | 49.045 | 49.195 | 54400.0 |
| 2002-01-10 14:00:00 | IWM | ETF | 49.195 | 49.25 | 49.125 | 49.25 | 69600.0 |
| 2002-01-10 15:00:00 | IWM | ETF | 49.26 | 49.275 | 49.05 | 49.125 | 100800.0 |
| 2002-01-10 16:00:00 | IWM | ETF | 49.3 | 49.3 | 49.145 | 49.145 | 3200.0 |
| 2002-01-10 09:00:00 | DIA | ETF | 100.95 | 101.12 | 100.66 | 100.8 | 534900.0 |
| 2002-01-10 10:00:00 | DIA | ETF | 100.86 | 101.16 | 100.44 | 100.73 | 565100.0 |
| 2002-01-10 11:00:00 | DIA | ETF | 100.64 | 100.9 | 100.62 | 100.84 | 316000.0 |
| 2002-01-10 12:00:00 | DIA | ETF | 100.8 | 100.95 | 100.42 | 100.54 | 71800.0 |
| 2002-01-10 13:00:00 | DIA | ETF | 100.52 | 100.85 | 100.4 | 100.81 | 201200.0 |
| 2002-01-10 14:00:00 | DIA | ETF | 100.79 | 101.15 | 100.71 | 101.12 | 401900.0 |
| 2002-01-10 15:00:00 | DIA | ETF | 101.16 | 101.16 | 100.58 | 100.83 | 417400.0 |
| 2002-01-10 16:00:00 | DIA | ETF | 100.84 | 100.95 | 100.82 | 100.9 | 214700.0 |
> showing 35 of 283 rows — these rows as CSV