PREVIEW / etf_5min / 2020-12-02
file: by_date/etf_5min/2020/2020-12-02.parquet size: 1.7 MB rows: 78,795
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-02 04:00:00 | SPY | ETF | 365.22 | 365.22 | 365.06 | 365.07 | 1428.0 |
| 2020-12-02 04:05:00 | SPY | ETF | 365.19 | 365.2 | 365.19 | 365.2 | 210.0 |
| 2020-12-02 04:10:00 | SPY | ETF | 365.37 | 365.4 | 365.37 | 365.4 | 225.0 |
| 2020-12-02 04:20:00 | SPY | ETF | 365.57 | 365.59 | 365.56 | 365.59 | 1150.0 |
| 2020-12-02 04:25:00 | SPY | ETF | 365.43 | 365.5 | 365.43 | 365.5 | 201.0 |
| 2020-12-02 04:30:00 | SPY | ETF | 365.52 | 365.52 | 365.52 | 365.52 | 365.0 |
| 2020-12-02 04:35:00 | SPY | ETF | 365.52 | 365.52 | 365.41 | 365.41 | 804.0 |
| 2020-12-02 04:40:00 | SPY | ETF | 365.34 | 365.34 | 365.34 | 365.34 | 150.0 |
| 2020-12-02 04:45:00 | SPY | ETF | 365.42 | 365.46 | 365.42 | 365.46 | 390.0 |
| 2020-12-02 04:55:00 | SPY | ETF | 365.4 | 365.4 | 365.38 | 365.38 | 204.0 |
| 2020-12-02 05:00:00 | SPY | ETF | 365.43 | 365.51 | 365.42 | 365.44 | 4300.0 |
| 2020-12-02 05:15:00 | SPY | ETF | 365.4 | 365.4 | 365.4 | 365.4 | 161.0 |
| 2020-12-02 05:20:00 | SPY | ETF | 365.41 | 365.45 | 365.41 | 365.45 | 502.0 |
| 2020-12-02 05:25:00 | SPY | ETF | 365.39 | 365.39 | 365.39 | 365.39 | 100.0 |
| 2020-12-02 05:30:00 | SPY | ETF | 365.44 | 365.44 | 365.39 | 365.39 | 3513.0 |
| 2020-12-02 05:35:00 | SPY | ETF | 365.32 | 365.34 | 365.32 | 365.34 | 240.0 |
| 2020-12-02 05:40:00 | SPY | ETF | 365.32 | 365.42 | 365.32 | 365.42 | 14370.0 |
| 2020-12-02 05:50:00 | SPY | ETF | 365.5 | 365.56 | 365.5 | 365.56 | 800.0 |
| 2020-12-02 05:55:00 | SPY | ETF | 365.51 | 365.57 | 365.51 | 365.57 | 330.0 |
| 2020-12-02 06:05:00 | SPY | ETF | 365.43 | 365.43 | 365.39 | 365.39 | 225.0 |
| 2020-12-02 06:10:00 | SPY | ETF | 365.41 | 365.41 | 365.2 | 365.2 | 1180.0 |
| 2020-12-02 06:15:00 | SPY | ETF | 365.15 | 365.15 | 365.08 | 365.08 | 1559.0 |
| 2020-12-02 06:20:00 | SPY | ETF | 365.11 | 365.15 | 365.0 | 365.0 | 31132.0 |
| 2020-12-02 06:25:00 | SPY | ETF | 365.15 | 365.15 | 365.15 | 365.15 | 250.0 |
| 2020-12-02 06:30:00 | SPY | ETF | 365.03 | 365.11 | 365.03 | 365.11 | 1300.0 |
| 2020-12-02 06:35:00 | SPY | ETF | 365.13 | 365.13 | 365.11 | 365.11 | 308.0 |
| 2020-12-02 06:40:00 | SPY | ETF | 365.23 | 365.24 | 365.23 | 365.23 | 400.0 |
| 2020-12-02 06:45:00 | SPY | ETF | 365.13 | 365.13 | 365.08 | 365.08 | 203.0 |
| 2020-12-02 06:50:00 | SPY | ETF | 365.2 | 365.2 | 365.2 | 365.2 | 802.0 |
| 2020-12-02 06:55:00 | SPY | ETF | 365.3 | 365.44 | 365.3 | 365.44 | 1780.0 |
| 2020-12-02 07:00:00 | SPY | ETF | 365.33 | 365.42 | 365.14 | 365.15 | 37518.0 |
| 2020-12-02 07:05:00 | SPY | ETF | 365.2 | 365.22 | 365.2 | 365.22 | 447.0 |
| 2020-12-02 07:10:00 | SPY | ETF | 365.16 | 365.18 | 365.02 | 365.07 | 86533.0 |
| 2020-12-02 07:15:00 | SPY | ETF | 365.07 | 365.25 | 364.95 | 365.15 | 12075.0 |
| 2020-12-02 07:20:00 | SPY | ETF | 365.12 | 365.12 | 365.01 | 365.05 | 90429.0 |
| 2020-12-02 07:25:00 | SPY | ETF | 365.08 | 365.08 | 364.91 | 364.91 | 32424.0 |
| 2020-12-02 07:30:00 | SPY | ETF | 364.94 | 364.97 | 364.81 | 364.82 | 27263.0 |
| 2020-12-02 07:35:00 | SPY | ETF | 364.82 | 364.82 | 364.53 | 364.53 | 19689.0 |
| 2020-12-02 07:40:00 | SPY | ETF | 364.51 | 364.55 | 364.3 | 364.31 | 55834.0 |
| 2020-12-02 07:45:00 | SPY | ETF | 364.32 | 364.62 | 364.31 | 364.52 | 40940.0 |
| 2020-12-02 07:50:00 | SPY | ETF | 364.55 | 364.79 | 364.5 | 364.79 | 24210.0 |
| 2020-12-02 07:55:00 | SPY | ETF | 364.76 | 364.85 | 364.73 | 364.83 | 16275.0 |
| 2020-12-02 08:00:00 | SPY | ETF | 364.7 | 365.3804 | 364.27 | 364.74 | 22807.0 |
| 2020-12-02 08:05:00 | SPY | ETF | 364.71 | 364.91 | 364.71 | 364.91 | 19064.0 |
| 2020-12-02 08:10:00 | SPY | ETF | 364.8898 | 364.97 | 364.8 | 364.83 | 12794.0 |
| 2020-12-02 08:15:00 | SPY | ETF | 364.8 | 365.07 | 364.55 | 364.94 | 34020.0 |
| 2020-12-02 08:20:00 | SPY | ETF | 364.91 | 364.96 | 364.87 | 364.87 | 11294.0 |
| 2020-12-02 08:25:00 | SPY | ETF | 364.92 | 364.92 | 364.71 | 364.8 | 15876.0 |
| 2020-12-02 08:30:00 | SPY | ETF | 364.83 | 364.88 | 364.73 | 364.77 | 17316.0 |
| 2020-12-02 08:35:00 | SPY | ETF | 364.7 | 364.85 | 364.69 | 364.75 | 65148.0 |
> showing 50 of 78,795 rows — these rows as CSV