PREVIEW / etf_1hour / 2001-04-12
file: by_date/etf_1hour/2001/2001-04-12.parquet size: 11 KB rows: 224
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-04-12 09:00:00 | SPY | ETF | 116.3 | 117.3 | 116.2 | 116.6 | 1178600.0 |
| 2001-04-12 10:00:00 | SPY | ETF | 116.65 | 116.75 | 115.96 | 116.38 | 905900.0 |
| 2001-04-12 11:00:00 | SPY | ETF | 116.34 | 117.44 | 116.03 | 117.32 | 1108100.0 |
| 2001-04-12 12:00:00 | SPY | ETF | 117.39 | 118.1 | 117.01 | 117.84 | 1058400.0 |
| 2001-04-12 13:00:00 | SPY | ETF | 117.82 | 118.36 | 117.7 | 117.84 | 1317800.0 |
| 2001-04-12 14:00:00 | SPY | ETF | 117.86 | 118.19 | 117.54 | 118.05 | 1162100.0 |
| 2001-04-12 15:00:00 | SPY | ETF | 117.88 | 118.63 | 117.7 | 118.55 | 1355700.0 |
| 2001-04-12 16:00:00 | SPY | ETF | 118.61 | 118.94 | 118.45 | 118.9 | 978900.0 |
| 2001-04-12 17:00:00 | SPY | ETF | 118.98 | 119.0 | 118.98 | 119.0 | 1300.0 |
| 2001-04-12 09:00:00 | QQQ | ETF | 40.3 | 41.25 | 40.25 | 40.56 | 14312800.0 |
| 2001-04-12 10:00:00 | QQQ | ETF | 40.56 | 40.75 | 40.0 | 40.4 | 10794100.0 |
| 2001-04-12 11:00:00 | QQQ | ETF | 40.4 | 41.4 | 40.2 | 41.39 | 10188000.0 |
| 2001-04-12 12:00:00 | QQQ | ETF | 41.3 | 42.1 | 41.17 | 41.85 | 11804500.0 |
| 2001-04-12 13:00:00 | QQQ | ETF | 41.85 | 42.69 | 41.8 | 42.15 | 10634000.0 |
| 2001-04-12 14:00:00 | QQQ | ETF | 42.17 | 42.47 | 41.71 | 42.35 | 8470500.0 |
| 2001-04-12 15:00:00 | QQQ | ETF | 42.35 | 42.77 | 42.2 | 42.65 | 10640800.0 |
| 2001-04-12 16:00:00 | QQQ | ETF | 42.7 | 43.05 | 42.64 | 42.85 | 1584700.0 |
| 2001-04-12 17:00:00 | QQQ | ETF | 42.85 | 43.0 | 42.8 | 42.89 | 33000.0 |
| 2001-04-12 18:00:00 | QQQ | ETF | 42.9 | 42.95 | 42.86 | 42.9 | 11700.0 |
| 2001-04-12 09:00:00 | IWM | ETF | 44.625 | 45.0 | 44.525 | 44.915 | 20400.0 |
| 2001-04-12 10:00:00 | IWM | ETF | 44.9 | 44.9 | 44.7 | 44.725 | 8400.0 |
| 2001-04-12 11:00:00 | IWM | ETF | 44.62 | 45.0 | 44.62 | 45.0 | 63800.0 |
| 2001-04-12 12:00:00 | IWM | ETF | 45.0 | 45.225 | 44.71 | 45.18 | 26200.0 |
| 2001-04-12 13:00:00 | IWM | ETF | 44.95 | 45.275 | 44.95 | 45.11 | 134000.0 |
| 2001-04-12 14:00:00 | IWM | ETF | 45.0 | 45.2 | 44.905 | 45.2 | 25200.0 |
| 2001-04-12 15:00:00 | IWM | ETF | 45.225 | 45.5 | 45.05 | 45.45 | 204400.0 |
| 2001-04-12 09:00:00 | DIA | ETF | 99.5 | 100.5 | 99.5 | 99.94 | 585800.0 |
| 2001-04-12 10:00:00 | DIA | ETF | 99.87 | 100.15 | 99.35 | 99.77 | 668500.0 |
| 2001-04-12 11:00:00 | DIA | ETF | 99.75 | 100.38 | 99.46 | 100.38 | 561900.0 |
| 2001-04-12 12:00:00 | DIA | ETF | 100.38 | 100.85 | 100.04 | 100.65 | 364600.0 |
| 2001-04-12 13:00:00 | DIA | ETF | 100.66 | 101.19 | 100.61 | 100.7 | 479700.0 |
| 2001-04-12 14:00:00 | DIA | ETF | 100.64 | 101.0 | 100.5 | 100.84 | 300800.0 |
| 2001-04-12 15:00:00 | DIA | ETF | 100.75 | 101.39 | 100.51 | 101.28 | 711700.0 |
| 2001-04-12 16:00:00 | DIA | ETF | 101.29 | 101.73 | 101.16 | 101.7 | 90600.0 |
> showing 34 of 224 rows — these rows as CSV