PREVIEW / etf_1hour / 2002-06-17
file: by_date/etf_1hour/2002/2002-06-17.parquet size: 14 KB rows: 304
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-17 09:00:00 | SPY | ETF | 101.92 | 102.56 | 101.85 | 102.27 | 2553200.0 |
| 2002-06-17 10:00:00 | SPY | ETF | 102.28 | 103.44 | 102.23 | 103.31 | 3473900.0 |
| 2002-06-17 11:00:00 | SPY | ETF | 103.33 | 103.84 | 103.18 | 103.65 | 2086900.0 |
| 2002-06-17 12:00:00 | SPY | ETF | 103.64 | 103.88 | 103.45 | 103.7 | 1379700.0 |
| 2002-06-17 13:00:00 | SPY | ETF | 103.68 | 103.75 | 103.31 | 103.7 | 1140600.0 |
| 2002-06-17 14:00:00 | SPY | ETF | 103.71 | 104.05 | 103.5 | 104.01 | 1623400.0 |
| 2002-06-17 15:00:00 | SPY | ETF | 104.01 | 104.29 | 103.63 | 104.19 | 3853100.0 |
| 2002-06-17 16:00:00 | SPY | ETF | 104.19 | 104.34 | 103.32 | 104.01 | 1270900.0 |
| 2002-06-17 17:00:00 | SPY | ETF | 104.05 | 104.11 | 104.04 | 104.06 | 7800.0 |
| 2002-06-17 18:00:00 | SPY | ETF | 104.1 | 104.1 | 103.91 | 103.95 | 500.0 |
| 2002-06-17 09:00:00 | QQQ | ETF | 28.0 | 28.22 | 27.91 | 28.07 | 13557900.0 |
| 2002-06-17 10:00:00 | QQQ | ETF | 28.06 | 28.59 | 28.01 | 28.49 | 18610700.0 |
| 2002-06-17 11:00:00 | QQQ | ETF | 28.51 | 28.6 | 28.31 | 28.51 | 10272000.0 |
| 2002-06-17 12:00:00 | QQQ | ETF | 28.5 | 28.68 | 28.4 | 28.58 | 7519900.0 |
| 2002-06-17 13:00:00 | QQQ | ETF | 28.58 | 28.64 | 28.42 | 28.55 | 6653400.0 |
| 2002-06-17 14:00:00 | QQQ | ETF | 28.55 | 28.75 | 28.43 | 28.65 | 9796900.0 |
| 2002-06-17 15:00:00 | QQQ | ETF | 28.65 | 28.7 | 28.31 | 28.6 | 16522100.0 |
| 2002-06-17 16:00:00 | QQQ | ETF | 28.58 | 28.63 | 28.54 | 28.57 | 2629500.0 |
| 2002-06-17 17:00:00 | QQQ | ETF | 28.57 | 28.63 | 28.54 | 28.57 | 113500.0 |
| 2002-06-17 18:00:00 | QQQ | ETF | 28.56 | 28.62 | 28.55 | 28.59 | 9700.0 |
| 2002-06-17 09:00:00 | IWM | ETF | 45.875 | 46.2 | 45.875 | 46.07 | 157200.0 |
| 2002-06-17 10:00:00 | IWM | ETF | 46.1 | 46.625 | 46.1 | 46.615 | 294000.0 |
| 2002-06-17 11:00:00 | IWM | ETF | 46.63 | 46.75 | 46.49 | 46.65 | 407000.0 |
| 2002-06-17 12:00:00 | IWM | ETF | 46.645 | 46.715 | 46.475 | 46.615 | 130800.0 |
| 2002-06-17 13:00:00 | IWM | ETF | 46.605 | 46.605 | 46.455 | 46.555 | 29400.0 |
| 2002-06-17 14:00:00 | IWM | ETF | 46.565 | 46.7 | 46.5 | 46.695 | 269000.0 |
| 2002-06-17 15:00:00 | IWM | ETF | 46.705 | 46.9 | 46.565 | 46.9 | 185000.0 |
| 2002-06-17 16:00:00 | IWM | ETF | 46.895 | 46.895 | 46.785 | 46.815 | 1400.0 |
| 2002-06-17 09:00:00 | DIA | ETF | 95.55 | 95.8 | 95.4 | 95.47 | 670100.0 |
| 2002-06-17 10:00:00 | DIA | ETF | 95.55 | 96.45 | 95.46 | 96.3 | 1219900.0 |
| 2002-06-17 11:00:00 | DIA | ETF | 96.28 | 96.86 | 96.17 | 96.67 | 538400.0 |
| 2002-06-17 12:00:00 | DIA | ETF | 96.67 | 96.8 | 96.47 | 96.68 | 260100.0 |
| 2002-06-17 13:00:00 | DIA | ETF | 96.65 | 96.76 | 96.39 | 96.72 | 182800.0 |
| 2002-06-17 14:00:00 | DIA | ETF | 96.63 | 96.99 | 96.52 | 96.95 | 223000.0 |
| 2002-06-17 15:00:00 | DIA | ETF | 97.0 | 97.19 | 96.61 | 97.1 | 469900.0 |
| 2002-06-17 16:00:00 | DIA | ETF | 97.06 | 97.2 | 97.05 | 97.07 | 72900.0 |
> showing 36 of 304 rows — these rows as CSV