PREVIEW / etf_30min / 2006-10-19
file: by_date/etf_30min/2006/2006-10-19.parquet size: 82 KB rows: 2,952
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-19 07:00:00 | SPY | ETF | 136.45 | 136.67 | 136.41 | 136.67 | 13900.0 |
| 2006-10-19 07:30:00 | SPY | ETF | 136.67 | 136.68 | 136.6 | 136.63 | 27900.0 |
| 2006-10-19 08:00:00 | SPY | ETF | 136.6 | 136.66 | 136.45 | 136.61 | 144800.0 |
| 2006-10-19 08:30:00 | SPY | ETF | 136.63 | 136.68 | 136.53 | 136.56 | 492300.0 |
| 2006-10-19 09:00:00 | SPY | ETF | 136.54 | 136.59 | 136.33 | 136.4 | 1234300.0 |
| 2006-10-19 09:30:00 | SPY | ETF | 136.39 | 136.56 | 136.23 | 136.52 | 7367000.0 |
| 2006-10-19 10:00:00 | SPY | ETF | 136.53 | 136.88 | 136.42 | 136.72 | 7113600.0 |
| 2006-10-19 10:30:00 | SPY | ETF | 136.73 | 136.76 | 136.56 | 136.63 | 4581800.0 |
| 2006-10-19 11:00:00 | SPY | ETF | 136.62 | 136.63 | 136.43 | 136.54 | 3048800.0 |
| 2006-10-19 11:30:00 | SPY | ETF | 136.54 | 136.62 | 136.45 | 136.54 | 2044300.0 |
| 2006-10-19 12:00:00 | SPY | ETF | 136.55 | 136.67 | 136.38 | 136.5 | 3383100.0 |
| 2006-10-19 12:30:00 | SPY | ETF | 136.5 | 136.58 | 136.29 | 136.36 | 3090200.0 |
| 2006-10-19 13:00:00 | SPY | ETF | 136.37 | 136.63 | 136.26 | 136.59 | 5072100.0 |
| 2006-10-19 13:30:00 | SPY | ETF | 136.58 | 136.68 | 136.53 | 136.57 | 7591400.0 |
| 2006-10-19 14:00:00 | SPY | ETF | 136.58 | 136.65 | 136.45 | 136.65 | 1578400.0 |
| 2006-10-19 14:30:00 | SPY | ETF | 136.65 | 136.72 | 136.57 | 136.67 | 1613900.0 |
| 2006-10-19 15:00:00 | SPY | ETF | 136.68 | 136.68 | 136.55 | 136.5901 | 2214500.0 |
| 2006-10-19 15:30:00 | SPY | ETF | 136.6 | 136.79 | 136.42 | 136.7 | 7119100.0 |
| 2006-10-19 16:00:00 | SPY | ETF | 136.75 | 136.83 | 136.67 | 136.78 | 845800.0 |
| 2006-10-19 16:30:00 | SPY | ETF | 136.8 | 136.84 | 136.77 | 136.81 | 304700.0 |
| 2006-10-19 17:00:00 | SPY | ETF | 136.81 | 136.85 | 136.8 | 136.81 | 3142200.0 |
| 2006-10-19 17:30:00 | SPY | ETF | 136.81 | 136.81 | 136.76 | 136.8 | 69300.0 |
| 2006-10-19 18:00:00 | SPY | ETF | 136.8 | 136.81 | 136.58 | 136.7 | 18800.0 |
| 2006-10-19 18:30:00 | SPY | ETF | 136.79 | 136.79 | 136.79 | 136.79 | 200.0 |
| 2006-10-19 19:00:00 | SPY | ETF | 136.8 | 136.8 | 136.8 | 136.8 | 200.0 |
| 2006-10-19 19:30:00 | SPY | ETF | 136.8 | 136.84 | 136.8 | 136.84 | 2200.0 |
| 2006-10-19 09:30:00 | QQQ | ETF | 41.69 | 41.9 | 41.59 | 41.89 | 14649500.0 |
| 2006-10-19 10:00:00 | QQQ | ETF | 41.88 | 42.11 | 41.79 | 42.03 | 14327100.0 |
| 2006-10-19 10:30:00 | QQQ | ETF | 42.03 | 42.04 | 41.92 | 41.96 | 7981900.0 |
| 2006-10-19 11:00:00 | QQQ | ETF | 41.96 | 41.96 | 41.82 | 41.86 | 9731700.0 |
| 2006-10-19 11:30:00 | QQQ | ETF | 41.86 | 41.89 | 41.82 | 41.86 | 3110700.0 |
| 2006-10-19 12:00:00 | QQQ | ETF | 41.86 | 41.94 | 41.8 | 41.81 | 8443300.0 |
| 2006-10-19 12:30:00 | QQQ | ETF | 41.81 | 41.83 | 41.6 | 41.67 | 7929600.0 |
| 2006-10-19 13:00:00 | QQQ | ETF | 41.68 | 41.81 | 41.62 | 41.78 | 4534700.0 |
| 2006-10-19 13:30:00 | QQQ | ETF | 41.78 | 41.84 | 41.75 | 41.78 | 4098500.0 |
| 2006-10-19 14:00:00 | QQQ | ETF | 41.78 | 41.88 | 41.71 | 41.87 | 5266800.0 |
| 2006-10-19 14:30:00 | QQQ | ETF | 41.88 | 41.92 | 41.82 | 41.91 | 6647100.0 |
| 2006-10-19 15:00:00 | QQQ | ETF | 41.9 | 41.91 | 41.79 | 41.84 | 3482700.0 |
| 2006-10-19 15:30:00 | QQQ | ETF | 41.83 | 41.93 | 41.83 | 41.91 | 7683900.0 |
| 2006-10-19 07:00:00 | IWM | ETF | 75.64 | 75.64 | 75.64 | 75.64 | 1300.0 |
| 2006-10-19 08:00:00 | IWM | ETF | 75.95 | 75.95 | 75.89 | 75.89 | 5000.0 |
| 2006-10-19 08:30:00 | IWM | ETF | 75.9 | 75.98 | 75.84 | 75.86 | 438300.0 |
| 2006-10-19 09:00:00 | IWM | ETF | 75.87 | 75.88 | 75.71 | 75.75 | 37500.0 |
| 2006-10-19 09:30:00 | IWM | ETF | 75.73 | 76.23 | 75.58 | 76.19 | 5583800.0 |
| 2006-10-19 10:00:00 | IWM | ETF | 76.19 | 76.4 | 76.11 | 76.28 | 4715300.0 |
| 2006-10-19 10:30:00 | IWM | ETF | 76.28 | 76.37 | 76.22 | 76.31 | 3566900.0 |
| 2006-10-19 11:00:00 | IWM | ETF | 76.31 | 76.31 | 76.11 | 76.23 | 2045900.0 |
| 2006-10-19 11:30:00 | IWM | ETF | 76.23 | 76.32 | 76.13 | 76.22 | 2371400.0 |
| 2006-10-19 12:00:00 | IWM | ETF | 76.22 | 76.36 | 76.07 | 76.18 | 3567900.0 |
| 2006-10-19 12:30:00 | IWM | ETF | 76.18 | 76.22 | 75.95 | 76.07 | 3093500.0 |
> showing 50 of 2,952 rows — these rows as CSV