PREVIEW / etf_30min / 2003-12-29
file: by_date/etf_30min/2003/2003-12-29.parquet size: 27 KB rows: 883
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-12-29 08:00:00 | SPY | ETF | 110.11 | 110.11 | 110.05 | 110.08 | 1500.0 |
| 2003-12-29 08:30:00 | SPY | ETF | 110.08 | 110.09 | 110.05 | 110.07 | 52100.0 |
| 2003-12-29 09:00:00 | SPY | ETF | 110.04 | 110.1 | 110.04 | 110.07 | 28900.0 |
| 2003-12-29 09:30:00 | SPY | ETF | 110.1 | 110.34 | 110.09 | 110.34 | 2732000.0 |
| 2003-12-29 10:00:00 | SPY | ETF | 110.33 | 110.54 | 110.33 | 110.42 | 2355900.0 |
| 2003-12-29 10:30:00 | SPY | ETF | 110.43 | 110.48 | 110.23 | 110.33 | 1831400.0 |
| 2003-12-29 11:00:00 | SPY | ETF | 110.33 | 110.43 | 110.11 | 110.39 | 2316100.0 |
| 2003-12-29 11:30:00 | SPY | ETF | 110.39 | 110.45 | 110.33 | 110.44 | 730900.0 |
| 2003-12-29 12:00:00 | SPY | ETF | 110.43 | 110.45 | 110.36 | 110.42 | 411800.0 |
| 2003-12-29 12:30:00 | SPY | ETF | 110.45 | 110.49 | 110.39 | 110.44 | 716800.0 |
| 2003-12-29 13:00:00 | SPY | ETF | 110.4 | 110.7 | 110.39 | 110.62 | 648000.0 |
| 2003-12-29 13:30:00 | SPY | ETF | 110.61 | 110.68 | 110.52 | 110.54 | 1127500.0 |
| 2003-12-29 14:00:00 | SPY | ETF | 110.57 | 110.77 | 110.54 | 110.66 | 824300.0 |
| 2003-12-29 14:30:00 | SPY | ETF | 110.65 | 110.7 | 110.58 | 110.64 | 615300.0 |
| 2003-12-29 15:00:00 | SPY | ETF | 110.62 | 110.91 | 110.61 | 110.89 | 1001200.0 |
| 2003-12-29 15:30:00 | SPY | ETF | 110.9 | 111.17 | 110.88 | 111.15 | 2424700.0 |
| 2003-12-29 16:00:00 | SPY | ETF | 111.15 | 111.27 | 111.11 | 111.2 | 1639200.0 |
| 2003-12-29 16:30:00 | SPY | ETF | 111.17 | 111.17 | 111.07 | 111.07 | 189200.0 |
| 2003-12-29 17:00:00 | SPY | ETF | 111.08 | 111.12 | 111.06 | 111.12 | 21300.0 |
| 2003-12-29 17:30:00 | SPY | ETF | 111.11 | 111.15 | 111.11 | 111.15 | 10800.0 |
| 2003-12-29 18:00:00 | SPY | ETF | 111.13 | 111.14 | 111.1 | 111.1 | 39600.0 |
| 2003-12-29 18:30:00 | SPY | ETF | 111.08 | 111.08 | 111.08 | 111.08 | 500.0 |
| 2003-12-29 19:30:00 | SPY | ETF | 111.12 | 111.12 | 111.12 | 111.12 | 400.0 |
| 2003-12-29 08:00:00 | QQQ | ETF | 36.04 | 36.08 | 36.04 | 36.04 | 27400.0 |
| 2003-12-29 08:30:00 | QQQ | ETF | 36.04 | 36.06 | 36.02 | 36.03 | 39700.0 |
| 2003-12-29 09:00:00 | QQQ | ETF | 36.04 | 36.05 | 36.01 | 36.02 | 25600.0 |
| 2003-12-29 09:30:00 | QQQ | ETF | 36.03 | 36.16 | 36.02 | 36.156 | 6171300.0 |
| 2003-12-29 10:00:00 | QQQ | ETF | 36.155 | 36.26 | 36.12 | 36.2 | 9221000.0 |
| 2003-12-29 10:30:00 | QQQ | ETF | 36.2 | 36.22 | 36.1 | 36.15 | 3870600.0 |
| 2003-12-29 11:00:00 | QQQ | ETF | 36.14 | 36.21 | 36.07 | 36.2 | 3072100.0 |
| 2003-12-29 11:30:00 | QQQ | ETF | 36.2 | 36.21 | 36.15 | 36.19 | 2272900.0 |
| 2003-12-29 12:00:00 | QQQ | ETF | 36.194 | 36.21 | 36.15 | 36.2 | 1606000.0 |
| 2003-12-29 12:30:00 | QQQ | ETF | 36.2 | 36.23 | 36.15 | 36.16 | 1616600.0 |
| 2003-12-29 13:00:00 | QQQ | ETF | 36.15 | 36.27 | 36.15 | 36.244 | 2817900.0 |
| 2003-12-29 13:30:00 | QQQ | ETF | 36.24 | 36.26 | 36.2 | 36.22 | 2441400.0 |
| 2003-12-29 14:00:00 | QQQ | ETF | 36.23 | 36.3 | 36.21 | 36.27 | 3728600.0 |
| 2003-12-29 14:30:00 | QQQ | ETF | 36.26 | 36.29 | 36.23 | 36.27 | 1232600.0 |
| 2003-12-29 15:00:00 | QQQ | ETF | 36.27 | 36.4 | 36.26 | 36.397 | 7306000.0 |
| 2003-12-29 15:30:00 | QQQ | ETF | 36.393 | 36.51 | 36.36 | 36.49 | 9948200.0 |
| 2003-12-29 16:00:00 | QQQ | ETF | 36.49 | 36.53 | 36.42 | 36.47 | 4391600.0 |
| 2003-12-29 16:30:00 | QQQ | ETF | 36.47 | 36.49 | 36.4 | 36.45 | 501600.0 |
| 2003-12-29 17:00:00 | QQQ | ETF | 36.46 | 36.481 | 36.44 | 36.46 | 31400.0 |
| 2003-12-29 17:30:00 | QQQ | ETF | 36.46 | 36.47 | 36.45 | 36.47 | 46300.0 |
| 2003-12-29 18:00:00 | QQQ | ETF | 36.47 | 36.49 | 36.47 | 36.48 | 12000.0 |
| 2003-12-29 18:30:00 | QQQ | ETF | 36.47 | 36.49 | 36.45 | 36.45 | 3500.0 |
| 2003-12-29 19:30:00 | QQQ | ETF | 36.45 | 36.46 | 36.45 | 36.45 | 3900.0 |
| 2003-12-29 09:00:00 | IWM | ETF | 55.39 | 55.39 | 55.39 | 55.39 | 4000.0 |
| 2003-12-29 09:30:00 | IWM | ETF | 55.48 | 55.845 | 55.455 | 55.825 | 763400.0 |
| 2003-12-29 10:00:00 | IWM | ETF | 55.855 | 56.0 | 55.825 | 55.9 | 240400.0 |
| 2003-12-29 10:30:00 | IWM | ETF | 55.89 | 55.935 | 55.855 | 55.8865 | 101800.0 |
> showing 50 of 883 rows — these rows as CSV