PREVIEW / etf_1hour / 2002-05-10
file: by_date/etf_1hour/2002/2002-05-10.parquet size: 14 KB rows: 306
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-05-10 09:00:00 | SPY | ETF | 107.91 | 107.96 | 107.29 | 107.29 | 2089600.0 |
| 2002-05-10 10:00:00 | SPY | ETF | 107.3 | 107.35 | 106.65 | 106.92 | 3998500.0 |
| 2002-05-10 11:00:00 | SPY | ETF | 106.94 | 107.19 | 106.83 | 106.93 | 1109200.0 |
| 2002-05-10 12:00:00 | SPY | ETF | 106.92 | 107.15 | 106.38 | 106.78 | 1355800.0 |
| 2002-05-10 13:00:00 | SPY | ETF | 106.76 | 106.79 | 106.31 | 106.59 | 1837800.0 |
| 2002-05-10 14:00:00 | SPY | ETF | 106.58 | 106.88 | 106.12 | 106.14 | 1623800.0 |
| 2002-05-10 15:00:00 | SPY | ETF | 106.21 | 106.25 | 105.72 | 105.98 | 4106300.0 |
| 2002-05-10 16:00:00 | SPY | ETF | 105.88 | 107.76 | 105.52 | 105.74 | 2087500.0 |
| 2002-05-10 17:00:00 | SPY | ETF | 105.7 | 105.74 | 105.7 | 105.74 | 600.0 |
| 2002-05-10 09:00:00 | QQQ | ETF | 31.0 | 31.09 | 30.48 | 30.52 | 11799400.0 |
| 2002-05-10 10:00:00 | QQQ | ETF | 30.52 | 30.59 | 30.15 | 30.43 | 23069300.0 |
| 2002-05-10 11:00:00 | QQQ | ETF | 30.43 | 30.6 | 30.23 | 30.29 | 9908700.0 |
| 2002-05-10 12:00:00 | QQQ | ETF | 30.3 | 30.4 | 29.78 | 29.96 | 18688800.0 |
| 2002-05-10 13:00:00 | QQQ | ETF | 29.95 | 29.99 | 29.61 | 29.79 | 11247900.0 |
| 2002-05-10 14:00:00 | QQQ | ETF | 29.76 | 30.04 | 29.58 | 29.63 | 12830300.0 |
| 2002-05-10 15:00:00 | QQQ | ETF | 29.61 | 29.74 | 29.5 | 29.65 | 16940700.0 |
| 2002-05-10 16:00:00 | QQQ | ETF | 29.62 | 29.84 | 29.5 | 29.58 | 5086300.0 |
| 2002-05-10 17:00:00 | QQQ | ETF | 29.53 | 29.91 | 29.51 | 29.64 | 78400.0 |
| 2002-05-10 18:00:00 | QQQ | ETF | 29.62 | 29.68 | 29.58 | 29.65 | 23100.0 |
| 2002-05-10 09:00:00 | IWM | ETF | 50.02 | 50.02 | 49.69 | 49.69 | 445400.0 |
| 2002-05-10 10:00:00 | IWM | ETF | 49.575 | 49.625 | 49.17 | 49.34 | 269200.0 |
| 2002-05-10 11:00:00 | IWM | ETF | 49.365 | 49.45 | 49.345 | 49.445 | 118200.0 |
| 2002-05-10 12:00:00 | IWM | ETF | 49.35 | 49.445 | 49.145 | 49.25 | 299000.0 |
| 2002-05-10 13:00:00 | IWM | ETF | 49.275 | 49.275 | 49.09 | 49.15 | 52800.0 |
| 2002-05-10 14:00:00 | IWM | ETF | 49.165 | 49.325 | 48.95 | 48.95 | 147600.0 |
| 2002-05-10 15:00:00 | IWM | ETF | 49.025 | 49.105 | 48.97 | 49.095 | 99400.0 |
| 2002-05-10 16:00:00 | IWM | ETF | 49.05 | 49.065 | 49.0 | 49.065 | 45600.0 |
| 2002-05-10 09:00:00 | DIA | ETF | 100.73 | 100.75 | 100.25 | 100.25 | 947100.0 |
| 2002-05-10 10:00:00 | DIA | ETF | 100.25 | 100.35 | 99.92 | 100.24 | 1050100.0 |
| 2002-05-10 11:00:00 | DIA | ETF | 100.18 | 100.46 | 100.16 | 100.3 | 355100.0 |
| 2002-05-10 12:00:00 | DIA | ETF | 100.24 | 100.43 | 99.83 | 100.11 | 718800.0 |
| 2002-05-10 13:00:00 | DIA | ETF | 100.14 | 100.15 | 99.76 | 100.02 | 363000.0 |
| 2002-05-10 14:00:00 | DIA | ETF | 100.01 | 100.27 | 99.67 | 99.67 | 366100.0 |
| 2002-05-10 15:00:00 | DIA | ETF | 99.67 | 99.78 | 99.28 | 99.54 | 505800.0 |
| 2002-05-10 16:00:00 | DIA | ETF | 99.51 | 99.55 | 99.32 | 99.5 | 287600.0 |
> showing 35 of 306 rows — these rows as CSV