PREVIEW / etf_30min / 2006-12-14
file: by_date/etf_30min/2006/2006-12-14.parquet size: 86 KB rows: 3,110
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-14 07:00:00 | SPY | ETF | 141.71 | 141.77 | 141.71 | 141.77 | 102000.0 |
| 2006-12-14 07:30:00 | SPY | ETF | 141.78 | 141.78 | 141.72 | 141.72 | 6900.0 |
| 2006-12-14 08:00:00 | SPY | ETF | 141.75 | 142.04 | 141.68 | 142.0 | 1430900.0 |
| 2006-12-14 08:30:00 | SPY | ETF | 142.0 | 142.02 | 141.77 | 141.89 | 1644800.0 |
| 2006-12-14 09:00:00 | SPY | ETF | 141.91 | 141.94 | 141.87 | 141.87 | 54800.0 |
| 2006-12-14 09:30:00 | SPY | ETF | 141.86 | 142.81 | 141.84 | 142.69 | 11892400.0 |
| 2006-12-14 10:00:00 | SPY | ETF | 142.7 | 142.98 | 142.57 | 142.72 | 11618600.0 |
| 2006-12-14 10:30:00 | SPY | ETF | 142.73 | 142.97 | 142.53 | 142.77 | 5853800.0 |
| 2006-12-14 11:00:00 | SPY | ETF | 142.76 | 142.86 | 142.68 | 142.73 | 3646700.0 |
| 2006-12-14 11:30:00 | SPY | ETF | 142.76 | 142.81 | 142.69 | 142.76 | 2098000.0 |
| 2006-12-14 12:00:00 | SPY | ETF | 142.76 | 142.8 | 142.68 | 142.76 | 2245700.0 |
| 2006-12-14 12:30:00 | SPY | ETF | 142.77 | 142.9 | 142.75 | 142.86 | 2556400.0 |
| 2006-12-14 13:00:00 | SPY | ETF | 142.85 | 142.98 | 142.77 | 142.92 | 1893100.0 |
| 2006-12-14 13:30:00 | SPY | ETF | 142.92 | 143.0 | 142.82 | 142.91 | 2214500.0 |
| 2006-12-14 14:00:00 | SPY | ETF | 142.91 | 142.99 | 142.84 | 142.99 | 1859600.0 |
| 2006-12-14 14:30:00 | SPY | ETF | 142.94 | 143.19 | 142.94 | 143.15 | 4204800.0 |
| 2006-12-14 15:00:00 | SPY | ETF | 143.14 | 143.18 | 142.98 | 143.12 | 3663500.0 |
| 2006-12-14 15:30:00 | SPY | ETF | 143.12 | 143.24 | 142.96 | 142.98 | 5151300.0 |
| 2006-12-14 16:00:00 | SPY | ETF | 142.99 | 143.12 | 142.8221 | 143.09 | 872700.0 |
| 2006-12-14 16:30:00 | SPY | ETF | 143.06 | 143.19 | 143.06 | 143.15 | 175600.0 |
| 2006-12-14 17:00:00 | SPY | ETF | 143.16 | 143.18 | 143.12 | 143.15 | 8700.0 |
| 2006-12-14 17:30:00 | SPY | ETF | 143.14 | 143.14 | 143.06 | 143.1 | 15100.0 |
| 2006-12-14 18:00:00 | SPY | ETF | 143.1 | 143.19 | 143.1 | 143.15 | 20600.0 |
| 2006-12-14 18:30:00 | SPY | ETF | 143.16 | 143.16 | 143.15 | 143.15 | 2900.0 |
| 2006-12-14 19:00:00 | SPY | ETF | 143.14 | 143.15 | 143.14 | 143.15 | 1000.0 |
| 2006-12-14 19:30:00 | SPY | ETF | 143.15 | 143.15 | 143.13 | 143.15 | 400.0 |
| 2006-12-14 09:30:00 | QQQ | ETF | 43.97 | 44.44 | 43.94 | 44.41 | 21100900.0 |
| 2006-12-14 10:00:00 | QQQ | ETF | 44.41 | 44.48 | 44.35 | 44.47 | 23045100.0 |
| 2006-12-14 10:30:00 | QQQ | ETF | 44.47 | 44.57 | 44.36 | 44.52 | 10492800.0 |
| 2006-12-14 11:00:00 | QQQ | ETF | 44.52 | 44.55 | 44.42 | 44.44 | 4074700.0 |
| 2006-12-14 11:30:00 | QQQ | ETF | 44.45 | 44.49 | 44.44 | 44.46 | 2573800.0 |
| 2006-12-14 12:00:00 | QQQ | ETF | 44.46 | 44.49 | 44.38 | 44.41 | 4410200.0 |
| 2006-12-14 12:30:00 | QQQ | ETF | 44.41 | 44.48 | 44.37 | 44.42 | 3064100.0 |
| 2006-12-14 13:00:00 | QQQ | ETF | 44.43 | 44.48 | 44.41 | 44.45 | 3123100.0 |
| 2006-12-14 13:30:00 | QQQ | ETF | 44.45 | 44.5 | 44.4 | 44.44 | 3513100.0 |
| 2006-12-14 14:00:00 | QQQ | ETF | 44.44 | 44.47 | 44.41 | 44.44 | 2254700.0 |
| 2006-12-14 14:30:00 | QQQ | ETF | 44.44 | 44.53 | 44.44 | 44.53 | 5205900.0 |
| 2006-12-14 15:00:00 | QQQ | ETF | 44.53 | 44.53 | 44.41 | 44.41 | 6340400.0 |
| 2006-12-14 15:30:00 | QQQ | ETF | 44.42 | 44.47 | 44.34 | 44.37 | 9222900.0 |
| 2006-12-14 08:00:00 | IWM | ETF | 78.52 | 78.64 | 78.52 | 78.64 | 1005800.0 |
| 2006-12-14 08:30:00 | IWM | ETF | 78.62 | 78.73 | 78.62 | 78.73 | 1100.0 |
| 2006-12-14 09:00:00 | IWM | ETF | 78.69 | 78.7 | 78.64 | 78.65 | 69300.0 |
| 2006-12-14 09:30:00 | IWM | ETF | 78.62 | 79.45 | 78.56 | 79.34 | 8470500.0 |
| 2006-12-14 10:00:00 | IWM | ETF | 79.33 | 79.59 | 79.28 | 79.35 | 16408500.0 |
| 2006-12-14 10:30:00 | IWM | ETF | 79.35 | 79.42 | 79.17 | 79.26 | 3105700.0 |
| 2006-12-14 11:00:00 | IWM | ETF | 79.24 | 79.32 | 79.2 | 79.24 | 1227900.0 |
| 2006-12-14 11:30:00 | IWM | ETF | 79.25 | 79.25 | 79.15 | 79.16 | 844300.0 |
| 2006-12-14 12:00:00 | IWM | ETF | 79.16 | 79.21 | 79.1 | 79.17 | 1274500.0 |
| 2006-12-14 12:30:00 | IWM | ETF | 79.17 | 79.27 | 79.16 | 79.19 | 3101400.0 |
| 2006-12-14 13:00:00 | IWM | ETF | 79.2 | 79.27 | 79.13 | 79.24 | 984700.0 |
> showing 50 of 3,110 rows — these rows as CSV