PREVIEW / futures_1hour / 2025-06-27
file: by_date/futures_1hour/2025/2025-06-27.parquet size: 55 KB rows: 1,627
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-06-27 00:00:00 | ES | Futures | 6248.51 | 6248.76 | 6246.49 | 6246.49 | 2554.0 |
| 2025-06-27 01:00:00 | ES | Futures | 6246.49 | 6252.54 | 6246.24 | 6250.77 | 3931.0 |
| 2025-06-27 02:00:00 | ES | Futures | 6250.77 | 6260.6 | 6250.02 | 6257.57 | 11406.0 |
| 2025-06-27 03:00:00 | ES | Futures | 6257.32 | 6261.6 | 6255.06 | 6256.57 | 9381.0 |
| 2025-06-27 04:00:00 | ES | Futures | 6256.82 | 6259.09 | 6254.55 | 6258.58 | 8727.0 |
| 2025-06-27 05:00:00 | ES | Futures | 6258.58 | 6259.09 | 6253.8 | 6257.07 | 8072.0 |
| 2025-06-27 06:00:00 | ES | Futures | 6257.07 | 6257.57 | 6253.8 | 6256.32 | 6700.0 |
| 2025-06-27 07:00:00 | ES | Futures | 6256.06 | 6265.38 | 6255.81 | 6264.88 | 11437.0 |
| 2025-06-27 08:00:00 | ES | Futures | 6265.13 | 6267.4 | 6255.06 | 6256.06 | 28709.0 |
| 2025-06-27 09:00:00 | ES | Futures | 6255.81 | 6268.15 | 6248.51 | 6264.88 | 105436.0 |
| 2025-06-27 10:00:00 | ES | Futures | 6265.13 | 6277.47 | 6265.13 | 6269.41 | 176913.0 |
| 2025-06-27 11:00:00 | ES | Futures | 6269.41 | 6282.76 | 6267.4 | 6280.75 | 92947.0 |
| 2025-06-27 12:00:00 | ES | Futures | 6280.75 | 6285.78 | 6277.98 | 6281.5 | 87569.0 |
| 2025-06-27 13:00:00 | ES | Futures | 6281.25 | 6281.5 | 6253.8 | 6263.12 | 152361.0 |
| 2025-06-27 14:00:00 | ES | Futures | 6263.12 | 6265.38 | 6229.62 | 6233.65 | 205636.0 |
| 2025-06-27 15:00:00 | ES | Futures | 6233.65 | 6273.44 | 6231.63 | 6269.92 | 259920.0 |
| 2025-06-27 16:00:00 | ES | Futures | 6270.17 | 6270.17 | 6263.37 | 6267.4 | 67080.0 |
| 2025-06-27 00:00:00 | NQ | Futures | 22891.15 | 22896.2 | 22884.34 | 22886.11 | 1324.0 |
| 2025-06-27 01:00:00 | NQ | Futures | 22885.86 | 22915.87 | 22885.35 | 22906.54 | 2781.0 |
| 2025-06-27 02:00:00 | NQ | Futures | 22907.54 | 22945.62 | 22904.77 | 22933.27 | 5006.0 |
| 2025-06-27 03:00:00 | NQ | Futures | 22933.01 | 22958.23 | 22922.17 | 22933.27 | 6139.0 |
| 2025-06-27 04:00:00 | NQ | Futures | 22934.02 | 22948.65 | 22921.41 | 22945.37 | 4682.0 |
| 2025-06-27 05:00:00 | NQ | Futures | 22946.38 | 22948.4 | 22927.72 | 22943.1 | 3173.0 |
| 2025-06-27 06:00:00 | NQ | Futures | 22943.1 | 22947.14 | 22923.43 | 22932.76 | 3311.0 |
| 2025-06-27 07:00:00 | NQ | Futures | 22932.76 | 22978.41 | 22930.74 | 22977.4 | 6519.0 |
| 2025-06-27 08:00:00 | NQ | Futures | 22977.9 | 22986.48 | 22920.66 | 22928.98 | 15559.0 |
| 2025-06-27 09:00:00 | NQ | Futures | 22929.23 | 22968.32 | 22882.83 | 22962.27 | 49623.0 |
| 2025-06-27 10:00:00 | NQ | Futures | 22962.77 | 23024.3 | 22946.63 | 22957.22 | 69646.0 |
| 2025-06-27 11:00:00 | NQ | Futures | 22958.48 | 23018.75 | 22943.1 | 23007.91 | 43123.0 |
| 2025-06-27 12:00:00 | NQ | Futures | 23007.91 | 23008.67 | 22967.81 | 22993.54 | 34709.0 |
| 2025-06-27 13:00:00 | NQ | Futures | 22993.28 | 22996.81 | 22893.67 | 22934.02 | 51278.0 |
| 2025-06-27 14:00:00 | NQ | Futures | 22934.27 | 22940.58 | 22796.84 | 22806.67 | 65001.0 |
| 2025-06-27 15:00:00 | NQ | Futures | 22807.93 | 22957.98 | 22802.13 | 22950.16 | 69911.0 |
| 2025-06-27 16:00:00 | NQ | Futures | 22950.16 | 22950.92 | 22925.2 | 22938.31 | 18542.0 |
| 2025-06-27 00:00:00 | YM | Futures | 44744.8 | 44745.9 | 44722.4 | 44722.4 | 279.0 |
| 2025-06-27 01:00:00 | YM | Futures | 44723.4 | 44760.2 | 44723.4 | 44753.0 | 378.0 |
| 2025-06-27 02:00:00 | YM | Futures | 44752.0 | 44832.7 | 44745.9 | 44808.2 | 1534.0 |
| 2025-06-27 03:00:00 | YM | Futures | 44806.1 | 44817.4 | 44786.7 | 44809.2 | 857.0 |
| 2025-06-27 04:00:00 | YM | Futures | 44801.0 | 44804.1 | 44760.2 | 44780.6 | 1238.0 |
| 2025-06-27 05:00:00 | YM | Futures | 44781.6 | 44784.7 | 44755.1 | 44768.3 | 585.0 |
| 2025-06-27 06:00:00 | YM | Futures | 44771.4 | 44780.6 | 44753.0 | 44776.5 | 730.0 |
| 2025-06-27 07:00:00 | YM | Futures | 44777.5 | 44828.6 | 44774.5 | 44820.4 | 1312.0 |
| 2025-06-27 08:00:00 | YM | Futures | 44822.5 | 44838.8 | 44775.5 | 44798.0 | 2214.0 |
| 2025-06-27 09:00:00 | YM | Futures | 44792.9 | 44931.8 | 44769.4 | 44903.2 | 9857.0 |
| 2025-06-27 10:00:00 | YM | Futures | 44903.2 | 45042.1 | 44903.2 | 45008.4 | 10337.0 |
| 2025-06-27 11:00:00 | YM | Futures | 45010.5 | 45156.5 | 44996.2 | 45144.3 | 7140.0 |
| 2025-06-27 12:00:00 | YM | Futures | 45146.3 | 45243.4 | 45132.0 | 45188.2 | 6869.0 |
| 2025-06-27 13:00:00 | YM | Futures | 45186.2 | 45188.2 | 44953.3 | 45015.6 | 8973.0 |
| 2025-06-27 14:00:00 | YM | Futures | 45017.6 | 45043.1 | 44818.4 | 44854.2 | 11075.0 |
| 2025-06-27 15:00:00 | YM | Futures | 44855.2 | 45102.4 | 44837.8 | 45075.8 | 11102.0 |
> showing 50 of 1,627 rows — these rows as CSV