PREVIEW / etf_30min / 2006-10-12
file: by_date/etf_30min/2006/2006-10-12.parquet size: 84 KB rows: 2,981
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-12 06:00:00 | SPY | ETF | 135.15 | 135.15 | 135.15 | 135.15 | 900.0 |
| 2006-10-12 07:30:00 | SPY | ETF | 135.25 | 135.27 | 135.24 | 135.26 | 60900.0 |
| 2006-10-12 08:00:00 | SPY | ETF | 135.31 | 135.37 | 135.24 | 135.34 | 1166900.0 |
| 2006-10-12 08:30:00 | SPY | ETF | 135.33 | 135.49 | 135.27 | 135.47 | 1066900.0 |
| 2006-10-12 09:00:00 | SPY | ETF | 135.47 | 135.52 | 135.44 | 135.48 | 326800.0 |
| 2006-10-12 09:30:00 | SPY | ETF | 135.45 | 135.6 | 135.4 | 135.48 | 6101500.0 |
| 2006-10-12 10:00:00 | SPY | ETF | 135.48 | 135.73 | 135.45 | 135.67 | 3753800.0 |
| 2006-10-12 10:30:00 | SPY | ETF | 135.67 | 135.75 | 135.56 | 135.66 | 3750400.0 |
| 2006-10-12 11:00:00 | SPY | ETF | 135.67 | 135.91 | 135.6 | 135.86 | 5250900.0 |
| 2006-10-12 11:30:00 | SPY | ETF | 135.86 | 135.93 | 135.8 | 135.83 | 4607200.0 |
| 2006-10-12 12:00:00 | SPY | ETF | 135.82 | 135.87 | 135.74 | 135.77 | 2930500.0 |
| 2006-10-12 12:30:00 | SPY | ETF | 135.77 | 135.86 | 135.75 | 135.8 | 2069500.0 |
| 2006-10-12 13:00:00 | SPY | ETF | 135.81 | 135.85 | 135.7 | 135.8 | 1557900.0 |
| 2006-10-12 13:30:00 | SPY | ETF | 135.79 | 135.89 | 135.72 | 135.85 | 1892900.0 |
| 2006-10-12 14:00:00 | SPY | ETF | 135.85 | 136.1 | 135.82 | 136.01 | 6893300.0 |
| 2006-10-12 14:30:00 | SPY | ETF | 136.03 | 136.12 | 135.98 | 136.07 | 2285800.0 |
| 2006-10-12 15:00:00 | SPY | ETF | 136.07 | 136.39 | 135.99 | 136.3 | 6199600.0 |
| 2006-10-12 15:30:00 | SPY | ETF | 136.3 | 136.32 | 136.24 | 136.26 | 5226700.0 |
| 2006-10-12 16:00:00 | SPY | ETF | 136.27 | 136.34 | 136.2 | 136.3 | 1304200.0 |
| 2006-10-12 16:30:00 | SPY | ETF | 136.29 | 136.3 | 135.29 | 136.29 | 887000.0 |
| 2006-10-12 17:00:00 | SPY | ETF | 136.3 | 136.33 | 136.3 | 136.32 | 172200.0 |
| 2006-10-12 17:30:00 | SPY | ETF | 136.35 | 136.39 | 136.34 | 136.36 | 35200.0 |
| 2006-10-12 18:00:00 | SPY | ETF | 136.33 | 136.33 | 136.28 | 136.29 | 14300.0 |
| 2006-10-12 19:00:00 | SPY | ETF | 136.33 | 136.33 | 136.33 | 136.33 | 500.0 |
| 2006-10-12 19:30:00 | SPY | ETF | 136.33 | 136.33 | 136.33 | 136.33 | 13200.0 |
| 2006-10-12 09:30:00 | QQQ | ETF | 41.76 | 41.83 | 41.7 | 41.76 | 10713900.0 |
| 2006-10-12 10:00:00 | QQQ | ETF | 41.76 | 41.88 | 41.74 | 41.82 | 5232000.0 |
| 2006-10-12 10:30:00 | QQQ | ETF | 41.82 | 41.87 | 41.75 | 41.78 | 5172000.0 |
| 2006-10-12 11:00:00 | QQQ | ETF | 41.78 | 41.85 | 41.73 | 41.82 | 5751400.0 |
| 2006-10-12 11:30:00 | QQQ | ETF | 41.82 | 41.87 | 41.79 | 41.82 | 3044600.0 |
| 2006-10-12 12:00:00 | QQQ | ETF | 41.82 | 41.85 | 41.8 | 41.82 | 2914500.0 |
| 2006-10-12 12:30:00 | QQQ | ETF | 41.82 | 41.87 | 41.78 | 41.82 | 3746600.0 |
| 2006-10-12 13:00:00 | QQQ | ETF | 41.82 | 41.85 | 41.76 | 41.8 | 3069500.0 |
| 2006-10-12 13:30:00 | QQQ | ETF | 41.79 | 41.86 | 41.77 | 41.85 | 3122300.0 |
| 2006-10-12 14:00:00 | QQQ | ETF | 41.84 | 41.99 | 41.84 | 41.96 | 11083200.0 |
| 2006-10-12 14:30:00 | QQQ | ETF | 41.95 | 42.01 | 41.93 | 41.96 | 4890700.0 |
| 2006-10-12 15:00:00 | QQQ | ETF | 41.97 | 42.24 | 41.95 | 42.2 | 13418100.0 |
| 2006-10-12 15:30:00 | QQQ | ETF | 42.2 | 42.25 | 42.16 | 42.2 | 11507300.0 |
| 2006-10-12 08:00:00 | IWM | ETF | 73.92 | 73.96 | 73.92 | 73.95 | 31400.0 |
| 2006-10-12 08:30:00 | IWM | ETF | 73.92 | 74.1 | 73.92 | 74.1 | 81900.0 |
| 2006-10-12 09:00:00 | IWM | ETF | 74.1 | 74.11 | 74.06 | 74.08 | 76900.0 |
| 2006-10-12 09:30:00 | IWM | ETF | 74.08 | 74.4 | 74.08 | 74.35 | 5740700.0 |
| 2006-10-12 10:00:00 | IWM | ETF | 74.35 | 74.54 | 74.28 | 74.46 | 4676300.0 |
| 2006-10-12 10:30:00 | IWM | ETF | 74.47 | 74.63 | 74.37 | 74.53 | 3382900.0 |
| 2006-10-12 11:00:00 | IWM | ETF | 74.53 | 74.7 | 74.45 | 74.56 | 2707100.0 |
| 2006-10-12 11:30:00 | IWM | ETF | 74.57 | 74.67 | 74.51 | 74.55 | 1175000.0 |
| 2006-10-12 12:00:00 | IWM | ETF | 74.55 | 74.59 | 74.47 | 74.56 | 1022200.0 |
| 2006-10-12 12:30:00 | IWM | ETF | 74.56 | 74.71 | 74.55 | 74.63 | 1132300.0 |
| 2006-10-12 13:00:00 | IWM | ETF | 74.64 | 74.66 | 74.52 | 74.57 | 2665300.0 |
| 2006-10-12 13:30:00 | IWM | ETF | 74.57 | 74.58 | 74.41 | 74.52 | 1526700.0 |
> showing 50 of 2,981 rows — these rows as CSV