PREVIEW / etf_30min / 2003-12-03
file: by_date/etf_30min/2003/2003-12-03.parquet size: 28 KB rows: 869
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-03 08:00:00 | SPY | ETF | 107.55 | 107.6 | 107.55 | 107.6 | 7200.0 |
| 2003-12-03 08:30:00 | SPY | ETF | 107.6 | 107.68 | 107.58 | 107.63 | 106500.0 |
| 2003-12-03 09:00:00 | SPY | ETF | 107.68 | 107.7 | 107.64 | 107.64 | 12100.0 |
| 2003-12-03 09:30:00 | SPY | ETF | 107.65 | 107.86 | 107.59 | 107.78 | 3588600.0 |
| 2003-12-03 10:00:00 | SPY | ETF | 107.81 | 107.85 | 107.32 | 107.4 | 4218200.0 |
| 2003-12-03 10:30:00 | SPY | ETF | 107.4 | 107.7 | 107.38 | 107.63 | 1847000.0 |
| 2003-12-03 11:00:00 | SPY | ETF | 107.63 | 107.75 | 107.52 | 107.74 | 1562300.0 |
| 2003-12-03 11:30:00 | SPY | ETF | 107.72 | 108.04 | 107.72 | 107.98 | 4252700.0 |
| 2003-12-03 12:00:00 | SPY | ETF | 107.99 | 108.06 | 107.92 | 107.95 | 969600.0 |
| 2003-12-03 12:30:00 | SPY | ETF | 107.99 | 108.08 | 107.891 | 107.9 | 1669100.0 |
| 2003-12-03 13:00:00 | SPY | ETF | 107.94 | 108.04 | 107.791 | 107.83 | 772200.0 |
| 2003-12-03 13:30:00 | SPY | ETF | 107.83 | 108.05 | 107.77 | 108.01 | 823200.0 |
| 2003-12-03 14:00:00 | SPY | ETF | 108.01 | 108.03 | 107.79 | 107.8 | 1018000.0 |
| 2003-12-03 14:30:00 | SPY | ETF | 107.82 | 107.87 | 107.53 | 107.67 | 4293100.0 |
| 2003-12-03 15:00:00 | SPY | ETF | 107.68 | 107.81 | 107.16 | 107.17 | 7254800.0 |
| 2003-12-03 15:30:00 | SPY | ETF | 107.18 | 107.29 | 107.08 | 107.12 | 4137100.0 |
| 2003-12-03 16:00:00 | SPY | ETF | 107.11 | 107.62 | 107.08 | 107.14 | 1037000.0 |
| 2003-12-03 16:30:00 | SPY | ETF | 107.13 | 107.18 | 107.11 | 107.18 | 58800.0 |
| 2003-12-03 17:00:00 | SPY | ETF | 107.14 | 107.17 | 107.12 | 107.15 | 65100.0 |
| 2003-12-03 17:30:00 | SPY | ETF | 107.15 | 107.16 | 107.15 | 107.15 | 4700.0 |
| 2003-12-03 18:00:00 | SPY | ETF | 107.15 | 107.15 | 107.08 | 107.08 | 16800.0 |
| 2003-12-03 18:30:00 | SPY | ETF | 107.05 | 107.05 | 107.05 | 107.05 | 100.0 |
| 2003-12-03 19:00:00 | SPY | ETF | 107.12 | 107.12 | 107.12 | 107.12 | 200.0 |
| 2003-12-03 19:30:00 | SPY | ETF | 107.11 | 107.11 | 107.11 | 107.11 | 400.0 |
| 2003-12-03 08:00:00 | QQQ | ETF | 35.82 | 35.85 | 35.8 | 35.83 | 46700.0 |
| 2003-12-03 08:30:00 | QQQ | ETF | 35.83 | 35.89 | 35.82 | 35.89 | 91900.0 |
| 2003-12-03 09:00:00 | QQQ | ETF | 35.89 | 35.9 | 35.84 | 35.84 | 102800.0 |
| 2003-12-03 09:30:00 | QQQ | ETF | 35.84 | 36.0 | 35.806 | 35.96 | 12736700.0 |
| 2003-12-03 10:00:00 | QQQ | ETF | 35.96 | 35.97 | 35.65 | 35.74 | 13617500.0 |
| 2003-12-03 10:30:00 | QQQ | ETF | 35.734 | 35.89 | 35.72 | 35.851 | 3994500.0 |
| 2003-12-03 11:00:00 | QQQ | ETF | 35.85 | 35.88 | 35.743 | 35.87 | 3032500.0 |
| 2003-12-03 11:30:00 | QQQ | ETF | 35.87 | 36.025 | 35.87 | 35.973 | 9354700.0 |
| 2003-12-03 12:00:00 | QQQ | ETF | 35.97 | 36.011 | 35.93 | 35.98 | 4564400.0 |
| 2003-12-03 12:30:00 | QQQ | ETF | 35.98 | 36.12 | 35.97 | 35.99 | 8043000.0 |
| 2003-12-03 13:00:00 | QQQ | ETF | 35.98 | 36.03 | 35.93 | 35.95 | 5388800.0 |
| 2003-12-03 13:30:00 | QQQ | ETF | 35.95 | 36.013 | 35.88 | 35.999 | 4066200.0 |
| 2003-12-03 14:00:00 | QQQ | ETF | 36.0 | 36.03 | 35.86 | 35.87 | 2732200.0 |
| 2003-12-03 14:30:00 | QQQ | ETF | 35.88 | 35.9 | 35.75 | 35.811 | 5684200.0 |
| 2003-12-03 15:00:00 | QQQ | ETF | 35.81 | 35.86 | 35.468 | 35.469 | 14957300.0 |
| 2003-12-03 15:30:00 | QQQ | ETF | 35.478 | 35.55 | 35.35 | 35.369 | 11645800.0 |
| 2003-12-03 16:00:00 | QQQ | ETF | 35.36 | 35.4 | 35.25 | 35.28 | 1922100.0 |
| 2003-12-03 16:30:00 | QQQ | ETF | 35.28 | 35.3 | 35.25 | 35.27 | 335100.0 |
| 2003-12-03 17:00:00 | QQQ | ETF | 35.273 | 35.8193 | 35.27 | 35.28 | 266400.0 |
| 2003-12-03 17:30:00 | QQQ | ETF | 35.28 | 35.29 | 35.25 | 35.29 | 161700.0 |
| 2003-12-03 18:00:00 | QQQ | ETF | 35.27 | 35.27 | 35.243 | 35.27 | 75500.0 |
| 2003-12-03 18:30:00 | QQQ | ETF | 35.27 | 35.27 | 35.25 | 35.26 | 8400.0 |
| 2003-12-03 19:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.24 | 35.27 | 11800.0 |
| 2003-12-03 19:30:00 | QQQ | ETF | 35.26 | 35.29 | 35.26 | 35.29 | 31300.0 |
| 2003-12-03 08:30:00 | IWM | ETF | 55.515 | 55.515 | 55.5 | 55.515 | 4000.0 |
| 2003-12-03 09:00:00 | IWM | ETF | 55.585 | 55.585 | 55.585 | 55.585 | 1000.0 |
> showing 50 of 869 rows — these rows as CSV