PREVIEW / etf_5min / 2024-07-25
file: by_date/etf_5min/2024/2024-07-25.parquet size: 2.4 MB rows: 119,221
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-07-25 04:00:00 | SPY | ETF | 541.88 | 542.28 | 539.91 | 540.02 | 33440.0 |
| 2024-07-25 04:05:00 | SPY | ETF | 540.22 | 540.26 | 539.51 | 539.51 | 7292.0 |
| 2024-07-25 04:10:00 | SPY | ETF | 539.53 | 539.83 | 539.5 | 539.5 | 3326.0 |
| 2024-07-25 04:15:00 | SPY | ETF | 539.41 | 539.45 | 539.28 | 539.28 | 3316.0 |
| 2024-07-25 04:20:00 | SPY | ETF | 539.5 | 539.74 | 539.47 | 539.53 | 917.0 |
| 2024-07-25 04:25:00 | SPY | ETF | 540.35 | 540.75 | 540.34 | 540.75 | 6128.0 |
| 2024-07-25 04:30:00 | SPY | ETF | 540.55 | 541.19 | 540.53 | 541.16 | 6282.0 |
| 2024-07-25 04:35:00 | SPY | ETF | 541.03 | 541.04 | 540.71 | 541.0 | 4170.0 |
| 2024-07-25 04:40:00 | SPY | ETF | 541.09 | 541.57 | 541.09 | 541.36 | 1793.0 |
| 2024-07-25 04:45:00 | SPY | ETF | 541.4 | 541.4 | 541.13 | 541.18 | 6750.0 |
| 2024-07-25 04:50:00 | SPY | ETF | 541.25 | 541.55 | 541.25 | 541.52 | 3392.0 |
| 2024-07-25 04:55:00 | SPY | ETF | 541.58 | 541.71 | 541.54 | 541.69 | 1592.0 |
| 2024-07-25 05:00:00 | SPY | ETF | 541.72 | 541.72 | 541.54 | 541.61 | 6365.0 |
| 2024-07-25 05:05:00 | SPY | ETF | 541.9 | 542.14 | 541.9 | 542.12 | 5961.0 |
| 2024-07-25 05:10:00 | SPY | ETF | 542.15 | 542.15 | 541.31 | 541.31 | 1558.0 |
| 2024-07-25 05:15:00 | SPY | ETF | 541.23 | 541.36 | 541.11 | 541.33 | 2590.0 |
| 2024-07-25 05:20:00 | SPY | ETF | 541.39 | 541.39 | 540.92 | 540.95 | 14252.0 |
| 2024-07-25 05:25:00 | SPY | ETF | 540.87 | 540.99 | 540.75 | 540.99 | 28696.0 |
| 2024-07-25 05:30:00 | SPY | ETF | 541.23 | 541.34 | 540.95 | 541.13 | 3850.0 |
| 2024-07-25 05:35:00 | SPY | ETF | 541.01 | 541.01 | 540.72 | 540.72 | 5283.0 |
| 2024-07-25 05:40:00 | SPY | ETF | 540.77 | 541.01 | 540.77 | 540.83 | 12797.0 |
| 2024-07-25 05:45:00 | SPY | ETF | 540.65 | 540.65 | 540.35 | 540.65 | 1646.0 |
| 2024-07-25 05:50:00 | SPY | ETF | 540.73 | 540.73 | 540.55 | 540.55 | 10800.0 |
| 2024-07-25 05:55:00 | SPY | ETF | 540.4 | 540.43 | 540.28 | 540.43 | 3006.0 |
| 2024-07-25 06:00:00 | SPY | ETF | 540.49 | 540.61 | 540.25 | 540.25 | 300.0 |
| 2024-07-25 06:05:00 | SPY | ETF | 540.38 | 540.38 | 540.38 | 540.38 | 100.0 |
| 2024-07-25 06:10:00 | SPY | ETF | 540.06 | 540.06 | 539.77 | 539.8 | 1594.0 |
| 2024-07-25 06:15:00 | SPY | ETF | 539.87 | 539.93 | 539.67 | 539.87 | 1973.0 |
| 2024-07-25 06:20:00 | SPY | ETF | 539.86 | 540.61 | 539.81 | 540.47 | 3949.0 |
| 2024-07-25 06:25:00 | SPY | ETF | 540.49 | 540.51 | 539.81 | 539.83 | 1601.0 |
| 2024-07-25 06:30:00 | SPY | ETF | 539.83 | 540.34 | 539.83 | 540.34 | 3455.0 |
| 2024-07-25 06:35:00 | SPY | ETF | 540.31 | 540.31 | 539.78 | 539.9 | 8892.0 |
| 2024-07-25 06:40:00 | SPY | ETF | 540.0 | 540.01 | 539.73 | 539.81 | 3929.0 |
| 2024-07-25 06:45:00 | SPY | ETF | 539.77 | 540.17 | 539.77 | 539.98 | 8650.0 |
| 2024-07-25 06:50:00 | SPY | ETF | 539.98 | 540.31 | 539.98 | 540.29 | 8775.0 |
| 2024-07-25 06:55:00 | SPY | ETF | 540.42 | 540.73 | 540.35 | 540.59 | 15923.0 |
| 2024-07-25 07:00:00 | SPY | ETF | 540.6 | 540.79 | 540.57 | 540.731 | 6662.0 |
| 2024-07-25 07:05:00 | SPY | ETF | 540.72 | 541.27 | 540.7 | 541.23 | 8138.0 |
| 2024-07-25 07:10:00 | SPY | ETF | 541.1 | 541.11 | 540.95 | 540.99 | 11168.0 |
| 2024-07-25 07:15:00 | SPY | ETF | 540.97 | 541.13 | 540.82 | 541.11 | 21751.0 |
| 2024-07-25 07:20:00 | SPY | ETF | 541.2 | 541.2 | 540.8 | 540.82 | 16778.0 |
| 2024-07-25 07:25:00 | SPY | ETF | 540.82 | 540.82 | 540.4 | 540.5 | 29421.0 |
| 2024-07-25 07:30:00 | SPY | ETF | 540.37 | 540.68 | 540.26 | 540.67 | 3790.0 |
| 2024-07-25 07:35:00 | SPY | ETF | 540.76 | 540.88 | 540.39 | 540.73 | 19953.0 |
| 2024-07-25 07:40:00 | SPY | ETF | 540.76 | 541.06 | 540.65 | 540.73 | 14573.0 |
| 2024-07-25 07:45:00 | SPY | ETF | 540.8 | 540.98 | 540.32 | 540.49 | 17069.0 |
| 2024-07-25 07:50:00 | SPY | ETF | 540.55 | 540.55 | 540.13 | 540.24 | 24855.0 |
| 2024-07-25 07:55:00 | SPY | ETF | 540.19 | 540.28 | 539.97 | 539.97 | 36023.0 |
| 2024-07-25 08:00:00 | SPY | ETF | 541.02 | 542.69 | 540.0 | 542.1 | 77251.0 |
| 2024-07-25 08:05:00 | SPY | ETF | 540.45 | 540.54 | 540.4 | 540.47 | 40737.0 |
> showing 50 of 119,221 rows — these rows as CSV