PREVIEW / futures_1hour / 2025-05-12
file: by_date/futures_1hour/2025/2025-05-12.parquet size: 70 KB rows: 2,114
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-12 00:00:00 | ES | Futures | 5853.08 | 5855.88 | 5852.07 | 5854.1 | 3033.0 |
| 2025-05-12 01:00:00 | ES | Futures | 5854.35 | 5860.7 | 5851.81 | 5856.64 | 5012.0 |
| 2025-05-12 02:00:00 | ES | Futures | 5856.89 | 5864.01 | 5852.32 | 5860.2 | 13348.0 |
| 2025-05-12 03:00:00 | ES | Futures | 5860.2 | 5948.35 | 5859.69 | 5914.56 | 90771.0 |
| 2025-05-12 04:00:00 | ES | Futures | 5914.56 | 5930.82 | 5909.23 | 5924.47 | 40104.0 |
| 2025-05-12 05:00:00 | ES | Futures | 5924.72 | 5934.38 | 5922.94 | 5933.36 | 20397.0 |
| 2025-05-12 06:00:00 | ES | Futures | 5933.36 | 5956.48 | 5929.29 | 5953.43 | 44218.0 |
| 2025-05-12 07:00:00 | ES | Futures | 5953.17 | 5960.54 | 5932.34 | 5940.98 | 56871.0 |
| 2025-05-12 08:00:00 | ES | Futures | 5940.73 | 5956.73 | 5939.46 | 5942.76 | 44351.0 |
| 2025-05-12 09:00:00 | ES | Futures | 5943.01 | 5949.62 | 5913.04 | 5917.35 | 201088.0 |
| 2025-05-12 10:00:00 | ES | Futures | 5917.61 | 5935.14 | 5899.57 | 5920.4 | 246803.0 |
| 2025-05-12 11:00:00 | ES | Futures | 5920.66 | 5927.77 | 5910.24 | 5911.51 | 138566.0 |
| 2025-05-12 12:00:00 | ES | Futures | 5911.77 | 5944.03 | 5909.73 | 5941.49 | 115334.0 |
| 2025-05-12 13:00:00 | ES | Futures | 5941.49 | 5955.71 | 5940.47 | 5945.81 | 133487.0 |
| 2025-05-12 14:00:00 | ES | Futures | 5945.81 | 5956.99 | 5943.78 | 5946.06 | 112727.0 |
| 2025-05-12 15:00:00 | ES | Futures | 5946.32 | 5961.05 | 5938.44 | 5959.02 | 262149.0 |
| 2025-05-12 16:00:00 | ES | Futures | 5959.02 | 5971.21 | 5958.51 | 5963.08 | 78069.0 |
| 2025-05-12 18:00:00 | ES | Futures | 5962.83 | 5963.84 | 5953.68 | 5954.7 | 6176.0 |
| 2025-05-12 19:00:00 | ES | Futures | 5954.95 | 5964.61 | 5951.4 | 5951.4 | 4227.0 |
| 2025-05-12 20:00:00 | ES | Futures | 5951.4 | 5951.4 | 5942.25 | 5943.52 | 7941.0 |
| 2025-05-12 21:00:00 | ES | Futures | 5943.78 | 5948.09 | 5940.98 | 5944.54 | 6870.0 |
| 2025-05-12 22:00:00 | ES | Futures | 5944.79 | 5949.11 | 5938.69 | 5943.27 | 7112.0 |
| 2025-05-12 23:00:00 | ES | Futures | 5943.01 | 5944.03 | 5936.15 | 5936.41 | 5726.0 |
| 2025-05-12 00:00:00 | NQ | Futures | 20907.5 | 20917.18 | 20902.41 | 20912.6 | 2222.0 |
| 2025-05-12 01:00:00 | NQ | Futures | 20912.85 | 20945.96 | 20905.21 | 20934.75 | 4214.0 |
| 2025-05-12 02:00:00 | NQ | Futures | 20935.51 | 20976.51 | 20923.29 | 20946.21 | 8394.0 |
| 2025-05-12 03:00:00 | NQ | Futures | 20946.97 | 21320.3 | 20945.96 | 21198.06 | 36108.0 |
| 2025-05-12 04:00:00 | NQ | Futures | 21199.08 | 21287.19 | 21165.47 | 21264.53 | 16754.0 |
| 2025-05-12 05:00:00 | NQ | Futures | 21266.05 | 21303.23 | 21262.49 | 21295.59 | 8979.0 |
| 2025-05-12 06:00:00 | NQ | Futures | 21296.36 | 21373.52 | 21271.15 | 21361.8 | 17057.0 |
| 2025-05-12 07:00:00 | NQ | Futures | 21362.31 | 21382.18 | 21271.66 | 21302.72 | 22272.0 |
| 2025-05-12 08:00:00 | NQ | Futures | 21302.72 | 21355.44 | 21295.59 | 21306.03 | 17668.0 |
| 2025-05-12 09:00:00 | NQ | Futures | 21305.78 | 21329.46 | 21132.62 | 21173.36 | 84281.0 |
| 2025-05-12 10:00:00 | NQ | Futures | 21174.63 | 21237.28 | 21075.06 | 21157.06 | 84874.0 |
| 2025-05-12 11:00:00 | NQ | Futures | 21158.59 | 21193.73 | 21140.0 | 21151.21 | 49310.0 |
| 2025-05-12 12:00:00 | NQ | Futures | 21151.71 | 21272.17 | 21143.06 | 21266.31 | 45783.0 |
| 2025-05-12 13:00:00 | NQ | Futures | 21266.82 | 21324.62 | 21260.71 | 21297.89 | 46222.0 |
| 2025-05-12 14:00:00 | NQ | Futures | 21298.14 | 21333.28 | 21282.1 | 21285.41 | 37876.0 |
| 2025-05-12 15:00:00 | NQ | Futures | 21284.9 | 21344.23 | 21247.21 | 21339.65 | 74062.0 |
| 2025-05-12 16:00:00 | NQ | Futures | 21339.65 | 21386.76 | 21327.17 | 21347.03 | 21678.0 |
| 2025-05-12 18:00:00 | NQ | Futures | 21344.74 | 21353.65 | 21302.47 | 21308.84 | 4712.0 |
| 2025-05-12 19:00:00 | NQ | Futures | 21309.85 | 21358.24 | 21297.12 | 21297.89 | 4541.0 |
| 2025-05-12 20:00:00 | NQ | Futures | 21297.63 | 21298.39 | 21254.34 | 21263.51 | 6582.0 |
| 2025-05-12 21:00:00 | NQ | Futures | 21264.78 | 21284.39 | 21252.3 | 21263.76 | 5061.0 |
| 2025-05-12 22:00:00 | NQ | Futures | 21263.76 | 21283.12 | 21238.04 | 21260.71 | 5925.0 |
| 2025-05-12 23:00:00 | NQ | Futures | 21260.2 | 21263.76 | 21230.15 | 21232.19 | 3277.0 |
| 2025-05-12 00:00:00 | YM | Futures | 43004.8 | 43017.1 | 42991.4 | 42994.5 | 593.0 |
| 2025-05-12 01:00:00 | YM | Futures | 42997.6 | 43019.2 | 42980.1 | 42998.6 | 693.0 |
| 2025-05-12 02:00:00 | YM | Futures | 42999.6 | 43035.7 | 42964.6 | 43017.1 | 1561.0 |
| 2025-05-12 03:00:00 | YM | Futures | 43016.1 | 43574.9 | 43014.0 | 43344.4 | 6218.0 |
> showing 50 of 2,114 rows — these rows as CSV