PREVIEW / futures_1hour / 2025-04-02
file: by_date/futures_1hour/2025/2025-04-02.parquet size: 73 KB rows: 2,145
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-04-02 00:00:00 | ES | Futures | 5757.06 | 5760.36 | 5756.04 | 5760.36 | 3654.0 |
| 2025-04-02 01:00:00 | ES | Futures | 5760.36 | 5760.87 | 5752.74 | 5755.02 | 5853.0 |
| 2025-04-02 02:00:00 | ES | Futures | 5755.02 | 5764.68 | 5752.48 | 5757.31 | 8692.0 |
| 2025-04-02 03:00:00 | ES | Futures | 5757.56 | 5763.41 | 5747.4 | 5750.96 | 17458.0 |
| 2025-04-02 04:00:00 | ES | Futures | 5750.96 | 5757.82 | 5743.59 | 5748.67 | 14281.0 |
| 2025-04-02 05:00:00 | ES | Futures | 5748.67 | 5754.77 | 5744.61 | 5745.88 | 8991.0 |
| 2025-04-02 06:00:00 | ES | Futures | 5745.88 | 5747.4 | 5730.64 | 5734.19 | 27256.0 |
| 2025-04-02 07:00:00 | ES | Futures | 5734.19 | 5736.99 | 5724.79 | 5726.06 | 23473.0 |
| 2025-04-02 08:00:00 | ES | Futures | 5726.06 | 5726.82 | 5702.69 | 5715.39 | 64546.0 |
| 2025-04-02 09:00:00 | ES | Futures | 5715.39 | 5752.99 | 5701.42 | 5742.07 | 215852.0 |
| 2025-04-02 10:00:00 | ES | Futures | 5742.32 | 5779.16 | 5737.75 | 5777.12 | 227596.0 |
| 2025-04-02 11:00:00 | ES | Futures | 5777.12 | 5794.4 | 5764.68 | 5779.16 | 217602.0 |
| 2025-04-02 12:00:00 | ES | Futures | 5779.41 | 5818.03 | 5777.12 | 5813.96 | 170238.0 |
| 2025-04-02 13:00:00 | ES | Futures | 5814.21 | 5832.0 | 5788.81 | 5797.7 | 208552.0 |
| 2025-04-02 14:00:00 | ES | Futures | 5797.7 | 5801.51 | 5765.44 | 5767.47 | 189288.0 |
| 2025-04-02 15:00:00 | ES | Futures | 5767.47 | 5813.71 | 5767.22 | 5802.27 | 245846.0 |
| 2025-04-02 16:00:00 | ES | Futures | 5802.53 | 5866.55 | 5656.2 | 5674.75 | 287950.0 |
| 2025-04-02 18:00:00 | ES | Futures | 5640.2 | 5640.2 | 5569.57 | 5617.33 | 76902.0 |
| 2025-04-02 19:00:00 | ES | Futures | 5617.33 | 5617.84 | 5587.1 | 5601.07 | 26895.0 |
| 2025-04-02 20:00:00 | ES | Futures | 5601.33 | 5647.56 | 5601.33 | 5621.14 | 37917.0 |
| 2025-04-02 21:00:00 | ES | Futures | 5621.4 | 5654.42 | 5620.89 | 5641.21 | 25105.0 |
| 2025-04-02 22:00:00 | ES | Futures | 5641.47 | 5653.66 | 5634.86 | 5652.65 | 17659.0 |
| 2025-04-02 23:00:00 | ES | Futures | 5652.9 | 5654.17 | 5635.62 | 5644.52 | 11543.0 |
| 2025-04-02 00:00:00 | NQ | Futures | 19931.93 | 19955.61 | 19929.13 | 19954.59 | 1979.0 |
| 2025-04-02 01:00:00 | NQ | Futures | 19955.36 | 19957.39 | 19911.81 | 19921.49 | 2431.0 |
| 2025-04-02 02:00:00 | NQ | Futures | 19921.23 | 19954.34 | 19908.5 | 19926.83 | 4246.0 |
| 2025-04-02 03:00:00 | NQ | Futures | 19927.09 | 19949.5 | 19878.2 | 19899.08 | 10476.0 |
| 2025-04-02 04:00:00 | NQ | Futures | 19899.33 | 19929.38 | 19861.9 | 19893.98 | 8232.0 |
| 2025-04-02 05:00:00 | NQ | Futures | 19892.71 | 19918.69 | 19874.63 | 19878.45 | 4950.0 |
| 2025-04-02 06:00:00 | NQ | Futures | 19879.98 | 19887.11 | 19815.55 | 19833.38 | 13272.0 |
| 2025-04-02 07:00:00 | NQ | Futures | 19834.14 | 19845.6 | 19785.5 | 19790.34 | 10687.0 |
| 2025-04-02 08:00:00 | NQ | Futures | 19791.11 | 19793.14 | 19703.25 | 19747.81 | 30351.0 |
| 2025-04-02 09:00:00 | NQ | Futures | 19747.3 | 19944.92 | 19676.0 | 19893.48 | 96889.0 |
| 2025-04-02 10:00:00 | NQ | Futures | 19893.48 | 20005.27 | 19854.0 | 19997.88 | 108029.0 |
| 2025-04-02 11:00:00 | NQ | Futures | 19997.88 | 20080.9 | 19942.88 | 20034.55 | 88808.0 |
| 2025-04-02 12:00:00 | NQ | Futures | 20034.81 | 20198.04 | 20024.37 | 20182.0 | 74716.0 |
| 2025-04-02 13:00:00 | NQ | Futures | 20184.29 | 20260.43 | 20085.74 | 20111.97 | 84129.0 |
| 2025-04-02 14:00:00 | NQ | Futures | 20112.22 | 20130.05 | 19969.62 | 19972.16 | 80358.0 |
| 2025-04-02 15:00:00 | NQ | Futures | 19972.93 | 20164.43 | 19972.93 | 20113.75 | 81070.0 |
| 2025-04-02 16:00:00 | NQ | Futures | 20113.75 | 20417.3 | 19431.79 | 19508.7 | 97965.0 |
| 2025-04-02 18:00:00 | NQ | Futures | 19373.98 | 19391.3 | 19169.24 | 19304.21 | 28604.0 |
| 2025-04-02 19:00:00 | NQ | Futures | 19300.64 | 19302.94 | 19196.24 | 19228.58 | 13886.0 |
| 2025-04-02 20:00:00 | NQ | Futures | 19231.12 | 19423.39 | 19231.12 | 19348.77 | 16266.0 |
| 2025-04-02 21:00:00 | NQ | Futures | 19348.77 | 19483.74 | 19346.99 | 19433.32 | 10918.0 |
| 2025-04-02 22:00:00 | NQ | Futures | 19435.1 | 19490.87 | 19415.49 | 19487.3 | 8360.0 |
| 2025-04-02 23:00:00 | NQ | Futures | 19488.07 | 19496.22 | 19424.15 | 19460.57 | 4948.0 |
| 2025-04-02 00:00:00 | YM | Futures | 43430.9 | 43435.0 | 43412.3 | 43427.8 | 466.0 |
| 2025-04-02 01:00:00 | YM | Futures | 43429.8 | 43438.1 | 43402.0 | 43412.3 | 728.0 |
| 2025-04-02 02:00:00 | YM | Futures | 43411.3 | 43477.2 | 43396.9 | 43441.2 | 1115.0 |
| 2025-04-02 03:00:00 | YM | Futures | 43439.1 | 43484.4 | 43375.3 | 43389.7 | 2201.0 |
> showing 50 of 2,145 rows — these rows as CSV