PREVIEW / etf_1hour / 2002-06-04
file: by_date/etf_1hour/2002/2002-06-04.parquet size: 14 KB rows: 323
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-04 09:00:00 | SPY | ETF | 104.15 | 104.45 | 103.77 | 104.33 | 4369600.0 |
| 2002-06-04 10:00:00 | SPY | ETF | 104.33 | 104.71 | 103.9 | 104.04 | 2972800.0 |
| 2002-06-04 11:00:00 | SPY | ETF | 104.08 | 104.42 | 103.7 | 104.05 | 2268100.0 |
| 2002-06-04 12:00:00 | SPY | ETF | 104.07 | 104.18 | 103.55 | 103.73 | 1626100.0 |
| 2002-06-04 13:00:00 | SPY | ETF | 103.7 | 104.62 | 103.65 | 104.55 | 3193800.0 |
| 2002-06-04 14:00:00 | SPY | ETF | 104.6 | 105.2 | 104.23 | 104.34 | 3608800.0 |
| 2002-06-04 15:00:00 | SPY | ETF | 104.32 | 104.67 | 103.57 | 104.41 | 4597700.0 |
| 2002-06-04 16:00:00 | SPY | ETF | 104.49 | 104.77 | 104.26 | 104.77 | 1409200.0 |
| 2002-06-04 17:00:00 | SPY | ETF | 104.8 | 104.85 | 104.7 | 104.7 | 5900.0 |
| 2002-06-04 18:00:00 | SPY | ETF | 104.71 | 104.89 | 104.71 | 104.89 | 12300.0 |
| 2002-06-04 09:00:00 | QQQ | ETF | 28.75 | 29.1 | 28.65 | 29.06 | 14203200.0 |
| 2002-06-04 10:00:00 | QQQ | ETF | 29.08 | 29.22 | 28.7 | 28.8 | 14457300.0 |
| 2002-06-04 11:00:00 | QQQ | ETF | 28.8 | 29.07 | 28.7 | 28.9 | 9383900.0 |
| 2002-06-04 12:00:00 | QQQ | ETF | 28.9 | 28.98 | 28.61 | 28.65 | 7124700.0 |
| 2002-06-04 13:00:00 | QQQ | ETF | 28.65 | 29.34 | 28.65 | 29.3 | 12055100.0 |
| 2002-06-04 14:00:00 | QQQ | ETF | 29.26 | 29.68 | 29.1 | 29.12 | 16140000.0 |
| 2002-06-04 15:00:00 | QQQ | ETF | 29.16 | 29.35 | 28.74 | 29.34 | 18975300.0 |
| 2002-06-04 16:00:00 | QQQ | ETF | 29.35 | 29.44 | 28.74 | 29.37 | 1704500.0 |
| 2002-06-04 17:00:00 | QQQ | ETF | 29.37 | 29.38 | 29.32 | 29.34 | 114900.0 |
| 2002-06-04 18:00:00 | QQQ | ETF | 29.36 | 29.4 | 29.32 | 29.38 | 31300.0 |
| 2002-06-04 09:00:00 | IWM | ETF | 47.05 | 47.3 | 47.05 | 47.185 | 316800.0 |
| 2002-06-04 10:00:00 | IWM | ETF | 47.195 | 47.4 | 46.97 | 46.995 | 447000.0 |
| 2002-06-04 11:00:00 | IWM | ETF | 47.0 | 47.075 | 46.85 | 46.875 | 357800.0 |
| 2002-06-04 12:00:00 | IWM | ETF | 46.905 | 46.915 | 46.51 | 46.51 | 471000.0 |
| 2002-06-04 13:00:00 | IWM | ETF | 46.505 | 46.925 | 46.505 | 46.88 | 332000.0 |
| 2002-06-04 14:00:00 | IWM | ETF | 46.88 | 47.355 | 46.795 | 47.005 | 992200.0 |
| 2002-06-04 15:00:00 | IWM | ETF | 47.035 | 47.2 | 46.675 | 47.2 | 915200.0 |
| 2002-06-04 16:00:00 | IWM | ETF | 47.13 | 47.15 | 46.84 | 46.84 | 261800.0 |
| 2002-06-04 17:00:00 | IWM | ETF | 47.215 | 47.215 | 47.215 | 47.215 | 1398000.0 |
| 2002-06-04 09:00:00 | DIA | ETF | 96.98 | 97.32 | 96.62 | 97.07 | 898000.0 |
| 2002-06-04 10:00:00 | DIA | ETF | 97.12 | 97.48 | 96.7 | 96.82 | 597900.0 |
| 2002-06-04 11:00:00 | DIA | ETF | 96.84 | 97.15 | 96.46 | 96.68 | 671400.0 |
| 2002-06-04 12:00:00 | DIA | ETF | 96.71 | 96.8 | 96.12 | 96.3 | 267600.0 |
| 2002-06-04 13:00:00 | DIA | ETF | 96.3 | 97.23 | 96.26 | 97.19 | 673400.0 |
| 2002-06-04 14:00:00 | DIA | ETF | 97.11 | 97.7 | 96.72 | 96.8 | 885400.0 |
| 2002-06-04 15:00:00 | DIA | ETF | 96.87 | 97.13 | 96.11 | 97.03 | 1141200.0 |
| 2002-06-04 16:00:00 | DIA | ETF | 97.02 | 97.19 | 96.96 | 97.18 | 73400.0 |
> showing 37 of 323 rows — these rows as CSV