PREVIEW / etf_30min / 2004-06-29
file: by_date/etf_30min/2004/2004-06-29.parquet size: 34 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-06-29 08:00:00 | SPY | ETF | 113.65 | 113.65 | 113.56 | 113.56 | 29200.0 |
| 2004-06-29 08:30:00 | SPY | ETF | 113.5 | 113.5 | 113.42 | 113.44 | 26700.0 |
| 2004-06-29 09:00:00 | SPY | ETF | 113.44 | 113.53 | 113.42 | 113.53 | 46100.0 |
| 2004-06-29 09:30:00 | SPY | ETF | 113.53 | 113.74 | 113.42 | 113.74 | 3943000.0 |
| 2004-06-29 10:00:00 | SPY | ETF | 113.71 | 113.97 | 113.7 | 113.84 | 3731500.0 |
| 2004-06-29 10:30:00 | SPY | ETF | 113.85 | 113.93 | 113.69 | 113.79 | 2460900.0 |
| 2004-06-29 11:00:00 | SPY | ETF | 113.8 | 113.94 | 113.76 | 113.88 | 1558500.0 |
| 2004-06-29 11:30:00 | SPY | ETF | 113.87 | 114.06 | 113.83 | 114.01 | 1380500.0 |
| 2004-06-29 12:00:00 | SPY | ETF | 114.02 | 114.17 | 113.98 | 114.04 | 1905800.0 |
| 2004-06-29 12:30:00 | SPY | ETF | 114.05 | 114.05 | 113.87 | 113.93 | 849800.0 |
| 2004-06-29 13:00:00 | SPY | ETF | 113.9315 | 114.03 | 113.92 | 113.97 | 501800.0 |
| 2004-06-29 13:30:00 | SPY | ETF | 113.96 | 113.99 | 113.8 | 113.95 | 1223000.0 |
| 2004-06-29 14:00:00 | SPY | ETF | 113.93 | 114.1 | 113.82 | 113.86 | 1650700.0 |
| 2004-06-29 14:30:00 | SPY | ETF | 113.86 | 114.11 | 113.77 | 114.01 | 1590300.0 |
| 2004-06-29 15:00:00 | SPY | ETF | 114.02 | 114.09 | 113.85 | 114.04 | 1167500.0 |
| 2004-06-29 15:30:00 | SPY | ETF | 114.09 | 114.12 | 113.87 | 113.98 | 2462300.0 |
| 2004-06-29 16:00:00 | SPY | ETF | 113.97 | 114.0 | 113.8233 | 113.93 | 1547000.0 |
| 2004-06-29 16:30:00 | SPY | ETF | 113.94 | 114.02 | 113.85 | 113.98 | 294700.0 |
| 2004-06-29 17:00:00 | SPY | ETF | 113.98 | 113.98 | 113.92 | 113.92 | 34900.0 |
| 2004-06-29 17:30:00 | SPY | ETF | 113.94 | 113.94 | 113.93 | 113.93 | 5500.0 |
| 2004-06-29 18:00:00 | SPY | ETF | 113.93 | 113.93 | 113.92 | 113.92 | 2800.0 |
| 2004-06-29 18:30:00 | SPY | ETF | 113.99 | 113.99 | 113.94 | 113.94 | 1000.0 |
| 2004-06-29 08:00:00 | QQQ | ETF | 37.13 | 37.13 | 37.09 | 37.09 | 23900.0 |
| 2004-06-29 08:30:00 | QQQ | ETF | 37.07 | 37.09 | 37.06 | 37.08 | 20000.0 |
| 2004-06-29 09:00:00 | QQQ | ETF | 37.08 | 37.12 | 37.08 | 37.11 | 89100.0 |
| 2004-06-29 09:30:00 | QQQ | ETF | 37.1 | 37.28 | 37.08 | 37.24 | 9094900.0 |
| 2004-06-29 10:00:00 | QQQ | ETF | 37.24 | 37.39 | 37.24 | 37.35 | 9496800.0 |
| 2004-06-29 10:30:00 | QQQ | ETF | 37.35 | 37.43 | 37.25 | 37.33 | 5364100.0 |
| 2004-06-29 11:00:00 | QQQ | ETF | 37.34 | 37.41 | 37.27 | 37.35 | 4774400.0 |
| 2004-06-29 11:30:00 | QQQ | ETF | 37.35 | 37.41 | 37.3 | 37.409 | 4543500.0 |
| 2004-06-29 12:00:00 | QQQ | ETF | 37.39 | 37.47 | 37.368 | 37.41 | 4632600.0 |
| 2004-06-29 12:30:00 | QQQ | ETF | 37.41 | 37.41 | 37.32 | 37.33 | 2172800.0 |
| 2004-06-29 13:00:00 | QQQ | ETF | 37.34 | 37.37 | 37.32 | 37.334 | 1630600.0 |
| 2004-06-29 13:30:00 | QQQ | ETF | 37.34 | 37.34 | 37.25 | 37.34 | 3739300.0 |
| 2004-06-29 14:00:00 | QQQ | ETF | 37.34 | 37.42 | 37.29 | 37.33 | 3822100.0 |
| 2004-06-29 14:30:00 | QQQ | ETF | 37.33 | 37.423 | 37.28 | 37.41 | 2841100.0 |
| 2004-06-29 15:00:00 | QQQ | ETF | 37.41 | 37.437 | 37.33 | 37.437 | 4202100.0 |
| 2004-06-29 15:30:00 | QQQ | ETF | 37.437 | 37.471 | 37.38 | 37.44 | 7383400.0 |
| 2004-06-29 16:00:00 | QQQ | ETF | 37.45 | 37.46 | 37.35 | 37.38 | 2566100.0 |
| 2004-06-29 16:30:00 | QQQ | ETF | 37.38 | 37.4 | 37.37 | 37.4 | 486700.0 |
| 2004-06-29 17:00:00 | QQQ | ETF | 37.4 | 37.41 | 37.38 | 37.41 | 71700.0 |
| 2004-06-29 17:30:00 | QQQ | ETF | 37.41 | 37.42 | 37.39 | 37.39 | 59700.0 |
| 2004-06-29 18:00:00 | QQQ | ETF | 37.4 | 37.43 | 37.4 | 37.43 | 30300.0 |
| 2004-06-29 18:30:00 | QQQ | ETF | 37.42 | 37.43 | 37.4 | 37.41 | 5300.0 |
| 2004-06-29 19:00:00 | QQQ | ETF | 37.4 | 37.43 | 37.4 | 37.43 | 4400.0 |
| 2004-06-29 19:30:00 | QQQ | ETF | 37.43 | 37.45 | 37.43 | 37.45 | 10400.0 |
| 2004-06-29 08:30:00 | IWM | ETF | 58.125 | 58.125 | 58.125 | 58.125 | 1000.0 |
| 2004-06-29 09:00:00 | IWM | ETF | 58.125 | 58.135 | 58.1 | 58.135 | 4600.0 |
| 2004-06-29 09:30:00 | IWM | ETF | 58.07 | 58.585 | 58.07 | 58.56 | 1001400.0 |
| 2004-06-29 10:00:00 | IWM | ETF | 58.585 | 58.865 | 58.585 | 58.76 | 726200.0 |
> showing 50 of 1,153 rows — these rows as CSV