PREVIEW / etf_5min / 2024-10-14
file: by_date/etf_5min/2024/2024-10-14.parquet size: 2.3 MB rows: 112,257
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-14 04:00:00 | SPY | ETF | 579.34 | 580.06 | 579.3 | 579.98 | 24890.0 |
| 2024-10-14 04:05:00 | SPY | ETF | 579.95 | 580.12 | 579.93 | 579.98 | 9894.0 |
| 2024-10-14 04:10:00 | SPY | ETF | 579.98 | 579.98 | 579.91 | 579.96 | 3089.0 |
| 2024-10-14 04:15:00 | SPY | ETF | 579.91 | 580.01 | 579.91 | 580.01 | 398.0 |
| 2024-10-14 04:20:00 | SPY | ETF | 580.1 | 580.16 | 580.1 | 580.16 | 1075.0 |
| 2024-10-14 04:25:00 | SPY | ETF | 580.17 | 580.17 | 580.1 | 580.11 | 600.0 |
| 2024-10-14 04:30:00 | SPY | ETF | 580.01 | 580.03 | 580.0 | 580.0 | 2805.0 |
| 2024-10-14 04:35:00 | SPY | ETF | 579.97 | 579.97 | 579.96 | 579.96 | 1067.0 |
| 2024-10-14 04:40:00 | SPY | ETF | 580.02 | 580.02 | 580.02 | 580.02 | 276.0 |
| 2024-10-14 04:45:00 | SPY | ETF | 579.99 | 580.12 | 579.99 | 580.06 | 3119.0 |
| 2024-10-14 04:50:00 | SPY | ETF | 580.0 | 580.0 | 579.98 | 580.0 | 2246.0 |
| 2024-10-14 04:55:00 | SPY | ETF | 579.9 | 579.9 | 579.86 | 579.86 | 4104.0 |
| 2024-10-14 05:00:00 | SPY | ETF | 579.96 | 580.21 | 579.95 | 580.21 | 2700.0 |
| 2024-10-14 05:05:00 | SPY | ETF | 580.2 | 580.28 | 580.2 | 580.2 | 2823.0 |
| 2024-10-14 05:10:00 | SPY | ETF | 580.17 | 580.17 | 580.17 | 580.17 | 400.0 |
| 2024-10-14 05:15:00 | SPY | ETF | 580.22 | 580.22 | 580.22 | 580.22 | 258.0 |
| 2024-10-14 05:20:00 | SPY | ETF | 580.11 | 580.11 | 580.11 | 580.11 | 159.0 |
| 2024-10-14 05:25:00 | SPY | ETF | 580.22 | 580.22 | 580.22 | 580.22 | 389.0 |
| 2024-10-14 05:30:00 | SPY | ETF | 580.2 | 580.22 | 580.2 | 580.22 | 299.0 |
| 2024-10-14 05:35:00 | SPY | ETF | 580.34 | 580.34 | 580.22 | 580.22 | 872.0 |
| 2024-10-14 05:40:00 | SPY | ETF | 580.25 | 580.25 | 580.22 | 580.22 | 496.0 |
| 2024-10-14 05:45:00 | SPY | ETF | 580.27 | 580.39 | 580.27 | 580.39 | 2045.0 |
| 2024-10-14 05:50:00 | SPY | ETF | 580.34 | 580.36 | 580.33 | 580.35 | 11199.0 |
| 2024-10-14 05:55:00 | SPY | ETF | 580.34 | 580.34 | 580.29 | 580.29 | 17300.0 |
| 2024-10-14 06:00:00 | SPY | ETF | 580.29 | 580.45 | 580.29 | 580.45 | 47427.0 |
| 2024-10-14 06:05:00 | SPY | ETF | 580.44 | 580.54 | 580.44 | 580.54 | 800.0 |
| 2024-10-14 06:10:00 | SPY | ETF | 580.54 | 580.54 | 580.5 | 580.5 | 500.0 |
| 2024-10-14 06:15:00 | SPY | ETF | 580.57 | 580.93 | 580.57 | 580.87 | 6294.0 |
| 2024-10-14 06:20:00 | SPY | ETF | 580.85 | 580.87 | 580.85 | 580.87 | 1687.0 |
| 2024-10-14 06:25:00 | SPY | ETF | 580.87 | 580.87 | 580.65 | 580.65 | 1085.0 |
| 2024-10-14 06:30:00 | SPY | ETF | 580.75 | 580.82 | 580.74 | 580.8 | 3060.0 |
| 2024-10-14 06:35:00 | SPY | ETF | 580.8 | 580.8 | 580.71 | 580.75 | 2876.0 |
| 2024-10-14 06:40:00 | SPY | ETF | 580.75 | 580.75 | 580.75 | 580.75 | 1087.0 |
| 2024-10-14 06:45:00 | SPY | ETF | 580.71 | 580.71 | 580.59 | 580.6 | 2687.0 |
| 2024-10-14 06:50:00 | SPY | ETF | 580.52 | 580.62 | 580.5 | 580.6 | 5714.0 |
| 2024-10-14 06:55:00 | SPY | ETF | 580.59 | 580.59 | 580.5 | 580.5 | 4294.0 |
| 2024-10-14 07:00:00 | SPY | ETF | 580.5 | 580.53 | 580.16 | 580.3 | 83375.0 |
| 2024-10-14 07:05:00 | SPY | ETF | 580.38 | 580.4 | 580.36 | 580.39 | 1131.0 |
| 2024-10-14 07:10:00 | SPY | ETF | 580.35 | 580.37 | 580.32 | 580.32 | 3406.0 |
| 2024-10-14 07:15:00 | SPY | ETF | 580.38 | 580.38 | 580.28 | 580.28 | 11893.0 |
| 2024-10-14 07:20:00 | SPY | ETF | 580.35 | 580.35 | 580.33 | 580.34 | 590.0 |
| 2024-10-14 07:25:00 | SPY | ETF | 580.321 | 580.36 | 580.25 | 580.29 | 5752.0 |
| 2024-10-14 07:30:00 | SPY | ETF | 580.29 | 580.34 | 580.29 | 580.32 | 1046.0 |
| 2024-10-14 07:35:00 | SPY | ETF | 580.31 | 580.45 | 580.31 | 580.45 | 18204.0 |
| 2024-10-14 07:40:00 | SPY | ETF | 580.49 | 580.53 | 580.45 | 580.52 | 2414.0 |
| 2024-10-14 07:45:00 | SPY | ETF | 580.55 | 580.57 | 580.5 | 580.5 | 3859.0 |
| 2024-10-14 07:50:00 | SPY | ETF | 580.53 | 580.53 | 580.4 | 580.41 | 1511.0 |
| 2024-10-14 07:55:00 | SPY | ETF | 580.46 | 580.49 | 580.41 | 580.49 | 7133.0 |
| 2024-10-14 08:00:00 | SPY | ETF | 580.44 | 580.71 | 579.2 | 580.5 | 26331.0 |
| 2024-10-14 08:05:00 | SPY | ETF | 580.51 | 580.6 | 580.35 | 580.4 | 94654.0 |
> showing 50 of 112,257 rows — these rows as CSV