PREVIEW / etf_30min / 2004-09-01
file: by_date/etf_30min/2004/2004-09-01.parquet size: 34 KB rows: 1,138
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-09-01 08:00:00 | SPY | ETF | 111.08 | 111.1 | 111.05 | 111.05 | 12500.0 |
| 2004-09-01 08:30:00 | SPY | ETF | 111.06 | 111.06 | 110.99 | 111.0 | 35700.0 |
| 2004-09-01 09:00:00 | SPY | ETF | 111.04 | 111.04 | 110.94 | 110.97 | 286800.0 |
| 2004-09-01 09:30:00 | SPY | ETF | 110.95 | 111.19 | 110.87 | 110.88 | 4260000.0 |
| 2004-09-01 10:00:00 | SPY | ETF | 110.88 | 111.6 | 110.87 | 111.6 | 6793300.0 |
| 2004-09-01 10:30:00 | SPY | ETF | 111.6 | 111.64 | 111.33 | 111.37 | 3690000.0 |
| 2004-09-01 11:00:00 | SPY | ETF | 111.37 | 111.54 | 111.36 | 111.41 | 1587000.0 |
| 2004-09-01 11:30:00 | SPY | ETF | 111.41 | 111.41 | 111.2 | 111.27 | 2048800.0 |
| 2004-09-01 12:00:00 | SPY | ETF | 111.28 | 111.37 | 111.18 | 111.28 | 1195900.0 |
| 2004-09-01 12:30:00 | SPY | ETF | 111.28 | 111.42 | 111.26 | 111.31 | 1431400.0 |
| 2004-09-01 13:00:00 | SPY | ETF | 111.312 | 111.32 | 110.48 | 111.16 | 13975600.0 |
| 2004-09-01 13:30:00 | SPY | ETF | 111.16 | 111.29 | 111.14 | 111.18 | 1681800.0 |
| 2004-09-01 14:00:00 | SPY | ETF | 111.18 | 111.25 | 111.0 | 111.25 | 1384000.0 |
| 2004-09-01 14:30:00 | SPY | ETF | 111.25 | 111.3 | 111.14 | 111.2 | 1483600.0 |
| 2004-09-01 15:00:00 | SPY | ETF | 111.2 | 111.22 | 110.93 | 111.05 | 2416800.0 |
| 2004-09-01 15:30:00 | SPY | ETF | 111.04 | 111.31 | 111.0 | 111.31 | 2486400.0 |
| 2004-09-01 16:00:00 | SPY | ETF | 111.31 | 111.4 | 111.2 | 111.39 | 3163400.0 |
| 2004-09-01 16:30:00 | SPY | ETF | 111.32 | 111.34 | 111.29 | 111.34 | 39300.0 |
| 2004-09-01 17:00:00 | SPY | ETF | 111.32 | 111.34 | 111.32 | 111.33 | 14200.0 |
| 2004-09-01 18:30:00 | SPY | ETF | 111.31 | 111.31 | 111.31 | 111.31 | 500.0 |
| 2004-09-01 19:30:00 | SPY | ETF | 111.34 | 111.34 | 111.34 | 111.34 | 7800.0 |
| 2004-09-01 08:00:00 | QQQ | ETF | 34.02 | 34.02 | 33.96 | 34.01 | 90300.0 |
| 2004-09-01 08:30:00 | QQQ | ETF | 34.01 | 34.02 | 33.97 | 33.98 | 124400.0 |
| 2004-09-01 09:00:00 | QQQ | ETF | 33.98 | 33.98 | 33.93 | 33.93 | 172800.0 |
| 2004-09-01 09:30:00 | QQQ | ETF | 33.93 | 34.1 | 33.91 | 34.0 | 8124100.0 |
| 2004-09-01 10:00:00 | QQQ | ETF | 34.0 | 34.438 | 33.981 | 34.43 | 14248900.0 |
| 2004-09-01 10:30:00 | QQQ | ETF | 34.435 | 34.45 | 34.31 | 34.34 | 10806500.0 |
| 2004-09-01 11:00:00 | QQQ | ETF | 34.34 | 34.39 | 34.296 | 34.313 | 4733500.0 |
| 2004-09-01 11:30:00 | QQQ | ETF | 34.32 | 34.32 | 34.22 | 34.28 | 3999100.0 |
| 2004-09-01 12:00:00 | QQQ | ETF | 34.28 | 34.34 | 34.24 | 34.25 | 3184500.0 |
| 2004-09-01 12:30:00 | QQQ | ETF | 34.25 | 34.3 | 34.245 | 34.26 | 2286800.0 |
| 2004-09-01 13:00:00 | QQQ | ETF | 34.25 | 34.28 | 33.8 | 34.165 | 22032400.0 |
| 2004-09-01 13:30:00 | QQQ | ETF | 34.16 | 34.24 | 34.14 | 34.16 | 3016400.0 |
| 2004-09-01 14:00:00 | QQQ | ETF | 34.152 | 34.18 | 34.08 | 34.17 | 3160500.0 |
| 2004-09-01 14:30:00 | QQQ | ETF | 34.173 | 34.22 | 34.12 | 34.19 | 2123400.0 |
| 2004-09-01 15:00:00 | QQQ | ETF | 34.19 | 34.2 | 34.06 | 34.15 | 4549100.0 |
| 2004-09-01 15:30:00 | QQQ | ETF | 34.15 | 34.27 | 34.12 | 34.26 | 7389400.0 |
| 2004-09-01 16:00:00 | QQQ | ETF | 34.261 | 34.3184 | 34.22 | 34.26 | 2737300.0 |
| 2004-09-01 16:30:00 | QQQ | ETF | 34.25 | 34.27 | 34.24 | 34.27 | 408900.0 |
| 2004-09-01 17:00:00 | QQQ | ETF | 34.261 | 34.27 | 34.25 | 34.257 | 89000.0 |
| 2004-09-01 17:30:00 | QQQ | ETF | 34.28 | 34.28 | 34.27 | 34.27 | 5100.0 |
| 2004-09-01 18:00:00 | QQQ | ETF | 34.262 | 34.27 | 34.24 | 34.24 | 40200.0 |
| 2004-09-01 18:30:00 | QQQ | ETF | 34.25 | 34.25 | 34.25 | 34.25 | 1000.0 |
| 2004-09-01 19:30:00 | QQQ | ETF | 34.24 | 34.24 | 34.24 | 34.24 | 300.0 |
| 2004-09-01 08:00:00 | IWM | ETF | 54.68 | 54.68 | 54.68 | 54.68 | 8000.0 |
| 2004-09-01 08:30:00 | IWM | ETF | 54.68 | 54.68 | 54.68 | 54.68 | 1800.0 |
| 2004-09-01 09:00:00 | IWM | ETF | 54.605 | 54.605 | 54.6 | 54.6 | 23000.0 |
| 2004-09-01 09:30:00 | IWM | ETF | 54.545 | 55.545 | 54.545 | 54.95 | 5466200.0 |
| 2004-09-01 10:00:00 | IWM | ETF | 54.95 | 55.41 | 54.895 | 55.41 | 2594000.0 |
| 2004-09-01 10:30:00 | IWM | ETF | 55.425 | 55.45 | 55.2 | 55.26 | 1371000.0 |
> showing 50 of 1,138 rows — these rows as CSV