PREVIEW / futures_1hour / 2025-01-29
file: by_date/futures_1hour/2025/2025-01-29.parquet size: 67 KB rows: 2,106
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-01-29 00:00:00 | ES | Futures | 6252.54 | 6253.82 | 6248.95 | 6249.72 | 2146.0 |
| 2025-01-29 01:00:00 | ES | Futures | 6249.97 | 6267.41 | 6249.97 | 6263.3 | 14734.0 |
| 2025-01-29 02:00:00 | ES | Futures | 6263.3 | 6263.56 | 6258.43 | 6260.74 | 5921.0 |
| 2025-01-29 03:00:00 | ES | Futures | 6260.74 | 6263.05 | 6257.15 | 6258.18 | 14819.0 |
| 2025-01-29 04:00:00 | ES | Futures | 6257.92 | 6259.46 | 6250.49 | 6257.15 | 13173.0 |
| 2025-01-29 05:00:00 | ES | Futures | 6257.15 | 6260.74 | 6253.05 | 6259.2 | 8327.0 |
| 2025-01-29 06:00:00 | ES | Futures | 6259.46 | 6262.54 | 6254.33 | 6260.74 | 7752.0 |
| 2025-01-29 07:00:00 | ES | Futures | 6260.74 | 6261.0 | 6248.95 | 6251.77 | 9933.0 |
| 2025-01-29 08:00:00 | ES | Futures | 6251.77 | 6252.02 | 6233.82 | 6241.0 | 31460.0 |
| 2025-01-29 09:00:00 | ES | Futures | 6240.74 | 6245.87 | 6229.46 | 6238.18 | 137659.0 |
| 2025-01-29 10:00:00 | ES | Futures | 6238.44 | 6246.64 | 6229.72 | 6233.31 | 152833.0 |
| 2025-01-29 11:00:00 | ES | Futures | 6233.31 | 6237.15 | 6224.08 | 6227.67 | 125302.0 |
| 2025-01-29 12:00:00 | ES | Futures | 6227.67 | 6239.72 | 6224.08 | 6225.62 | 86029.0 |
| 2025-01-29 13:00:00 | ES | Futures | 6225.87 | 6231.77 | 6200.49 | 6219.98 | 189203.0 |
| 2025-01-29 14:00:00 | ES | Futures | 6219.98 | 6238.69 | 6196.39 | 6228.44 | 281258.0 |
| 2025-01-29 15:00:00 | ES | Futures | 6228.18 | 6242.79 | 6210.23 | 6223.05 | 282337.0 |
| 2025-01-29 16:00:00 | ES | Futures | 6223.05 | 6236.64 | 6197.93 | 6231.51 | 111229.0 |
| 2025-01-29 18:00:00 | ES | Futures | 6223.31 | 6230.74 | 6216.13 | 6223.57 | 16585.0 |
| 2025-01-29 19:00:00 | ES | Futures | 6223.57 | 6236.64 | 6221.52 | 6236.64 | 6887.0 |
| 2025-01-29 20:00:00 | ES | Futures | 6236.39 | 6247.92 | 6234.33 | 6244.59 | 9466.0 |
| 2025-01-29 21:00:00 | ES | Futures | 6244.59 | 6249.46 | 6244.59 | 6245.1 | 5329.0 |
| 2025-01-29 22:00:00 | ES | Futures | 6245.1 | 6247.92 | 6244.59 | 6247.92 | 3280.0 |
| 2025-01-29 23:00:00 | ES | Futures | 6247.92 | 6249.2 | 6245.36 | 6245.61 | 2854.0 |
| 2025-01-29 00:00:00 | NQ | Futures | 22231.66 | 22237.84 | 22211.08 | 22214.42 | 2019.0 |
| 2025-01-29 01:00:00 | NQ | Futures | 22214.68 | 22323.54 | 22214.68 | 22299.6 | 9601.0 |
| 2025-01-29 02:00:00 | NQ | Futures | 22299.6 | 22307.58 | 22277.99 | 22306.3 | 4158.0 |
| 2025-01-29 03:00:00 | NQ | Futures | 22305.78 | 22334.6 | 22299.35 | 22304.24 | 8401.0 |
| 2025-01-29 04:00:00 | NQ | Futures | 22302.95 | 22314.53 | 22264.09 | 22304.75 | 10454.0 |
| 2025-01-29 05:00:00 | NQ | Futures | 22304.24 | 22311.44 | 22276.7 | 22301.66 | 5870.0 |
| 2025-01-29 06:00:00 | NQ | Futures | 22302.18 | 22327.4 | 22284.42 | 22318.13 | 4700.0 |
| 2025-01-29 07:00:00 | NQ | Futures | 22318.65 | 22320.71 | 22274.9 | 22283.39 | 6431.0 |
| 2025-01-29 08:00:00 | NQ | Futures | 22282.62 | 22283.39 | 22193.83 | 22237.33 | 19790.0 |
| 2025-01-29 09:00:00 | NQ | Futures | 22237.07 | 22262.55 | 22125.64 | 22151.37 | 75997.0 |
| 2025-01-29 10:00:00 | NQ | Futures | 22150.86 | 22198.21 | 22086.52 | 22137.99 | 83707.0 |
| 2025-01-29 11:00:00 | NQ | Futures | 22138.76 | 22157.55 | 22097.59 | 22115.34 | 55245.0 |
| 2025-01-29 12:00:00 | NQ | Futures | 22115.09 | 22181.48 | 22109.43 | 22116.12 | 36468.0 |
| 2025-01-29 13:00:00 | NQ | Futures | 22116.63 | 22148.28 | 21994.91 | 22098.1 | 73003.0 |
| 2025-01-29 14:00:00 | NQ | Futures | 22094.76 | 22212.11 | 22015.24 | 22171.7 | 91386.0 |
| 2025-01-29 15:00:00 | NQ | Futures | 22171.45 | 22235.53 | 22093.47 | 22162.95 | 79608.0 |
| 2025-01-29 16:00:00 | NQ | Futures | 22163.47 | 22245.05 | 22015.49 | 22206.19 | 39745.0 |
| 2025-01-29 18:00:00 | NQ | Futures | 22180.97 | 22220.6 | 22137.73 | 22171.96 | 8924.0 |
| 2025-01-29 19:00:00 | NQ | Futures | 22171.45 | 22222.14 | 22158.58 | 22219.57 | 4834.0 |
| 2025-01-29 20:00:00 | NQ | Futures | 22219.83 | 22303.72 | 22212.62 | 22285.97 | 7935.0 |
| 2025-01-29 21:00:00 | NQ | Futures | 22286.22 | 22316.07 | 22286.22 | 22292.14 | 4547.0 |
| 2025-01-29 22:00:00 | NQ | Futures | 22293.43 | 22312.21 | 22290.08 | 22310.16 | 3080.0 |
| 2025-01-29 23:00:00 | NQ | Futures | 22310.41 | 22317.1 | 22295.74 | 22296.52 | 2314.0 |
| 2025-01-29 00:00:00 | YM | Futures | 46338.6 | 46340.6 | 46319.0 | 46321.1 | 218.0 |
| 2025-01-29 01:00:00 | YM | Futures | 46322.1 | 46393.1 | 46322.1 | 46360.2 | 1591.0 |
| 2025-01-29 02:00:00 | YM | Futures | 46359.2 | 46359.2 | 46302.6 | 46321.1 | 941.0 |
| 2025-01-29 03:00:00 | YM | Futures | 46321.1 | 46327.3 | 46291.2 | 46295.4 | 962.0 |
> showing 50 of 2,106 rows — these rows as CSV