PREVIEW / etf_30min / 2004-03-23
file: by_date/etf_30min/2004/2004-03-23.parquet size: 35 KB rows: 1,174
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-03-23 08:00:00 | SPY | ETF | 110.2 | 110.28 | 110.14 | 110.28 | 91300.0 |
| 2004-03-23 08:30:00 | SPY | ETF | 110.29 | 110.35 | 110.26 | 110.32 | 62700.0 |
| 2004-03-23 09:00:00 | SPY | ETF | 110.32 | 110.35 | 110.26 | 110.27 | 134400.0 |
| 2004-03-23 09:30:00 | SPY | ETF | 110.25 | 110.39 | 110.01 | 110.2 | 8512800.0 |
| 2004-03-23 10:00:00 | SPY | ETF | 110.23 | 110.31 | 109.93 | 110.2 | 4708900.0 |
| 2004-03-23 10:30:00 | SPY | ETF | 110.2 | 110.29 | 109.86 | 110.24 | 2791900.0 |
| 2004-03-23 11:00:00 | SPY | ETF | 110.25 | 110.25 | 109.84 | 109.95 | 2244400.0 |
| 2004-03-23 11:30:00 | SPY | ETF | 109.94 | 110.0 | 109.65 | 109.92 | 3939000.0 |
| 2004-03-23 12:00:00 | SPY | ETF | 109.92 | 109.97 | 109.43 | 109.56 | 3114700.0 |
| 2004-03-23 12:30:00 | SPY | ETF | 109.56 | 109.75 | 109.36 | 109.7 | 1935800.0 |
| 2004-03-23 13:00:00 | SPY | ETF | 109.69 | 109.77 | 109.57 | 109.67 | 1021500.0 |
| 2004-03-23 13:30:00 | SPY | ETF | 109.66 | 110.17 | 109.58 | 110.03 | 3404300.0 |
| 2004-03-23 14:00:00 | SPY | ETF | 110.03 | 110.22 | 109.9 | 110.1 | 2740400.0 |
| 2004-03-23 14:30:00 | SPY | ETF | 110.13 | 110.38 | 110.07 | 110.27 | 2122200.0 |
| 2004-03-23 15:00:00 | SPY | ETF | 110.27 | 110.4 | 110.05 | 110.28 | 1959200.0 |
| 2004-03-23 15:30:00 | SPY | ETF | 110.25 | 110.38 | 109.63 | 109.69 | 3570400.0 |
| 2004-03-23 16:00:00 | SPY | ETF | 109.65 | 109.69 | 109.43 | 109.5 | 1897300.0 |
| 2004-03-23 16:30:00 | SPY | ETF | 109.53 | 109.67 | 109.25 | 109.3 | 377600.0 |
| 2004-03-23 17:00:00 | SPY | ETF | 109.3 | 109.41 | 109.27 | 109.38 | 100300.0 |
| 2004-03-23 17:30:00 | SPY | ETF | 109.38 | 109.48 | 109.38 | 109.4 | 2200.0 |
| 2004-03-23 18:00:00 | SPY | ETF | 109.35 | 109.35 | 109.3 | 109.3 | 18900.0 |
| 2004-03-23 18:30:00 | SPY | ETF | 109.3 | 109.3 | 109.23 | 109.25 | 600.0 |
| 2004-03-23 19:00:00 | SPY | ETF | 109.2 | 109.28 | 109.2 | 109.27 | 7800.0 |
| 2004-03-23 19:30:00 | SPY | ETF | 109.3 | 109.3 | 109.24 | 109.24 | 6800.0 |
| 2004-03-23 08:00:00 | QQQ | ETF | 34.54 | 34.57 | 34.51 | 34.57 | 206900.0 |
| 2004-03-23 08:30:00 | QQQ | ETF | 34.57 | 34.62 | 34.56 | 34.61 | 177400.0 |
| 2004-03-23 09:00:00 | QQQ | ETF | 34.6 | 34.6 | 34.57 | 34.6 | 232600.0 |
| 2004-03-23 09:30:00 | QQQ | ETF | 34.59 | 34.65 | 34.478 | 34.55 | 11493400.0 |
| 2004-03-23 10:00:00 | QQQ | ETF | 34.56 | 34.58 | 34.45 | 34.54 | 9270500.0 |
| 2004-03-23 10:30:00 | QQQ | ETF | 34.536 | 34.55 | 34.355 | 34.47 | 7636700.0 |
| 2004-03-23 11:00:00 | QQQ | ETF | 34.48 | 34.48 | 34.23 | 34.27 | 5725300.0 |
| 2004-03-23 11:30:00 | QQQ | ETF | 34.264 | 34.311 | 34.111 | 34.29 | 9213600.0 |
| 2004-03-23 12:00:00 | QQQ | ETF | 34.283 | 34.29 | 34.05 | 34.111 | 8890700.0 |
| 2004-03-23 12:30:00 | QQQ | ETF | 34.11 | 34.22 | 34.01 | 34.208 | 10149700.0 |
| 2004-03-23 13:00:00 | QQQ | ETF | 34.208 | 34.24 | 34.12 | 34.15 | 4371000.0 |
| 2004-03-23 13:30:00 | QQQ | ETF | 34.149 | 34.37 | 34.149 | 34.32 | 9469200.0 |
| 2004-03-23 14:00:00 | QQQ | ETF | 34.31 | 34.42 | 34.27 | 34.34 | 5405700.0 |
| 2004-03-23 14:30:00 | QQQ | ETF | 34.34 | 34.5 | 34.31 | 34.466 | 6288500.0 |
| 2004-03-23 15:00:00 | QQQ | ETF | 34.461 | 34.5 | 34.34 | 34.45 | 6338900.0 |
| 2004-03-23 15:30:00 | QQQ | ETF | 34.45 | 34.497 | 34.1 | 34.12 | 12114600.0 |
| 2004-03-23 16:00:00 | QQQ | ETF | 34.12 | 34.14 | 34.01 | 34.05 | 4532800.0 |
| 2004-03-23 16:30:00 | QQQ | ETF | 34.048 | 34.1 | 33.97 | 33.97 | 444600.0 |
| 2004-03-23 17:00:00 | QQQ | ETF | 33.98 | 34.04 | 33.97 | 34.01 | 72000.0 |
| 2004-03-23 17:30:00 | QQQ | ETF | 34.03 | 34.05 | 34.03 | 34.03 | 64500.0 |
| 2004-03-23 18:00:00 | QQQ | ETF | 34.03 | 34.04 | 33.98 | 34.0 | 81900.0 |
| 2004-03-23 18:30:00 | QQQ | ETF | 33.99 | 33.99 | 33.97 | 33.97 | 13900.0 |
| 2004-03-23 19:00:00 | QQQ | ETF | 34.0 | 34.0 | 33.98 | 33.99 | 5200.0 |
| 2004-03-23 19:30:00 | QQQ | ETF | 33.99 | 34.01 | 33.98 | 33.98 | 5600.0 |
| 2004-03-23 09:00:00 | IWM | ETF | 56.15 | 56.225 | 56.15 | 56.215 | 15000.0 |
| 2004-03-23 09:30:00 | IWM | ETF | 56.16 | 56.5 | 56.025 | 56.42 | 2831200.0 |
> showing 50 of 1,174 rows — these rows as CSV