PREVIEW / etf_5min / 2021-12-14
file: by_date/etf_5min/2021/2021-12-14.parquet size: 1.9 MB rows: 89,369
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-14 04:00:00 | SPY | ETF | 467.48 | 467.69 | 467.48 | 467.55 | 2796.0 |
| 2021-12-14 04:05:00 | SPY | ETF | 467.47 | 467.87 | 467.47 | 467.87 | 5700.0 |
| 2021-12-14 04:10:00 | SPY | ETF | 467.9 | 467.9 | 467.5 | 467.62 | 6021.0 |
| 2021-12-14 04:15:00 | SPY | ETF | 467.65 | 467.71 | 467.6 | 467.69 | 854.0 |
| 2021-12-14 04:20:00 | SPY | ETF | 467.65 | 467.75 | 467.48 | 467.48 | 1342.0 |
| 2021-12-14 04:25:00 | SPY | ETF | 467.45 | 467.45 | 467.45 | 467.45 | 304.0 |
| 2021-12-14 04:30:00 | SPY | ETF | 467.43 | 467.6 | 467.34 | 467.51 | 6378.0 |
| 2021-12-14 04:35:00 | SPY | ETF | 467.45 | 467.45 | 466.8 | 466.89 | 11516.0 |
| 2021-12-14 04:40:00 | SPY | ETF | 466.7 | 466.76 | 466.39 | 466.39 | 5899.0 |
| 2021-12-14 04:45:00 | SPY | ETF | 466.64 | 466.64 | 466.42 | 466.57 | 700.0 |
| 2021-12-14 04:50:00 | SPY | ETF | 466.46 | 466.46 | 465.21 | 465.21 | 19972.0 |
| 2021-12-14 04:55:00 | SPY | ETF | 465.32 | 465.44 | 464.9 | 464.9 | 17241.0 |
| 2021-12-14 05:00:00 | SPY | ETF | 464.89 | 465.1 | 464.75 | 464.91 | 19268.0 |
| 2021-12-14 05:05:00 | SPY | ETF | 464.91 | 465.23 | 464.83 | 465.23 | 3205.0 |
| 2021-12-14 05:10:00 | SPY | ETF | 465.27 | 465.27 | 465.05 | 465.19 | 4495.0 |
| 2021-12-14 05:15:00 | SPY | ETF | 465.22 | 465.22 | 464.96 | 464.96 | 2370.0 |
| 2021-12-14 05:20:00 | SPY | ETF | 464.99 | 465.11 | 464.99 | 465.08 | 7866.0 |
| 2021-12-14 05:25:00 | SPY | ETF | 465.18 | 465.21 | 465.1 | 465.2 | 877.0 |
| 2021-12-14 05:30:00 | SPY | ETF | 465.5 | 465.5 | 465.45 | 465.45 | 200.0 |
| 2021-12-14 05:35:00 | SPY | ETF | 465.45 | 465.49 | 465.4 | 465.4 | 3737.0 |
| 2021-12-14 05:40:00 | SPY | ETF | 465.35 | 465.49 | 465.28 | 465.28 | 1500.0 |
| 2021-12-14 05:45:00 | SPY | ETF | 465.39 | 465.4 | 465.1 | 465.17 | 5171.0 |
| 2021-12-14 05:50:00 | SPY | ETF | 465.08 | 465.08 | 464.95 | 465.01 | 2550.0 |
| 2021-12-14 05:55:00 | SPY | ETF | 465.15 | 465.27 | 465.15 | 465.27 | 400.0 |
| 2021-12-14 06:00:00 | SPY | ETF | 465.3 | 465.4 | 465.3 | 465.4 | 562.0 |
| 2021-12-14 06:05:00 | SPY | ETF | 465.49 | 465.62 | 465.45 | 465.62 | 1600.0 |
| 2021-12-14 06:10:00 | SPY | ETF | 465.78 | 465.83 | 465.61 | 465.61 | 5452.0 |
| 2021-12-14 06:15:00 | SPY | ETF | 465.68 | 465.68 | 465.55 | 465.55 | 200.0 |
| 2021-12-14 06:20:00 | SPY | ETF | 465.56 | 465.66 | 465.52 | 465.59 | 998.0 |
| 2021-12-14 06:25:00 | SPY | ETF | 465.58 | 465.59 | 465.38 | 465.38 | 14893.0 |
| 2021-12-14 06:30:00 | SPY | ETF | 465.45 | 465.58 | 465.4 | 465.4 | 12974.0 |
| 2021-12-14 06:35:00 | SPY | ETF | 465.26 | 465.39 | 465.26 | 465.39 | 15497.0 |
| 2021-12-14 06:40:00 | SPY | ETF | 465.43 | 465.43 | 465.24 | 465.38 | 1007.0 |
| 2021-12-14 06:45:00 | SPY | ETF | 465.47 | 465.77 | 465.35 | 465.41 | 10193.0 |
| 2021-12-14 06:50:00 | SPY | ETF | 465.36 | 465.48 | 465.21 | 465.4 | 13481.0 |
| 2021-12-14 06:55:00 | SPY | ETF | 465.54 | 465.54 | 465.34 | 465.35 | 6828.0 |
| 2021-12-14 07:00:00 | SPY | ETF | 465.44 | 465.63 | 465.39 | 465.61 | 4100.0 |
| 2021-12-14 07:05:00 | SPY | ETF | 465.64 | 465.86 | 465.64 | 465.8 | 6360.0 |
| 2021-12-14 07:10:00 | SPY | ETF | 465.81 | 466.0 | 465.78 | 465.9 | 53126.0 |
| 2021-12-14 07:15:00 | SPY | ETF | 465.89 | 465.97 | 465.88 | 465.97 | 1362.0 |
| 2021-12-14 07:20:00 | SPY | ETF | 466.0 | 466.11 | 465.99 | 466.11 | 10105.0 |
| 2021-12-14 07:25:00 | SPY | ETF | 466.17 | 466.17 | 465.99 | 466.13 | 3353.0 |
| 2021-12-14 07:30:00 | SPY | ETF | 466.13 | 466.15 | 465.9 | 466.03 | 20209.0 |
| 2021-12-14 07:35:00 | SPY | ETF | 466.0 | 466.0 | 465.72 | 465.72 | 9002.0 |
| 2021-12-14 07:40:00 | SPY | ETF | 465.78 | 465.79 | 465.49 | 465.68 | 16413.0 |
| 2021-12-14 07:45:00 | SPY | ETF | 465.66 | 465.75 | 465.65 | 465.73 | 12448.0 |
| 2021-12-14 07:50:00 | SPY | ETF | 465.75 | 465.8 | 465.67 | 465.68 | 8225.0 |
| 2021-12-14 07:55:00 | SPY | ETF | 465.69 | 465.7 | 465.61 | 465.61 | 6774.0 |
| 2021-12-14 08:00:00 | SPY | ETF | 465.9501 | 468.0 | 465.0796 | 465.635 | 32814.0 |
| 2021-12-14 08:05:00 | SPY | ETF | 465.66 | 466.02 | 465.58 | 465.89 | 10200.0 |
> showing 50 of 89,369 rows — these rows as CSV