PREVIEW / etf_30min / 2004-08-23
file: by_date/etf_30min/2004/2004-08-23.parquet size: 34 KB rows: 1,147
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-08-23 08:00:00 | SPY | ETF | 110.5 | 110.56 | 110.5 | 110.56 | 20800.0 |
| 2004-08-23 08:30:00 | SPY | ETF | 110.6 | 110.66 | 110.55 | 110.66 | 6300.0 |
| 2004-08-23 09:00:00 | SPY | ETF | 110.66 | 110.68 | 110.53 | 110.57 | 75000.0 |
| 2004-08-23 09:30:00 | SPY | ETF | 110.55 | 110.67 | 110.26 | 110.32 | 5654700.0 |
| 2004-08-23 10:00:00 | SPY | ETF | 110.32 | 110.67 | 110.23 | 110.54 | 6277100.0 |
| 2004-08-23 10:30:00 | SPY | ETF | 110.54 | 110.69 | 110.47 | 110.59 | 2211000.0 |
| 2004-08-23 11:00:00 | SPY | ETF | 110.59 | 110.62 | 110.4 | 110.53 | 2343200.0 |
| 2004-08-23 11:30:00 | SPY | ETF | 110.53 | 110.6 | 110.44 | 110.5 | 664100.0 |
| 2004-08-23 12:00:00 | SPY | ETF | 110.5 | 110.6 | 110.42 | 110.45 | 527000.0 |
| 2004-08-23 12:30:00 | SPY | ETF | 110.45 | 110.52 | 110.36 | 110.38 | 795200.0 |
| 2004-08-23 13:00:00 | SPY | ETF | 110.39 | 110.46 | 110.24 | 110.33 | 1634200.0 |
| 2004-08-23 13:30:00 | SPY | ETF | 110.32 | 110.61 | 110.3 | 110.59 | 1720100.0 |
| 2004-08-23 14:00:00 | SPY | ETF | 110.58 | 110.77 | 110.515 | 110.6 | 1478000.0 |
| 2004-08-23 14:30:00 | SPY | ETF | 110.6 | 110.61 | 110.32 | 110.37 | 1705000.0 |
| 2004-08-23 15:00:00 | SPY | ETF | 110.35 | 110.38 | 110.05 | 110.17 | 3478300.0 |
| 2004-08-23 15:30:00 | SPY | ETF | 110.17 | 110.35 | 110.12 | 110.2 | 2410200.0 |
| 2004-08-23 16:00:00 | SPY | ETF | 110.22 | 110.29 | 110.14 | 110.24 | 1724400.0 |
| 2004-08-23 16:30:00 | SPY | ETF | 110.19 | 110.27 | 110.18 | 110.27 | 19100.0 |
| 2004-08-23 17:00:00 | SPY | ETF | 110.2 | 110.22 | 110.2 | 110.21 | 81900.0 |
| 2004-08-23 17:30:00 | SPY | ETF | 110.2 | 110.2 | 109.55 | 110.2 | 18300.0 |
| 2004-08-23 18:00:00 | SPY | ETF | 110.52 | 110.52 | 110.2 | 110.24 | 4300.0 |
| 2004-08-23 18:30:00 | SPY | ETF | 110.23 | 110.26 | 110.23 | 110.26 | 3000.0 |
| 2004-08-23 19:00:00 | SPY | ETF | 110.26 | 110.26 | 110.26 | 110.26 | 1000.0 |
| 2004-08-23 19:30:00 | SPY | ETF | 110.27 | 110.27 | 110.27 | 110.27 | 200.0 |
| 2004-08-23 08:00:00 | QQQ | ETF | 34.13 | 34.13 | 34.04 | 34.08 | 123500.0 |
| 2004-08-23 08:30:00 | QQQ | ETF | 34.08 | 34.1 | 34.05 | 34.08 | 127400.0 |
| 2004-08-23 09:00:00 | QQQ | ETF | 34.09 | 34.09 | 34.06 | 34.06 | 117700.0 |
| 2004-08-23 09:30:00 | QQQ | ETF | 34.05 | 34.1 | 33.91 | 33.96 | 14206500.0 |
| 2004-08-23 10:00:00 | QQQ | ETF | 33.96 | 34.16 | 33.92 | 34.12 | 10241800.0 |
| 2004-08-23 10:30:00 | QQQ | ETF | 34.123 | 34.19 | 34.09 | 34.187 | 6374700.0 |
| 2004-08-23 11:00:00 | QQQ | ETF | 34.188 | 34.189 | 34.06 | 34.14 | 5862100.0 |
| 2004-08-23 11:30:00 | QQQ | ETF | 34.141 | 34.17 | 34.08 | 34.1 | 2650800.0 |
| 2004-08-23 12:00:00 | QQQ | ETF | 34.12 | 34.18 | 34.07 | 34.09 | 3318200.0 |
| 2004-08-23 12:30:00 | QQQ | ETF | 34.0894 | 34.16 | 34.07 | 34.08 | 3491800.0 |
| 2004-08-23 13:00:00 | QQQ | ETF | 34.079 | 34.11 | 34.03 | 34.05 | 4411400.0 |
| 2004-08-23 13:30:00 | QQQ | ETF | 34.05 | 34.219 | 34.04 | 34.18 | 4770500.0 |
| 2004-08-23 14:00:00 | QQQ | ETF | 34.182 | 34.27 | 34.17 | 34.212 | 6364800.0 |
| 2004-08-23 14:30:00 | QQQ | ETF | 34.22 | 34.22 | 34.114 | 34.14 | 3344400.0 |
| 2004-08-23 15:00:00 | QQQ | ETF | 34.14 | 34.15 | 33.99 | 34.04 | 7060800.0 |
| 2004-08-23 15:30:00 | QQQ | ETF | 34.043 | 34.13 | 34.01 | 34.098 | 6639900.0 |
| 2004-08-23 16:00:00 | QQQ | ETF | 34.09 | 34.16 | 34.06 | 34.09 | 1859700.0 |
| 2004-08-23 16:30:00 | QQQ | ETF | 34.081 | 34.1 | 34.077 | 34.08 | 213000.0 |
| 2004-08-23 17:00:00 | QQQ | ETF | 34.09 | 34.1 | 34.08 | 34.1 | 79600.0 |
| 2004-08-23 17:30:00 | QQQ | ETF | 34.1 | 34.12 | 34.09 | 34.11 | 38100.0 |
| 2004-08-23 18:00:00 | QQQ | ETF | 34.11 | 34.12 | 34.08 | 34.08 | 87900.0 |
| 2004-08-23 18:30:00 | QQQ | ETF | 34.08 | 34.08 | 34.08 | 34.08 | 1000.0 |
| 2004-08-23 19:00:00 | QQQ | ETF | 34.08 | 34.1 | 34.08 | 34.1 | 3700.0 |
| 2004-08-23 19:30:00 | QQQ | ETF | 34.1 | 34.1 | 34.1 | 34.1 | 3100.0 |
| 2004-08-23 08:00:00 | IWM | ETF | 54.645 | 54.645 | 54.645 | 54.645 | 1400.0 |
| 2004-08-23 08:30:00 | IWM | ETF | 54.695 | 54.75 | 54.695 | 54.695 | 7200.0 |
> showing 50 of 1,147 rows — these rows as CSV