PREVIEW / futures_5min / 2024-07-31
file: by_date/futures_5min/2024/2024-07-31.parquet size: 392 KB rows: 20,909
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-31 00:00:00 | ES | Futures | 5764.72 | 5767.34 | 5758.96 | 5760.79 | 2967.0 |
| 2024-07-31 00:05:00 | ES | Futures | 5760.53 | 5761.31 | 5758.96 | 5760.53 | 865.0 |
| 2024-07-31 00:10:00 | ES | Futures | 5760.53 | 5761.31 | 5758.96 | 5759.74 | 627.0 |
| 2024-07-31 00:15:00 | ES | Futures | 5760.0 | 5761.58 | 5758.96 | 5760.27 | 1888.0 |
| 2024-07-31 00:20:00 | ES | Futures | 5760.0 | 5761.31 | 5758.96 | 5759.22 | 650.0 |
| 2024-07-31 00:25:00 | ES | Futures | 5759.22 | 5759.74 | 5757.91 | 5759.22 | 482.0 |
| 2024-07-31 00:30:00 | ES | Futures | 5759.48 | 5760.0 | 5758.69 | 5759.74 | 318.0 |
| 2024-07-31 00:35:00 | ES | Futures | 5760.0 | 5760.53 | 5759.22 | 5760.53 | 243.0 |
| 2024-07-31 00:40:00 | ES | Futures | 5760.27 | 5762.89 | 5760.0 | 5762.1 | 833.0 |
| 2024-07-31 00:45:00 | ES | Futures | 5762.1 | 5763.15 | 5761.58 | 5762.63 | 722.0 |
| 2024-07-31 00:50:00 | ES | Futures | 5762.63 | 5762.89 | 5761.05 | 5762.1 | 580.0 |
| 2024-07-31 00:55:00 | ES | Futures | 5762.36 | 5762.36 | 5759.74 | 5761.31 | 962.0 |
| 2024-07-31 01:00:00 | ES | Futures | 5761.58 | 5761.58 | 5760.27 | 5760.79 | 455.0 |
| 2024-07-31 01:05:00 | ES | Futures | 5760.79 | 5761.05 | 5759.74 | 5760.53 | 298.0 |
| 2024-07-31 01:10:00 | ES | Futures | 5760.53 | 5761.58 | 5760.53 | 5761.31 | 322.0 |
| 2024-07-31 01:15:00 | ES | Futures | 5761.31 | 5762.36 | 5760.27 | 5762.36 | 421.0 |
| 2024-07-31 01:20:00 | ES | Futures | 5762.1 | 5764.2 | 5761.58 | 5762.1 | 1288.0 |
| 2024-07-31 01:25:00 | ES | Futures | 5762.1 | 5764.2 | 5761.05 | 5763.67 | 632.0 |
| 2024-07-31 01:30:00 | ES | Futures | 5763.94 | 5765.77 | 5763.67 | 5765.77 | 1063.0 |
| 2024-07-31 01:35:00 | ES | Futures | 5766.03 | 5772.06 | 5765.77 | 5769.18 | 2756.0 |
| 2024-07-31 01:40:00 | ES | Futures | 5769.18 | 5778.09 | 5768.92 | 5777.31 | 3032.0 |
| 2024-07-31 01:45:00 | ES | Futures | 5777.57 | 5781.24 | 5776.52 | 5780.45 | 3447.0 |
| 2024-07-31 01:50:00 | ES | Futures | 5780.45 | 5782.29 | 5779.4 | 5782.03 | 1962.0 |
| 2024-07-31 01:55:00 | ES | Futures | 5781.76 | 5782.55 | 5780.45 | 5780.72 | 1522.0 |
| 2024-07-31 02:00:00 | ES | Futures | 5780.72 | 5781.5 | 5776.26 | 5778.36 | 4003.0 |
| 2024-07-31 02:05:00 | ES | Futures | 5778.09 | 5778.88 | 5775.21 | 5776.0 | 1864.0 |
| 2024-07-31 02:10:00 | ES | Futures | 5775.73 | 5782.29 | 5775.73 | 5781.76 | 2233.0 |
| 2024-07-31 02:15:00 | ES | Futures | 5781.76 | 5784.91 | 5780.98 | 5784.12 | 3305.0 |
| 2024-07-31 02:20:00 | ES | Futures | 5784.12 | 5785.17 | 5783.34 | 5784.39 | 1371.0 |
| 2024-07-31 02:25:00 | ES | Futures | 5784.39 | 5784.65 | 5782.29 | 5782.81 | 1105.0 |
| 2024-07-31 02:30:00 | ES | Futures | 5783.07 | 5788.06 | 5783.07 | 5787.53 | 2727.0 |
| 2024-07-31 02:35:00 | ES | Futures | 5787.79 | 5787.79 | 5785.17 | 5786.74 | 1341.0 |
| 2024-07-31 02:40:00 | ES | Futures | 5787.01 | 5787.53 | 5783.6 | 5785.96 | 1601.0 |
| 2024-07-31 02:45:00 | ES | Futures | 5785.7 | 5787.27 | 5785.43 | 5786.48 | 902.0 |
| 2024-07-31 02:50:00 | ES | Futures | 5786.48 | 5786.74 | 5784.91 | 5785.96 | 891.0 |
| 2024-07-31 02:55:00 | ES | Futures | 5785.96 | 5786.22 | 5783.86 | 5785.96 | 1283.0 |
| 2024-07-31 03:00:00 | ES | Futures | 5785.7 | 5786.22 | 5781.76 | 5782.81 | 3113.0 |
| 2024-07-31 03:05:00 | ES | Futures | 5782.81 | 5783.07 | 5779.93 | 5782.55 | 2548.0 |
| 2024-07-31 03:10:00 | ES | Futures | 5782.29 | 5785.17 | 5781.5 | 5784.91 | 1695.0 |
| 2024-07-31 03:15:00 | ES | Futures | 5785.17 | 5786.22 | 5782.81 | 5785.96 | 1633.0 |
| 2024-07-31 03:20:00 | ES | Futures | 5785.96 | 5788.58 | 5784.39 | 5784.91 | 2927.0 |
| 2024-07-31 03:25:00 | ES | Futures | 5784.91 | 5787.27 | 5784.12 | 5784.91 | 1649.0 |
| 2024-07-31 03:30:00 | ES | Futures | 5785.17 | 5786.48 | 5783.07 | 5783.86 | 1782.0 |
| 2024-07-31 03:35:00 | ES | Futures | 5784.12 | 5787.01 | 5783.86 | 5786.74 | 1347.0 |
| 2024-07-31 03:40:00 | ES | Futures | 5786.74 | 5787.27 | 5785.17 | 5786.74 | 1098.0 |
| 2024-07-31 03:45:00 | ES | Futures | 5786.74 | 5789.1 | 5786.22 | 5788.84 | 1541.0 |
| 2024-07-31 03:50:00 | ES | Futures | 5788.84 | 5790.68 | 5788.58 | 5789.63 | 1891.0 |
| 2024-07-31 03:55:00 | ES | Futures | 5789.63 | 5791.2 | 5788.58 | 5790.94 | 2520.0 |
| 2024-07-31 04:00:00 | ES | Futures | 5790.68 | 5791.2 | 5788.58 | 5788.58 | 3936.0 |
| 2024-07-31 04:05:00 | ES | Futures | 5788.58 | 5789.37 | 5783.34 | 5783.86 | 4465.0 |
> showing 50 of 20,909 rows — these rows as CSV