PREVIEW / etf_1hour / 2001-10-30
file: by_date/etf_1hour/2001/2001-10-30.parquet size: 13 KB rows: 263
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-10-30 09:00:00 | SPY | ETF | 107.35 | 107.35 | 106.7 | 106.78 | 3728900.0 |
| 2001-10-30 10:00:00 | SPY | ETF | 106.8 | 106.8 | 105.56 | 106.0 | 6019300.0 |
| 2001-10-30 11:00:00 | SPY | ETF | 106.0 | 106.75 | 105.96 | 106.65 | 4716000.0 |
| 2001-10-30 12:00:00 | SPY | ETF | 106.64 | 106.73 | 106.3 | 106.5 | 1313100.0 |
| 2001-10-30 13:00:00 | SPY | ETF | 106.51 | 107.2 | 106.32 | 107.04 | 2936000.0 |
| 2001-10-30 14:00:00 | SPY | ETF | 107.1 | 107.13 | 106.39 | 106.62 | 1956300.0 |
| 2001-10-30 15:00:00 | SPY | ETF | 106.56 | 106.78 | 106.0 | 106.2 | 3667800.0 |
| 2001-10-30 16:00:00 | SPY | ETF | 106.2 | 106.26 | 106.08 | 106.11 | 1027400.0 |
| 2001-10-30 17:00:00 | SPY | ETF | 106.2 | 106.21 | 105.94 | 106.0 | 1600.0 |
| 2001-10-30 18:00:00 | SPY | ETF | 105.96 | 105.96 | 105.9 | 105.91 | 6500.0 |
| 2001-10-30 09:00:00 | QQQ | ETF | 33.71 | 33.85 | 33.45 | 33.55 | 12224500.0 |
| 2001-10-30 10:00:00 | QQQ | ETF | 33.54 | 33.55 | 32.84 | 33.22 | 24031400.0 |
| 2001-10-30 11:00:00 | QQQ | ETF | 33.22 | 33.77 | 33.13 | 33.66 | 12433700.0 |
| 2001-10-30 12:00:00 | QQQ | ETF | 33.68 | 33.72 | 33.27 | 33.47 | 6875100.0 |
| 2001-10-30 13:00:00 | QQQ | ETF | 33.47 | 34.09 | 33.3 | 34.01 | 11960700.0 |
| 2001-10-30 14:00:00 | QQQ | ETF | 34.02 | 34.05 | 33.48 | 33.66 | 9631400.0 |
| 2001-10-30 15:00:00 | QQQ | ETF | 33.66 | 33.85 | 33.23 | 33.4 | 12799500.0 |
| 2001-10-30 16:00:00 | QQQ | ETF | 33.42 | 33.45 | 33.19 | 33.22 | 5452500.0 |
| 2001-10-30 17:00:00 | QQQ | ETF | 33.25 | 33.38 | 33.22 | 33.29 | 130200.0 |
| 2001-10-30 18:00:00 | QQQ | ETF | 33.3 | 33.3 | 33.23 | 33.27 | 25700.0 |
| 2001-10-30 09:00:00 | IWM | ETF | 42.4 | 42.4 | 42.185 | 42.225 | 130200.0 |
| 2001-10-30 10:00:00 | IWM | ETF | 42.21 | 42.21 | 41.675 | 41.865 | 533800.0 |
| 2001-10-30 11:00:00 | IWM | ETF | 41.865 | 42.05 | 41.855 | 42.05 | 82400.0 |
| 2001-10-30 12:00:00 | IWM | ETF | 42.095 | 42.13 | 42.08 | 42.13 | 7400.0 |
| 2001-10-30 13:00:00 | IWM | ETF | 42.085 | 42.26 | 42.055 | 42.23 | 48800.0 |
| 2001-10-30 14:00:00 | IWM | ETF | 42.26 | 42.26 | 42.1 | 42.14 | 35200.0 |
| 2001-10-30 15:00:00 | IWM | ETF | 42.14 | 42.14 | 41.935 | 42.0 | 44000.0 |
| 2001-10-30 16:00:00 | IWM | ETF | 42.06 | 42.06 | 41.85 | 41.85 | 4600.0 |
| 2001-10-30 09:00:00 | DIA | ETF | 92.1 | 92.15 | 91.7 | 91.83 | 711800.0 |
| 2001-10-30 10:00:00 | DIA | ETF | 91.75 | 91.8 | 90.68 | 91.05 | 1147600.0 |
| 2001-10-30 11:00:00 | DIA | ETF | 91.05 | 91.6 | 90.98 | 91.51 | 583700.0 |
| 2001-10-30 12:00:00 | DIA | ETF | 91.46 | 91.62 | 91.25 | 91.41 | 250600.0 |
| 2001-10-30 13:00:00 | DIA | ETF | 91.45 | 91.94 | 91.26 | 91.74 | 403100.0 |
| 2001-10-30 14:00:00 | DIA | ETF | 91.77 | 91.88 | 91.18 | 91.33 | 278600.0 |
| 2001-10-30 15:00:00 | DIA | ETF | 91.39 | 91.55 | 90.9 | 91.22 | 436400.0 |
| 2001-10-30 16:00:00 | DIA | ETF | 91.28 | 91.28 | 91.0 | 91.0 | 239000.0 |
> showing 36 of 263 rows — these rows as CSV