PREVIEW / etf_30min / 2004-11-10
file: by_date/etf_30min/2004/2004-11-10.parquet size: 37 KB rows: 1,284
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-11-10 08:00:00 | SPY | ETF | 117.28 | 117.28 | 117.21 | 117.26 | 28800.0 |
| 2004-11-10 08:30:00 | SPY | ETF | 117.23 | 117.26 | 117.11 | 117.11 | 51900.0 |
| 2004-11-10 09:00:00 | SPY | ETF | 117.11 | 117.11 | 117.02 | 117.03 | 34900.0 |
| 2004-11-10 09:30:00 | SPY | ETF | 117.09 | 117.12 | 116.88 | 116.9016 | 3647900.0 |
| 2004-11-10 10:00:00 | SPY | ETF | 116.9 | 117.02 | 116.81 | 116.94 | 2575600.0 |
| 2004-11-10 10:30:00 | SPY | ETF | 116.95 | 117.14 | 116.76 | 117.06 | 3863600.0 |
| 2004-11-10 11:00:00 | SPY | ETF | 117.06 | 117.09 | 116.96 | 117.01 | 1280500.0 |
| 2004-11-10 11:30:00 | SPY | ETF | 117.01 | 117.23 | 116.96 | 117.16 | 2990900.0 |
| 2004-11-10 12:00:00 | SPY | ETF | 117.15 | 117.24 | 117.13 | 117.18 | 1418000.0 |
| 2004-11-10 12:30:00 | SPY | ETF | 117.18 | 117.22 | 117.12 | 117.16 | 498000.0 |
| 2004-11-10 13:00:00 | SPY | ETF | 117.16 | 117.19 | 116.92 | 117.09 | 1529000.0 |
| 2004-11-10 13:30:00 | SPY | ETF | 117.09 | 117.1 | 116.96 | 117.02 | 1153600.0 |
| 2004-11-10 14:00:00 | SPY | ETF | 117.01 | 117.44 | 116.92 | 117.37 | 5883700.0 |
| 2004-11-10 14:30:00 | SPY | ETF | 117.38 | 117.55 | 117.14 | 117.35 | 5111400.0 |
| 2004-11-10 15:00:00 | SPY | ETF | 117.35 | 117.41 | 116.8 | 116.93 | 5675300.0 |
| 2004-11-10 15:30:00 | SPY | ETF | 116.92 | 117.09 | 116.84 | 116.92 | 4227800.0 |
| 2004-11-10 16:00:00 | SPY | ETF | 116.93 | 117.05 | 116.85 | 117.0 | 2060200.0 |
| 2004-11-10 16:30:00 | SPY | ETF | 116.99 | 117.02 | 116.97 | 117.02 | 36600.0 |
| 2004-11-10 17:00:00 | SPY | ETF | 116.97 | 116.99 | 116.94 | 116.94 | 4000.0 |
| 2004-11-10 18:00:00 | SPY | ETF | 116.93 | 116.93 | 116.93 | 116.93 | 1200.0 |
| 2004-11-10 18:30:00 | SPY | ETF | 116.97 | 117.0 | 116.97 | 117.0 | 700.0 |
| 2004-11-10 19:30:00 | SPY | ETF | 117.0 | 117.0 | 117.0 | 117.0 | 100.0 |
| 2004-11-10 08:00:00 | QQQ | ETF | 38.03 | 38.06 | 38.03 | 38.05 | 165100.0 |
| 2004-11-10 08:30:00 | QQQ | ETF | 38.06 | 38.06 | 37.95 | 37.95 | 278300.0 |
| 2004-11-10 09:00:00 | QQQ | ETF | 37.95 | 37.97 | 37.93 | 37.93 | 235000.0 |
| 2004-11-10 09:30:00 | QQQ | ETF | 37.94 | 37.96 | 37.86 | 37.88 | 9081700.0 |
| 2004-11-10 10:00:00 | QQQ | ETF | 37.87 | 37.88 | 37.78 | 37.83 | 7081700.0 |
| 2004-11-10 10:30:00 | QQQ | ETF | 37.84 | 37.88 | 37.74 | 37.85 | 8620500.0 |
| 2004-11-10 11:00:00 | QQQ | ETF | 37.85 | 37.85 | 37.76 | 37.785 | 2764400.0 |
| 2004-11-10 11:30:00 | QQQ | ETF | 37.78 | 37.896 | 37.78 | 37.86 | 3342300.0 |
| 2004-11-10 12:00:00 | QQQ | ETF | 37.86 | 37.89 | 37.83 | 37.87 | 2675000.0 |
| 2004-11-10 12:30:00 | QQQ | ETF | 37.87 | 37.87 | 37.84 | 37.84 | 1855800.0 |
| 2004-11-10 13:00:00 | QQQ | ETF | 37.84 | 37.86 | 37.76 | 37.847 | 4099300.0 |
| 2004-11-10 13:30:00 | QQQ | ETF | 37.85 | 37.85 | 37.77 | 37.8 | 2605700.0 |
| 2004-11-10 14:00:00 | QQQ | ETF | 37.8 | 38.0 | 37.786 | 37.96 | 10518700.0 |
| 2004-11-10 14:30:00 | QQQ | ETF | 37.95 | 38.06 | 37.86 | 37.97 | 13071400.0 |
| 2004-11-10 15:00:00 | QQQ | ETF | 37.97 | 38.0 | 37.66 | 37.71 | 14571100.0 |
| 2004-11-10 15:30:00 | QQQ | ETF | 37.702 | 37.75 | 37.64 | 37.74 | 10262900.0 |
| 2004-11-10 16:00:00 | QQQ | ETF | 37.744 | 37.81 | 37.65 | 37.72 | 1705000.0 |
| 2004-11-10 16:30:00 | QQQ | ETF | 37.739 | 37.8 | 37.7 | 37.75 | 140700.0 |
| 2004-11-10 17:00:00 | QQQ | ETF | 37.75 | 37.78 | 37.75 | 37.763 | 36800.0 |
| 2004-11-10 17:30:00 | QQQ | ETF | 37.76 | 37.76 | 37.75 | 37.75 | 7900.0 |
| 2004-11-10 18:00:00 | QQQ | ETF | 37.75 | 37.77 | 37.74 | 37.77 | 25700.0 |
| 2004-11-10 18:30:00 | QQQ | ETF | 37.77 | 37.78 | 37.75 | 37.76 | 4100.0 |
| 2004-11-10 19:00:00 | QQQ | ETF | 37.77 | 37.79 | 37.77 | 37.79 | 6700.0 |
| 2004-11-10 19:30:00 | QQQ | ETF | 37.79 | 37.8 | 37.78 | 37.8 | 11800.0 |
| 2004-11-10 08:00:00 | IWM | ETF | 60.525 | 60.525 | 60.525 | 60.525 | 1000.0 |
| 2004-11-10 08:30:00 | IWM | ETF | 60.545 | 60.545 | 60.505 | 60.505 | 3000.0 |
| 2004-11-10 09:00:00 | IWM | ETF | 60.375 | 60.375 | 60.375 | 60.375 | 1000.0 |
| 2004-11-10 09:30:00 | IWM | ETF | 60.4 | 60.445 | 60.3 | 60.375 | 896800.0 |
> showing 50 of 1,284 rows — these rows as CSV