PREVIEW / etf_5min / 2024-12-17
file: by_date/etf_5min/2024/2024-12-17.parquet size: 2.7 MB rows: 130,194
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-12-17 04:00:00 | SPY | ETF | 605.35 | 605.35 | 604.8 | 605.19 | 21329.0 |
| 2024-12-17 04:05:00 | SPY | ETF | 605.12 | 605.21 | 605.02 | 605.21 | 3017.0 |
| 2024-12-17 04:10:00 | SPY | ETF | 605.15 | 605.2 | 605.11 | 605.2 | 2300.0 |
| 2024-12-17 04:15:00 | SPY | ETF | 605.2 | 605.22 | 605.15 | 605.15 | 1731.0 |
| 2024-12-17 04:20:00 | SPY | ETF | 605.15 | 605.15 | 604.87 | 604.87 | 1411.0 |
| 2024-12-17 04:25:00 | SPY | ETF | 604.87 | 604.87 | 604.87 | 604.87 | 100.0 |
| 2024-12-17 04:30:00 | SPY | ETF | 605.1 | 605.17 | 605.06 | 605.09 | 3645.0 |
| 2024-12-17 04:35:00 | SPY | ETF | 605.11 | 605.16 | 605.09 | 605.09 | 873.0 |
| 2024-12-17 04:40:00 | SPY | ETF | 605.1 | 605.11 | 605.01 | 605.11 | 929.0 |
| 2024-12-17 04:45:00 | SPY | ETF | 605.08 | 605.08 | 605.08 | 605.08 | 384.0 |
| 2024-12-17 04:50:00 | SPY | ETF | 605.18 | 605.2 | 605.17 | 605.2 | 900.0 |
| 2024-12-17 04:55:00 | SPY | ETF | 605.36 | 605.36 | 605.33 | 605.33 | 600.0 |
| 2024-12-17 05:00:00 | SPY | ETF | 605.37 | 605.37 | 605.24 | 605.24 | 280.0 |
| 2024-12-17 05:05:00 | SPY | ETF | 605.36 | 605.36 | 605.36 | 605.36 | 200.0 |
| 2024-12-17 05:10:00 | SPY | ETF | 605.39 | 605.39 | 605.32 | 605.32 | 487.0 |
| 2024-12-17 05:15:00 | SPY | ETF | 605.16 | 605.16 | 605.16 | 605.16 | 250.0 |
| 2024-12-17 05:20:00 | SPY | ETF | 605.0 | 605.08 | 605.0 | 605.08 | 200.0 |
| 2024-12-17 05:25:00 | SPY | ETF | 605.06 | 605.06 | 605.06 | 605.06 | 748.0 |
| 2024-12-17 05:40:00 | SPY | ETF | 605.36 | 605.36 | 605.36 | 605.36 | 313.0 |
| 2024-12-17 05:45:00 | SPY | ETF | 605.35 | 605.35 | 605.24 | 605.24 | 200.0 |
| 2024-12-17 05:50:00 | SPY | ETF | 605.24 | 605.24 | 605.24 | 605.24 | 187.0 |
| 2024-12-17 05:55:00 | SPY | ETF | 605.42 | 605.42 | 605.39 | 605.39 | 900.0 |
| 2024-12-17 06:05:00 | SPY | ETF | 605.14 | 605.19 | 605.14 | 605.19 | 309.0 |
| 2024-12-17 06:10:00 | SPY | ETF | 605.28 | 605.28 | 605.28 | 605.28 | 100.0 |
| 2024-12-17 06:15:00 | SPY | ETF | 605.5 | 605.62 | 605.5 | 605.62 | 900.0 |
| 2024-12-17 06:20:00 | SPY | ETF | 605.57 | 605.61 | 605.57 | 605.61 | 2600.0 |
| 2024-12-17 06:25:00 | SPY | ETF | 605.49 | 605.53 | 605.49 | 605.53 | 304.0 |
| 2024-12-17 06:40:00 | SPY | ETF | 605.2 | 605.2 | 604.98 | 605.05 | 1976.0 |
| 2024-12-17 06:45:00 | SPY | ETF | 604.85 | 604.99 | 604.85 | 604.99 | 1000.0 |
| 2024-12-17 06:50:00 | SPY | ETF | 604.95 | 604.95 | 604.85 | 604.85 | 18226.0 |
| 2024-12-17 06:55:00 | SPY | ETF | 604.85 | 605.02 | 604.85 | 605.02 | 4822.0 |
| 2024-12-17 07:00:00 | SPY | ETF | 605.09 | 605.25 | 604.94 | 604.94 | 4626.0 |
| 2024-12-17 07:05:00 | SPY | ETF | 604.94 | 604.99 | 604.87 | 604.92 | 8655.0 |
| 2024-12-17 07:10:00 | SPY | ETF | 604.9 | 605.0 | 604.8 | 604.98 | 12165.0 |
| 2024-12-17 07:15:00 | SPY | ETF | 604.94 | 604.94 | 604.86 | 604.909 | 8272.0 |
| 2024-12-17 07:20:00 | SPY | ETF | 604.95 | 604.95 | 604.8 | 604.84 | 26516.0 |
| 2024-12-17 07:25:00 | SPY | ETF | 604.88 | 604.91 | 604.86 | 604.91 | 4890.0 |
| 2024-12-17 07:30:00 | SPY | ETF | 604.86 | 604.86 | 604.81 | 604.83 | 2718.0 |
| 2024-12-17 07:35:00 | SPY | ETF | 604.82 | 604.85 | 604.8 | 604.81 | 4960.0 |
| 2024-12-17 07:40:00 | SPY | ETF | 604.88 | 605.01 | 604.88 | 605.01 | 1232.0 |
| 2024-12-17 07:45:00 | SPY | ETF | 604.93 | 605.02 | 604.9 | 604.93 | 32417.0 |
| 2024-12-17 07:50:00 | SPY | ETF | 604.89 | 604.9 | 604.83 | 604.83 | 5995.0 |
| 2024-12-17 07:55:00 | SPY | ETF | 604.83 | 604.84 | 604.66 | 604.68 | 25361.0 |
| 2024-12-17 08:00:00 | SPY | ETF | 604.86 | 606.46 | 604.04 | 604.1198 | 91509.0 |
| 2024-12-17 08:05:00 | SPY | ETF | 604.11 | 604.21 | 604.02 | 604.06 | 24463.0 |
| 2024-12-17 08:10:00 | SPY | ETF | 604.06 | 604.23 | 604.04 | 604.12 | 14431.0 |
| 2024-12-17 08:15:00 | SPY | ETF | 604.2 | 604.43 | 604.18 | 604.43 | 11344.0 |
| 2024-12-17 08:20:00 | SPY | ETF | 604.42 | 604.49 | 604.35 | 604.48 | 22717.0 |
| 2024-12-17 08:25:00 | SPY | ETF | 604.5 | 604.5 | 604.3 | 604.35 | 10376.0 |
| 2024-12-17 08:30:00 | SPY | ETF | 604.27 | 604.65 | 604.21 | 604.41 | 40048.0 |
> showing 50 of 130,194 rows — these rows as CSV