PREVIEW / etf_30min / 2004-07-30
file: by_date/etf_30min/2004/2004-07-30.parquet size: 34 KB rows: 1,149
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-07-30 08:00:00 | SPY | ETF | 110.44 | 110.52 | 110.19 | 110.39 | 102700.0 |
| 2004-07-30 08:30:00 | SPY | ETF | 110.31 | 110.31 | 110.13 | 110.22 | 224600.0 |
| 2004-07-30 09:00:00 | SPY | ETF | 110.22 | 110.36 | 110.22 | 110.34 | 185100.0 |
| 2004-07-30 09:30:00 | SPY | ETF | 110.32 | 110.49 | 110.28 | 110.32 | 4029200.0 |
| 2004-07-30 10:00:00 | SPY | ETF | 110.31 | 110.58 | 110.16 | 110.24 | 5473200.0 |
| 2004-07-30 10:30:00 | SPY | ETF | 110.26 | 110.7 | 110.24 | 110.63 | 3202600.0 |
| 2004-07-30 11:00:00 | SPY | ETF | 110.63 | 110.85 | 110.54 | 110.57 | 2499600.0 |
| 2004-07-30 11:30:00 | SPY | ETF | 110.57 | 110.61 | 110.4 | 110.46 | 1168700.0 |
| 2004-07-30 12:00:00 | SPY | ETF | 110.43 | 110.7 | 110.43 | 110.65 | 1141700.0 |
| 2004-07-30 12:30:00 | SPY | ETF | 110.67 | 110.69 | 110.52 | 110.56 | 1265600.0 |
| 2004-07-30 13:00:00 | SPY | ETF | 110.56 | 110.61 | 110.38 | 110.45 | 1336900.0 |
| 2004-07-30 13:30:00 | SPY | ETF | 110.44 | 110.45 | 110.18 | 110.25 | 2009000.0 |
| 2004-07-30 14:00:00 | SPY | ETF | 110.25 | 110.47 | 110.25 | 110.39 | 2082700.0 |
| 2004-07-30 14:30:00 | SPY | ETF | 110.39 | 110.55 | 110.18 | 110.31 | 1973300.0 |
| 2004-07-30 15:00:00 | SPY | ETF | 110.28 | 110.49 | 110.1 | 110.19 | 3476700.0 |
| 2004-07-30 15:30:00 | SPY | ETF | 110.19 | 110.68 | 110.175 | 110.67 | 3576000.0 |
| 2004-07-30 16:00:00 | SPY | ETF | 110.68 | 110.9 | 110.54 | 110.8 | 3376500.0 |
| 2004-07-30 16:30:00 | SPY | ETF | 110.8 | 110.83 | 110.73 | 110.8 | 294600.0 |
| 2004-07-30 17:00:00 | SPY | ETF | 110.82 | 110.85 | 110.76 | 110.85 | 49500.0 |
| 2004-07-30 17:30:00 | SPY | ETF | 110.8 | 110.83 | 110.8 | 110.83 | 1400.0 |
| 2004-07-30 18:00:00 | SPY | ETF | 110.8 | 110.85 | 110.77 | 110.85 | 2500.0 |
| 2004-07-30 08:00:00 | QQQ | ETF | 34.76 | 34.78 | 34.66 | 34.73 | 82000.0 |
| 2004-07-30 08:30:00 | QQQ | ETF | 34.73 | 34.73 | 34.63 | 34.71 | 409100.0 |
| 2004-07-30 09:00:00 | QQQ | ETF | 34.7 | 34.79 | 34.7 | 34.77 | 157600.0 |
| 2004-07-30 09:30:00 | QQQ | ETF | 34.76 | 34.8 | 34.65 | 34.68 | 9452200.0 |
| 2004-07-30 10:00:00 | QQQ | ETF | 34.68 | 34.87 | 34.65 | 34.758 | 8977300.0 |
| 2004-07-30 10:30:00 | QQQ | ETF | 34.758 | 35.04 | 34.747 | 34.99 | 8558000.0 |
| 2004-07-30 11:00:00 | QQQ | ETF | 34.99 | 35.1 | 34.94 | 34.96 | 7190000.0 |
| 2004-07-30 11:30:00 | QQQ | ETF | 34.95 | 34.99 | 34.87 | 34.92 | 3565400.0 |
| 2004-07-30 12:00:00 | QQQ | ETF | 34.92 | 35.04 | 34.9 | 35.03 | 3004100.0 |
| 2004-07-30 12:30:00 | QQQ | ETF | 35.03 | 35.07 | 34.98 | 35.041 | 3365200.0 |
| 2004-07-30 13:00:00 | QQQ | ETF | 35.04 | 35.06 | 34.91 | 34.96 | 3036100.0 |
| 2004-07-30 13:30:00 | QQQ | ETF | 34.95 | 34.96 | 34.85 | 34.88 | 4553000.0 |
| 2004-07-30 14:00:00 | QQQ | ETF | 34.88 | 35.01 | 34.87 | 34.95 | 4656400.0 |
| 2004-07-30 14:30:00 | QQQ | ETF | 34.949 | 34.995 | 34.83 | 34.87 | 4083200.0 |
| 2004-07-30 15:00:00 | QQQ | ETF | 34.86 | 34.931 | 34.705 | 34.75 | 7296200.0 |
| 2004-07-30 15:30:00 | QQQ | ETF | 34.75 | 34.9 | 34.74 | 34.851 | 8074200.0 |
| 2004-07-30 16:00:00 | QQQ | ETF | 34.85 | 34.943 | 34.83 | 34.87 | 2431900.0 |
| 2004-07-30 16:30:00 | QQQ | ETF | 34.76 | 34.9 | 34.76 | 34.87 | 1425400.0 |
| 2004-07-30 17:00:00 | QQQ | ETF | 34.89 | 34.92 | 34.89 | 34.92 | 30300.0 |
| 2004-07-30 17:30:00 | QQQ | ETF | 34.93 | 34.94 | 34.9 | 34.94 | 15100.0 |
| 2004-07-30 18:00:00 | QQQ | ETF | 34.92 | 34.93 | 34.9 | 34.9 | 11500.0 |
| 2004-07-30 19:00:00 | QQQ | ETF | 34.9 | 34.9 | 34.9 | 34.9 | 300.0 |
| 2004-07-30 19:30:00 | QQQ | ETF | 34.9 | 34.94 | 34.9 | 34.93 | 2900.0 |
| 2004-07-30 08:30:00 | IWM | ETF | 54.375 | 54.455 | 54.375 | 54.38 | 19000.0 |
| 2004-07-30 09:00:00 | IWM | ETF | 54.475 | 54.575 | 54.475 | 54.575 | 6400.0 |
| 2004-07-30 09:30:00 | IWM | ETF | 54.6 | 54.815 | 54.55 | 54.625 | 1319400.0 |
| 2004-07-30 10:00:00 | IWM | ETF | 54.59 | 54.795 | 54.515 | 54.54 | 1112400.0 |
| 2004-07-30 10:30:00 | IWM | ETF | 54.57 | 54.95 | 54.57 | 54.935 | 667600.0 |
| 2004-07-30 11:00:00 | IWM | ETF | 54.95 | 55.075 | 54.925 | 54.95 | 498000.0 |
> showing 50 of 1,149 rows — these rows as CSV