PREVIEW / etf_1hour / 2001-10-12
file: by_date/etf_1hour/2001/2001-10-12.parquet size: 13 KB rows: 265
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-12 09:00:00 | SPY | ETF | 109.15 | 109.89 | 108.75 | 109.05 | 6271200.0 |
| 2001-10-12 10:00:00 | SPY | ETF | 109.08 | 109.7 | 108.92 | 109.18 | 3800100.0 |
| 2001-10-12 11:00:00 | SPY | ETF | 109.16 | 109.46 | 107.6 | 108.31 | 4644400.0 |
| 2001-10-12 12:00:00 | SPY | ETF | 108.42 | 108.55 | 107.3 | 107.65 | 5486200.0 |
| 2001-10-12 13:00:00 | SPY | ETF | 107.72 | 108.05 | 107.5 | 107.9 | 1580700.0 |
| 2001-10-12 14:00:00 | SPY | ETF | 107.94 | 108.79 | 107.76 | 108.7 | 2336900.0 |
| 2001-10-12 15:00:00 | SPY | ETF | 108.7 | 109.55 | 108.27 | 109.52 | 4590600.0 |
| 2001-10-12 16:00:00 | SPY | ETF | 109.45 | 109.67 | 109.05 | 109.49 | 1100600.0 |
| 2001-10-12 17:00:00 | SPY | ETF | 109.2 | 109.3 | 108.95 | 109.0 | 4900.0 |
| 2001-10-12 18:00:00 | SPY | ETF | 109.01 | 109.01 | 109.0 | 109.0 | 2000.0 |
| 2001-10-12 09:00:00 | QQQ | ETF | 34.33 | 34.75 | 33.91 | 34.28 | 24611400.0 |
| 2001-10-12 10:00:00 | QQQ | ETF | 34.31 | 34.79 | 34.25 | 34.45 | 16498900.0 |
| 2001-10-12 11:00:00 | QQQ | ETF | 34.48 | 34.58 | 33.35 | 33.7 | 17281000.0 |
| 2001-10-12 12:00:00 | QQQ | ETF | 33.7 | 33.9 | 33.14 | 33.31 | 15310800.0 |
| 2001-10-12 13:00:00 | QQQ | ETF | 33.31 | 33.66 | 33.26 | 33.54 | 5589900.0 |
| 2001-10-12 14:00:00 | QQQ | ETF | 33.55 | 34.15 | 33.49 | 34.12 | 10167200.0 |
| 2001-10-12 15:00:00 | QQQ | ETF | 34.14 | 34.76 | 33.86 | 34.71 | 14819400.0 |
| 2001-10-12 16:00:00 | QQQ | ETF | 34.71 | 34.74 | 33.97 | 34.54 | 3520200.0 |
| 2001-10-12 17:00:00 | QQQ | ETF | 34.54 | 34.59 | 34.45 | 34.46 | 33900.0 |
| 2001-10-12 18:00:00 | QQQ | ETF | 34.48 | 34.48 | 34.45 | 34.46 | 7100.0 |
| 2001-10-12 09:00:00 | IWM | ETF | 42.56 | 42.79 | 42.35 | 42.625 | 121200.0 |
| 2001-10-12 10:00:00 | IWM | ETF | 42.6 | 42.74 | 42.565 | 42.7 | 24800.0 |
| 2001-10-12 11:00:00 | IWM | ETF | 42.64 | 42.75 | 41.9 | 42.165 | 67400.0 |
| 2001-10-12 12:00:00 | IWM | ETF | 42.15 | 42.2 | 42.05 | 42.05 | 86600.0 |
| 2001-10-12 13:00:00 | IWM | ETF | 41.995 | 42.1 | 41.995 | 42.04 | 26000.0 |
| 2001-10-12 14:00:00 | IWM | ETF | 42.06 | 42.89 | 42.06 | 42.425 | 12000.0 |
| 2001-10-12 15:00:00 | IWM | ETF | 42.425 | 42.765 | 42.41 | 42.61 | 94600.0 |
| 2001-10-12 16:00:00 | IWM | ETF | 42.7 | 42.7 | 42.55 | 42.55 | 34000.0 |
| 2001-10-12 09:00:00 | DIA | ETF | 93.2 | 93.99 | 92.75 | 93.15 | 1253800.0 |
| 2001-10-12 10:00:00 | DIA | ETF | 93.28 | 93.8 | 93.05 | 93.35 | 1190600.0 |
| 2001-10-12 11:00:00 | DIA | ETF | 93.35 | 93.55 | 92.0 | 92.65 | 813200.0 |
| 2001-10-12 12:00:00 | DIA | ETF | 92.8 | 92.93 | 92.0 | 92.15 | 1371500.0 |
| 2001-10-12 13:00:00 | DIA | ETF | 92.2 | 92.54 | 92.11 | 92.46 | 185600.0 |
| 2001-10-12 14:00:00 | DIA | ETF | 92.41 | 93.05 | 92.32 | 93.0 | 413100.0 |
| 2001-10-12 15:00:00 | DIA | ETF | 93.05 | 93.68 | 92.6 | 93.54 | 692500.0 |
| 2001-10-12 16:00:00 | DIA | ETF | 93.58 | 94.23 | 93.5 | 94.23 | 353000.0 |
> showing 36 of 265 rows — these rows as CSV