PREVIEW / etf_1hour / 2002-04-10
file: by_date/etf_1hour/2002/2002-04-10.parquet size: 14 KB rows: 308
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-04-10 09:00:00 | SPY | ETF | 112.1 | 112.55 | 112.09 | 112.37 | 1240900.0 |
| 2002-04-10 10:00:00 | SPY | ETF | 112.39 | 113.31 | 112.35 | 113.08 | 3190200.0 |
| 2002-04-10 11:00:00 | SPY | ETF | 113.08 | 113.16 | 112.61 | 112.71 | 2972500.0 |
| 2002-04-10 12:00:00 | SPY | ETF | 112.7 | 112.85 | 112.12 | 112.36 | 1673100.0 |
| 2002-04-10 13:00:00 | SPY | ETF | 112.37 | 113.1 | 112.34 | 112.89 | 1362600.0 |
| 2002-04-10 14:00:00 | SPY | ETF | 112.9 | 113.23 | 112.82 | 113.04 | 2567800.0 |
| 2002-04-10 15:00:00 | SPY | ETF | 113.05 | 113.54 | 112.8 | 113.35 | 2414900.0 |
| 2002-04-10 16:00:00 | SPY | ETF | 113.34 | 113.49 | 113.32 | 113.38 | 1104500.0 |
| 2002-04-10 17:00:00 | SPY | ETF | 113.46 | 113.49 | 113.45 | 113.45 | 7900.0 |
| 2002-04-10 18:00:00 | SPY | ETF | 113.45 | 113.48 | 113.45 | 113.48 | 3800.0 |
| 2002-04-10 09:00:00 | QQQ | ETF | 33.76 | 33.94 | 33.55 | 33.64 | 8670700.0 |
| 2002-04-10 10:00:00 | QQQ | ETF | 33.64 | 34.25 | 33.6 | 34.01 | 15486800.0 |
| 2002-04-10 11:00:00 | QQQ | ETF | 34.04 | 34.12 | 33.56 | 33.69 | 11203300.0 |
| 2002-04-10 12:00:00 | QQQ | ETF | 33.66 | 33.79 | 33.13 | 33.32 | 9145100.0 |
| 2002-04-10 13:00:00 | QQQ | ETF | 33.31 | 33.95 | 33.27 | 33.78 | 12040100.0 |
| 2002-04-10 14:00:00 | QQQ | ETF | 33.79 | 34.11 | 33.76 | 33.91 | 13918100.0 |
| 2002-04-10 15:00:00 | QQQ | ETF | 33.89 | 34.05 | 33.63 | 33.9 | 11384800.0 |
| 2002-04-10 16:00:00 | QQQ | ETF | 33.84 | 34.08 | 33.75 | 33.82 | 1650000.0 |
| 2002-04-10 17:00:00 | QQQ | ETF | 33.83 | 34.09 | 33.19 | 33.87 | 119400.0 |
| 2002-04-10 18:00:00 | QQQ | ETF | 33.87 | 34.0 | 33.86 | 33.9 | 28600.0 |
| 2002-04-10 09:00:00 | IWM | ETF | 50.25 | 50.35 | 50.17 | 50.35 | 82000.0 |
| 2002-04-10 10:00:00 | IWM | ETF | 50.35 | 50.75 | 50.35 | 50.625 | 351800.0 |
| 2002-04-10 11:00:00 | IWM | ETF | 50.61 | 50.685 | 50.44 | 50.44 | 691600.0 |
| 2002-04-10 12:00:00 | IWM | ETF | 50.44 | 50.495 | 50.32 | 50.33 | 53000.0 |
| 2002-04-10 13:00:00 | IWM | ETF | 50.335 | 50.55 | 50.335 | 50.55 | 54200.0 |
| 2002-04-10 14:00:00 | IWM | ETF | 50.57 | 50.725 | 50.5 | 50.67 | 112400.0 |
| 2002-04-10 15:00:00 | IWM | ETF | 50.695 | 50.9 | 50.5 | 50.875 | 505600.0 |
| 2002-04-10 16:00:00 | IWM | ETF | 50.83 | 50.95 | 50.83 | 50.95 | 190600.0 |
| 2002-04-10 09:00:00 | DIA | ETF | 102.42 | 102.88 | 102.36 | 102.73 | 1043500.0 |
| 2002-04-10 10:00:00 | DIA | ETF | 102.73 | 103.58 | 102.68 | 103.31 | 1574700.0 |
| 2002-04-10 11:00:00 | DIA | ETF | 103.3 | 103.38 | 103.08 | 103.33 | 291500.0 |
| 2002-04-10 12:00:00 | DIA | ETF | 103.34 | 103.45 | 102.76 | 103.01 | 536400.0 |
| 2002-04-10 13:00:00 | DIA | ETF | 102.98 | 103.59 | 102.95 | 103.41 | 934100.0 |
| 2002-04-10 14:00:00 | DIA | ETF | 103.41 | 103.78 | 103.39 | 103.66 | 937800.0 |
| 2002-04-10 15:00:00 | DIA | ETF | 103.68 | 104.13 | 103.4 | 103.94 | 1247500.0 |
| 2002-04-10 16:00:00 | DIA | ETF | 103.95 | 104.08 | 103.9 | 103.98 | 403400.0 |
| 2002-04-10 17:00:00 | DIA | ETF | 104.0 | 104.0 | 104.0 | 104.0 | 100.0 |
> showing 37 of 308 rows — these rows as CSV