PREVIEW / etf_5min / 2024-10-31
file: by_date/etf_5min/2024/2024-10-31.parquet size: 2.5 MB rows: 121,750
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-31 04:00:00 | SPY | ETF | 576.78 | 576.78 | 575.13 | 575.53 | 23659.0 |
| 2024-10-31 04:05:00 | SPY | ETF | 575.52 | 575.59 | 575.41 | 575.42 | 2375.0 |
| 2024-10-31 04:10:00 | SPY | ETF | 575.47 | 575.55 | 575.38 | 575.51 | 1927.0 |
| 2024-10-31 04:15:00 | SPY | ETF | 575.64 | 575.71 | 575.61 | 575.67 | 1779.0 |
| 2024-10-31 04:20:00 | SPY | ETF | 575.55 | 575.59 | 575.28 | 575.28 | 2931.0 |
| 2024-10-31 04:25:00 | SPY | ETF | 575.34 | 575.4 | 575.12 | 575.37 | 6585.0 |
| 2024-10-31 04:30:00 | SPY | ETF | 575.2 | 575.2 | 575.12 | 575.2 | 2576.0 |
| 2024-10-31 04:35:00 | SPY | ETF | 575.15 | 575.31 | 575.15 | 575.28 | 3725.0 |
| 2024-10-31 04:40:00 | SPY | ETF | 575.32 | 575.4 | 575.28 | 575.35 | 1403.0 |
| 2024-10-31 04:45:00 | SPY | ETF | 575.35 | 575.67 | 575.35 | 575.62 | 2685.0 |
| 2024-10-31 04:50:00 | SPY | ETF | 575.64 | 575.7 | 575.5 | 575.5 | 2775.0 |
| 2024-10-31 04:55:00 | SPY | ETF | 575.61 | 575.67 | 575.57 | 575.61 | 1299.0 |
| 2024-10-31 05:00:00 | SPY | ETF | 575.35 | 575.45 | 575.26 | 575.28 | 5300.0 |
| 2024-10-31 05:05:00 | SPY | ETF | 575.26 | 575.26 | 575.05 | 575.06 | 3756.0 |
| 2024-10-31 05:10:00 | SPY | ETF | 575.28 | 575.28 | 575.21 | 575.21 | 300.0 |
| 2024-10-31 05:15:00 | SPY | ETF | 575.26 | 575.32 | 575.11 | 575.11 | 415.0 |
| 2024-10-31 05:20:00 | SPY | ETF | 575.16 | 575.16 | 575.04 | 575.13 | 2900.0 |
| 2024-10-31 05:25:00 | SPY | ETF | 575.13 | 575.2 | 575.13 | 575.2 | 5400.0 |
| 2024-10-31 05:30:00 | SPY | ETF | 575.16 | 575.21 | 575.08 | 575.09 | 3034.0 |
| 2024-10-31 05:35:00 | SPY | ETF | 575.21 | 575.3 | 575.2 | 575.25 | 1287.0 |
| 2024-10-31 05:40:00 | SPY | ETF | 575.27 | 575.34 | 575.27 | 575.34 | 900.0 |
| 2024-10-31 05:45:00 | SPY | ETF | 575.44 | 575.44 | 575.32 | 575.32 | 1750.0 |
| 2024-10-31 05:50:00 | SPY | ETF | 575.25 | 575.36 | 575.25 | 575.36 | 387.0 |
| 2024-10-31 05:55:00 | SPY | ETF | 575.48 | 575.54 | 575.48 | 575.5 | 1183.0 |
| 2024-10-31 06:00:00 | SPY | ETF | 575.55 | 575.6 | 575.55 | 575.55 | 4290.0 |
| 2024-10-31 06:05:00 | SPY | ETF | 575.58 | 575.62 | 575.29 | 575.29 | 4799.0 |
| 2024-10-31 06:10:00 | SPY | ETF | 575.22 | 575.22 | 575.2 | 575.22 | 1745.0 |
| 2024-10-31 06:15:00 | SPY | ETF | 575.31 | 575.32 | 575.3 | 575.3 | 765.0 |
| 2024-10-31 06:25:00 | SPY | ETF | 575.35 | 575.58 | 575.35 | 575.58 | 12343.0 |
| 2024-10-31 06:30:00 | SPY | ETF | 575.51 | 575.51 | 575.5 | 575.5 | 450.0 |
| 2024-10-31 06:35:00 | SPY | ETF | 575.42 | 575.42 | 575.39 | 575.39 | 600.0 |
| 2024-10-31 06:40:00 | SPY | ETF | 575.4 | 575.5 | 575.35 | 575.5 | 5393.0 |
| 2024-10-31 06:45:00 | SPY | ETF | 575.52 | 575.53 | 575.38 | 575.38 | 1900.0 |
| 2024-10-31 06:50:00 | SPY | ETF | 575.44 | 575.8 | 575.41 | 575.8 | 24017.0 |
| 2024-10-31 06:55:00 | SPY | ETF | 575.7 | 575.84 | 575.7 | 575.7 | 16709.0 |
| 2024-10-31 07:00:00 | SPY | ETF | 575.83 | 575.99 | 575.77 | 575.86 | 12589.0 |
| 2024-10-31 07:05:00 | SPY | ETF | 575.86 | 575.91 | 575.72 | 575.77 | 41244.0 |
| 2024-10-31 07:10:00 | SPY | ETF | 575.74 | 576.0 | 575.69 | 575.94 | 90100.0 |
| 2024-10-31 07:15:00 | SPY | ETF | 575.98 | 576.1 | 575.89 | 576.01 | 23674.0 |
| 2024-10-31 07:20:00 | SPY | ETF | 576.01 | 576.16 | 575.98 | 576.05 | 48552.0 |
| 2024-10-31 07:25:00 | SPY | ETF | 576.02 | 576.15 | 576.0 | 576.01 | 17175.0 |
| 2024-10-31 07:30:00 | SPY | ETF | 576.04 | 576.04 | 575.79 | 575.82 | 64641.0 |
| 2024-10-31 07:35:00 | SPY | ETF | 575.88 | 575.89 | 575.69 | 575.73 | 23224.0 |
| 2024-10-31 07:40:00 | SPY | ETF | 575.75 | 576.0 | 575.74 | 575.91 | 60873.0 |
| 2024-10-31 07:45:00 | SPY | ETF | 575.93 | 576.08 | 575.92 | 576.04 | 23701.0 |
| 2024-10-31 07:50:00 | SPY | ETF | 576.07 | 576.361 | 576.07 | 576.34 | 11334.0 |
| 2024-10-31 07:55:00 | SPY | ETF | 576.33 | 576.56 | 576.33 | 576.53 | 31809.0 |
| 2024-10-31 08:00:00 | SPY | ETF | 575.86 | 577.59 | 575.05 | 576.45 | 67666.0 |
| 2024-10-31 08:05:00 | SPY | ETF | 576.45 | 576.62 | 576.29 | 576.37 | 25399.0 |
| 2024-10-31 08:10:00 | SPY | ETF | 576.37 | 576.66 | 576.28 | 576.58 | 33713.0 |
> showing 50 of 121,750 rows — these rows as CSV