PREVIEW / etf_5min / 2024-02-27
file: by_date/etf_5min/2024/2024-02-27.parquet size: 2.2 MB rows: 108,126
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-02-27 04:00:00 | SPY | ETF | 506.0 | 506.48 | 506.0 | 506.48 | 4564.0 |
| 2024-02-27 04:05:00 | SPY | ETF | 506.41 | 506.41 | 506.35 | 506.38 | 3438.0 |
| 2024-02-27 04:10:00 | SPY | ETF | 506.38 | 506.38 | 506.29 | 506.29 | 1527.0 |
| 2024-02-27 04:15:00 | SPY | ETF | 506.3 | 506.3 | 506.3 | 506.3 | 200.0 |
| 2024-02-27 04:20:00 | SPY | ETF | 506.41 | 506.42 | 506.41 | 506.41 | 508.0 |
| 2024-02-27 04:25:00 | SPY | ETF | 506.51 | 506.69 | 506.49 | 506.69 | 1695.0 |
| 2024-02-27 04:30:00 | SPY | ETF | 506.67 | 506.67 | 506.6 | 506.65 | 1798.0 |
| 2024-02-27 04:35:00 | SPY | ETF | 506.65 | 506.65 | 506.64 | 506.64 | 267.0 |
| 2024-02-27 04:40:00 | SPY | ETF | 506.67 | 506.67 | 506.62 | 506.65 | 1329.0 |
| 2024-02-27 04:45:00 | SPY | ETF | 506.68 | 506.68 | 506.68 | 506.68 | 558.0 |
| 2024-02-27 04:50:00 | SPY | ETF | 506.52 | 506.52 | 506.52 | 506.52 | 205.0 |
| 2024-02-27 04:55:00 | SPY | ETF | 506.58 | 506.58 | 506.58 | 506.58 | 100.0 |
| 2024-02-27 05:00:00 | SPY | ETF | 506.62 | 506.62 | 506.53 | 506.53 | 700.0 |
| 2024-02-27 05:05:00 | SPY | ETF | 506.56 | 506.63 | 506.56 | 506.63 | 1477.0 |
| 2024-02-27 05:10:00 | SPY | ETF | 506.7 | 506.73 | 506.51 | 506.52 | 3292.0 |
| 2024-02-27 05:15:00 | SPY | ETF | 506.47 | 506.6 | 506.47 | 506.6 | 650.0 |
| 2024-02-27 05:25:00 | SPY | ETF | 506.59 | 506.62 | 506.59 | 506.61 | 3050.0 |
| 2024-02-27 05:30:00 | SPY | ETF | 506.55 | 506.55 | 506.55 | 506.55 | 250.0 |
| 2024-02-27 05:40:00 | SPY | ETF | 506.48 | 506.48 | 506.38 | 506.38 | 995.0 |
| 2024-02-27 05:45:00 | SPY | ETF | 506.45 | 506.56 | 506.45 | 506.54 | 3125.0 |
| 2024-02-27 05:50:00 | SPY | ETF | 506.6 | 506.61 | 506.6 | 506.61 | 200.0 |
| 2024-02-27 05:55:00 | SPY | ETF | 506.61 | 506.64 | 506.61 | 506.64 | 674.0 |
| 2024-02-27 06:00:00 | SPY | ETF | 506.69 | 506.69 | 506.54 | 506.55 | 640.0 |
| 2024-02-27 06:05:00 | SPY | ETF | 506.54 | 506.56 | 506.46 | 506.56 | 2689.0 |
| 2024-02-27 06:10:00 | SPY | ETF | 506.51 | 506.54 | 506.42 | 506.45 | 1850.0 |
| 2024-02-27 06:20:00 | SPY | ETF | 506.41 | 506.41 | 506.41 | 506.41 | 500.0 |
| 2024-02-27 06:30:00 | SPY | ETF | 506.32 | 506.33 | 506.31 | 506.33 | 799.0 |
| 2024-02-27 06:35:00 | SPY | ETF | 506.4 | 506.43 | 506.4 | 506.43 | 1099.0 |
| 2024-02-27 06:40:00 | SPY | ETF | 506.47 | 506.47 | 506.45 | 506.46 | 3592.0 |
| 2024-02-27 06:45:00 | SPY | ETF | 506.46 | 506.5 | 506.45 | 506.5 | 5978.0 |
| 2024-02-27 06:50:00 | SPY | ETF | 506.5 | 506.51 | 506.46 | 506.46 | 898.0 |
| 2024-02-27 06:55:00 | SPY | ETF | 506.45 | 506.49 | 506.45 | 506.49 | 1125.0 |
| 2024-02-27 07:00:00 | SPY | ETF | 506.44 | 506.61 | 506.44 | 506.54 | 18989.0 |
| 2024-02-27 07:05:00 | SPY | ETF | 506.55 | 506.62 | 506.54 | 506.61 | 12109.0 |
| 2024-02-27 07:10:00 | SPY | ETF | 506.62 | 506.67 | 506.62 | 506.64 | 7227.0 |
| 2024-02-27 07:15:00 | SPY | ETF | 506.65 | 506.74 | 506.65 | 506.74 | 5217.0 |
| 2024-02-27 07:20:00 | SPY | ETF | 506.73 | 506.75 | 506.73 | 506.74 | 4075.0 |
| 2024-02-27 07:25:00 | SPY | ETF | 506.75 | 506.78 | 506.75 | 506.78 | 2172.0 |
| 2024-02-27 07:30:00 | SPY | ETF | 506.8 | 506.97 | 506.78 | 506.95 | 11176.0 |
| 2024-02-27 07:35:00 | SPY | ETF | 506.97 | 506.97 | 506.84 | 506.89 | 20130.0 |
| 2024-02-27 07:40:00 | SPY | ETF | 506.95 | 506.95 | 506.92 | 506.94 | 600.0 |
| 2024-02-27 07:45:00 | SPY | ETF | 506.95 | 507.01 | 506.94 | 507.0 | 8027.0 |
| 2024-02-27 07:50:00 | SPY | ETF | 507.0 | 507.01 | 506.88 | 506.89 | 4145.0 |
| 2024-02-27 07:55:00 | SPY | ETF | 506.86 | 506.88 | 506.85 | 506.88 | 10538.0 |
| 2024-02-27 08:00:00 | SPY | ETF | 506.48 | 507.0101 | 505.55 | 506.8 | 34641.0 |
| 2024-02-27 08:05:00 | SPY | ETF | 506.81 | 506.81 | 506.29 | 506.6 | 6881.0 |
| 2024-02-27 08:10:00 | SPY | ETF | 506.59 | 506.59 | 506.5 | 506.5 | 38571.0 |
| 2024-02-27 08:15:00 | SPY | ETF | 506.5 | 506.5 | 506.03 | 506.17 | 91986.0 |
| 2024-02-27 08:20:00 | SPY | ETF | 506.12 | 506.27 | 506.12 | 506.17 | 4050.0 |
| 2024-02-27 08:25:00 | SPY | ETF | 506.19 | 506.26 | 506.14 | 506.21 | 17472.0 |
> showing 50 of 108,126 rows — these rows as CSV