PREVIEW / etf_1hour / 2002-03-22
file: by_date/etf_1hour/2002/2002-03-22.parquet size: 13 KB rows: 284
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-03-22 09:00:00 | SPY | ETF | 115.5 | 115.5 | 114.89 | 115.05 | 1894200.0 |
| 2002-03-22 10:00:00 | SPY | ETF | 115.07 | 115.32 | 114.7 | 115.27 | 2289300.0 |
| 2002-03-22 11:00:00 | SPY | ETF | 115.29 | 115.55 | 115.08 | 115.3 | 2016200.0 |
| 2002-03-22 12:00:00 | SPY | ETF | 115.3 | 115.94 | 115.28 | 115.72 | 1936300.0 |
| 2002-03-22 13:00:00 | SPY | ETF | 115.74 | 115.82 | 115.42 | 115.46 | 1521200.0 |
| 2002-03-22 14:00:00 | SPY | ETF | 115.5 | 115.5 | 115.03 | 115.22 | 1838300.0 |
| 2002-03-22 15:00:00 | SPY | ETF | 115.22 | 115.25 | 114.87 | 115.09 | 2039100.0 |
| 2002-03-22 16:00:00 | SPY | ETF | 115.12 | 115.37 | 114.98 | 115.03 | 1102200.0 |
| 2002-03-22 17:00:00 | SPY | ETF | 115.0 | 115.0 | 115.0 | 115.0 | 400.0 |
| 2002-03-22 09:00:00 | QQQ | ETF | 36.94 | 37.02 | 36.68 | 36.79 | 7786300.0 |
| 2002-03-22 10:00:00 | QQQ | ETF | 36.8 | 36.87 | 36.47 | 36.85 | 13299700.0 |
| 2002-03-22 11:00:00 | QQQ | ETF | 36.85 | 37.0 | 36.68 | 36.86 | 7176900.0 |
| 2002-03-22 12:00:00 | QQQ | ETF | 36.85 | 37.14 | 36.83 | 36.92 | 6468500.0 |
| 2002-03-22 13:00:00 | QQQ | ETF | 36.93 | 37.0 | 36.79 | 36.89 | 5813800.0 |
| 2002-03-22 14:00:00 | QQQ | ETF | 36.88 | 36.9 | 36.61 | 36.8 | 7646800.0 |
| 2002-03-22 15:00:00 | QQQ | ETF | 36.77 | 36.8 | 36.53 | 36.62 | 7022500.0 |
| 2002-03-22 16:00:00 | QQQ | ETF | 36.62 | 36.81 | 36.58 | 36.7 | 1057700.0 |
| 2002-03-22 17:00:00 | QQQ | ETF | 36.66 | 36.67 | 36.61 | 36.63 | 16400.0 |
| 2002-03-22 18:00:00 | QQQ | ETF | 36.62 | 36.65 | 36.62 | 36.65 | 1100.0 |
| 2002-03-22 09:00:00 | IWM | ETF | 50.275 | 50.275 | 50.06 | 50.13 | 45200.0 |
| 2002-03-22 10:00:00 | IWM | ETF | 50.075 | 50.24 | 49.945 | 50.205 | 88000.0 |
| 2002-03-22 11:00:00 | IWM | ETF | 50.19 | 50.45 | 50.19 | 50.335 | 102200.0 |
| 2002-03-22 12:00:00 | IWM | ETF | 50.33 | 50.555 | 50.3 | 50.545 | 78400.0 |
| 2002-03-22 13:00:00 | IWM | ETF | 50.405 | 50.47 | 50.265 | 50.265 | 42600.0 |
| 2002-03-22 14:00:00 | IWM | ETF | 50.265 | 50.29 | 50.135 | 50.15 | 75400.0 |
| 2002-03-22 15:00:00 | IWM | ETF | 50.16 | 50.21 | 49.905 | 49.905 | 494200.0 |
| 2002-03-22 16:00:00 | IWM | ETF | 49.88 | 49.95 | 49.88 | 49.9 | 40400.0 |
| 2002-03-22 09:00:00 | DIA | ETF | 104.76 | 104.76 | 104.16 | 104.28 | 205000.0 |
| 2002-03-22 10:00:00 | DIA | ETF | 104.31 | 104.45 | 103.96 | 104.36 | 733000.0 |
| 2002-03-22 11:00:00 | DIA | ETF | 104.47 | 104.64 | 104.21 | 104.37 | 270400.0 |
| 2002-03-22 12:00:00 | DIA | ETF | 104.41 | 105.04 | 104.4 | 104.8 | 904700.0 |
| 2002-03-22 13:00:00 | DIA | ETF | 104.8 | 104.96 | 104.48 | 104.53 | 981700.0 |
| 2002-03-22 14:00:00 | DIA | ETF | 104.46 | 104.48 | 104.14 | 104.37 | 430800.0 |
| 2002-03-22 15:00:00 | DIA | ETF | 104.34 | 104.42 | 104.07 | 104.3 | 692000.0 |
| 2002-03-22 16:00:00 | DIA | ETF | 104.26 | 104.42 | 104.23 | 104.23 | 206200.0 |
> showing 35 of 284 rows — these rows as CSV