PREVIEW / etf_30min / 2004-04-13
file: by_date/etf_30min/2004/2004-04-13.parquet size: 38 KB rows: 1,213
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-04-13 08:00:00 | SPY | ETF | 115.14 | 115.26 | 115.14 | 115.22 | 8900.0 |
| 2004-04-13 08:30:00 | SPY | ETF | 115.3 | 115.42 | 115.25 | 115.33 | 91700.0 |
| 2004-04-13 09:00:00 | SPY | ETF | 115.33 | 115.35 | 115.26 | 115.28 | 73600.0 |
| 2004-04-13 09:30:00 | SPY | ETF | 115.25 | 115.28 | 114.65 | 114.68 | 2628700.0 |
| 2004-04-13 10:00:00 | SPY | ETF | 114.67 | 114.68 | 114.2 | 114.32 | 3050200.0 |
| 2004-04-13 10:30:00 | SPY | ETF | 114.31 | 114.5 | 114.26 | 114.43 | 4010700.0 |
| 2004-04-13 11:00:00 | SPY | ETF | 114.43 | 114.46 | 114.16 | 114.31 | 1682200.0 |
| 2004-04-13 11:30:00 | SPY | ETF | 114.31 | 114.39 | 114.21 | 114.28 | 787100.0 |
| 2004-04-13 12:00:00 | SPY | ETF | 114.28 | 114.29 | 113.89 | 113.94 | 2047100.0 |
| 2004-04-13 12:30:00 | SPY | ETF | 113.93 | 114.0 | 113.74 | 113.91 | 3101500.0 |
| 2004-04-13 13:00:00 | SPY | ETF | 113.94 | 113.97 | 113.71 | 113.83 | 1814100.0 |
| 2004-04-13 13:30:00 | SPY | ETF | 113.83 | 113.85 | 113.41 | 113.5 | 3792900.0 |
| 2004-04-13 14:00:00 | SPY | ETF | 113.5 | 113.64 | 113.28 | 113.36 | 3683400.0 |
| 2004-04-13 14:30:00 | SPY | ETF | 113.38 | 113.44 | 113.18 | 113.33 | 3476600.0 |
| 2004-04-13 15:00:00 | SPY | ETF | 113.29 | 113.36 | 113.08 | 113.29 | 3288000.0 |
| 2004-04-13 15:30:00 | SPY | ETF | 113.45 | 113.54 | 113.2 | 113.29 | 2344400.0 |
| 2004-04-13 16:00:00 | SPY | ETF | 113.29 | 113.4 | 113.02 | 113.15 | 2426800.0 |
| 2004-04-13 16:30:00 | SPY | ETF | 113.15 | 113.28 | 113.04 | 113.06 | 1079000.0 |
| 2004-04-13 17:00:00 | SPY | ETF | 113.07 | 113.12 | 112.98 | 112.98 | 227900.0 |
| 2004-04-13 17:30:00 | SPY | ETF | 112.99 | 113.0 | 112.95 | 112.98 | 5500.0 |
| 2004-04-13 18:00:00 | SPY | ETF | 112.99 | 113.12 | 112.99 | 113.12 | 5400.0 |
| 2004-04-13 18:30:00 | SPY | ETF | 113.08 | 113.08 | 113.08 | 113.08 | 500.0 |
| 2004-04-13 19:00:00 | SPY | ETF | 113.11 | 113.11 | 113.1 | 113.1 | 500.0 |
| 2004-04-13 08:00:00 | QQQ | ETF | 37.25 | 37.32 | 37.25 | 37.32 | 76000.0 |
| 2004-04-13 08:30:00 | QQQ | ETF | 37.33 | 37.44 | 37.32 | 37.35 | 181300.0 |
| 2004-04-13 09:00:00 | QQQ | ETF | 37.35 | 37.37 | 37.34 | 37.36 | 54800.0 |
| 2004-04-13 09:30:00 | QQQ | ETF | 37.34 | 37.357 | 37.1 | 37.104 | 6868400.0 |
| 2004-04-13 10:00:00 | QQQ | ETF | 37.12 | 37.12 | 36.89 | 36.901 | 6357500.0 |
| 2004-04-13 10:30:00 | QQQ | ETF | 36.901 | 36.98 | 36.88 | 36.95 | 4025600.0 |
| 2004-04-13 11:00:00 | QQQ | ETF | 36.95 | 37.0 | 36.87 | 36.97 | 4068100.0 |
| 2004-04-13 11:30:00 | QQQ | ETF | 36.96 | 37.001 | 36.92 | 36.951 | 3555600.0 |
| 2004-04-13 12:00:00 | QQQ | ETF | 36.95 | 36.96 | 36.86 | 36.9 | 2849500.0 |
| 2004-04-13 12:30:00 | QQQ | ETF | 36.88 | 36.92 | 36.82 | 36.89 | 3935400.0 |
| 2004-04-13 13:00:00 | QQQ | ETF | 36.892 | 36.91 | 36.84 | 36.89 | 1790600.0 |
| 2004-04-13 13:30:00 | QQQ | ETF | 36.88 | 36.89 | 36.67 | 36.74 | 6156800.0 |
| 2004-04-13 14:00:00 | QQQ | ETF | 36.74 | 36.78 | 36.58 | 36.632 | 7437500.0 |
| 2004-04-13 14:30:00 | QQQ | ETF | 36.63 | 36.657 | 36.55 | 36.603 | 7483000.0 |
| 2004-04-13 15:00:00 | QQQ | ETF | 36.6 | 36.67 | 36.52 | 36.61 | 5648100.0 |
| 2004-04-13 15:30:00 | QQQ | ETF | 36.69 | 36.73 | 36.6 | 36.61 | 5106700.0 |
| 2004-04-13 16:00:00 | QQQ | ETF | 36.61 | 36.7 | 36.44 | 36.56 | 4756700.0 |
| 2004-04-13 16:30:00 | QQQ | ETF | 36.56 | 36.61 | 36.428 | 36.56 | 1129900.0 |
| 2004-04-13 17:00:00 | QQQ | ETF | 36.56 | 36.62 | 36.53 | 36.53 | 236200.0 |
| 2004-04-13 17:30:00 | QQQ | ETF | 36.531 | 36.531 | 36.45 | 36.5 | 94900.0 |
| 2004-04-13 18:00:00 | QQQ | ETF | 36.52 | 36.55 | 36.5 | 36.54 | 78700.0 |
| 2004-04-13 18:30:00 | QQQ | ETF | 36.52 | 36.52 | 36.48 | 36.49 | 86500.0 |
| 2004-04-13 19:00:00 | QQQ | ETF | 36.51 | 36.51 | 36.5 | 36.51 | 7100.0 |
| 2004-04-13 19:30:00 | QQQ | ETF | 36.51 | 36.55 | 36.51 | 36.55 | 4300.0 |
| 2004-04-13 08:30:00 | IWM | ETF | 60.075 | 60.075 | 60.075 | 60.075 | 1000.0 |
| 2004-04-13 09:00:00 | IWM | ETF | 60.045 | 60.045 | 60.045 | 60.045 | 1000.0 |
| 2004-04-13 09:30:00 | IWM | ETF | 60.075 | 60.075 | 59.45 | 59.47 | 509800.0 |
> showing 50 of 1,213 rows — these rows as CSV