PREVIEW / etf_5min / 2024-05-17
file: by_date/etf_5min/2024/2024-05-17.parquet size: 2.1 MB rows: 104,478
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-17 04:00:00 | SPY | ETF | 528.8 | 528.8 | 528.62 | 528.64 | 2822.0 |
| 2024-05-17 04:05:00 | SPY | ETF | 528.61 | 528.62 | 528.25 | 528.25 | 1814.0 |
| 2024-05-17 04:10:00 | SPY | ETF | 528.42 | 528.42 | 528.38 | 528.39 | 1715.0 |
| 2024-05-17 04:15:00 | SPY | ETF | 528.21 | 528.21 | 528.15 | 528.21 | 742.0 |
| 2024-05-17 04:20:00 | SPY | ETF | 528.21 | 528.23 | 528.21 | 528.23 | 1000.0 |
| 2024-05-17 04:25:00 | SPY | ETF | 528.24 | 528.26 | 528.24 | 528.26 | 600.0 |
| 2024-05-17 04:30:00 | SPY | ETF | 528.19 | 528.19 | 528.1 | 528.13 | 1200.0 |
| 2024-05-17 04:35:00 | SPY | ETF | 528.18 | 528.19 | 528.18 | 528.18 | 894.0 |
| 2024-05-17 04:45:00 | SPY | ETF | 528.22 | 528.22 | 528.22 | 528.22 | 200.0 |
| 2024-05-17 04:55:00 | SPY | ETF | 528.37 | 528.37 | 528.37 | 528.37 | 800.0 |
| 2024-05-17 05:00:00 | SPY | ETF | 528.4 | 528.59 | 528.4 | 528.59 | 1332.0 |
| 2024-05-17 05:05:00 | SPY | ETF | 528.6 | 528.6 | 528.6 | 528.6 | 900.0 |
| 2024-05-17 05:10:00 | SPY | ETF | 528.69 | 528.74 | 528.69 | 528.74 | 1919.0 |
| 2024-05-17 05:15:00 | SPY | ETF | 528.63 | 528.63 | 528.48 | 528.48 | 300.0 |
| 2024-05-17 05:25:00 | SPY | ETF | 528.64 | 528.64 | 528.64 | 528.64 | 200.0 |
| 2024-05-17 05:30:00 | SPY | ETF | 528.64 | 528.67 | 528.58 | 528.58 | 825.0 |
| 2024-05-17 05:35:00 | SPY | ETF | 528.6 | 528.6 | 528.6 | 528.6 | 100.0 |
| 2024-05-17 05:45:00 | SPY | ETF | 528.7 | 528.82 | 528.7 | 528.77 | 1637.0 |
| 2024-05-17 05:50:00 | SPY | ETF | 528.82 | 528.82 | 528.82 | 528.82 | 100.0 |
| 2024-05-17 06:00:00 | SPY | ETF | 528.68 | 528.68 | 528.68 | 528.68 | 100.0 |
| 2024-05-17 06:05:00 | SPY | ETF | 528.5 | 528.5 | 528.5 | 528.5 | 1300.0 |
| 2024-05-17 06:25:00 | SPY | ETF | 528.68 | 528.68 | 528.68 | 528.68 | 111.0 |
| 2024-05-17 06:30:00 | SPY | ETF | 528.74 | 528.74 | 528.68 | 528.68 | 714.0 |
| 2024-05-17 06:35:00 | SPY | ETF | 528.65 | 528.65 | 528.55 | 528.55 | 1668.0 |
| 2024-05-17 06:40:00 | SPY | ETF | 528.56 | 528.56 | 528.56 | 528.56 | 200.0 |
| 2024-05-17 06:55:00 | SPY | ETF | 528.68 | 528.75 | 528.64 | 528.75 | 700.0 |
| 2024-05-17 07:00:00 | SPY | ETF | 528.78 | 528.84 | 528.78 | 528.79 | 1950.0 |
| 2024-05-17 07:05:00 | SPY | ETF | 528.73 | 528.76 | 528.68 | 528.68 | 2026.0 |
| 2024-05-17 07:10:00 | SPY | ETF | 528.7 | 528.7 | 528.6 | 528.63 | 20729.0 |
| 2024-05-17 07:15:00 | SPY | ETF | 528.61 | 528.81 | 528.61 | 528.81 | 3428.0 |
| 2024-05-17 07:20:00 | SPY | ETF | 528.8 | 528.84 | 528.8 | 528.84 | 1330.0 |
| 2024-05-17 07:25:00 | SPY | ETF | 528.841 | 528.96 | 528.841 | 528.96 | 2394.0 |
| 2024-05-17 07:30:00 | SPY | ETF | 528.91 | 529.0 | 528.91 | 528.98 | 4718.0 |
| 2024-05-17 07:35:00 | SPY | ETF | 528.9 | 528.95 | 528.85 | 528.95 | 9935.0 |
| 2024-05-17 07:40:00 | SPY | ETF | 528.98 | 529.09 | 528.98 | 529.04 | 3620.0 |
| 2024-05-17 07:45:00 | SPY | ETF | 529.04 | 529.07 | 528.99 | 529.0 | 12355.0 |
| 2024-05-17 07:50:00 | SPY | ETF | 529.0 | 529.02 | 528.99 | 528.99 | 40245.0 |
| 2024-05-17 07:55:00 | SPY | ETF | 528.92 | 528.96 | 528.9 | 528.9 | 2116.0 |
| 2024-05-17 08:00:00 | SPY | ETF | 528.8099 | 529.07 | 528.6104 | 528.94 | 21262.0 |
| 2024-05-17 08:05:00 | SPY | ETF | 529.0 | 529.06 | 528.68 | 529.06 | 6910.0 |
| 2024-05-17 08:10:00 | SPY | ETF | 529.07 | 529.07 | 528.95 | 528.95 | 6286.0 |
| 2024-05-17 08:15:00 | SPY | ETF | 528.94 | 528.95 | 528.82 | 528.95 | 9064.0 |
| 2024-05-17 08:20:00 | SPY | ETF | 528.97 | 529.14 | 528.94 | 528.97 | 11949.0 |
| 2024-05-17 08:25:00 | SPY | ETF | 528.96 | 529.1 | 528.96 | 529.09 | 2775.0 |
| 2024-05-17 08:30:00 | SPY | ETF | 529.13 | 529.18 | 529.09 | 529.14 | 6180.0 |
| 2024-05-17 08:35:00 | SPY | ETF | 529.12 | 529.23 | 529.12 | 529.17 | 62998.0 |
| 2024-05-17 08:40:00 | SPY | ETF | 529.17 | 529.22 | 529.0704 | 529.21 | 29413.0 |
| 2024-05-17 08:45:00 | SPY | ETF | 529.21 | 529.2502 | 529.15 | 529.23 | 8746.0 |
| 2024-05-17 08:50:00 | SPY | ETF | 529.24 | 529.24 | 529.16 | 529.2 | 13177.0 |
| 2024-05-17 08:55:00 | SPY | ETF | 529.2 | 529.33 | 529.2 | 529.32 | 14017.0 |
> showing 50 of 104,478 rows — these rows as CSV