PREVIEW / etf_5min / 2024-05-28
file: by_date/etf_5min/2024/2024-05-28.parquet size: 2.3 MB rows: 112,735
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-05-28 04:00:00 | SPY | ETF | 530.28 | 530.59 | 530.27 | 530.58 | 15750.0 |
| 2024-05-28 04:05:00 | SPY | ETF | 530.57 | 530.71 | 530.5 | 530.68 | 3340.0 |
| 2024-05-28 04:10:00 | SPY | ETF | 530.79 | 530.98 | 530.72 | 530.98 | 2300.0 |
| 2024-05-28 04:15:00 | SPY | ETF | 530.96 | 531.08 | 530.93 | 530.95 | 1099.0 |
| 2024-05-28 04:20:00 | SPY | ETF | 531.01 | 531.05 | 531.01 | 531.05 | 959.0 |
| 2024-05-28 04:25:00 | SPY | ETF | 531.08 | 531.08 | 530.98 | 530.98 | 315.0 |
| 2024-05-28 04:35:00 | SPY | ETF | 531.12 | 531.12 | 531.11 | 531.11 | 800.0 |
| 2024-05-28 04:40:00 | SPY | ETF | 531.18 | 531.18 | 531.18 | 531.18 | 200.0 |
| 2024-05-28 04:50:00 | SPY | ETF | 531.24 | 531.24 | 531.2 | 531.21 | 300.0 |
| 2024-05-28 04:55:00 | SPY | ETF | 531.13 | 531.13 | 531.13 | 531.13 | 100.0 |
| 2024-05-28 05:00:00 | SPY | ETF | 531.16 | 531.17 | 531.15 | 531.17 | 1567.0 |
| 2024-05-28 05:10:00 | SPY | ETF | 531.12 | 531.12 | 531.12 | 531.12 | 1300.0 |
| 2024-05-28 05:25:00 | SPY | ETF | 531.24 | 531.24 | 531.24 | 531.24 | 2100.0 |
| 2024-05-28 05:30:00 | SPY | ETF | 531.05 | 531.05 | 531.05 | 531.05 | 1000.0 |
| 2024-05-28 05:35:00 | SPY | ETF | 531.01 | 531.06 | 531.01 | 531.06 | 338.0 |
| 2024-05-28 05:40:00 | SPY | ETF | 531.09 | 531.14 | 531.07 | 531.14 | 488.0 |
| 2024-05-28 05:45:00 | SPY | ETF | 531.11 | 531.17 | 531.11 | 531.15 | 3534.0 |
| 2024-05-28 05:50:00 | SPY | ETF | 531.19 | 531.19 | 531.19 | 531.19 | 1600.0 |
| 2024-05-28 05:55:00 | SPY | ETF | 531.17 | 531.17 | 531.17 | 531.17 | 100.0 |
| 2024-05-28 06:05:00 | SPY | ETF | 531.05 | 531.06 | 531.0 | 531.0 | 450.0 |
| 2024-05-28 06:15:00 | SPY | ETF | 530.95 | 530.95 | 530.84 | 530.84 | 1300.0 |
| 2024-05-28 06:20:00 | SPY | ETF | 530.6 | 530.6 | 530.15 | 530.16 | 3559.0 |
| 2024-05-28 06:25:00 | SPY | ETF | 530.17 | 530.21 | 529.91 | 530.01 | 12173.0 |
| 2024-05-28 06:30:00 | SPY | ETF | 529.9 | 530.12 | 529.9 | 530.1 | 8200.0 |
| 2024-05-28 06:35:00 | SPY | ETF | 530.23 | 530.23 | 530.17 | 530.19 | 3026.0 |
| 2024-05-28 06:40:00 | SPY | ETF | 530.28 | 530.28 | 530.27 | 530.27 | 200.0 |
| 2024-05-28 06:45:00 | SPY | ETF | 530.24 | 530.24 | 529.94 | 530.06 | 3052.0 |
| 2024-05-28 06:50:00 | SPY | ETF | 530.01 | 530.18 | 530.01 | 530.14 | 1505.0 |
| 2024-05-28 06:55:00 | SPY | ETF | 530.04 | 530.05 | 530.04 | 530.05 | 1350.0 |
| 2024-05-28 07:00:00 | SPY | ETF | 529.93 | 530.11 | 529.93 | 530.1 | 59565.0 |
| 2024-05-28 07:05:00 | SPY | ETF | 530.13 | 530.21 | 530.1 | 530.1 | 2533.0 |
| 2024-05-28 07:10:00 | SPY | ETF | 530.09 | 530.3 | 530.09 | 530.3 | 9631.0 |
| 2024-05-28 07:15:00 | SPY | ETF | 530.33 | 530.33 | 530.25 | 530.27 | 1387.0 |
| 2024-05-28 07:20:00 | SPY | ETF | 530.17 | 530.17 | 529.96 | 530.0 | 1629.0 |
| 2024-05-28 07:25:00 | SPY | ETF | 530.04 | 530.11 | 530.04 | 530.11 | 888.0 |
| 2024-05-28 07:30:00 | SPY | ETF | 530.13 | 530.25 | 530.1 | 530.16 | 8926.0 |
| 2024-05-28 07:35:00 | SPY | ETF | 530.14 | 530.21 | 530.09 | 530.15 | 23968.0 |
| 2024-05-28 07:40:00 | SPY | ETF | 530.27 | 530.3 | 530.12 | 530.12 | 13309.0 |
| 2024-05-28 07:45:00 | SPY | ETF | 530.1 | 530.16 | 530.1 | 530.16 | 1359.0 |
| 2024-05-28 07:50:00 | SPY | ETF | 530.24 | 530.36 | 530.24 | 530.26 | 2408.0 |
| 2024-05-28 07:55:00 | SPY | ETF | 530.25 | 530.25 | 530.22 | 530.22 | 850.0 |
| 2024-05-28 08:00:00 | SPY | ETF | 530.1 | 530.44 | 529.9 | 530.14 | 20139.0 |
| 2024-05-28 08:05:00 | SPY | ETF | 530.23 | 530.48 | 530.21 | 530.48 | 17599.0 |
| 2024-05-28 08:10:00 | SPY | ETF | 530.48 | 530.57 | 530.48 | 530.53 | 10709.0 |
| 2024-05-28 08:15:00 | SPY | ETF | 530.51 | 530.51 | 530.21 | 530.23 | 17338.0 |
| 2024-05-28 08:20:00 | SPY | ETF | 530.33 | 530.37 | 530.28 | 530.37 | 4315.0 |
| 2024-05-28 08:25:00 | SPY | ETF | 530.37 | 530.48 | 530.35 | 530.4 | 4582.0 |
| 2024-05-28 08:30:00 | SPY | ETF | 530.37 | 530.43 | 530.27 | 530.28 | 26061.0 |
| 2024-05-28 08:35:00 | SPY | ETF | 530.35 | 530.49 | 530.34 | 530.49 | 3377.0 |
| 2024-05-28 08:40:00 | SPY | ETF | 530.47 | 530.489 | 530.06 | 530.09 | 4147.0 |
> showing 50 of 112,735 rows — these rows as CSV