PREVIEW / etf_5min / 2024-05-16
file: by_date/etf_5min/2024/2024-05-16.parquet size: 2.2 MB rows: 106,990
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-16 04:00:00 | SPY | ETF | 530.8 | 530.8 | 530.39 | 530.42 | 3298.0 |
| 2024-05-16 04:05:00 | SPY | ETF | 530.4 | 530.45 | 530.4 | 530.45 | 700.0 |
| 2024-05-16 04:10:00 | SPY | ETF | 530.33 | 530.33 | 530.28 | 530.28 | 1059.0 |
| 2024-05-16 04:15:00 | SPY | ETF | 530.25 | 530.27 | 530.19 | 530.27 | 2637.0 |
| 2024-05-16 04:20:00 | SPY | ETF | 530.22 | 530.23 | 530.22 | 530.22 | 1599.0 |
| 2024-05-16 04:25:00 | SPY | ETF | 530.23 | 530.25 | 530.18 | 530.18 | 2000.0 |
| 2024-05-16 04:30:00 | SPY | ETF | 530.24 | 530.25 | 530.21 | 530.21 | 1441.0 |
| 2024-05-16 04:35:00 | SPY | ETF | 530.24 | 530.24 | 530.24 | 530.24 | 687.0 |
| 2024-05-16 04:40:00 | SPY | ETF | 530.38 | 530.38 | 530.31 | 530.31 | 719.0 |
| 2024-05-16 04:45:00 | SPY | ETF | 530.38 | 530.41 | 530.35 | 530.35 | 715.0 |
| 2024-05-16 04:50:00 | SPY | ETF | 530.35 | 530.35 | 530.35 | 530.35 | 500.0 |
| 2024-05-16 04:55:00 | SPY | ETF | 530.35 | 530.35 | 530.35 | 530.35 | 200.0 |
| 2024-05-16 05:00:00 | SPY | ETF | 530.31 | 530.31 | 530.28 | 530.28 | 200.0 |
| 2024-05-16 05:05:00 | SPY | ETF | 530.31 | 530.35 | 530.31 | 530.33 | 975.0 |
| 2024-05-16 05:15:00 | SPY | ETF | 530.41 | 530.41 | 530.41 | 530.41 | 100.0 |
| 2024-05-16 05:20:00 | SPY | ETF | 530.46 | 530.46 | 530.46 | 530.46 | 300.0 |
| 2024-05-16 05:25:00 | SPY | ETF | 530.35 | 530.37 | 530.35 | 530.36 | 800.0 |
| 2024-05-16 05:30:00 | SPY | ETF | 530.33 | 530.33 | 530.25 | 530.25 | 1999.0 |
| 2024-05-16 05:35:00 | SPY | ETF | 530.29 | 530.29 | 530.29 | 530.29 | 1175.0 |
| 2024-05-16 05:40:00 | SPY | ETF | 530.26 | 530.31 | 530.26 | 530.31 | 803.0 |
| 2024-05-16 05:45:00 | SPY | ETF | 530.4 | 530.4 | 530.4 | 530.4 | 100.0 |
| 2024-05-16 05:50:00 | SPY | ETF | 530.33 | 530.33 | 530.33 | 530.33 | 100.0 |
| 2024-05-16 05:55:00 | SPY | ETF | 530.33 | 530.33 | 530.23 | 530.23 | 373.0 |
| 2024-05-16 06:00:00 | SPY | ETF | 530.33 | 530.33 | 530.29 | 530.29 | 700.0 |
| 2024-05-16 06:05:00 | SPY | ETF | 530.24 | 530.28 | 530.21 | 530.21 | 1600.0 |
| 2024-05-16 06:10:00 | SPY | ETF | 530.25 | 530.25 | 530.25 | 530.25 | 250.0 |
| 2024-05-16 06:15:00 | SPY | ETF | 530.22 | 530.22 | 530.16 | 530.16 | 325.0 |
| 2024-05-16 06:20:00 | SPY | ETF | 530.17 | 530.17 | 530.17 | 530.17 | 400.0 |
| 2024-05-16 06:25:00 | SPY | ETF | 530.14 | 530.15 | 530.12 | 530.13 | 2697.0 |
| 2024-05-16 06:30:00 | SPY | ETF | 530.13 | 530.15 | 530.12 | 530.12 | 2370.0 |
| 2024-05-16 06:35:00 | SPY | ETF | 530.12 | 530.15 | 530.09 | 530.09 | 2150.0 |
| 2024-05-16 06:40:00 | SPY | ETF | 530.23 | 530.25 | 530.23 | 530.25 | 1550.0 |
| 2024-05-16 06:45:00 | SPY | ETF | 530.26 | 530.32 | 530.21 | 530.27 | 2192.0 |
| 2024-05-16 06:50:00 | SPY | ETF | 530.23 | 530.29 | 530.23 | 530.24 | 800.0 |
| 2024-05-16 06:55:00 | SPY | ETF | 530.29 | 530.29 | 530.2 | 530.2 | 1400.0 |
| 2024-05-16 07:00:00 | SPY | ETF | 530.25 | 530.43 | 530.25 | 530.28 | 8000.0 |
| 2024-05-16 07:05:00 | SPY | ETF | 530.38 | 530.38 | 530.35 | 530.35 | 839.0 |
| 2024-05-16 07:10:00 | SPY | ETF | 530.39 | 530.42 | 530.35 | 530.4 | 6058.0 |
| 2024-05-16 07:15:00 | SPY | ETF | 530.44 | 530.47 | 530.42 | 530.47 | 2001.0 |
| 2024-05-16 07:20:00 | SPY | ETF | 530.44 | 530.44 | 530.35 | 530.35 | 4851.0 |
| 2024-05-16 07:25:00 | SPY | ETF | 530.48 | 530.61 | 530.48 | 530.61 | 3743.0 |
| 2024-05-16 07:30:00 | SPY | ETF | 530.62 | 530.62 | 530.37 | 530.37 | 3144.0 |
| 2024-05-16 07:35:00 | SPY | ETF | 530.35 | 530.41 | 530.32 | 530.4 | 3375.0 |
| 2024-05-16 07:40:00 | SPY | ETF | 530.37 | 530.37 | 530.34 | 530.37 | 500.0 |
| 2024-05-16 07:45:00 | SPY | ETF | 530.42 | 530.48 | 530.42 | 530.48 | 1360.0 |
| 2024-05-16 07:50:00 | SPY | ETF | 530.48 | 530.48 | 530.39 | 530.39 | 2000.0 |
| 2024-05-16 07:55:00 | SPY | ETF | 530.41 | 530.41 | 530.35 | 530.36 | 11529.0 |
| 2024-05-16 08:00:00 | SPY | ETF | 530.33 | 530.89 | 530.0904 | 530.35 | 35668.0 |
| 2024-05-16 08:05:00 | SPY | ETF | 530.29 | 530.52 | 530.22 | 530.25 | 3258.0 |
| 2024-05-16 08:10:00 | SPY | ETF | 530.221 | 530.28 | 530.2 | 530.28 | 2518.0 |
> showing 50 of 106,990 rows — these rows as CSV