PREVIEW / etf_30min / 2006-12-19
file: by_date/etf_30min/2006/2006-12-19.parquet size: 93 KB rows: 3,203
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-19 06:00:00 | SPY | ETF | 141.62 | 141.62 | 141.62 | 141.62 | 24800.0 |
| 2006-12-19 07:00:00 | SPY | ETF | 141.62 | 141.62 | 141.47 | 141.47 | 43300.0 |
| 2006-12-19 07:30:00 | SPY | ETF | 141.47 | 141.77 | 141.47 | 141.75 | 162000.0 |
| 2006-12-19 08:00:00 | SPY | ETF | 141.58 | 141.8 | 141.438 | 141.77 | 1144900.0 |
| 2006-12-19 08:30:00 | SPY | ETF | 141.63 | 141.69 | 141.37 | 141.59 | 2006200.0 |
| 2006-12-19 09:00:00 | SPY | ETF | 141.59 | 141.62 | 141.45 | 141.53 | 1047900.0 |
| 2006-12-19 09:30:00 | SPY | ETF | 141.55 | 141.68 | 141.19 | 141.51 | 14976800.0 |
| 2006-12-19 10:00:00 | SPY | ETF | 141.51 | 141.83 | 141.48 | 141.71 | 5538100.0 |
| 2006-12-19 10:30:00 | SPY | ETF | 141.71 | 141.93 | 141.67 | 141.88 | 4107200.0 |
| 2006-12-19 11:00:00 | SPY | ETF | 141.9 | 142.01 | 141.64 | 141.67 | 3784200.0 |
| 2006-12-19 11:30:00 | SPY | ETF | 141.67 | 141.75 | 141.56 | 141.62 | 2428500.0 |
| 2006-12-19 12:00:00 | SPY | ETF | 141.65 | 141.81 | 141.46 | 141.59 | 2625900.0 |
| 2006-12-19 12:30:00 | SPY | ETF | 141.58 | 141.8 | 141.58 | 141.69 | 1150000.0 |
| 2006-12-19 13:00:00 | SPY | ETF | 141.69 | 141.73 | 141.55 | 141.6 | 997100.0 |
| 2006-12-19 13:30:00 | SPY | ETF | 141.6 | 141.94 | 141.57 | 141.89 | 2471200.0 |
| 2006-12-19 14:00:00 | SPY | ETF | 141.89 | 142.28 | 141.88 | 142.04 | 6155400.0 |
| 2006-12-19 14:30:00 | SPY | ETF | 142.05 | 142.3 | 142.01 | 142.23 | 3838800.0 |
| 2006-12-19 15:00:00 | SPY | ETF | 142.24 | 142.56 | 142.23 | 142.37 | 4859700.0 |
| 2006-12-19 15:30:00 | SPY | ETF | 142.37 | 142.4 | 142.26 | 142.28 | 3311800.0 |
| 2006-12-19 16:00:00 | SPY | ETF | 142.28 | 142.28 | 142.16 | 142.21 | 1402100.0 |
| 2006-12-19 16:30:00 | SPY | ETF | 142.21 | 142.26 | 141.16 | 142.23 | 1246800.0 |
| 2006-12-19 17:00:00 | SPY | ETF | 142.24 | 142.29 | 142.24 | 142.26 | 47000.0 |
| 2006-12-19 17:30:00 | SPY | ETF | 142.29 | 142.33 | 142.29 | 142.33 | 6700.0 |
| 2006-12-19 18:00:00 | SPY | ETF | 142.25 | 142.25 | 142.2 | 142.21 | 55000.0 |
| 2006-12-19 18:30:00 | SPY | ETF | 142.21 | 142.24 | 142.19 | 142.22 | 1500.0 |
| 2006-12-19 09:30:00 | QQQ | ETF | 43.66 | 44.63 | 43.38 | 43.58 | 21306100.0 |
| 2006-12-19 10:00:00 | QQQ | ETF | 43.57 | 43.8 | 43.57 | 43.68 | 12493200.0 |
| 2006-12-19 10:30:00 | QQQ | ETF | 43.68 | 43.8 | 43.61 | 43.77 | 12443100.0 |
| 2006-12-19 11:00:00 | QQQ | ETF | 43.78 | 43.87 | 43.6 | 43.63 | 9529100.0 |
| 2006-12-19 11:30:00 | QQQ | ETF | 43.63 | 43.67 | 43.58 | 43.62 | 4641200.0 |
| 2006-12-19 12:00:00 | QQQ | ETF | 43.62 | 43.74 | 43.5 | 43.58 | 9725100.0 |
| 2006-12-19 12:30:00 | QQQ | ETF | 43.58 | 43.7 | 43.58 | 43.68 | 4146800.0 |
| 2006-12-19 13:00:00 | QQQ | ETF | 43.67 | 43.68 | 43.54 | 43.54 | 1688300.0 |
| 2006-12-19 13:30:00 | QQQ | ETF | 43.54 | 43.72 | 43.54 | 43.69 | 4737000.0 |
| 2006-12-19 14:00:00 | QQQ | ETF | 43.7 | 43.84 | 43.69 | 43.7 | 5418100.0 |
| 2006-12-19 14:30:00 | QQQ | ETF | 43.7 | 43.91 | 43.7 | 43.89 | 4951100.0 |
| 2006-12-19 15:00:00 | QQQ | ETF | 43.88 | 44.06 | 43.88 | 43.93 | 8830000.0 |
| 2006-12-19 15:30:00 | QQQ | ETF | 43.92 | 43.97 | 43.85 | 43.85 | 10669300.0 |
| 2006-12-19 07:30:00 | IWM | ETF | 77.61 | 77.69 | 77.6 | 77.69 | 20000.0 |
| 2006-12-19 08:00:00 | IWM | ETF | 77.69 | 77.69 | 77.55 | 77.64 | 739300.0 |
| 2006-12-19 08:30:00 | IWM | ETF | 77.59 | 78.05 | 77.39 | 77.55 | 767600.0 |
| 2006-12-19 09:00:00 | IWM | ETF | 77.53 | 77.56 | 77.41 | 77.45 | 699400.0 |
| 2006-12-19 09:30:00 | IWM | ETF | 77.45 | 77.5 | 77.1 | 77.33 | 8924500.0 |
| 2006-12-19 10:00:00 | IWM | ETF | 77.33 | 77.77 | 77.3 | 77.69 | 5961500.0 |
| 2006-12-19 10:30:00 | IWM | ETF | 77.69 | 77.76 | 77.45 | 77.7 | 4435500.0 |
| 2006-12-19 11:00:00 | IWM | ETF | 77.7 | 77.84 | 77.46 | 77.47 | 3718100.0 |
| 2006-12-19 11:30:00 | IWM | ETF | 77.47 | 77.75 | 77.36 | 77.39 | 2429700.0 |
| 2006-12-19 12:00:00 | IWM | ETF | 77.39 | 77.49 | 77.31 | 77.42 | 2488100.0 |
| 2006-12-19 12:30:00 | IWM | ETF | 77.41 | 77.55 | 77.41 | 77.5 | 801900.0 |
| 2006-12-19 13:00:00 | IWM | ETF | 77.5 | 77.52 | 77.42 | 77.47 | 452600.0 |
> showing 50 of 3,203 rows — these rows as CSV