PREVIEW / etf_30min / 2003-10-23
file: by_date/etf_30min/2003/2003-10-23.parquet size: 26 KB rows: 803
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-23 08:00:00 | SPY | ETF | 102.8 | 102.8 | 102.63 | 102.7 | 185300.0 |
| 2003-10-23 08:30:00 | SPY | ETF | 102.78 | 102.93 | 102.75 | 102.86 | 33600.0 |
| 2003-10-23 09:00:00 | SPY | ETF | 102.86 | 102.94 | 102.82 | 102.9 | 31200.0 |
| 2003-10-23 09:30:00 | SPY | ETF | 102.89 | 103.53 | 102.84 | 103.5 | 8077300.0 |
| 2003-10-23 10:00:00 | SPY | ETF | 103.486 | 103.69 | 103.16 | 103.57 | 5683900.0 |
| 2003-10-23 10:30:00 | SPY | ETF | 103.6 | 103.65 | 103.19 | 103.29 | 3267800.0 |
| 2003-10-23 11:00:00 | SPY | ETF | 103.26 | 103.33 | 102.97 | 103.04 | 2688000.0 |
| 2003-10-23 11:30:00 | SPY | ETF | 103.06 | 103.35 | 103.0 | 103.28 | 1455600.0 |
| 2003-10-23 12:00:00 | SPY | ETF | 103.28 | 103.521 | 103.18 | 103.49 | 1808800.0 |
| 2003-10-23 12:30:00 | SPY | ETF | 103.5 | 103.62 | 103.32 | 103.46 | 1250400.0 |
| 2003-10-23 13:00:00 | SPY | ETF | 103.47 | 103.63 | 103.36 | 103.6 | 1289500.0 |
| 2003-10-23 13:30:00 | SPY | ETF | 103.61 | 103.79 | 103.46 | 103.73 | 2885900.0 |
| 2003-10-23 14:00:00 | SPY | ETF | 103.72 | 103.95 | 103.69 | 103.82 | 2211200.0 |
| 2003-10-23 14:30:00 | SPY | ETF | 103.83 | 103.89 | 103.43 | 103.48 | 3177900.0 |
| 2003-10-23 15:00:00 | SPY | ETF | 103.49 | 103.69 | 103.33 | 103.62 | 1883000.0 |
| 2003-10-23 15:30:00 | SPY | ETF | 103.632 | 103.756 | 103.4 | 103.74 | 1963900.0 |
| 2003-10-23 16:00:00 | SPY | ETF | 103.74 | 103.85 | 103.34 | 103.42 | 2088500.0 |
| 2003-10-23 16:30:00 | SPY | ETF | 103.35 | 103.36 | 103.0 | 103.07 | 672500.0 |
| 2003-10-23 17:00:00 | SPY | ETF | 103.09 | 103.2 | 103.09 | 103.16 | 54200.0 |
| 2003-10-23 17:30:00 | SPY | ETF | 103.15 | 103.19 | 103.05 | 103.15 | 122200.0 |
| 2003-10-23 18:00:00 | SPY | ETF | 103.14 | 103.14 | 102.42 | 102.67 | 443900.0 |
| 2003-10-23 18:30:00 | SPY | ETF | 102.62 | 102.7 | 102.62 | 102.66 | 27200.0 |
| 2003-10-23 19:00:00 | SPY | ETF | 102.7 | 102.7 | 102.64 | 102.68 | 17700.0 |
| 2003-10-23 19:30:00 | SPY | ETF | 102.7 | 102.7 | 102.7 | 102.7 | 200.0 |
| 2003-10-23 08:00:00 | QQQ | ETF | 34.15 | 34.15 | 33.99 | 34.05 | 307600.0 |
| 2003-10-23 08:30:00 | QQQ | ETF | 34.06 | 34.15 | 34.04 | 34.13 | 225700.0 |
| 2003-10-23 09:00:00 | QQQ | ETF | 34.12 | 34.2 | 34.11 | 34.14 | 159700.0 |
| 2003-10-23 09:30:00 | QQQ | ETF | 34.15 | 34.43 | 34.05 | 34.39 | 13484000.0 |
| 2003-10-23 10:00:00 | QQQ | ETF | 34.39 | 34.507 | 34.16 | 34.43 | 11676900.0 |
| 2003-10-23 10:30:00 | QQQ | ETF | 34.468 | 34.48 | 34.25 | 34.28 | 6011000.0 |
| 2003-10-23 11:00:00 | QQQ | ETF | 34.28 | 34.34 | 34.11 | 34.12 | 6038500.0 |
| 2003-10-23 11:30:00 | QQQ | ETF | 34.13 | 34.23 | 34.1 | 34.21 | 5082900.0 |
| 2003-10-23 12:00:00 | QQQ | ETF | 34.2 | 34.35 | 34.15 | 34.33 | 4531400.0 |
| 2003-10-23 12:30:00 | QQQ | ETF | 34.33 | 34.36 | 34.23 | 34.31 | 3699600.0 |
| 2003-10-23 13:00:00 | QQQ | ETF | 34.31 | 34.39 | 34.26 | 34.36 | 2600900.0 |
| 2003-10-23 13:30:00 | QQQ | ETF | 34.37 | 34.42 | 34.3 | 34.39 | 3599900.0 |
| 2003-10-23 14:00:00 | QQQ | ETF | 34.39 | 34.46 | 34.35 | 34.38 | 3511600.0 |
| 2003-10-23 14:30:00 | QQQ | ETF | 34.38 | 34.41 | 34.23 | 34.28 | 3991300.0 |
| 2003-10-23 15:00:00 | QQQ | ETF | 34.29 | 34.36 | 34.2 | 34.295 | 4772900.0 |
| 2003-10-23 15:30:00 | QQQ | ETF | 34.299 | 34.35 | 34.21 | 34.34 | 5856600.0 |
| 2003-10-23 16:00:00 | QQQ | ETF | 34.34 | 34.44 | 34.15 | 34.16 | 5832200.0 |
| 2003-10-23 16:30:00 | QQQ | ETF | 34.16 | 34.179 | 33.94 | 33.97 | 3171600.0 |
| 2003-10-23 17:00:00 | QQQ | ETF | 33.962 | 34.01 | 33.95 | 34.01 | 1373500.0 |
| 2003-10-23 17:30:00 | QQQ | ETF | 34.01 | 34.02 | 33.95 | 33.95 | 178800.0 |
| 2003-10-23 18:00:00 | QQQ | ETF | 33.96 | 33.97 | 33.61 | 33.74 | 3777000.0 |
| 2003-10-23 18:30:00 | QQQ | ETF | 33.74 | 33.78 | 33.72 | 33.75 | 52900.0 |
| 2003-10-23 19:00:00 | QQQ | ETF | 33.76 | 33.77 | 33.72 | 33.74 | 47500.0 |
| 2003-10-23 19:30:00 | QQQ | ETF | 33.75 | 33.76 | 33.72 | 33.76 | 30400.0 |
| 2003-10-23 20:00:00 | QQQ | ETF | 33.75 | 33.75 | 33.75 | 33.75 | 100.0 |
| 2003-10-23 08:30:00 | IWM | ETF | 50.745 | 50.745 | 50.745 | 50.745 | 400.0 |
> showing 50 of 803 rows — these rows as CSV