PREVIEW / etf_5min / 2021-09-07
file: by_date/etf_5min/2021/2021-09-07.parquet size: 1.7 MB rows: 81,803
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-07 04:00:00 | SPY | ETF | 452.0 | 453.61 | 452.0 | 453.47 | 3572.0 |
| 2021-09-07 04:05:00 | SPY | ETF | 453.39 | 453.39 | 453.06 | 453.08 | 1510.0 |
| 2021-09-07 04:10:00 | SPY | ETF | 453.03 | 453.45 | 453.03 | 453.45 | 609.0 |
| 2021-09-07 04:15:00 | SPY | ETF | 453.5 | 453.5 | 453.41 | 453.41 | 900.0 |
| 2021-09-07 04:25:00 | SPY | ETF | 453.22 | 453.26 | 453.22 | 453.25 | 1200.0 |
| 2021-09-07 04:30:00 | SPY | ETF | 453.37 | 453.47 | 453.37 | 453.44 | 718.0 |
| 2021-09-07 04:35:00 | SPY | ETF | 453.42 | 453.42 | 453.42 | 453.42 | 200.0 |
| 2021-09-07 04:45:00 | SPY | ETF | 453.41 | 453.41 | 453.4 | 453.4 | 300.0 |
| 2021-09-07 04:50:00 | SPY | ETF | 453.31 | 453.31 | 453.31 | 453.31 | 100.0 |
| 2021-09-07 04:55:00 | SPY | ETF | 453.36 | 453.37 | 453.36 | 453.36 | 918.0 |
| 2021-09-07 05:00:00 | SPY | ETF | 453.16 | 453.3 | 453.16 | 453.26 | 400.0 |
| 2021-09-07 05:05:00 | SPY | ETF | 453.36 | 453.36 | 453.36 | 453.36 | 200.0 |
| 2021-09-07 05:10:00 | SPY | ETF | 453.05 | 453.14 | 453.05 | 453.14 | 2099.0 |
| 2021-09-07 05:15:00 | SPY | ETF | 453.1 | 453.1 | 453.03 | 453.08 | 300.0 |
| 2021-09-07 05:20:00 | SPY | ETF | 453.07 | 453.07 | 452.76 | 452.76 | 5495.0 |
| 2021-09-07 05:25:00 | SPY | ETF | 452.87 | 452.87 | 452.87 | 452.87 | 100.0 |
| 2021-09-07 05:30:00 | SPY | ETF | 452.81 | 452.81 | 452.6 | 452.6 | 600.0 |
| 2021-09-07 05:40:00 | SPY | ETF | 452.8 | 452.8 | 452.8 | 452.8 | 500.0 |
| 2021-09-07 05:45:00 | SPY | ETF | 452.77 | 452.79 | 452.7 | 452.7 | 1850.0 |
| 2021-09-07 05:50:00 | SPY | ETF | 452.7 | 452.7 | 452.66 | 452.67 | 1301.0 |
| 2021-09-07 06:00:00 | SPY | ETF | 452.85 | 452.95 | 452.84 | 452.95 | 1411.0 |
| 2021-09-07 06:05:00 | SPY | ETF | 452.9 | 453.01 | 452.88 | 453.01 | 965.0 |
| 2021-09-07 06:10:00 | SPY | ETF | 453.01 | 453.01 | 452.92 | 452.98 | 400.0 |
| 2021-09-07 06:15:00 | SPY | ETF | 452.9 | 452.9 | 452.9 | 452.9 | 100.0 |
| 2021-09-07 06:20:00 | SPY | ETF | 453.02 | 453.02 | 453.02 | 453.02 | 200.0 |
| 2021-09-07 06:25:00 | SPY | ETF | 453.02 | 453.09 | 452.8 | 452.9 | 3115.0 |
| 2021-09-07 06:30:00 | SPY | ETF | 452.99 | 453.05 | 452.99 | 453.04 | 1055.0 |
| 2021-09-07 06:35:00 | SPY | ETF | 452.94 | 452.94 | 452.93 | 452.93 | 999.0 |
| 2021-09-07 06:40:00 | SPY | ETF | 453.0 | 453.01 | 452.9 | 452.9 | 1100.0 |
| 2021-09-07 06:45:00 | SPY | ETF | 452.89 | 452.89 | 452.88 | 452.88 | 2000.0 |
| 2021-09-07 06:50:00 | SPY | ETF | 452.86 | 452.88 | 452.85 | 452.85 | 800.0 |
| 2021-09-07 06:55:00 | SPY | ETF | 452.9 | 452.98 | 452.9 | 452.98 | 879.0 |
| 2021-09-07 07:00:00 | SPY | ETF | 453.03 | 453.1 | 452.99 | 453.04 | 2505.0 |
| 2021-09-07 07:05:00 | SPY | ETF | 453.0 | 453.03 | 453.0 | 453.02 | 800.0 |
| 2021-09-07 07:10:00 | SPY | ETF | 453.02 | 453.13 | 453.02 | 453.1 | 6282.0 |
| 2021-09-07 07:15:00 | SPY | ETF | 453.09 | 453.3 | 453.07 | 453.3 | 11055.0 |
| 2021-09-07 07:20:00 | SPY | ETF | 453.26 | 453.26 | 453.22 | 453.23 | 3460.0 |
| 2021-09-07 07:25:00 | SPY | ETF | 453.35 | 453.43 | 453.34 | 453.34 | 8550.0 |
| 2021-09-07 07:30:00 | SPY | ETF | 453.35 | 453.35 | 453.27 | 453.31 | 8796.0 |
| 2021-09-07 07:35:00 | SPY | ETF | 453.35 | 453.38 | 453.31 | 453.31 | 2796.0 |
| 2021-09-07 07:40:00 | SPY | ETF | 453.26 | 453.38 | 453.26 | 453.36 | 8990.0 |
| 2021-09-07 07:45:00 | SPY | ETF | 453.31 | 453.37 | 453.31 | 453.35 | 1177.0 |
| 2021-09-07 07:50:00 | SPY | ETF | 453.38 | 453.39 | 453.35 | 453.35 | 4344.0 |
| 2021-09-07 07:55:00 | SPY | ETF | 453.33 | 453.38 | 453.3 | 453.32 | 7295.0 |
| 2021-09-07 08:00:00 | SPY | ETF | 453.2699 | 453.5 | 452.8296 | 453.34 | 26938.0 |
| 2021-09-07 08:05:00 | SPY | ETF | 453.38 | 453.38 | 453.35 | 453.37 | 16894.0 |
| 2021-09-07 08:10:00 | SPY | ETF | 453.38 | 453.38 | 453.18 | 453.19 | 11635.0 |
| 2021-09-07 08:15:00 | SPY | ETF | 453.23 | 453.23 | 453.14 | 453.22 | 7143.0 |
| 2021-09-07 08:20:00 | SPY | ETF | 453.22 | 453.23 | 453.19 | 453.22 | 3596.0 |
| 2021-09-07 08:25:00 | SPY | ETF | 453.21 | 453.26 | 453.21 | 453.26 | 4741.0 |
> showing 50 of 81,803 rows — these rows as CSV