PREVIEW / etf_30min / 2004-10-15
file: by_date/etf_30min/2004/2004-10-15.parquet size: 37 KB rows: 1,223
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-15 08:00:00 | SPY | ETF | 110.68 | 110.69 | 110.67 | 110.67 | 11200.0 |
| 2004-10-15 08:30:00 | SPY | ETF | 110.72 | 110.95 | 110.72 | 110.88 | 191800.0 |
| 2004-10-15 09:00:00 | SPY | ETF | 110.88 | 111.03 | 110.88 | 110.99 | 219100.0 |
| 2004-10-15 09:30:00 | SPY | ETF | 111.02 | 111.11 | 110.58 | 110.72 | 7980000.0 |
| 2004-10-15 10:00:00 | SPY | ETF | 110.71 | 111.13 | 110.65 | 111.1 | 7956500.0 |
| 2004-10-15 10:30:00 | SPY | ETF | 111.09 | 111.15 | 110.9 | 111.06 | 4096800.0 |
| 2004-10-15 11:00:00 | SPY | ETF | 111.05 | 111.07 | 110.83 | 110.9 | 2178900.0 |
| 2004-10-15 11:30:00 | SPY | ETF | 110.89 | 111.02 | 110.85 | 110.91 | 2609700.0 |
| 2004-10-15 12:00:00 | SPY | ETF | 110.91 | 111.43 | 110.74 | 111.33 | 12756100.0 |
| 2004-10-15 12:30:00 | SPY | ETF | 111.33 | 111.54 | 111.29 | 111.43 | 4485900.0 |
| 2004-10-15 13:00:00 | SPY | ETF | 111.43 | 111.58 | 111.36 | 111.55 | 1344900.0 |
| 2004-10-15 13:30:00 | SPY | ETF | 111.56 | 111.74 | 111.53 | 111.6 | 2289700.0 |
| 2004-10-15 14:00:00 | SPY | ETF | 111.6 | 111.65 | 111.33 | 111.35 | 2491600.0 |
| 2004-10-15 14:30:00 | SPY | ETF | 111.34 | 111.44 | 111.23 | 111.31 | 3221600.0 |
| 2004-10-15 15:00:00 | SPY | ETF | 111.31 | 111.43 | 111.05 | 111.39 | 3692600.0 |
| 2004-10-15 15:30:00 | SPY | ETF | 111.39 | 111.44 | 111.11 | 111.17 | 3542900.0 |
| 2004-10-15 16:00:00 | SPY | ETF | 111.19 | 111.33 | 111.13 | 111.2 | 1625500.0 |
| 2004-10-15 16:30:00 | SPY | ETF | 111.2 | 111.34 | 111.15 | 111.3 | 111800.0 |
| 2004-10-15 17:00:00 | SPY | ETF | 111.33 | 111.35 | 111.26 | 111.26 | 700.0 |
| 2004-10-15 17:30:00 | SPY | ETF | 111.26 | 111.26 | 111.23 | 111.23 | 500.0 |
| 2004-10-15 19:00:00 | SPY | ETF | 111.24 | 111.24 | 111.24 | 111.24 | 200.0 |
| 2004-10-15 19:30:00 | SPY | ETF | 111.33 | 111.35 | 111.33 | 111.35 | 400.0 |
| 2004-10-15 08:00:00 | QQQ | ETF | 35.42 | 35.44 | 35.38 | 35.4 | 90900.0 |
| 2004-10-15 08:30:00 | QQQ | ETF | 35.4 | 35.51 | 35.4 | 35.49 | 583500.0 |
| 2004-10-15 09:00:00 | QQQ | ETF | 35.49 | 35.53 | 35.48 | 35.49 | 284300.0 |
| 2004-10-15 09:30:00 | QQQ | ETF | 35.504 | 35.62 | 35.34 | 35.43 | 15296400.0 |
| 2004-10-15 10:00:00 | QQQ | ETF | 35.431 | 35.58 | 35.36 | 35.547 | 10730400.0 |
| 2004-10-15 10:30:00 | QQQ | ETF | 35.55 | 35.6 | 35.5 | 35.54 | 13193700.0 |
| 2004-10-15 11:00:00 | QQQ | ETF | 35.55 | 35.55 | 35.45 | 35.49 | 4863700.0 |
| 2004-10-15 11:30:00 | QQQ | ETF | 35.491 | 35.52 | 35.4 | 35.425 | 4306100.0 |
| 2004-10-15 12:00:00 | QQQ | ETF | 35.425 | 35.65 | 35.28 | 35.56 | 13051100.0 |
| 2004-10-15 12:30:00 | QQQ | ETF | 35.572 | 35.72 | 35.56 | 35.65 | 6380400.0 |
| 2004-10-15 13:00:00 | QQQ | ETF | 35.65 | 35.75 | 35.62 | 35.74 | 4846600.0 |
| 2004-10-15 13:30:00 | QQQ | ETF | 35.74 | 35.856 | 35.7 | 35.72 | 11595800.0 |
| 2004-10-15 14:00:00 | QQQ | ETF | 35.73 | 35.772 | 35.63 | 35.633 | 4580000.0 |
| 2004-10-15 14:30:00 | QQQ | ETF | 35.63 | 35.67 | 35.566 | 35.62 | 6187200.0 |
| 2004-10-15 15:00:00 | QQQ | ETF | 35.62 | 35.65 | 35.46 | 35.64 | 7795700.0 |
| 2004-10-15 15:30:00 | QQQ | ETF | 35.64 | 35.65 | 35.53 | 35.58 | 8399700.0 |
| 2004-10-15 16:00:00 | QQQ | ETF | 35.585 | 35.67 | 35.57 | 35.58 | 2571500.0 |
| 2004-10-15 16:30:00 | QQQ | ETF | 35.64 | 35.68 | 35.62 | 35.68 | 51500.0 |
| 2004-10-15 17:00:00 | QQQ | ETF | 35.674 | 35.7 | 35.65 | 35.69 | 27200.0 |
| 2004-10-15 17:30:00 | QQQ | ETF | 35.66 | 35.69 | 35.66 | 35.69 | 1700.0 |
| 2004-10-15 18:00:00 | QQQ | ETF | 35.68 | 35.699 | 35.66 | 35.68 | 4700.0 |
| 2004-10-15 18:30:00 | QQQ | ETF | 35.68 | 35.68 | 35.68 | 35.68 | 800.0 |
| 2004-10-15 19:00:00 | QQQ | ETF | 35.68 | 35.68 | 35.68 | 35.68 | 200.0 |
| 2004-10-15 19:30:00 | QQQ | ETF | 35.67 | 35.71 | 35.67 | 35.71 | 4800.0 |
| 2004-10-15 08:00:00 | IWM | ETF | 56.27 | 56.27 | 56.27 | 56.27 | 4000.0 |
| 2004-10-15 08:30:00 | IWM | ETF | 56.46 | 56.46 | 56.46 | 56.46 | 800.0 |
| 2004-10-15 09:00:00 | IWM | ETF | 56.44 | 56.45 | 56.435 | 56.45 | 30200.0 |
| 2004-10-15 09:30:00 | IWM | ETF | 56.505 | 56.58 | 56.145 | 56.185 | 2486600.0 |
> showing 50 of 1,223 rows — these rows as CSV