PREVIEW / etf_30min / 2004-05-27
file: by_date/etf_30min/2004/2004-05-27.parquet size: 36 KB rows: 1,188
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-05-27 08:00:00 | SPY | ETF | 112.43 | 112.45 | 112.34 | 112.4 | 16800.0 |
| 2004-05-27 08:30:00 | SPY | ETF | 112.42 | 112.52 | 112.37 | 112.51 | 48500.0 |
| 2004-05-27 09:00:00 | SPY | ETF | 112.51 | 112.57 | 112.47 | 112.54 | 99000.0 |
| 2004-05-27 09:30:00 | SPY | ETF | 112.54 | 112.75 | 112.46 | 112.72 | 9267600.0 |
| 2004-05-27 10:00:00 | SPY | ETF | 112.72 | 113.03 | 112.68 | 112.88 | 3616600.0 |
| 2004-05-27 10:30:00 | SPY | ETF | 112.89 | 112.95 | 112.77 | 112.91 | 2021700.0 |
| 2004-05-27 11:00:00 | SPY | ETF | 112.92 | 112.95 | 112.35 | 112.47 | 4412400.0 |
| 2004-05-27 11:30:00 | SPY | ETF | 112.46 | 112.65 | 112.31 | 112.55 | 2616100.0 |
| 2004-05-27 12:00:00 | SPY | ETF | 112.55 | 112.6 | 112.22 | 112.33 | 1984500.0 |
| 2004-05-27 12:30:00 | SPY | ETF | 112.31 | 112.42 | 112.1 | 112.14 | 2527900.0 |
| 2004-05-27 13:00:00 | SPY | ETF | 112.14 | 112.3 | 112.06 | 112.15 | 1545000.0 |
| 2004-05-27 13:30:00 | SPY | ETF | 112.16 | 112.38 | 112.13 | 112.23 | 1414500.0 |
| 2004-05-27 14:00:00 | SPY | ETF | 112.23 | 112.58 | 112.12 | 112.53 | 1960200.0 |
| 2004-05-27 14:30:00 | SPY | ETF | 112.53 | 112.65 | 112.5 | 112.6 | 1684400.0 |
| 2004-05-27 15:00:00 | SPY | ETF | 112.58 | 112.6 | 112.37 | 112.53 | 1751800.0 |
| 2004-05-27 15:30:00 | SPY | ETF | 112.53 | 112.9 | 112.5 | 112.72 | 4526700.0 |
| 2004-05-27 16:00:00 | SPY | ETF | 112.72 | 112.92 | 112.67 | 112.85 | 2290300.0 |
| 2004-05-27 16:30:00 | SPY | ETF | 112.85 | 112.98 | 112.54 | 112.9 | 187200.0 |
| 2004-05-27 17:00:00 | SPY | ETF | 112.88 | 112.91 | 112.85 | 112.85 | 11100.0 |
| 2004-05-27 17:30:00 | SPY | ETF | 112.9 | 112.91 | 112.9 | 112.91 | 1500.0 |
| 2004-05-27 18:00:00 | SPY | ETF | 112.88 | 112.88 | 112.82 | 112.82 | 3300.0 |
| 2004-05-27 18:30:00 | SPY | ETF | 112.88 | 112.88 | 112.87 | 112.88 | 2200.0 |
| 2004-05-27 19:00:00 | SPY | ETF | 112.88 | 112.92 | 112.82 | 112.92 | 4400.0 |
| 2004-05-27 19:30:00 | SPY | ETF | 112.9 | 112.9 | 112.8 | 112.8 | 1200.0 |
| 2004-05-27 08:00:00 | QQQ | ETF | 36.28 | 36.28 | 36.15 | 36.24 | 49600.0 |
| 2004-05-27 08:30:00 | QQQ | ETF | 36.25 | 36.28 | 36.2 | 36.28 | 354800.0 |
| 2004-05-27 09:00:00 | QQQ | ETF | 36.28 | 36.35 | 36.28 | 36.3 | 477700.0 |
| 2004-05-27 09:30:00 | QQQ | ETF | 36.29 | 36.37 | 36.22 | 36.32 | 14969000.0 |
| 2004-05-27 10:00:00 | QQQ | ETF | 36.32 | 36.5 | 36.316 | 36.39 | 18204400.0 |
| 2004-05-27 10:30:00 | QQQ | ETF | 36.394 | 36.44 | 36.346 | 36.41 | 6247700.0 |
| 2004-05-27 11:00:00 | QQQ | ETF | 36.4 | 36.44 | 36.18 | 36.25 | 9430300.0 |
| 2004-05-27 11:30:00 | QQQ | ETF | 36.25 | 36.34 | 36.19 | 36.31 | 4227600.0 |
| 2004-05-27 12:00:00 | QQQ | ETF | 36.3 | 36.32 | 36.12 | 36.2 | 7590700.0 |
| 2004-05-27 12:30:00 | QQQ | ETF | 36.18 | 36.23 | 36.09 | 36.11 | 5607800.0 |
| 2004-05-27 13:00:00 | QQQ | ETF | 36.1 | 36.14 | 36.06 | 36.076 | 5957400.0 |
| 2004-05-27 13:30:00 | QQQ | ETF | 36.07 | 36.2 | 36.06 | 36.11 | 4719800.0 |
| 2004-05-27 14:00:00 | QQQ | ETF | 36.09 | 36.3 | 36.09 | 36.267 | 6555800.0 |
| 2004-05-27 14:30:00 | QQQ | ETF | 36.266 | 36.34 | 36.24 | 36.324 | 5503400.0 |
| 2004-05-27 15:00:00 | QQQ | ETF | 36.33 | 36.35 | 36.22 | 36.3 | 5329600.0 |
| 2004-05-27 15:30:00 | QQQ | ETF | 36.305 | 36.42 | 36.28 | 36.359 | 8154400.0 |
| 2004-05-27 16:00:00 | QQQ | ETF | 36.36 | 36.452 | 36.33 | 36.43 | 2078400.0 |
| 2004-05-27 16:30:00 | QQQ | ETF | 36.43 | 36.52 | 36.29 | 36.52 | 1193500.0 |
| 2004-05-27 17:00:00 | QQQ | ETF | 36.501 | 36.52 | 36.44 | 36.46 | 284300.0 |
| 2004-05-27 17:30:00 | QQQ | ETF | 36.46 | 36.46 | 36.44 | 36.44 | 28000.0 |
| 2004-05-27 18:00:00 | QQQ | ETF | 36.46 | 36.471 | 36.44 | 36.45 | 22000.0 |
| 2004-05-27 18:30:00 | QQQ | ETF | 36.45 | 36.47 | 36.44 | 36.46 | 7400.0 |
| 2004-05-27 19:00:00 | QQQ | ETF | 36.45 | 36.45 | 36.45 | 36.45 | 600.0 |
| 2004-05-27 19:30:00 | QQQ | ETF | 36.45 | 36.5 | 36.45 | 36.5 | 11100.0 |
| 2004-05-27 08:30:00 | IWM | ETF | 56.785 | 56.8 | 56.725 | 56.8 | 4000.0 |
| 2004-05-27 09:00:00 | IWM | ETF | 56.825 | 56.825 | 56.825 | 56.825 | 1000.0 |
> showing 50 of 1,188 rows — these rows as CSV