PREVIEW / etf_1min / 2024-11-20
file: by_date/etf_1min/2024/2024-11-20.parquet size: 5.8 MB rows: 322,889
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-11-20 04:00:00 | SPY | ETF | 591.57 | 591.57 | 591.42 | 591.42 | 1446.0 |
| 2024-11-20 04:03:00 | SPY | ETF | 591.54 | 591.61 | 591.54 | 591.61 | 435.0 |
| 2024-11-20 04:04:00 | SPY | ETF | 591.61 | 591.61 | 591.49 | 591.49 | 447.0 |
| 2024-11-20 04:08:00 | SPY | ETF | 591.64 | 591.68 | 591.63 | 591.63 | 529.0 |
| 2024-11-20 04:10:00 | SPY | ETF | 591.62 | 591.62 | 591.62 | 591.62 | 150.0 |
| 2024-11-20 04:11:00 | SPY | ETF | 591.64 | 591.64 | 591.64 | 591.64 | 100.0 |
| 2024-11-20 04:12:00 | SPY | ETF | 591.89 | 591.89 | 591.89 | 591.89 | 724.0 |
| 2024-11-20 04:15:00 | SPY | ETF | 591.99 | 591.99 | 591.99 | 591.99 | 215.0 |
| 2024-11-20 04:18:00 | SPY | ETF | 591.86 | 591.86 | 591.84 | 591.84 | 516.0 |
| 2024-11-20 04:19:00 | SPY | ETF | 591.94 | 592.01 | 591.94 | 592.01 | 549.0 |
| 2024-11-20 04:20:00 | SPY | ETF | 591.98 | 591.98 | 591.94 | 591.94 | 874.0 |
| 2024-11-20 04:23:00 | SPY | ETF | 591.85 | 591.85 | 591.85 | 591.85 | 300.0 |
| 2024-11-20 04:25:00 | SPY | ETF | 591.95 | 591.95 | 591.95 | 591.95 | 100.0 |
| 2024-11-20 04:27:00 | SPY | ETF | 591.91 | 591.91 | 591.9 | 591.9 | 1720.0 |
| 2024-11-20 04:30:00 | SPY | ETF | 591.72 | 591.78 | 591.72 | 591.78 | 600.0 |
| 2024-11-20 04:32:00 | SPY | ETF | 591.59 | 591.64 | 591.59 | 591.64 | 308.0 |
| 2024-11-20 04:33:00 | SPY | ETF | 591.54 | 591.54 | 591.54 | 591.54 | 200.0 |
| 2024-11-20 04:34:00 | SPY | ETF | 591.55 | 591.55 | 591.52 | 591.52 | 599.0 |
| 2024-11-20 04:40:00 | SPY | ETF | 591.73 | 591.73 | 591.73 | 591.73 | 100.0 |
| 2024-11-20 04:42:00 | SPY | ETF | 591.62 | 591.62 | 591.62 | 591.62 | 105.0 |
| 2024-11-20 04:45:00 | SPY | ETF | 591.55 | 591.55 | 591.55 | 591.55 | 200.0 |
| 2024-11-20 04:48:00 | SPY | ETF | 591.46 | 591.46 | 591.46 | 591.46 | 249.0 |
| 2024-11-20 04:49:00 | SPY | ETF | 591.4 | 591.41 | 591.4 | 591.41 | 228.0 |
| 2024-11-20 04:50:00 | SPY | ETF | 591.3 | 591.3 | 591.3 | 591.3 | 130.0 |
| 2024-11-20 04:51:00 | SPY | ETF | 591.21 | 591.27 | 591.21 | 591.27 | 1110.0 |
| 2024-11-20 04:52:00 | SPY | ETF | 591.5 | 591.52 | 591.49 | 591.51 | 13860.0 |
| 2024-11-20 04:53:00 | SPY | ETF | 591.59 | 591.65 | 591.59 | 591.65 | 13800.0 |
| 2024-11-20 04:55:00 | SPY | ETF | 591.47 | 591.53 | 591.47 | 591.53 | 1024.0 |
| 2024-11-20 04:57:00 | SPY | ETF | 591.39 | 591.39 | 591.39 | 591.39 | 172.0 |
| 2024-11-20 04:59:00 | SPY | ETF | 591.42 | 591.42 | 591.42 | 591.42 | 809.0 |
| 2024-11-20 05:00:00 | SPY | ETF | 591.44 | 591.44 | 591.22 | 591.22 | 1787.0 |
| 2024-11-20 05:02:00 | SPY | ETF | 591.34 | 591.34 | 591.34 | 591.34 | 200.0 |
| 2024-11-20 05:03:00 | SPY | ETF | 591.33 | 591.33 | 591.33 | 591.33 | 261.0 |
| 2024-11-20 05:04:00 | SPY | ETF | 591.23 | 591.25 | 591.23 | 591.25 | 950.0 |
| 2024-11-20 05:05:00 | SPY | ETF | 591.2 | 591.2 | 591.2 | 591.2 | 700.0 |
| 2024-11-20 05:07:00 | SPY | ETF | 591.4 | 591.4 | 591.4 | 591.4 | 100.0 |
| 2024-11-20 05:08:00 | SPY | ETF | 591.38 | 591.38 | 591.38 | 591.38 | 300.0 |
| 2024-11-20 05:11:00 | SPY | ETF | 591.37 | 591.37 | 591.37 | 591.37 | 100.0 |
| 2024-11-20 05:18:00 | SPY | ETF | 591.11 | 591.11 | 591.11 | 591.11 | 300.0 |
| 2024-11-20 05:19:00 | SPY | ETF | 591.01 | 591.01 | 591.01 | 591.01 | 100.0 |
| 2024-11-20 05:20:00 | SPY | ETF | 590.95 | 590.95 | 590.94 | 590.95 | 550.0 |
| 2024-11-20 05:21:00 | SPY | ETF | 590.8 | 590.8 | 590.8 | 590.8 | 1968.0 |
| 2024-11-20 05:22:00 | SPY | ETF | 590.8 | 590.8 | 590.8 | 590.8 | 430.0 |
| 2024-11-20 05:23:00 | SPY | ETF | 590.78 | 590.79 | 590.77 | 590.79 | 1070.0 |
| 2024-11-20 05:24:00 | SPY | ETF | 590.85 | 590.85 | 590.85 | 590.85 | 171.0 |
| 2024-11-20 05:25:00 | SPY | ETF | 590.99 | 591.12 | 590.99 | 591.12 | 2815.0 |
| 2024-11-20 05:26:00 | SPY | ETF | 591.17 | 591.17 | 591.17 | 591.17 | 187.0 |
| 2024-11-20 05:27:00 | SPY | ETF | 591.06 | 591.06 | 591.06 | 591.06 | 680.0 |
| 2024-11-20 05:29:00 | SPY | ETF | 590.75 | 590.75 | 590.58 | 590.58 | 2160.0 |
| 2024-11-20 05:30:00 | SPY | ETF | 590.53 | 590.53 | 590.5 | 590.5 | 575.0 |
> showing 50 of 322,889 rows — these rows as CSV