PREVIEW / etf_30min / 2006-12-13
file: by_date/etf_30min/2006/2006-12-13.parquet size: 86 KB rows: 3,057
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-13 05:30:00 | SPY | ETF | 141.95 | 141.95 | 141.95 | 141.95 | 400.0 |
| 2006-12-13 07:00:00 | SPY | ETF | 142.02 | 142.06 | 141.97 | 142.05 | 16400.0 |
| 2006-12-13 07:30:00 | SPY | ETF | 142.04 | 142.1 | 142.04 | 142.1 | 24400.0 |
| 2006-12-13 08:00:00 | SPY | ETF | 142.1 | 142.12 | 141.97 | 142.05 | 849000.0 |
| 2006-12-13 08:30:00 | SPY | ETF | 142.05 | 142.3 | 142.03 | 142.28 | 1623800.0 |
| 2006-12-13 09:00:00 | SPY | ETF | 142.26 | 142.34 | 142.19 | 142.22 | 996100.0 |
| 2006-12-13 09:30:00 | SPY | ETF | 142.23 | 142.34 | 141.96 | 142.07 | 7404200.0 |
| 2006-12-13 10:00:00 | SPY | ETF | 142.08 | 142.11 | 141.71 | 141.85 | 6385200.0 |
| 2006-12-13 10:30:00 | SPY | ETF | 141.85 | 141.87 | 141.56 | 141.85 | 5113400.0 |
| 2006-12-13 11:00:00 | SPY | ETF | 141.84 | 142.17 | 141.76 | 141.98 | 2593500.0 |
| 2006-12-13 11:30:00 | SPY | ETF | 141.97 | 142.02 | 141.87 | 142.0 | 1858300.0 |
| 2006-12-13 12:00:00 | SPY | ETF | 142.02 | 142.02 | 141.76 | 141.79 | 2441500.0 |
| 2006-12-13 12:30:00 | SPY | ETF | 141.8 | 141.87 | 141.7 | 141.84 | 1120600.0 |
| 2006-12-13 13:00:00 | SPY | ETF | 141.82 | 141.94 | 141.79 | 141.86 | 1091100.0 |
| 2006-12-13 13:30:00 | SPY | ETF | 141.86 | 141.91 | 141.61 | 141.76 | 2242900.0 |
| 2006-12-13 14:00:00 | SPY | ETF | 141.75 | 141.87 | 141.71 | 141.75 | 2298200.0 |
| 2006-12-13 14:30:00 | SPY | ETF | 141.75 | 141.77 | 141.62 | 141.67 | 6511700.0 |
| 2006-12-13 15:00:00 | SPY | ETF | 141.6706 | 141.84 | 141.63 | 141.77 | 2054500.0 |
| 2006-12-13 15:30:00 | SPY | ETF | 141.76 | 141.99 | 141.73 | 141.85 | 6173100.0 |
| 2006-12-13 16:00:00 | SPY | ETF | 141.87 | 141.92 | 141.79 | 141.9 | 717200.0 |
| 2006-12-13 16:30:00 | SPY | ETF | 141.88 | 142.0707 | 141.79 | 141.86 | 1655600.0 |
| 2006-12-13 17:00:00 | SPY | ETF | 141.85 | 141.87 | 141.78 | 141.8 | 103600.0 |
| 2006-12-13 17:30:00 | SPY | ETF | 141.8 | 141.81 | 141.8 | 141.81 | 1000.0 |
| 2006-12-13 18:00:00 | SPY | ETF | 141.82 | 141.82 | 141.82 | 141.82 | 1000.0 |
| 2006-12-13 18:30:00 | SPY | ETF | 141.83 | 141.88 | 141.83 | 141.88 | 5800.0 |
| 2006-12-13 19:00:00 | SPY | ETF | 141.86 | 141.86 | 141.86 | 141.86 | 1000.0 |
| 2006-12-13 09:30:00 | QQQ | ETF | 44.1 | 44.11 | 43.9 | 43.91 | 13250200.0 |
| 2006-12-13 10:00:00 | QQQ | ETF | 43.92 | 43.93 | 43.77 | 43.83 | 7922700.0 |
| 2006-12-13 10:30:00 | QQQ | ETF | 43.82 | 43.82 | 43.62 | 43.78 | 9294200.0 |
| 2006-12-13 11:00:00 | QQQ | ETF | 43.78 | 43.86 | 43.72 | 43.86 | 4655700.0 |
| 2006-12-13 11:30:00 | QQQ | ETF | 43.86 | 43.87 | 43.8 | 43.83 | 2825800.0 |
| 2006-12-13 12:00:00 | QQQ | ETF | 43.83 | 43.84 | 43.66 | 43.69 | 4731500.0 |
| 2006-12-13 12:30:00 | QQQ | ETF | 43.69 | 43.75 | 43.63 | 43.73 | 3526200.0 |
| 2006-12-13 13:00:00 | QQQ | ETF | 43.73 | 43.8 | 43.7 | 43.75 | 2793100.0 |
| 2006-12-13 13:30:00 | QQQ | ETF | 43.75 | 43.77 | 43.62 | 43.76 | 3615800.0 |
| 2006-12-13 14:00:00 | QQQ | ETF | 43.76 | 43.82 | 43.71 | 43.72 | 3283400.0 |
| 2006-12-13 14:30:00 | QQQ | ETF | 43.72 | 43.78 | 43.67 | 43.75 | 5433700.0 |
| 2006-12-13 15:00:00 | QQQ | ETF | 43.75 | 43.8 | 43.72 | 43.76 | 3272200.0 |
| 2006-12-13 15:30:00 | QQQ | ETF | 43.76 | 43.89 | 43.75 | 43.88 | 6017200.0 |
| 2006-12-13 07:30:00 | IWM | ETF | 78.77 | 78.79 | 78.77 | 78.77 | 10500.0 |
| 2006-12-13 08:00:00 | IWM | ETF | 78.77 | 78.79 | 78.71 | 78.71 | 30700.0 |
| 2006-12-13 08:30:00 | IWM | ETF | 78.77 | 78.94 | 78.76 | 78.93 | 137600.0 |
| 2006-12-13 09:00:00 | IWM | ETF | 78.93 | 79.0 | 78.85 | 78.9 | 342700.0 |
| 2006-12-13 09:30:00 | IWM | ETF | 78.91 | 79.0 | 78.76 | 78.84 | 4027800.0 |
| 2006-12-13 10:00:00 | IWM | ETF | 78.84 | 78.95 | 78.57 | 78.69 | 3390900.0 |
| 2006-12-13 10:30:00 | IWM | ETF | 78.69 | 78.69 | 78.34 | 78.52 | 4157000.0 |
| 2006-12-13 11:00:00 | IWM | ETF | 78.53 | 78.63 | 78.47 | 78.63 | 1837500.0 |
| 2006-12-13 11:30:00 | IWM | ETF | 78.63 | 78.65 | 78.54 | 78.63 | 1350000.0 |
| 2006-12-13 12:00:00 | IWM | ETF | 78.63 | 78.63 | 78.41 | 78.51 | 1190700.0 |
| 2006-12-13 12:30:00 | IWM | ETF | 78.5 | 78.51 | 78.34 | 78.44 | 1744400.0 |
> showing 50 of 3,057 rows — these rows as CSV