PREVIEW / etf_30min / 2004-06-04
file: by_date/etf_30min/2004/2004-06-04.parquet size: 34 KB rows: 1,163
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-04 08:00:00 | SPY | ETF | 112.6 | 112.77 | 112.57 | 112.64 | 152700.0 |
| 2004-06-04 08:30:00 | SPY | ETF | 112.65 | 113.12 | 112.57 | 113.05 | 366700.0 |
| 2004-06-04 09:00:00 | SPY | ETF | 113.07 | 113.11 | 112.99 | 113.02 | 71800.0 |
| 2004-06-04 09:30:00 | SPY | ETF | 112.98 | 113.2 | 112.88 | 112.95 | 5970700.0 |
| 2004-06-04 10:00:00 | SPY | ETF | 112.95 | 113.18 | 112.79 | 113.06 | 3611800.0 |
| 2004-06-04 10:30:00 | SPY | ETF | 113.07 | 113.23 | 113.01 | 113.02 | 2118300.0 |
| 2004-06-04 11:00:00 | SPY | ETF | 113.04 | 113.21 | 113.03 | 113.03 | 1248900.0 |
| 2004-06-04 11:30:00 | SPY | ETF | 113.03 | 113.09 | 112.94 | 113.04 | 1082600.0 |
| 2004-06-04 12:00:00 | SPY | ETF | 113.04 | 113.23 | 113.02 | 113.15 | 1229700.0 |
| 2004-06-04 12:30:00 | SPY | ETF | 113.16 | 113.58 | 113.16 | 113.45 | 3218700.0 |
| 2004-06-04 13:00:00 | SPY | ETF | 113.44 | 113.47 | 113.285 | 113.4 | 965500.0 |
| 2004-06-04 13:30:00 | SPY | ETF | 113.39 | 113.42 | 113.23 | 113.32 | 910300.0 |
| 2004-06-04 14:00:00 | SPY | ETF | 113.34 | 113.36 | 113.01 | 113.08 | 1674900.0 |
| 2004-06-04 14:30:00 | SPY | ETF | 113.08 | 113.26 | 113.02 | 113.18 | 1128400.0 |
| 2004-06-04 15:00:00 | SPY | ETF | 113.19 | 113.34 | 112.99 | 113.15 | 1427200.0 |
| 2004-06-04 15:30:00 | SPY | ETF | 113.15 | 113.17 | 112.71 | 112.91 | 3472000.0 |
| 2004-06-04 16:00:00 | SPY | ETF | 112.91 | 112.98 | 112.79 | 112.9 | 1827300.0 |
| 2004-06-04 16:30:00 | SPY | ETF | 112.9 | 112.98 | 112.9 | 112.95 | 12300.0 |
| 2004-06-04 17:00:00 | SPY | ETF | 112.93 | 112.95 | 112.9 | 112.9 | 6400.0 |
| 2004-06-04 17:30:00 | SPY | ETF | 112.9 | 112.9 | 112.89 | 112.9 | 9900.0 |
| 2004-06-04 18:00:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 500.0 |
| 2004-06-04 18:30:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 8500.0 |
| 2004-06-04 19:00:00 | SPY | ETF | 112.9 | 112.9 | 112.87 | 112.87 | 900.0 |
| 2004-06-04 19:30:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 1200.0 |
| 2004-06-04 08:00:00 | QQQ | ETF | 36.12 | 36.26 | 36.12 | 36.19 | 302000.0 |
| 2004-06-04 08:30:00 | QQQ | ETF | 36.18 | 36.35 | 36.18 | 36.32 | 840600.0 |
| 2004-06-04 09:00:00 | QQQ | ETF | 36.32 | 36.35 | 36.3 | 36.33 | 341400.0 |
| 2004-06-04 09:30:00 | QQQ | ETF | 36.33 | 36.41 | 36.25 | 36.341 | 13232900.0 |
| 2004-06-04 10:00:00 | QQQ | ETF | 36.34 | 36.39 | 36.221 | 36.356 | 10060000.0 |
| 2004-06-04 10:30:00 | QQQ | ETF | 36.36 | 36.44 | 36.33 | 36.365 | 6305300.0 |
| 2004-06-04 11:00:00 | QQQ | ETF | 36.37 | 36.43 | 36.34 | 36.35 | 3784800.0 |
| 2004-06-04 11:30:00 | QQQ | ETF | 36.35 | 36.4 | 36.31 | 36.38 | 3083600.0 |
| 2004-06-04 12:00:00 | QQQ | ETF | 36.37 | 36.467 | 36.37 | 36.45 | 5669500.0 |
| 2004-06-04 12:30:00 | QQQ | ETF | 36.45 | 36.62 | 36.45 | 36.558 | 11780700.0 |
| 2004-06-04 13:00:00 | QQQ | ETF | 36.558 | 36.59 | 36.46 | 36.53 | 3222300.0 |
| 2004-06-04 13:30:00 | QQQ | ETF | 36.54 | 36.54 | 36.433 | 36.49 | 5009900.0 |
| 2004-06-04 14:00:00 | QQQ | ETF | 36.49 | 36.49 | 36.36 | 36.379 | 4117700.0 |
| 2004-06-04 14:30:00 | QQQ | ETF | 36.4 | 36.47 | 36.37 | 36.43 | 3974800.0 |
| 2004-06-04 15:00:00 | QQQ | ETF | 36.43 | 36.48 | 36.35 | 36.41 | 5809100.0 |
| 2004-06-04 15:30:00 | QQQ | ETF | 36.42 | 36.45 | 36.18 | 36.22 | 9472900.0 |
| 2004-06-04 16:00:00 | QQQ | ETF | 36.224 | 36.25 | 36.14 | 36.24 | 2139900.0 |
| 2004-06-04 16:30:00 | QQQ | ETF | 36.25 | 36.29 | 36.23 | 36.28 | 113700.0 |
| 2004-06-04 17:00:00 | QQQ | ETF | 36.27 | 36.28 | 36.25 | 36.28 | 68300.0 |
| 2004-06-04 17:30:00 | QQQ | ETF | 36.26 | 36.28 | 36.25 | 36.27 | 28700.0 |
| 2004-06-04 18:00:00 | QQQ | ETF | 36.26 | 36.29 | 36.26 | 36.29 | 13500.0 |
| 2004-06-04 18:30:00 | QQQ | ETF | 36.3 | 36.31 | 36.27 | 36.27 | 3600.0 |
| 2004-06-04 19:00:00 | QQQ | ETF | 36.24 | 36.24 | 36.23 | 36.24 | 5800.0 |
| 2004-06-04 19:30:00 | QQQ | ETF | 36.27 | 36.27 | 36.25 | 36.26 | 2300.0 |
| 2004-06-04 08:00:00 | IWM | ETF | 56.325 | 56.325 | 56.325 | 56.325 | 1800.0 |
| 2004-06-04 08:30:00 | IWM | ETF | 56.435 | 56.6 | 56.435 | 56.575 | 94000.0 |
> showing 50 of 1,163 rows — these rows as CSV