PREVIEW / futures_1hour / 2022-06-15
file: by_date/futures_1hour/2022/2022-06-15.parquet size: 71 KB rows: 2,061
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-15 00:00:00 | ES | Futures | 4252.75 | 4255.3 | 4242.56 | 4244.54 | 5308.0 |
| 2022-06-15 01:00:00 | ES | Futures | 4244.54 | 4258.14 | 4237.17 | 4250.21 | 13015.0 |
| 2022-06-15 02:00:00 | ES | Futures | 4250.21 | 4261.25 | 4246.24 | 4254.45 | 18785.0 |
| 2022-06-15 03:00:00 | ES | Futures | 4254.45 | 4263.24 | 4243.97 | 4261.82 | 32131.0 |
| 2022-06-15 04:00:00 | ES | Futures | 4261.82 | 4276.55 | 4258.42 | 4264.65 | 24585.0 |
| 2022-06-15 05:00:00 | ES | Futures | 4264.65 | 4266.64 | 4253.6 | 4263.24 | 17998.0 |
| 2022-06-15 06:00:00 | ES | Futures | 4263.24 | 4263.24 | 4251.62 | 4256.15 | 17060.0 |
| 2022-06-15 07:00:00 | ES | Futures | 4256.15 | 4281.65 | 4252.19 | 4279.67 | 29771.0 |
| 2022-06-15 08:00:00 | ES | Futures | 4279.38 | 4286.18 | 4264.37 | 4280.23 | 46423.0 |
| 2022-06-15 09:00:00 | ES | Futures | 4279.95 | 4298.93 | 4271.17 | 4292.98 | 189326.0 |
| 2022-06-15 10:00:00 | ES | Futures | 4292.98 | 4303.18 | 4268.05 | 4277.97 | 200246.0 |
| 2022-06-15 11:00:00 | ES | Futures | 4277.97 | 4280.8 | 4264.37 | 4279.67 | 127537.0 |
| 2022-06-15 12:00:00 | ES | Futures | 4279.95 | 4290.15 | 4263.24 | 4264.94 | 101736.0 |
| 2022-06-15 13:00:00 | ES | Futures | 4265.22 | 4294.11 | 4264.37 | 4287.31 | 98715.0 |
| 2022-06-15 14:00:00 | ES | Futures | 4288.16 | 4339.44 | 4219.05 | 4288.45 | 483780.0 |
| 2022-06-15 15:00:00 | ES | Futures | 4288.45 | 4354.45 | 4284.76 | 4300.63 | 386492.0 |
| 2022-06-15 16:00:00 | ES | Futures | 4300.63 | 4304.03 | 4289.86 | 4298.64 | 60771.0 |
| 2022-06-15 18:00:00 | ES | Futures | 4304.59 | 4321.59 | 4304.59 | 4318.76 | 9571.0 |
| 2022-06-15 19:00:00 | ES | Futures | 4318.76 | 4329.8 | 4313.94 | 4329.52 | 7678.0 |
| 2022-06-15 20:00:00 | ES | Futures | 4329.24 | 4336.04 | 4324.99 | 4332.35 | 12121.0 |
| 2022-06-15 21:00:00 | ES | Futures | 4332.35 | 4343.4 | 4319.32 | 4321.59 | 20767.0 |
| 2022-06-15 22:00:00 | ES | Futures | 4321.59 | 4324.42 | 4313.66 | 4322.72 | 12037.0 |
| 2022-06-15 23:00:00 | ES | Futures | 4323.01 | 4331.22 | 4314.51 | 4316.49 | 8759.0 |
| 2022-06-15 00:00:00 | NQ | Futures | 13200.58 | 13209.26 | 13161.82 | 13169.63 | 3435.0 |
| 2022-06-15 01:00:00 | NQ | Futures | 13169.34 | 13218.8 | 13141.29 | 13192.77 | 6383.0 |
| 2022-06-15 02:00:00 | NQ | Futures | 13192.19 | 13228.06 | 13178.89 | 13200.87 | 7548.0 |
| 2022-06-15 03:00:00 | NQ | Futures | 13201.45 | 13223.72 | 13154.59 | 13215.91 | 11834.0 |
| 2022-06-15 04:00:00 | NQ | Futures | 13215.04 | 13260.16 | 13196.82 | 13221.12 | 11130.0 |
| 2022-06-15 05:00:00 | NQ | Futures | 13221.41 | 13232.4 | 13187.57 | 13226.61 | 8003.0 |
| 2022-06-15 06:00:00 | NQ | Futures | 13226.9 | 13227.48 | 13189.88 | 13208.39 | 6831.0 |
| 2022-06-15 07:00:00 | NQ | Futures | 13207.23 | 13289.38 | 13190.75 | 13283.01 | 15506.0 |
| 2022-06-15 08:00:00 | NQ | Futures | 13282.15 | 13324.38 | 13226.03 | 13298.92 | 25028.0 |
| 2022-06-15 09:00:00 | NQ | Futures | 13298.63 | 13361.69 | 13258.43 | 13318.59 | 68234.0 |
| 2022-06-15 10:00:00 | NQ | Futures | 13318.3 | 13390.61 | 13263.35 | 13301.24 | 77103.0 |
| 2022-06-15 11:00:00 | NQ | Futures | 13301.81 | 13346.36 | 13281.86 | 13342.6 | 43535.0 |
| 2022-06-15 12:00:00 | NQ | Futures | 13343.18 | 13387.43 | 13289.96 | 13296.03 | 46241.0 |
| 2022-06-15 13:00:00 | NQ | Futures | 13296.32 | 13416.93 | 13292.85 | 13385.12 | 36451.0 |
| 2022-06-15 14:00:00 | NQ | Futures | 13387.72 | 13598.28 | 13156.04 | 13413.17 | 178001.0 |
| 2022-06-15 15:00:00 | NQ | Futures | 13414.33 | 13645.43 | 13395.82 | 13457.43 | 112619.0 |
| 2022-06-15 16:00:00 | NQ | Futures | 13458.0 | 13466.97 | 13414.91 | 13451.64 | 19003.0 |
| 2022-06-15 18:00:00 | NQ | Futures | 13474.2 | 13546.51 | 13474.2 | 13530.6 | 6386.0 |
| 2022-06-15 19:00:00 | NQ | Futures | 13530.89 | 13567.91 | 13510.07 | 13566.47 | 3909.0 |
| 2022-06-15 20:00:00 | NQ | Futures | 13565.6 | 13581.51 | 13547.96 | 13572.25 | 4946.0 |
| 2022-06-15 21:00:00 | NQ | Futures | 13572.83 | 13622.29 | 13532.92 | 13544.49 | 10469.0 |
| 2022-06-15 22:00:00 | NQ | Futures | 13544.49 | 13555.77 | 13506.31 | 13537.54 | 5382.0 |
| 2022-06-15 23:00:00 | NQ | Futures | 13537.54 | 13564.44 | 13506.89 | 13517.3 | 4531.0 |
| 2022-06-15 00:00:00 | YM | Futures | 34326.5 | 34341.1 | 34256.5 | 34268.9 | 889.0 |
| 2022-06-15 01:00:00 | YM | Futures | 34268.9 | 34366.0 | 34219.3 | 34307.3 | 2482.0 |
| 2022-06-15 02:00:00 | YM | Futures | 34307.3 | 34385.1 | 34277.9 | 34340.0 | 2951.0 |
| 2022-06-15 03:00:00 | YM | Futures | 34340.0 | 34408.8 | 34275.7 | 34404.3 | 5377.0 |
> showing 50 of 2,061 rows — these rows as CSV