PREVIEW / etf_5min / 2021-01-14
file: by_date/etf_5min/2021/2021-01-14.parquet size: 1.9 MB rows: 86,352
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-01-14 04:00:00 | SPY | ETF | 380.81 | 380.92 | 380.67 | 380.9 | 14534.0 |
| 2021-01-14 04:05:00 | SPY | ETF | 380.75 | 380.77 | 380.75 | 380.77 | 1300.0 |
| 2021-01-14 04:10:00 | SPY | ETF | 380.77 | 380.8 | 380.69 | 380.69 | 1741.0 |
| 2021-01-14 04:15:00 | SPY | ETF | 380.73 | 380.76 | 380.72 | 380.72 | 900.0 |
| 2021-01-14 04:20:00 | SPY | ETF | 380.78 | 380.78 | 380.75 | 380.75 | 605.0 |
| 2021-01-14 04:25:00 | SPY | ETF | 380.78 | 380.83 | 380.76 | 380.76 | 3106.0 |
| 2021-01-14 04:30:00 | SPY | ETF | 380.81 | 380.81 | 380.81 | 380.81 | 342.0 |
| 2021-01-14 04:35:00 | SPY | ETF | 380.89 | 380.89 | 380.82 | 380.82 | 323.0 |
| 2021-01-14 04:40:00 | SPY | ETF | 380.82 | 380.82 | 380.82 | 380.82 | 200.0 |
| 2021-01-14 04:45:00 | SPY | ETF | 380.75 | 380.77 | 380.75 | 380.77 | 1150.0 |
| 2021-01-14 04:50:00 | SPY | ETF | 380.85 | 380.85 | 380.84 | 380.84 | 200.0 |
| 2021-01-14 04:55:00 | SPY | ETF | 380.83 | 380.83 | 380.83 | 380.83 | 101.0 |
| 2021-01-14 05:00:00 | SPY | ETF | 380.76 | 380.76 | 380.57 | 380.63 | 5412.0 |
| 2021-01-14 05:05:00 | SPY | ETF | 380.68 | 380.68 | 380.64 | 380.64 | 1058.0 |
| 2021-01-14 05:10:00 | SPY | ETF | 380.65 | 380.69 | 380.62 | 380.69 | 1881.0 |
| 2021-01-14 05:15:00 | SPY | ETF | 380.68 | 380.68 | 380.65 | 380.68 | 601.0 |
| 2021-01-14 05:20:00 | SPY | ETF | 380.6 | 380.66 | 380.6 | 380.61 | 1323.0 |
| 2021-01-14 05:25:00 | SPY | ETF | 380.46 | 380.46 | 380.19 | 380.34 | 2187.0 |
| 2021-01-14 05:30:00 | SPY | ETF | 380.36 | 380.46 | 380.36 | 380.46 | 325.0 |
| 2021-01-14 05:35:00 | SPY | ETF | 380.3 | 380.3 | 380.04 | 380.06 | 1800.0 |
| 2021-01-14 05:40:00 | SPY | ETF | 380.17 | 380.36 | 380.17 | 380.36 | 1441.0 |
| 2021-01-14 05:45:00 | SPY | ETF | 380.32 | 380.32 | 380.3 | 380.3 | 1300.0 |
| 2021-01-14 05:50:00 | SPY | ETF | 380.33 | 380.33 | 380.2 | 380.25 | 2600.0 |
| 2021-01-14 05:55:00 | SPY | ETF | 380.16 | 380.3 | 380.16 | 380.3 | 3025.0 |
| 2021-01-14 06:00:00 | SPY | ETF | 380.38 | 380.42 | 380.37 | 380.42 | 2130.0 |
| 2021-01-14 06:05:00 | SPY | ETF | 380.42 | 380.42 | 380.39 | 380.39 | 992.0 |
| 2021-01-14 06:10:00 | SPY | ETF | 380.37 | 380.37 | 380.18 | 380.32 | 2978.0 |
| 2021-01-14 06:15:00 | SPY | ETF | 380.32 | 380.32 | 380.32 | 380.32 | 215.0 |
| 2021-01-14 06:20:00 | SPY | ETF | 380.31 | 380.31 | 380.19 | 380.27 | 4333.0 |
| 2021-01-14 06:25:00 | SPY | ETF | 380.18 | 380.18 | 380.0 | 380.07 | 5502.0 |
| 2021-01-14 06:30:00 | SPY | ETF | 380.07 | 380.11 | 380.07 | 380.11 | 1232.0 |
| 2021-01-14 06:35:00 | SPY | ETF | 380.15 | 380.17 | 380.07 | 380.07 | 1300.0 |
| 2021-01-14 06:40:00 | SPY | ETF | 380.06 | 380.2 | 380.06 | 380.2 | 228.0 |
| 2021-01-14 06:45:00 | SPY | ETF | 380.19 | 380.33 | 380.19 | 380.31 | 1412.0 |
| 2021-01-14 06:50:00 | SPY | ETF | 380.31 | 380.38 | 380.31 | 380.38 | 2003.0 |
| 2021-01-14 06:55:00 | SPY | ETF | 380.4 | 380.46 | 380.4 | 380.46 | 2002.0 |
| 2021-01-14 07:00:00 | SPY | ETF | 380.44 | 380.5 | 380.34 | 380.41 | 6897.0 |
| 2021-01-14 07:05:00 | SPY | ETF | 380.44 | 380.52 | 380.43 | 380.44 | 17952.0 |
| 2021-01-14 07:10:00 | SPY | ETF | 380.45 | 380.46 | 380.45 | 380.45 | 4437.0 |
| 2021-01-14 07:15:00 | SPY | ETF | 380.44 | 380.55 | 380.43 | 380.5 | 8796.0 |
| 2021-01-14 07:20:00 | SPY | ETF | 380.49 | 380.5 | 380.37 | 380.37 | 9868.0 |
| 2021-01-14 07:25:00 | SPY | ETF | 380.44 | 380.48 | 380.41 | 380.45 | 2152.0 |
| 2021-01-14 07:30:00 | SPY | ETF | 380.37 | 380.37 | 380.3 | 380.31 | 3795.0 |
| 2021-01-14 07:35:00 | SPY | ETF | 380.32 | 380.45 | 380.32 | 380.44 | 4598.0 |
| 2021-01-14 07:40:00 | SPY | ETF | 380.45 | 380.49 | 380.35 | 380.36 | 9188.0 |
| 2021-01-14 07:45:00 | SPY | ETF | 380.35 | 380.43 | 380.26 | 380.43 | 43365.0 |
| 2021-01-14 07:50:00 | SPY | ETF | 380.43 | 380.5 | 380.41 | 380.45 | 21530.0 |
| 2021-01-14 07:55:00 | SPY | ETF | 380.48 | 380.51 | 380.47 | 380.48 | 65138.0 |
| 2021-01-14 08:00:00 | SPY | ETF | 380.47 | 380.51 | 380.2898 | 380.2898 | 22803.0 |
| 2021-01-14 08:05:00 | SPY | ETF | 380.3 | 380.45 | 380.3 | 380.43 | 57011.0 |
> showing 50 of 86,352 rows — these rows as CSV