PREVIEW / etf_30min / 2002-10-30
file: by_date/etf_30min/2002/2002-10-30.parquet size: 21 KB rows: 595
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-30 08:00:00 | SPY | ETF | 88.66 | 88.66 | 88.66 | 88.66 | 100.0 |
| 2002-10-30 08:30:00 | SPY | ETF | 88.79 | 88.8 | 88.67 | 88.67 | 4100.0 |
| 2002-10-30 09:00:00 | SPY | ETF | 88.72 | 88.78 | 88.72 | 88.78 | 1000.0 |
| 2002-10-30 09:30:00 | SPY | ETF | 88.68 | 88.99 | 88.23 | 88.24 | 4126100.0 |
| 2002-10-30 10:00:00 | SPY | ETF | 88.28 | 89.1 | 88.23 | 88.8 | 2876900.0 |
| 2002-10-30 10:30:00 | SPY | ETF | 88.8 | 89.4 | 88.77 | 89.25 | 2956000.0 |
| 2002-10-30 11:00:00 | SPY | ETF | 89.22 | 89.96 | 89.17 | 89.7 | 3425800.0 |
| 2002-10-30 11:30:00 | SPY | ETF | 89.7 | 89.74 | 89.41 | 89.44 | 2440800.0 |
| 2002-10-30 12:00:00 | SPY | ETF | 89.41 | 89.76 | 89.28 | 89.58 | 2013200.0 |
| 2002-10-30 12:30:00 | SPY | ETF | 89.63 | 89.68 | 89.3 | 89.68 | 1588500.0 |
| 2002-10-30 13:00:00 | SPY | ETF | 89.66 | 89.76 | 89.25 | 89.38 | 1697500.0 |
| 2002-10-30 13:30:00 | SPY | ETF | 89.38 | 89.64 | 88.91 | 89.15 | 2622500.0 |
| 2002-10-30 14:00:00 | SPY | ETF | 89.13 | 89.15 | 88.62 | 88.94 | 3464300.0 |
| 2002-10-30 14:30:00 | SPY | ETF | 88.89 | 89.34 | 88.83 | 89.27 | 2016600.0 |
| 2002-10-30 15:00:00 | SPY | ETF | 89.26 | 89.78 | 88.9 | 89.65 | 2267900.0 |
| 2002-10-30 15:30:00 | SPY | ETF | 89.75 | 89.78 | 89.1 | 89.45 | 3195300.0 |
| 2002-10-30 16:00:00 | SPY | ETF | 89.41 | 89.68 | 89.24 | 89.42 | 2649300.0 |
| 2002-10-30 16:30:00 | SPY | ETF | 89.49 | 89.55 | 89.25 | 89.42 | 20000.0 |
| 2002-10-30 17:00:00 | SPY | ETF | 89.3 | 89.78 | 89.25 | 89.34 | 205600.0 |
| 2002-10-30 17:30:00 | SPY | ETF | 89.25 | 89.3 | 89.12 | 89.27 | 14500.0 |
| 2002-10-30 18:00:00 | SPY | ETF | 89.27 | 89.27 | 89.22 | 89.24 | 3600.0 |
| 2002-10-30 18:30:00 | SPY | ETF | 89.23 | 89.23 | 89.23 | 89.23 | 800.0 |
| 2002-10-30 08:00:00 | QQQ | ETF | 24.04 | 24.05 | 24.04 | 24.05 | 400.0 |
| 2002-10-30 08:30:00 | QQQ | ETF | 24.05 | 24.09 | 24.05 | 24.06 | 6900.0 |
| 2002-10-30 09:00:00 | QQQ | ETF | 24.05 | 24.07 | 24.02 | 24.07 | 9400.0 |
| 2002-10-30 09:30:00 | QQQ | ETF | 24.06 | 24.14 | 23.85 | 23.92 | 10684900.0 |
| 2002-10-30 10:00:00 | QQQ | ETF | 23.92 | 24.22 | 23.9 | 24.17 | 6473500.0 |
| 2002-10-30 10:30:00 | QQQ | ETF | 24.12 | 24.42 | 24.11 | 24.35 | 6719000.0 |
| 2002-10-30 11:00:00 | QQQ | ETF | 24.35 | 24.79 | 24.34 | 24.59 | 19244600.0 |
| 2002-10-30 11:30:00 | QQQ | ETF | 24.6 | 24.64 | 24.48 | 24.51 | 4909800.0 |
| 2002-10-30 12:00:00 | QQQ | ETF | 24.49 | 24.65 | 24.45 | 24.63 | 7277700.0 |
| 2002-10-30 12:30:00 | QQQ | ETF | 24.62 | 24.7 | 24.53 | 24.7 | 4142900.0 |
| 2002-10-30 13:00:00 | QQQ | ETF | 24.68 | 24.7 | 24.46 | 24.55 | 5386400.0 |
| 2002-10-30 13:30:00 | QQQ | ETF | 24.54 | 24.64 | 24.41 | 24.45 | 4006000.0 |
| 2002-10-30 14:00:00 | QQQ | ETF | 24.45 | 24.47 | 24.26 | 24.44 | 6093100.0 |
| 2002-10-30 14:30:00 | QQQ | ETF | 24.42 | 24.61 | 24.41 | 24.58 | 4296600.0 |
| 2002-10-30 15:00:00 | QQQ | ETF | 24.59 | 24.75 | 24.46 | 24.71 | 5570800.0 |
| 2002-10-30 15:30:00 | QQQ | ETF | 24.7 | 24.75 | 24.44 | 24.54 | 6369800.0 |
| 2002-10-30 16:00:00 | QQQ | ETF | 24.52 | 24.6 | 24.47 | 24.59 | 2388600.0 |
| 2002-10-30 16:30:00 | QQQ | ETF | 24.57 | 24.6 | 24.51 | 24.54 | 117700.0 |
| 2002-10-30 17:00:00 | QQQ | ETF | 24.54 | 24.55 | 24.5 | 24.54 | 154400.0 |
| 2002-10-30 17:30:00 | QQQ | ETF | 24.52 | 24.54 | 24.52 | 24.54 | 24400.0 |
| 2002-10-30 18:00:00 | QQQ | ETF | 24.54 | 24.58 | 24.52 | 24.54 | 25900.0 |
| 2002-10-30 18:30:00 | QQQ | ETF | 24.54 | 24.57 | 24.54 | 24.57 | 9800.0 |
| 2002-10-30 19:00:00 | QQQ | ETF | 24.54 | 24.54 | 24.51 | 24.51 | 1900.0 |
| 2002-10-30 09:30:00 | IWM | ETF | 37.0 | 37.0 | 36.72 | 36.72 | 275600.0 |
| 2002-10-30 10:00:00 | IWM | ETF | 36.795 | 37.0 | 36.725 | 36.94 | 230800.0 |
| 2002-10-30 10:30:00 | IWM | ETF | 36.97 | 37.21 | 36.915 | 37.11 | 102000.0 |
| 2002-10-30 11:00:00 | IWM | ETF | 37.2 | 37.365 | 37.155 | 37.29 | 85200.0 |
| 2002-10-30 11:30:00 | IWM | ETF | 37.305 | 37.345 | 37.21 | 37.225 | 106200.0 |
> showing 50 of 595 rows — these rows as CSV