PREVIEW / etf_30min / 2005-10-18
file: by_date/etf_30min/2005/2005-10-18.parquet size: 49 KB rows: 1,715
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-10-18 06:30:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 1000.0 |
| 2005-10-18 07:30:00 | SPY | ETF | 119.15 | 119.18 | 119.15 | 119.18 | 131500.0 |
| 2005-10-18 08:00:00 | SPY | ETF | 119.22 | 119.25 | 119.06 | 119.06 | 1015900.0 |
| 2005-10-18 08:30:00 | SPY | ETF | 119.08 | 119.08 | 118.83 | 118.95 | 2771800.0 |
| 2005-10-18 09:00:00 | SPY | ETF | 118.95 | 119.15 | 118.8 | 118.94 | 1408600.0 |
| 2005-10-18 09:30:00 | SPY | ETF | 118.94 | 118.96 | 118.62 | 118.67 | 5902300.0 |
| 2005-10-18 10:00:00 | SPY | ETF | 118.68 | 118.91 | 118.58 | 118.65 | 6664200.0 |
| 2005-10-18 10:30:00 | SPY | ETF | 118.65 | 118.7 | 118.5 | 118.61 | 3566700.0 |
| 2005-10-18 11:00:00 | SPY | ETF | 118.62 | 118.89 | 118.61 | 118.6885 | 7170600.0 |
| 2005-10-18 11:30:00 | SPY | ETF | 118.69 | 118.82 | 118.61 | 118.76 | 3008600.0 |
| 2005-10-18 12:00:00 | SPY | ETF | 118.76 | 118.96 | 118.71 | 118.81 | 1374700.0 |
| 2005-10-18 12:30:00 | SPY | ETF | 118.81 | 118.91 | 118.65 | 118.67 | 878400.0 |
| 2005-10-18 13:00:00 | SPY | ETF | 118.67 | 118.69 | 118.2 | 118.33 | 7956800.0 |
| 2005-10-18 13:30:00 | SPY | ETF | 118.34 | 118.42 | 118.14 | 118.4 | 6773400.0 |
| 2005-10-18 14:00:00 | SPY | ETF | 118.4 | 118.55 | 118.24 | 118.35 | 4547200.0 |
| 2005-10-18 14:30:00 | SPY | ETF | 118.35 | 118.57 | 118.05 | 118.17 | 6381500.0 |
| 2005-10-18 15:00:00 | SPY | ETF | 118.17 | 118.4 | 118.06 | 118.31 | 3633000.0 |
| 2005-10-18 15:30:00 | SPY | ETF | 118.31 | 118.42 | 117.87 | 117.9 | 7029300.0 |
| 2005-10-18 16:00:00 | SPY | ETF | 117.87 | 118.05 | 117.78 | 118.0 | 848500.0 |
| 2005-10-18 16:30:00 | SPY | ETF | 117.97 | 117.97 | 117.63 | 117.66 | 672400.0 |
| 2005-10-18 17:00:00 | SPY | ETF | 117.7 | 117.71 | 117.63 | 117.64 | 45500.0 |
| 2005-10-18 17:30:00 | SPY | ETF | 117.66 | 117.66 | 117.59 | 117.59 | 16400.0 |
| 2005-10-18 18:00:00 | SPY | ETF | 117.59 | 117.73 | 117.59 | 117.66 | 11700.0 |
| 2005-10-18 19:00:00 | SPY | ETF | 117.63 | 117.63 | 117.6 | 117.6 | 7100.0 |
| 2005-10-18 09:30:00 | QQQ | ETF | 38.14 | 38.17 | 38.03 | 38.08 | 9973000.0 |
| 2005-10-18 10:00:00 | QQQ | ETF | 38.08 | 38.16 | 38.04 | 38.07 | 6704200.0 |
| 2005-10-18 10:30:00 | QQQ | ETF | 38.07 | 38.11 | 38.03 | 38.09 | 7099200.0 |
| 2005-10-18 11:00:00 | QQQ | ETF | 38.09 | 38.17 | 38.09 | 38.12 | 3769800.0 |
| 2005-10-18 11:30:00 | QQQ | ETF | 38.11 | 38.15 | 38.08 | 38.11 | 1865400.0 |
| 2005-10-18 12:00:00 | QQQ | ETF | 38.12 | 38.18 | 38.1 | 38.15 | 3946100.0 |
| 2005-10-18 12:30:00 | QQQ | ETF | 38.15 | 38.16 | 38.09 | 38.1 | 2654300.0 |
| 2005-10-18 13:00:00 | QQQ | ETF | 38.1 | 38.1 | 37.98 | 38.04 | 5049100.0 |
| 2005-10-18 13:30:00 | QQQ | ETF | 38.04 | 38.04 | 37.92 | 38.02 | 8022000.0 |
| 2005-10-18 14:00:00 | QQQ | ETF | 38.02 | 38.11 | 37.97 | 38.08 | 5513500.0 |
| 2005-10-18 14:30:00 | QQQ | ETF | 38.08 | 38.12 | 37.97 | 38.0 | 7048000.0 |
| 2005-10-18 15:00:00 | QQQ | ETF | 38.0 | 38.13 | 37.94 | 38.1 | 6539900.0 |
| 2005-10-18 15:30:00 | QQQ | ETF | 38.11 | 38.15 | 37.91 | 37.91 | 9641400.0 |
| 2005-10-18 08:00:00 | IWM | ETF | 63.09 | 63.11 | 63.08 | 63.08 | 68400.0 |
| 2005-10-18 08:30:00 | IWM | ETF | 63.05 | 63.05 | 62.89 | 62.91 | 53300.0 |
| 2005-10-18 09:00:00 | IWM | ETF | 62.9 | 63.0 | 62.79 | 62.91 | 341600.0 |
| 2005-10-18 09:30:00 | IWM | ETF | 62.9 | 62.97 | 62.53 | 62.59 | 2671300.0 |
| 2005-10-18 10:00:00 | IWM | ETF | 62.58 | 62.88 | 62.51 | 62.72 | 3665800.0 |
| 2005-10-18 10:30:00 | IWM | ETF | 62.72 | 62.88 | 62.59 | 62.84 | 2218000.0 |
| 2005-10-18 11:00:00 | IWM | ETF | 62.82 | 63.03 | 62.81 | 62.82 | 2426400.0 |
| 2005-10-18 11:30:00 | IWM | ETF | 62.81 | 62.86 | 62.72 | 62.78 | 472300.0 |
| 2005-10-18 12:00:00 | IWM | ETF | 62.77 | 62.97 | 62.74 | 62.78 | 607800.0 |
| 2005-10-18 12:30:00 | IWM | ETF | 62.78 | 62.85 | 62.67 | 62.68 | 370700.0 |
| 2005-10-18 13:00:00 | IWM | ETF | 62.68 | 62.71 | 62.27 | 62.36 | 4371100.0 |
| 2005-10-18 13:30:00 | IWM | ETF | 62.36 | 62.4 | 62.19 | 62.4 | 1702100.0 |
| 2005-10-18 14:00:00 | IWM | ETF | 62.38 | 62.52 | 62.31 | 62.39 | 994000.0 |
> showing 50 of 1,715 rows — these rows as CSV