PREVIEW / futures_1hour / 2025-05-02
file: by_date/futures_1hour/2025/2025-05-02.parquet size: 60 KB rows: 1,726
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-02 00:00:00 | ES | Futures | 5759.34 | 5765.69 | 5754.01 | 5759.6 | 5915.0 |
| 2025-05-02 01:00:00 | ES | Futures | 5759.85 | 5760.87 | 5748.16 | 5750.45 | 6187.0 |
| 2025-05-02 02:00:00 | ES | Futures | 5750.45 | 5750.45 | 5738.0 | 5745.37 | 9550.0 |
| 2025-05-02 03:00:00 | ES | Futures | 5745.62 | 5753.75 | 5738.76 | 5739.53 | 16678.0 |
| 2025-05-02 04:00:00 | ES | Futures | 5739.53 | 5748.42 | 5726.57 | 5726.82 | 15456.0 |
| 2025-05-02 05:00:00 | ES | Futures | 5726.82 | 5742.58 | 5724.54 | 5738.0 | 11308.0 |
| 2025-05-02 06:00:00 | ES | Futures | 5737.75 | 5744.61 | 5735.46 | 5740.03 | 10165.0 |
| 2025-05-02 07:00:00 | ES | Futures | 5740.03 | 5744.86 | 5731.14 | 5734.45 | 14481.0 |
| 2025-05-02 08:00:00 | ES | Futures | 5734.45 | 5784.75 | 5732.41 | 5782.46 | 62559.0 |
| 2025-05-02 09:00:00 | ES | Futures | 5782.46 | 5791.1 | 5754.52 | 5767.22 | 160440.0 |
| 2025-05-02 10:00:00 | ES | Futures | 5767.73 | 5795.92 | 5763.66 | 5790.59 | 174472.0 |
| 2025-05-02 11:00:00 | ES | Futures | 5790.59 | 5796.94 | 5776.62 | 5795.16 | 124108.0 |
| 2025-05-02 12:00:00 | ES | Futures | 5794.91 | 5813.96 | 5794.15 | 5808.12 | 146214.0 |
| 2025-05-02 13:00:00 | ES | Futures | 5808.12 | 5811.17 | 5796.18 | 5805.32 | 91322.0 |
| 2025-05-02 14:00:00 | ES | Futures | 5805.32 | 5817.26 | 5797.19 | 5804.05 | 93858.0 |
| 2025-05-02 15:00:00 | ES | Futures | 5803.8 | 5811.93 | 5792.37 | 5797.96 | 251508.0 |
| 2025-05-02 16:00:00 | ES | Futures | 5797.96 | 5806.85 | 5797.19 | 5802.78 | 53271.0 |
| 2025-05-02 00:00:00 | NQ | Futures | 20350.07 | 20377.32 | 20332.24 | 20356.94 | 3959.0 |
| 2025-05-02 01:00:00 | NQ | Futures | 20357.71 | 20361.02 | 20311.62 | 20321.8 | 3853.0 |
| 2025-05-02 02:00:00 | NQ | Futures | 20320.02 | 20320.02 | 20253.05 | 20301.17 | 7169.0 |
| 2025-05-02 03:00:00 | NQ | Futures | 20301.68 | 20330.97 | 20271.38 | 20273.42 | 8880.0 |
| 2025-05-02 04:00:00 | NQ | Futures | 20272.4 | 20320.78 | 20236.49 | 20240.06 | 8395.0 |
| 2025-05-02 05:00:00 | NQ | Futures | 20239.29 | 20304.99 | 20233.69 | 20289.21 | 6168.0 |
| 2025-05-02 06:00:00 | NQ | Futures | 20290.22 | 20327.4 | 20279.78 | 20302.96 | 6297.0 |
| 2025-05-02 07:00:00 | NQ | Futures | 20302.96 | 20329.44 | 20271.89 | 20288.44 | 7770.0 |
| 2025-05-02 08:00:00 | NQ | Futures | 20288.95 | 20479.69 | 20281.57 | 20469.25 | 27907.0 |
| 2025-05-02 09:00:00 | NQ | Futures | 20469.75 | 20516.1 | 20392.34 | 20446.58 | 72308.0 |
| 2025-05-02 10:00:00 | NQ | Futures | 20446.58 | 20556.34 | 20435.38 | 20540.8 | 66974.0 |
| 2025-05-02 11:00:00 | NQ | Futures | 20541.31 | 20583.08 | 20501.84 | 20573.65 | 47167.0 |
| 2025-05-02 12:00:00 | NQ | Futures | 20572.89 | 20643.17 | 20567.8 | 20618.47 | 51223.0 |
| 2025-05-02 13:00:00 | NQ | Futures | 20618.73 | 20631.46 | 20572.13 | 20602.43 | 36692.0 |
| 2025-05-02 14:00:00 | NQ | Futures | 20601.92 | 20654.12 | 20574.67 | 20597.59 | 32950.0 |
| 2025-05-02 15:00:00 | NQ | Futures | 20597.08 | 20612.11 | 20527.31 | 20562.19 | 64473.0 |
| 2025-05-02 16:00:00 | NQ | Futures | 20561.18 | 20601.41 | 20553.03 | 20580.53 | 14085.0 |
| 2025-05-02 00:00:00 | YM | Futures | 42415.1 | 42457.3 | 42380.1 | 42411.0 | 636.0 |
| 2025-05-02 01:00:00 | YM | Futures | 42414.0 | 42419.2 | 42344.1 | 42363.6 | 666.0 |
| 2025-05-02 02:00:00 | YM | Futures | 42361.6 | 42364.6 | 42305.0 | 42321.4 | 1313.0 |
| 2025-05-02 03:00:00 | YM | Futures | 42323.5 | 42405.8 | 42300.8 | 42305.0 | 1482.0 |
| 2025-05-02 04:00:00 | YM | Futures | 42307.0 | 42326.6 | 42189.7 | 42192.8 | 2180.0 |
| 2025-05-02 05:00:00 | YM | Futures | 42192.8 | 42276.1 | 42165.0 | 42250.4 | 1498.0 |
| 2025-05-02 06:00:00 | YM | Futures | 42253.5 | 42289.5 | 42216.4 | 42235.0 | 877.0 |
| 2025-05-02 07:00:00 | YM | Futures | 42231.9 | 42273.0 | 42204.1 | 42230.9 | 1351.0 |
| 2025-05-02 08:00:00 | YM | Futures | 42228.8 | 42522.1 | 42217.5 | 42519.0 | 3904.0 |
| 2025-05-02 09:00:00 | YM | Futures | 42521.1 | 42584.9 | 42341.0 | 42399.6 | 12588.0 |
| 2025-05-02 10:00:00 | YM | Futures | 42414.0 | 42581.8 | 42371.8 | 42531.4 | 10570.0 |
| 2025-05-02 11:00:00 | YM | Futures | 42531.4 | 42570.5 | 42385.2 | 42562.2 | 6253.0 |
| 2025-05-02 12:00:00 | YM | Futures | 42565.3 | 42716.6 | 42554.0 | 42683.7 | 8657.0 |
| 2025-05-02 13:00:00 | YM | Futures | 42689.9 | 42700.2 | 42593.1 | 42631.2 | 4396.0 |
| 2025-05-02 14:00:00 | YM | Futures | 42628.1 | 42701.2 | 42558.1 | 42617.8 | 4255.0 |
| 2025-05-02 15:00:00 | YM | Futures | 42615.8 | 42696.0 | 42565.3 | 42618.8 | 9314.0 |
> showing 50 of 1,726 rows — these rows as CSV