PREVIEW / etf_5min / 2021-06-08
file: by_date/etf_5min/2021/2021-06-08.parquet size: 1.7 MB rows: 80,472
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-06-08 04:00:00 | SPY | ETF | 422.07 | 422.15 | 422.07 | 422.15 | 598.0 |
| 2021-06-08 04:05:00 | SPY | ETF | 422.05 | 422.05 | 422.05 | 422.05 | 100.0 |
| 2021-06-08 04:10:00 | SPY | ETF | 422.0 | 422.0 | 421.95 | 421.95 | 10100.0 |
| 2021-06-08 04:15:00 | SPY | ETF | 421.95 | 422.04 | 421.95 | 422.04 | 2695.0 |
| 2021-06-08 04:25:00 | SPY | ETF | 422.02 | 422.09 | 422.02 | 422.09 | 600.0 |
| 2021-06-08 04:30:00 | SPY | ETF | 422.05 | 422.24 | 422.05 | 422.24 | 360.0 |
| 2021-06-08 04:35:00 | SPY | ETF | 422.22 | 422.22 | 422.14 | 422.15 | 20240.0 |
| 2021-06-08 04:40:00 | SPY | ETF | 422.26 | 422.29 | 422.26 | 422.29 | 992.0 |
| 2021-06-08 04:45:00 | SPY | ETF | 422.25 | 422.27 | 422.25 | 422.25 | 10500.0 |
| 2021-06-08 04:50:00 | SPY | ETF | 422.24 | 422.29 | 422.22 | 422.29 | 5794.0 |
| 2021-06-08 04:55:00 | SPY | ETF | 422.35 | 422.41 | 422.33 | 422.41 | 24997.0 |
| 2021-06-08 05:00:00 | SPY | ETF | 422.35 | 422.5 | 422.28 | 422.5 | 30295.0 |
| 2021-06-08 05:05:00 | SPY | ETF | 422.64 | 422.65 | 422.64 | 422.65 | 300.0 |
| 2021-06-08 05:10:00 | SPY | ETF | 422.64 | 422.64 | 422.64 | 422.64 | 100.0 |
| 2021-06-08 05:15:00 | SPY | ETF | 422.74 | 422.79 | 422.68 | 422.68 | 1381.0 |
| 2021-06-08 05:20:00 | SPY | ETF | 422.66 | 422.79 | 422.66 | 422.79 | 400.0 |
| 2021-06-08 05:30:00 | SPY | ETF | 422.71 | 422.74 | 422.71 | 422.74 | 600.0 |
| 2021-06-08 05:45:00 | SPY | ETF | 422.59 | 422.74 | 422.59 | 422.65 | 1200.0 |
| 2021-06-08 05:50:00 | SPY | ETF | 422.69 | 422.69 | 422.69 | 422.69 | 250.0 |
| 2021-06-08 05:55:00 | SPY | ETF | 422.72 | 422.72 | 422.66 | 422.66 | 350.0 |
| 2021-06-08 06:00:00 | SPY | ETF | 422.59 | 422.59 | 422.5 | 422.5 | 300.0 |
| 2021-06-08 06:05:00 | SPY | ETF | 422.43 | 422.56 | 422.43 | 422.54 | 710.0 |
| 2021-06-08 06:10:00 | SPY | ETF | 422.34 | 422.42 | 422.27 | 422.42 | 10300.0 |
| 2021-06-08 06:15:00 | SPY | ETF | 422.19 | 422.19 | 421.44 | 421.44 | 14248.0 |
| 2021-06-08 06:20:00 | SPY | ETF | 421.31 | 421.62 | 421.27 | 421.44 | 5044.0 |
| 2021-06-08 06:25:00 | SPY | ETF | 421.29 | 421.52 | 421.0 | 421.3 | 12122.0 |
| 2021-06-08 06:30:00 | SPY | ETF | 421.29 | 421.5 | 421.05 | 421.48 | 136711.0 |
| 2021-06-08 06:35:00 | SPY | ETF | 421.46 | 422.39 | 421.46 | 422.39 | 12686.0 |
| 2021-06-08 06:40:00 | SPY | ETF | 422.31 | 422.31 | 422.12 | 422.13 | 4550.0 |
| 2021-06-08 06:45:00 | SPY | ETF | 422.14 | 422.3 | 422.12 | 422.3 | 3000.0 |
| 2021-06-08 06:50:00 | SPY | ETF | 422.38 | 422.39 | 422.29 | 422.29 | 1612.0 |
| 2021-06-08 06:55:00 | SPY | ETF | 422.37 | 422.53 | 422.37 | 422.5 | 107520.0 |
| 2021-06-08 07:00:00 | SPY | ETF | 422.5 | 422.55 | 422.37 | 422.48 | 9835.0 |
| 2021-06-08 07:05:00 | SPY | ETF | 422.58 | 422.75 | 422.58 | 422.75 | 9717.0 |
| 2021-06-08 07:10:00 | SPY | ETF | 422.69 | 422.85 | 422.66 | 422.85 | 5114.0 |
| 2021-06-08 07:15:00 | SPY | ETF | 422.86 | 422.87 | 422.74 | 422.77 | 8612.0 |
| 2021-06-08 07:20:00 | SPY | ETF | 422.78 | 422.82 | 422.75 | 422.75 | 10980.0 |
| 2021-06-08 07:25:00 | SPY | ETF | 422.82 | 422.82 | 422.67 | 422.69 | 1503.0 |
| 2021-06-08 07:30:00 | SPY | ETF | 422.74 | 422.76 | 422.7 | 422.7 | 8140.0 |
| 2021-06-08 07:35:00 | SPY | ETF | 422.68 | 422.84 | 422.67 | 422.84 | 4716.0 |
| 2021-06-08 07:40:00 | SPY | ETF | 422.86 | 422.99 | 422.84 | 422.97 | 14516.0 |
| 2021-06-08 07:45:00 | SPY | ETF | 422.97 | 422.98 | 422.91 | 422.92 | 26279.0 |
| 2021-06-08 07:50:00 | SPY | ETF | 422.93 | 423.0 | 422.91 | 422.91 | 8291.0 |
| 2021-06-08 07:55:00 | SPY | ETF | 422.9 | 423.03 | 422.89 | 423.03 | 2467.0 |
| 2021-06-08 08:00:00 | SPY | ETF | 422.66 | 423.03 | 421.4896 | 422.9 | 29588.0 |
| 2021-06-08 08:05:00 | SPY | ETF | 422.5 | 423.06 | 422.5 | 422.99 | 34643.0 |
| 2021-06-08 08:10:00 | SPY | ETF | 422.98 | 423.06 | 422.95 | 423.03 | 3384.0 |
| 2021-06-08 08:15:00 | SPY | ETF | 423.03 | 423.25 | 423.0 | 423.25 | 14872.0 |
| 2021-06-08 08:20:00 | SPY | ETF | 423.25 | 423.36 | 423.17 | 423.335 | 38287.0 |
| 2021-06-08 08:25:00 | SPY | ETF | 423.34 | 423.38 | 423.28 | 423.28 | 5361.0 |
> showing 50 of 80,472 rows — these rows as CSV