PREVIEW / etf_30min / 2006-05-31
file: by_date/etf_30min/2006/2006-05-31.parquet size: 65 KB rows: 2,306
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-31 05:00:00 | SPY | ETF | 126.47 | 126.47 | 126.47 | 126.47 | 2200.0 |
| 2006-05-31 05:30:00 | SPY | ETF | 126.54 | 126.54 | 126.54 | 126.54 | 100.0 |
| 2006-05-31 06:00:00 | SPY | ETF | 126.65 | 126.65 | 126.65 | 126.65 | 2500.0 |
| 2006-05-31 06:30:00 | SPY | ETF | 126.5 | 126.5 | 126.47 | 126.47 | 23600.0 |
| 2006-05-31 07:00:00 | SPY | ETF | 126.46 | 126.57 | 126.46 | 126.57 | 35000.0 |
| 2006-05-31 07:30:00 | SPY | ETF | 126.6 | 126.65 | 126.56 | 126.65 | 97600.0 |
| 2006-05-31 08:00:00 | SPY | ETF | 126.63 | 126.73 | 126.46 | 126.7 | 314700.0 |
| 2006-05-31 08:30:00 | SPY | ETF | 126.68 | 126.88 | 126.05 | 126.67 | 1109400.0 |
| 2006-05-31 09:00:00 | SPY | ETF | 126.67 | 126.71 | 126.6 | 126.6 | 914200.0 |
| 2006-05-31 09:30:00 | SPY | ETF | 126.58 | 126.97 | 126.56 | 126.87 | 8574400.0 |
| 2006-05-31 10:00:00 | SPY | ETF | 126.87 | 126.93 | 126.61 | 126.82 | 7554800.0 |
| 2006-05-31 10:30:00 | SPY | ETF | 126.83 | 127.33 | 126.83 | 127.2 | 7894500.0 |
| 2006-05-31 11:00:00 | SPY | ETF | 127.21 | 127.33 | 127.01 | 127.32 | 3011900.0 |
| 2006-05-31 11:30:00 | SPY | ETF | 127.32 | 127.37 | 127.13 | 127.16 | 1783900.0 |
| 2006-05-31 12:00:00 | SPY | ETF | 127.16 | 127.2 | 127.07 | 127.15 | 2401800.0 |
| 2006-05-31 12:30:00 | SPY | ETF | 127.15 | 127.18 | 127.04 | 127.05 | 2135200.0 |
| 2006-05-31 13:00:00 | SPY | ETF | 127.05 | 127.09 | 126.91 | 126.95 | 2248300.0 |
| 2006-05-31 13:30:00 | SPY | ETF | 126.93 | 127.14 | 126.812 | 126.9 | 2367800.0 |
| 2006-05-31 14:00:00 | SPY | ETF | 126.91 | 127.18 | 126.2 | 126.69 | 16584200.0 |
| 2006-05-31 14:30:00 | SPY | ETF | 126.69 | 127.04 | 126.67 | 126.82 | 5307800.0 |
| 2006-05-31 15:00:00 | SPY | ETF | 126.83 | 126.99 | 126.6 | 126.87 | 4372100.0 |
| 2006-05-31 15:30:00 | SPY | ETF | 126.87 | 127.38 | 126.3274 | 127.3 | 10486400.0 |
| 2006-05-31 16:00:00 | SPY | ETF | 127.3 | 127.98 | 127.26 | 127.51 | 3533400.0 |
| 2006-05-31 16:30:00 | SPY | ETF | 127.5 | 127.51 | 127.35 | 127.45 | 352400.0 |
| 2006-05-31 17:00:00 | SPY | ETF | 127.47 | 127.49 | 127.38 | 127.45 | 13600.0 |
| 2006-05-31 17:30:00 | SPY | ETF | 127.44 | 127.44 | 127.42 | 127.42 | 2000.0 |
| 2006-05-31 18:00:00 | SPY | ETF | 127.44 | 127.52 | 127.44 | 127.48 | 5600.0 |
| 2006-05-31 18:30:00 | SPY | ETF | 127.54 | 127.54 | 127.5 | 127.5 | 2400.0 |
| 2006-05-31 19:00:00 | SPY | ETF | 127.51 | 127.51 | 127.51 | 127.51 | 100.0 |
| 2006-05-31 09:30:00 | QQQ | ETF | 38.72 | 38.86 | 38.71 | 38.8 | 12989100.0 |
| 2006-05-31 10:00:00 | QQQ | ETF | 38.8 | 38.86 | 38.68 | 38.83 | 11479400.0 |
| 2006-05-31 10:30:00 | QQQ | ETF | 38.82 | 39.05 | 38.82 | 38.97 | 12425300.0 |
| 2006-05-31 11:00:00 | QQQ | ETF | 38.97 | 39.99 | 38.88 | 39.04 | 5662400.0 |
| 2006-05-31 11:30:00 | QQQ | ETF | 39.04 | 39.06 | 38.95 | 38.95 | 4822800.0 |
| 2006-05-31 12:00:00 | QQQ | ETF | 38.95 | 38.99 | 38.9 | 38.97 | 8338400.0 |
| 2006-05-31 12:30:00 | QQQ | ETF | 38.96 | 38.97 | 38.9 | 38.95 | 3940500.0 |
| 2006-05-31 13:00:00 | QQQ | ETF | 38.95 | 38.97 | 38.87 | 38.88 | 6232200.0 |
| 2006-05-31 13:30:00 | QQQ | ETF | 38.88 | 38.96 | 38.83 | 38.85 | 3852500.0 |
| 2006-05-31 14:00:00 | QQQ | ETF | 38.85 | 38.95 | 38.54 | 38.67 | 25941700.0 |
| 2006-05-31 14:30:00 | QQQ | ETF | 38.67 | 38.82 | 38.63 | 38.72 | 10892100.0 |
| 2006-05-31 15:00:00 | QQQ | ETF | 38.71 | 38.78 | 38.62 | 38.71 | 7384200.0 |
| 2006-05-31 15:30:00 | QQQ | ETF | 38.71 | 38.9 | 38.64 | 38.83 | 12620900.0 |
| 2006-05-31 07:30:00 | IWM | ETF | 70.9 | 70.9 | 70.9 | 70.9 | 800.0 |
| 2006-05-31 08:00:00 | IWM | ETF | 70.9 | 70.97 | 70.64 | 70.92 | 1070700.0 |
| 2006-05-31 08:30:00 | IWM | ETF | 70.9 | 70.9 | 70.78 | 70.88 | 126800.0 |
| 2006-05-31 09:00:00 | IWM | ETF | 70.89 | 70.89 | 70.81 | 70.82 | 222900.0 |
| 2006-05-31 09:30:00 | IWM | ETF | 70.81 | 71.21 | 70.81 | 71.06 | 4157000.0 |
| 2006-05-31 10:00:00 | IWM | ETF | 71.05 | 71.14 | 70.67 | 71.01 | 7212100.0 |
| 2006-05-31 10:30:00 | IWM | ETF | 71.02 | 71.48 | 71.02 | 71.4 | 4506100.0 |
| 2006-05-31 11:00:00 | IWM | ETF | 71.39 | 71.67 | 70.6955 | 71.64 | 4648900.0 |
> showing 50 of 2,306 rows — these rows as CSV