PREVIEW / etf_1hour / 2002-01-22
file: by_date/etf_1hour/2002/2002-01-22.parquet size: 13 KB rows: 283
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-01-22 09:00:00 | SPY | ETF | 113.75 | 113.87 | 113.55 | 113.7 | 1568100.0 |
| 2002-01-22 10:00:00 | SPY | ETF | 113.68 | 113.93 | 113.03 | 113.17 | 2840000.0 |
| 2002-01-22 11:00:00 | SPY | ETF | 113.18 | 113.2 | 112.84 | 112.84 | 1246600.0 |
| 2002-01-22 12:00:00 | SPY | ETF | 112.79 | 112.97 | 112.52 | 112.97 | 1097700.0 |
| 2002-01-22 13:00:00 | SPY | ETF | 112.98 | 112.98 | 112.26 | 112.52 | 1086400.0 |
| 2002-01-22 14:00:00 | SPY | ETF | 112.52 | 112.68 | 112.2 | 112.35 | 1179500.0 |
| 2002-01-22 15:00:00 | SPY | ETF | 112.32 | 112.6 | 112.02 | 112.25 | 1748000.0 |
| 2002-01-22 16:00:00 | SPY | ETF | 112.22 | 112.5 | 112.2 | 112.44 | 607200.0 |
| 2002-01-22 17:00:00 | SPY | ETF | 112.42 | 112.47 | 112.4 | 112.47 | 1800.0 |
| 2002-01-22 18:00:00 | SPY | ETF | 112.46 | 112.5 | 112.4 | 112.5 | 1600.0 |
| 2002-01-22 09:00:00 | QQQ | ETF | 39.0 | 39.02 | 38.65 | 38.85 | 9420000.0 |
| 2002-01-22 10:00:00 | QQQ | ETF | 38.83 | 38.99 | 37.9 | 38.06 | 18045300.0 |
| 2002-01-22 11:00:00 | QQQ | ETF | 38.06 | 38.1 | 37.77 | 37.79 | 12728400.0 |
| 2002-01-22 12:00:00 | QQQ | ETF | 37.79 | 37.92 | 37.62 | 37.9 | 8128200.0 |
| 2002-01-22 13:00:00 | QQQ | ETF | 37.88 | 37.92 | 37.46 | 37.63 | 9437100.0 |
| 2002-01-22 14:00:00 | QQQ | ETF | 37.65 | 37.75 | 37.44 | 37.48 | 7083800.0 |
| 2002-01-22 15:00:00 | QQQ | ETF | 37.5 | 37.7 | 37.33 | 37.39 | 13371900.0 |
| 2002-01-22 16:00:00 | QQQ | ETF | 37.4 | 37.55 | 37.28 | 37.53 | 1994700.0 |
| 2002-01-22 17:00:00 | QQQ | ETF | 37.54 | 37.55 | 37.42 | 37.42 | 140800.0 |
| 2002-01-22 18:00:00 | QQQ | ETF | 37.47 | 37.52 | 37.42 | 37.45 | 15900.0 |
| 2002-01-22 09:00:00 | IWM | ETF | 47.375 | 47.545 | 47.265 | 47.4 | 73800.0 |
| 2002-01-22 10:00:00 | IWM | ETF | 47.44 | 47.44 | 46.995 | 47.0 | 332200.0 |
| 2002-01-22 11:00:00 | IWM | ETF | 46.995 | 47.01 | 46.855 | 46.975 | 125800.0 |
| 2002-01-22 12:00:00 | IWM | ETF | 46.85 | 46.97 | 46.825 | 46.97 | 89200.0 |
| 2002-01-22 13:00:00 | IWM | ETF | 46.95 | 46.96 | 46.765 | 46.855 | 119200.0 |
| 2002-01-22 14:00:00 | IWM | ETF | 46.89 | 46.92 | 46.785 | 46.87 | 141200.0 |
| 2002-01-22 15:00:00 | IWM | ETF | 46.86 | 46.91 | 46.675 | 46.725 | 233600.0 |
| 2002-01-22 16:00:00 | IWM | ETF | 46.555 | 46.65 | 46.555 | 46.65 | 145800.0 |
| 2002-01-22 09:00:00 | DIA | ETF | 98.34 | 98.55 | 98.13 | 98.32 | 188700.0 |
| 2002-01-22 10:00:00 | DIA | ETF | 98.43 | 98.55 | 98.0 | 98.12 | 301800.0 |
| 2002-01-22 11:00:00 | DIA | ETF | 98.1 | 98.13 | 97.77 | 97.82 | 181200.0 |
| 2002-01-22 12:00:00 | DIA | ETF | 97.77 | 97.93 | 97.5 | 97.9 | 257900.0 |
| 2002-01-22 13:00:00 | DIA | ETF | 97.95 | 97.96 | 97.3 | 97.55 | 140200.0 |
| 2002-01-22 14:00:00 | DIA | ETF | 97.55 | 97.66 | 97.26 | 97.35 | 280900.0 |
| 2002-01-22 15:00:00 | DIA | ETF | 97.32 | 97.49 | 97.0 | 97.22 | 513100.0 |
| 2002-01-22 16:00:00 | DIA | ETF | 97.24 | 97.3 | 97.2 | 97.25 | 60500.0 |
> showing 36 of 283 rows — these rows as CSV