PREVIEW / etf_1min / 2025-08-20
file: by_date/etf_1min/2025/2025-08-20.parquet size: 6.5 MB rows: 364,434
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 |
|---|---|---|---|---|---|---|---|
| 2025-08-20 04:00:00 | SPY | ETF | 637.22 | 638.67 | 637.22 | 638.66 | 1799.0 |
| 2025-08-20 04:01:00 | SPY | ETF | 638.67 | 638.67 | 638.56 | 638.56 | 2470.0 |
| 2025-08-20 04:02:00 | SPY | ETF | 638.63 | 638.63 | 638.4 | 638.46 | 2854.0 |
| 2025-08-20 04:03:00 | SPY | ETF | 638.41 | 638.61 | 638.41 | 638.54 | 4100.0 |
| 2025-08-20 04:04:00 | SPY | ETF | 638.61 | 638.64 | 638.51 | 638.51 | 2359.0 |
| 2025-08-20 04:05:00 | SPY | ETF | 638.59 | 638.64 | 638.51 | 638.52 | 2928.0 |
| 2025-08-20 04:06:00 | SPY | ETF | 638.54 | 638.55 | 638.41 | 638.5 | 3970.0 |
| 2025-08-20 04:07:00 | SPY | ETF | 638.51 | 638.55 | 638.45 | 638.51 | 6490.0 |
| 2025-08-20 04:08:00 | SPY | ETF | 638.52 | 638.52 | 638.38 | 638.38 | 500.0 |
| 2025-08-20 04:09:00 | SPY | ETF | 638.38 | 638.38 | 638.38 | 638.38 | 1219.0 |
| 2025-08-20 04:10:00 | SPY | ETF | 638.41 | 638.41 | 638.31 | 638.31 | 1310.0 |
| 2025-08-20 04:11:00 | SPY | ETF | 638.33 | 638.33 | 638.24 | 638.32 | 1370.0 |
| 2025-08-20 04:12:00 | SPY | ETF | 638.21 | 638.3 | 638.17 | 638.3 | 3789.0 |
| 2025-08-20 04:13:00 | SPY | ETF | 638.22 | 638.24 | 638.14 | 638.17 | 620.0 |
| 2025-08-20 04:14:00 | SPY | ETF | 638.07 | 638.15 | 638.04 | 638.14 | 1040.0 |
| 2025-08-20 04:15:00 | SPY | ETF | 638.02 | 638.02 | 638.0 | 638.0 | 210.0 |
| 2025-08-20 04:16:00 | SPY | ETF | 638.12 | 638.12 | 638.12 | 638.12 | 220.0 |
| 2025-08-20 04:17:00 | SPY | ETF | 638.1 | 638.12 | 638.1 | 638.12 | 210.0 |
| 2025-08-20 04:19:00 | SPY | ETF | 638.22 | 638.22 | 638.2 | 638.2 | 600.0 |
| 2025-08-20 04:20:00 | SPY | ETF | 638.26 | 638.27 | 638.26 | 638.26 | 1140.0 |
| 2025-08-20 04:21:00 | SPY | ETF | 638.24 | 638.25 | 638.12 | 638.12 | 1650.0 |
| 2025-08-20 04:22:00 | SPY | ETF | 638.09 | 638.09 | 638.08 | 638.08 | 920.0 |
| 2025-08-20 04:24:00 | SPY | ETF | 637.9 | 637.9 | 637.89 | 637.89 | 300.0 |
| 2025-08-20 04:29:00 | SPY | ETF | 638.0 | 638.0 | 638.0 | 638.0 | 100.0 |
| 2025-08-20 04:30:00 | SPY | ETF | 637.9 | 637.9 | 637.9 | 637.9 | 100.0 |
| 2025-08-20 04:31:00 | SPY | ETF | 637.98 | 637.98 | 637.98 | 637.98 | 110.0 |
| 2025-08-20 04:32:00 | SPY | ETF | 637.99 | 638.38 | 637.99 | 638.38 | 1731.0 |
| 2025-08-20 04:33:00 | SPY | ETF | 638.4 | 638.52 | 638.4 | 638.52 | 2300.0 |
| 2025-08-20 04:34:00 | SPY | ETF | 638.49 | 638.49 | 638.49 | 638.49 | 100.0 |
| 2025-08-20 04:35:00 | SPY | ETF | 638.41 | 638.49 | 638.41 | 638.49 | 400.0 |
| 2025-08-20 04:37:00 | SPY | ETF | 638.76 | 638.78 | 638.76 | 638.78 | 400.0 |
| 2025-08-20 04:38:00 | SPY | ETF | 638.75 | 638.75 | 638.71 | 638.74 | 500.0 |
| 2025-08-20 04:39:00 | SPY | ETF | 638.75 | 638.75 | 638.73 | 638.73 | 500.0 |
| 2025-08-20 04:40:00 | SPY | ETF | 638.7 | 638.7 | 638.7 | 638.7 | 100.0 |
| 2025-08-20 04:48:00 | SPY | ETF | 638.52 | 638.61 | 638.52 | 638.6 | 400.0 |
| 2025-08-20 04:51:00 | SPY | ETF | 638.61 | 638.61 | 638.61 | 638.61 | 100.0 |
| 2025-08-20 04:58:00 | SPY | ETF | 638.57 | 638.57 | 638.54 | 638.54 | 2900.0 |
| 2025-08-20 04:59:00 | SPY | ETF | 638.46 | 638.48 | 638.46 | 638.46 | 520.0 |
| 2025-08-20 05:00:00 | SPY | ETF | 638.56 | 638.6 | 638.41 | 638.42 | 1984.0 |
| 2025-08-20 05:01:00 | SPY | ETF | 638.47 | 638.53 | 638.47 | 638.52 | 892.0 |
| 2025-08-20 05:02:00 | SPY | ETF | 638.58 | 638.63 | 638.58 | 638.63 | 300.0 |
| 2025-08-20 05:04:00 | SPY | ETF | 638.53 | 638.53 | 638.53 | 638.53 | 500.0 |
| 2025-08-20 05:06:00 | SPY | ETF | 638.45 | 638.45 | 638.45 | 638.45 | 100.0 |
| 2025-08-20 05:11:00 | SPY | ETF | 638.74 | 638.74 | 638.74 | 638.74 | 110.0 |
| 2025-08-20 05:12:00 | SPY | ETF | 638.72 | 638.72 | 638.72 | 638.72 | 200.0 |
| 2025-08-20 05:18:00 | SPY | ETF | 638.91 | 638.91 | 638.9 | 638.9 | 200.0 |
| 2025-08-20 05:19:00 | SPY | ETF | 638.91 | 638.91 | 638.91 | 638.91 | 110.0 |
| 2025-08-20 05:20:00 | SPY | ETF | 638.94 | 638.95 | 638.94 | 638.95 | 800.0 |
| 2025-08-20 05:22:00 | SPY | ETF | 638.92 | 638.92 | 638.9 | 638.9 | 400.0 |
| 2025-08-20 05:24:00 | SPY | ETF | 638.88 | 638.88 | 638.88 | 638.88 | 100.0 |
> showing 50 of 364,434 rows — these rows as CSV