PREVIEW / etf_1hour / 2002-07-12
file: by_date/etf_1hour/2002/2002-07-12.parquet size: 14 KB rows: 321
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-07-12 09:00:00 | SPY | ETF | 93.33 | 93.54 | 91.55 | 92.29 | 5659400.0 |
| 2002-07-12 10:00:00 | SPY | ETF | 92.3 | 93.89 | 92.1 | 93.56 | 8699600.0 |
| 2002-07-12 11:00:00 | SPY | ETF | 93.56 | 93.69 | 92.83 | 93.02 | 3723400.0 |
| 2002-07-12 12:00:00 | SPY | ETF | 93.06 | 93.65 | 92.78 | 93.61 | 1574800.0 |
| 2002-07-12 13:00:00 | SPY | ETF | 93.66 | 93.69 | 93.0 | 93.06 | 1658500.0 |
| 2002-07-12 14:00:00 | SPY | ETF | 93.1 | 93.19 | 91.52 | 92.07 | 5491500.0 |
| 2002-07-12 15:00:00 | SPY | ETF | 92.11 | 92.69 | 91.68 | 92.46 | 6161900.0 |
| 2002-07-12 16:00:00 | SPY | ETF | 92.46 | 93.06 | 91.81 | 91.99 | 3517500.0 |
| 2002-07-12 17:00:00 | SPY | ETF | 91.85 | 92.67 | 91.5 | 91.62 | 814900.0 |
| 2002-07-12 18:00:00 | SPY | ETF | 91.6 | 91.6 | 91.6 | 91.6 | 100.0 |
| 2002-07-12 09:00:00 | QQQ | ETF | 25.25 | 25.32 | 24.55 | 24.86 | 23561900.0 |
| 2002-07-12 10:00:00 | QQQ | ETF | 24.86 | 25.52 | 24.73 | 25.44 | 32147300.0 |
| 2002-07-12 11:00:00 | QQQ | ETF | 25.44 | 25.47 | 25.02 | 25.12 | 13143300.0 |
| 2002-07-12 12:00:00 | QQQ | ETF | 25.09 | 25.33 | 24.93 | 25.32 | 7290800.0 |
| 2002-07-12 13:00:00 | QQQ | ETF | 25.3 | 25.34 | 25.04 | 25.16 | 8395700.0 |
| 2002-07-12 14:00:00 | QQQ | ETF | 25.16 | 25.22 | 24.55 | 24.74 | 18998800.0 |
| 2002-07-12 15:00:00 | QQQ | ETF | 24.73 | 25.05 | 24.55 | 24.85 | 17372400.0 |
| 2002-07-12 16:00:00 | QQQ | ETF | 24.85 | 25.06 | 24.71 | 24.75 | 6356800.0 |
| 2002-07-12 17:00:00 | QQQ | ETF | 24.75 | 24.8 | 24.71 | 24.75 | 52800.0 |
| 2002-07-12 18:00:00 | QQQ | ETF | 24.73 | 24.75 | 24.73 | 24.75 | 2200.0 |
| 2002-07-12 09:00:00 | IWM | ETF | 41.3 | 41.75 | 41.285 | 41.4 | 276400.0 |
| 2002-07-12 10:00:00 | IWM | ETF | 41.435 | 41.975 | 41.415 | 41.93 | 500200.0 |
| 2002-07-12 11:00:00 | IWM | ETF | 41.925 | 42.09 | 41.75 | 41.775 | 322200.0 |
| 2002-07-12 12:00:00 | IWM | ETF | 41.8 | 41.95 | 41.625 | 41.79 | 600800.0 |
| 2002-07-12 13:00:00 | IWM | ETF | 41.8 | 41.875 | 41.63 | 41.64 | 437600.0 |
| 2002-07-12 14:00:00 | IWM | ETF | 41.625 | 41.68 | 40.95 | 40.95 | 485400.0 |
| 2002-07-12 15:00:00 | IWM | ETF | 41.025 | 41.305 | 40.96 | 41.2 | 341200.0 |
| 2002-07-12 16:00:00 | IWM | ETF | 41.05 | 41.05 | 41.025 | 41.025 | 23000.0 |
| 2002-07-12 18:00:00 | IWM | ETF | 41.2 | 41.2 | 41.2 | 41.2 | 1262000.0 |
| 2002-07-12 09:00:00 | DIA | ETF | 88.5 | 88.7 | 86.4 | 87.01 | 1258300.0 |
| 2002-07-12 10:00:00 | DIA | ETF | 87.03 | 88.69 | 87.0 | 88.47 | 2521600.0 |
| 2002-07-12 11:00:00 | DIA | ETF | 88.42 | 88.52 | 87.45 | 87.69 | 751900.0 |
| 2002-07-12 12:00:00 | DIA | ETF | 87.69 | 88.19 | 87.45 | 88.1 | 261800.0 |
| 2002-07-12 13:00:00 | DIA | ETF | 88.1 | 88.18 | 87.55 | 87.6 | 220300.0 |
| 2002-07-12 14:00:00 | DIA | ETF | 87.67 | 87.78 | 86.11 | 86.65 | 1307300.0 |
| 2002-07-12 15:00:00 | DIA | ETF | 86.64 | 87.35 | 86.23 | 87.0 | 1669600.0 |
| 2002-07-12 16:00:00 | DIA | ETF | 86.95 | 87.35 | 86.6 | 86.6 | 158100.0 |
| 2002-07-12 17:00:00 | DIA | ETF | 86.72 | 86.72 | 86.72 | 86.72 | 100.0 |
| 2002-07-12 18:00:00 | DIA | ETF | 86.75 | 86.75 | 86.75 | 86.75 | 100.0 |
> showing 39 of 321 rows — these rows as CSV