PREVIEW / etf_30min / 2004-01-21
file: by_date/etf_30min/2004/2004-01-21.parquet size: 35 KB rows: 1,153
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-21 08:00:00 | SPY | ETF | 114.21 | 114.27 | 114.21 | 114.22 | 7800.0 |
| 2004-01-21 08:30:00 | SPY | ETF | 114.25 | 114.27 | 114.09 | 114.16 | 7000.0 |
| 2004-01-21 09:00:00 | SPY | ETF | 114.17 | 114.2 | 114.1 | 114.13 | 15100.0 |
| 2004-01-21 09:30:00 | SPY | ETF | 114.13 | 114.16 | 113.83 | 114.02 | 2230100.0 |
| 2004-01-21 10:00:00 | SPY | ETF | 114.02 | 114.1 | 113.72 | 113.76 | 2248700.0 |
| 2004-01-21 10:30:00 | SPY | ETF | 113.75 | 113.99 | 113.72 | 113.93 | 2518900.0 |
| 2004-01-21 11:00:00 | SPY | ETF | 113.92 | 114.05 | 113.85 | 114.02 | 1061100.0 |
| 2004-01-21 11:30:00 | SPY | ETF | 114.02 | 114.28 | 113.98 | 114.16 | 1604500.0 |
| 2004-01-21 12:00:00 | SPY | ETF | 114.14 | 114.56 | 114.1 | 114.42 | 2299700.0 |
| 2004-01-21 12:30:00 | SPY | ETF | 114.43 | 114.56 | 114.38 | 114.53 | 866100.0 |
| 2004-01-21 13:00:00 | SPY | ETF | 114.52 | 114.57 | 114.4 | 114.53 | 722900.0 |
| 2004-01-21 13:30:00 | SPY | ETF | 114.54 | 114.83 | 114.36 | 114.78 | 2939800.0 |
| 2004-01-21 14:00:00 | SPY | ETF | 114.78 | 115.19 | 114.72 | 115.12 | 2002900.0 |
| 2004-01-21 14:30:00 | SPY | ETF | 115.12 | 115.2 | 115.02 | 115.12 | 1322300.0 |
| 2004-01-21 15:00:00 | SPY | ETF | 115.1 | 115.3 | 114.87 | 114.96 | 3205600.0 |
| 2004-01-21 15:30:00 | SPY | ETF | 114.96 | 115.09 | 114.78 | 115.07 | 3151500.0 |
| 2004-01-21 16:00:00 | SPY | ETF | 115.06 | 115.13 | 114.95 | 115.07 | 979500.0 |
| 2004-01-21 16:30:00 | SPY | ETF | 115.07 | 115.18 | 115.07 | 115.18 | 246800.0 |
| 2004-01-21 17:00:00 | SPY | ETF | 115.18 | 115.2 | 115.11 | 115.18 | 6800.0 |
| 2004-01-21 17:30:00 | SPY | ETF | 115.18 | 115.21 | 115.18 | 115.2 | 900.0 |
| 2004-01-21 18:00:00 | SPY | ETF | 115.2 | 115.22 | 115.17 | 115.17 | 16500.0 |
| 2004-01-21 18:30:00 | SPY | ETF | 115.15 | 115.15 | 115.13 | 115.13 | 1200.0 |
| 2004-01-21 19:00:00 | SPY | ETF | 115.12 | 115.12 | 115.12 | 115.12 | 100.0 |
| 2004-01-21 19:30:00 | SPY | ETF | 115.12 | 115.12 | 115.1 | 115.12 | 1300.0 |
| 2004-01-21 08:00:00 | QQQ | ETF | 38.41 | 38.44 | 38.41 | 38.43 | 5400.0 |
| 2004-01-21 08:30:00 | QQQ | ETF | 38.44 | 38.44 | 38.35 | 38.39 | 135600.0 |
| 2004-01-21 09:00:00 | QQQ | ETF | 38.39 | 38.41 | 38.36 | 38.38 | 182300.0 |
| 2004-01-21 09:30:00 | QQQ | ETF | 38.391 | 38.42 | 38.18 | 38.26 | 12612100.0 |
| 2004-01-21 10:00:00 | QQQ | ETF | 38.24 | 38.25 | 38.02 | 38.02 | 9675500.0 |
| 2004-01-21 10:30:00 | QQQ | ETF | 38.03 | 38.17 | 38.0 | 38.11 | 7130600.0 |
| 2004-01-21 11:00:00 | QQQ | ETF | 38.113 | 38.18 | 38.04 | 38.12 | 3966200.0 |
| 2004-01-21 11:30:00 | QQQ | ETF | 38.14 | 38.25 | 38.13 | 38.14 | 7428400.0 |
| 2004-01-21 12:00:00 | QQQ | ETF | 38.14 | 38.27 | 38.1 | 38.21 | 5154500.0 |
| 2004-01-21 12:30:00 | QQQ | ETF | 38.21 | 38.295 | 38.18 | 38.26 | 3262600.0 |
| 2004-01-21 13:00:00 | QQQ | ETF | 38.27 | 38.29 | 38.18 | 38.27 | 3284700.0 |
| 2004-01-21 13:30:00 | QQQ | ETF | 38.271 | 38.36 | 38.16 | 38.32 | 6030200.0 |
| 2004-01-21 14:00:00 | QQQ | ETF | 38.32 | 38.66 | 38.29 | 38.59 | 9898100.0 |
| 2004-01-21 14:30:00 | QQQ | ETF | 38.59 | 38.6 | 38.478 | 38.539 | 7002500.0 |
| 2004-01-21 15:00:00 | QQQ | ETF | 38.56 | 38.65 | 38.39 | 38.43 | 7308100.0 |
| 2004-01-21 15:30:00 | QQQ | ETF | 38.45 | 38.45 | 38.3 | 38.411 | 13883600.0 |
| 2004-01-21 16:00:00 | QQQ | ETF | 38.4 | 38.46 | 38.314 | 38.46 | 4743600.0 |
| 2004-01-21 16:30:00 | QQQ | ETF | 38.47 | 38.55 | 38.46 | 38.52 | 1050300.0 |
| 2004-01-21 17:00:00 | QQQ | ETF | 38.53 | 38.57 | 38.52 | 38.57 | 453200.0 |
| 2004-01-21 17:30:00 | QQQ | ETF | 38.56 | 38.57 | 38.53 | 38.53 | 94500.0 |
| 2004-01-21 18:00:00 | QQQ | ETF | 38.55 | 38.56 | 38.52 | 38.54 | 24600.0 |
| 2004-01-21 18:30:00 | QQQ | ETF | 38.53 | 38.54 | 38.52 | 38.52 | 14600.0 |
| 2004-01-21 19:00:00 | QQQ | ETF | 38.52 | 38.52 | 38.51 | 38.51 | 2600.0 |
| 2004-01-21 19:30:00 | QQQ | ETF | 38.52 | 38.56 | 38.52 | 38.52 | 19500.0 |
| 2004-01-21 09:00:00 | IWM | ETF | 59.45 | 59.45 | 59.355 | 59.435 | 10600.0 |
| 2004-01-21 09:30:00 | IWM | ETF | 59.425 | 59.44 | 59.055 | 59.1065 | 1361800.0 |
> showing 50 of 1,153 rows — these rows as CSV