PREVIEW / etf_1hour / 2002-01-24
file: by_date/etf_1hour/2002/2002-01-24.parquet size: 13 KB rows: 282
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-24 09:00:00 | SPY | ETF | 113.64 | 113.93 | 113.5 | 113.78 | 1816600.0 |
| 2002-01-24 10:00:00 | SPY | ETF | 113.83 | 114.25 | 113.64 | 113.91 | 3165500.0 |
| 2002-01-24 11:00:00 | SPY | ETF | 113.87 | 114.13 | 113.66 | 114.04 | 982100.0 |
| 2002-01-24 12:00:00 | SPY | ETF | 114.0 | 114.21 | 113.86 | 114.02 | 883900.0 |
| 2002-01-24 13:00:00 | SPY | ETF | 114.04 | 114.05 | 113.4 | 113.45 | 1216800.0 |
| 2002-01-24 14:00:00 | SPY | ETF | 113.46 | 113.8 | 113.37 | 113.62 | 1048900.0 |
| 2002-01-24 15:00:00 | SPY | ETF | 113.66 | 113.85 | 113.32 | 113.54 | 1974500.0 |
| 2002-01-24 16:00:00 | SPY | ETF | 113.48 | 113.72 | 113.35 | 113.45 | 837900.0 |
| 2002-01-24 17:00:00 | SPY | ETF | 113.54 | 113.62 | 113.46 | 113.47 | 21400.0 |
| 2002-01-24 18:00:00 | SPY | ETF | 113.4 | 113.55 | 113.4 | 113.43 | 700.0 |
| 2002-01-24 09:00:00 | QQQ | ETF | 38.94 | 39.3 | 38.85 | 39.12 | 9579200.0 |
| 2002-01-24 10:00:00 | QQQ | ETF | 39.13 | 39.51 | 38.92 | 39.21 | 22420600.0 |
| 2002-01-24 11:00:00 | QQQ | ETF | 39.2 | 39.36 | 39.05 | 39.27 | 7770900.0 |
| 2002-01-24 12:00:00 | QQQ | ETF | 39.27 | 39.36 | 39.12 | 39.27 | 4776700.0 |
| 2002-01-24 13:00:00 | QQQ | ETF | 39.26 | 39.28 | 38.85 | 38.88 | 7884400.0 |
| 2002-01-24 14:00:00 | QQQ | ETF | 38.88 | 39.14 | 38.77 | 39.04 | 6745900.0 |
| 2002-01-24 15:00:00 | QQQ | ETF | 39.04 | 39.25 | 38.86 | 38.96 | 9687700.0 |
| 2002-01-24 16:00:00 | QQQ | ETF | 38.96 | 39.09 | 38.46 | 38.61 | 2801500.0 |
| 2002-01-24 17:00:00 | QQQ | ETF | 38.61 | 38.96 | 38.59 | 38.65 | 4130700.0 |
| 2002-01-24 18:00:00 | QQQ | ETF | 38.65 | 38.67 | 38.57 | 38.59 | 75700.0 |
| 2002-01-24 09:00:00 | IWM | ETF | 47.55 | 47.765 | 47.55 | 47.66 | 40400.0 |
| 2002-01-24 10:00:00 | IWM | ETF | 47.75 | 47.89 | 47.65 | 47.75 | 331000.0 |
| 2002-01-24 11:00:00 | IWM | ETF | 47.775 | 47.825 | 47.7 | 47.74 | 16800.0 |
| 2002-01-24 12:00:00 | IWM | ETF | 47.875 | 47.875 | 47.71 | 47.72 | 98200.0 |
| 2002-01-24 13:00:00 | IWM | ETF | 47.72 | 47.785 | 47.56 | 47.56 | 206200.0 |
| 2002-01-24 14:00:00 | IWM | ETF | 47.55 | 47.725 | 47.55 | 47.7 | 33400.0 |
| 2002-01-24 15:00:00 | IWM | ETF | 47.75 | 47.785 | 47.63 | 47.65 | 152600.0 |
| 2002-01-24 16:00:00 | IWM | ETF | 47.6 | 47.725 | 47.6 | 47.675 | 70000.0 |
| 2002-01-24 09:00:00 | DIA | ETF | 97.94 | 98.38 | 97.76 | 98.2 | 585300.0 |
| 2002-01-24 10:00:00 | DIA | ETF | 98.26 | 98.66 | 98.18 | 98.33 | 475900.0 |
| 2002-01-24 11:00:00 | DIA | ETF | 98.33 | 98.5 | 98.18 | 98.44 | 380600.0 |
| 2002-01-24 12:00:00 | DIA | ETF | 98.45 | 98.53 | 98.15 | 98.41 | 1281000.0 |
| 2002-01-24 13:00:00 | DIA | ETF | 98.35 | 98.41 | 97.86 | 97.88 | 239700.0 |
| 2002-01-24 14:00:00 | DIA | ETF | 97.87 | 98.16 | 97.79 | 98.0 | 335800.0 |
| 2002-01-24 15:00:00 | DIA | ETF | 98.09 | 98.25 | 97.84 | 98.02 | 533800.0 |
| 2002-01-24 16:00:00 | DIA | ETF | 98.08 | 98.14 | 98.06 | 98.08 | 48100.0 |
> showing 36 of 282 rows — these rows as CSV