PREVIEW / etf_30min / 2005-03-17
file: by_date/etf_30min/2005/2005-03-17.parquet size: 43 KB rows: 1,499
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-03-17 08:00:00 | SPY | ETF | 119.08 | 119.3 | 119.08 | 119.3 | 90200.0 |
| 2005-03-17 08:30:00 | SPY | ETF | 119.2 | 119.29 | 119.2 | 119.28 | 54900.0 |
| 2005-03-17 09:00:00 | SPY | ETF | 119.29 | 119.35 | 119.27 | 119.33 | 138500.0 |
| 2005-03-17 09:30:00 | SPY | ETF | 119.31 | 119.41 | 119.04 | 119.07 | 8702000.0 |
| 2005-03-17 10:00:00 | SPY | ETF | 119.07 | 119.4 | 118.98 | 119.36 | 7147100.0 |
| 2005-03-17 10:30:00 | SPY | ETF | 119.36 | 119.55 | 119.21 | 119.52 | 6302800.0 |
| 2005-03-17 11:00:00 | SPY | ETF | 119.52 | 119.65 | 119.42 | 119.5 | 4900600.0 |
| 2005-03-17 11:30:00 | SPY | ETF | 119.5 | 119.58 | 119.48 | 119.54 | 1600900.0 |
| 2005-03-17 12:00:00 | SPY | ETF | 119.54 | 119.63 | 119.38 | 119.61 | 3261900.0 |
| 2005-03-17 12:30:00 | SPY | ETF | 119.6 | 119.74 | 119.51 | 119.53 | 5012700.0 |
| 2005-03-17 13:00:00 | SPY | ETF | 119.52 | 119.6 | 119.39 | 119.44 | 2426900.0 |
| 2005-03-17 13:30:00 | SPY | ETF | 119.44 | 119.57 | 119.32 | 119.34 | 2521000.0 |
| 2005-03-17 14:00:00 | SPY | ETF | 119.36 | 119.6 | 119.17 | 119.56 | 8128200.0 |
| 2005-03-17 14:30:00 | SPY | ETF | 119.55 | 119.61 | 119.47 | 119.58 | 2096300.0 |
| 2005-03-17 15:00:00 | SPY | ETF | 119.59 | 119.71 | 119.47 | 119.62 | 2758300.0 |
| 2005-03-17 15:30:00 | SPY | ETF | 119.61 | 119.66 | 119.38 | 119.43 | 6096800.0 |
| 2005-03-17 16:00:00 | SPY | ETF | 119.4 | 119.44 | 119.25 | 119.35 | 252700.0 |
| 2005-03-17 16:30:00 | SPY | ETF | 119.35 | 119.4 | 119.32 | 119.36 | 21200.0 |
| 2005-03-17 17:00:00 | SPY | ETF | 119.33 | 119.36 | 119.33 | 119.34 | 139400.0 |
| 2005-03-17 17:30:00 | SPY | ETF | 119.36 | 119.36 | 119.32 | 119.35 | 7200.0 |
| 2005-03-17 18:00:00 | SPY | ETF | 119.35 | 119.42 | 119.33 | 119.38 | 135900.0 |
| 2005-03-17 19:00:00 | SPY | ETF | 119.41 | 119.41 | 119.41 | 119.41 | 2400.0 |
| 2005-03-17 19:30:00 | SPY | ETF | 119.45 | 119.51 | 119.45 | 119.51 | 11700.0 |
| 2005-03-17 09:30:00 | QQQ | ETF | 36.63 | 36.7 | 36.55 | 36.58 | 21082700.0 |
| 2005-03-17 10:00:00 | QQQ | ETF | 36.58 | 36.75 | 36.54 | 36.73 | 10245800.0 |
| 2005-03-17 10:30:00 | QQQ | ETF | 36.73 | 36.83 | 36.65 | 36.82 | 8388800.0 |
| 2005-03-17 11:00:00 | QQQ | ETF | 36.81 | 36.89 | 36.78 | 36.8 | 8413400.0 |
| 2005-03-17 11:30:00 | QQQ | ETF | 36.8 | 36.87 | 36.8 | 36.84 | 2634300.0 |
| 2005-03-17 12:00:00 | QQQ | ETF | 36.85 | 36.86 | 36.77 | 36.84 | 3906800.0 |
| 2005-03-17 12:30:00 | QQQ | ETF | 36.85 | 36.89 | 36.79 | 36.79 | 4490900.0 |
| 2005-03-17 13:00:00 | QQQ | ETF | 36.8 | 36.81 | 36.73 | 36.76 | 3987100.0 |
| 2005-03-17 13:30:00 | QQQ | ETF | 36.75 | 36.81 | 36.68 | 36.71 | 3111600.0 |
| 2005-03-17 14:00:00 | QQQ | ETF | 36.71 | 36.85 | 36.63 | 36.83 | 6256100.0 |
| 2005-03-17 14:30:00 | QQQ | ETF | 36.83 | 36.85 | 36.76 | 36.84 | 4787700.0 |
| 2005-03-17 15:00:00 | QQQ | ETF | 36.84 | 36.88 | 36.79 | 36.81 | 6326200.0 |
| 2005-03-17 15:30:00 | QQQ | ETF | 36.81 | 36.84 | 36.68 | 36.69 | 7436500.0 |
| 2005-03-17 08:00:00 | IWM | ETF | 62.18 | 62.18 | 62.18 | 62.18 | 4000.0 |
| 2005-03-17 08:30:00 | IWM | ETF | 62.25 | 62.26 | 62.25 | 62.25 | 1600.0 |
| 2005-03-17 09:00:00 | IWM | ETF | 62.25 | 62.29 | 62.25 | 62.29 | 2200.0 |
| 2005-03-17 09:30:00 | IWM | ETF | 62.26 | 62.26 | 61.945 | 61.955 | 2605000.0 |
| 2005-03-17 10:00:00 | IWM | ETF | 61.96 | 62.3 | 61.92 | 62.285 | 1917400.0 |
| 2005-03-17 10:30:00 | IWM | ETF | 62.285 | 62.425 | 62.175 | 62.405 | 1595200.0 |
| 2005-03-17 11:00:00 | IWM | ETF | 62.41 | 62.45 | 62.28 | 62.32 | 2210000.0 |
| 2005-03-17 11:30:00 | IWM | ETF | 62.325 | 62.35 | 62.275 | 62.32 | 2084600.0 |
| 2005-03-17 12:00:00 | IWM | ETF | 62.315 | 62.33 | 62.23 | 62.295 | 333000.0 |
| 2005-03-17 12:30:00 | IWM | ETF | 62.29 | 62.4 | 62.275 | 62.33 | 662400.0 |
| 2005-03-17 13:00:00 | IWM | ETF | 62.33 | 62.33 | 62.195 | 62.23 | 1071800.0 |
| 2005-03-17 13:30:00 | IWM | ETF | 62.23 | 62.275 | 62.1 | 62.165 | 978200.0 |
| 2005-03-17 14:00:00 | IWM | ETF | 62.15 | 62.34 | 62.1 | 62.295 | 1099200.0 |
| 2005-03-17 14:30:00 | IWM | ETF | 62.315 | 62.415 | 62.265 | 62.4 | 775200.0 |
> showing 50 of 1,499 rows — these rows as CSV