PREVIEW / etf_30min / 2004-04-22
file: by_date/etf_30min/2004/2004-04-22.parquet size: 37 KB rows: 1,194
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-22 08:00:00 | SPY | ETF | 112.72 | 112.74 | 112.5 | 112.52 | 43600.0 |
| 2004-04-22 08:30:00 | SPY | ETF | 112.52 | 112.68 | 112.32 | 112.56 | 124400.0 |
| 2004-04-22 09:00:00 | SPY | ETF | 112.53 | 112.65 | 112.5 | 112.5 | 29000.0 |
| 2004-04-22 09:30:00 | SPY | ETF | 112.48 | 112.88 | 112.44 | 112.8 | 2957600.0 |
| 2004-04-22 10:00:00 | SPY | ETF | 112.83 | 112.83 | 112.5 | 112.55 | 3928700.0 |
| 2004-04-22 10:30:00 | SPY | ETF | 112.55 | 113.01 | 112.52 | 112.93 | 3503500.0 |
| 2004-04-22 11:00:00 | SPY | ETF | 112.95 | 113.99 | 112.94 | 113.83 | 8001400.0 |
| 2004-04-22 11:30:00 | SPY | ETF | 113.83 | 114.11 | 113.76 | 114.0 | 10272700.0 |
| 2004-04-22 12:00:00 | SPY | ETF | 113.96 | 114.12 | 113.89 | 114.1 | 2633700.0 |
| 2004-04-22 12:30:00 | SPY | ETF | 114.11 | 114.22 | 114.0 | 114.05 | 1575200.0 |
| 2004-04-22 13:00:00 | SPY | ETF | 113.99 | 114.2 | 113.96 | 114.19 | 946300.0 |
| 2004-04-22 13:30:00 | SPY | ETF | 114.19 | 114.66 | 114.15 | 114.53 | 6996400.0 |
| 2004-04-22 14:00:00 | SPY | ETF | 114.53 | 114.64 | 114.39 | 114.58 | 2726300.0 |
| 2004-04-22 14:30:00 | SPY | ETF | 114.57 | 114.67 | 114.32 | 114.59 | 3093500.0 |
| 2004-04-22 15:00:00 | SPY | ETF | 114.59 | 114.64 | 114.31 | 114.38 | 2918800.0 |
| 2004-04-22 15:30:00 | SPY | ETF | 114.38 | 114.58 | 114.21 | 114.44 | 5741500.0 |
| 2004-04-22 16:00:00 | SPY | ETF | 114.45 | 114.6 | 114.15 | 114.6 | 2331100.0 |
| 2004-04-22 16:30:00 | SPY | ETF | 114.6 | 114.6 | 114.36 | 114.47 | 553800.0 |
| 2004-04-22 17:00:00 | SPY | ETF | 114.49 | 114.54 | 114.445 | 114.54 | 203000.0 |
| 2004-04-22 17:30:00 | SPY | ETF | 114.54 | 114.6 | 114.47 | 114.6 | 56300.0 |
| 2004-04-22 18:00:00 | SPY | ETF | 114.52 | 114.52 | 114.47 | 114.48 | 14500.0 |
| 2004-04-22 18:30:00 | SPY | ETF | 114.5 | 114.5 | 114.46 | 114.49 | 1100.0 |
| 2004-04-22 19:00:00 | SPY | ETF | 114.48 | 114.49 | 114.48 | 114.49 | 1100.0 |
| 2004-04-22 19:30:00 | SPY | ETF | 114.49 | 114.49 | 114.49 | 114.49 | 500.0 |
| 2004-04-22 08:00:00 | QQQ | ETF | 36.03 | 36.04 | 35.92 | 35.96 | 51600.0 |
| 2004-04-22 08:30:00 | QQQ | ETF | 35.95 | 36.05 | 35.87 | 35.98 | 324500.0 |
| 2004-04-22 09:00:00 | QQQ | ETF | 35.99 | 36.03 | 35.97 | 36.0 | 211800.0 |
| 2004-04-22 09:30:00 | QQQ | ETF | 36.0 | 36.232 | 35.98 | 36.181 | 12233800.0 |
| 2004-04-22 10:00:00 | QQQ | ETF | 36.181 | 36.2 | 36.05 | 36.08 | 8523500.0 |
| 2004-04-22 10:30:00 | QQQ | ETF | 36.08 | 36.38 | 36.064 | 36.35 | 13326600.0 |
| 2004-04-22 11:00:00 | QQQ | ETF | 36.367 | 36.77 | 36.35 | 36.696 | 25458800.0 |
| 2004-04-22 11:30:00 | QQQ | ETF | 36.696 | 36.87 | 36.65 | 36.742 | 12021100.0 |
| 2004-04-22 12:00:00 | QQQ | ETF | 36.75 | 36.8 | 36.69 | 36.774 | 5601700.0 |
| 2004-04-22 12:30:00 | QQQ | ETF | 36.771 | 36.85 | 36.76 | 36.77 | 5768800.0 |
| 2004-04-22 13:00:00 | QQQ | ETF | 36.78 | 36.9 | 36.76 | 36.885 | 4422500.0 |
| 2004-04-22 13:30:00 | QQQ | ETF | 36.882 | 36.99 | 36.85 | 36.932 | 7916000.0 |
| 2004-04-22 14:00:00 | QQQ | ETF | 36.932 | 37.01 | 36.9 | 37.0 | 7103000.0 |
| 2004-04-22 14:30:00 | QQQ | ETF | 36.972 | 37.0 | 36.889 | 36.99 | 5403500.0 |
| 2004-04-22 15:00:00 | QQQ | ETF | 36.986 | 37.0 | 36.83 | 36.86 | 7112200.0 |
| 2004-04-22 15:30:00 | QQQ | ETF | 36.86 | 36.97 | 36.81 | 36.92 | 12497600.0 |
| 2004-04-22 16:00:00 | QQQ | ETF | 36.92 | 37.21 | 36.79 | 37.21 | 3283300.0 |
| 2004-04-22 16:30:00 | QQQ | ETF | 37.2 | 37.213 | 37.073 | 37.132 | 2196900.0 |
| 2004-04-22 17:00:00 | QQQ | ETF | 37.138 | 37.19 | 37.13 | 37.16 | 323200.0 |
| 2004-04-22 17:30:00 | QQQ | ETF | 37.188 | 37.25 | 37.17 | 37.19 | 380500.0 |
| 2004-04-22 18:00:00 | QQQ | ETF | 37.19 | 37.19 | 37.15 | 37.18 | 102700.0 |
| 2004-04-22 18:30:00 | QQQ | ETF | 37.17 | 37.17 | 37.16 | 37.17 | 13500.0 |
| 2004-04-22 19:00:00 | QQQ | ETF | 37.18 | 37.18 | 37.16 | 37.18 | 9100.0 |
| 2004-04-22 19:30:00 | QQQ | ETF | 37.16 | 37.17 | 37.15 | 37.17 | 24500.0 |
| 2004-04-22 08:30:00 | IWM | ETF | 58.0 | 58.14 | 58.0 | 58.14 | 1600.0 |
| 2004-04-22 09:00:00 | IWM | ETF | 58.07 | 58.07 | 58.06 | 58.06 | 6000.0 |
> showing 50 of 1,194 rows — these rows as CSV