PREVIEW / etf_30min / 2002-10-04
file: by_date/etf_30min/2002/2002-10-04.parquet size: 21 KB rows: 608
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-04 08:00:00 | SPY | ETF | 82.29 | 82.29 | 82.29 | 82.29 | 100.0 |
| 2002-10-04 08:30:00 | SPY | ETF | 82.41 | 83.16 | 82.41 | 82.96 | 7100.0 |
| 2002-10-04 09:00:00 | SPY | ETF | 82.96 | 83.0 | 82.89 | 82.89 | 2900.0 |
| 2002-10-04 09:30:00 | SPY | ETF | 82.8 | 82.92 | 81.45 | 81.7 | 7451900.0 |
| 2002-10-04 10:00:00 | SPY | ETF | 81.75 | 81.94 | 80.96 | 81.45 | 5279000.0 |
| 2002-10-04 10:30:00 | SPY | ETF | 81.47 | 81.79 | 80.82 | 80.9 | 3846800.0 |
| 2002-10-04 11:00:00 | SPY | ETF | 80.9 | 81.2 | 80.45 | 80.64 | 2923400.0 |
| 2002-10-04 11:30:00 | SPY | ETF | 80.63 | 81.0 | 80.35 | 80.9 | 3339700.0 |
| 2002-10-04 12:00:00 | SPY | ETF | 80.92 | 81.19 | 80.7 | 80.97 | 2130600.0 |
| 2002-10-04 12:30:00 | SPY | ETF | 81.0 | 81.01 | 80.52 | 80.59 | 1420600.0 |
| 2002-10-04 13:00:00 | SPY | ETF | 80.52 | 80.64 | 80.06 | 80.16 | 4738700.0 |
| 2002-10-04 13:30:00 | SPY | ETF | 80.16 | 80.38 | 79.58 | 80.15 | 6061900.0 |
| 2002-10-04 14:00:00 | SPY | ETF | 80.14 | 80.46 | 79.81 | 79.9 | 3875800.0 |
| 2002-10-04 14:30:00 | SPY | ETF | 79.9 | 81.14 | 79.72 | 81.1 | 6991600.0 |
| 2002-10-04 15:00:00 | SPY | ETF | 81.12 | 81.55 | 79.97 | 79.99 | 10052200.0 |
| 2002-10-04 15:30:00 | SPY | ETF | 80.01 | 80.7 | 79.95 | 80.38 | 3947400.0 |
| 2002-10-04 16:00:00 | SPY | ETF | 80.35 | 81.0 | 80.31 | 80.9 | 2909700.0 |
| 2002-10-04 16:30:00 | SPY | ETF | 80.78 | 81.04 | 80.36 | 80.81 | 1111100.0 |
| 2002-10-04 17:00:00 | SPY | ETF | 80.87 | 80.91 | 80.76 | 80.91 | 5300.0 |
| 2002-10-04 17:30:00 | SPY | ETF | 80.91 | 80.92 | 80.7 | 80.7 | 5000.0 |
| 2002-10-04 18:00:00 | SPY | ETF | 80.1 | 81.65 | 79.67 | 80.76 | 235900.0 |
| 2002-10-04 19:30:00 | SPY | ETF | 80.85 | 80.91 | 80.75 | 80.75 | 800.0 |
| 2002-10-04 08:00:00 | QQQ | ETF | 20.78 | 20.86 | 20.78 | 20.86 | 10800.0 |
| 2002-10-04 08:30:00 | QQQ | ETF | 20.9 | 21.09 | 20.9 | 21.05 | 62100.0 |
| 2002-10-04 09:00:00 | QQQ | ETF | 21.0 | 21.04 | 20.94 | 20.95 | 14500.0 |
| 2002-10-04 09:30:00 | QQQ | ETF | 20.94 | 21.02 | 20.55 | 20.61 | 11130300.0 |
| 2002-10-04 10:00:00 | QQQ | ETF | 20.62 | 20.73 | 20.4 | 20.58 | 7929800.0 |
| 2002-10-04 10:30:00 | QQQ | ETF | 20.59 | 20.77 | 20.5 | 20.57 | 6536400.0 |
| 2002-10-04 11:00:00 | QQQ | ETF | 20.58 | 20.66 | 20.36 | 20.44 | 6253000.0 |
| 2002-10-04 11:30:00 | QQQ | ETF | 20.43 | 20.54 | 20.34 | 20.5 | 3742000.0 |
| 2002-10-04 12:00:00 | QQQ | ETF | 20.5 | 20.6 | 20.43 | 20.53 | 3668800.0 |
| 2002-10-04 12:30:00 | QQQ | ETF | 20.53 | 20.53 | 20.35 | 20.36 | 1810600.0 |
| 2002-10-04 13:00:00 | QQQ | ETF | 20.37 | 20.4 | 20.19 | 20.21 | 5010100.0 |
| 2002-10-04 13:30:00 | QQQ | ETF | 20.23 | 20.31 | 20.11 | 20.28 | 4941900.0 |
| 2002-10-04 14:00:00 | QQQ | ETF | 20.27 | 20.45 | 20.22 | 20.25 | 3866700.0 |
| 2002-10-04 14:30:00 | QQQ | ETF | 20.23 | 20.55 | 20.2 | 20.52 | 6206000.0 |
| 2002-10-04 15:00:00 | QQQ | ETF | 20.52 | 20.72 | 20.25 | 20.26 | 9465100.0 |
| 2002-10-04 15:30:00 | QQQ | ETF | 20.26 | 20.45 | 20.24 | 20.28 | 6658000.0 |
| 2002-10-04 16:00:00 | QQQ | ETF | 20.28 | 20.6 | 20.2 | 20.2 | 3276500.0 |
| 2002-10-04 16:30:00 | QQQ | ETF | 20.29 | 20.35 | 20.23 | 20.32 | 19100.0 |
| 2002-10-04 17:00:00 | QQQ | ETF | 20.31 | 20.36 | 20.29 | 20.34 | 48000.0 |
| 2002-10-04 17:30:00 | QQQ | ETF | 20.35 | 20.41 | 20.27 | 20.31 | 26700.0 |
| 2002-10-04 18:00:00 | QQQ | ETF | 20.32 | 20.35 | 20.3 | 20.34 | 42900.0 |
| 2002-10-04 09:30:00 | IWM | ETF | 35.875 | 35.875 | 35.175 | 35.3 | 499200.0 |
| 2002-10-04 10:00:00 | IWM | ETF | 35.3 | 35.325 | 35.06 | 35.17 | 143000.0 |
| 2002-10-04 10:30:00 | IWM | ETF | 35.175 | 35.24 | 35.02 | 35.02 | 59000.0 |
| 2002-10-04 11:00:00 | IWM | ETF | 35.04 | 35.08 | 34.83 | 34.88 | 605400.0 |
| 2002-10-04 11:30:00 | IWM | ETF | 34.925 | 34.99 | 34.795 | 34.975 | 373600.0 |
| 2002-10-04 12:00:00 | IWM | ETF | 34.975 | 35.075 | 34.905 | 34.925 | 133000.0 |
| 2002-10-04 12:30:00 | IWM | ETF | 34.955 | 34.955 | 34.81 | 34.845 | 49800.0 |
> showing 50 of 608 rows — these rows as CSV