PREVIEW / etf_5min / 2021-09-16
file: by_date/etf_5min/2021/2021-09-16.parquet size: 1.7 MB rows: 78,742
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-09-16 04:00:00 | SPY | ETF | 447.97 | 447.97 | 447.7 | 447.96 | 24092.0 |
| 2021-09-16 04:05:00 | SPY | ETF | 447.92 | 448.03 | 447.91 | 447.94 | 7535.0 |
| 2021-09-16 04:10:00 | SPY | ETF | 447.97 | 447.98 | 447.94 | 447.94 | 3111.0 |
| 2021-09-16 04:15:00 | SPY | ETF | 447.93 | 447.93 | 447.81 | 447.93 | 2963.0 |
| 2021-09-16 04:20:00 | SPY | ETF | 447.93 | 447.95 | 447.86 | 447.86 | 2948.0 |
| 2021-09-16 04:25:00 | SPY | ETF | 447.76 | 447.83 | 447.72 | 447.83 | 4400.0 |
| 2021-09-16 04:30:00 | SPY | ETF | 447.85 | 447.9 | 447.85 | 447.9 | 300.0 |
| 2021-09-16 04:35:00 | SPY | ETF | 447.75 | 447.75 | 447.62 | 447.62 | 17700.0 |
| 2021-09-16 04:40:00 | SPY | ETF | 447.71 | 447.83 | 447.71 | 447.83 | 800.0 |
| 2021-09-16 04:45:00 | SPY | ETF | 447.92 | 447.92 | 447.92 | 447.92 | 100.0 |
| 2021-09-16 04:50:00 | SPY | ETF | 447.64 | 447.64 | 447.63 | 447.64 | 2400.0 |
| 2021-09-16 05:00:00 | SPY | ETF | 447.63 | 447.68 | 447.61 | 447.68 | 3800.0 |
| 2021-09-16 05:10:00 | SPY | ETF | 447.65 | 447.65 | 447.6 | 447.6 | 2000.0 |
| 2021-09-16 05:20:00 | SPY | ETF | 447.58 | 447.59 | 447.58 | 447.59 | 1900.0 |
| 2021-09-16 05:30:00 | SPY | ETF | 447.48 | 447.49 | 447.48 | 447.48 | 3400.0 |
| 2021-09-16 05:35:00 | SPY | ETF | 447.45 | 447.45 | 447.41 | 447.42 | 2840.0 |
| 2021-09-16 05:40:00 | SPY | ETF | 447.43 | 447.43 | 447.37 | 447.37 | 2450.0 |
| 2021-09-16 05:45:00 | SPY | ETF | 447.38 | 447.39 | 447.11 | 447.16 | 7262.0 |
| 2021-09-16 05:50:00 | SPY | ETF | 447.18 | 447.25 | 447.18 | 447.2 | 7400.0 |
| 2021-09-16 05:55:00 | SPY | ETF | 447.19 | 447.22 | 447.13 | 447.2 | 2288.0 |
| 2021-09-16 06:00:00 | SPY | ETF | 447.25 | 447.28 | 447.24 | 447.28 | 1300.0 |
| 2021-09-16 06:05:00 | SPY | ETF | 447.3 | 447.38 | 447.3 | 447.35 | 1663.0 |
| 2021-09-16 06:10:00 | SPY | ETF | 447.35 | 447.35 | 447.28 | 447.29 | 1968.0 |
| 2021-09-16 06:15:00 | SPY | ETF | 447.3 | 447.35 | 447.3 | 447.34 | 15821.0 |
| 2021-09-16 06:20:00 | SPY | ETF | 447.33 | 447.35 | 447.32 | 447.32 | 10617.0 |
| 2021-09-16 06:25:00 | SPY | ETF | 447.31 | 447.31 | 447.22 | 447.22 | 21528.0 |
| 2021-09-16 06:30:00 | SPY | ETF | 447.25 | 447.25 | 447.14 | 447.2 | 36404.0 |
| 2021-09-16 06:35:00 | SPY | ETF | 447.25 | 447.26 | 447.18 | 447.21 | 38153.0 |
| 2021-09-16 06:40:00 | SPY | ETF | 447.19 | 447.22 | 447.12 | 447.21 | 10169.0 |
| 2021-09-16 06:45:00 | SPY | ETF | 447.21 | 447.27 | 447.21 | 447.24 | 12169.0 |
| 2021-09-16 06:50:00 | SPY | ETF | 447.25 | 447.25 | 447.22 | 447.24 | 17902.0 |
| 2021-09-16 06:55:00 | SPY | ETF | 447.25 | 447.37 | 447.25 | 447.37 | 11997.0 |
| 2021-09-16 07:00:00 | SPY | ETF | 447.38 | 447.58 | 447.32 | 447.55 | 43298.0 |
| 2021-09-16 07:05:00 | SPY | ETF | 447.55 | 447.57 | 447.44 | 447.46 | 10778.0 |
| 2021-09-16 07:10:00 | SPY | ETF | 447.47 | 447.51 | 447.46 | 447.46 | 4166.0 |
| 2021-09-16 07:15:00 | SPY | ETF | 447.51 | 447.6 | 447.5 | 447.5 | 7858.0 |
| 2021-09-16 07:20:00 | SPY | ETF | 447.5 | 447.5 | 447.39 | 447.4 | 9246.0 |
| 2021-09-16 07:25:00 | SPY | ETF | 447.4 | 447.4 | 447.27 | 447.3 | 9714.0 |
| 2021-09-16 07:30:00 | SPY | ETF | 447.37 | 447.37 | 447.2 | 447.21 | 16098.0 |
| 2021-09-16 07:35:00 | SPY | ETF | 447.2 | 447.2 | 447.01 | 447.06 | 41157.0 |
| 2021-09-16 07:40:00 | SPY | ETF | 447.08 | 447.18 | 447.07 | 447.1 | 7697.0 |
| 2021-09-16 07:45:00 | SPY | ETF | 447.05 | 447.08 | 446.9 | 446.98 | 24568.0 |
| 2021-09-16 07:50:00 | SPY | ETF | 446.96 | 447.02 | 446.91 | 447.01 | 6495.0 |
| 2021-09-16 07:55:00 | SPY | ETF | 447.0 | 447.0 | 446.88 | 446.95 | 9097.0 |
| 2021-09-16 08:00:00 | SPY | ETF | 447.37 | 448.215 | 446.75 | 446.79 | 162101.0 |
| 2021-09-16 08:05:00 | SPY | ETF | 446.79 | 446.84 | 446.69 | 446.78 | 47785.0 |
| 2021-09-16 08:10:00 | SPY | ETF | 446.81 | 446.81 | 446.75 | 446.75 | 27992.0 |
| 2021-09-16 08:15:00 | SPY | ETF | 446.8 | 446.9 | 446.78 | 446.86 | 26108.0 |
| 2021-09-16 08:20:00 | SPY | ETF | 446.84 | 446.95 | 446.53 | 446.61 | 107307.0 |
| 2021-09-16 08:25:00 | SPY | ETF | 446.61 | 446.67 | 446.35 | 446.67 | 170080.0 |
> showing 50 of 78,742 rows — these rows as CSV