PREVIEW / etf_30min / 2005-01-03
file: by_date/etf_30min/2005/2005-01-03.parquet size: 45 KB rows: 1,498
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-01-03 08:00:00 | SPY | ETF | 121.6 | 121.6 | 121.52 | 121.56 | 143200.0 |
| 2005-01-03 08:30:00 | SPY | ETF | 121.57 | 121.6 | 121.53 | 121.55 | 284200.0 |
| 2005-01-03 09:00:00 | SPY | ETF | 121.54 | 121.62 | 121.45 | 121.56 | 247900.0 |
| 2005-01-03 09:30:00 | SPY | ETF | 121.56 | 121.76 | 121.47 | 121.52 | 5974100.0 |
| 2005-01-03 10:00:00 | SPY | ETF | 121.53 | 121.64 | 120.88 | 120.98 | 8743800.0 |
| 2005-01-03 10:30:00 | SPY | ETF | 120.98 | 121.2 | 120.7 | 120.84 | 7161000.0 |
| 2005-01-03 11:00:00 | SPY | ETF | 120.84 | 120.84 | 120.49 | 120.71 | 3769300.0 |
| 2005-01-03 11:30:00 | SPY | ETF | 120.71 | 121.56 | 120.68 | 120.83 | 2131500.0 |
| 2005-01-03 12:00:00 | SPY | ETF | 120.83 | 120.84 | 120.58 | 120.62 | 1248100.0 |
| 2005-01-03 12:30:00 | SPY | ETF | 120.63 | 121.52 | 120.57 | 120.69 | 1585200.0 |
| 2005-01-03 13:00:00 | SPY | ETF | 120.68 | 120.69 | 120.26 | 120.32 | 2544700.0 |
| 2005-01-03 13:30:00 | SPY | ETF | 120.33 | 120.47 | 120.29 | 120.32 | 1985200.0 |
| 2005-01-03 14:00:00 | SPY | ETF | 120.33 | 120.48 | 120.3 | 120.33 | 3226700.0 |
| 2005-01-03 14:30:00 | SPY | ETF | 120.33 | 120.56 | 120.24 | 120.28 | 2431400.0 |
| 2005-01-03 15:00:00 | SPY | ETF | 120.27 | 120.41 | 120.09 | 120.15 | 4816000.0 |
| 2005-01-03 15:30:00 | SPY | ETF | 120.15 | 120.18 | 119.9 | 120.06 | 6819400.0 |
| 2005-01-03 16:00:00 | SPY | ETF | 120.05 | 120.7 | 119.98 | 120.24 | 843700.0 |
| 2005-01-03 16:30:00 | SPY | ETF | 120.27 | 120.33 | 120.06 | 120.27 | 195200.0 |
| 2005-01-03 17:00:00 | SPY | ETF | 120.26 | 120.29 | 120.12 | 120.25 | 248100.0 |
| 2005-01-03 17:30:00 | SPY | ETF | 120.31 | 120.31 | 120.25 | 120.25 | 300.0 |
| 2005-01-03 18:00:00 | SPY | ETF | 120.28 | 120.3 | 120.28 | 120.3 | 1200.0 |
| 2005-01-03 18:30:00 | SPY | ETF | 120.28 | 120.3 | 120.28 | 120.3 | 3000.0 |
| 2005-01-03 19:30:00 | SPY | ETF | 120.31 | 120.32 | 120.31 | 120.31 | 1400.0 |
| 2005-01-03 09:30:00 | QQQ | ETF | 40.07 | 40.29 | 40.06 | 40.13 | 13154100.0 |
| 2005-01-03 10:00:00 | QQQ | ETF | 40.13 | 40.21 | 39.71 | 39.73 | 17321300.0 |
| 2005-01-03 10:30:00 | QQQ | ETF | 39.73 | 39.74 | 39.37 | 39.57 | 16252400.0 |
| 2005-01-03 11:00:00 | QQQ | ETF | 39.58 | 39.6 | 39.45 | 39.6 | 5885600.0 |
| 2005-01-03 11:30:00 | QQQ | ETF | 39.6 | 39.7 | 39.42 | 39.64 | 5297000.0 |
| 2005-01-03 12:00:00 | QQQ | ETF | 39.64 | 39.65 | 39.54 | 39.59 | 4070400.0 |
| 2005-01-03 12:30:00 | QQQ | ETF | 39.6 | 39.68 | 39.58 | 39.68 | 2309900.0 |
| 2005-01-03 13:00:00 | QQQ | ETF | 39.68 | 39.68 | 39.52 | 39.56 | 3403000.0 |
| 2005-01-03 13:30:00 | QQQ | ETF | 39.56 | 39.64 | 39.53 | 39.57 | 3065300.0 |
| 2005-01-03 14:00:00 | QQQ | ETF | 39.57 | 39.66 | 39.55 | 39.61 | 3666000.0 |
| 2005-01-03 14:30:00 | QQQ | ETF | 39.61 | 39.73 | 39.57 | 39.6 | 4772700.0 |
| 2005-01-03 15:00:00 | QQQ | ETF | 39.61 | 39.67 | 39.47 | 39.51 | 5227000.0 |
| 2005-01-03 15:30:00 | QQQ | ETF | 39.51 | 39.54 | 39.41 | 39.49 | 8937800.0 |
| 2005-01-03 08:00:00 | IWM | ETF | 65.16 | 65.16 | 65.155 | 65.155 | 4600.0 |
| 2005-01-03 08:30:00 | IWM | ETF | 65.155 | 65.155 | 65.135 | 65.155 | 4800.0 |
| 2005-01-03 09:00:00 | IWM | ETF | 65.155 | 65.18 | 65.085 | 65.14 | 9400.0 |
| 2005-01-03 09:30:00 | IWM | ETF | 65.095 | 65.21 | 64.915 | 64.975 | 2022400.0 |
| 2005-01-03 10:00:00 | IWM | ETF | 64.955 | 64.985 | 64.115 | 64.155 | 1729000.0 |
| 2005-01-03 10:30:00 | IWM | ETF | 64.145 | 64.145 | 63.75 | 64.065 | 2250600.0 |
| 2005-01-03 11:00:00 | IWM | ETF | 64.07 | 64.075 | 63.895 | 64.025 | 1113600.0 |
| 2005-01-03 11:30:00 | IWM | ETF | 64.025 | 64.215 | 64.02 | 64.15 | 939400.0 |
| 2005-01-03 12:00:00 | IWM | ETF | 64.15 | 64.15 | 64.06 | 64.14 | 478800.0 |
| 2005-01-03 12:30:00 | IWM | ETF | 64.14 | 64.275 | 64.105 | 64.195 | 442600.0 |
| 2005-01-03 13:00:00 | IWM | ETF | 64.195 | 64.195 | 63.905 | 63.94 | 553400.0 |
| 2005-01-03 13:30:00 | IWM | ETF | 63.945 | 64.0 | 63.84 | 63.91 | 494000.0 |
| 2005-01-03 14:00:00 | IWM | ETF | 63.9 | 64.055 | 63.89 | 63.98 | 878600.0 |
| 2005-01-03 14:30:00 | IWM | ETF | 63.985 | 64.125 | 63.885 | 63.895 | 483600.0 |
> showing 50 of 1,498 rows — these rows as CSV