PREVIEW / etf_30min / 2003-08-14
file: by_date/etf_30min/2003/2003-08-14.parquet size: 23 KB rows: 679
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-08-14 08:00:00 | SPY | ETF | 99.3 | 99.34 | 99.24 | 99.32 | 6500.0 |
| 2003-08-14 08:30:00 | SPY | ETF | 99.26 | 99.3 | 99.03 | 99.05 | 51100.0 |
| 2003-08-14 09:00:00 | SPY | ETF | 99.03 | 99.08 | 99.03 | 99.04 | 9800.0 |
| 2003-08-14 09:30:00 | SPY | ETF | 99.1 | 99.153 | 98.509 | 98.72 | 3599900.0 |
| 2003-08-14 10:00:00 | SPY | ETF | 98.72 | 99.101 | 98.63 | 99.098 | 1970400.0 |
| 2003-08-14 10:30:00 | SPY | ETF | 99.05 | 99.429 | 98.98 | 99.35 | 3713400.0 |
| 2003-08-14 11:00:00 | SPY | ETF | 99.36 | 99.5 | 99.24 | 99.41 | 1153200.0 |
| 2003-08-14 11:30:00 | SPY | ETF | 99.41 | 99.43 | 99.26 | 99.39 | 851500.0 |
| 2003-08-14 12:00:00 | SPY | ETF | 99.37 | 99.75 | 99.3 | 99.34 | 3450300.0 |
| 2003-08-14 12:30:00 | SPY | ETF | 99.33 | 99.42 | 99.2 | 99.32 | 1518600.0 |
| 2003-08-14 13:00:00 | SPY | ETF | 99.32 | 99.47 | 99.29 | 99.34 | 864500.0 |
| 2003-08-14 13:30:00 | SPY | ETF | 99.31 | 99.43 | 99.23 | 99.41 | 901400.0 |
| 2003-08-14 14:00:00 | SPY | ETF | 99.41 | 99.46 | 99.25 | 99.33 | 803800.0 |
| 2003-08-14 14:30:00 | SPY | ETF | 99.32 | 99.599 | 99.21 | 99.57 | 2177300.0 |
| 2003-08-14 15:00:00 | SPY | ETF | 99.55 | 99.62 | 99.26 | 99.54 | 1296700.0 |
| 2003-08-14 15:30:00 | SPY | ETF | 99.55 | 99.62 | 99.3 | 99.54 | 3462300.0 |
| 2003-08-14 16:00:00 | SPY | ETF | 99.55 | 99.63 | 98.0 | 98.29 | 2537700.0 |
| 2003-08-14 16:30:00 | SPY | ETF | 98.03 | 99.31 | 97.99 | 98.5 | 1348100.0 |
| 2003-08-14 18:00:00 | SPY | ETF | 98.72 | 98.89 | 98.67 | 98.85 | 96000.0 |
| 2003-08-14 18:30:00 | SPY | ETF | 98.82 | 98.94 | 98.7 | 98.79 | 14100.0 |
| 2003-08-14 19:00:00 | SPY | ETF | 98.79 | 98.79 | 98.7 | 98.7 | 2200.0 |
| 2003-08-14 19:30:00 | SPY | ETF | 98.7 | 98.87 | 98.7 | 98.87 | 3200.0 |
| 2003-08-14 08:00:00 | QQQ | ETF | 30.94 | 31.0 | 30.93 | 30.96 | 134900.0 |
| 2003-08-14 08:30:00 | QQQ | ETF | 30.95 | 30.98 | 30.87 | 30.88 | 55000.0 |
| 2003-08-14 09:00:00 | QQQ | ETF | 30.89 | 30.9 | 30.85 | 30.88 | 42200.0 |
| 2003-08-14 09:30:00 | QQQ | ETF | 30.88 | 30.94 | 30.67 | 30.76 | 5002700.0 |
| 2003-08-14 10:00:00 | QQQ | ETF | 30.748 | 30.937 | 30.69 | 30.932 | 3161200.0 |
| 2003-08-14 10:30:00 | QQQ | ETF | 30.94 | 31.01 | 30.87 | 30.979 | 3541600.0 |
| 2003-08-14 11:00:00 | QQQ | ETF | 30.979 | 31.03 | 30.91 | 30.99 | 3098700.0 |
| 2003-08-14 11:30:00 | QQQ | ETF | 30.99 | 30.99 | 30.916 | 30.98 | 1694000.0 |
| 2003-08-14 12:00:00 | QQQ | ETF | 30.98 | 31.19 | 30.97 | 31.052 | 5597100.0 |
| 2003-08-14 12:30:00 | QQQ | ETF | 31.052 | 31.09 | 31.01 | 31.056 | 2141800.0 |
| 2003-08-14 13:00:00 | QQQ | ETF | 31.06 | 31.11 | 31.04 | 31.06 | 1397900.0 |
| 2003-08-14 13:30:00 | QQQ | ETF | 31.05 | 31.07 | 30.98 | 31.05 | 2046800.0 |
| 2003-08-14 14:00:00 | QQQ | ETF | 31.065 | 31.094 | 31.0 | 31.053 | 1736700.0 |
| 2003-08-14 14:30:00 | QQQ | ETF | 31.06 | 31.164 | 30.99 | 31.163 | 2318200.0 |
| 2003-08-14 15:00:00 | QQQ | ETF | 31.159 | 31.18 | 31.03 | 31.14 | 2819000.0 |
| 2003-08-14 15:30:00 | QQQ | ETF | 31.14 | 31.16 | 31.02 | 31.14 | 4957400.0 |
| 2003-08-14 16:00:00 | QQQ | ETF | 31.13 | 31.17 | 30.73 | 30.76 | 3435200.0 |
| 2003-08-14 16:30:00 | QQQ | ETF | 30.76 | 30.9 | 30.35 | 30.67 | 1554300.0 |
| 2003-08-14 18:00:00 | QQQ | ETF | 30.73 | 30.82 | 30.71 | 30.8 | 263900.0 |
| 2003-08-14 18:30:00 | QQQ | ETF | 30.8 | 30.81 | 30.75 | 30.75 | 34000.0 |
| 2003-08-14 19:00:00 | QQQ | ETF | 30.8 | 30.8 | 30.75 | 30.75 | 21300.0 |
| 2003-08-14 19:30:00 | QQQ | ETF | 30.72 | 30.75 | 30.71 | 30.74 | 7400.0 |
| 2003-08-14 09:30:00 | IWM | ETF | 46.715 | 46.75 | 46.515 | 46.63 | 202600.0 |
| 2003-08-14 10:00:00 | IWM | ETF | 46.635 | 46.705 | 46.615 | 46.69 | 92000.0 |
| 2003-08-14 10:30:00 | IWM | ETF | 46.735 | 46.76 | 46.65 | 46.725 | 890600.0 |
| 2003-08-14 11:00:00 | IWM | ETF | 46.725 | 46.795 | 46.695 | 46.79 | 278600.0 |
| 2003-08-14 11:30:00 | IWM | ETF | 46.78 | 46.875 | 46.745 | 46.84 | 131600.0 |
| 2003-08-14 12:00:00 | IWM | ETF | 46.835 | 46.955 | 46.81 | 46.81 | 260800.0 |
> showing 50 of 679 rows — these rows as CSV