PREVIEW / etf_30min / 2004-09-16
file: by_date/etf_30min/2004/2004-09-16.parquet size: 34 KB rows: 1,162
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-16 08:00:00 | SPY | ETF | 112.8 | 112.82 | 112.76 | 112.8 | 69800.0 |
| 2004-09-16 08:30:00 | SPY | ETF | 112.88 | 112.9 | 112.83 | 112.85 | 20200.0 |
| 2004-09-16 09:00:00 | SPY | ETF | 112.85 | 112.9 | 112.8 | 112.8 | 9600.0 |
| 2004-09-16 09:30:00 | SPY | ETF | 112.85 | 113.11 | 112.84 | 113.11 | 3073100.0 |
| 2004-09-16 10:00:00 | SPY | ETF | 113.11 | 113.28 | 113.07 | 113.25 | 2853900.0 |
| 2004-09-16 10:30:00 | SPY | ETF | 113.24 | 113.37 | 113.19 | 113.26 | 1606400.0 |
| 2004-09-16 11:00:00 | SPY | ETF | 113.26 | 113.3 | 113.21 | 113.26 | 981100.0 |
| 2004-09-16 11:30:00 | SPY | ETF | 113.27 | 113.3 | 113.13 | 113.16 | 868500.0 |
| 2004-09-16 12:00:00 | SPY | ETF | 113.17 | 113.2 | 112.99 | 113.13 | 3010200.0 |
| 2004-09-16 12:30:00 | SPY | ETF | 113.13 | 113.28 | 113.13 | 113.17 | 683400.0 |
| 2004-09-16 13:00:00 | SPY | ETF | 113.17 | 113.2 | 113.11 | 113.19 | 784100.0 |
| 2004-09-16 13:30:00 | SPY | ETF | 113.19 | 113.27 | 113.15 | 113.23 | 966100.0 |
| 2004-09-16 14:00:00 | SPY | ETF | 113.2316 | 113.33 | 113.17 | 113.31 | 1315600.0 |
| 2004-09-16 14:30:00 | SPY | ETF | 113.29 | 113.33 | 113.17 | 113.19 | 871000.0 |
| 2004-09-16 15:00:00 | SPY | ETF | 113.18 | 113.2 | 112.92 | 113.02 | 2226600.0 |
| 2004-09-16 15:30:00 | SPY | ETF | 113.02 | 113.18 | 113.01 | 113.1 | 2022900.0 |
| 2004-09-16 16:00:00 | SPY | ETF | 113.1 | 113.22 | 113.06 | 113.09 | 1255600.0 |
| 2004-09-16 16:30:00 | SPY | ETF | 113.11 | 113.17 | 113.07 | 113.17 | 104700.0 |
| 2004-09-16 17:00:00 | SPY | ETF | 113.14 | 113.14 | 113.1 | 113.1 | 108500.0 |
| 2004-09-16 17:30:00 | SPY | ETF | 113.15 | 113.15 | 113.12 | 113.12 | 700.0 |
| 2004-09-16 18:00:00 | SPY | ETF | 113.12 | 113.12 | 113.12 | 113.12 | 1500.0 |
| 2004-09-16 18:30:00 | SPY | ETF | 113.13 | 113.13 | 113.12 | 113.12 | 3600.0 |
| 2004-09-16 19:00:00 | SPY | ETF | 113.12 | 113.12 | 113.11 | 113.11 | 1000.0 |
| 2004-09-16 19:30:00 | SPY | ETF | 113.11 | 113.11 | 113.11 | 113.11 | 300.0 |
| 2004-09-16 08:00:00 | QQQ | ETF | 35.26 | 35.26 | 35.21 | 35.24 | 74800.0 |
| 2004-09-16 08:30:00 | QQQ | ETF | 35.28 | 35.29 | 35.26 | 35.29 | 58700.0 |
| 2004-09-16 09:00:00 | QQQ | ETF | 35.28 | 35.28 | 35.25 | 35.27 | 158700.0 |
| 2004-09-16 09:30:00 | QQQ | ETF | 35.26 | 35.42 | 35.26 | 35.41 | 9541900.0 |
| 2004-09-16 10:00:00 | QQQ | ETF | 35.41 | 35.52 | 35.4 | 35.5 | 6439600.0 |
| 2004-09-16 10:30:00 | QQQ | ETF | 35.5 | 35.57 | 35.49 | 35.51 | 5922500.0 |
| 2004-09-16 11:00:00 | QQQ | ETF | 35.51 | 35.52 | 35.47 | 35.503 | 3839900.0 |
| 2004-09-16 11:30:00 | QQQ | ETF | 35.51 | 35.52 | 35.36 | 35.39 | 3678900.0 |
| 2004-09-16 12:00:00 | QQQ | ETF | 35.39 | 35.4 | 35.29 | 35.35 | 7497200.0 |
| 2004-09-16 12:30:00 | QQQ | ETF | 35.36 | 35.43 | 35.34 | 35.37 | 2006200.0 |
| 2004-09-16 13:00:00 | QQQ | ETF | 35.371 | 35.38 | 35.31 | 35.36 | 1561500.0 |
| 2004-09-16 13:30:00 | QQQ | ETF | 35.36 | 35.401 | 35.34 | 35.38 | 2275200.0 |
| 2004-09-16 14:00:00 | QQQ | ETF | 35.38 | 35.44 | 35.35 | 35.39 | 3597000.0 |
| 2004-09-16 14:30:00 | QQQ | ETF | 35.39 | 35.39 | 35.26 | 35.287 | 3321100.0 |
| 2004-09-16 15:00:00 | QQQ | ETF | 35.288 | 35.3 | 35.13 | 35.19 | 7785100.0 |
| 2004-09-16 15:30:00 | QQQ | ETF | 35.19 | 35.29 | 35.19 | 35.241 | 6591700.0 |
| 2004-09-16 16:00:00 | QQQ | ETF | 35.246 | 35.34 | 35.24 | 35.29 | 2108900.0 |
| 2004-09-16 16:30:00 | QQQ | ETF | 35.29 | 35.32 | 35.272 | 35.3 | 99900.0 |
| 2004-09-16 17:00:00 | QQQ | ETF | 35.29 | 35.329 | 35.285 | 35.301 | 125100.0 |
| 2004-09-16 17:30:00 | QQQ | ETF | 35.32 | 35.34 | 35.301 | 35.34 | 6200.0 |
| 2004-09-16 18:00:00 | QQQ | ETF | 35.34 | 35.34 | 35.32 | 35.33 | 20900.0 |
| 2004-09-16 19:00:00 | QQQ | ETF | 35.32 | 35.32 | 35.31 | 35.32 | 5900.0 |
| 2004-09-16 19:30:00 | QQQ | ETF | 35.32 | 35.32 | 35.32 | 35.32 | 18500.0 |
| 2004-09-16 09:00:00 | IWM | ETF | 56.78 | 56.87 | 56.78 | 56.87 | 10800.0 |
| 2004-09-16 09:30:00 | IWM | ETF | 56.835 | 57.125 | 56.835 | 57.1 | 1334600.0 |
| 2004-09-16 10:00:00 | IWM | ETF | 57.115 | 57.3 | 57.11 | 57.27 | 1021600.0 |
> showing 50 of 1,162 rows — these rows as CSV