PREVIEW / etf_5min / 2024-01-12
file: by_date/etf_5min/2024/2024-01-12.parquet size: 2.2 MB rows: 107,849
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-01-12 04:00:00 | SPY | ETF | 476.12 | 476.79 | 475.82 | 476.71 | 4121.0 |
| 2024-01-12 04:05:00 | SPY | ETF | 476.71 | 476.83 | 476.7 | 476.83 | 4900.0 |
| 2024-01-12 04:10:00 | SPY | ETF | 476.88 | 477.09 | 476.88 | 477.09 | 1740.0 |
| 2024-01-12 04:15:00 | SPY | ETF | 477.01 | 477.02 | 476.84 | 476.87 | 3381.0 |
| 2024-01-12 04:25:00 | SPY | ETF | 476.5 | 476.65 | 476.47 | 476.65 | 2650.0 |
| 2024-01-12 04:30:00 | SPY | ETF | 476.9 | 476.9 | 476.9 | 476.9 | 240.0 |
| 2024-01-12 04:35:00 | SPY | ETF | 476.77 | 476.88 | 476.58 | 476.58 | 6599.0 |
| 2024-01-12 04:40:00 | SPY | ETF | 476.56 | 476.56 | 476.48 | 476.5 | 806.0 |
| 2024-01-12 04:45:00 | SPY | ETF | 476.55 | 476.55 | 476.55 | 476.55 | 300.0 |
| 2024-01-12 04:50:00 | SPY | ETF | 476.45 | 476.45 | 476.35 | 476.35 | 505.0 |
| 2024-01-12 04:55:00 | SPY | ETF | 476.3 | 476.36 | 476.3 | 476.36 | 426.0 |
| 2024-01-12 05:00:00 | SPY | ETF | 476.24 | 476.24 | 476.24 | 476.24 | 100.0 |
| 2024-01-12 05:05:00 | SPY | ETF | 476.2 | 476.2 | 476.2 | 476.2 | 100.0 |
| 2024-01-12 05:10:00 | SPY | ETF | 476.35 | 476.47 | 476.35 | 476.47 | 469.0 |
| 2024-01-12 05:15:00 | SPY | ETF | 476.45 | 476.45 | 476.45 | 476.45 | 100.0 |
| 2024-01-12 05:20:00 | SPY | ETF | 476.46 | 476.56 | 476.46 | 476.51 | 925.0 |
| 2024-01-12 05:25:00 | SPY | ETF | 476.55 | 476.6 | 476.55 | 476.6 | 815.0 |
| 2024-01-12 05:30:00 | SPY | ETF | 476.43 | 476.45 | 476.41 | 476.45 | 815.0 |
| 2024-01-12 05:35:00 | SPY | ETF | 476.49 | 476.49 | 476.49 | 476.49 | 100.0 |
| 2024-01-12 05:45:00 | SPY | ETF | 476.2 | 476.2 | 476.2 | 476.2 | 100.0 |
| 2024-01-12 05:50:00 | SPY | ETF | 476.05 | 476.05 | 475.99 | 475.99 | 450.0 |
| 2024-01-12 05:55:00 | SPY | ETF | 476.17 | 476.19 | 476.17 | 476.19 | 600.0 |
| 2024-01-12 06:00:00 | SPY | ETF | 476.4 | 476.4 | 476.35 | 476.35 | 200.0 |
| 2024-01-12 06:05:00 | SPY | ETF | 476.25 | 476.25 | 476.05 | 476.05 | 310.0 |
| 2024-01-12 06:10:00 | SPY | ETF | 475.98 | 476.08 | 475.98 | 476.08 | 3420.0 |
| 2024-01-12 06:15:00 | SPY | ETF | 475.93 | 476.02 | 475.88 | 475.88 | 2751.0 |
| 2024-01-12 06:20:00 | SPY | ETF | 475.8 | 475.88 | 475.75 | 475.88 | 1900.0 |
| 2024-01-12 06:25:00 | SPY | ETF | 475.83 | 475.98 | 475.83 | 475.98 | 800.0 |
| 2024-01-12 06:30:00 | SPY | ETF | 475.88 | 475.92 | 475.79 | 475.79 | 2991.0 |
| 2024-01-12 06:35:00 | SPY | ETF | 475.8 | 475.83 | 475.62 | 475.62 | 66455.0 |
| 2024-01-12 06:40:00 | SPY | ETF | 475.63 | 475.63 | 475.24 | 475.27 | 96765.0 |
| 2024-01-12 06:45:00 | SPY | ETF | 475.29 | 475.29 | 474.17 | 474.35 | 14666.0 |
| 2024-01-12 06:50:00 | SPY | ETF | 474.37 | 474.44 | 474.22 | 474.39 | 6700.0 |
| 2024-01-12 06:55:00 | SPY | ETF | 474.35 | 474.93 | 474.33 | 474.92 | 8295.0 |
| 2024-01-12 07:00:00 | SPY | ETF | 474.95 | 475.35 | 474.95 | 475.12 | 90627.0 |
| 2024-01-12 07:05:00 | SPY | ETF | 475.14 | 475.16 | 474.94 | 475.05 | 11251.0 |
| 2024-01-12 07:10:00 | SPY | ETF | 475.08 | 475.14 | 475.04 | 475.06 | 5810.0 |
| 2024-01-12 07:15:00 | SPY | ETF | 475.05 | 475.14 | 474.84 | 474.84 | 81746.0 |
| 2024-01-12 07:20:00 | SPY | ETF | 474.81 | 475.18 | 474.75 | 475.16 | 4695.0 |
| 2024-01-12 07:25:00 | SPY | ETF | 475.16 | 475.3 | 475.16 | 475.17 | 11038.0 |
| 2024-01-12 07:30:00 | SPY | ETF | 475.19 | 475.57 | 475.19 | 475.45 | 16322.0 |
| 2024-01-12 07:35:00 | SPY | ETF | 475.43 | 475.45 | 475.26 | 475.3 | 7159.0 |
| 2024-01-12 07:40:00 | SPY | ETF | 475.41 | 475.45 | 475.32 | 475.33 | 5735.0 |
| 2024-01-12 07:45:00 | SPY | ETF | 475.33 | 475.37 | 475.12 | 475.25 | 18362.0 |
| 2024-01-12 07:50:00 | SPY | ETF | 475.25 | 475.4 | 475.1 | 475.35 | 12422.0 |
| 2024-01-12 07:55:00 | SPY | ETF | 475.33 | 475.33 | 475.1 | 475.15 | 10938.0 |
| 2024-01-12 08:00:00 | SPY | ETF | 475.17 | 476.85 | 474.3196 | 475.49 | 83281.0 |
| 2024-01-12 08:05:00 | SPY | ETF | 475.48 | 475.5 | 475.27 | 475.27 | 19189.0 |
| 2024-01-12 08:10:00 | SPY | ETF | 475.23 | 475.38 | 474.95 | 475.14 | 11910.0 |
| 2024-01-12 08:15:00 | SPY | ETF | 475.16 | 475.34 | 475.0 | 475.06 | 17738.0 |
> showing 50 of 107,849 rows — these rows as CSV