PREVIEW / etf_30min / 2003-10-20
file: by_date/etf_30min/2003/2003-10-20.parquet size: 26 KB rows: 799
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-20 08:00:00 | SPY | ETF | 104.46 | 104.48 | 104.33 | 104.44 | 24500.0 |
| 2003-10-20 08:30:00 | SPY | ETF | 104.44 | 104.52 | 104.44 | 104.5 | 2700.0 |
| 2003-10-20 09:00:00 | SPY | ETF | 104.49 | 104.51 | 104.41 | 104.42 | 71400.0 |
| 2003-10-20 09:30:00 | SPY | ETF | 104.447 | 104.66 | 104.278 | 104.59 | 3651500.0 |
| 2003-10-20 10:00:00 | SPY | ETF | 104.63 | 104.68 | 104.08 | 104.1 | 4056800.0 |
| 2003-10-20 10:30:00 | SPY | ETF | 104.13 | 104.26 | 103.94 | 104.22 | 3036100.0 |
| 2003-10-20 11:00:00 | SPY | ETF | 104.21 | 104.33 | 104.11 | 104.19 | 1494700.0 |
| 2003-10-20 11:30:00 | SPY | ETF | 104.16 | 104.44 | 104.1 | 104.38 | 786000.0 |
| 2003-10-20 12:00:00 | SPY | ETF | 104.39 | 104.54 | 104.34 | 104.4 | 857800.0 |
| 2003-10-20 12:30:00 | SPY | ETF | 104.4 | 104.54 | 104.38 | 104.47 | 528900.0 |
| 2003-10-20 13:00:00 | SPY | ETF | 104.44 | 104.62 | 104.35 | 104.47 | 939700.0 |
| 2003-10-20 13:30:00 | SPY | ETF | 104.47 | 104.48 | 104.22 | 104.3 | 877100.0 |
| 2003-10-20 14:00:00 | SPY | ETF | 104.32 | 104.43 | 104.17 | 104.27 | 633000.0 |
| 2003-10-20 14:30:00 | SPY | ETF | 104.25 | 104.41 | 104.14 | 104.378 | 2723000.0 |
| 2003-10-20 15:00:00 | SPY | ETF | 104.37 | 104.541 | 104.37 | 104.52 | 1422900.0 |
| 2003-10-20 15:30:00 | SPY | ETF | 104.54 | 104.825 | 104.53 | 104.8 | 3253600.0 |
| 2003-10-20 16:00:00 | SPY | ETF | 104.78 | 105.08 | 104.73 | 105.0 | 1541800.0 |
| 2003-10-20 16:30:00 | SPY | ETF | 105.01 | 105.38 | 105.01 | 105.32 | 572700.0 |
| 2003-10-20 17:00:00 | SPY | ETF | 105.3 | 105.43 | 105.21 | 105.39 | 341000.0 |
| 2003-10-20 17:30:00 | SPY | ETF | 105.35 | 105.4 | 105.33 | 105.35 | 4500.0 |
| 2003-10-20 18:00:00 | SPY | ETF | 105.33 | 105.374 | 105.33 | 105.35 | 2300.0 |
| 2003-10-20 18:30:00 | SPY | ETF | 105.32 | 105.35 | 105.32 | 105.33 | 12300.0 |
| 2003-10-20 19:00:00 | SPY | ETF | 105.3 | 105.33 | 105.28 | 105.28 | 400.0 |
| 2003-10-20 19:30:00 | SPY | ETF | 105.3 | 105.3 | 105.25 | 105.26 | 2400.0 |
| 2003-10-20 08:00:00 | QQQ | ETF | 34.73 | 34.73 | 34.6 | 34.64 | 228000.0 |
| 2003-10-20 08:30:00 | QQQ | ETF | 34.65 | 34.68 | 34.64 | 34.68 | 108300.0 |
| 2003-10-20 09:00:00 | QQQ | ETF | 34.66 | 34.68 | 34.64 | 34.66 | 131200.0 |
| 2003-10-20 09:30:00 | QQQ | ETF | 34.65 | 34.84 | 34.65 | 34.81 | 9971600.0 |
| 2003-10-20 10:00:00 | QQQ | ETF | 34.82 | 34.86 | 34.53 | 34.579 | 9535400.0 |
| 2003-10-20 10:30:00 | QQQ | ETF | 34.58 | 34.73 | 34.5 | 34.67 | 4928400.0 |
| 2003-10-20 11:00:00 | QQQ | ETF | 34.68 | 34.74 | 34.63 | 34.66 | 3554200.0 |
| 2003-10-20 11:30:00 | QQQ | ETF | 34.66 | 34.81 | 34.61 | 34.79 | 3151800.0 |
| 2003-10-20 12:00:00 | QQQ | ETF | 34.78 | 34.958 | 34.75 | 34.911 | 5616600.0 |
| 2003-10-20 12:30:00 | QQQ | ETF | 34.91 | 34.98 | 34.9 | 34.94 | 3209300.0 |
| 2003-10-20 13:00:00 | QQQ | ETF | 34.936 | 35.0 | 34.83 | 34.88 | 4347400.0 |
| 2003-10-20 13:30:00 | QQQ | ETF | 34.87 | 34.89 | 34.71 | 34.8 | 2829700.0 |
| 2003-10-20 14:00:00 | QQQ | ETF | 34.8 | 34.9 | 34.77 | 34.8 | 1796300.0 |
| 2003-10-20 14:30:00 | QQQ | ETF | 34.8 | 34.85 | 34.73 | 34.83 | 3554300.0 |
| 2003-10-20 15:00:00 | QQQ | ETF | 34.82 | 34.9 | 34.82 | 34.89 | 3769000.0 |
| 2003-10-20 15:30:00 | QQQ | ETF | 34.88 | 35.02 | 34.87 | 34.987 | 7490200.0 |
| 2003-10-20 16:00:00 | QQQ | ETF | 34.98 | 35.09 | 34.96 | 35.05 | 5144000.0 |
| 2003-10-20 16:30:00 | QQQ | ETF | 35.05 | 35.31 | 35.04 | 35.31 | 3434500.0 |
| 2003-10-20 17:00:00 | QQQ | ETF | 35.31 | 35.384 | 35.28 | 35.38 | 1009700.0 |
| 2003-10-20 17:30:00 | QQQ | ETF | 35.38 | 35.38 | 35.3 | 35.31 | 540000.0 |
| 2003-10-20 18:00:00 | QQQ | ETF | 35.32 | 35.35 | 35.32 | 35.32 | 51300.0 |
| 2003-10-20 18:30:00 | QQQ | ETF | 35.32 | 35.34 | 35.3 | 35.33 | 35300.0 |
| 2003-10-20 19:00:00 | QQQ | ETF | 35.3 | 35.33 | 35.3 | 35.31 | 6700.0 |
| 2003-10-20 19:30:00 | QQQ | ETF | 35.31 | 35.31 | 35.28 | 35.28 | 18500.0 |
| 2003-10-20 08:30:00 | IWM | ETF | 51.89 | 51.89 | 51.89 | 51.89 | 800.0 |
| 2003-10-20 09:30:00 | IWM | ETF | 51.97 | 52.275 | 51.92 | 52.25 | 977400.0 |
> showing 50 of 799 rows — these rows as CSV