PREVIEW / etf_30min / 2020-12-03
file: by_date/etf_30min/2020/2020-12-03.parquet size: 588 KB rows: 22,060
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-03 04:00:00 | SPY | ETF | 366.28 | 366.72 | 366.03 | 366.08 | 9950.0 |
| 2020-12-03 04:30:00 | SPY | ETF | 366.1 | 366.38 | 365.8 | 366.38 | 8844.0 |
| 2020-12-03 05:00:00 | SPY | ETF | 366.25 | 366.3 | 366.2 | 366.3 | 901.0 |
| 2020-12-03 05:30:00 | SPY | ETF | 366.22 | 366.5 | 366.18 | 366.5 | 2844.0 |
| 2020-12-03 06:00:00 | SPY | ETF | 366.57 | 366.78 | 366.55 | 366.68 | 5824.0 |
| 2020-12-03 06:30:00 | SPY | ETF | 366.73 | 366.8 | 366.49 | 366.68 | 70478.0 |
| 2020-12-03 07:00:00 | SPY | ETF | 366.69 | 366.95 | 366.41 | 366.48 | 270526.0 |
| 2020-12-03 07:30:00 | SPY | ETF | 366.5 | 366.96 | 366.5 | 366.96 | 33454.0 |
| 2020-12-03 08:00:00 | SPY | ETF | 366.5701 | 366.92 | 366.2 | 366.83 | 104956.0 |
| 2020-12-03 08:30:00 | SPY | ETF | 366.86 | 367.01 | 366.5 | 366.69 | 206205.0 |
| 2020-12-03 09:00:00 | SPY | ETF | 366.65 | 366.86 | 366.65 | 366.6804 | 82952.0 |
| 2020-12-03 09:30:00 | SPY | ETF | 366.68 | 367.278 | 366.65 | 367.01 | 3530188.0 |
| 2020-12-03 10:00:00 | SPY | ETF | 367.0 | 367.96 | 366.96 | 367.5653 | 2832769.0 |
| 2020-12-03 10:30:00 | SPY | ETF | 367.57 | 367.99 | 367.47 | 367.5001 | 2169705.0 |
| 2020-12-03 11:00:00 | SPY | ETF | 367.5 | 367.75 | 366.91 | 367.695 | 2262806.0 |
| 2020-12-03 11:30:00 | SPY | ETF | 367.69 | 367.88 | 367.435 | 367.6182 | 1295547.0 |
| 2020-12-03 12:00:00 | SPY | ETF | 367.62 | 367.89 | 367.05 | 367.3401 | 2571517.0 |
| 2020-12-03 12:30:00 | SPY | ETF | 367.34 | 367.66 | 367.095 | 367.45 | 1533950.0 |
| 2020-12-03 13:00:00 | SPY | ETF | 367.44 | 367.495 | 366.87 | 367.1713 | 1719998.0 |
| 2020-12-03 13:30:00 | SPY | ETF | 367.17 | 367.18 | 366.39 | 366.52 | 2117833.0 |
| 2020-12-03 14:00:00 | SPY | ETF | 366.52 | 367.09 | 366.47 | 367.0144 | 2175430.0 |
| 2020-12-03 14:30:00 | SPY | ETF | 367.01 | 367.63 | 366.96 | 367.59 | 3901018.0 |
| 2020-12-03 15:00:00 | SPY | ETF | 367.571 | 368.19 | 367.29 | 368.055 | 4473887.0 |
| 2020-12-03 15:30:00 | SPY | ETF | 368.06 | 368.11 | 365.5 | 366.6698 | 20673728.0 |
| 2020-12-03 16:00:00 | SPY | ETF | 366.67 | 367.08 | 366.25 | 367.0 | 8011260.0 |
| 2020-12-03 16:30:00 | SPY | ETF | 367.0 | 367.04 | 366.72 | 366.76 | 439366.0 |
| 2020-12-03 17:00:00 | SPY | ETF | 366.89 | 367.0 | 366.72 | 366.91 | 82911.0 |
| 2020-12-03 17:30:00 | SPY | ETF | 366.91 | 366.96 | 366.8 | 366.87 | 49290.0 |
| 2020-12-03 18:00:00 | SPY | ETF | 366.87 | 366.99 | 366.58 | 366.86 | 104639.0 |
| 2020-12-03 18:30:00 | SPY | ETF | 366.85 | 367.28 | 366.6927 | 366.93 | 124510.0 |
| 2020-12-03 19:00:00 | SPY | ETF | 367.0 | 367.39 | 367.0 | 367.33 | 35011.0 |
| 2020-12-03 19:30:00 | SPY | ETF | 367.34 | 367.4 | 367.08 | 367.28 | 43540.0 |
| 2020-12-03 04:00:00 | QQQ | ETF | 304.4 | 304.5 | 303.91 | 304.12 | 5465.0 |
| 2020-12-03 04:30:00 | QQQ | ETF | 304.1 | 304.43 | 304.04 | 304.43 | 1825.0 |
| 2020-12-03 05:00:00 | QQQ | ETF | 304.48 | 304.49 | 304.26 | 304.26 | 2125.0 |
| 2020-12-03 05:30:00 | QQQ | ETF | 304.22 | 304.27 | 304.15 | 304.25 | 3028.0 |
| 2020-12-03 06:00:00 | QQQ | ETF | 304.28 | 304.4 | 304.24 | 304.32 | 3300.0 |
| 2020-12-03 06:30:00 | QQQ | ETF | 304.43 | 304.46 | 304.36 | 304.36 | 1936.0 |
| 2020-12-03 07:00:00 | QQQ | ETF | 304.38 | 304.61 | 304.34 | 304.38 | 46436.0 |
| 2020-12-03 07:30:00 | QQQ | ETF | 304.36 | 304.73 | 304.34 | 304.65 | 50971.0 |
| 2020-12-03 08:00:00 | QQQ | ETF | 304.45 | 304.7 | 303.85 | 304.5 | 130129.0 |
| 2020-12-03 08:30:00 | QQQ | ETF | 304.5 | 304.64 | 304.01 | 304.25 | 88170.0 |
| 2020-12-03 09:00:00 | QQQ | ETF | 304.22 | 304.325 | 304.04 | 304.079 | 63016.0 |
| 2020-12-03 09:30:00 | QQQ | ETF | 304.07 | 304.99 | 304.06 | 304.75 | 2130680.0 |
| 2020-12-03 10:00:00 | QQQ | ETF | 304.79 | 305.88 | 304.69 | 305.3101 | 1605773.0 |
| 2020-12-03 10:30:00 | QQQ | ETF | 305.33 | 305.63 | 304.38 | 304.4299 | 1313805.0 |
| 2020-12-03 11:00:00 | QQQ | ETF | 304.431 | 304.768 | 303.67 | 304.66 | 1499229.0 |
| 2020-12-03 11:30:00 | QQQ | ETF | 304.66 | 305.235 | 304.47 | 305.14 | 902271.0 |
| 2020-12-03 12:00:00 | QQQ | ETF | 305.16 | 305.48 | 304.505 | 304.73 | 930389.0 |
| 2020-12-03 12:30:00 | QQQ | ETF | 304.7292 | 305.22 | 304.29 | 304.58 | 780297.0 |
> showing 50 of 22,060 rows — these rows as CSV