PREVIEW / etf_30min / 2004-05-04
file: by_date/etf_30min/2004/2004-05-04.parquet size: 36 KB rows: 1,161
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-05-04 08:00:00 | SPY | ETF | 112.3 | 112.41 | 112.3 | 112.36 | 19500.0 |
| 2004-05-04 08:30:00 | SPY | ETF | 112.33 | 112.35 | 112.3 | 112.31 | 22800.0 |
| 2004-05-04 09:00:00 | SPY | ETF | 112.33 | 112.35 | 112.26 | 112.26 | 4600.0 |
| 2004-05-04 09:30:00 | SPY | ETF | 112.25 | 112.32 | 112.08 | 112.26 | 4726800.0 |
| 2004-05-04 10:00:00 | SPY | ETF | 112.28 | 112.43 | 112.11 | 112.21 | 2658000.0 |
| 2004-05-04 10:30:00 | SPY | ETF | 112.21 | 112.35 | 112.17 | 112.2 | 941100.0 |
| 2004-05-04 11:00:00 | SPY | ETF | 112.2 | 112.3 | 112.08 | 112.14 | 2116700.0 |
| 2004-05-04 11:30:00 | SPY | ETF | 112.15 | 112.18 | 111.91 | 111.92 | 1770100.0 |
| 2004-05-04 12:00:00 | SPY | ETF | 111.96 | 111.99 | 111.81 | 111.86 | 1784600.0 |
| 2004-05-04 12:30:00 | SPY | ETF | 111.86 | 111.88 | 111.66 | 111.81 | 1684400.0 |
| 2004-05-04 13:00:00 | SPY | ETF | 111.81 | 112.06 | 111.78 | 111.99 | 1220300.0 |
| 2004-05-04 13:30:00 | SPY | ETF | 112.0 | 112.11 | 111.94 | 112.05 | 1194200.0 |
| 2004-05-04 14:00:00 | SPY | ETF | 112.03 | 112.65 | 111.7 | 112.3 | 8251100.0 |
| 2004-05-04 14:30:00 | SPY | ETF | 112.26 | 113.26 | 112.2 | 113.21 | 7812600.0 |
| 2004-05-04 15:00:00 | SPY | ETF | 113.2 | 113.25 | 112.179 | 112.2 | 7795500.0 |
| 2004-05-04 15:30:00 | SPY | ETF | 112.2 | 112.45 | 111.95 | 112.36 | 5123700.0 |
| 2004-05-04 16:00:00 | SPY | ETF | 112.34 | 112.93 | 112.04 | 112.04 | 1581000.0 |
| 2004-05-04 16:30:00 | SPY | ETF | 112.66 | 112.66 | 112.03 | 112.05 | 94800.0 |
| 2004-05-04 17:00:00 | SPY | ETF | 112.05 | 112.5424 | 112.02 | 112.09 | 61500.0 |
| 2004-05-04 17:30:00 | SPY | ETF | 112.07 | 112.14 | 112.07 | 112.07 | 5500.0 |
| 2004-05-04 18:00:00 | SPY | ETF | 112.14 | 112.14 | 112.05 | 112.07 | 3100.0 |
| 2004-05-04 19:00:00 | SPY | ETF | 112.12 | 112.14 | 112.12 | 112.14 | 3600.0 |
| 2004-05-04 19:30:00 | SPY | ETF | 112.14 | 112.14 | 112.14 | 112.14 | 100.0 |
| 2004-05-04 08:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.23 | 35.23 | 16000.0 |
| 2004-05-04 08:30:00 | QQQ | ETF | 35.24 | 35.24 | 35.23 | 35.24 | 21000.0 |
| 2004-05-04 09:00:00 | QQQ | ETF | 35.25 | 35.25 | 35.21 | 35.21 | 24300.0 |
| 2004-05-04 09:30:00 | QQQ | ETF | 35.21 | 35.33 | 35.16 | 35.24 | 11168600.0 |
| 2004-05-04 10:00:00 | QQQ | ETF | 35.25 | 35.331 | 35.18 | 35.29 | 5716800.0 |
| 2004-05-04 10:30:00 | QQQ | ETF | 35.29 | 35.36 | 35.25 | 35.27 | 8402900.0 |
| 2004-05-04 11:00:00 | QQQ | ETF | 35.272 | 35.29 | 35.19 | 35.21 | 3220300.0 |
| 2004-05-04 11:30:00 | QQQ | ETF | 35.21 | 35.22 | 35.1 | 35.15 | 4109700.0 |
| 2004-05-04 12:00:00 | QQQ | ETF | 35.15 | 35.18 | 35.11 | 35.138 | 2738700.0 |
| 2004-05-04 12:30:00 | QQQ | ETF | 35.14 | 35.14 | 35.03 | 35.06 | 2955400.0 |
| 2004-05-04 13:00:00 | QQQ | ETF | 35.07 | 35.19 | 35.06 | 35.176 | 2400000.0 |
| 2004-05-04 13:30:00 | QQQ | ETF | 35.176 | 35.26 | 35.15 | 35.234 | 4104700.0 |
| 2004-05-04 14:00:00 | QQQ | ETF | 35.23 | 35.44 | 35.118 | 35.29 | 17040500.0 |
| 2004-05-04 14:30:00 | QQQ | ETF | 35.289 | 35.746 | 35.23 | 35.72 | 21801400.0 |
| 2004-05-04 15:00:00 | QQQ | ETF | 35.72 | 35.75 | 35.248 | 35.26 | 15408400.0 |
| 2004-05-04 15:30:00 | QQQ | ETF | 35.271 | 35.48 | 35.22 | 35.41 | 14205900.0 |
| 2004-05-04 16:00:00 | QQQ | ETF | 35.41 | 35.42 | 35.23 | 35.25 | 4757400.0 |
| 2004-05-04 16:30:00 | QQQ | ETF | 35.25 | 35.3026 | 35.23 | 35.25 | 1347600.0 |
| 2004-05-04 17:00:00 | QQQ | ETF | 35.24 | 35.4855 | 35.201 | 35.25 | 168800.0 |
| 2004-05-04 17:30:00 | QQQ | ETF | 35.26 | 35.26 | 35.24 | 35.25 | 13500.0 |
| 2004-05-04 18:00:00 | QQQ | ETF | 35.25 | 35.26 | 35.24 | 35.26 | 40800.0 |
| 2004-05-04 18:30:00 | QQQ | ETF | 35.25 | 35.25 | 35.23 | 35.23 | 7000.0 |
| 2004-05-04 19:00:00 | QQQ | ETF | 35.25 | 35.26 | 35.24 | 35.24 | 8200.0 |
| 2004-05-04 19:30:00 | QQQ | ETF | 35.24 | 35.25 | 35.24 | 35.24 | 8200.0 |
| 2004-05-04 08:00:00 | IWM | ETF | 56.345 | 56.44 | 56.345 | 56.435 | 6000.0 |
| 2004-05-04 08:30:00 | IWM | ETF | 56.405 | 56.405 | 56.405 | 56.405 | 200.0 |
| 2004-05-04 09:30:00 | IWM | ETF | 56.33 | 56.625 | 56.33 | 56.43 | 921600.0 |
> showing 50 of 1,161 rows — these rows as CSV