PREVIEW / etf_30min / 2003-10-31
file: by_date/etf_30min/2003/2003-10-31.parquet size: 25 KB rows: 785
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-31 08:00:00 | SPY | ETF | 105.3 | 105.55 | 105.3 | 105.55 | 21700.0 |
| 2003-10-31 08:30:00 | SPY | ETF | 105.48 | 105.55 | 105.4 | 105.43 | 35100.0 |
| 2003-10-31 09:00:00 | SPY | ETF | 105.4 | 105.44 | 105.38 | 105.42 | 40800.0 |
| 2003-10-31 09:30:00 | SPY | ETF | 105.41 | 105.71 | 105.4 | 105.58 | 3752400.0 |
| 2003-10-31 10:00:00 | SPY | ETF | 105.59 | 105.74 | 105.25 | 105.35 | 3273300.0 |
| 2003-10-31 10:30:00 | SPY | ETF | 105.38 | 105.59 | 105.22 | 105.54 | 3453100.0 |
| 2003-10-31 11:00:00 | SPY | ETF | 105.54 | 105.57 | 105.4 | 105.46 | 841100.0 |
| 2003-10-31 11:30:00 | SPY | ETF | 105.45 | 105.54 | 105.37 | 105.53 | 1136300.0 |
| 2003-10-31 12:00:00 | SPY | ETF | 105.52 | 105.65 | 105.47 | 105.52 | 545500.0 |
| 2003-10-31 12:30:00 | SPY | ETF | 105.51 | 105.55 | 105.41 | 105.48 | 324000.0 |
| 2003-10-31 13:00:00 | SPY | ETF | 105.5 | 105.57 | 105.44 | 105.48 | 454100.0 |
| 2003-10-31 13:30:00 | SPY | ETF | 105.47 | 105.51 | 105.26 | 105.33 | 687100.0 |
| 2003-10-31 14:00:00 | SPY | ETF | 105.34 | 105.63 | 105.34 | 105.63 | 732400.0 |
| 2003-10-31 14:30:00 | SPY | ETF | 105.63 | 105.7 | 105.37 | 105.39 | 897000.0 |
| 2003-10-31 15:00:00 | SPY | ETF | 105.41 | 105.68 | 105.37 | 105.64 | 856200.0 |
| 2003-10-31 15:30:00 | SPY | ETF | 105.65 | 105.69 | 105.37 | 105.42 | 2610600.0 |
| 2003-10-31 16:00:00 | SPY | ETF | 105.42 | 105.5 | 105.26 | 105.32 | 2068000.0 |
| 2003-10-31 16:30:00 | SPY | ETF | 105.39 | 105.39 | 105.25 | 105.3 | 32700.0 |
| 2003-10-31 17:00:00 | SPY | ETF | 105.25 | 105.3 | 105.25 | 105.26 | 7000.0 |
| 2003-10-31 17:30:00 | SPY | ETF | 105.27 | 105.3 | 105.27 | 105.3 | 500.0 |
| 2003-10-31 18:30:00 | SPY | ETF | 105.33 | 105.33 | 105.33 | 105.33 | 400.0 |
| 2003-10-31 19:00:00 | SPY | ETF | 105.35 | 105.35 | 105.35 | 105.35 | 600.0 |
| 2003-10-31 08:00:00 | QQQ | ETF | 35.36 | 35.53 | 35.36 | 35.52 | 104700.0 |
| 2003-10-31 08:30:00 | QQQ | ETF | 35.52 | 35.53 | 35.45 | 35.46 | 68700.0 |
| 2003-10-31 09:00:00 | QQQ | ETF | 35.46 | 35.5 | 35.45 | 35.45 | 59100.0 |
| 2003-10-31 09:30:00 | QQQ | ETF | 35.44 | 35.48 | 35.27 | 35.392 | 6548400.0 |
| 2003-10-31 10:00:00 | QQQ | ETF | 35.38 | 35.47 | 35.17 | 35.22 | 5954100.0 |
| 2003-10-31 10:30:00 | QQQ | ETF | 35.21 | 35.29 | 35.06 | 35.27 | 6448900.0 |
| 2003-10-31 11:00:00 | QQQ | ETF | 35.261 | 35.28 | 35.178 | 35.2 | 2667800.0 |
| 2003-10-31 11:30:00 | QQQ | ETF | 35.212 | 35.28 | 35.16 | 35.27 | 1522800.0 |
| 2003-10-31 12:00:00 | QQQ | ETF | 35.27 | 35.33 | 35.24 | 35.26 | 2308600.0 |
| 2003-10-31 12:30:00 | QQQ | ETF | 35.27 | 35.27 | 35.13 | 35.21 | 1692400.0 |
| 2003-10-31 13:00:00 | QQQ | ETF | 35.21 | 35.25 | 35.17 | 35.19 | 1634900.0 |
| 2003-10-31 13:30:00 | QQQ | ETF | 35.199 | 35.22 | 35.1 | 35.1 | 2334300.0 |
| 2003-10-31 14:00:00 | QQQ | ETF | 35.12 | 35.267 | 35.1 | 35.26 | 3813700.0 |
| 2003-10-31 14:30:00 | QQQ | ETF | 35.25 | 35.32 | 35.19 | 35.2 | 2795300.0 |
| 2003-10-31 15:00:00 | QQQ | ETF | 35.208 | 35.37 | 35.2 | 35.34 | 3310200.0 |
| 2003-10-31 15:30:00 | QQQ | ETF | 35.34 | 35.36 | 35.15 | 35.18 | 5975500.0 |
| 2003-10-31 16:00:00 | QQQ | ETF | 35.16 | 35.26 | 35.14 | 35.21 | 2849000.0 |
| 2003-10-31 16:30:00 | QQQ | ETF | 35.21 | 35.23 | 35.17 | 35.18 | 26200.0 |
| 2003-10-31 17:00:00 | QQQ | ETF | 35.16 | 35.2 | 35.114 | 35.18 | 27200.0 |
| 2003-10-31 17:30:00 | QQQ | ETF | 35.19 | 35.2 | 35.18 | 35.2 | 4800.0 |
| 2003-10-31 18:00:00 | QQQ | ETF | 35.2 | 35.21 | 35.18 | 35.2 | 13000.0 |
| 2003-10-31 18:30:00 | QQQ | ETF | 35.21 | 35.21 | 35.21 | 35.21 | 500.0 |
| 2003-10-31 19:00:00 | QQQ | ETF | 35.2 | 35.2 | 35.16 | 35.2 | 3000.0 |
| 2003-10-31 19:30:00 | QQQ | ETF | 35.2 | 35.2 | 35.2 | 35.2 | 1500.0 |
| 2003-10-31 09:30:00 | IWM | ETF | 53.135 | 53.28 | 53.07 | 53.135 | 822400.0 |
| 2003-10-31 10:00:00 | IWM | ETF | 53.138 | 53.253 | 52.835 | 52.93 | 577200.0 |
| 2003-10-31 10:30:00 | IWM | ETF | 52.933 | 53.0 | 52.825 | 52.98 | 113800.0 |
| 2003-10-31 11:00:00 | IWM | ETF | 52.99 | 52.99 | 52.89 | 52.925 | 106400.0 |
> showing 50 of 785 rows — these rows as CSV