PREVIEW / etf_30min / 2004-01-23
file: by_date/etf_30min/2004/2004-01-23.parquet size: 35 KB rows: 1,139
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-23 08:00:00 | SPY | ETF | 114.75 | 114.77 | 114.75 | 114.77 | 10700.0 |
| 2004-01-23 08:30:00 | SPY | ETF | 114.78 | 114.91 | 114.77 | 114.87 | 219100.0 |
| 2004-01-23 09:00:00 | SPY | ETF | 114.87 | 115.08 | 114.87 | 115.02 | 8400.0 |
| 2004-01-23 09:30:00 | SPY | ETF | 115.0 | 115.16 | 114.86 | 115.003 | 2968800.0 |
| 2004-01-23 10:00:00 | SPY | ETF | 115.01 | 115.36 | 114.9 | 115.29 | 2166900.0 |
| 2004-01-23 10:30:00 | SPY | ETF | 115.28 | 115.37 | 114.88 | 114.95 | 2070800.0 |
| 2004-01-23 11:00:00 | SPY | ETF | 114.94 | 115.06 | 114.79 | 114.86 | 2111900.0 |
| 2004-01-23 11:30:00 | SPY | ETF | 114.85 | 115.07 | 114.82 | 115.01 | 1539900.0 |
| 2004-01-23 12:00:00 | SPY | ETF | 115.0 | 115.0 | 114.62 | 114.7 | 1665800.0 |
| 2004-01-23 12:30:00 | SPY | ETF | 114.66 | 114.75 | 114.43 | 114.55 | 1480100.0 |
| 2004-01-23 13:00:00 | SPY | ETF | 114.54 | 114.67 | 114.47 | 114.52 | 1673500.0 |
| 2004-01-23 13:30:00 | SPY | ETF | 114.55 | 114.65 | 114.3 | 114.31 | 1540100.0 |
| 2004-01-23 14:00:00 | SPY | ETF | 114.34 | 114.38 | 114.17 | 114.3 | 1980100.0 |
| 2004-01-23 14:30:00 | SPY | ETF | 114.31 | 114.52 | 114.24 | 114.4 | 1128900.0 |
| 2004-01-23 15:00:00 | SPY | ETF | 114.38 | 114.4 | 113.95 | 114.02 | 2759000.0 |
| 2004-01-23 15:30:00 | SPY | ETF | 114.01 | 114.45 | 114.01 | 114.36 | 4311800.0 |
| 2004-01-23 16:00:00 | SPY | ETF | 114.39 | 114.51 | 114.3 | 114.45 | 12748400.0 |
| 2004-01-23 16:30:00 | SPY | ETF | 114.42 | 114.46 | 114.38 | 114.45 | 1580100.0 |
| 2004-01-23 17:00:00 | SPY | ETF | 114.38 | 114.41 | 114.35 | 114.39 | 10900.0 |
| 2004-01-23 17:30:00 | SPY | ETF | 114.46 | 114.46 | 114.35 | 114.35 | 5722600.0 |
| 2004-01-23 18:00:00 | SPY | ETF | 114.35 | 114.35 | 114.35 | 114.35 | 700.0 |
| 2004-01-23 19:30:00 | SPY | ETF | 114.28 | 114.28 | 114.28 | 114.28 | 100.0 |
| 2004-01-23 08:00:00 | QQQ | ETF | 38.01 | 38.06 | 38.01 | 38.06 | 54400.0 |
| 2004-01-23 08:30:00 | QQQ | ETF | 38.1 | 38.2 | 38.1 | 38.13 | 72500.0 |
| 2004-01-23 09:00:00 | QQQ | ETF | 38.13 | 38.21 | 38.12 | 38.19 | 203800.0 |
| 2004-01-23 09:30:00 | QQQ | ETF | 38.21 | 38.3 | 38.05 | 38.17 | 13473600.0 |
| 2004-01-23 10:00:00 | QQQ | ETF | 38.17 | 38.42 | 38.11 | 38.4 | 9173200.0 |
| 2004-01-23 10:30:00 | QQQ | ETF | 38.4 | 38.46 | 38.21 | 38.28 | 6423100.0 |
| 2004-01-23 11:00:00 | QQQ | ETF | 38.271 | 38.33 | 38.15 | 38.21 | 4027300.0 |
| 2004-01-23 11:30:00 | QQQ | ETF | 38.2 | 38.3 | 38.16 | 38.181 | 3439600.0 |
| 2004-01-23 12:00:00 | QQQ | ETF | 38.2 | 38.24 | 38.02 | 38.049 | 3998600.0 |
| 2004-01-23 12:30:00 | QQQ | ETF | 38.07 | 38.09 | 37.88 | 37.95 | 6517100.0 |
| 2004-01-23 13:00:00 | QQQ | ETF | 37.95 | 38.04 | 37.94 | 37.95 | 5382100.0 |
| 2004-01-23 13:30:00 | QQQ | ETF | 37.96 | 38.05 | 37.89 | 37.92 | 4688400.0 |
| 2004-01-23 14:00:00 | QQQ | ETF | 37.91 | 37.96 | 37.85 | 37.89 | 5328600.0 |
| 2004-01-23 14:30:00 | QQQ | ETF | 37.86 | 38.02 | 37.82 | 37.918 | 5369900.0 |
| 2004-01-23 15:00:00 | QQQ | ETF | 37.92 | 37.93 | 37.78 | 37.8 | 5950900.0 |
| 2004-01-23 15:30:00 | QQQ | ETF | 37.8 | 38.04 | 37.8 | 38.03 | 7915000.0 |
| 2004-01-23 16:00:00 | QQQ | ETF | 38.03 | 38.06 | 37.99 | 38.04 | 2389400.0 |
| 2004-01-23 16:30:00 | QQQ | ETF | 38.05 | 38.05 | 38.021 | 38.03 | 53300.0 |
| 2004-01-23 17:00:00 | QQQ | ETF | 38.022 | 38.03 | 38.01 | 38.01 | 42800.0 |
| 2004-01-23 17:30:00 | QQQ | ETF | 38.03 | 38.05 | 38.0 | 38.04 | 48200.0 |
| 2004-01-23 18:00:00 | QQQ | ETF | 38.04 | 38.04 | 38.02 | 38.04 | 2400.0 |
| 2004-01-23 18:30:00 | QQQ | ETF | 38.03 | 38.03 | 38.02 | 38.02 | 1900.0 |
| 2004-01-23 19:00:00 | QQQ | ETF | 38.02 | 38.02 | 37.99 | 37.99 | 2900.0 |
| 2004-01-23 19:30:00 | QQQ | ETF | 38.03 | 38.03 | 38.02 | 38.03 | 3700.0 |
| 2004-01-23 09:00:00 | IWM | ETF | 59.045 | 59.13 | 59.045 | 59.105 | 4800.0 |
| 2004-01-23 09:30:00 | IWM | ETF | 59.095 | 59.125 | 58.865 | 58.915 | 768200.0 |
| 2004-01-23 10:00:00 | IWM | ETF | 58.93 | 59.41 | 58.875 | 59.315 | 743200.0 |
| 2004-01-23 10:30:00 | IWM | ETF | 59.31 | 59.35 | 59.18 | 59.22 | 338400.0 |
> showing 50 of 1,139 rows — these rows as CSV