PREVIEW / etf_30min / 2006-11-06
file: by_date/etf_30min/2006/2006-11-06.parquet size: 87 KB rows: 3,044
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-11-06 04:00:00 | SPY | ETF | 136.97 | 136.97 | 136.97 | 136.97 | 500.0 |
| 2006-11-06 06:00:00 | SPY | ETF | 137.06 | 137.06 | 137.06 | 137.06 | 900.0 |
| 2006-11-06 07:00:00 | SPY | ETF | 137.02 | 137.02 | 136.94 | 136.96 | 33000.0 |
| 2006-11-06 07:30:00 | SPY | ETF | 136.94 | 137.0 | 136.94 | 137.0 | 21700.0 |
| 2006-11-06 08:00:00 | SPY | ETF | 136.97 | 137.05 | 136.93 | 136.99 | 192200.0 |
| 2006-11-06 08:30:00 | SPY | ETF | 136.99 | 136.99 | 136.9 | 136.93 | 544000.0 |
| 2006-11-06 09:00:00 | SPY | ETF | 136.93 | 136.98 | 136.93 | 136.96 | 74500.0 |
| 2006-11-06 09:30:00 | SPY | ETF | 136.96 | 137.35 | 136.95 | 137.29 | 9627200.0 |
| 2006-11-06 10:00:00 | SPY | ETF | 137.3 | 137.75 | 137.27 | 137.56 | 9799000.0 |
| 2006-11-06 10:30:00 | SPY | ETF | 137.56 | 137.67 | 137.47 | 137.61 | 3980800.0 |
| 2006-11-06 11:00:00 | SPY | ETF | 137.63 | 137.78 | 137.58 | 137.74 | 3676400.0 |
| 2006-11-06 11:30:00 | SPY | ETF | 137.74 | 137.86 | 137.62 | 137.761 | 4961900.0 |
| 2006-11-06 12:00:00 | SPY | ETF | 137.78 | 137.88 | 137.71 | 137.72 | 2507200.0 |
| 2006-11-06 12:30:00 | SPY | ETF | 137.73 | 137.8 | 137.7 | 137.76 | 2506300.0 |
| 2006-11-06 13:00:00 | SPY | ETF | 137.76 | 138.02 | 137.75 | 137.9 | 2631700.0 |
| 2006-11-06 13:30:00 | SPY | ETF | 137.9 | 137.99 | 137.77 | 137.85 | 2861000.0 |
| 2006-11-06 14:00:00 | SPY | ETF | 137.85 | 138.01 | 137.84 | 137.99 | 2181500.0 |
| 2006-11-06 14:30:00 | SPY | ETF | 137.99 | 138.08 | 137.92 | 138.01 | 2986900.0 |
| 2006-11-06 15:00:00 | SPY | ETF | 138.0 | 138.27 | 137.98 | 138.21 | 4903000.0 |
| 2006-11-06 15:30:00 | SPY | ETF | 138.21 | 138.28 | 138.02 | 138.09 | 6401000.0 |
| 2006-11-06 16:00:00 | SPY | ETF | 138.07 | 138.13 | 138.01 | 138.08 | 1752700.0 |
| 2006-11-06 16:30:00 | SPY | ETF | 138.08 | 138.08 | 138.02 | 138.02 | 240300.0 |
| 2006-11-06 17:00:00 | SPY | ETF | 138.02 | 138.06 | 138.02 | 138.03 | 2200.0 |
| 2006-11-06 17:30:00 | SPY | ETF | 138.06 | 138.06 | 138.06 | 138.06 | 4600.0 |
| 2006-11-06 18:00:00 | SPY | ETF | 138.04 | 138.05 | 138.03 | 138.05 | 9300.0 |
| 2006-11-06 18:30:00 | SPY | ETF | 138.03 | 138.05 | 138.02 | 138.02 | 1200.0 |
| 2006-11-06 19:30:00 | SPY | ETF | 138.01 | 138.01 | 138.0 | 138.0 | 700.0 |
| 2006-11-06 09:30:00 | QQQ | ETF | 42.06 | 42.36 | 42.06 | 42.33 | 16327700.0 |
| 2006-11-06 10:00:00 | QQQ | ETF | 42.33 | 42.6 | 42.27 | 42.5 | 17462400.0 |
| 2006-11-06 10:30:00 | QQQ | ETF | 42.51 | 42.62 | 42.47 | 42.57 | 9112000.0 |
| 2006-11-06 11:00:00 | QQQ | ETF | 42.57 | 42.6 | 42.52 | 42.59 | 4676200.0 |
| 2006-11-06 11:30:00 | QQQ | ETF | 42.59 | 42.6 | 42.52 | 42.56 | 2985400.0 |
| 2006-11-06 12:00:00 | QQQ | ETF | 42.56 | 42.62 | 42.5 | 42.51 | 4114000.0 |
| 2006-11-06 12:30:00 | QQQ | ETF | 42.52 | 42.57 | 42.5 | 42.54 | 2611100.0 |
| 2006-11-06 13:00:00 | QQQ | ETF | 42.54 | 42.66 | 42.54 | 42.59 | 6505400.0 |
| 2006-11-06 13:30:00 | QQQ | ETF | 42.59 | 42.62 | 42.53 | 42.55 | 3735900.0 |
| 2006-11-06 14:00:00 | QQQ | ETF | 42.55 | 42.63 | 42.54 | 42.63 | 5703200.0 |
| 2006-11-06 14:30:00 | QQQ | ETF | 42.63 | 42.71 | 42.62 | 42.65 | 4849400.0 |
| 2006-11-06 15:00:00 | QQQ | ETF | 42.64 | 42.7 | 42.63 | 42.65 | 4758100.0 |
| 2006-11-06 15:30:00 | QQQ | ETF | 42.65 | 42.67 | 42.53 | 42.54 | 10365400.0 |
| 2006-11-06 08:00:00 | IWM | ETF | 75.1 | 75.2 | 75.1 | 75.2 | 3100.0 |
| 2006-11-06 08:30:00 | IWM | ETF | 75.16 | 75.19 | 75.16 | 75.18 | 900.0 |
| 2006-11-06 09:00:00 | IWM | ETF | 75.2 | 75.23 | 75.14 | 75.19 | 296300.0 |
| 2006-11-06 09:30:00 | IWM | ETF | 75.21 | 75.44 | 75.0 | 75.27 | 5538100.0 |
| 2006-11-06 10:00:00 | IWM | ETF | 75.26 | 75.6 | 75.25 | 75.29 | 5009500.0 |
| 2006-11-06 10:30:00 | IWM | ETF | 75.29 | 75.4 | 75.11 | 75.36 | 4089800.0 |
| 2006-11-06 11:00:00 | IWM | ETF | 75.36 | 75.51 | 75.31 | 75.48 | 1609100.0 |
| 2006-11-06 11:30:00 | IWM | ETF | 75.48 | 75.5 | 75.35 | 75.42 | 1338000.0 |
| 2006-11-06 12:00:00 | IWM | ETF | 75.43 | 75.61 | 75.43 | 75.52 | 1735200.0 |
| 2006-11-06 12:30:00 | IWM | ETF | 75.52 | 75.6 | 75.46 | 75.53 | 1306000.0 |
> showing 50 of 3,044 rows — these rows as CSV