PREVIEW / etf_30min / 2004-01-29
file: by_date/etf_30min/2004/2004-01-29.parquet size: 36 KB rows: 1,155
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-01-29 08:00:00 | SPY | ETF | 113.61 | 113.71 | 113.6 | 113.63 | 30700.0 |
| 2004-01-29 08:30:00 | SPY | ETF | 113.65 | 113.67 | 113.43 | 113.52 | 29000.0 |
| 2004-01-29 09:00:00 | SPY | ETF | 113.54 | 113.63 | 113.54 | 113.56 | 16700.0 |
| 2004-01-29 09:30:00 | SPY | ETF | 113.59 | 113.68 | 113.25 | 113.38 | 5438000.0 |
| 2004-01-29 10:00:00 | SPY | ETF | 113.38 | 113.41 | 113.07 | 113.35 | 5133700.0 |
| 2004-01-29 10:30:00 | SPY | ETF | 113.36 | 113.57 | 113.15 | 113.25 | 2968000.0 |
| 2004-01-29 11:00:00 | SPY | ETF | 113.26 | 113.42 | 113.03 | 113.33 | 3492200.0 |
| 2004-01-29 11:30:00 | SPY | ETF | 113.34 | 113.36 | 112.97 | 113.06 | 2208800.0 |
| 2004-01-29 12:00:00 | SPY | ETF | 113.03 | 113.23 | 112.96 | 113.18 | 1451100.0 |
| 2004-01-29 12:30:00 | SPY | ETF | 113.17 | 113.31 | 112.97 | 113.24 | 2004900.0 |
| 2004-01-29 13:00:00 | SPY | ETF | 113.3 | 113.33 | 112.67 | 112.82 | 5450700.0 |
| 2004-01-29 13:30:00 | SPY | ETF | 112.83 | 112.88 | 112.56 | 112.8 | 2878700.0 |
| 2004-01-29 14:00:00 | SPY | ETF | 112.8 | 113.37 | 112.67 | 113.2 | 4606600.0 |
| 2004-01-29 14:30:00 | SPY | ETF | 113.23 | 113.56 | 112.94 | 113.5 | 6459000.0 |
| 2004-01-29 15:00:00 | SPY | ETF | 113.5 | 113.83 | 113.45 | 113.59 | 4874500.0 |
| 2004-01-29 15:30:00 | SPY | ETF | 113.57 | 113.85 | 113.5 | 113.75 | 4311200.0 |
| 2004-01-29 16:00:00 | SPY | ETF | 113.71 | 113.76 | 113.48 | 113.6 | 2019400.0 |
| 2004-01-29 16:30:00 | SPY | ETF | 113.57 | 113.65 | 113.47 | 113.63 | 885300.0 |
| 2004-01-29 17:00:00 | SPY | ETF | 113.6 | 113.66 | 113.59 | 113.65 | 26000.0 |
| 2004-01-29 17:30:00 | SPY | ETF | 113.68 | 113.69 | 113.68 | 113.69 | 400.0 |
| 2004-01-29 18:00:00 | SPY | ETF | 113.66 | 113.66 | 113.62 | 113.65 | 2300.0 |
| 2004-01-29 18:30:00 | SPY | ETF | 113.65 | 113.65 | 113.6 | 113.6 | 600.0 |
| 2004-01-29 08:00:00 | QQQ | ETF | 37.25 | 37.31 | 37.24 | 37.27 | 100400.0 |
| 2004-01-29 08:30:00 | QQQ | ETF | 37.25 | 37.25 | 37.12 | 37.22 | 228000.0 |
| 2004-01-29 09:00:00 | QQQ | ETF | 37.23 | 37.27 | 37.22 | 37.24 | 195900.0 |
| 2004-01-29 09:30:00 | QQQ | ETF | 37.24 | 37.31 | 37.06 | 37.14 | 12504100.0 |
| 2004-01-29 10:00:00 | QQQ | ETF | 37.13 | 37.14 | 36.85 | 37.02 | 14659000.0 |
| 2004-01-29 10:30:00 | QQQ | ETF | 37.02 | 37.16 | 36.902 | 36.94 | 13312300.0 |
| 2004-01-29 11:00:00 | QQQ | ETF | 36.95 | 37.04 | 36.8 | 36.98 | 10999500.0 |
| 2004-01-29 11:30:00 | QQQ | ETF | 36.978 | 37.002 | 36.82 | 36.91 | 7796000.0 |
| 2004-01-29 12:00:00 | QQQ | ETF | 36.91 | 36.96 | 36.84 | 36.921 | 4935300.0 |
| 2004-01-29 12:30:00 | QQQ | ETF | 36.92 | 37.04 | 36.84 | 37.02 | 3775900.0 |
| 2004-01-29 13:00:00 | QQQ | ETF | 37.025 | 37.04 | 36.68 | 36.75 | 8926900.0 |
| 2004-01-29 13:30:00 | QQQ | ETF | 36.75 | 36.807 | 36.66 | 36.77 | 7781100.0 |
| 2004-01-29 14:00:00 | QQQ | ETF | 36.77 | 36.99 | 36.71 | 36.92 | 13328400.0 |
| 2004-01-29 14:30:00 | QQQ | ETF | 36.92 | 37.15 | 36.8 | 37.11 | 9027300.0 |
| 2004-01-29 15:00:00 | QQQ | ETF | 37.12 | 37.3 | 37.07 | 37.1 | 12877300.0 |
| 2004-01-29 15:30:00 | QQQ | ETF | 37.12 | 37.2 | 37.02 | 37.165 | 8803700.0 |
| 2004-01-29 16:00:00 | QQQ | ETF | 37.16 | 37.31 | 36.99 | 37.29 | 3332800.0 |
| 2004-01-29 16:30:00 | QQQ | ETF | 37.28 | 37.36 | 37.23 | 37.3 | 1603700.0 |
| 2004-01-29 17:00:00 | QQQ | ETF | 37.31 | 37.35 | 37.292 | 37.33 | 70000.0 |
| 2004-01-29 17:30:00 | QQQ | ETF | 37.32 | 37.326 | 37.3 | 37.32 | 55000.0 |
| 2004-01-29 18:00:00 | QQQ | ETF | 37.32 | 37.34 | 37.3 | 37.34 | 22500.0 |
| 2004-01-29 18:30:00 | QQQ | ETF | 37.34 | 37.35 | 37.32 | 37.34 | 21800.0 |
| 2004-01-29 19:00:00 | QQQ | ETF | 37.32 | 37.34 | 37.31 | 37.31 | 10400.0 |
| 2004-01-29 19:30:00 | QQQ | ETF | 37.32 | 37.35 | 37.3 | 37.35 | 7700.0 |
| 2004-01-29 09:00:00 | IWM | ETF | 58.41 | 58.42 | 58.41 | 58.42 | 1000.0 |
| 2004-01-29 09:30:00 | IWM | ETF | 58.35 | 58.485 | 57.87 | 57.92 | 1841600.0 |
| 2004-01-29 10:00:00 | IWM | ETF | 57.89 | 57.935 | 57.525 | 57.68 | 2432400.0 |
| 2004-01-29 10:30:00 | IWM | ETF | 57.725 | 57.925 | 57.595 | 57.63 | 1171200.0 |
> showing 50 of 1,155 rows — these rows as CSV