PREVIEW / etf_30min / 2002-10-03
file: by_date/etf_30min/2002/2002-10-03.parquet size: 21 KB rows: 604
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-10-03 08:00:00 | SPY | ETF | 82.89 | 83.02 | 82.89 | 83.02 | 8700.0 |
| 2002-10-03 08:30:00 | SPY | ETF | 83.0 | 83.61 | 82.85 | 83.36 | 9300.0 |
| 2002-10-03 09:00:00 | SPY | ETF | 83.35 | 83.35 | 83.08 | 83.1 | 5600.0 |
| 2002-10-03 09:30:00 | SPY | ETF | 83.14 | 83.37 | 82.58 | 82.78 | 4769700.0 |
| 2002-10-03 10:00:00 | SPY | ETF | 82.83 | 84.35 | 82.73 | 83.92 | 10992300.0 |
| 2002-10-03 10:30:00 | SPY | ETF | 83.93 | 83.97 | 82.86 | 83.02 | 4824800.0 |
| 2002-10-03 11:00:00 | SPY | ETF | 83.01 | 83.18 | 82.32 | 82.56 | 4420000.0 |
| 2002-10-03 11:30:00 | SPY | ETF | 82.55 | 83.0 | 82.4 | 82.85 | 3199300.0 |
| 2002-10-03 12:00:00 | SPY | ETF | 82.92 | 82.97 | 82.35 | 82.42 | 1260100.0 |
| 2002-10-03 12:30:00 | SPY | ETF | 82.42 | 82.48 | 81.95 | 82.42 | 3299500.0 |
| 2002-10-03 13:00:00 | SPY | ETF | 82.44 | 82.64 | 81.95 | 82.11 | 2291800.0 |
| 2002-10-03 13:30:00 | SPY | ETF | 82.17 | 82.9 | 82.13 | 82.36 | 2930300.0 |
| 2002-10-03 14:00:00 | SPY | ETF | 82.38 | 83.16 | 82.1 | 82.74 | 3092700.0 |
| 2002-10-03 14:30:00 | SPY | ETF | 82.74 | 83.08 | 82.45 | 82.73 | 2565400.0 |
| 2002-10-03 15:00:00 | SPY | ETF | 82.72 | 83.3 | 82.31 | 82.46 | 4742700.0 |
| 2002-10-03 15:30:00 | SPY | ETF | 82.45 | 82.68 | 82.02 | 82.05 | 3903100.0 |
| 2002-10-03 16:00:00 | SPY | ETF | 82.05 | 82.37 | 82.04 | 82.2 | 2013600.0 |
| 2002-10-03 16:30:00 | SPY | ETF | 82.2 | 82.33 | 82.12 | 82.2 | 81800.0 |
| 2002-10-03 17:00:00 | SPY | ETF | 82.2 | 82.29 | 82.18 | 82.27 | 4600.0 |
| 2002-10-03 17:30:00 | SPY | ETF | 82.28 | 82.28 | 82.18 | 82.22 | 5500.0 |
| 2002-10-03 18:00:00 | SPY | ETF | 82.22 | 82.31 | 82.22 | 82.3 | 14800.0 |
| 2002-10-03 18:30:00 | SPY | ETF | 82.28 | 82.28 | 82.21 | 82.21 | 5200.0 |
| 2002-10-03 19:00:00 | SPY | ETF | 82.29 | 82.29 | 82.29 | 82.29 | 100.0 |
| 2002-10-03 19:30:00 | SPY | ETF | 82.28 | 82.28 | 82.28 | 82.28 | 100.0 |
| 2002-10-03 08:00:00 | QQQ | ETF | 21.02 | 21.08 | 21.02 | 21.08 | 6800.0 |
| 2002-10-03 08:30:00 | QQQ | ETF | 21.08 | 21.17 | 21.04 | 21.1 | 23400.0 |
| 2002-10-03 09:00:00 | QQQ | ETF | 21.1 | 21.1 | 21.05 | 21.08 | 10000.0 |
| 2002-10-03 09:30:00 | QQQ | ETF | 21.06 | 21.21 | 20.87 | 20.96 | 6575300.0 |
| 2002-10-03 10:00:00 | QQQ | ETF | 20.98 | 21.4 | 20.94 | 21.24 | 10919300.0 |
| 2002-10-03 10:30:00 | QQQ | ETF | 21.25 | 21.33 | 20.98 | 21.01 | 4528200.0 |
| 2002-10-03 11:00:00 | QQQ | ETF | 21.01 | 21.12 | 20.88 | 20.94 | 4333400.0 |
| 2002-10-03 11:30:00 | QQQ | ETF | 20.94 | 21.06 | 20.87 | 21.04 | 3104500.0 |
| 2002-10-03 12:00:00 | QQQ | ETF | 21.01 | 21.05 | 20.86 | 20.9 | 3647500.0 |
| 2002-10-03 12:30:00 | QQQ | ETF | 20.88 | 20.93 | 20.76 | 20.9 | 4735700.0 |
| 2002-10-03 13:00:00 | QQQ | ETF | 20.93 | 20.98 | 20.76 | 20.83 | 4331800.0 |
| 2002-10-03 13:30:00 | QQQ | ETF | 20.83 | 21.05 | 20.8 | 20.85 | 3112700.0 |
| 2002-10-03 14:00:00 | QQQ | ETF | 20.84 | 21.1 | 20.79 | 21.01 | 6359400.0 |
| 2002-10-03 14:30:00 | QQQ | ETF | 21.0 | 21.12 | 20.88 | 21.0 | 3726500.0 |
| 2002-10-03 15:00:00 | QQQ | ETF | 21.0 | 21.22 | 20.86 | 20.89 | 5796600.0 |
| 2002-10-03 15:30:00 | QQQ | ETF | 20.89 | 20.96 | 20.68 | 20.7 | 7129800.0 |
| 2002-10-03 16:00:00 | QQQ | ETF | 20.68 | 20.77 | 20.65 | 20.72 | 4101800.0 |
| 2002-10-03 16:30:00 | QQQ | ETF | 20.69 | 20.74 | 20.58 | 20.63 | 128400.0 |
| 2002-10-03 17:00:00 | QQQ | ETF | 20.62 | 20.64 | 20.58 | 20.63 | 322200.0 |
| 2002-10-03 17:30:00 | QQQ | ETF | 20.63 | 20.69 | 20.63 | 20.69 | 47400.0 |
| 2002-10-03 18:00:00 | QQQ | ETF | 20.68 | 20.75 | 20.67 | 20.7 | 53000.0 |
| 2002-10-03 18:30:00 | QQQ | ETF | 20.73 | 20.73 | 20.68 | 20.71 | 2000.0 |
| 2002-10-03 19:30:00 | QQQ | ETF | 20.7 | 20.7 | 20.7 | 20.7 | 400.0 |
| 2002-10-03 09:00:00 | IWM | ETF | 36.07 | 36.07 | 36.07 | 36.07 | 1000.0 |
| 2002-10-03 09:30:00 | IWM | ETF | 35.97 | 36.075 | 35.725 | 35.825 | 91400.0 |
| 2002-10-03 10:00:00 | IWM | ETF | 35.88 | 36.335 | 35.86 | 36.2 | 285000.0 |
> showing 50 of 604 rows — these rows as CSV