PREVIEW / etf_30min / 2002-10-22
file: by_date/etf_30min/2002/2002-10-22.parquet size: 21 KB rows: 616
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-22 08:00:00 | SPY | ETF | 89.3 | 89.3 | 89.06 | 89.18 | 8900.0 |
| 2002-10-22 08:30:00 | SPY | ETF | 89.2 | 89.27 | 89.19 | 89.27 | 4700.0 |
| 2002-10-22 09:00:00 | SPY | ETF | 89.19 | 89.25 | 89.05 | 89.15 | 23000.0 |
| 2002-10-22 09:30:00 | SPY | ETF | 89.05 | 89.35 | 88.82 | 89.04 | 5627500.0 |
| 2002-10-22 10:00:00 | SPY | ETF | 89.06 | 89.59 | 88.97 | 89.51 | 3385700.0 |
| 2002-10-22 10:30:00 | SPY | ETF | 89.53 | 90.01 | 89.5 | 89.79 | 4199000.0 |
| 2002-10-22 11:00:00 | SPY | ETF | 89.79 | 89.99 | 89.33 | 89.5 | 3041000.0 |
| 2002-10-22 11:30:00 | SPY | ETF | 89.5 | 89.58 | 89.12 | 89.45 | 1825700.0 |
| 2002-10-22 12:00:00 | SPY | ETF | 89.43 | 89.58 | 89.13 | 89.15 | 2020400.0 |
| 2002-10-22 12:30:00 | SPY | ETF | 89.17 | 89.49 | 88.96 | 89.3 | 1530800.0 |
| 2002-10-22 13:00:00 | SPY | ETF | 89.27 | 89.45 | 88.99 | 89.05 | 1317600.0 |
| 2002-10-22 13:30:00 | SPY | ETF | 89.1 | 89.1 | 88.62 | 88.79 | 2058100.0 |
| 2002-10-22 14:00:00 | SPY | ETF | 88.79 | 88.84 | 88.52 | 88.81 | 2746900.0 |
| 2002-10-22 14:30:00 | SPY | ETF | 88.79 | 89.04 | 88.64 | 88.93 | 2742500.0 |
| 2002-10-22 15:00:00 | SPY | ETF | 88.9 | 89.07 | 88.6 | 88.92 | 2454100.0 |
| 2002-10-22 15:30:00 | SPY | ETF | 88.92 | 89.48 | 88.74 | 89.37 | 3765800.0 |
| 2002-10-22 16:00:00 | SPY | ETF | 89.32 | 89.62 | 89.22 | 89.6 | 2766000.0 |
| 2002-10-22 16:30:00 | SPY | ETF | 89.62 | 89.62 | 89.34 | 89.42 | 234200.0 |
| 2002-10-22 17:00:00 | SPY | ETF | 89.51 | 89.51 | 89.3 | 89.37 | 48400.0 |
| 2002-10-22 17:30:00 | SPY | ETF | 89.4 | 89.44 | 88.65 | 89.31 | 54400.0 |
| 2002-10-22 18:00:00 | SPY | ETF | 89.39 | 89.49 | 89.39 | 89.44 | 4900.0 |
| 2002-10-22 19:00:00 | SPY | ETF | 89.5 | 89.5 | 89.5 | 89.5 | 200.0 |
| 2002-10-22 19:30:00 | SPY | ETF | 89.47 | 89.47 | 89.47 | 89.47 | 200.0 |
| 2002-10-22 08:00:00 | QQQ | ETF | 23.78 | 23.78 | 23.77 | 23.77 | 5900.0 |
| 2002-10-22 08:30:00 | QQQ | ETF | 23.75 | 23.8 | 23.75 | 23.79 | 4600.0 |
| 2002-10-22 09:00:00 | QQQ | ETF | 23.76 | 23.79 | 23.71 | 23.76 | 65300.0 |
| 2002-10-22 09:30:00 | QQQ | ETF | 23.73 | 23.89 | 23.65 | 23.73 | 9126500.0 |
| 2002-10-22 10:00:00 | QQQ | ETF | 23.73 | 24.1 | 23.71 | 24.08 | 11070500.0 |
| 2002-10-22 10:30:00 | QQQ | ETF | 24.06 | 24.34 | 24.04 | 24.21 | 12849900.0 |
| 2002-10-22 11:00:00 | QQQ | ETF | 24.2 | 24.32 | 23.93 | 24.04 | 9503300.0 |
| 2002-10-22 11:30:00 | QQQ | ETF | 24.04 | 24.08 | 23.9 | 24.02 | 6358100.0 |
| 2002-10-22 12:00:00 | QQQ | ETF | 24.03 | 24.09 | 23.94 | 24.02 | 1655900.0 |
| 2002-10-22 12:30:00 | QQQ | ETF | 24.0 | 24.09 | 23.94 | 24.04 | 2615000.0 |
| 2002-10-22 13:00:00 | QQQ | ETF | 24.04 | 24.13 | 23.93 | 23.99 | 2673900.0 |
| 2002-10-22 13:30:00 | QQQ | ETF | 23.97 | 23.99 | 23.76 | 23.81 | 4959400.0 |
| 2002-10-22 14:00:00 | QQQ | ETF | 23.81 | 23.85 | 23.66 | 23.77 | 5345300.0 |
| 2002-10-22 14:30:00 | QQQ | ETF | 23.79 | 23.9 | 23.74 | 23.85 | 4480300.0 |
| 2002-10-22 15:00:00 | QQQ | ETF | 23.89 | 23.97 | 23.79 | 23.86 | 4784700.0 |
| 2002-10-22 15:30:00 | QQQ | ETF | 23.86 | 24.01 | 23.78 | 23.95 | 7948300.0 |
| 2002-10-22 16:00:00 | QQQ | ETF | 23.92 | 24.24 | 23.92 | 24.14 | 2237500.0 |
| 2002-10-22 16:30:00 | QQQ | ETF | 24.12 | 24.17 | 24.0 | 24.09 | 303700.0 |
| 2002-10-22 17:00:00 | QQQ | ETF | 24.09 | 24.1 | 23.89 | 23.98 | 1341500.0 |
| 2002-10-22 17:30:00 | QQQ | ETF | 23.98 | 23.98 | 23.88 | 23.93 | 126200.0 |
| 2002-10-22 18:00:00 | QQQ | ETF | 23.94 | 23.99 | 23.91 | 23.95 | 126900.0 |
| 2002-10-22 18:30:00 | QQQ | ETF | 23.97 | 24.0 | 23.96 | 24.0 | 1000.0 |
| 2002-10-22 19:00:00 | QQQ | ETF | 23.98 | 23.98 | 23.98 | 23.98 | 3000.0 |
| 2002-10-22 19:30:00 | QQQ | ETF | 24.02 | 24.02 | 24.02 | 24.02 | 600.0 |
| 2002-10-22 09:30:00 | IWM | ETF | 36.35 | 36.43 | 36.16 | 36.225 | 273400.0 |
| 2002-10-22 10:00:00 | IWM | ETF | 36.205 | 36.525 | 36.205 | 36.44 | 326800.0 |
| 2002-10-22 10:30:00 | IWM | ETF | 36.51 | 36.615 | 36.42 | 36.43 | 704400.0 |
> showing 50 of 616 rows — these rows as CSV