PREVIEW / etf_30min / 2003-10-13
file: by_date/etf_30min/2003/2003-10-13.parquet size: 25 KB rows: 791
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-13 08:00:00 | SPY | ETF | 104.93 | 105.03 | 104.91 | 104.95 | 70100.0 |
| 2003-10-13 08:30:00 | SPY | ETF | 104.93 | 104.96 | 104.9 | 104.93 | 32900.0 |
| 2003-10-13 09:00:00 | SPY | ETF | 104.89 | 104.89 | 104.74 | 104.74 | 139200.0 |
| 2003-10-13 09:30:00 | SPY | ETF | 104.715 | 104.87 | 104.7 | 104.82 | 3102800.0 |
| 2003-10-13 10:00:00 | SPY | ETF | 104.828 | 105.27 | 104.81 | 105.23 | 3088800.0 |
| 2003-10-13 10:30:00 | SPY | ETF | 105.25 | 105.29 | 105.08 | 105.14 | 1602800.0 |
| 2003-10-13 11:00:00 | SPY | ETF | 105.15 | 105.16 | 104.97 | 105.05 | 1304800.0 |
| 2003-10-13 11:30:00 | SPY | ETF | 105.0 | 105.18 | 104.98 | 105.1 | 1234700.0 |
| 2003-10-13 12:00:00 | SPY | ETF | 105.14 | 105.15 | 105.03 | 105.07 | 617600.0 |
| 2003-10-13 12:30:00 | SPY | ETF | 105.07 | 105.15 | 104.87 | 104.92 | 1444100.0 |
| 2003-10-13 13:00:00 | SPY | ETF | 104.97 | 104.99 | 104.59 | 104.61 | 2234900.0 |
| 2003-10-13 13:30:00 | SPY | ETF | 104.63 | 104.79 | 104.51 | 104.77 | 2204600.0 |
| 2003-10-13 14:00:00 | SPY | ETF | 104.77 | 104.84 | 104.66 | 104.82 | 815800.0 |
| 2003-10-13 14:30:00 | SPY | ETF | 104.78 | 104.84 | 104.67 | 104.7 | 839100.0 |
| 2003-10-13 15:00:00 | SPY | ETF | 104.7 | 104.94 | 104.53 | 104.91 | 1365700.0 |
| 2003-10-13 15:30:00 | SPY | ETF | 104.91 | 104.93 | 104.7 | 104.86 | 1608500.0 |
| 2003-10-13 16:00:00 | SPY | ETF | 104.89 | 104.95 | 104.84 | 104.92 | 702400.0 |
| 2003-10-13 16:30:00 | SPY | ETF | 104.93 | 104.96 | 104.91 | 104.931 | 98000.0 |
| 2003-10-13 17:00:00 | SPY | ETF | 104.95 | 104.95 | 104.92 | 104.92 | 1600.0 |
| 2003-10-13 17:30:00 | SPY | ETF | 104.91 | 104.94 | 104.91 | 104.94 | 1800.0 |
| 2003-10-13 18:00:00 | SPY | ETF | 104.95 | 104.96 | 104.94 | 104.95 | 2000.0 |
| 2003-10-13 18:30:00 | SPY | ETF | 104.95 | 104.95 | 104.95 | 104.95 | 500.0 |
| 2003-10-13 19:00:00 | SPY | ETF | 104.99 | 104.99 | 104.99 | 104.99 | 100.0 |
| 2003-10-13 19:30:00 | SPY | ETF | 105.0 | 105.0 | 105.0 | 105.0 | 200.0 |
| 2003-10-13 08:00:00 | QQQ | ETF | 35.23 | 35.23 | 35.19 | 35.19 | 66500.0 |
| 2003-10-13 08:30:00 | QQQ | ETF | 35.19 | 35.22 | 35.18 | 35.2 | 46900.0 |
| 2003-10-13 09:00:00 | QQQ | ETF | 35.19 | 35.2 | 35.13 | 35.13 | 46200.0 |
| 2003-10-13 09:30:00 | QQQ | ETF | 35.14 | 35.22 | 35.09 | 35.18 | 8789800.0 |
| 2003-10-13 10:00:00 | QQQ | ETF | 35.17 | 35.37 | 35.16 | 35.35 | 8220700.0 |
| 2003-10-13 10:30:00 | QQQ | ETF | 35.35 | 35.36 | 35.24 | 35.284 | 3568500.0 |
| 2003-10-13 11:00:00 | QQQ | ETF | 35.28 | 35.29 | 35.15 | 35.17 | 2957000.0 |
| 2003-10-13 11:30:00 | QQQ | ETF | 35.17 | 35.27 | 35.17 | 35.255 | 1973200.0 |
| 2003-10-13 12:00:00 | QQQ | ETF | 35.26 | 35.27 | 35.21 | 35.23 | 2912900.0 |
| 2003-10-13 12:30:00 | QQQ | ETF | 35.23 | 35.26 | 35.1 | 35.14 | 2934900.0 |
| 2003-10-13 13:00:00 | QQQ | ETF | 35.13 | 35.18 | 34.96 | 35.02 | 5098600.0 |
| 2003-10-13 13:30:00 | QQQ | ETF | 35.02 | 35.11 | 34.92 | 35.09 | 4059900.0 |
| 2003-10-13 14:00:00 | QQQ | ETF | 35.1 | 35.12 | 34.98 | 35.11 | 2298200.0 |
| 2003-10-13 14:30:00 | QQQ | ETF | 35.09 | 35.12 | 35.01 | 35.04 | 3013900.0 |
| 2003-10-13 15:00:00 | QQQ | ETF | 35.04 | 35.17 | 34.96 | 35.14 | 3291600.0 |
| 2003-10-13 15:30:00 | QQQ | ETF | 35.143 | 35.17 | 35.06 | 35.15 | 4125600.0 |
| 2003-10-13 16:00:00 | QQQ | ETF | 35.155 | 35.25 | 35.12 | 35.22 | 2391100.0 |
| 2003-10-13 16:30:00 | QQQ | ETF | 35.22 | 35.25 | 35.21 | 35.23 | 152500.0 |
| 2003-10-13 17:00:00 | QQQ | ETF | 35.23 | 35.23 | 35.2 | 35.22 | 14300.0 |
| 2003-10-13 17:30:00 | QQQ | ETF | 35.22 | 35.22 | 35.18 | 35.2 | 37400.0 |
| 2003-10-13 18:00:00 | QQQ | ETF | 35.196 | 35.22 | 35.19 | 35.21 | 19000.0 |
| 2003-10-13 18:30:00 | QQQ | ETF | 35.21 | 35.21 | 35.19 | 35.19 | 2900.0 |
| 2003-10-13 19:00:00 | QQQ | ETF | 35.2 | 35.2 | 35.18 | 35.19 | 7500.0 |
| 2003-10-13 19:30:00 | QQQ | ETF | 35.19 | 35.22 | 35.19 | 35.22 | 5000.0 |
| 2003-10-13 08:30:00 | IWM | ETF | 51.935 | 51.935 | 51.935 | 51.935 | 4800.0 |
| 2003-10-13 09:30:00 | IWM | ETF | 52.06 | 52.45 | 51.95 | 52.45 | 381800.0 |
> showing 50 of 791 rows — these rows as CSV