PREVIEW / etf_30min / 2006-10-30
file: by_date/etf_30min/2006/2006-10-30.parquet size: 84 KB rows: 2,971
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-30 06:30:00 | SPY | ETF | 137.65 | 137.67 | 137.65 | 137.67 | 12500.0 |
| 2006-10-30 07:00:00 | SPY | ETF | 137.66 | 137.76 | 137.61 | 137.73 | 90100.0 |
| 2006-10-30 07:30:00 | SPY | ETF | 137.75 | 137.81 | 137.73 | 137.79 | 120600.0 |
| 2006-10-30 08:00:00 | SPY | ETF | 137.76 | 137.81 | 137.61 | 137.74 | 322600.0 |
| 2006-10-30 08:30:00 | SPY | ETF | 137.76 | 137.81 | 137.61 | 137.65 | 601000.0 |
| 2006-10-30 09:00:00 | SPY | ETF | 137.65 | 137.74 | 137.59 | 137.65 | 214500.0 |
| 2006-10-30 09:30:00 | SPY | ETF | 137.66 | 137.92 | 137.51 | 137.57 | 7184100.0 |
| 2006-10-30 10:00:00 | SPY | ETF | 137.57 | 137.88 | 137.4 | 137.49 | 4616200.0 |
| 2006-10-30 10:30:00 | SPY | ETF | 137.49 | 137.8 | 137.49 | 137.71 | 4355000.0 |
| 2006-10-30 11:00:00 | SPY | ETF | 137.71 | 138.1 | 137.69 | 137.91 | 5732100.0 |
| 2006-10-30 11:30:00 | SPY | ETF | 137.91 | 137.97 | 137.78 | 137.86 | 2049500.0 |
| 2006-10-30 12:00:00 | SPY | ETF | 137.85 | 137.85 | 137.66 | 137.77 | 2508800.0 |
| 2006-10-30 12:30:00 | SPY | ETF | 137.77 | 137.84 | 137.67 | 137.81 | 939100.0 |
| 2006-10-30 13:00:00 | SPY | ETF | 137.82 | 138.05 | 137.76 | 137.92 | 2201300.0 |
| 2006-10-30 13:30:00 | SPY | ETF | 137.92 | 138.17 | 137.91 | 138.16 | 4150500.0 |
| 2006-10-30 14:00:00 | SPY | ETF | 138.15 | 138.2 | 138.06 | 138.08 | 2510100.0 |
| 2006-10-30 14:30:00 | SPY | ETF | 138.07 | 138.12 | 137.99 | 138.04 | 2007700.0 |
| 2006-10-30 15:00:00 | SPY | ETF | 138.05 | 138.17 | 137.82 | 137.87 | 3514700.0 |
| 2006-10-30 15:30:00 | SPY | ETF | 137.85 | 137.89 | 137.74 | 137.89 | 4223100.0 |
| 2006-10-30 16:00:00 | SPY | ETF | 137.87 | 137.88 | 137.79 | 137.82 | 829600.0 |
| 2006-10-30 16:30:00 | SPY | ETF | 137.81 | 137.84 | 137.8 | 137.82 | 149000.0 |
| 2006-10-30 17:00:00 | SPY | ETF | 137.82 | 137.83 | 137.82 | 137.83 | 5100.0 |
| 2006-10-30 17:30:00 | SPY | ETF | 137.82 | 137.86 | 137.82 | 137.86 | 900.0 |
| 2006-10-30 09:30:00 | QQQ | ETF | 42.17 | 42.31 | 40.2 | 42.11 | 17058200.0 |
| 2006-10-30 10:00:00 | QQQ | ETF | 42.11 | 42.21 | 41.14 | 42.16 | 9654400.0 |
| 2006-10-30 10:30:00 | QQQ | ETF | 42.16 | 42.31 | 42.15 | 42.26 | 7506100.0 |
| 2006-10-30 11:00:00 | QQQ | ETF | 42.27 | 42.49 | 42.26 | 42.44 | 11983500.0 |
| 2006-10-30 11:30:00 | QQQ | ETF | 42.44 | 42.45 | 42.36 | 42.41 | 3606500.0 |
| 2006-10-30 12:00:00 | QQQ | ETF | 42.41 | 42.41 | 42.26 | 42.33 | 6373000.0 |
| 2006-10-30 12:30:00 | QQQ | ETF | 42.32 | 42.35 | 42.27 | 42.35 | 2770000.0 |
| 2006-10-30 13:00:00 | QQQ | ETF | 42.35 | 42.47 | 42.34 | 42.43 | 5343100.0 |
| 2006-10-30 13:30:00 | QQQ | ETF | 42.43 | 42.6 | 42.43 | 42.6 | 8299100.0 |
| 2006-10-30 14:00:00 | QQQ | ETF | 42.59 | 42.65 | 42.55 | 42.58 | 5009300.0 |
| 2006-10-30 14:30:00 | QQQ | ETF | 42.58 | 42.6 | 42.54 | 42.56 | 4842800.0 |
| 2006-10-30 15:00:00 | QQQ | ETF | 42.56 | 42.61 | 42.44 | 42.45 | 5188200.0 |
| 2006-10-30 15:30:00 | QQQ | ETF | 42.45 | 42.5 | 42.4 | 42.48 | 8822200.0 |
| 2006-10-30 07:30:00 | IWM | ETF | 76.04 | 76.04 | 76.04 | 76.04 | 400.0 |
| 2006-10-30 08:00:00 | IWM | ETF | 75.89 | 76.02 | 75.89 | 75.97 | 73000.0 |
| 2006-10-30 08:30:00 | IWM | ETF | 75.98 | 76.04 | 75.87 | 75.88 | 189200.0 |
| 2006-10-30 09:00:00 | IWM | ETF | 75.89 | 75.94 | 75.77 | 75.8 | 1267800.0 |
| 2006-10-30 09:30:00 | IWM | ETF | 75.78 | 76.12 | 75.64 | 75.76 | 6741900.0 |
| 2006-10-30 10:00:00 | IWM | ETF | 75.75 | 75.81 | 75.53 | 75.73 | 3629100.0 |
| 2006-10-30 10:30:00 | IWM | ETF | 75.73 | 76.0 | 75.7 | 75.84 | 3552300.0 |
| 2006-10-30 11:00:00 | IWM | ETF | 75.83 | 76.35 | 75.82 | 76.28 | 5012200.0 |
| 2006-10-30 11:30:00 | IWM | ETF | 76.28 | 76.33 | 76.18 | 76.22 | 944900.0 |
| 2006-10-30 12:00:00 | IWM | ETF | 76.22 | 76.22 | 76.01 | 76.1 | 1074900.0 |
| 2006-10-30 12:30:00 | IWM | ETF | 76.1 | 76.15 | 76.0 | 76.1024 | 645200.0 |
| 2006-10-30 13:00:00 | IWM | ETF | 76.1 | 76.34 | 76.1 | 76.31 | 1928100.0 |
| 2006-10-30 13:30:00 | IWM | ETF | 76.32 | 76.63 | 76.32 | 76.59 | 4046800.0 |
| 2006-10-30 14:00:00 | IWM | ETF | 76.59 | 76.71 | 76.56 | 76.62 | 3280400.0 |
> showing 50 of 2,971 rows — these rows as CSV