PREVIEW / etf_1hour / 2002-06-27
file: by_date/etf_1hour/2002/2002-06-27.parquet size: 14 KB rows: 325
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-06-27 09:00:00 | SPY | ETF | 98.5 | 98.65 | 97.85 | 98.3 | 4344600.0 |
| 2002-06-27 10:00:00 | SPY | ETF | 98.29 | 98.5 | 97.75 | 97.93 | 3638700.0 |
| 2002-06-27 11:00:00 | SPY | ETF | 97.9 | 97.95 | 96.57 | 97.25 | 6455200.0 |
| 2002-06-27 12:00:00 | SPY | ETF | 97.25 | 97.55 | 97.04 | 97.55 | 1997900.0 |
| 2002-06-27 13:00:00 | SPY | ETF | 97.55 | 98.41 | 97.41 | 98.2 | 3065900.0 |
| 2002-06-27 14:00:00 | SPY | ETF | 98.21 | 99.14 | 98.1 | 98.83 | 3511100.0 |
| 2002-06-27 15:00:00 | SPY | ETF | 98.86 | 99.45 | 98.1 | 99.45 | 3248600.0 |
| 2002-06-27 16:00:00 | SPY | ETF | 99.37 | 99.49 | 99.3 | 99.3 | 1235000.0 |
| 2002-06-27 17:00:00 | SPY | ETF | 99.43 | 99.64 | 99.38 | 99.54 | 11900.0 |
| 2002-06-27 18:00:00 | SPY | ETF | 99.55 | 99.69 | 99.55 | 99.69 | 700.0 |
| 2002-06-27 09:00:00 | QQQ | ETF | 26.0 | 26.09 | 25.68 | 25.97 | 14179900.0 |
| 2002-06-27 10:00:00 | QQQ | ETF | 25.93 | 26.07 | 25.64 | 25.76 | 16156300.0 |
| 2002-06-27 11:00:00 | QQQ | ETF | 25.75 | 25.79 | 25.02 | 25.46 | 22786900.0 |
| 2002-06-27 12:00:00 | QQQ | ETF | 25.4 | 25.58 | 25.26 | 25.56 | 6006200.0 |
| 2002-06-27 13:00:00 | QQQ | ETF | 25.55 | 25.84 | 25.41 | 25.79 | 8824400.0 |
| 2002-06-27 14:00:00 | QQQ | ETF | 25.8 | 26.11 | 25.72 | 25.91 | 13505100.0 |
| 2002-06-27 15:00:00 | QQQ | ETF | 25.92 | 26.15 | 25.55 | 26.11 | 15775900.0 |
| 2002-06-27 16:00:00 | QQQ | ETF | 26.12 | 26.31 | 26.07 | 26.23 | 4767800.0 |
| 2002-06-27 17:00:00 | QQQ | ETF | 26.22 | 26.3 | 26.19 | 26.27 | 81600.0 |
| 2002-06-27 18:00:00 | QQQ | ETF | 26.27 | 26.3 | 26.23 | 26.24 | 18500.0 |
| 2002-06-27 09:00:00 | IWM | ETF | 45.65 | 45.67 | 45.255 | 45.375 | 154400.0 |
| 2002-06-27 10:00:00 | IWM | ETF | 45.35 | 45.615 | 45.305 | 45.435 | 163000.0 |
| 2002-06-27 11:00:00 | IWM | ETF | 45.43 | 45.43 | 44.775 | 45.155 | 2107600.0 |
| 2002-06-27 12:00:00 | IWM | ETF | 45.105 | 45.115 | 44.995 | 45.035 | 133400.0 |
| 2002-06-27 13:00:00 | IWM | ETF | 45.095 | 45.355 | 45.055 | 45.355 | 218800.0 |
| 2002-06-27 14:00:00 | IWM | ETF | 45.395 | 45.55 | 45.275 | 45.405 | 249400.0 |
| 2002-06-27 15:00:00 | IWM | ETF | 45.385 | 45.7 | 45.125 | 45.7 | 709800.0 |
| 2002-06-27 16:00:00 | IWM | ETF | 45.77 | 45.85 | 45.7 | 45.85 | 270200.0 |
| 2002-06-27 17:00:00 | IWM | ETF | 45.665 | 45.665 | 45.665 | 45.665 | 423000.0 |
| 2002-06-27 09:00:00 | DIA | ETF | 92.16 | 92.32 | 91.43 | 91.57 | 930800.0 |
| 2002-06-27 10:00:00 | DIA | ETF | 91.73 | 92.07 | 91.41 | 91.67 | 1157600.0 |
| 2002-06-27 11:00:00 | DIA | ETF | 91.62 | 91.68 | 90.3 | 90.99 | 1324000.0 |
| 2002-06-27 12:00:00 | DIA | ETF | 90.85 | 91.25 | 90.65 | 91.2 | 229200.0 |
| 2002-06-27 13:00:00 | DIA | ETF | 91.23 | 92.05 | 91.1 | 91.97 | 568400.0 |
| 2002-06-27 14:00:00 | DIA | ETF | 91.97 | 92.81 | 91.84 | 92.57 | 678600.0 |
| 2002-06-27 15:00:00 | DIA | ETF | 92.55 | 92.81 | 91.6 | 92.8 | 732000.0 |
| 2002-06-27 16:00:00 | DIA | ETF | 92.74 | 92.88 | 92.72 | 92.86 | 60300.0 |
| 2002-06-27 17:00:00 | DIA | ETF | 92.86 | 92.98 | 92.86 | 92.98 | 400.0 |
> showing 38 of 325 rows — these rows as CSV