PREVIEW / etf_30min / 2002-10-24
file: by_date/etf_30min/2002/2002-10-24.parquet size: 22 KB rows: 637
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-24 08:00:00 | SPY | ETF | 89.95 | 90.05 | 89.9 | 90.05 | 2800.0 |
| 2002-10-24 08:30:00 | SPY | ETF | 90.11 | 90.53 | 90.11 | 90.5 | 46200.0 |
| 2002-10-24 09:00:00 | SPY | ETF | 90.6 | 90.7 | 90.6 | 90.64 | 5500.0 |
| 2002-10-24 09:30:00 | SPY | ETF | 90.75 | 90.9 | 89.94 | 90.55 | 6398300.0 |
| 2002-10-24 10:00:00 | SPY | ETF | 90.55 | 90.69 | 89.67 | 89.84 | 5378300.0 |
| 2002-10-24 10:30:00 | SPY | ETF | 89.86 | 90.54 | 89.69 | 90.26 | 3323700.0 |
| 2002-10-24 11:00:00 | SPY | ETF | 90.25 | 90.42 | 89.85 | 90.33 | 2121600.0 |
| 2002-10-24 11:30:00 | SPY | ETF | 90.34 | 90.62 | 90.03 | 90.15 | 2320500.0 |
| 2002-10-24 12:00:00 | SPY | ETF | 90.11 | 90.31 | 89.92 | 89.92 | 1523100.0 |
| 2002-10-24 12:30:00 | SPY | ETF | 90.0 | 90.4 | 89.88 | 90.21 | 2141500.0 |
| 2002-10-24 13:00:00 | SPY | ETF | 90.29 | 90.29 | 90.0 | 90.15 | 1318100.0 |
| 2002-10-24 13:30:00 | SPY | ETF | 90.18 | 90.21 | 89.55 | 89.75 | 4182700.0 |
| 2002-10-24 14:00:00 | SPY | ETF | 89.77 | 89.82 | 89.32 | 89.5 | 2196400.0 |
| 2002-10-24 14:30:00 | SPY | ETF | 89.5 | 89.52 | 88.56 | 88.77 | 4123400.0 |
| 2002-10-24 15:00:00 | SPY | ETF | 88.77 | 88.94 | 88.41 | 88.51 | 3913900.0 |
| 2002-10-24 15:30:00 | SPY | ETF | 88.52 | 88.71 | 88.1 | 88.6 | 6271100.0 |
| 2002-10-24 16:00:00 | SPY | ETF | 88.58 | 88.72 | 88.19 | 88.29 | 2508000.0 |
| 2002-10-24 16:30:00 | SPY | ETF | 88.23 | 88.41 | 88.2 | 88.35 | 35800.0 |
| 2002-10-24 17:00:00 | SPY | ETF | 90.49 | 90.49 | 88.27 | 88.43 | 45300.0 |
| 2002-10-24 17:30:00 | SPY | ETF | 88.36 | 88.38 | 88.29 | 88.29 | 4100.0 |
| 2002-10-24 18:00:00 | SPY | ETF | 88.32 | 88.38 | 88.3 | 88.33 | 3800.0 |
| 2002-10-24 18:30:00 | SPY | ETF | 88.3 | 88.3 | 88.28 | 88.28 | 300.0 |
| 2002-10-24 19:00:00 | SPY | ETF | 88.28 | 88.28 | 88.28 | 88.28 | 200.0 |
| 2002-10-24 19:30:00 | SPY | ETF | 88.21 | 88.21 | 88.09 | 88.09 | 1800.0 |
| 2002-10-24 08:00:00 | QQQ | ETF | 24.5 | 24.51 | 24.47 | 24.51 | 6800.0 |
| 2002-10-24 08:30:00 | QQQ | ETF | 24.67 | 24.69 | 24.58 | 24.69 | 33500.0 |
| 2002-10-24 09:00:00 | QQQ | ETF | 24.71 | 24.71 | 24.66 | 24.7 | 8400.0 |
| 2002-10-24 09:30:00 | QQQ | ETF | 24.68 | 24.8 | 24.44 | 24.71 | 12052900.0 |
| 2002-10-24 10:00:00 | QQQ | ETF | 24.74 | 24.75 | 24.33 | 24.46 | 8107800.0 |
| 2002-10-24 10:30:00 | QQQ | ETF | 24.46 | 24.71 | 24.42 | 24.65 | 7424100.0 |
| 2002-10-24 11:00:00 | QQQ | ETF | 24.65 | 24.74 | 24.49 | 24.7 | 7132800.0 |
| 2002-10-24 11:30:00 | QQQ | ETF | 24.7 | 24.86 | 24.6 | 24.62 | 6204000.0 |
| 2002-10-24 12:00:00 | QQQ | ETF | 24.61 | 24.69 | 24.52 | 24.53 | 3855100.0 |
| 2002-10-24 12:30:00 | QQQ | ETF | 24.55 | 24.7 | 24.49 | 24.65 | 3673700.0 |
| 2002-10-24 13:00:00 | QQQ | ETF | 24.65 | 24.72 | 24.51 | 24.59 | 2892600.0 |
| 2002-10-24 13:30:00 | QQQ | ETF | 24.58 | 24.62 | 24.33 | 24.43 | 5722600.0 |
| 2002-10-24 14:00:00 | QQQ | ETF | 24.43 | 24.48 | 24.25 | 24.4 | 5735500.0 |
| 2002-10-24 14:30:00 | QQQ | ETF | 24.39 | 24.42 | 24.1 | 24.16 | 8043800.0 |
| 2002-10-24 15:00:00 | QQQ | ETF | 24.17 | 24.27 | 24.01 | 24.05 | 5835100.0 |
| 2002-10-24 15:30:00 | QQQ | ETF | 24.03 | 24.14 | 23.92 | 24.0 | 7117800.0 |
| 2002-10-24 16:00:00 | QQQ | ETF | 24.0 | 24.09 | 23.95 | 24.0 | 2495800.0 |
| 2002-10-24 16:30:00 | QQQ | ETF | 23.97 | 24.08 | 23.94 | 24.02 | 234000.0 |
| 2002-10-24 17:00:00 | QQQ | ETF | 24.03 | 24.06 | 23.99 | 24.01 | 21800.0 |
| 2002-10-24 17:30:00 | QQQ | ETF | 24.01 | 24.02 | 23.98 | 23.99 | 75100.0 |
| 2002-10-24 18:00:00 | QQQ | ETF | 23.98 | 24.07 | 23.98 | 24.07 | 37700.0 |
| 2002-10-24 18:30:00 | QQQ | ETF | 24.01 | 24.04 | 24.01 | 24.01 | 1700.0 |
| 2002-10-24 19:00:00 | QQQ | ETF | 24.01 | 24.01 | 24.0 | 24.0 | 1600.0 |
| 2002-10-24 19:30:00 | QQQ | ETF | 23.98 | 23.98 | 23.96 | 23.96 | 3200.0 |
| 2002-10-24 09:30:00 | IWM | ETF | 36.95 | 36.95 | 36.73 | 36.935 | 979000.0 |
| 2002-10-24 10:00:00 | IWM | ETF | 36.975 | 37.05 | 36.775 | 36.875 | 778200.0 |
> showing 50 of 637 rows — these rows as CSV