PREVIEW / etf_30min / 2006-12-12
file: by_date/etf_30min/2006/2006-12-12.parquet size: 88 KB rows: 3,032
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-12 04:00:00 | SPY | ETF | 141.87 | 141.87 | 141.87 | 141.87 | 1800.0 |
| 2006-12-12 06:00:00 | SPY | ETF | 141.71 | 141.71 | 141.71 | 141.71 | 1400.0 |
| 2006-12-12 07:00:00 | SPY | ETF | 141.7 | 141.74 | 141.7 | 141.74 | 5200.0 |
| 2006-12-12 07:30:00 | SPY | ETF | 141.74 | 141.75 | 141.73 | 141.73 | 14800.0 |
| 2006-12-12 08:00:00 | SPY | ETF | 141.76 | 141.76 | 141.65 | 141.73 | 286400.0 |
| 2006-12-12 08:30:00 | SPY | ETF | 141.71 | 141.79 | 141.65 | 141.74 | 227700.0 |
| 2006-12-12 09:00:00 | SPY | ETF | 141.76 | 141.76 | 141.66 | 141.68 | 366800.0 |
| 2006-12-12 09:30:00 | SPY | ETF | 141.69 | 141.76 | 141.59 | 141.69 | 3589200.0 |
| 2006-12-12 10:00:00 | SPY | ETF | 141.68 | 141.74 | 141.55 | 141.73 | 3735000.0 |
| 2006-12-12 10:30:00 | SPY | ETF | 141.72 | 141.87 | 141.66 | 141.69 | 3812600.0 |
| 2006-12-12 11:00:00 | SPY | ETF | 141.68 | 141.81 | 141.67 | 141.79 | 1293300.0 |
| 2006-12-12 11:30:00 | SPY | ETF | 141.79 | 141.79 | 141.49 | 141.52 | 5134900.0 |
| 2006-12-12 12:00:00 | SPY | ETF | 141.52 | 141.72 | 140.89 | 141.0 | 11538200.0 |
| 2006-12-12 12:30:00 | SPY | ETF | 141.02 | 141.22 | 140.99 | 141.18 | 4054200.0 |
| 2006-12-12 13:00:00 | SPY | ETF | 141.18 | 141.22 | 141.14 | 141.22 | 2865800.0 |
| 2006-12-12 13:30:00 | SPY | ETF | 141.22 | 141.35 | 141.19 | 141.25 | 2057200.0 |
| 2006-12-12 14:00:00 | SPY | ETF | 141.25 | 141.73 | 141.07 | 141.58 | 14065400.0 |
| 2006-12-12 14:30:00 | SPY | ETF | 141.59 | 141.72 | 141.27 | 141.57 | 8050100.0 |
| 2006-12-12 15:00:00 | SPY | ETF | 141.57 | 141.73 | 141.42 | 141.54 | 5872500.0 |
| 2006-12-12 15:30:00 | SPY | ETF | 141.54 | 141.7 | 141.46 | 141.62 | 4535700.0 |
| 2006-12-12 16:00:00 | SPY | ETF | 141.65 | 141.77 | 141.65 | 141.67 | 1498700.0 |
| 2006-12-12 16:30:00 | SPY | ETF | 141.67 | 141.72 | 141.64 | 141.65 | 297700.0 |
| 2006-12-12 17:00:00 | SPY | ETF | 141.65 | 141.65 | 141.65 | 141.65 | 100.0 |
| 2006-12-12 17:30:00 | SPY | ETF | 141.68 | 141.68 | 141.68 | 141.68 | 700.0 |
| 2006-12-12 18:00:00 | SPY | ETF | 141.65 | 141.66 | 141.65 | 141.66 | 600.0 |
| 2006-12-12 18:30:00 | SPY | ETF | 141.66 | 141.66 | 141.62 | 141.62 | 3100.0 |
| 2006-12-12 19:30:00 | SPY | ETF | 141.6 | 141.61 | 141.6 | 141.6 | 5300.0 |
| 2006-12-12 09:30:00 | QQQ | ETF | 44.03 | 44.13 | 43.93 | 44.07 | 8985900.0 |
| 2006-12-12 10:00:00 | QQQ | ETF | 44.07 | 44.08 | 43.83 | 43.94 | 11495700.0 |
| 2006-12-12 10:30:00 | QQQ | ETF | 43.94 | 44.04 | 43.93 | 43.94 | 4815300.0 |
| 2006-12-12 11:00:00 | QQQ | ETF | 43.93 | 43.98 | 43.9 | 43.96 | 1881800.0 |
| 2006-12-12 11:30:00 | QQQ | ETF | 43.97 | 43.97 | 43.82 | 43.86 | 4459400.0 |
| 2006-12-12 12:00:00 | QQQ | ETF | 43.86 | 43.87 | 43.56 | 43.61 | 14989200.0 |
| 2006-12-12 12:30:00 | QQQ | ETF | 43.6 | 43.71 | 43.59 | 43.64 | 5793400.0 |
| 2006-12-12 13:00:00 | QQQ | ETF | 43.65 | 43.69 | 43.63 | 43.68 | 2136300.0 |
| 2006-12-12 13:30:00 | QQQ | ETF | 43.68 | 43.73 | 43.67 | 43.7 | 2474300.0 |
| 2006-12-12 14:00:00 | QQQ | ETF | 43.69 | 43.95 | 43.61 | 43.82 | 22309100.0 |
| 2006-12-12 14:30:00 | QQQ | ETF | 43.82 | 43.89 | 43.67 | 43.82 | 10913700.0 |
| 2006-12-12 15:00:00 | QQQ | ETF | 43.78 | 43.86 | 43.7 | 43.74 | 6327500.0 |
| 2006-12-12 15:30:00 | QQQ | ETF | 43.74 | 43.85 | 43.71 | 43.81 | 6240600.0 |
| 2006-12-12 08:00:00 | IWM | ETF | 78.9 | 78.95 | 78.9 | 78.95 | 4000.0 |
| 2006-12-12 08:30:00 | IWM | ETF | 78.97 | 79.03 | 78.92 | 78.98 | 31100.0 |
| 2006-12-12 09:00:00 | IWM | ETF | 78.96 | 78.96 | 78.9 | 78.93 | 57000.0 |
| 2006-12-12 09:30:00 | IWM | ETF | 78.94 | 79.02 | 78.83 | 78.88 | 1956600.0 |
| 2006-12-12 10:00:00 | IWM | ETF | 78.87 | 78.89 | 78.65 | 78.7 | 2897500.0 |
| 2006-12-12 10:30:00 | IWM | ETF | 78.7 | 78.85 | 78.68 | 78.7 | 2068100.0 |
| 2006-12-12 11:00:00 | IWM | ETF | 78.69 | 78.78 | 78.67 | 78.76 | 554400.0 |
| 2006-12-12 11:30:00 | IWM | ETF | 78.76 | 78.78 | 78.43 | 78.52 | 2563200.0 |
| 2006-12-12 12:00:00 | IWM | ETF | 78.51 | 78.53 | 78.05 | 78.13 | 5101500.0 |
| 2006-12-12 12:30:00 | IWM | ETF | 78.12 | 78.22 | 78.08 | 78.2 | 2042200.0 |
> showing 50 of 3,032 rows — these rows as CSV