PREVIEW / etf_5min / 2021-12-16
file: by_date/etf_5min/2021/2021-12-16.parquet size: 1.9 MB rows: 92,232
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-16 04:00:00 | SPY | ETF | 472.51 | 473.28 | 471.0 | 473.08 | 52030.0 |
| 2021-12-16 04:05:00 | SPY | ETF | 472.96 | 473.11 | 472.86 | 472.86 | 5634.0 |
| 2021-12-16 04:10:00 | SPY | ETF | 472.74 | 473.07 | 472.74 | 473.04 | 4834.0 |
| 2021-12-16 04:15:00 | SPY | ETF | 472.95 | 473.0 | 472.86 | 472.86 | 8226.0 |
| 2021-12-16 04:20:00 | SPY | ETF | 472.88 | 472.93 | 472.76 | 472.8 | 2003.0 |
| 2021-12-16 04:25:00 | SPY | ETF | 472.85 | 472.85 | 472.75 | 472.78 | 3772.0 |
| 2021-12-16 04:30:00 | SPY | ETF | 472.83 | 472.98 | 472.83 | 472.98 | 1124.0 |
| 2021-12-16 04:35:00 | SPY | ETF | 472.91 | 472.91 | 472.84 | 472.84 | 200.0 |
| 2021-12-16 04:40:00 | SPY | ETF | 472.9 | 473.01 | 472.82 | 473.01 | 5992.0 |
| 2021-12-16 04:45:00 | SPY | ETF | 473.04 | 473.06 | 473.0 | 473.03 | 1695.0 |
| 2021-12-16 04:50:00 | SPY | ETF | 472.95 | 473.03 | 472.95 | 472.97 | 1881.0 |
| 2021-12-16 04:55:00 | SPY | ETF | 473.05 | 473.1 | 473.04 | 473.1 | 1695.0 |
| 2021-12-16 05:00:00 | SPY | ETF | 473.08 | 473.17 | 472.95 | 473.17 | 3183.0 |
| 2021-12-16 05:05:00 | SPY | ETF | 473.16 | 473.18 | 473.11 | 473.11 | 886.0 |
| 2021-12-16 05:10:00 | SPY | ETF | 473.13 | 473.23 | 473.11 | 473.19 | 1672.0 |
| 2021-12-16 05:15:00 | SPY | ETF | 473.21 | 473.3 | 473.21 | 473.3 | 933.0 |
| 2021-12-16 05:20:00 | SPY | ETF | 473.32 | 473.32 | 473.18 | 473.23 | 9426.0 |
| 2021-12-16 05:25:00 | SPY | ETF | 473.23 | 473.23 | 473.11 | 473.11 | 1364.0 |
| 2021-12-16 05:30:00 | SPY | ETF | 473.14 | 473.2 | 473.09 | 473.2 | 615.0 |
| 2021-12-16 05:35:00 | SPY | ETF | 473.23 | 473.24 | 473.21 | 473.21 | 1065.0 |
| 2021-12-16 05:40:00 | SPY | ETF | 473.25 | 473.45 | 473.19 | 473.45 | 4509.0 |
| 2021-12-16 05:45:00 | SPY | ETF | 473.47 | 473.47 | 473.33 | 473.35 | 2007.0 |
| 2021-12-16 05:50:00 | SPY | ETF | 473.35 | 473.48 | 473.35 | 473.48 | 1144.0 |
| 2021-12-16 05:55:00 | SPY | ETF | 473.5 | 473.9 | 473.5 | 473.9 | 3337.0 |
| 2021-12-16 06:00:00 | SPY | ETF | 473.92 | 473.93 | 473.75 | 473.8 | 1343.0 |
| 2021-12-16 06:05:00 | SPY | ETF | 473.79 | 473.79 | 473.78 | 473.78 | 302.0 |
| 2021-12-16 06:10:00 | SPY | ETF | 473.85 | 474.12 | 473.78 | 474.01 | 4895.0 |
| 2021-12-16 06:15:00 | SPY | ETF | 474.05 | 474.13 | 474.03 | 474.09 | 3185.0 |
| 2021-12-16 06:20:00 | SPY | ETF | 474.13 | 474.16 | 474.11 | 474.16 | 2181.0 |
| 2021-12-16 06:25:00 | SPY | ETF | 474.26 | 474.48 | 474.25 | 474.44 | 17012.0 |
| 2021-12-16 06:30:00 | SPY | ETF | 474.43 | 474.7 | 474.43 | 474.57 | 29886.0 |
| 2021-12-16 06:35:00 | SPY | ETF | 474.53 | 474.58 | 474.47 | 474.58 | 3369.0 |
| 2021-12-16 06:40:00 | SPY | ETF | 474.56 | 474.59 | 474.5 | 474.55 | 2821.0 |
| 2021-12-16 06:45:00 | SPY | ETF | 474.56 | 474.82 | 474.53 | 474.72 | 30138.0 |
| 2021-12-16 06:50:00 | SPY | ETF | 474.77 | 474.86 | 474.42 | 474.49 | 103365.0 |
| 2021-12-16 06:55:00 | SPY | ETF | 474.48 | 474.49 | 474.41 | 474.44 | 51673.0 |
| 2021-12-16 07:00:00 | SPY | ETF | 474.4 | 474.41 | 474.04 | 474.16 | 49317.0 |
| 2021-12-16 07:05:00 | SPY | ETF | 474.2 | 474.21 | 473.89 | 473.9 | 38202.0 |
| 2021-12-16 07:10:00 | SPY | ETF | 473.93 | 474.18 | 473.87 | 473.9 | 25473.0 |
| 2021-12-16 07:15:00 | SPY | ETF | 474.01 | 474.05 | 473.79 | 473.79 | 10626.0 |
| 2021-12-16 07:20:00 | SPY | ETF | 473.85 | 473.97 | 473.78 | 473.97 | 13679.0 |
| 2021-12-16 07:25:00 | SPY | ETF | 473.99 | 474.03 | 473.79 | 473.81 | 6339.0 |
| 2021-12-16 07:30:00 | SPY | ETF | 473.8 | 473.99 | 473.8 | 473.9 | 18335.0 |
| 2021-12-16 07:35:00 | SPY | ETF | 473.91 | 474.01 | 473.91 | 473.92 | 2292.0 |
| 2021-12-16 07:40:00 | SPY | ETF | 473.94 | 473.96 | 473.7 | 473.7 | 5145.0 |
| 2021-12-16 07:45:00 | SPY | ETF | 473.71 | 473.92 | 473.6 | 473.83 | 29068.0 |
| 2021-12-16 07:50:00 | SPY | ETF | 473.8 | 473.86 | 473.62 | 473.73 | 18579.0 |
| 2021-12-16 07:55:00 | SPY | ETF | 473.72 | 473.74 | 473.65 | 473.71 | 8170.0 |
| 2021-12-16 08:00:00 | SPY | ETF | 473.0396 | 474.8396 | 471.75 | 473.68 | 76914.0 |
| 2021-12-16 08:05:00 | SPY | ETF | 473.6 | 473.67 | 473.24 | 473.24 | 37265.0 |
> showing 50 of 92,232 rows — these rows as CSV