PREVIEW / etf_5min / 2024-04-02
file: by_date/etf_5min/2024/2024-04-02.parquet size: 2.3 MB rows: 114,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 |
|---|---|---|---|---|---|---|---|
| 2024-04-02 04:00:00 | SPY | ETF | 521.79 | 522.11 | 521.79 | 522.11 | 1785.0 |
| 2024-04-02 04:05:00 | SPY | ETF | 522.07 | 522.1 | 521.97 | 521.97 | 1000.0 |
| 2024-04-02 04:10:00 | SPY | ETF | 522.06 | 522.06 | 522.01 | 522.02 | 502.0 |
| 2024-04-02 04:15:00 | SPY | ETF | 522.36 | 522.36 | 522.35 | 522.35 | 300.0 |
| 2024-04-02 04:20:00 | SPY | ETF | 522.29 | 522.29 | 522.23 | 522.27 | 474.0 |
| 2024-04-02 04:25:00 | SPY | ETF | 522.24 | 522.32 | 522.24 | 522.27 | 525.0 |
| 2024-04-02 04:30:00 | SPY | ETF | 522.2 | 522.22 | 522.2 | 522.22 | 425.0 |
| 2024-04-02 04:35:00 | SPY | ETF | 522.19 | 522.19 | 522.19 | 522.19 | 200.0 |
| 2024-04-02 04:40:00 | SPY | ETF | 521.96 | 521.96 | 521.96 | 521.96 | 100.0 |
| 2024-04-02 04:45:00 | SPY | ETF | 521.79 | 521.79 | 521.76 | 521.76 | 650.0 |
| 2024-04-02 04:50:00 | SPY | ETF | 521.67 | 521.67 | 521.57 | 521.65 | 3375.0 |
| 2024-04-02 04:55:00 | SPY | ETF | 521.67 | 521.74 | 521.67 | 521.74 | 1800.0 |
| 2024-04-02 05:00:00 | SPY | ETF | 521.78 | 521.78 | 521.78 | 521.78 | 200.0 |
| 2024-04-02 05:10:00 | SPY | ETF | 521.96 | 521.96 | 521.96 | 521.96 | 134.0 |
| 2024-04-02 05:15:00 | SPY | ETF | 521.91 | 521.91 | 521.86 | 521.86 | 1111.0 |
| 2024-04-02 05:20:00 | SPY | ETF | 521.93 | 521.93 | 521.9 | 521.93 | 913.0 |
| 2024-04-02 05:25:00 | SPY | ETF | 522.05 | 522.05 | 521.99 | 521.99 | 600.0 |
| 2024-04-02 05:30:00 | SPY | ETF | 521.84 | 521.84 | 521.84 | 521.84 | 140.0 |
| 2024-04-02 05:45:00 | SPY | ETF | 521.94 | 521.94 | 521.94 | 521.94 | 1000.0 |
| 2024-04-02 05:50:00 | SPY | ETF | 521.91 | 521.91 | 521.67 | 521.67 | 325.0 |
| 2024-04-02 06:00:00 | SPY | ETF | 521.5 | 521.5 | 521.34 | 521.34 | 1800.0 |
| 2024-04-02 06:05:00 | SPY | ETF | 521.32 | 521.32 | 521.29 | 521.29 | 771.0 |
| 2024-04-02 06:10:00 | SPY | ETF | 521.31 | 521.31 | 521.24 | 521.24 | 3149.0 |
| 2024-04-02 06:15:00 | SPY | ETF | 521.23 | 521.28 | 521.18 | 521.28 | 4050.0 |
| 2024-04-02 06:20:00 | SPY | ETF | 521.46 | 521.46 | 521.46 | 521.46 | 400.0 |
| 2024-04-02 06:25:00 | SPY | ETF | 521.4 | 521.4 | 521.4 | 521.4 | 325.0 |
| 2024-04-02 06:30:00 | SPY | ETF | 521.44 | 521.44 | 521.44 | 521.44 | 264.0 |
| 2024-04-02 06:35:00 | SPY | ETF | 521.02 | 521.02 | 521.0 | 521.0 | 1446.0 |
| 2024-04-02 06:40:00 | SPY | ETF | 520.81 | 520.93 | 520.8 | 520.93 | 7805.0 |
| 2024-04-02 06:45:00 | SPY | ETF | 521.04 | 521.04 | 520.94 | 521.01 | 1200.0 |
| 2024-04-02 06:50:00 | SPY | ETF | 521.03 | 521.03 | 521.0 | 521.01 | 1950.0 |
| 2024-04-02 06:55:00 | SPY | ETF | 521.08 | 521.2 | 521.08 | 521.2 | 5900.0 |
| 2024-04-02 07:00:00 | SPY | ETF | 521.17 | 521.22 | 521.05 | 521.22 | 8191.0 |
| 2024-04-02 07:05:00 | SPY | ETF | 521.14 | 521.14 | 521.05 | 521.05 | 8955.0 |
| 2024-04-02 07:10:00 | SPY | ETF | 521.11 | 521.12 | 521.041 | 521.09 | 9430.0 |
| 2024-04-02 07:15:00 | SPY | ETF | 521.0 | 521.07 | 521.0 | 521.04 | 6900.0 |
| 2024-04-02 07:20:00 | SPY | ETF | 520.84 | 520.84 | 520.57 | 520.69 | 24205.0 |
| 2024-04-02 07:25:00 | SPY | ETF | 520.671 | 520.8 | 520.65 | 520.8 | 15247.0 |
| 2024-04-02 07:30:00 | SPY | ETF | 520.69 | 520.79 | 520.67 | 520.69 | 15207.0 |
| 2024-04-02 07:35:00 | SPY | ETF | 520.7 | 520.83 | 520.695 | 520.83 | 14868.0 |
| 2024-04-02 07:40:00 | SPY | ETF | 520.8 | 520.8 | 520.62 | 520.63 | 1860.0 |
| 2024-04-02 07:45:00 | SPY | ETF | 520.64 | 520.64 | 520.37 | 520.39 | 12229.0 |
| 2024-04-02 07:50:00 | SPY | ETF | 520.4 | 520.43 | 520.34 | 520.34 | 8461.0 |
| 2024-04-02 07:55:00 | SPY | ETF | 520.33 | 520.39 | 520.24 | 520.25 | 15877.0 |
| 2024-04-02 08:00:00 | SPY | ETF | 521.68 | 522.3996 | 520.2605 | 520.32 | 40708.0 |
| 2024-04-02 08:05:00 | SPY | ETF | 520.32 | 520.39 | 520.259 | 520.38 | 10250.0 |
| 2024-04-02 08:10:00 | SPY | ETF | 520.37 | 520.39 | 520.2 | 520.2 | 13138.0 |
| 2024-04-02 08:15:00 | SPY | ETF | 520.2 | 520.2 | 520.06 | 520.1 | 10364.0 |
| 2024-04-02 08:20:00 | SPY | ETF | 520.12 | 520.13 | 520.05 | 520.05 | 18588.0 |
| 2024-04-02 08:25:00 | SPY | ETF | 520.09 | 520.29 | 520.06 | 520.29 | 10191.0 |
> showing 50 of 114,434 rows — these rows as CSV