PREVIEW / etf_1min / 2024-10-31
file: by_date/etf_1min/2024/2024-10-31.parquet size: 5.7 MB rows: 324,832
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.5 | 575.52 | 14086.0 |
| 2024-10-31 04:01:00 | SPY | ETF | 575.51 | 575.61 | 575.49 | 575.61 | 2723.0 |
| 2024-10-31 04:02:00 | SPY | ETF | 575.53 | 575.53 | 575.25 | 575.25 | 2110.0 |
| 2024-10-31 04:03:00 | SPY | ETF | 575.25 | 575.32 | 575.13 | 575.32 | 2943.0 |
| 2024-10-31 04:04:00 | SPY | ETF | 575.4 | 575.58 | 575.3 | 575.53 | 1797.0 |
| 2024-10-31 04:05:00 | SPY | ETF | 575.52 | 575.52 | 575.41 | 575.41 | 402.0 |
| 2024-10-31 04:06:00 | SPY | ETF | 575.47 | 575.47 | 575.46 | 575.46 | 200.0 |
| 2024-10-31 04:07:00 | SPY | ETF | 575.55 | 575.59 | 575.52 | 575.52 | 1491.0 |
| 2024-10-31 04:08:00 | SPY | ETF | 575.49 | 575.49 | 575.42 | 575.42 | 282.0 |
| 2024-10-31 04:10:00 | SPY | ETF | 575.47 | 575.49 | 575.47 | 575.49 | 431.0 |
| 2024-10-31 04:11:00 | SPY | ETF | 575.55 | 575.55 | 575.55 | 575.55 | 200.0 |
| 2024-10-31 04:13:00 | SPY | ETF | 575.38 | 575.51 | 575.38 | 575.51 | 1296.0 |
| 2024-10-31 04:16:00 | SPY | ETF | 575.64 | 575.64 | 575.61 | 575.64 | 724.0 |
| 2024-10-31 04:18:00 | SPY | ETF | 575.63 | 575.63 | 575.61 | 575.61 | 200.0 |
| 2024-10-31 04:19:00 | SPY | ETF | 575.71 | 575.71 | 575.64 | 575.67 | 855.0 |
| 2024-10-31 04:20:00 | SPY | ETF | 575.55 | 575.55 | 575.55 | 575.55 | 100.0 |
| 2024-10-31 04:21:00 | SPY | ETF | 575.47 | 575.59 | 575.47 | 575.47 | 2213.0 |
| 2024-10-31 04:22:00 | SPY | ETF | 575.4 | 575.43 | 575.4 | 575.43 | 287.0 |
| 2024-10-31 04:24:00 | SPY | ETF | 575.32 | 575.35 | 575.28 | 575.28 | 331.0 |
| 2024-10-31 04:25:00 | SPY | ETF | 575.34 | 575.34 | 575.3 | 575.3 | 2400.0 |
| 2024-10-31 04:26:00 | SPY | ETF | 575.28 | 575.28 | 575.18 | 575.18 | 3285.0 |
| 2024-10-31 04:27:00 | SPY | ETF | 575.17 | 575.4 | 575.12 | 575.39 | 800.0 |
| 2024-10-31 04:28:00 | SPY | ETF | 575.37 | 575.37 | 575.37 | 575.37 | 100.0 |
| 2024-10-31 04:31:00 | SPY | ETF | 575.2 | 575.2 | 575.2 | 575.2 | 100.0 |
| 2024-10-31 04:32:00 | SPY | ETF | 575.12 | 575.17 | 575.12 | 575.13 | 800.0 |
| 2024-10-31 04:33:00 | SPY | ETF | 575.12 | 575.12 | 575.12 | 575.12 | 200.0 |
| 2024-10-31 04:34:00 | SPY | ETF | 575.2 | 575.2 | 575.19 | 575.2 | 1476.0 |
| 2024-10-31 04:35:00 | SPY | ETF | 575.15 | 575.3 | 575.15 | 575.3 | 674.0 |
| 2024-10-31 04:36:00 | SPY | ETF | 575.29 | 575.31 | 575.19 | 575.24 | 613.0 |
| 2024-10-31 04:38:00 | SPY | ETF | 575.2 | 575.21 | 575.2 | 575.21 | 800.0 |
| 2024-10-31 04:39:00 | SPY | ETF | 575.22 | 575.3 | 575.22 | 575.28 | 1638.0 |
| 2024-10-31 04:40:00 | SPY | ETF | 575.32 | 575.32 | 575.29 | 575.32 | 903.0 |
| 2024-10-31 04:42:00 | SPY | ETF | 575.28 | 575.28 | 575.28 | 575.28 | 100.0 |
| 2024-10-31 04:43:00 | SPY | ETF | 575.4 | 575.4 | 575.4 | 575.4 | 100.0 |
| 2024-10-31 04:44:00 | SPY | ETF | 575.35 | 575.35 | 575.35 | 575.35 | 300.0 |
| 2024-10-31 04:45:00 | SPY | ETF | 575.35 | 575.35 | 575.35 | 575.35 | 270.0 |
| 2024-10-31 04:47:00 | SPY | ETF | 575.42 | 575.51 | 575.42 | 575.51 | 200.0 |
| 2024-10-31 04:48:00 | SPY | ETF | 575.59 | 575.66 | 575.59 | 575.66 | 1015.0 |
| 2024-10-31 04:49:00 | SPY | ETF | 575.63 | 575.67 | 575.62 | 575.62 | 1200.0 |
| 2024-10-31 04:50:00 | SPY | ETF | 575.64 | 575.64 | 575.64 | 575.64 | 215.0 |
| 2024-10-31 04:51:00 | SPY | ETF | 575.7 | 575.7 | 575.6 | 575.61 | 2016.0 |
| 2024-10-31 04:52:00 | SPY | ETF | 575.63 | 575.63 | 575.63 | 575.63 | 429.0 |
| 2024-10-31 04:53:00 | SPY | ETF | 575.5 | 575.5 | 575.5 | 575.5 | 115.0 |
| 2024-10-31 04:55:00 | SPY | ETF | 575.61 | 575.61 | 575.61 | 575.61 | 161.0 |
| 2024-10-31 04:57:00 | SPY | ETF | 575.67 | 575.67 | 575.62 | 575.62 | 838.0 |
| 2024-10-31 04:58:00 | SPY | ETF | 575.57 | 575.61 | 575.57 | 575.61 | 300.0 |
| 2024-10-31 05:00:00 | SPY | ETF | 575.35 | 575.35 | 575.29 | 575.3 | 1120.0 |
| 2024-10-31 05:01:00 | SPY | ETF | 575.3 | 575.35 | 575.3 | 575.35 | 687.0 |
| 2024-10-31 05:02:00 | SPY | ETF | 575.31 | 575.45 | 575.28 | 575.4 | 1396.0 |
| 2024-10-31 05:03:00 | SPY | ETF | 575.26 | 575.26 | 575.26 | 575.26 | 498.0 |
> showing 50 of 324,832 rows — these rows as CSV