PREVIEW / etf_5min / 2024-06-13
file: by_date/etf_5min/2024/2024-06-13.parquet size: 2.2 MB rows: 109,027
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-06-13 04:00:00 | SPY | ETF | 542.55 | 542.81 | 542.55 | 542.81 | 3053.0 |
| 2024-06-13 04:05:00 | SPY | ETF | 542.7 | 542.72 | 542.56 | 542.56 | 1008.0 |
| 2024-06-13 04:10:00 | SPY | ETF | 542.57 | 542.57 | 542.36 | 542.36 | 3524.0 |
| 2024-06-13 04:15:00 | SPY | ETF | 542.3 | 542.32 | 542.25 | 542.3 | 1981.0 |
| 2024-06-13 04:20:00 | SPY | ETF | 542.32 | 542.32 | 542.27 | 542.27 | 501.0 |
| 2024-06-13 04:25:00 | SPY | ETF | 542.34 | 542.37 | 542.29 | 542.29 | 903.0 |
| 2024-06-13 04:30:00 | SPY | ETF | 542.27 | 542.27 | 542.23 | 542.27 | 1050.0 |
| 2024-06-13 04:35:00 | SPY | ETF | 542.26 | 542.26 | 542.25 | 542.25 | 1500.0 |
| 2024-06-13 04:40:00 | SPY | ETF | 542.2 | 542.2 | 542.16 | 542.18 | 3150.0 |
| 2024-06-13 04:45:00 | SPY | ETF | 542.12 | 542.16 | 542.07 | 542.11 | 1999.0 |
| 2024-06-13 04:50:00 | SPY | ETF | 542.17 | 542.17 | 542.15 | 542.15 | 252.0 |
| 2024-06-13 04:55:00 | SPY | ETF | 542.22 | 542.22 | 542.22 | 542.22 | 400.0 |
| 2024-06-13 05:05:00 | SPY | ETF | 542.53 | 542.53 | 542.41 | 542.43 | 650.0 |
| 2024-06-13 05:10:00 | SPY | ETF | 542.46 | 542.46 | 542.36 | 542.41 | 2550.0 |
| 2024-06-13 05:15:00 | SPY | ETF | 542.3 | 542.3 | 542.25 | 542.25 | 432.0 |
| 2024-06-13 05:20:00 | SPY | ETF | 542.32 | 542.35 | 542.32 | 542.35 | 500.0 |
| 2024-06-13 05:25:00 | SPY | ETF | 542.18 | 542.18 | 542.04 | 542.04 | 1040.0 |
| 2024-06-13 05:30:00 | SPY | ETF | 542.02 | 542.05 | 541.99 | 542.05 | 900.0 |
| 2024-06-13 05:35:00 | SPY | ETF | 541.97 | 541.97 | 541.85 | 541.85 | 924.0 |
| 2024-06-13 05:40:00 | SPY | ETF | 541.75 | 541.75 | 541.55 | 541.55 | 2487.0 |
| 2024-06-13 05:45:00 | SPY | ETF | 541.6 | 541.68 | 541.59 | 541.59 | 1390.0 |
| 2024-06-13 05:50:00 | SPY | ETF | 541.6 | 541.61 | 541.56 | 541.56 | 1600.0 |
| 2024-06-13 05:55:00 | SPY | ETF | 541.63 | 541.63 | 541.57 | 541.61 | 1450.0 |
| 2024-06-13 06:00:00 | SPY | ETF | 541.7 | 541.8 | 541.7 | 541.8 | 398.0 |
| 2024-06-13 06:05:00 | SPY | ETF | 541.89 | 541.89 | 541.82 | 541.82 | 400.0 |
| 2024-06-13 06:10:00 | SPY | ETF | 541.72 | 541.76 | 541.71 | 541.76 | 700.0 |
| 2024-06-13 06:15:00 | SPY | ETF | 541.71 | 541.71 | 541.41 | 541.41 | 2300.0 |
| 2024-06-13 06:20:00 | SPY | ETF | 541.45 | 541.48 | 541.45 | 541.48 | 1277.0 |
| 2024-06-13 06:25:00 | SPY | ETF | 541.68 | 541.79 | 541.68 | 541.79 | 775.0 |
| 2024-06-13 06:30:00 | SPY | ETF | 541.81 | 541.87 | 541.8 | 541.84 | 3700.0 |
| 2024-06-13 06:35:00 | SPY | ETF | 541.81 | 541.81 | 541.8 | 541.8 | 8426.0 |
| 2024-06-13 06:40:00 | SPY | ETF | 541.79 | 541.81 | 541.75 | 541.81 | 4738.0 |
| 2024-06-13 06:45:00 | SPY | ETF | 541.75 | 541.75 | 541.75 | 541.75 | 135.0 |
| 2024-06-13 06:50:00 | SPY | ETF | 541.37 | 541.75 | 541.37 | 541.74 | 698.0 |
| 2024-06-13 06:55:00 | SPY | ETF | 541.93 | 541.95 | 541.93 | 541.95 | 400.0 |
| 2024-06-13 07:00:00 | SPY | ETF | 541.99 | 542.04 | 541.9 | 541.95 | 97618.0 |
| 2024-06-13 07:05:00 | SPY | ETF | 541.98 | 541.98 | 541.96 | 541.96 | 1720.0 |
| 2024-06-13 07:10:00 | SPY | ETF | 541.94 | 542.15 | 541.94 | 542.15 | 27037.0 |
| 2024-06-13 07:15:00 | SPY | ETF | 542.17 | 542.24 | 542.06 | 542.06 | 64578.0 |
| 2024-06-13 07:20:00 | SPY | ETF | 542.05 | 542.05 | 541.99 | 542.04 | 600.0 |
| 2024-06-13 07:25:00 | SPY | ETF | 542.09 | 542.09 | 542.0 | 542.02 | 5271.0 |
| 2024-06-13 07:30:00 | SPY | ETF | 542.03 | 542.07 | 541.98 | 542.03 | 6467.0 |
| 2024-06-13 07:35:00 | SPY | ETF | 542.07 | 542.24 | 542.07 | 542.2 | 24088.0 |
| 2024-06-13 07:40:00 | SPY | ETF | 542.04 | 542.17 | 542.0 | 542.16 | 4779.0 |
| 2024-06-13 07:45:00 | SPY | ETF | 541.98 | 542.02 | 541.97 | 542.02 | 2721.0 |
| 2024-06-13 07:50:00 | SPY | ETF | 542.01 | 542.02 | 541.9 | 541.97 | 25216.0 |
| 2024-06-13 07:55:00 | SPY | ETF | 541.93 | 541.95 | 541.89 | 541.89 | 25986.0 |
| 2024-06-13 08:00:00 | SPY | ETF | 541.9782 | 542.86 | 541.8104 | 542.08 | 23675.0 |
| 2024-06-13 08:05:00 | SPY | ETF | 542.07 | 542.65 | 542.06 | 542.2683 | 3213.0 |
| 2024-06-13 08:10:00 | SPY | ETF | 542.29 | 542.69 | 542.27 | 542.66 | 11620.0 |
> showing 50 of 109,027 rows — these rows as CSV