PREVIEW / etf_30min / 2004-10-04
file: by_date/etf_30min/2004/2004-10-04.parquet size: 36 KB rows: 1,247
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-10-04 08:00:00 | SPY | ETF | 114.17 | 114.26 | 114.11 | 114.26 | 144200.0 |
| 2004-10-04 08:30:00 | SPY | ETF | 114.23 | 114.34 | 114.22 | 114.3 | 189300.0 |
| 2004-10-04 09:00:00 | SPY | ETF | 114.29 | 114.32 | 114.1 | 114.11 | 125300.0 |
| 2004-10-04 09:30:00 | SPY | ETF | 114.1 | 114.3 | 113.98 | 114.28 | 5692300.0 |
| 2004-10-04 10:00:00 | SPY | ETF | 114.3 | 114.44 | 114.15 | 114.19 | 3748400.0 |
| 2004-10-04 10:30:00 | SPY | ETF | 114.18 | 114.3 | 114.1 | 114.14 | 1708100.0 |
| 2004-10-04 11:00:00 | SPY | ETF | 114.16 | 114.36 | 114.15 | 114.2 | 2281700.0 |
| 2004-10-04 11:30:00 | SPY | ETF | 114.2 | 114.2 | 114.02 | 114.08 | 3200700.0 |
| 2004-10-04 12:00:00 | SPY | ETF | 114.08 | 114.14 | 114.01 | 114.1 | 994600.0 |
| 2004-10-04 12:30:00 | SPY | ETF | 114.1 | 114.12 | 113.96 | 113.99 | 1443100.0 |
| 2004-10-04 13:00:00 | SPY | ETF | 113.99 | 114.07 | 113.91 | 114.0 | 1201500.0 |
| 2004-10-04 13:30:00 | SPY | ETF | 114.0 | 114.15 | 113.99 | 114.08 | 951300.0 |
| 2004-10-04 14:00:00 | SPY | ETF | 114.08 | 114.28 | 114.01 | 114.24 | 1220100.0 |
| 2004-10-04 14:30:00 | SPY | ETF | 114.24 | 114.24 | 113.99 | 114.02 | 1558000.0 |
| 2004-10-04 15:00:00 | SPY | ETF | 114.02 | 114.13 | 113.95 | 114.11 | 1689500.0 |
| 2004-10-04 15:30:00 | SPY | ETF | 114.11 | 114.13 | 113.8 | 113.85 | 3893300.0 |
| 2004-10-04 16:00:00 | SPY | ETF | 113.85 | 113.9848 | 113.75 | 113.85 | 937000.0 |
| 2004-10-04 16:30:00 | SPY | ETF | 113.84 | 113.84 | 113.73 | 113.75 | 207300.0 |
| 2004-10-04 17:00:00 | SPY | ETF | 113.73 | 113.75 | 113.71 | 113.75 | 8200.0 |
| 2004-10-04 17:30:00 | SPY | ETF | 113.73 | 113.75 | 113.72 | 113.75 | 252000.0 |
| 2004-10-04 18:00:00 | SPY | ETF | 113.73 | 113.73 | 113.73 | 113.73 | 250000.0 |
| 2004-10-04 19:00:00 | SPY | ETF | 113.73 | 113.73 | 113.73 | 113.73 | 200.0 |
| 2004-10-04 19:30:00 | SPY | ETF | 113.75 | 113.75 | 113.73 | 113.73 | 600.0 |
| 2004-10-04 08:00:00 | QQQ | ETF | 36.42 | 36.44 | 36.38 | 36.4 | 405900.0 |
| 2004-10-04 08:30:00 | QQQ | ETF | 36.4 | 36.49 | 36.39 | 36.48 | 459600.0 |
| 2004-10-04 09:00:00 | QQQ | ETF | 36.48 | 36.48 | 36.34 | 36.36 | 737300.0 |
| 2004-10-04 09:30:00 | QQQ | ETF | 36.36 | 36.59 | 36.34 | 36.59 | 19153800.0 |
| 2004-10-04 10:00:00 | QQQ | ETF | 36.59 | 36.62 | 36.47 | 36.51 | 12347300.0 |
| 2004-10-04 10:30:00 | QQQ | ETF | 36.513 | 36.59 | 36.48 | 36.51 | 7000900.0 |
| 2004-10-04 11:00:00 | QQQ | ETF | 36.51 | 36.6 | 36.48 | 36.487 | 7386300.0 |
| 2004-10-04 11:30:00 | QQQ | ETF | 36.48 | 36.49 | 36.38 | 36.4 | 7809600.0 |
| 2004-10-04 12:00:00 | QQQ | ETF | 36.4 | 36.49 | 36.39 | 36.451 | 2801300.0 |
| 2004-10-04 12:30:00 | QQQ | ETF | 36.46 | 36.46 | 36.38 | 36.406 | 3609000.0 |
| 2004-10-04 13:00:00 | QQQ | ETF | 36.404 | 36.45 | 36.37 | 36.42 | 2862600.0 |
| 2004-10-04 13:30:00 | QQQ | ETF | 36.41 | 36.53 | 36.4 | 36.487 | 3659200.0 |
| 2004-10-04 14:00:00 | QQQ | ETF | 36.49 | 36.57 | 36.46 | 36.54 | 4987600.0 |
| 2004-10-04 14:30:00 | QQQ | ETF | 36.54 | 36.55 | 36.4 | 36.415 | 5350100.0 |
| 2004-10-04 15:00:00 | QQQ | ETF | 36.415 | 36.49 | 36.39 | 36.472 | 6791500.0 |
| 2004-10-04 15:30:00 | QQQ | ETF | 36.472 | 36.49 | 36.25 | 36.29 | 15317500.0 |
| 2004-10-04 16:00:00 | QQQ | ETF | 36.29 | 36.33 | 36.27 | 36.3 | 3198400.0 |
| 2004-10-04 16:30:00 | QQQ | ETF | 36.32 | 36.32 | 36.26 | 36.27 | 247100.0 |
| 2004-10-04 17:00:00 | QQQ | ETF | 36.265 | 36.3 | 36.265 | 36.3 | 212300.0 |
| 2004-10-04 17:30:00 | QQQ | ETF | 36.29 | 36.3 | 36.24 | 36.24 | 252400.0 |
| 2004-10-04 18:00:00 | QQQ | ETF | 36.25 | 36.27 | 36.22 | 36.26 | 109500.0 |
| 2004-10-04 18:30:00 | QQQ | ETF | 36.26 | 36.27 | 36.25 | 36.25 | 5500.0 |
| 2004-10-04 19:00:00 | QQQ | ETF | 36.25 | 36.28 | 36.25 | 36.28 | 4500.0 |
| 2004-10-04 19:30:00 | QQQ | ETF | 36.26 | 36.26 | 36.26 | 36.26 | 3500.0 |
| 2004-10-04 08:00:00 | IWM | ETF | 58.76 | 58.76 | 58.7 | 58.75 | 1200.0 |
| 2004-10-04 08:30:00 | IWM | ETF | 58.75 | 58.83 | 58.75 | 58.8 | 29400.0 |
| 2004-10-04 09:00:00 | IWM | ETF | 58.81 | 58.815 | 58.695 | 58.745 | 255000.0 |
> showing 50 of 1,247 rows — these rows as CSV