PREVIEW / etf_1hour / 2002-07-10
file: by_date/etf_1hour/2002/2002-07-10.parquet size: 15 KB rows: 331
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-07-10 09:00:00 | SPY | ETF | 96.0 | 96.07 | 94.77 | 95.35 | 4573400.0 |
| 2002-07-10 10:00:00 | SPY | ETF | 95.33 | 95.97 | 95.0 | 95.41 | 5670000.0 |
| 2002-07-10 11:00:00 | SPY | ETF | 95.38 | 95.41 | 94.06 | 94.12 | 4663800.0 |
| 2002-07-10 12:00:00 | SPY | ETF | 94.12 | 94.5 | 93.74 | 94.5 | 5149000.0 |
| 2002-07-10 13:00:00 | SPY | ETF | 94.46 | 94.7 | 93.27 | 93.41 | 3594300.0 |
| 2002-07-10 14:00:00 | SPY | ETF | 93.35 | 93.52 | 92.57 | 93.41 | 8168700.0 |
| 2002-07-10 15:00:00 | SPY | ETF | 93.46 | 93.5 | 92.2 | 92.29 | 12043500.0 |
| 2002-07-10 16:00:00 | SPY | ETF | 92.24 | 93.6 | 91.94 | 92.14 | 5009400.0 |
| 2002-07-10 17:00:00 | SPY | ETF | 92.12 | 92.48 | 92.1 | 92.1 | 39900.0 |
| 2002-07-10 18:00:00 | SPY | ETF | 92.2 | 92.2 | 92.12 | 92.16 | 8300.0 |
| 2002-07-10 09:00:00 | QQQ | ETF | 24.99 | 25.03 | 24.5 | 24.78 | 16462200.0 |
| 2002-07-10 10:00:00 | QQQ | ETF | 24.78 | 24.99 | 24.55 | 24.79 | 15665500.0 |
| 2002-07-10 11:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.35 | 24.4 | 14244200.0 |
| 2002-07-10 12:00:00 | QQQ | ETF | 24.41 | 24.65 | 24.3 | 24.62 | 9134900.0 |
| 2002-07-10 13:00:00 | QQQ | ETF | 24.61 | 24.75 | 24.21 | 24.24 | 12632500.0 |
| 2002-07-10 14:00:00 | QQQ | ETF | 24.24 | 24.45 | 23.96 | 24.28 | 17496600.0 |
| 2002-07-10 15:00:00 | QQQ | ETF | 24.29 | 24.33 | 23.83 | 23.94 | 22474700.0 |
| 2002-07-10 16:00:00 | QQQ | ETF | 23.9 | 24.38 | 23.85 | 23.92 | 4261400.0 |
| 2002-07-10 17:00:00 | QQQ | ETF | 23.94 | 24.01 | 23.92 | 24.0 | 277100.0 |
| 2002-07-10 18:00:00 | QQQ | ETF | 24.0 | 24.01 | 23.95 | 23.98 | 63200.0 |
| 2002-07-10 09:00:00 | IWM | ETF | 42.945 | 42.945 | 42.38 | 42.61 | 222600.0 |
| 2002-07-10 10:00:00 | IWM | ETF | 42.56 | 42.75 | 42.325 | 42.48 | 485200.0 |
| 2002-07-10 11:00:00 | IWM | ETF | 42.475 | 42.48 | 42.175 | 42.175 | 280200.0 |
| 2002-07-10 12:00:00 | IWM | ETF | 42.25 | 42.315 | 42.075 | 42.3 | 273000.0 |
| 2002-07-10 13:00:00 | IWM | ETF | 42.35 | 42.42 | 42.065 | 42.11 | 144800.0 |
| 2002-07-10 14:00:00 | IWM | ETF | 42.12 | 42.12 | 41.825 | 42.0 | 223000.0 |
| 2002-07-10 15:00:00 | IWM | ETF | 42.0 | 42.015 | 41.675 | 41.68 | 380800.0 |
| 2002-07-10 16:00:00 | IWM | ETF | 41.775 | 41.855 | 41.705 | 41.71 | 39600.0 |
| 2002-07-10 17:00:00 | IWM | ETF | 41.825 | 41.825 | 41.825 | 41.825 | 382400.0 |
| 2002-07-10 09:00:00 | DIA | ETF | 91.55 | 91.6 | 90.36 | 90.91 | 871100.0 |
| 2002-07-10 10:00:00 | DIA | ETF | 90.92 | 91.58 | 90.68 | 91.1 | 959300.0 |
| 2002-07-10 11:00:00 | DIA | ETF | 91.0 | 91.13 | 90.0 | 90.0 | 735600.0 |
| 2002-07-10 12:00:00 | DIA | ETF | 90.06 | 90.35 | 89.7 | 90.29 | 1488800.0 |
| 2002-07-10 13:00:00 | DIA | ETF | 90.29 | 90.59 | 89.45 | 89.48 | 923300.0 |
| 2002-07-10 14:00:00 | DIA | ETF | 89.54 | 89.6 | 88.68 | 89.39 | 1787700.0 |
| 2002-07-10 15:00:00 | DIA | ETF | 89.41 | 89.43 | 88.2 | 88.26 | 1850500.0 |
| 2002-07-10 16:00:00 | DIA | ETF | 88.28 | 89.66 | 88.01 | 88.3 | 181500.0 |
| 2002-07-10 17:00:00 | DIA | ETF | 88.75 | 88.75 | 88.75 | 88.75 | 200.0 |
> showing 38 of 331 rows — these rows as CSV