PREVIEW / etf_30min / 2003-05-29
file: by_date/etf_30min/2003/2003-05-29.parquet size: 24 KB rows: 728
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-29 08:00:00 | SPY | ETF | 95.86 | 96.0 | 95.82 | 95.94 | 65500.0 |
| 2003-05-29 08:30:00 | SPY | ETF | 95.93 | 96.11 | 95.89 | 96.03 | 130900.0 |
| 2003-05-29 09:00:00 | SPY | ETF | 96.05 | 96.05 | 95.89 | 95.89 | 26300.0 |
| 2003-05-29 09:30:00 | SPY | ETF | 95.88 | 96.52 | 95.7 | 96.42 | 5065400.0 |
| 2003-05-29 10:00:00 | SPY | ETF | 96.41 | 96.6 | 96.2 | 96.6 | 4765800.0 |
| 2003-05-29 10:30:00 | SPY | ETF | 96.6 | 96.74 | 96.36 | 96.39 | 3017600.0 |
| 2003-05-29 11:00:00 | SPY | ETF | 96.37 | 96.57 | 96.32 | 96.5 | 2823800.0 |
| 2003-05-29 11:30:00 | SPY | ETF | 96.53 | 96.66 | 96.41 | 96.55 | 1134200.0 |
| 2003-05-29 12:00:00 | SPY | ETF | 96.55 | 96.64 | 96.3 | 96.36 | 909500.0 |
| 2003-05-29 12:30:00 | SPY | ETF | 96.3 | 96.5 | 95.94 | 95.98 | 3922600.0 |
| 2003-05-29 13:00:00 | SPY | ETF | 95.98 | 96.06 | 95.33 | 95.43 | 4156500.0 |
| 2003-05-29 13:30:00 | SPY | ETF | 95.42 | 95.65 | 95.27 | 95.5 | 4348700.0 |
| 2003-05-29 14:00:00 | SPY | ETF | 95.48 | 95.84 | 95.43 | 95.72 | 6110600.0 |
| 2003-05-29 14:30:00 | SPY | ETF | 95.73 | 95.92 | 95.63 | 95.68 | 1984600.0 |
| 2003-05-29 15:00:00 | SPY | ETF | 95.62 | 95.68 | 95.08 | 95.24 | 4938500.0 |
| 2003-05-29 15:30:00 | SPY | ETF | 95.23 | 95.48 | 95.17 | 95.37 | 3474600.0 |
| 2003-05-29 16:00:00 | SPY | ETF | 95.37 | 95.5 | 95.27 | 95.43 | 1501600.0 |
| 2003-05-29 16:30:00 | SPY | ETF | 95.47 | 95.48 | 95.37 | 95.4 | 6800.0 |
| 2003-05-29 17:00:00 | SPY | ETF | 95.46 | 96.55 | 95.43 | 95.43 | 36300.0 |
| 2003-05-29 17:30:00 | SPY | ETF | 95.36 | 95.48 | 95.32 | 95.42 | 104200.0 |
| 2003-05-29 18:00:00 | SPY | ETF | 95.42 | 95.45 | 95.39 | 95.42 | 16400.0 |
| 2003-05-29 18:30:00 | SPY | ETF | 95.42 | 95.45 | 95.42 | 95.45 | 2200.0 |
| 2003-05-29 19:00:00 | SPY | ETF | 95.45 | 95.45 | 95.45 | 95.45 | 1900.0 |
| 2003-05-29 19:30:00 | SPY | ETF | 95.45 | 95.49 | 95.45 | 95.49 | 400.0 |
| 2003-05-29 08:00:00 | QQQ | ETF | 29.16 | 29.24 | 29.15 | 29.24 | 13900.0 |
| 2003-05-29 08:30:00 | QQQ | ETF | 29.23 | 29.31 | 29.22 | 29.27 | 61600.0 |
| 2003-05-29 09:00:00 | QQQ | ETF | 29.27 | 29.3 | 29.22 | 29.23 | 81900.0 |
| 2003-05-29 09:30:00 | QQQ | ETF | 29.23 | 29.46 | 29.16 | 29.43 | 8417400.0 |
| 2003-05-29 10:00:00 | QQQ | ETF | 29.45 | 29.63 | 29.32 | 29.61 | 10480800.0 |
| 2003-05-29 10:30:00 | QQQ | ETF | 29.63 | 29.77 | 29.56 | 29.63 | 10610700.0 |
| 2003-05-29 11:00:00 | QQQ | ETF | 29.63 | 29.72 | 29.62 | 29.69 | 5595300.0 |
| 2003-05-29 11:30:00 | QQQ | ETF | 29.7 | 29.78 | 29.66 | 29.75 | 5152700.0 |
| 2003-05-29 12:00:00 | QQQ | ETF | 29.74 | 29.8 | 29.65 | 29.69 | 3323400.0 |
| 2003-05-29 12:30:00 | QQQ | ETF | 29.66 | 29.69 | 29.45 | 29.5 | 8156000.0 |
| 2003-05-29 13:00:00 | QQQ | ETF | 29.5 | 29.53 | 29.27 | 29.3 | 9948100.0 |
| 2003-05-29 13:30:00 | QQQ | ETF | 29.29 | 29.48 | 29.22 | 29.43 | 6139900.0 |
| 2003-05-29 14:00:00 | QQQ | ETF | 29.43 | 29.54 | 29.4 | 29.5 | 4801100.0 |
| 2003-05-29 14:30:00 | QQQ | ETF | 29.51 | 29.59 | 29.41 | 29.46 | 4228700.0 |
| 2003-05-29 15:00:00 | QQQ | ETF | 29.48 | 29.48 | 29.25 | 29.29 | 6841500.0 |
| 2003-05-29 15:30:00 | QQQ | ETF | 29.27 | 29.42 | 29.27 | 29.33 | 5035600.0 |
| 2003-05-29 16:00:00 | QQQ | ETF | 29.32 | 29.35 | 29.29 | 29.34 | 1242800.0 |
| 2003-05-29 16:30:00 | QQQ | ETF | 29.35 | 29.36 | 29.26 | 29.3 | 345100.0 |
| 2003-05-29 17:00:00 | QQQ | ETF | 29.29 | 29.33 | 29.28 | 29.31 | 213000.0 |
| 2003-05-29 17:30:00 | QQQ | ETF | 29.31 | 29.37 | 29.26 | 29.3 | 222800.0 |
| 2003-05-29 18:00:00 | QQQ | ETF | 29.31 | 29.32 | 29.3 | 29.32 | 22900.0 |
| 2003-05-29 18:30:00 | QQQ | ETF | 29.3 | 29.32 | 29.3 | 29.3 | 3200.0 |
| 2003-05-29 19:00:00 | QQQ | ETF | 29.3 | 29.34 | 29.3 | 29.34 | 2600.0 |
| 2003-05-29 19:30:00 | QQQ | ETF | 29.34 | 29.35 | 29.33 | 29.35 | 3300.0 |
| 2003-05-29 09:30:00 | IWM | ETF | 43.185 | 43.285 | 43.05 | 43.285 | 542000.0 |
| 2003-05-29 10:00:00 | IWM | ETF | 43.275 | 43.41 | 43.225 | 43.41 | 290800.0 |
> showing 50 of 728 rows — these rows as CSV