PREVIEW / etf_30min / 2006-12-18
file: by_date/etf_30min/2006/2006-12-18.parquet size: 92 KB rows: 3,125
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-18 07:00:00 | SPY | ETF | 142.7 | 142.72 | 142.61 | 142.61 | 15600.0 |
| 2006-12-18 07:30:00 | SPY | ETF | 142.67 | 142.68 | 142.63 | 142.63 | 15900.0 |
| 2006-12-18 08:00:00 | SPY | ETF | 142.66 | 142.72 | 142.53 | 142.54 | 329700.0 |
| 2006-12-18 08:30:00 | SPY | ETF | 142.54 | 142.69 | 142.34 | 142.64 | 728900.0 |
| 2006-12-18 09:00:00 | SPY | ETF | 142.65 | 142.69 | 142.56 | 142.56 | 120600.0 |
| 2006-12-18 09:30:00 | SPY | ETF | 142.54 | 142.87 | 142.47 | 142.81 | 6889700.0 |
| 2006-12-18 10:00:00 | SPY | ETF | 142.8 | 142.88 | 142.69 | 142.7 | 3377200.0 |
| 2006-12-18 10:30:00 | SPY | ETF | 142.7 | 142.71 | 142.51 | 142.56 | 1893500.0 |
| 2006-12-18 11:00:00 | SPY | ETF | 142.57 | 142.6 | 142.42 | 142.51 | 2284400.0 |
| 2006-12-18 11:30:00 | SPY | ETF | 142.51 | 142.57 | 142.3 | 142.35 | 2024300.0 |
| 2006-12-18 12:00:00 | SPY | ETF | 142.34 | 142.36 | 142.09 | 142.32 | 4646200.0 |
| 2006-12-18 12:30:00 | SPY | ETF | 142.32 | 142.42 | 142.3 | 142.32 | 1328200.0 |
| 2006-12-18 13:00:00 | SPY | ETF | 142.31 | 142.38 | 142.18 | 142.31 | 1857700.0 |
| 2006-12-18 13:30:00 | SPY | ETF | 142.29 | 142.49 | 142.26 | 142.39 | 5840300.0 |
| 2006-12-18 14:00:00 | SPY | ETF | 142.38 | 142.43 | 142.19 | 142.22 | 1392700.0 |
| 2006-12-18 14:30:00 | SPY | ETF | 142.23 | 142.26 | 141.87 | 141.98 | 3712600.0 |
| 2006-12-18 15:00:00 | SPY | ETF | 141.98 | 141.98 | 141.75 | 141.89 | 4957000.0 |
| 2006-12-18 15:30:00 | SPY | ETF | 141.89 | 142.01 | 141.89 | 141.93 | 4210000.0 |
| 2006-12-18 16:00:00 | SPY | ETF | 141.95 | 141.99 | 141.92 | 141.95 | 582500.0 |
| 2006-12-18 16:30:00 | SPY | ETF | 141.95 | 142.06 | 141.95 | 142.0 | 142500.0 |
| 2006-12-18 17:00:00 | SPY | ETF | 142.0 | 142.0 | 141.93 | 141.93 | 80800.0 |
| 2006-12-18 17:30:00 | SPY | ETF | 141.95 | 141.97 | 141.92 | 141.95 | 2900.0 |
| 2006-12-18 18:00:00 | SPY | ETF | 141.95 | 141.99 | 141.95 | 141.95 | 1700.0 |
| 2006-12-18 18:30:00 | SPY | ETF | 141.95 | 141.97 | 141.95 | 141.97 | 500.0 |
| 2006-12-18 19:00:00 | SPY | ETF | 141.97 | 141.97 | 141.97 | 141.97 | 100.0 |
| 2006-12-18 19:30:00 | SPY | ETF | 141.95 | 141.95 | 141.95 | 141.95 | 500.0 |
| 2006-12-18 09:30:00 | QQQ | ETF | 44.58 | 44.73 | 44.52 | 44.7 | 14347000.0 |
| 2006-12-18 10:00:00 | QQQ | ETF | 44.71 | 44.75 | 44.57 | 44.57 | 10599300.0 |
| 2006-12-18 10:30:00 | QQQ | ETF | 44.58 | 44.62 | 44.51 | 44.54 | 5176500.0 |
| 2006-12-18 11:00:00 | QQQ | ETF | 44.55 | 44.57 | 44.47 | 44.51 | 4577700.0 |
| 2006-12-18 11:30:00 | QQQ | ETF | 44.51 | 44.51 | 44.38 | 44.43 | 6590200.0 |
| 2006-12-18 12:00:00 | QQQ | ETF | 44.43 | 44.44 | 44.22 | 44.3 | 7055900.0 |
| 2006-12-18 12:30:00 | QQQ | ETF | 44.29 | 44.37 | 44.29 | 44.29 | 4508500.0 |
| 2006-12-18 13:00:00 | QQQ | ETF | 44.29 | 44.34 | 44.22 | 44.27 | 4068900.0 |
| 2006-12-18 13:30:00 | QQQ | ETF | 44.28 | 44.38 | 44.25 | 44.32 | 3412600.0 |
| 2006-12-18 14:00:00 | QQQ | ETF | 44.32 | 44.35 | 44.24 | 44.25 | 2899000.0 |
| 2006-12-18 14:30:00 | QQQ | ETF | 44.25 | 44.28 | 43.91 | 44.0 | 21367600.0 |
| 2006-12-18 15:00:00 | QQQ | ETF | 44.01 | 44.01 | 43.8 | 43.92 | 10035500.0 |
| 2006-12-18 15:30:00 | QQQ | ETF | 43.92 | 44.04 | 43.91 | 43.98 | 12173100.0 |
| 2006-12-18 08:00:00 | IWM | ETF | 79.1 | 79.14 | 79.08 | 79.1 | 21900.0 |
| 2006-12-18 08:30:00 | IWM | ETF | 79.09 | 79.17 | 79.08 | 79.15 | 33400.0 |
| 2006-12-18 09:00:00 | IWM | ETF | 79.14 | 79.23 | 79.08 | 79.08 | 369600.0 |
| 2006-12-18 09:30:00 | IWM | ETF | 79.06 | 79.19 | 78.85 | 79.11 | 3394900.0 |
| 2006-12-18 10:00:00 | IWM | ETF | 79.12 | 79.21 | 78.98 | 78.98 | 2039200.0 |
| 2006-12-18 10:30:00 | IWM | ETF | 78.97 | 79.06 | 78.86 | 78.92 | 1427800.0 |
| 2006-12-18 11:00:00 | IWM | ETF | 78.92 | 78.95 | 78.74 | 78.8 | 1662100.0 |
| 2006-12-18 11:30:00 | IWM | ETF | 78.8 | 78.86 | 78.53 | 78.54 | 2609300.0 |
| 2006-12-18 12:00:00 | IWM | ETF | 78.54 | 78.54 | 78.13 | 78.27 | 3947400.0 |
| 2006-12-18 12:30:00 | IWM | ETF | 78.26 | 78.3 | 78.17 | 78.19 | 1493000.0 |
| 2006-12-18 13:00:00 | IWM | ETF | 78.18 | 78.24 | 78.06 | 78.16 | 1663300.0 |
> showing 50 of 3,125 rows — these rows as CSV