PREVIEW / futures_1hour / 2024-01-31
file: by_date/futures_1hour/2024/2024-01-31.parquet size: 70 KB rows: 2,134
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-31 00:00:00 | ES | Futures | 5299.02 | 5299.56 | 5296.88 | 5297.14 | 3498.0 |
| 2024-01-31 01:00:00 | ES | Futures | 5297.41 | 5299.02 | 5294.73 | 5295.0 | 4576.0 |
| 2024-01-31 02:00:00 | ES | Futures | 5294.73 | 5302.25 | 5293.65 | 5300.9 | 8267.0 |
| 2024-01-31 03:00:00 | ES | Futures | 5300.9 | 5305.2 | 5300.37 | 5301.44 | 13168.0 |
| 2024-01-31 04:00:00 | ES | Futures | 5301.44 | 5301.98 | 5289.35 | 5291.77 | 25176.0 |
| 2024-01-31 05:00:00 | ES | Futures | 5291.77 | 5292.85 | 5289.35 | 5290.43 | 10870.0 |
| 2024-01-31 06:00:00 | ES | Futures | 5290.43 | 5295.8 | 5289.09 | 5293.92 | 15694.0 |
| 2024-01-31 07:00:00 | ES | Futures | 5294.19 | 5297.68 | 5290.7 | 5297.41 | 20466.0 |
| 2024-01-31 08:00:00 | ES | Futures | 5297.14 | 5304.13 | 5289.35 | 5291.23 | 69710.0 |
| 2024-01-31 09:00:00 | ES | Futures | 5291.23 | 5297.14 | 5279.95 | 5282.64 | 222087.0 |
| 2024-01-31 10:00:00 | ES | Futures | 5282.37 | 5283.45 | 5267.87 | 5271.63 | 240797.0 |
| 2024-01-31 11:00:00 | ES | Futures | 5271.9 | 5279.69 | 5267.33 | 5272.7 | 161903.0 |
| 2024-01-31 12:00:00 | ES | Futures | 5272.7 | 5278.88 | 5269.21 | 5278.07 | 118730.0 |
| 2024-01-31 13:00:00 | ES | Futures | 5278.34 | 5282.1 | 5274.58 | 5278.88 | 95844.0 |
| 2024-01-31 14:00:00 | ES | Futures | 5278.88 | 5296.34 | 5259.54 | 5268.94 | 398743.0 |
| 2024-01-31 15:00:00 | ES | Futures | 5268.94 | 5270.28 | 5230.26 | 5230.8 | 600796.0 |
| 2024-01-31 16:00:00 | ES | Futures | 5230.8 | 5238.59 | 5227.85 | 5234.03 | 108429.0 |
| 2024-01-31 18:00:00 | ES | Futures | 5236.98 | 5240.2 | 5234.83 | 5239.4 | 10442.0 |
| 2024-01-31 19:00:00 | ES | Futures | 5239.4 | 5246.11 | 5239.13 | 5242.35 | 10305.0 |
| 2024-01-31 20:00:00 | ES | Futures | 5242.35 | 5244.23 | 5240.74 | 5243.69 | 8033.0 |
| 2024-01-31 21:00:00 | ES | Futures | 5243.69 | 5249.33 | 5243.16 | 5247.72 | 8263.0 |
| 2024-01-31 22:00:00 | ES | Futures | 5247.72 | 5247.99 | 5242.35 | 5245.84 | 5564.0 |
| 2024-01-31 23:00:00 | ES | Futures | 5245.84 | 5248.8 | 5245.84 | 5247.72 | 4419.0 |
| 2024-01-31 00:00:00 | NQ | Futures | 18929.61 | 18935.58 | 18921.47 | 18922.56 | 3091.0 |
| 2024-01-31 01:00:00 | NQ | Futures | 18922.83 | 18933.68 | 18908.18 | 18910.08 | 3364.0 |
| 2024-01-31 02:00:00 | NQ | Futures | 18909.54 | 18947.51 | 18905.2 | 18936.12 | 6469.0 |
| 2024-01-31 03:00:00 | NQ | Futures | 18936.39 | 18950.49 | 18920.66 | 18926.36 | 6910.0 |
| 2024-01-31 04:00:00 | NQ | Futures | 18926.08 | 18928.8 | 18813.53 | 18853.67 | 22425.0 |
| 2024-01-31 05:00:00 | NQ | Futures | 18853.67 | 18857.74 | 18828.18 | 18829.53 | 9298.0 |
| 2024-01-31 06:00:00 | NQ | Futures | 18829.26 | 18872.39 | 18804.04 | 18868.59 | 13294.0 |
| 2024-01-31 07:00:00 | NQ | Futures | 18869.13 | 18909.54 | 18858.82 | 18906.56 | 14917.0 |
| 2024-01-31 08:00:00 | NQ | Futures | 18906.56 | 18934.76 | 18875.91 | 18882.15 | 31396.0 |
| 2024-01-31 09:00:00 | NQ | Futures | 18882.42 | 18904.66 | 18818.69 | 18842.82 | 91207.0 |
| 2024-01-31 10:00:00 | NQ | Futures | 18843.37 | 18858.01 | 18749.53 | 18768.78 | 96895.0 |
| 2024-01-31 11:00:00 | NQ | Futures | 18768.78 | 18822.48 | 18767.7 | 18810.55 | 65975.0 |
| 2024-01-31 12:00:00 | NQ | Futures | 18810.82 | 18845.26 | 18803.5 | 18843.91 | 48334.0 |
| 2024-01-31 13:00:00 | NQ | Futures | 18844.45 | 18879.71 | 18837.94 | 18857.2 | 37465.0 |
| 2024-01-31 14:00:00 | NQ | Futures | 18859.37 | 18967.04 | 18777.19 | 18852.86 | 144579.0 |
| 2024-01-31 15:00:00 | NQ | Futures | 18853.4 | 18859.91 | 18692.03 | 18700.98 | 153961.0 |
| 2024-01-31 16:00:00 | NQ | Futures | 18700.44 | 18735.7 | 18682.27 | 18729.73 | 24332.0 |
| 2024-01-31 18:00:00 | NQ | Futures | 18738.41 | 18757.39 | 18731.36 | 18748.72 | 6505.0 |
| 2024-01-31 19:00:00 | NQ | Futures | 18748.44 | 18785.6 | 18746.27 | 18772.31 | 7089.0 |
| 2024-01-31 20:00:00 | NQ | Futures | 18772.31 | 18780.18 | 18757.12 | 18773.67 | 5276.0 |
| 2024-01-31 21:00:00 | NQ | Futures | 18773.12 | 18794.01 | 18768.51 | 18785.06 | 3514.0 |
| 2024-01-31 22:00:00 | NQ | Futures | 18785.33 | 18791.57 | 18754.41 | 18781.53 | 4098.0 |
| 2024-01-31 23:00:00 | NQ | Futures | 18780.45 | 18795.91 | 18779.36 | 18786.68 | 2616.0 |
| 2024-01-31 00:00:00 | YM | Futures | 41494.8 | 41499.1 | 41470.1 | 41474.4 | 711.0 |
| 2024-01-31 01:00:00 | YM | Futures | 41474.4 | 41486.2 | 41454.0 | 41454.0 | 839.0 |
| 2024-01-31 02:00:00 | YM | Futures | 41455.1 | 41508.8 | 41444.4 | 41503.4 | 1820.0 |
| 2024-01-31 03:00:00 | YM | Futures | 41502.4 | 41550.7 | 41490.5 | 41516.3 | 2319.0 |
> showing 50 of 2,134 rows — these rows as CSV