PREVIEW / etf_5min / 2024-08-08
file: by_date/etf_5min/2024/2024-08-08.parquet size: 2.3 MB rows: 115,958
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-08 04:00:00 | SPY | ETF | 516.59 | 517.36 | 516.5 | 517.18 | 5769.0 |
| 2024-08-08 04:05:00 | SPY | ETF | 516.77 | 517.49 | 516.77 | 516.96 | 2241.0 |
| 2024-08-08 04:10:00 | SPY | ETF | 516.68 | 517.32 | 516.63 | 517.17 | 6466.0 |
| 2024-08-08 04:15:00 | SPY | ETF | 516.98 | 517.39 | 516.92 | 517.27 | 3790.0 |
| 2024-08-08 04:20:00 | SPY | ETF | 517.3 | 517.3 | 516.84 | 516.84 | 3389.0 |
| 2024-08-08 04:25:00 | SPY | ETF | 516.65 | 517.19 | 516.63 | 516.63 | 1767.0 |
| 2024-08-08 04:30:00 | SPY | ETF | 516.88 | 517.1 | 516.78 | 517.1 | 492.0 |
| 2024-08-08 04:35:00 | SPY | ETF | 517.23 | 517.33 | 517.02 | 517.02 | 2108.0 |
| 2024-08-08 04:40:00 | SPY | ETF | 517.5 | 517.7 | 517.5 | 517.7 | 680.0 |
| 2024-08-08 04:45:00 | SPY | ETF | 517.64 | 518.0 | 517.64 | 518.0 | 807.0 |
| 2024-08-08 04:50:00 | SPY | ETF | 518.04 | 518.35 | 518.04 | 518.35 | 6063.0 |
| 2024-08-08 04:55:00 | SPY | ETF | 518.26 | 518.5 | 518.26 | 518.35 | 1504.0 |
| 2024-08-08 05:00:00 | SPY | ETF | 518.52 | 519.0 | 518.51 | 518.64 | 11970.0 |
| 2024-08-08 05:05:00 | SPY | ETF | 518.51 | 518.51 | 518.38 | 518.38 | 748.0 |
| 2024-08-08 05:10:00 | SPY | ETF | 518.22 | 518.31 | 518.2 | 518.31 | 4570.0 |
| 2024-08-08 05:15:00 | SPY | ETF | 518.48 | 518.6 | 518.1 | 518.28 | 2575.0 |
| 2024-08-08 05:20:00 | SPY | ETF | 518.29 | 518.29 | 517.9 | 517.9 | 508.0 |
| 2024-08-08 05:25:00 | SPY | ETF | 517.79 | 517.79 | 517.79 | 517.79 | 100.0 |
| 2024-08-08 05:35:00 | SPY | ETF | 517.94 | 517.94 | 517.71 | 517.71 | 212.0 |
| 2024-08-08 05:40:00 | SPY | ETF | 517.64 | 517.69 | 517.23 | 517.23 | 1308.0 |
| 2024-08-08 05:45:00 | SPY | ETF | 517.11 | 517.11 | 516.6 | 516.6 | 1186.0 |
| 2024-08-08 05:50:00 | SPY | ETF | 516.55 | 517.07 | 516.35 | 517.07 | 2018.0 |
| 2024-08-08 05:55:00 | SPY | ETF | 517.0 | 517.26 | 517.0 | 517.0 | 2553.0 |
| 2024-08-08 06:00:00 | SPY | ETF | 517.1 | 517.1 | 516.92 | 516.92 | 600.0 |
| 2024-08-08 06:05:00 | SPY | ETF | 516.66 | 516.91 | 516.42 | 516.42 | 1781.0 |
| 2024-08-08 06:10:00 | SPY | ETF | 516.46 | 517.2 | 516.46 | 517.2 | 7061.0 |
| 2024-08-08 06:15:00 | SPY | ETF | 517.2 | 517.4 | 517.1 | 517.4 | 7705.0 |
| 2024-08-08 06:20:00 | SPY | ETF | 517.42 | 517.71 | 517.42 | 517.55 | 6907.0 |
| 2024-08-08 06:25:00 | SPY | ETF | 517.67 | 517.8 | 517.5 | 517.54 | 6571.0 |
| 2024-08-08 06:30:00 | SPY | ETF | 517.6 | 517.8 | 517.6 | 517.79 | 2039.0 |
| 2024-08-08 06:35:00 | SPY | ETF | 517.71 | 517.8 | 517.53 | 517.8 | 746.0 |
| 2024-08-08 06:40:00 | SPY | ETF | 517.77 | 517.83 | 517.47 | 517.47 | 1907.0 |
| 2024-08-08 06:45:00 | SPY | ETF | 517.6 | 518.27 | 517.6 | 517.98 | 11187.0 |
| 2024-08-08 06:50:00 | SPY | ETF | 518.23 | 518.42 | 518.04 | 518.1 | 2753.0 |
| 2024-08-08 06:55:00 | SPY | ETF | 518.1 | 518.2 | 517.73 | 518.18 | 11604.0 |
| 2024-08-08 07:00:00 | SPY | ETF | 518.0 | 518.12 | 517.72 | 517.72 | 9865.0 |
| 2024-08-08 07:05:00 | SPY | ETF | 517.83 | 518.2 | 517.81 | 518.2 | 9897.0 |
| 2024-08-08 07:10:00 | SPY | ETF | 518.24 | 519.18 | 518.24 | 519.0 | 34546.0 |
| 2024-08-08 07:15:00 | SPY | ETF | 518.96 | 519.12 | 518.79 | 518.98 | 14147.0 |
| 2024-08-08 07:20:00 | SPY | ETF | 518.86 | 518.91 | 518.46 | 518.65 | 4945.0 |
| 2024-08-08 07:25:00 | SPY | ETF | 518.5 | 518.7 | 518.5 | 518.56 | 11238.0 |
| 2024-08-08 07:30:00 | SPY | ETF | 518.53 | 518.71 | 518.3 | 518.66 | 22425.0 |
| 2024-08-08 07:35:00 | SPY | ETF | 518.79 | 518.88 | 518.57 | 518.7 | 16017.0 |
| 2024-08-08 07:40:00 | SPY | ETF | 518.84 | 519.0 | 518.65 | 519.0 | 12674.0 |
| 2024-08-08 07:45:00 | SPY | ETF | 518.86 | 519.19 | 518.86 | 519.0 | 28676.0 |
| 2024-08-08 07:50:00 | SPY | ETF | 518.96 | 519.32 | 518.96 | 519.04 | 117334.0 |
| 2024-08-08 07:55:00 | SPY | ETF | 519.0 | 519.2 | 518.85 | 519.15 | 45304.0 |
| 2024-08-08 08:00:00 | SPY | ETF | 519.24 | 519.42 | 516.26 | 518.95 | 84518.0 |
| 2024-08-08 08:05:00 | SPY | ETF | 518.92 | 519.24 | 518.92 | 519.23 | 21630.0 |
| 2024-08-08 08:10:00 | SPY | ETF | 518.97 | 519.36 | 518.95 | 519.31 | 50238.0 |
> showing 50 of 115,958 rows — these rows as CSV