PREVIEW / etf_1hour / 2002-06-13
file: by_date/etf_1hour/2002/2002-06-13.parquet size: 14 KB rows: 302
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-13 09:00:00 | SPY | ETF | 102.13 | 102.4 | 102.1 | 102.28 | 2067100.0 |
| 2002-06-13 10:00:00 | SPY | ETF | 102.24 | 102.31 | 101.54 | 101.88 | 3297600.0 |
| 2002-06-13 11:00:00 | SPY | ETF | 101.88 | 102.88 | 101.7 | 102.78 | 2479400.0 |
| 2002-06-13 12:00:00 | SPY | ETF | 102.75 | 103.0 | 102.35 | 102.53 | 3279900.0 |
| 2002-06-13 13:00:00 | SPY | ETF | 102.52 | 102.8 | 102.29 | 102.4 | 1480000.0 |
| 2002-06-13 14:00:00 | SPY | ETF | 102.36 | 102.47 | 101.98 | 102.26 | 1922400.0 |
| 2002-06-13 15:00:00 | SPY | ETF | 102.27 | 102.36 | 101.34 | 101.48 | 3618900.0 |
| 2002-06-13 16:00:00 | SPY | ETF | 101.49 | 101.65 | 101.13 | 101.58 | 1226100.0 |
| 2002-06-13 17:00:00 | SPY | ETF | 101.52 | 101.54 | 101.48 | 101.51 | 37000.0 |
| 2002-06-13 18:00:00 | SPY | ETF | 101.54 | 101.65 | 101.48 | 101.65 | 1500.0 |
| 2002-06-13 09:00:00 | QQQ | ETF | 27.76 | 27.93 | 27.69 | 27.79 | 10841900.0 |
| 2002-06-13 10:00:00 | QQQ | ETF | 27.77 | 27.82 | 27.35 | 27.52 | 13610600.0 |
| 2002-06-13 11:00:00 | QQQ | ETF | 27.54 | 28.16 | 27.5 | 28.08 | 13296200.0 |
| 2002-06-13 12:00:00 | QQQ | ETF | 28.06 | 28.21 | 27.83 | 27.93 | 13529100.0 |
| 2002-06-13 13:00:00 | QQQ | ETF | 27.93 | 28.19 | 27.82 | 27.93 | 9879400.0 |
| 2002-06-13 14:00:00 | QQQ | ETF | 27.93 | 27.99 | 27.6 | 27.91 | 15818100.0 |
| 2002-06-13 15:00:00 | QQQ | ETF | 27.91 | 27.97 | 27.51 | 27.55 | 12849700.0 |
| 2002-06-13 16:00:00 | QQQ | ETF | 27.55 | 27.8 | 27.52 | 27.61 | 3388600.0 |
| 2002-06-13 17:00:00 | QQQ | ETF | 27.61 | 27.63 | 27.54 | 27.57 | 116900.0 |
| 2002-06-13 18:00:00 | QQQ | ETF | 27.56 | 27.59 | 27.47 | 27.59 | 12500.0 |
| 2002-06-13 09:00:00 | IWM | ETF | 46.1 | 46.165 | 46.005 | 46.035 | 506800.0 |
| 2002-06-13 10:00:00 | IWM | ETF | 46.0 | 46.0 | 45.75 | 45.88 | 236800.0 |
| 2002-06-13 11:00:00 | IWM | ETF | 45.9 | 46.295 | 45.84 | 46.295 | 155400.0 |
| 2002-06-13 12:00:00 | IWM | ETF | 46.24 | 46.285 | 46.08 | 46.135 | 67800.0 |
| 2002-06-13 13:00:00 | IWM | ETF | 46.125 | 46.185 | 46.0 | 46.0 | 76000.0 |
| 2002-06-13 14:00:00 | IWM | ETF | 46.035 | 46.045 | 45.81 | 45.905 | 93600.0 |
| 2002-06-13 15:00:00 | IWM | ETF | 45.875 | 45.915 | 45.385 | 45.475 | 216800.0 |
| 2002-06-13 16:00:00 | IWM | ETF | 45.4 | 45.5 | 45.4 | 45.5 | 23400.0 |
| 2002-06-13 09:00:00 | DIA | ETF | 96.06 | 96.24 | 95.85 | 96.06 | 349800.0 |
| 2002-06-13 10:00:00 | DIA | ETF | 96.06 | 96.09 | 95.26 | 95.66 | 661000.0 |
| 2002-06-13 11:00:00 | DIA | ETF | 95.69 | 96.56 | 95.5 | 96.45 | 788500.0 |
| 2002-06-13 12:00:00 | DIA | ETF | 96.44 | 96.56 | 95.91 | 96.1 | 589400.0 |
| 2002-06-13 13:00:00 | DIA | ETF | 96.1 | 96.38 | 95.8 | 96.02 | 282000.0 |
| 2002-06-13 14:00:00 | DIA | ETF | 96.07 | 96.11 | 95.66 | 95.96 | 417900.0 |
| 2002-06-13 15:00:00 | DIA | ETF | 95.95 | 96.05 | 95.1 | 95.18 | 483900.0 |
| 2002-06-13 16:00:00 | DIA | ETF | 95.17 | 95.38 | 95.17 | 95.38 | 39500.0 |
| 2002-06-13 17:00:00 | DIA | ETF | 95.23 | 95.23 | 95.23 | 95.23 | 10000.0 |
> showing 37 of 302 rows — these rows as CSV