PREVIEW / etf_30min / 2002-02-22
file: by_date/etf_30min/2002/2002-02-22.parquet size: 17 KB rows: 456
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-02-22 09:30:00 | SPY | ETF | 108.35 | 108.83 | 108.04 | 108.55 | 4126100.0 |
| 2002-02-22 10:00:00 | SPY | ETF | 108.5 | 108.91 | 108.25 | 108.57 | 2002800.0 |
| 2002-02-22 10:30:00 | SPY | ETF | 108.62 | 108.62 | 107.88 | 108.32 | 2482000.0 |
| 2002-02-22 11:00:00 | SPY | ETF | 108.33 | 108.5 | 108.08 | 108.44 | 1128100.0 |
| 2002-02-22 11:30:00 | SPY | ETF | 108.45 | 108.67 | 108.24 | 108.25 | 1189400.0 |
| 2002-02-22 12:00:00 | SPY | ETF | 108.22 | 108.32 | 107.87 | 108.22 | 1749200.0 |
| 2002-02-22 12:30:00 | SPY | ETF | 108.2 | 108.43 | 108.15 | 108.2 | 909400.0 |
| 2002-02-22 13:00:00 | SPY | ETF | 108.12 | 108.64 | 108.0 | 108.5 | 1646300.0 |
| 2002-02-22 13:30:00 | SPY | ETF | 108.47 | 108.57 | 108.2 | 108.31 | 595100.0 |
| 2002-02-22 14:00:00 | SPY | ETF | 108.28 | 108.75 | 108.28 | 108.56 | 701100.0 |
| 2002-02-22 14:30:00 | SPY | ETF | 108.58 | 109.65 | 108.55 | 109.61 | 3064000.0 |
| 2002-02-22 15:00:00 | SPY | ETF | 109.64 | 109.94 | 109.12 | 109.34 | 3782200.0 |
| 2002-02-22 15:30:00 | SPY | ETF | 109.28 | 109.67 | 109.0 | 109.37 | 1448300.0 |
| 2002-02-22 16:00:00 | SPY | ETF | 109.4 | 110.6 | 109.27 | 109.63 | 1064100.0 |
| 2002-02-22 16:30:00 | SPY | ETF | 109.6 | 109.65 | 109.5 | 109.5 | 32800.0 |
| 2002-02-22 09:30:00 | QQQ | ETF | 33.61 | 33.86 | 33.35 | 33.66 | 11216900.0 |
| 2002-02-22 10:00:00 | QQQ | ETF | 33.65 | 33.84 | 33.45 | 33.61 | 6773600.0 |
| 2002-02-22 10:30:00 | QQQ | ETF | 33.65 | 33.66 | 33.09 | 33.35 | 9368400.0 |
| 2002-02-22 11:00:00 | QQQ | ETF | 33.35 | 33.54 | 33.23 | 33.46 | 5570600.0 |
| 2002-02-22 11:30:00 | QQQ | ETF | 33.48 | 33.59 | 33.26 | 33.26 | 3315700.0 |
| 2002-02-22 12:00:00 | QQQ | ETF | 33.29 | 33.34 | 33.13 | 33.28 | 4462900.0 |
| 2002-02-22 12:30:00 | QQQ | ETF | 33.28 | 33.43 | 33.17 | 33.18 | 2713500.0 |
| 2002-02-22 13:00:00 | QQQ | ETF | 33.17 | 33.43 | 33.12 | 33.36 | 4532700.0 |
| 2002-02-22 13:30:00 | QQQ | ETF | 33.36 | 33.4 | 33.16 | 33.21 | 3245800.0 |
| 2002-02-22 14:00:00 | QQQ | ETF | 33.23 | 33.54 | 33.21 | 33.42 | 4866100.0 |
| 2002-02-22 14:30:00 | QQQ | ETF | 33.44 | 34.1 | 33.42 | 34.08 | 13044300.0 |
| 2002-02-22 15:00:00 | QQQ | ETF | 34.08 | 34.2 | 33.61 | 33.77 | 14105500.0 |
| 2002-02-22 15:30:00 | QQQ | ETF | 33.76 | 33.96 | 33.52 | 33.75 | 6518600.0 |
| 2002-02-22 16:00:00 | QQQ | ETF | 33.75 | 33.91 | 33.56 | 33.82 | 6258100.0 |
| 2002-02-22 16:30:00 | QQQ | ETF | 33.85 | 33.85 | 33.7 | 33.8 | 39600.0 |
| 2002-02-22 17:00:00 | QQQ | ETF | 33.8 | 33.8 | 32.84 | 33.65 | 22000.0 |
| 2002-02-22 17:30:00 | QQQ | ETF | 33.72 | 33.75 | 33.65 | 33.65 | 21300.0 |
| 2002-02-22 18:00:00 | QQQ | ETF | 33.66 | 33.79 | 33.6 | 33.73 | 17500.0 |
| 2002-02-22 09:30:00 | IWM | ETF | 45.6 | 45.825 | 45.39 | 45.65 | 61800.0 |
| 2002-02-22 10:00:00 | IWM | ETF | 45.735 | 45.745 | 45.64 | 45.745 | 68600.0 |
| 2002-02-22 10:30:00 | IWM | ETF | 45.735 | 45.735 | 45.41 | 45.5 | 94000.0 |
| 2002-02-22 11:00:00 | IWM | ETF | 45.5 | 45.585 | 45.48 | 45.585 | 35000.0 |
| 2002-02-22 11:30:00 | IWM | ETF | 45.535 | 45.635 | 45.53 | 45.615 | 109600.0 |
| 2002-02-22 12:00:00 | IWM | ETF | 45.49 | 45.56 | 45.45 | 45.555 | 30800.0 |
| 2002-02-22 12:30:00 | IWM | ETF | 45.56 | 45.7 | 45.51 | 45.68 | 158200.0 |
| 2002-02-22 13:00:00 | IWM | ETF | 45.67 | 45.75 | 45.61 | 45.75 | 67400.0 |
| 2002-02-22 13:30:00 | IWM | ETF | 45.785 | 45.785 | 45.665 | 45.725 | 22200.0 |
| 2002-02-22 14:00:00 | IWM | ETF | 45.715 | 45.765 | 45.705 | 45.765 | 67600.0 |
| 2002-02-22 14:30:00 | IWM | ETF | 45.77 | 46.255 | 45.77 | 46.255 | 173400.0 |
| 2002-02-22 15:00:00 | IWM | ETF | 46.285 | 46.325 | 46.11 | 46.125 | 326600.0 |
| 2002-02-22 15:30:00 | IWM | ETF | 46.175 | 46.25 | 46.1 | 46.25 | 97000.0 |
| 2002-02-22 16:00:00 | IWM | ETF | 46.355 | 46.375 | 46.27 | 46.27 | 11600.0 |
| 2002-02-22 09:30:00 | DIA | ETF | 98.5 | 98.85 | 98.04 | 98.6 | 1554900.0 |
| 2002-02-22 10:00:00 | DIA | ETF | 98.6 | 99.0 | 98.5 | 98.76 | 497400.0 |
| 2002-02-22 10:30:00 | DIA | ETF | 98.75 | 98.78 | 98.22 | 98.67 | 676600.0 |
> showing 50 of 456 rows — these rows as CSV