PREVIEW / etf_5min / 2024-10-10
file: by_date/etf_5min/2024/2024-10-10.parquet size: 2.3 MB rows: 112,515
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-10-10 04:00:00 | SPY | ETF | 576.37 | 576.45 | 576.29 | 576.45 | 2286.0 |
| 2024-10-10 04:05:00 | SPY | ETF | 576.41 | 576.51 | 576.41 | 576.46 | 1605.0 |
| 2024-10-10 04:10:00 | SPY | ETF | 576.39 | 576.39 | 576.1 | 576.15 | 3245.0 |
| 2024-10-10 04:15:00 | SPY | ETF | 576.3 | 576.35 | 576.25 | 576.25 | 2361.0 |
| 2024-10-10 04:20:00 | SPY | ETF | 576.31 | 576.31 | 576.25 | 576.27 | 4596.0 |
| 2024-10-10 04:25:00 | SPY | ETF | 576.37 | 576.55 | 576.37 | 576.55 | 876.0 |
| 2024-10-10 04:30:00 | SPY | ETF | 576.51 | 576.6 | 576.51 | 576.6 | 300.0 |
| 2024-10-10 04:35:00 | SPY | ETF | 576.58 | 576.58 | 576.39 | 576.47 | 797.0 |
| 2024-10-10 04:40:00 | SPY | ETF | 576.44 | 576.44 | 576.31 | 576.38 | 708.0 |
| 2024-10-10 04:45:00 | SPY | ETF | 576.34 | 576.34 | 576.34 | 576.34 | 3400.0 |
| 2024-10-10 04:50:00 | SPY | ETF | 576.33 | 576.33 | 576.3 | 576.33 | 1519.0 |
| 2024-10-10 04:55:00 | SPY | ETF | 576.33 | 576.33 | 576.33 | 576.33 | 200.0 |
| 2024-10-10 05:00:00 | SPY | ETF | 576.23 | 576.23 | 576.15 | 576.15 | 987.0 |
| 2024-10-10 05:05:00 | SPY | ETF | 576.1 | 576.13 | 576.08 | 576.13 | 2626.0 |
| 2024-10-10 05:10:00 | SPY | ETF | 576.06 | 576.3 | 576.06 | 576.2 | 2298.0 |
| 2024-10-10 05:15:00 | SPY | ETF | 576.26 | 576.26 | 576.26 | 576.26 | 187.0 |
| 2024-10-10 05:20:00 | SPY | ETF | 576.32 | 576.32 | 576.32 | 576.32 | 100.0 |
| 2024-10-10 05:25:00 | SPY | ETF | 576.32 | 576.32 | 576.32 | 576.32 | 274.0 |
| 2024-10-10 05:30:00 | SPY | ETF | 576.32 | 576.56 | 576.31 | 576.56 | 2099.0 |
| 2024-10-10 05:35:00 | SPY | ETF | 576.6 | 576.6 | 576.46 | 576.5 | 2227.0 |
| 2024-10-10 05:40:00 | SPY | ETF | 576.56 | 576.56 | 576.56 | 576.56 | 411.0 |
| 2024-10-10 05:45:00 | SPY | ETF | 576.34 | 576.34 | 576.34 | 576.34 | 100.0 |
| 2024-10-10 05:50:00 | SPY | ETF | 576.35 | 576.5 | 576.35 | 576.5 | 1244.0 |
| 2024-10-10 05:55:00 | SPY | ETF | 576.54 | 576.54 | 576.54 | 576.54 | 200.0 |
| 2024-10-10 06:00:00 | SPY | ETF | 576.6 | 576.6 | 576.59 | 576.59 | 335.0 |
| 2024-10-10 06:05:00 | SPY | ETF | 576.64 | 576.65 | 576.63 | 576.63 | 1397.0 |
| 2024-10-10 06:10:00 | SPY | ETF | 576.57 | 576.57 | 576.57 | 576.57 | 100.0 |
| 2024-10-10 06:15:00 | SPY | ETF | 576.55 | 576.55 | 576.55 | 576.55 | 100.0 |
| 2024-10-10 06:20:00 | SPY | ETF | 576.45 | 576.45 | 576.33 | 576.38 | 749.0 |
| 2024-10-10 06:30:00 | SPY | ETF | 576.39 | 576.55 | 576.32 | 576.55 | 1153.0 |
| 2024-10-10 06:35:00 | SPY | ETF | 576.57 | 576.57 | 576.57 | 576.57 | 400.0 |
| 2024-10-10 06:40:00 | SPY | ETF | 576.55 | 576.55 | 576.55 | 576.55 | 149.0 |
| 2024-10-10 06:45:00 | SPY | ETF | 576.26 | 576.26 | 576.25 | 576.25 | 5598.0 |
| 2024-10-10 06:50:00 | SPY | ETF | 576.23 | 576.35 | 576.21 | 576.35 | 725.0 |
| 2024-10-10 06:55:00 | SPY | ETF | 576.25 | 576.25 | 576.25 | 576.25 | 100.0 |
| 2024-10-10 07:00:00 | SPY | ETF | 576.24 | 576.26 | 576.2 | 576.26 | 6522.0 |
| 2024-10-10 07:05:00 | SPY | ETF | 576.21 | 576.28 | 576.21 | 576.22 | 1978.0 |
| 2024-10-10 07:10:00 | SPY | ETF | 576.21 | 576.21 | 576.09 | 576.09 | 11004.0 |
| 2024-10-10 07:15:00 | SPY | ETF | 576.09 | 576.35 | 576.09 | 576.35 | 4573.0 |
| 2024-10-10 07:20:00 | SPY | ETF | 576.4 | 576.43 | 576.36 | 576.36 | 13238.0 |
| 2024-10-10 07:25:00 | SPY | ETF | 576.38 | 576.4 | 576.35 | 576.4 | 14385.0 |
| 2024-10-10 07:30:00 | SPY | ETF | 576.4 | 576.52 | 576.4 | 576.52 | 18458.0 |
| 2024-10-10 07:35:00 | SPY | ETF | 576.55 | 576.57 | 576.53 | 576.53 | 14950.0 |
| 2024-10-10 07:40:00 | SPY | ETF | 576.51 | 576.57 | 576.5 | 576.55 | 3232.0 |
| 2024-10-10 07:45:00 | SPY | ETF | 576.56 | 576.57 | 576.45 | 576.45 | 9204.0 |
| 2024-10-10 07:50:00 | SPY | ETF | 576.55 | 576.65 | 576.55 | 576.65 | 24153.0 |
| 2024-10-10 07:55:00 | SPY | ETF | 576.65 | 576.71 | 576.57 | 576.71 | 11848.0 |
| 2024-10-10 08:00:00 | SPY | ETF | 576.52 | 577.37 | 576.09 | 576.85 | 307161.0 |
| 2024-10-10 08:05:00 | SPY | ETF | 576.85 | 577.13 | 576.85 | 577.11 | 25703.0 |
| 2024-10-10 08:10:00 | SPY | ETF | 577.1 | 577.13 | 576.93 | 576.98 | 23951.0 |
> showing 50 of 112,515 rows — these rows as CSV