PREVIEW / etf_30min / 2006-05-24
file: by_date/etf_30min/2006/2006-05-24.parquet size: 70 KB rows: 2,403
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-24 04:00:00 | SPY | ETF | 125.82 | 125.87 | 125.8 | 125.8 | 9200.0 |
| 2006-05-24 05:00:00 | SPY | ETF | 125.8 | 125.8 | 125.6 | 125.67 | 9000.0 |
| 2006-05-24 05:30:00 | SPY | ETF | 125.59 | 125.67 | 125.57 | 125.67 | 4700.0 |
| 2006-05-24 06:00:00 | SPY | ETF | 125.65 | 125.65 | 125.24 | 125.24 | 1800.0 |
| 2006-05-24 06:30:00 | SPY | ETF | 125.2 | 125.37 | 125.14 | 125.26 | 4500.0 |
| 2006-05-24 07:00:00 | SPY | ETF | 125.29 | 125.38 | 125.17 | 125.38 | 59200.0 |
| 2006-05-24 07:30:00 | SPY | ETF | 125.39 | 125.54 | 125.3 | 125.54 | 238600.0 |
| 2006-05-24 08:00:00 | SPY | ETF | 125.52 | 125.79 | 124.82 | 125.71 | 2859000.0 |
| 2006-05-24 08:30:00 | SPY | ETF | 125.72 | 125.88 | 125.43 | 125.77 | 3148700.0 |
| 2006-05-24 09:00:00 | SPY | ETF | 125.77 | 125.82 | 125.38 | 125.69 | 1411800.0 |
| 2006-05-24 09:30:00 | SPY | ETF | 125.68 | 126.31 | 125.4 | 126.21 | 15686800.0 |
| 2006-05-24 10:00:00 | SPY | ETF | 126.22 | 126.7 | 126.08 | 126.51 | 10820600.0 |
| 2006-05-24 10:30:00 | SPY | ETF | 126.5 | 126.89 | 126.26 | 126.29 | 6723900.0 |
| 2006-05-24 11:00:00 | SPY | ETF | 126.3 | 126.32 | 125.85 | 125.92 | 8860100.0 |
| 2006-05-24 11:30:00 | SPY | ETF | 125.92 | 126.23 | 125.55 | 126.08 | 14426400.0 |
| 2006-05-24 12:00:00 | SPY | ETF | 126.06 | 126.34 | 125.67 | 125.77 | 6632300.0 |
| 2006-05-24 12:30:00 | SPY | ETF | 125.77 | 125.83 | 125.21 | 125.38 | 10821800.0 |
| 2006-05-24 13:00:00 | SPY | ETF | 125.39 | 125.53 | 124.94 | 124.95 | 12073800.0 |
| 2006-05-24 13:30:00 | SPY | ETF | 124.95 | 125.73 | 124.76 | 125.54 | 18151500.0 |
| 2006-05-24 14:00:00 | SPY | ETF | 125.54 | 125.8 | 125.11 | 125.23 | 13474200.0 |
| 2006-05-24 14:30:00 | SPY | ETF | 125.22 | 126.2 | 125.12 | 125.97 | 14047700.0 |
| 2006-05-24 15:00:00 | SPY | ETF | 125.99 | 126.14 | 125.51 | 125.7 | 7236000.0 |
| 2006-05-24 15:30:00 | SPY | ETF | 125.72 | 126.55 | 125.71 | 126.09 | 15826100.0 |
| 2006-05-24 16:00:00 | SPY | ETF | 126.07 | 126.3 | 125.96 | 126.2 | 1712900.0 |
| 2006-05-24 16:30:00 | SPY | ETF | 126.19 | 126.27 | 126.13 | 126.18 | 63100.0 |
| 2006-05-24 17:00:00 | SPY | ETF | 126.23 | 126.33 | 126.23 | 126.3 | 305600.0 |
| 2006-05-24 17:30:00 | SPY | ETF | 126.31 | 126.33 | 126.21 | 126.31 | 41900.0 |
| 2006-05-24 18:00:00 | SPY | ETF | 126.3 | 126.3 | 126.26 | 126.26 | 10600.0 |
| 2006-05-24 18:30:00 | SPY | ETF | 126.29 | 126.29 | 126.24 | 126.27 | 2200.0 |
| 2006-05-24 19:00:00 | SPY | ETF | 126.29 | 126.31 | 126.29 | 126.31 | 1600.0 |
| 2006-05-24 19:30:00 | SPY | ETF | 126.34 | 126.35 | 126.3 | 126.35 | 6900.0 |
| 2006-05-24 09:30:00 | QQQ | ETF | 38.52 | 38.89 | 38.34 | 38.88 | 28876000.0 |
| 2006-05-24 10:00:00 | QQQ | ETF | 38.88 | 39.01 | 38.8 | 38.92 | 17762700.0 |
| 2006-05-24 10:30:00 | QQQ | ETF | 38.91 | 39.04 | 38.76 | 38.78 | 13109900.0 |
| 2006-05-24 11:00:00 | QQQ | ETF | 38.78 | 38.81 | 38.65 | 38.7 | 10668600.0 |
| 2006-05-24 11:30:00 | QQQ | ETF | 38.69 | 38.83 | 38.56 | 38.77 | 16526100.0 |
| 2006-05-24 12:00:00 | QQQ | ETF | 38.77 | 38.84 | 38.6 | 38.64 | 9954000.0 |
| 2006-05-24 12:30:00 | QQQ | ETF | 38.63 | 38.8 | 38.4 | 38.44 | 12855600.0 |
| 2006-05-24 13:00:00 | QQQ | ETF | 38.45 | 38.55 | 38.34 | 38.36 | 10886200.0 |
| 2006-05-24 13:30:00 | QQQ | ETF | 38.36 | 38.65 | 38.23 | 38.57 | 19636300.0 |
| 2006-05-24 14:00:00 | QQQ | ETF | 38.57 | 38.7 | 38.36 | 38.4 | 18043900.0 |
| 2006-05-24 14:30:00 | QQQ | ETF | 38.4 | 38.82 | 38.35 | 38.78 | 20933100.0 |
| 2006-05-24 15:00:00 | QQQ | ETF | 38.78 | 38.84 | 38.55 | 38.65 | 15471300.0 |
| 2006-05-24 15:30:00 | QQQ | ETF | 38.65 | 38.99 | 38.65 | 38.84 | 23813000.0 |
| 2006-05-24 07:00:00 | IWM | ETF | 70.5 | 70.5 | 70.1 | 70.1 | 300.0 |
| 2006-05-24 07:30:00 | IWM | ETF | 70.08 | 70.08 | 70.08 | 70.08 | 200.0 |
| 2006-05-24 08:00:00 | IWM | ETF | 70.18 | 70.4 | 69.94 | 70.38 | 432000.0 |
| 2006-05-24 08:30:00 | IWM | ETF | 70.45 | 70.71 | 70.3 | 70.51 | 1048400.0 |
| 2006-05-24 09:00:00 | IWM | ETF | 70.48 | 70.55 | 70.33 | 70.5 | 162300.0 |
| 2006-05-24 09:30:00 | IWM | ETF | 70.49 | 71.12 | 70.02 | 70.98 | 10988200.0 |
> showing 50 of 2,403 rows — these rows as CSV