PREVIEW / etf_30min / 2006-12-11
file: by_date/etf_30min/2006/2006-12-11.parquet size: 84 KB rows: 3,033
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-11 04:00:00 | SPY | ETF | 141.66 | 141.66 | 141.66 | 141.66 | 7000.0 |
| 2006-12-11 06:00:00 | SPY | ETF | 141.69 | 141.69 | 141.68 | 141.68 | 11500.0 |
| 2006-12-11 06:30:00 | SPY | ETF | 141.64 | 141.64 | 141.63 | 141.63 | 50000.0 |
| 2006-12-11 07:00:00 | SPY | ETF | 141.65 | 141.66 | 141.64 | 141.66 | 31000.0 |
| 2006-12-11 07:30:00 | SPY | ETF | 141.65 | 141.66 | 141.63 | 141.64 | 31900.0 |
| 2006-12-11 08:00:00 | SPY | ETF | 141.66 | 141.71 | 141.42 | 141.6 | 1383200.0 |
| 2006-12-11 08:30:00 | SPY | ETF | 141.59 | 141.59 | 141.56 | 141.58 | 208100.0 |
| 2006-12-11 09:00:00 | SPY | ETF | 141.56 | 141.62 | 141.39 | 141.42 | 499500.0 |
| 2006-12-11 09:30:00 | SPY | ETF | 141.42 | 141.69 | 141.34 | 141.64 | 6043600.0 |
| 2006-12-11 10:00:00 | SPY | ETF | 141.65 | 142.09 | 141.54 | 141.86 | 7243100.0 |
| 2006-12-11 10:30:00 | SPY | ETF | 141.87 | 141.94 | 141.77 | 141.82 | 2837300.0 |
| 2006-12-11 11:00:00 | SPY | ETF | 141.83 | 141.94 | 141.79 | 141.89 | 2343300.0 |
| 2006-12-11 11:30:00 | SPY | ETF | 141.88 | 142.01 | 141.79 | 141.88 | 1931400.0 |
| 2006-12-11 12:00:00 | SPY | ETF | 141.89 | 141.91 | 141.58 | 141.67 | 2718400.0 |
| 2006-12-11 12:30:00 | SPY | ETF | 141.67 | 141.8 | 141.65 | 141.74 | 1273700.0 |
| 2006-12-11 13:00:00 | SPY | ETF | 141.74 | 141.89 | 141.67 | 141.82 | 1331300.0 |
| 2006-12-11 13:30:00 | SPY | ETF | 141.82 | 141.89 | 141.76 | 141.85 | 749200.0 |
| 2006-12-11 14:00:00 | SPY | ETF | 141.86 | 141.86 | 141.78 | 141.83 | 1103900.0 |
| 2006-12-11 14:30:00 | SPY | ETF | 141.83 | 141.89 | 141.74 | 141.76 | 1229100.0 |
| 2006-12-11 15:00:00 | SPY | ETF | 141.75 | 141.86 | 141.72 | 141.77 | 1225000.0 |
| 2006-12-11 15:30:00 | SPY | ETF | 141.77 | 141.8 | 141.66 | 141.74 | 4068000.0 |
| 2006-12-11 16:00:00 | SPY | ETF | 141.76 | 141.87 | 141.75 | 141.82 | 1535300.0 |
| 2006-12-11 16:30:00 | SPY | ETF | 141.8 | 141.88 | 141.77 | 141.82 | 360100.0 |
| 2006-12-11 17:00:00 | SPY | ETF | 141.81 | 141.84 | 141.78 | 141.8 | 133600.0 |
| 2006-12-11 17:30:00 | SPY | ETF | 141.83 | 141.83 | 141.83 | 141.83 | 1700.0 |
| 2006-12-11 18:30:00 | SPY | ETF | 141.83 | 141.83 | 141.8 | 141.8 | 1200.0 |
| 2006-12-11 19:00:00 | SPY | ETF | 141.83 | 141.83 | 141.83 | 141.83 | 500.0 |
| 2006-12-11 19:30:00 | SPY | ETF | 141.83 | 141.83 | 141.8 | 141.8 | 3100.0 |
| 2006-12-11 09:30:00 | QQQ | ETF | 43.83 | 44.03 | 43.75 | 44.02 | 10683500.0 |
| 2006-12-11 10:00:00 | QQQ | ETF | 44.02 | 44.37 | 43.96 | 44.25 | 17022200.0 |
| 2006-12-11 10:30:00 | QQQ | ETF | 44.26 | 44.31 | 44.21 | 44.24 | 4539400.0 |
| 2006-12-11 11:00:00 | QQQ | ETF | 44.25 | 44.35 | 44.25 | 44.3 | 5406100.0 |
| 2006-12-11 11:30:00 | QQQ | ETF | 44.3 | 44.32 | 44.22 | 44.23 | 1597000.0 |
| 2006-12-11 12:00:00 | QQQ | ETF | 44.24 | 44.26 | 44.12 | 44.19 | 3067000.0 |
| 2006-12-11 12:30:00 | QQQ | ETF | 44.19 | 44.24 | 44.13 | 44.16 | 4907900.0 |
| 2006-12-11 13:00:00 | QQQ | ETF | 44.15 | 44.27 | 44.13 | 44.22 | 3345900.0 |
| 2006-12-11 13:30:00 | QQQ | ETF | 44.23 | 44.25 | 44.19 | 44.21 | 991600.0 |
| 2006-12-11 14:00:00 | QQQ | ETF | 44.22 | 44.22 | 44.16 | 44.19 | 1914500.0 |
| 2006-12-11 14:30:00 | QQQ | ETF | 44.19 | 44.23 | 44.16 | 44.18 | 2508800.0 |
| 2006-12-11 15:00:00 | QQQ | ETF | 44.17 | 44.22 | 44.11 | 44.13 | 2936700.0 |
| 2006-12-11 15:30:00 | QQQ | ETF | 44.14 | 44.14 | 44.05 | 44.05 | 6940600.0 |
| 2006-12-11 08:00:00 | IWM | ETF | 78.93 | 78.93 | 78.86 | 78.86 | 38900.0 |
| 2006-12-11 08:30:00 | IWM | ETF | 78.87 | 78.89 | 78.84 | 78.84 | 6800.0 |
| 2006-12-11 09:00:00 | IWM | ETF | 78.87 | 78.87 | 78.71 | 78.78 | 19400.0 |
| 2006-12-11 09:30:00 | IWM | ETF | 78.8 | 78.93 | 78.54 | 78.91 | 3692600.0 |
| 2006-12-11 10:00:00 | IWM | ETF | 78.92 | 79.18 | 78.81 | 79.09 | 4259900.0 |
| 2006-12-11 10:30:00 | IWM | ETF | 79.09 | 79.16 | 78.88 | 78.93 | 1371600.0 |
| 2006-12-11 11:00:00 | IWM | ETF | 78.9224 | 79.08 | 78.91 | 79.025 | 753700.0 |
| 2006-12-11 11:30:00 | IWM | ETF | 79.03 | 79.08 | 78.91 | 78.99 | 1871900.0 |
| 2006-12-11 12:00:00 | IWM | ETF | 78.99 | 79.03 | 78.8 | 78.87 | 1099900.0 |
> showing 50 of 3,033 rows — these rows as CSV