PREVIEW / etf_30min / 2002-10-23
file: by_date/etf_30min/2002/2002-10-23.parquet size: 21 KB rows: 607
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-23 09:00:00 | SPY | ETF | 88.77 | 88.77 | 88.71 | 88.71 | 2000.0 |
| 2002-10-23 09:30:00 | SPY | ETF | 88.77 | 89.5 | 88.58 | 89.25 | 5949200.0 |
| 2002-10-23 10:00:00 | SPY | ETF | 89.3 | 89.31 | 88.1 | 88.62 | 5512800.0 |
| 2002-10-23 10:30:00 | SPY | ETF | 88.63 | 88.64 | 87.95 | 88.29 | 3737700.0 |
| 2002-10-23 11:00:00 | SPY | ETF | 88.28 | 88.45 | 87.98 | 88.13 | 2701800.0 |
| 2002-10-23 11:30:00 | SPY | ETF | 88.12 | 88.26 | 87.77 | 87.8 | 2811600.0 |
| 2002-10-23 12:00:00 | SPY | ETF | 87.88 | 88.01 | 87.68 | 87.96 | 2327500.0 |
| 2002-10-23 12:30:00 | SPY | ETF | 88.0 | 88.26 | 87.7 | 88.26 | 2527000.0 |
| 2002-10-23 13:00:00 | SPY | ETF | 88.25 | 88.38 | 87.96 | 88.0 | 1566900.0 |
| 2002-10-23 13:30:00 | SPY | ETF | 87.98 | 88.37 | 87.95 | 88.37 | 1275600.0 |
| 2002-10-23 14:00:00 | SPY | ETF | 88.37 | 89.35 | 87.9 | 89.26 | 4895800.0 |
| 2002-10-23 14:30:00 | SPY | ETF | 89.25 | 89.75 | 88.92 | 89.45 | 5248400.0 |
| 2002-10-23 15:00:00 | SPY | ETF | 89.41 | 89.58 | 89.0 | 89.06 | 4521300.0 |
| 2002-10-23 15:30:00 | SPY | ETF | 89.06 | 89.99 | 89.05 | 89.97 | 4538200.0 |
| 2002-10-23 16:00:00 | SPY | ETF | 89.93 | 90.3 | 89.91 | 90.15 | 2982200.0 |
| 2002-10-23 16:30:00 | SPY | ETF | 90.19 | 90.5 | 90.15 | 90.36 | 285800.0 |
| 2002-10-23 17:00:00 | SPY | ETF | 90.36 | 90.41 | 90.35 | 90.38 | 31700.0 |
| 2002-10-23 17:30:00 | SPY | ETF | 90.38 | 90.45 | 87.97 | 90.45 | 111000.0 |
| 2002-10-23 18:00:00 | SPY | ETF | 90.45 | 90.49 | 90.43 | 90.43 | 15200.0 |
| 2002-10-23 19:30:00 | SPY | ETF | 90.55 | 90.55 | 90.55 | 90.55 | 1000.0 |
| 2002-10-23 08:00:00 | QQQ | ETF | 23.81 | 23.81 | 23.81 | 23.81 | 100.0 |
| 2002-10-23 08:30:00 | QQQ | ETF | 23.8 | 23.81 | 23.8 | 23.81 | 4200.0 |
| 2002-10-23 09:00:00 | QQQ | ETF | 23.81 | 23.85 | 23.8 | 23.85 | 24100.0 |
| 2002-10-23 09:30:00 | QQQ | ETF | 23.85 | 24.2 | 23.8 | 24.06 | 12222000.0 |
| 2002-10-23 10:00:00 | QQQ | ETF | 24.08 | 24.11 | 23.69 | 23.94 | 8389500.0 |
| 2002-10-23 10:30:00 | QQQ | ETF | 23.94 | 23.97 | 23.73 | 23.88 | 4366900.0 |
| 2002-10-23 11:00:00 | QQQ | ETF | 23.89 | 23.94 | 23.77 | 23.88 | 3107700.0 |
| 2002-10-23 11:30:00 | QQQ | ETF | 23.86 | 23.89 | 23.7 | 23.73 | 2694100.0 |
| 2002-10-23 12:00:00 | QQQ | ETF | 23.73 | 23.83 | 23.67 | 23.81 | 3314000.0 |
| 2002-10-23 12:30:00 | QQQ | ETF | 23.82 | 23.96 | 23.74 | 23.95 | 3264100.0 |
| 2002-10-23 13:00:00 | QQQ | ETF | 23.95 | 23.99 | 23.82 | 23.86 | 3573700.0 |
| 2002-10-23 13:30:00 | QQQ | ETF | 23.86 | 24.08 | 23.82 | 24.07 | 4434900.0 |
| 2002-10-23 14:00:00 | QQQ | ETF | 24.07 | 24.34 | 23.9 | 24.32 | 9834500.0 |
| 2002-10-23 14:30:00 | QQQ | ETF | 24.31 | 24.56 | 24.23 | 24.45 | 10137500.0 |
| 2002-10-23 15:00:00 | QQQ | ETF | 24.45 | 24.55 | 24.22 | 24.25 | 8367300.0 |
| 2002-10-23 15:30:00 | QQQ | ETF | 24.27 | 24.63 | 23.81 | 24.59 | 9765000.0 |
| 2002-10-23 16:00:00 | QQQ | ETF | 24.58 | 24.62 | 24.51 | 24.6 | 1796700.0 |
| 2002-10-23 16:30:00 | QQQ | ETF | 24.62 | 24.78 | 24.58 | 24.7 | 514500.0 |
| 2002-10-23 17:00:00 | QQQ | ETF | 24.71 | 24.76 | 24.3 | 24.71 | 278700.0 |
| 2002-10-23 17:30:00 | QQQ | ETF | 24.7 | 24.75 | 24.68 | 24.75 | 96000.0 |
| 2002-10-23 18:00:00 | QQQ | ETF | 24.75 | 24.75 | 24.7 | 24.75 | 48900.0 |
| 2002-10-23 18:30:00 | QQQ | ETF | 24.73 | 24.73 | 24.73 | 24.73 | 200.0 |
| 2002-10-23 19:00:00 | QQQ | ETF | 24.75 | 24.75 | 24.75 | 24.75 | 200.0 |
| 2002-10-23 19:30:00 | QQQ | ETF | 24.75 | 24.75 | 24.75 | 24.75 | 400.0 |
| 2002-10-23 09:30:00 | IWM | ETF | 36.0 | 36.37 | 35.855 | 36.275 | 380400.0 |
| 2002-10-23 10:00:00 | IWM | ETF | 36.315 | 36.315 | 35.97 | 36.09 | 187800.0 |
| 2002-10-23 10:30:00 | IWM | ETF | 36.0 | 36.05 | 35.825 | 35.855 | 461600.0 |
| 2002-10-23 11:00:00 | IWM | ETF | 35.875 | 36.01 | 35.815 | 35.885 | 110200.0 |
| 2002-10-23 11:30:00 | IWM | ETF | 35.885 | 35.885 | 35.825 | 35.86 | 87200.0 |
| 2002-10-23 12:00:00 | IWM | ETF | 35.8 | 35.895 | 35.8 | 35.875 | 49600.0 |
> showing 50 of 607 rows — these rows as CSV