PREVIEW / etf_30min / 2006-10-03
file: by_date/etf_30min/2006/2006-10-03.parquet size: 84 KB rows: 2,924
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-10-03 05:30:00 | SPY | ETF | 132.88 | 132.88 | 132.88 | 132.88 | 500.0 |
| 2006-10-03 07:00:00 | SPY | ETF | 132.91 | 132.91 | 132.91 | 132.91 | 2500.0 |
| 2006-10-03 07:30:00 | SPY | ETF | 133.06 | 133.06 | 132.93 | 132.98 | 14200.0 |
| 2006-10-03 08:00:00 | SPY | ETF | 132.74 | 133.0 | 132.74 | 132.87 | 124400.0 |
| 2006-10-03 08:30:00 | SPY | ETF | 132.88 | 132.97 | 132.78 | 132.97 | 446000.0 |
| 2006-10-03 09:00:00 | SPY | ETF | 132.86 | 133.0823 | 132.85 | 132.86 | 1409300.0 |
| 2006-10-03 09:30:00 | SPY | ETF | 132.89 | 132.99 | 132.66 | 132.87 | 8457800.0 |
| 2006-10-03 10:00:00 | SPY | ETF | 132.87 | 132.98 | 132.65 | 132.9 | 8275700.0 |
| 2006-10-03 10:30:00 | SPY | ETF | 132.91 | 133.04 | 132.83 | 132.89 | 4136300.0 |
| 2006-10-03 11:00:00 | SPY | ETF | 132.89 | 133.32 | 132.78 | 133.25 | 7142300.0 |
| 2006-10-03 11:30:00 | SPY | ETF | 133.26 | 133.36 | 133.08 | 133.15 | 4968300.0 |
| 2006-10-03 12:00:00 | SPY | ETF | 133.15 | 133.73 | 133.15 | 133.66 | 5603600.0 |
| 2006-10-03 12:30:00 | SPY | ETF | 133.67 | 133.77 | 133.57 | 133.76 | 4055700.0 |
| 2006-10-03 13:00:00 | SPY | ETF | 133.77 | 133.79 | 133.48 | 133.56 | 4966000.0 |
| 2006-10-03 13:30:00 | SPY | ETF | 133.56 | 133.65 | 133.5 | 133.6 | 2256300.0 |
| 2006-10-03 14:00:00 | SPY | ETF | 133.6 | 133.79 | 133.41 | 133.46 | 6368000.0 |
| 2006-10-03 14:30:00 | SPY | ETF | 133.46 | 133.87 | 133.44 | 133.61 | 3193200.0 |
| 2006-10-03 15:00:00 | SPY | ETF | 133.61 | 133.69 | 133.49 | 133.51 | 2980900.0 |
| 2006-10-03 15:30:00 | SPY | ETF | 133.5 | 133.61 | 133.26 | 133.46 | 5927900.0 |
| 2006-10-03 16:00:00 | SPY | ETF | 133.44 | 133.47 | 133.35 | 133.4 | 955900.0 |
| 2006-10-03 16:30:00 | SPY | ETF | 133.39 | 133.4 | 133.32 | 133.4 | 383500.0 |
| 2006-10-03 17:00:00 | SPY | ETF | 133.41 | 133.42 | 133.37 | 133.37 | 183600.0 |
| 2006-10-03 17:30:00 | SPY | ETF | 133.34 | 133.34 | 133.34 | 133.34 | 3000.0 |
| 2006-10-03 18:00:00 | SPY | ETF | 133.39 | 133.39 | 133.36 | 133.36 | 400.0 |
| 2006-10-03 18:30:00 | SPY | ETF | 133.36 | 133.36 | 133.35 | 133.35 | 2100.0 |
| 2006-10-03 19:00:00 | SPY | ETF | 133.32 | 133.32 | 133.32 | 133.32 | 400.0 |
| 2006-10-03 19:30:00 | SPY | ETF | 133.32 | 133.35 | 133.32 | 133.35 | 1800.0 |
| 2006-10-03 09:30:00 | QQQ | ETF | 40.05 | 40.07 | 39.88 | 39.98 | 12905200.0 |
| 2006-10-03 10:00:00 | QQQ | ETF | 39.99 | 40.11 | 39.89 | 40.07 | 9115000.0 |
| 2006-10-03 10:30:00 | QQQ | ETF | 40.06 | 40.09 | 39.96 | 39.98 | 6023900.0 |
| 2006-10-03 11:00:00 | QQQ | ETF | 39.99 | 40.18 | 39.93 | 40.15 | 8213900.0 |
| 2006-10-03 11:30:00 | QQQ | ETF | 40.16 | 40.2 | 40.1 | 40.14 | 7470600.0 |
| 2006-10-03 12:00:00 | QQQ | ETF | 40.14 | 40.43 | 40.13 | 40.37 | 13106500.0 |
| 2006-10-03 12:30:00 | QQQ | ETF | 40.37 | 40.45 | 40.33 | 40.45 | 5489100.0 |
| 2006-10-03 13:00:00 | QQQ | ETF | 40.45 | 40.48 | 40.28 | 40.33 | 8893500.0 |
| 2006-10-03 13:30:00 | QQQ | ETF | 40.32 | 40.4 | 40.32 | 40.38 | 5903400.0 |
| 2006-10-03 14:00:00 | QQQ | ETF | 40.37 | 40.46 | 40.31 | 40.34 | 5792900.0 |
| 2006-10-03 14:30:00 | QQQ | ETF | 40.33 | 40.45 | 40.32 | 40.38 | 6948100.0 |
| 2006-10-03 15:00:00 | QQQ | ETF | 40.38 | 40.45 | 40.32 | 40.36 | 7148100.0 |
| 2006-10-03 15:30:00 | QQQ | ETF | 40.36 | 40.41 | 40.25 | 40.33 | 10726800.0 |
| 2006-10-03 05:30:00 | IWM | ETF | 71.0 | 71.0 | 71.0 | 71.0 | 200.0 |
| 2006-10-03 07:00:00 | IWM | ETF | 71.1 | 71.25 | 71.1 | 71.25 | 2400.0 |
| 2006-10-03 08:00:00 | IWM | ETF | 71.12 | 71.21 | 71.12 | 71.21 | 5400.0 |
| 2006-10-03 08:30:00 | IWM | ETF | 71.2 | 71.21 | 71.11 | 71.16 | 67500.0 |
| 2006-10-03 09:00:00 | IWM | ETF | 71.16 | 71.22 | 71.16 | 71.22 | 190100.0 |
| 2006-10-03 09:30:00 | IWM | ETF | 71.25 | 71.28 | 70.68 | 70.86 | 7544700.0 |
| 2006-10-03 10:00:00 | IWM | ETF | 70.87 | 71.14 | 70.71 | 71.06 | 2937000.0 |
| 2006-10-03 10:30:00 | IWM | ETF | 71.06 | 71.26 | 71.03 | 71.13 | 5702700.0 |
| 2006-10-03 11:00:00 | IWM | ETF | 71.12 | 71.51 | 71.06 | 71.49 | 3369200.0 |
| 2006-10-03 11:30:00 | IWM | ETF | 71.5 | 71.58 | 71.23 | 71.29 | 2693700.0 |
> showing 50 of 2,924 rows — these rows as CSV