PREVIEW / etf_30min / 2004-10-06
file: by_date/etf_30min/2004/2004-10-06.parquet size: 36 KB rows: 1,211
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-06 08:00:00 | SPY | ETF | 113.8 | 113.8 | 113.79 | 113.79 | 2000.0 |
| 2004-10-06 08:30:00 | SPY | ETF | 113.83 | 113.89 | 113.83 | 113.87 | 23600.0 |
| 2004-10-06 09:00:00 | SPY | ETF | 113.86 | 113.86 | 113.73 | 113.73 | 67600.0 |
| 2004-10-06 09:30:00 | SPY | ETF | 113.77 | 113.94 | 113.69 | 113.76 | 4261900.0 |
| 2004-10-06 10:00:00 | SPY | ETF | 113.77 | 113.97 | 113.68 | 113.97 | 2296400.0 |
| 2004-10-06 10:30:00 | SPY | ETF | 113.97 | 114.03 | 113.72 | 113.76 | 6376200.0 |
| 2004-10-06 11:00:00 | SPY | ETF | 113.73 | 113.96 | 113.71 | 113.83 | 3322300.0 |
| 2004-10-06 11:30:00 | SPY | ETF | 113.83 | 113.95 | 113.77 | 113.88 | 2784400.0 |
| 2004-10-06 12:00:00 | SPY | ETF | 113.9 | 114.11 | 113.87 | 114.04 | 1959300.0 |
| 2004-10-06 12:30:00 | SPY | ETF | 114.04 | 114.15 | 113.98 | 113.99 | 1783200.0 |
| 2004-10-06 13:00:00 | SPY | ETF | 114.0 | 114.065 | 113.9 | 113.91 | 1138900.0 |
| 2004-10-06 13:30:00 | SPY | ETF | 113.91 | 113.99 | 113.86 | 113.92 | 1071700.0 |
| 2004-10-06 14:00:00 | SPY | ETF | 113.92 | 114.08 | 113.88 | 114.03 | 1258300.0 |
| 2004-10-06 14:30:00 | SPY | ETF | 114.03 | 114.06 | 113.88 | 113.96 | 1749900.0 |
| 2004-10-06 15:00:00 | SPY | ETF | 113.95 | 114.37 | 113.94 | 114.35 | 4503100.0 |
| 2004-10-06 15:30:00 | SPY | ETF | 114.35 | 114.6 | 114.27 | 114.57 | 5870200.0 |
| 2004-10-06 16:00:00 | SPY | ETF | 114.57 | 114.68 | 114.47 | 114.61 | 1524600.0 |
| 2004-10-06 16:30:00 | SPY | ETF | 114.61 | 114.61 | 113.948 | 114.61 | 124400.0 |
| 2004-10-06 17:00:00 | SPY | ETF | 114.57 | 114.62 | 114.54 | 114.62 | 67200.0 |
| 2004-10-06 17:30:00 | SPY | ETF | 114.58 | 114.6 | 114.55 | 114.6 | 51600.0 |
| 2004-10-06 18:00:00 | SPY | ETF | 114.59 | 114.61 | 114.57 | 114.61 | 2400.0 |
| 2004-10-06 18:30:00 | SPY | ETF | 114.58 | 114.58 | 114.58 | 114.58 | 500.0 |
| 2004-10-06 19:30:00 | SPY | ETF | 114.58 | 114.58 | 114.58 | 114.58 | 100.0 |
| 2004-10-06 08:00:00 | QQQ | ETF | 36.35 | 36.35 | 36.32 | 36.33 | 35400.0 |
| 2004-10-06 08:30:00 | QQQ | ETF | 36.33 | 36.36 | 36.33 | 36.35 | 81300.0 |
| 2004-10-06 09:00:00 | QQQ | ETF | 36.35 | 36.35 | 36.32 | 36.32 | 104900.0 |
| 2004-10-06 09:30:00 | QQQ | ETF | 36.31 | 36.34 | 36.119 | 36.15 | 11941100.0 |
| 2004-10-06 10:00:00 | QQQ | ETF | 36.15 | 36.28 | 36.11 | 36.26 | 6572400.0 |
| 2004-10-06 10:30:00 | QQQ | ETF | 36.27 | 36.31 | 36.158 | 36.18 | 8579200.0 |
| 2004-10-06 11:00:00 | QQQ | ETF | 36.18 | 36.275 | 36.16 | 36.22 | 4016100.0 |
| 2004-10-06 11:30:00 | QQQ | ETF | 36.22 | 36.33 | 36.19 | 36.29 | 4266600.0 |
| 2004-10-06 12:00:00 | QQQ | ETF | 36.278 | 36.43 | 36.26 | 36.39 | 6860900.0 |
| 2004-10-06 12:30:00 | QQQ | ETF | 36.38 | 36.42 | 36.35 | 36.35 | 3530200.0 |
| 2004-10-06 13:00:00 | QQQ | ETF | 36.36 | 36.4 | 36.31 | 36.32 | 2694300.0 |
| 2004-10-06 13:30:00 | QQQ | ETF | 36.31 | 36.35 | 36.28 | 36.3 | 2451900.0 |
| 2004-10-06 14:00:00 | QQQ | ETF | 36.299 | 36.38 | 36.299 | 36.35 | 4177600.0 |
| 2004-10-06 14:30:00 | QQQ | ETF | 36.35 | 36.39 | 36.25 | 36.311 | 4490500.0 |
| 2004-10-06 15:00:00 | QQQ | ETF | 36.31 | 36.542 | 36.299 | 36.541 | 10062800.0 |
| 2004-10-06 15:30:00 | QQQ | ETF | 36.52 | 36.65 | 36.48 | 36.63 | 11479700.0 |
| 2004-10-06 16:00:00 | QQQ | ETF | 36.64 | 36.69 | 36.62 | 36.66 | 3024600.0 |
| 2004-10-06 16:30:00 | QQQ | ETF | 36.66 | 36.71 | 36.63 | 36.66 | 613200.0 |
| 2004-10-06 17:00:00 | QQQ | ETF | 36.65 | 36.654 | 36.63 | 36.65 | 109600.0 |
| 2004-10-06 17:30:00 | QQQ | ETF | 36.64 | 36.68 | 36.64 | 36.66 | 76000.0 |
| 2004-10-06 18:00:00 | QQQ | ETF | 36.67 | 36.68 | 36.56 | 36.67 | 120900.0 |
| 2004-10-06 18:30:00 | QQQ | ETF | 36.66 | 36.66 | 36.65 | 36.66 | 10900.0 |
| 2004-10-06 19:30:00 | QQQ | ETF | 36.69 | 36.69 | 36.67 | 36.68 | 3800.0 |
| 2004-10-06 09:00:00 | IWM | ETF | 58.56 | 58.56 | 58.555 | 58.555 | 1800.0 |
| 2004-10-06 09:30:00 | IWM | ETF | 58.595 | 58.73 | 58.47 | 58.475 | 1167000.0 |
| 2004-10-06 10:00:00 | IWM | ETF | 58.475 | 58.62 | 58.44 | 58.605 | 486800.0 |
| 2004-10-06 10:30:00 | IWM | ETF | 58.625 | 58.625 | 58.475 | 58.5 | 606200.0 |
> showing 50 of 1,211 rows — these rows as CSV