PREVIEW / etf_5min / 2021-12-10
file: by_date/etf_5min/2021/2021-12-10.parquet size: 1.8 MB rows: 84,100
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-10 04:00:00 | SPY | ETF | 467.57 | 467.69 | 467.37 | 467.37 | 5241.0 |
| 2021-12-10 04:05:00 | SPY | ETF | 467.32 | 467.33 | 467.23 | 467.27 | 656.0 |
| 2021-12-10 04:10:00 | SPY | ETF | 467.27 | 467.36 | 467.27 | 467.31 | 1081.0 |
| 2021-12-10 04:15:00 | SPY | ETF | 467.33 | 467.4 | 467.29 | 467.37 | 1969.0 |
| 2021-12-10 04:20:00 | SPY | ETF | 467.42 | 467.47 | 467.38 | 467.47 | 1137.0 |
| 2021-12-10 04:25:00 | SPY | ETF | 467.39 | 467.39 | 467.3 | 467.31 | 429.0 |
| 2021-12-10 04:30:00 | SPY | ETF | 467.34 | 467.37 | 467.31 | 467.37 | 968.0 |
| 2021-12-10 04:35:00 | SPY | ETF | 467.5 | 467.57 | 467.5 | 467.57 | 1198.0 |
| 2021-12-10 04:40:00 | SPY | ETF | 467.56 | 467.6 | 467.45 | 467.45 | 6886.0 |
| 2021-12-10 04:45:00 | SPY | ETF | 467.52 | 467.57 | 467.52 | 467.53 | 839.0 |
| 2021-12-10 04:50:00 | SPY | ETF | 467.57 | 467.57 | 467.57 | 467.57 | 100.0 |
| 2021-12-10 04:55:00 | SPY | ETF | 467.54 | 467.64 | 467.54 | 467.64 | 300.0 |
| 2021-12-10 05:00:00 | SPY | ETF | 467.68 | 467.69 | 467.59 | 467.59 | 5749.0 |
| 2021-12-10 05:05:00 | SPY | ETF | 467.56 | 467.63 | 467.56 | 467.63 | 1800.0 |
| 2021-12-10 05:10:00 | SPY | ETF | 467.62 | 467.62 | 467.49 | 467.49 | 409.0 |
| 2021-12-10 05:15:00 | SPY | ETF | 467.48 | 467.54 | 467.48 | 467.5 | 420.0 |
| 2021-12-10 05:20:00 | SPY | ETF | 467.53 | 467.53 | 467.53 | 467.53 | 1132.0 |
| 2021-12-10 05:25:00 | SPY | ETF | 467.51 | 467.54 | 467.51 | 467.54 | 1100.0 |
| 2021-12-10 05:30:00 | SPY | ETF | 467.57 | 467.59 | 467.56 | 467.59 | 723.0 |
| 2021-12-10 05:35:00 | SPY | ETF | 467.65 | 467.72 | 467.65 | 467.72 | 3919.0 |
| 2021-12-10 05:40:00 | SPY | ETF | 467.65 | 467.66 | 467.6 | 467.62 | 1183.0 |
| 2021-12-10 05:45:00 | SPY | ETF | 467.62 | 467.62 | 467.62 | 467.62 | 120.0 |
| 2021-12-10 05:50:00 | SPY | ETF | 467.67 | 467.67 | 467.65 | 467.65 | 641.0 |
| 2021-12-10 05:55:00 | SPY | ETF | 467.67 | 467.7 | 467.55 | 467.7 | 1074.0 |
| 2021-12-10 06:00:00 | SPY | ETF | 467.72 | 467.85 | 467.7 | 467.85 | 5842.0 |
| 2021-12-10 06:05:00 | SPY | ETF | 467.8 | 468.0 | 467.8 | 468.0 | 1090.0 |
| 2021-12-10 06:10:00 | SPY | ETF | 468.05 | 468.05 | 467.98 | 467.98 | 1237.0 |
| 2021-12-10 06:15:00 | SPY | ETF | 467.99 | 468.08 | 467.96 | 467.96 | 1550.0 |
| 2021-12-10 06:20:00 | SPY | ETF | 468.05 | 468.05 | 468.03 | 468.05 | 772.0 |
| 2021-12-10 06:25:00 | SPY | ETF | 468.17 | 468.22 | 468.17 | 468.22 | 20439.0 |
| 2021-12-10 06:30:00 | SPY | ETF | 468.23 | 468.25 | 468.04 | 468.06 | 3020.0 |
| 2021-12-10 06:35:00 | SPY | ETF | 468.08 | 468.25 | 468.08 | 468.25 | 2377.0 |
| 2021-12-10 06:40:00 | SPY | ETF | 468.25 | 468.44 | 468.2 | 468.38 | 2851.0 |
| 2021-12-10 06:45:00 | SPY | ETF | 468.34 | 468.41 | 468.32 | 468.41 | 13417.0 |
| 2021-12-10 06:50:00 | SPY | ETF | 468.43 | 468.5 | 468.4 | 468.5 | 4580.0 |
| 2021-12-10 06:55:00 | SPY | ETF | 468.48 | 468.5 | 468.35 | 468.35 | 2333.0 |
| 2021-12-10 07:00:00 | SPY | ETF | 468.33 | 468.38 | 468.19 | 468.2 | 13869.0 |
| 2021-12-10 07:05:00 | SPY | ETF | 468.19 | 468.19 | 468.05 | 468.07 | 15538.0 |
| 2021-12-10 07:10:00 | SPY | ETF | 468.08 | 468.13 | 467.91 | 467.92 | 6592.0 |
| 2021-12-10 07:15:00 | SPY | ETF | 467.92 | 467.95 | 467.82 | 467.91 | 6528.0 |
| 2021-12-10 07:20:00 | SPY | ETF | 467.93 | 468.1 | 467.91 | 468.1 | 10840.0 |
| 2021-12-10 07:25:00 | SPY | ETF | 468.09 | 468.12 | 468.04 | 468.12 | 917.0 |
| 2021-12-10 07:30:00 | SPY | ETF | 468.12 | 468.15 | 467.91 | 467.91 | 6522.0 |
| 2021-12-10 07:35:00 | SPY | ETF | 467.91 | 467.96 | 467.91 | 467.93 | 4832.0 |
| 2021-12-10 07:40:00 | SPY | ETF | 467.97 | 467.97 | 467.87 | 467.87 | 5303.0 |
| 2021-12-10 07:45:00 | SPY | ETF | 467.86 | 467.86 | 467.7 | 467.77 | 24597.0 |
| 2021-12-10 07:50:00 | SPY | ETF | 467.8 | 467.81 | 467.7 | 467.81 | 29153.0 |
| 2021-12-10 07:55:00 | SPY | ETF | 467.78 | 467.83 | 467.74 | 467.83 | 1295.0 |
| 2021-12-10 08:00:00 | SPY | ETF | 468.17 | 468.5096 | 466.33 | 467.78 | 45745.0 |
| 2021-12-10 08:05:00 | SPY | ETF | 467.76 | 467.79 | 467.68 | 467.71 | 7314.0 |
> showing 50 of 84,100 rows — these rows as CSV