PREVIEW / etf_30min / 2005-12-20
file: by_date/etf_30min/2005/2005-12-20.parquet size: 57 KB rows: 2,077
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-20 07:00:00 | SPY | ETF | 125.95 | 125.99 | 125.93 | 125.95 | 6300.0 |
| 2005-12-20 07:30:00 | SPY | ETF | 125.91 | 125.94 | 125.89 | 125.89 | 26700.0 |
| 2005-12-20 08:00:00 | SPY | ETF | 125.9 | 125.98 | 125.89 | 125.92 | 215500.0 |
| 2005-12-20 08:30:00 | SPY | ETF | 125.95 | 126.1 | 125.95 | 125.95 | 844600.0 |
| 2005-12-20 09:00:00 | SPY | ETF | 125.95 | 126.02 | 125.8 | 125.85 | 349200.0 |
| 2005-12-20 09:30:00 | SPY | ETF | 125.86 | 125.99 | 125.71 | 125.9 | 6106300.0 |
| 2005-12-20 10:00:00 | SPY | ETF | 125.9 | 126.57 | 125.48 | 125.55 | 5696500.0 |
| 2005-12-20 10:30:00 | SPY | ETF | 125.54 | 126.59 | 125.52 | 125.79 | 3939700.0 |
| 2005-12-20 11:00:00 | SPY | ETF | 125.78 | 125.9 | 125.76 | 125.86 | 2026700.0 |
| 2005-12-20 11:30:00 | SPY | ETF | 125.86 | 125.95 | 125.75 | 125.75 | 2172900.0 |
| 2005-12-20 12:00:00 | SPY | ETF | 125.75 | 126.08 | 125.71 | 125.99 | 4201900.0 |
| 2005-12-20 12:30:00 | SPY | ETF | 126.0 | 126.15 | 125.9 | 126.13 | 2107200.0 |
| 2005-12-20 13:00:00 | SPY | ETF | 126.15 | 126.22 | 126.01 | 126.08 | 3067800.0 |
| 2005-12-20 13:30:00 | SPY | ETF | 126.09 | 126.2 | 125.87 | 125.97 | 3231300.0 |
| 2005-12-20 14:00:00 | SPY | ETF | 125.95 | 125.99 | 125.76 | 125.9 | 2183600.0 |
| 2005-12-20 14:30:00 | SPY | ETF | 125.91 | 125.99 | 125.77 | 125.86 | 1796800.0 |
| 2005-12-20 15:00:00 | SPY | ETF | 125.86 | 125.87 | 125.56 | 125.59 | 2928300.0 |
| 2005-12-20 15:30:00 | SPY | ETF | 125.59 | 125.79 | 125.56 | 125.77 | 3820300.0 |
| 2005-12-20 16:00:00 | SPY | ETF | 125.77 | 125.85 | 125.74 | 125.83 | 540300.0 |
| 2005-12-20 16:30:00 | SPY | ETF | 125.83 | 125.85 | 125.81 | 125.85 | 354600.0 |
| 2005-12-20 17:00:00 | SPY | ETF | 125.84 | 125.84 | 125.84 | 125.84 | 3000.0 |
| 2005-12-20 17:30:00 | SPY | ETF | 125.83 | 125.83 | 125.8 | 125.8 | 1300.0 |
| 2005-12-20 18:00:00 | SPY | ETF | 125.79 | 125.79 | 125.78 | 125.78 | 2000.0 |
| 2005-12-20 18:30:00 | SPY | ETF | 125.76 | 125.76 | 125.72 | 125.74 | 1700.0 |
| 2005-12-20 19:00:00 | SPY | ETF | 125.78 | 125.78 | 125.78 | 125.78 | 100.0 |
| 2005-12-20 19:30:00 | SPY | ETF | 125.81 | 125.81 | 125.81 | 125.81 | 200.0 |
| 2005-12-20 09:30:00 | QQQ | ETF | 40.95 | 41.01 | 40.79 | 40.9 | 11997200.0 |
| 2005-12-20 10:00:00 | QQQ | ETF | 40.9 | 40.92 | 40.75 | 40.8 | 7041700.0 |
| 2005-12-20 10:30:00 | QQQ | ETF | 40.8 | 40.93 | 40.8 | 40.92 | 6504000.0 |
| 2005-12-20 11:00:00 | QQQ | ETF | 40.93 | 40.98 | 40.89 | 40.96 | 3518000.0 |
| 2005-12-20 11:30:00 | QQQ | ETF | 40.96 | 41.04 | 40.92 | 41.0 | 3903600.0 |
| 2005-12-20 12:00:00 | QQQ | ETF | 40.92 | 41.08 | 40.92 | 41.02 | 5603900.0 |
| 2005-12-20 12:30:00 | QQQ | ETF | 41.03 | 41.12 | 41.01 | 41.1 | 2605200.0 |
| 2005-12-20 13:00:00 | QQQ | ETF | 41.1 | 41.15 | 41.06 | 41.1 | 4443800.0 |
| 2005-12-20 13:30:00 | QQQ | ETF | 41.11 | 41.12 | 40.99 | 41.04 | 3854400.0 |
| 2005-12-20 14:00:00 | QQQ | ETF | 41.03 | 41.08 | 40.95 | 41.03 | 2234000.0 |
| 2005-12-20 14:30:00 | QQQ | ETF | 41.03 | 41.06 | 40.93 | 40.95 | 3696200.0 |
| 2005-12-20 15:00:00 | QQQ | ETF | 40.95 | 41.03 | 40.85 | 40.86 | 4538900.0 |
| 2005-12-20 15:30:00 | QQQ | ETF | 40.86 | 40.97 | 40.86 | 40.96 | 5920900.0 |
| 2005-12-20 08:00:00 | IWM | ETF | 67.05 | 67.05 | 67.05 | 67.05 | 3500.0 |
| 2005-12-20 08:30:00 | IWM | ETF | 67.09 | 67.13 | 67.09 | 67.09 | 10400.0 |
| 2005-12-20 09:00:00 | IWM | ETF | 67.11 | 67.12 | 66.94 | 66.94 | 169000.0 |
| 2005-12-20 09:30:00 | IWM | ETF | 66.92 | 67.01 | 66.68 | 66.89 | 3981000.0 |
| 2005-12-20 10:00:00 | IWM | ETF | 66.88 | 66.9 | 66.54 | 66.58 | 2622300.0 |
| 2005-12-20 10:30:00 | IWM | ETF | 66.58 | 66.9 | 66.57 | 66.86 | 2566500.0 |
| 2005-12-20 11:00:00 | IWM | ETF | 66.86 | 67.0 | 66.85 | 66.99 | 1517600.0 |
| 2005-12-20 11:30:00 | IWM | ETF | 66.99 | 67.13 | 66.99 | 67.02 | 2917900.0 |
| 2005-12-20 12:00:00 | IWM | ETF | 67.02 | 67.53 | 66.98 | 67.42 | 3672400.0 |
| 2005-12-20 12:30:00 | IWM | ETF | 67.42 | 67.49 | 67.3 | 67.47 | 1147300.0 |
| 2005-12-20 13:00:00 | IWM | ETF | 67.48 | 67.48 | 67.25 | 67.44 | 599000.0 |
> showing 50 of 2,077 rows — these rows as CSV