PREVIEW / etf_1hour / 2001-03-22
file: by_date/etf_1hour/2001/2001-03-22.parquet size: 12 KB rows: 234
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-03-22 09:00:00 | SPY | ETF | 112.02 | 112.4 | 111.01 | 111.43 | 2920000.0 |
| 2001-03-22 10:00:00 | SPY | ETF | 111.45 | 111.62 | 109.2 | 110.08 | 5246400.0 |
| 2001-03-22 11:00:00 | SPY | ETF | 110.02 | 110.35 | 108.62 | 109.5 | 4650700.0 |
| 2001-03-22 12:00:00 | SPY | ETF | 109.35 | 110.73 | 109.27 | 110.02 | 1838700.0 |
| 2001-03-22 13:00:00 | SPY | ETF | 110.15 | 110.37 | 109.43 | 109.95 | 1106700.0 |
| 2001-03-22 14:00:00 | SPY | ETF | 109.78 | 109.95 | 108.04 | 109.09 | 3095600.0 |
| 2001-03-22 15:00:00 | SPY | ETF | 109.05 | 112.6 | 108.95 | 111.9 | 5912600.0 |
| 2001-03-22 16:00:00 | SPY | ETF | 111.87 | 111.95 | 108.95 | 111.0 | 3392100.0 |
| 2001-03-22 17:00:00 | SPY | ETF | 111.38 | 111.38 | 111.21 | 111.21 | 200.0 |
| 2001-03-22 18:00:00 | SPY | ETF | 111.52 | 111.7 | 111.51 | 111.7 | 1000.0 |
| 2001-03-22 09:00:00 | QQQ | ETF | 40.6 | 41.0 | 40.39 | 40.56 | 10740400.0 |
| 2001-03-22 10:00:00 | QQQ | ETF | 40.46 | 40.65 | 39.49 | 40.2 | 20931700.0 |
| 2001-03-22 11:00:00 | QQQ | ETF | 40.14 | 40.66 | 39.68 | 40.35 | 16209500.0 |
| 2001-03-22 12:00:00 | QQQ | ETF | 40.35 | 41.26 | 40.19 | 40.7 | 16974000.0 |
| 2001-03-22 13:00:00 | QQQ | ETF | 40.76 | 41.03 | 40.43 | 40.55 | 9276600.0 |
| 2001-03-22 14:00:00 | QQQ | ETF | 40.55 | 40.85 | 39.91 | 40.79 | 14066300.0 |
| 2001-03-22 15:00:00 | QQQ | ETF | 40.85 | 42.66 | 40.72 | 42.5 | 34088800.0 |
| 2001-03-22 16:00:00 | QQQ | ETF | 42.5 | 42.8 | 42.05 | 42.25 | 3493800.0 |
| 2001-03-22 17:00:00 | QQQ | ETF | 42.49 | 42.8 | 42.25 | 42.65 | 51700.0 |
| 2001-03-22 18:00:00 | QQQ | ETF | 42.6 | 42.8 | 42.6 | 42.62 | 23400.0 |
| 2001-03-22 09:00:00 | IWM | ETF | 43.125 | 43.3 | 42.725 | 42.725 | 325000.0 |
| 2001-03-22 10:00:00 | IWM | ETF | 42.7 | 42.7 | 41.875 | 42.2 | 267800.0 |
| 2001-03-22 11:00:00 | IWM | ETF | 42.11 | 42.2 | 41.575 | 42.0 | 191800.0 |
| 2001-03-22 12:00:00 | IWM | ETF | 42.06 | 42.4 | 42.06 | 42.175 | 47400.0 |
| 2001-03-22 13:00:00 | IWM | ETF | 42.175 | 42.275 | 42.05 | 42.185 | 21000.0 |
| 2001-03-22 14:00:00 | IWM | ETF | 42.075 | 42.125 | 41.775 | 41.95 | 49000.0 |
| 2001-03-22 15:00:00 | IWM | ETF | 42.05 | 43.375 | 42.0 | 43.0 | 277400.0 |
| 2001-03-22 16:00:00 | IWM | ETF | 43.0 | 43.05 | 42.825 | 43.0 | 7600.0 |
| 2001-03-22 09:00:00 | DIA | ETF | 94.5 | 94.55 | 93.1 | 94.3 | 1642800.0 |
| 2001-03-22 10:00:00 | DIA | ETF | 94.15 | 94.25 | 92.15 | 92.84 | 1752500.0 |
| 2001-03-22 11:00:00 | DIA | ETF | 92.8 | 93.15 | 91.57 | 92.2 | 1391100.0 |
| 2001-03-22 12:00:00 | DIA | ETF | 92.1 | 93.44 | 92.06 | 92.55 | 1271500.0 |
| 2001-03-22 13:00:00 | DIA | ETF | 92.59 | 92.82 | 92.11 | 92.4 | 885200.0 |
| 2001-03-22 14:00:00 | DIA | ETF | 92.48 | 92.48 | 91.0 | 91.8 | 1637900.0 |
| 2001-03-22 15:00:00 | DIA | ETF | 91.8 | 95.04 | 91.7 | 93.97 | 2986500.0 |
| 2001-03-22 16:00:00 | DIA | ETF | 94.0 | 94.0 | 93.4 | 93.4 | 200600.0 |
| 2001-03-22 17:00:00 | DIA | ETF | 93.5 | 93.86 | 93.5 | 93.86 | 1500.0 |
| 2001-03-22 18:00:00 | DIA | ETF | 93.5 | 93.51 | 93.5 | 93.51 | 1100.0 |
> showing 38 of 234 rows — these rows as CSV