PREVIEW / futures_1hour / 2022-06-30
file: by_date/futures_1hour/2022/2022-06-30.parquet size: 70 KB rows: 2,056
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 |
|---|---|---|---|---|---|---|---|
| 2022-06-30 00:00:00 | ES | Futures | 4317.34 | 4319.32 | 4313.94 | 4315.64 | 3959.0 |
| 2022-06-30 01:00:00 | ES | Futures | 4315.36 | 4317.06 | 4293.55 | 4299.49 | 17711.0 |
| 2022-06-30 02:00:00 | ES | Futures | 4299.78 | 4302.61 | 4268.9 | 4276.83 | 37949.0 |
| 2022-06-30 03:00:00 | ES | Futures | 4276.83 | 4286.18 | 4266.07 | 4283.06 | 40830.0 |
| 2022-06-30 04:00:00 | ES | Futures | 4283.06 | 4290.71 | 4275.98 | 4280.52 | 32316.0 |
| 2022-06-30 05:00:00 | ES | Futures | 4280.52 | 4281.37 | 4262.67 | 4276.27 | 24852.0 |
| 2022-06-30 06:00:00 | ES | Futures | 4276.55 | 4278.82 | 4263.52 | 4272.58 | 19605.0 |
| 2022-06-30 07:00:00 | ES | Futures | 4272.87 | 4274.57 | 4261.25 | 4266.92 | 28368.0 |
| 2022-06-30 08:00:00 | ES | Futures | 4266.92 | 4287.88 | 4265.79 | 4270.32 | 73638.0 |
| 2022-06-30 09:00:00 | ES | Futures | 4270.32 | 4290.15 | 4244.82 | 4248.22 | 261420.0 |
| 2022-06-30 10:00:00 | ES | Futures | 4248.22 | 4277.4 | 4239.16 | 4275.98 | 291056.0 |
| 2022-06-30 11:00:00 | ES | Futures | 4275.7 | 4305.73 | 4265.22 | 4305.16 | 243505.0 |
| 2022-06-30 12:00:00 | ES | Futures | 4305.16 | 4331.5 | 4289.01 | 4319.04 | 204398.0 |
| 2022-06-30 13:00:00 | ES | Futures | 4319.32 | 4329.52 | 4297.8 | 4322.16 | 181830.0 |
| 2022-06-30 14:00:00 | ES | Futures | 4321.87 | 4325.27 | 4286.75 | 4292.41 | 173266.0 |
| 2022-06-30 15:00:00 | ES | Futures | 4292.7 | 4309.13 | 4268.05 | 4293.83 | 497473.0 |
| 2022-06-30 16:00:00 | ES | Futures | 4293.83 | 4299.49 | 4280.52 | 4284.2 | 113685.0 |
| 2022-06-30 18:00:00 | ES | Futures | 4285.33 | 4285.9 | 4275.13 | 4279.67 | 8457.0 |
| 2022-06-30 19:00:00 | ES | Futures | 4279.95 | 4295.53 | 4277.97 | 4294.68 | 7634.0 |
| 2022-06-30 20:00:00 | ES | Futures | 4294.4 | 4298.64 | 4288.45 | 4289.3 | 12000.0 |
| 2022-06-30 21:00:00 | ES | Futures | 4289.3 | 4292.13 | 4274.28 | 4280.23 | 9741.0 |
| 2022-06-30 22:00:00 | ES | Futures | 4280.23 | 4288.73 | 4262.1 | 4265.79 | 13444.0 |
| 2022-06-30 23:00:00 | ES | Futures | 4265.79 | 4266.35 | 4247.66 | 4255.02 | 17388.0 |
| 2022-06-30 00:00:00 | NQ | Futures | 13481.14 | 13490.4 | 13470.44 | 13476.8 | 1863.0 |
| 2022-06-30 01:00:00 | NQ | Futures | 13476.51 | 13483.75 | 13392.35 | 13418.67 | 7589.0 |
| 2022-06-30 02:00:00 | NQ | Futures | 13419.82 | 13429.66 | 13299.79 | 13330.16 | 14631.0 |
| 2022-06-30 03:00:00 | NQ | Futures | 13330.16 | 13366.6 | 13294.58 | 13356.77 | 16028.0 |
| 2022-06-30 04:00:00 | NQ | Futures | 13356.19 | 13383.67 | 13323.51 | 13333.92 | 13792.0 |
| 2022-06-30 05:00:00 | NQ | Futures | 13334.5 | 13336.81 | 13260.16 | 13312.81 | 14005.0 |
| 2022-06-30 06:00:00 | NQ | Futures | 13311.94 | 13315.41 | 13275.2 | 13309.62 | 8896.0 |
| 2022-06-30 07:00:00 | NQ | Futures | 13309.91 | 13326.4 | 13277.23 | 13296.03 | 10642.0 |
| 2022-06-30 08:00:00 | NQ | Futures | 13295.74 | 13398.13 | 13291.11 | 13320.9 | 33867.0 |
| 2022-06-30 09:00:00 | NQ | Futures | 13320.04 | 13406.81 | 13180.91 | 13186.99 | 106985.0 |
| 2022-06-30 10:00:00 | NQ | Futures | 13186.99 | 13296.9 | 13132.61 | 13290.24 | 99646.0 |
| 2022-06-30 11:00:00 | NQ | Futures | 13290.82 | 13438.05 | 13255.25 | 13434.86 | 83987.0 |
| 2022-06-30 12:00:00 | NQ | Futures | 13434.86 | 13519.03 | 13350.7 | 13462.34 | 67338.0 |
| 2022-06-30 13:00:00 | NQ | Futures | 13461.76 | 13499.08 | 13381.64 | 13472.18 | 54940.0 |
| 2022-06-30 14:00:00 | NQ | Futures | 13471.89 | 13484.04 | 13346.07 | 13361.69 | 49124.0 |
| 2022-06-30 15:00:00 | NQ | Futures | 13362.84 | 13426.19 | 13271.44 | 13348.96 | 105339.0 |
| 2022-06-30 16:00:00 | NQ | Futures | 13349.54 | 13362.84 | 13300.66 | 13318.01 | 23586.0 |
| 2022-06-30 18:00:00 | NQ | Futures | 13313.67 | 13318.88 | 13283.01 | 13301.24 | 4831.0 |
| 2022-06-30 19:00:00 | NQ | Futures | 13301.24 | 13360.24 | 13293.72 | 13356.48 | 4031.0 |
| 2022-06-30 20:00:00 | NQ | Futures | 13357.06 | 13369.79 | 13331.03 | 13335.94 | 5735.0 |
| 2022-06-30 21:00:00 | NQ | Futures | 13335.94 | 13346.65 | 13279.25 | 13303.26 | 6208.0 |
| 2022-06-30 22:00:00 | NQ | Futures | 13303.26 | 13332.47 | 13234.42 | 13250.33 | 7226.0 |
| 2022-06-30 23:00:00 | NQ | Futures | 13250.91 | 13252.93 | 13185.54 | 13212.44 | 9535.0 |
| 2022-06-30 00:00:00 | YM | Futures | 34890.6 | 34910.9 | 34874.8 | 34883.9 | 548.0 |
| 2022-06-30 01:00:00 | YM | Futures | 34885.0 | 34894.0 | 34737.2 | 34775.5 | 3572.0 |
| 2022-06-30 02:00:00 | YM | Futures | 34781.2 | 34800.4 | 34571.3 | 34628.9 | 5526.0 |
| 2022-06-30 03:00:00 | YM | Futures | 34631.1 | 34686.4 | 34539.7 | 34659.3 | 5571.0 |
> showing 50 of 2,056 rows — these rows as CSV