PREVIEW / etf_30min / 2006-12-06
file: by_date/etf_30min/2006/2006-12-06.parquet size: 87 KB rows: 3,088
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-12-06 06:00:00 | SPY | ETF | 141.94 | 141.95 | 141.94 | 141.95 | 30000.0 |
| 2006-12-06 07:00:00 | SPY | ETF | 141.9 | 141.9 | 141.86 | 141.86 | 2600.0 |
| 2006-12-06 07:30:00 | SPY | ETF | 141.83 | 141.88 | 141.83 | 141.88 | 600.0 |
| 2006-12-06 08:00:00 | SPY | ETF | 141.86 | 142.02 | 141.7 | 141.77 | 368100.0 |
| 2006-12-06 08:30:00 | SPY | ETF | 141.78 | 141.83 | 141.67 | 141.82 | 347000.0 |
| 2006-12-06 09:00:00 | SPY | ETF | 141.8 | 141.89 | 141.79 | 141.84 | 261300.0 |
| 2006-12-06 09:30:00 | SPY | ETF | 141.87 | 141.89 | 141.57 | 141.66 | 7563500.0 |
| 2006-12-06 10:00:00 | SPY | ETF | 141.65 | 141.91 | 141.5 | 141.84 | 7548100.0 |
| 2006-12-06 10:30:00 | SPY | ETF | 141.85 | 141.98 | 141.75 | 141.76 | 4633600.0 |
| 2006-12-06 11:00:00 | SPY | ETF | 141.76 | 141.97 | 141.76 | 141.91 | 2888800.0 |
| 2006-12-06 11:30:00 | SPY | ETF | 141.9 | 141.93 | 141.75 | 141.76 | 2265100.0 |
| 2006-12-06 12:00:00 | SPY | ETF | 141.75 | 141.89 | 141.68 | 141.81 | 1707700.0 |
| 2006-12-06 12:30:00 | SPY | ETF | 141.82 | 142.04 | 141.73 | 141.95 | 4568600.0 |
| 2006-12-06 13:00:00 | SPY | ETF | 141.95 | 142.07 | 141.88 | 141.93 | 2204900.0 |
| 2006-12-06 13:30:00 | SPY | ETF | 141.92 | 142.0 | 141.75 | 141.86 | 2200700.0 |
| 2006-12-06 14:00:00 | SPY | ETF | 141.86 | 141.94 | 141.81 | 141.83 | 1899400.0 |
| 2006-12-06 14:30:00 | SPY | ETF | 141.82 | 141.89 | 141.73 | 141.82 | 2894300.0 |
| 2006-12-06 15:00:00 | SPY | ETF | 141.81 | 141.83 | 141.59 | 141.69 | 5081300.0 |
| 2006-12-06 15:30:00 | SPY | ETF | 141.68 | 141.76 | 141.58 | 141.76 | 4450400.0 |
| 2006-12-06 16:00:00 | SPY | ETF | 141.76 | 141.79 | 141.69 | 141.78 | 1005000.0 |
| 2006-12-06 16:30:00 | SPY | ETF | 141.76 | 141.78 | 141.73 | 141.78 | 276600.0 |
| 2006-12-06 17:00:00 | SPY | ETF | 141.79 | 141.8 | 141.69 | 141.71 | 265900.0 |
| 2006-12-06 17:30:00 | SPY | ETF | 141.71 | 141.71 | 141.71 | 141.71 | 27700.0 |
| 2006-12-06 18:00:00 | SPY | ETF | 141.71 | 141.74 | 141.62 | 141.62 | 68800.0 |
| 2006-12-06 18:30:00 | SPY | ETF | 141.62 | 141.63 | 141.62 | 141.63 | 3500.0 |
| 2006-12-06 19:00:00 | SPY | ETF | 141.73 | 141.73 | 141.66 | 141.66 | 1800.0 |
| 2006-12-06 19:30:00 | SPY | ETF | 141.68 | 141.68 | 141.68 | 141.68 | 100.0 |
| 2006-12-06 09:30:00 | QQQ | ETF | 44.29 | 44.31 | 44.07 | 44.19 | 14529200.0 |
| 2006-12-06 10:00:00 | QQQ | ETF | 44.18 | 44.34 | 44.1 | 44.24 | 12255400.0 |
| 2006-12-06 10:30:00 | QQQ | ETF | 44.24 | 44.33 | 44.18 | 44.19 | 8439000.0 |
| 2006-12-06 11:00:00 | QQQ | ETF | 44.19 | 44.31 | 44.19 | 44.29 | 2962300.0 |
| 2006-12-06 11:30:00 | QQQ | ETF | 44.28 | 44.3 | 44.21 | 44.22 | 2134300.0 |
| 2006-12-06 12:00:00 | QQQ | ETF | 44.21 | 44.25 | 44.18 | 44.24 | 1678200.0 |
| 2006-12-06 12:30:00 | QQQ | ETF | 44.23 | 44.38 | 44.22 | 44.34 | 3593800.0 |
| 2006-12-06 13:00:00 | QQQ | ETF | 44.34 | 44.4 | 44.31 | 44.33 | 2378500.0 |
| 2006-12-06 13:30:00 | QQQ | ETF | 44.34 | 44.37 | 44.26 | 44.3 | 2843900.0 |
| 2006-12-06 14:00:00 | QQQ | ETF | 44.29 | 44.33 | 44.27 | 44.29 | 2171200.0 |
| 2006-12-06 14:30:00 | QQQ | ETF | 44.29 | 44.33 | 44.27 | 44.27 | 2630600.0 |
| 2006-12-06 15:00:00 | QQQ | ETF | 44.27 | 44.27 | 44.14 | 44.18 | 6715400.0 |
| 2006-12-06 15:30:00 | QQQ | ETF | 44.18 | 44.26 | 44.14 | 44.26 | 6990300.0 |
| 2006-12-06 08:00:00 | IWM | ETF | 79.22 | 79.31 | 79.18 | 79.18 | 31400.0 |
| 2006-12-06 08:30:00 | IWM | ETF | 79.19 | 79.33 | 79.07 | 79.2 | 9344000.0 |
| 2006-12-06 09:00:00 | IWM | ETF | 79.17 | 79.2 | 79.13 | 79.15 | 82700.0 |
| 2006-12-06 09:30:00 | IWM | ETF | 79.2 | 79.26 | 78.84 | 78.95 | 4029100.0 |
| 2006-12-06 10:00:00 | IWM | ETF | 78.94 | 79.28 | 78.79 | 79.18 | 4036200.0 |
| 2006-12-06 10:30:00 | IWM | ETF | 79.19 | 79.34 | 79.09 | 79.14 | 1850100.0 |
| 2006-12-06 11:00:00 | IWM | ETF | 79.13 | 79.37 | 79.11 | 79.34 | 1331200.0 |
| 2006-12-06 11:30:00 | IWM | ETF | 79.34 | 79.36 | 79.23 | 79.27 | 618900.0 |
| 2006-12-06 12:00:00 | IWM | ETF | 79.26 | 79.31 | 79.15 | 79.28 | 2823800.0 |
| 2006-12-06 12:30:00 | IWM | ETF | 79.29 | 79.47 | 79.25 | 79.43 | 2669300.0 |
> showing 50 of 3,088 rows — these rows as CSV