PREVIEW / etf_1hour / 2002-03-13
file: by_date/etf_1hour/2002/2002-03-13.parquet size: 14 KB rows: 314
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-03-13 09:00:00 | SPY | ETF | 116.63 | 116.7 | 116.17 | 116.44 | 2664400.0 |
| 2002-03-13 10:00:00 | SPY | ETF | 116.37 | 116.75 | 116.32 | 116.4 | 2403800.0 |
| 2002-03-13 11:00:00 | SPY | ETF | 116.35 | 116.47 | 116.04 | 116.12 | 3444900.0 |
| 2002-03-13 12:00:00 | SPY | ETF | 116.11 | 116.34 | 115.95 | 116.22 | 871800.0 |
| 2002-03-13 13:00:00 | SPY | ETF | 116.23 | 116.4 | 115.82 | 115.97 | 1977500.0 |
| 2002-03-13 14:00:00 | SPY | ETF | 115.94 | 116.14 | 115.64 | 115.83 | 2242500.0 |
| 2002-03-13 15:00:00 | SPY | ETF | 115.79 | 116.17 | 115.75 | 115.95 | 1660200.0 |
| 2002-03-13 16:00:00 | SPY | ETF | 115.9 | 116.05 | 115.77 | 116.02 | 1081700.0 |
| 2002-03-13 17:00:00 | SPY | ETF | 116.0 | 116.05 | 115.96 | 116.05 | 600.0 |
| 2002-03-13 18:00:00 | SPY | ETF | 116.12 | 116.12 | 115.99 | 115.99 | 1100.0 |
| 2002-03-13 09:00:00 | QQQ | ETF | 37.41 | 37.54 | 37.22 | 37.33 | 11477100.0 |
| 2002-03-13 10:00:00 | QQQ | ETF | 37.34 | 37.66 | 37.27 | 37.38 | 14424000.0 |
| 2002-03-13 11:00:00 | QQQ | ETF | 37.39 | 37.45 | 37.15 | 37.18 | 8197200.0 |
| 2002-03-13 12:00:00 | QQQ | ETF | 37.18 | 37.31 | 37.06 | 37.2 | 5019900.0 |
| 2002-03-13 13:00:00 | QQQ | ETF | 37.2 | 37.36 | 36.97 | 37.05 | 7317500.0 |
| 2002-03-13 14:00:00 | QQQ | ETF | 37.05 | 37.12 | 36.87 | 36.98 | 8842600.0 |
| 2002-03-13 15:00:00 | QQQ | ETF | 36.96 | 37.17 | 36.92 | 37.02 | 10003000.0 |
| 2002-03-13 16:00:00 | QQQ | ETF | 37.03 | 37.1 | 36.98 | 37.08 | 2496200.0 |
| 2002-03-13 17:00:00 | QQQ | ETF | 37.09 | 37.14 | 37.07 | 37.11 | 71200.0 |
| 2002-03-13 18:00:00 | QQQ | ETF | 37.12 | 37.3 | 37.0 | 37.0 | 30600.0 |
| 2002-03-13 09:00:00 | IWM | ETF | 49.25 | 49.4 | 49.225 | 49.275 | 301400.0 |
| 2002-03-13 10:00:00 | IWM | ETF | 49.26 | 49.525 | 49.26 | 49.435 | 283800.0 |
| 2002-03-13 11:00:00 | IWM | ETF | 49.35 | 49.425 | 49.065 | 49.19 | 37600.0 |
| 2002-03-13 12:00:00 | IWM | ETF | 49.185 | 49.275 | 49.025 | 49.275 | 131800.0 |
| 2002-03-13 13:00:00 | IWM | ETF | 49.265 | 49.345 | 49.1 | 49.145 | 208000.0 |
| 2002-03-13 14:00:00 | IWM | ETF | 49.235 | 49.285 | 49.16 | 49.175 | 285200.0 |
| 2002-03-13 15:00:00 | IWM | ETF | 49.175 | 49.335 | 49.15 | 49.3 | 238400.0 |
| 2002-03-13 16:00:00 | IWM | ETF | 49.2 | 49.2 | 49.2 | 49.2 | 4000.0 |
| 2002-03-13 09:00:00 | DIA | ETF | 105.97 | 106.1 | 105.5 | 105.79 | 2786000.0 |
| 2002-03-13 10:00:00 | DIA | ETF | 105.84 | 106.18 | 105.72 | 105.9 | 1754200.0 |
| 2002-03-13 11:00:00 | DIA | ETF | 105.86 | 105.92 | 105.45 | 105.51 | 1751400.0 |
| 2002-03-13 12:00:00 | DIA | ETF | 105.5 | 105.74 | 105.33 | 105.58 | 562900.0 |
| 2002-03-13 13:00:00 | DIA | ETF | 105.56 | 105.75 | 105.04 | 105.19 | 775800.0 |
| 2002-03-13 14:00:00 | DIA | ETF | 105.18 | 105.39 | 104.9 | 105.11 | 874400.0 |
| 2002-03-13 15:00:00 | DIA | ETF | 105.08 | 105.4 | 105.0 | 105.26 | 505900.0 |
| 2002-03-13 16:00:00 | DIA | ETF | 105.25 | 105.32 | 105.1 | 105.32 | 104000.0 |
| 2002-03-13 18:00:00 | DIA | ETF | 105.14 | 105.14 | 105.14 | 105.14 | 200.0 |
> showing 37 of 314 rows — these rows as CSV