PREVIEW / futures_1hour / 2022-10-04
file: by_date/futures_1hour/2022/2022-10-04.parquet size: 70 KB rows: 2,100
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-10-04 00:00:00 | ES | Futures | 4196.55 | 4205.29 | 4192.04 | 4199.93 | 12672.0 |
| 2022-10-04 01:00:00 | ES | Futures | 4199.93 | 4205.57 | 4196.83 | 4202.47 | 12200.0 |
| 2022-10-04 02:00:00 | ES | Futures | 4202.75 | 4210.08 | 4198.81 | 4208.95 | 21556.0 |
| 2022-10-04 03:00:00 | ES | Futures | 4208.95 | 4223.89 | 4202.75 | 4221.92 | 45860.0 |
| 2022-10-04 04:00:00 | ES | Futures | 4221.92 | 4224.46 | 4217.13 | 4223.05 | 27818.0 |
| 2022-10-04 05:00:00 | ES | Futures | 4223.33 | 4228.4 | 4211.49 | 4226.43 | 36436.0 |
| 2022-10-04 06:00:00 | ES | Futures | 4226.43 | 4241.37 | 4223.33 | 4232.07 | 44937.0 |
| 2022-10-04 07:00:00 | ES | Futures | 4232.07 | 4232.35 | 4224.46 | 4231.22 | 34393.0 |
| 2022-10-04 08:00:00 | ES | Futures | 4231.5 | 4234.04 | 4219.1 | 4228.69 | 56641.0 |
| 2022-10-04 09:00:00 | ES | Futures | 4228.69 | 4270.12 | 4221.92 | 4269.0 | 315080.0 |
| 2022-10-04 10:00:00 | ES | Futures | 4269.0 | 4284.78 | 4267.31 | 4282.81 | 392926.0 |
| 2022-10-04 11:00:00 | ES | Futures | 4282.81 | 4287.6 | 4273.51 | 4280.55 | 208046.0 |
| 2022-10-04 12:00:00 | ES | Futures | 4280.55 | 4287.04 | 4267.31 | 4270.97 | 165021.0 |
| 2022-10-04 13:00:00 | ES | Futures | 4270.97 | 4277.74 | 4247.01 | 4272.38 | 208656.0 |
| 2022-10-04 14:00:00 | ES | Futures | 4272.38 | 4285.06 | 4262.79 | 4281.68 | 189329.0 |
| 2022-10-04 15:00:00 | ES | Futures | 4281.4 | 4291.27 | 4262.79 | 4290.42 | 370011.0 |
| 2022-10-04 16:00:00 | ES | Futures | 4290.42 | 4294.65 | 4285.63 | 4288.73 | 78850.0 |
| 2022-10-04 18:00:00 | ES | Futures | 4285.91 | 4289.86 | 4279.14 | 4281.4 | 9407.0 |
| 2022-10-04 19:00:00 | ES | Futures | 4281.4 | 4282.25 | 4276.33 | 4280.55 | 8077.0 |
| 2022-10-04 20:00:00 | ES | Futures | 4280.27 | 4280.55 | 4267.87 | 4271.25 | 16810.0 |
| 2022-10-04 21:00:00 | ES | Futures | 4271.25 | 4278.58 | 4262.51 | 4265.9 | 19475.0 |
| 2022-10-04 22:00:00 | ES | Futures | 4266.18 | 4272.94 | 4262.79 | 4267.02 | 12706.0 |
| 2022-10-04 23:00:00 | ES | Futures | 4266.74 | 4270.12 | 4265.33 | 4269.0 | 7189.0 |
| 2022-10-04 00:00:00 | NQ | Futures | 13100.34 | 13133.67 | 13085.4 | 13117.29 | 6775.0 |
| 2022-10-04 01:00:00 | NQ | Futures | 13117.58 | 13143.72 | 13110.11 | 13125.05 | 6987.0 |
| 2022-10-04 02:00:00 | NQ | Futures | 13124.76 | 13157.8 | 13113.27 | 13153.2 | 10755.0 |
| 2022-10-04 03:00:00 | NQ | Futures | 13154.35 | 13212.39 | 13134.53 | 13205.21 | 23098.0 |
| 2022-10-04 04:00:00 | NQ | Futures | 13205.21 | 13215.84 | 13185.96 | 13209.23 | 16656.0 |
| 2022-10-04 05:00:00 | NQ | Futures | 13210.67 | 13235.67 | 13178.78 | 13227.91 | 16481.0 |
| 2022-10-04 06:00:00 | NQ | Futures | 13227.91 | 13278.77 | 13220.44 | 13247.45 | 17103.0 |
| 2022-10-04 07:00:00 | NQ | Futures | 13248.02 | 13248.6 | 13223.89 | 13239.69 | 14895.0 |
| 2022-10-04 08:00:00 | NQ | Futures | 13239.98 | 13248.6 | 13196.59 | 13232.79 | 23812.0 |
| 2022-10-04 09:00:00 | NQ | Futures | 13233.37 | 13354.62 | 13212.68 | 13351.17 | 106724.0 |
| 2022-10-04 10:00:00 | NQ | Futures | 13350.88 | 13418.12 | 13350.88 | 13411.8 | 114301.0 |
| 2022-10-04 11:00:00 | NQ | Futures | 13412.09 | 13417.83 | 13360.08 | 13386.8 | 65068.0 |
| 2022-10-04 12:00:00 | NQ | Futures | 13386.51 | 13400.88 | 13321.58 | 13332.5 | 60798.0 |
| 2022-10-04 13:00:00 | NQ | Futures | 13333.07 | 13359.5 | 13244.86 | 13341.12 | 77030.0 |
| 2022-10-04 14:00:00 | NQ | Futures | 13341.12 | 13387.38 | 13310.66 | 13373.87 | 54043.0 |
| 2022-10-04 15:00:00 | NQ | Futures | 13373.87 | 13385.65 | 13306.06 | 13382.2 | 82851.0 |
| 2022-10-04 16:00:00 | NQ | Futures | 13381.92 | 13407.2 | 13367.84 | 13383.93 | 19505.0 |
| 2022-10-04 18:00:00 | NQ | Futures | 13366.69 | 13383.93 | 13350.6 | 13359.22 | 4408.0 |
| 2022-10-04 19:00:00 | NQ | Futures | 13359.22 | 13364.1 | 13342.26 | 13355.77 | 3719.0 |
| 2022-10-04 20:00:00 | NQ | Futures | 13355.48 | 13356.63 | 13300.32 | 13315.83 | 7068.0 |
| 2022-10-04 21:00:00 | NQ | Futures | 13316.12 | 13346.86 | 13289.68 | 13304.91 | 8494.0 |
| 2022-10-04 22:00:00 | NQ | Futures | 13303.19 | 13330.77 | 13296.01 | 13308.07 | 5981.0 |
| 2022-10-04 23:00:00 | NQ | Futures | 13306.64 | 13321.86 | 13304.34 | 13315.83 | 3390.0 |
| 2022-10-04 00:00:00 | YM | Futures | 33390.9 | 33452.7 | 33356.2 | 33413.4 | 1873.0 |
| 2022-10-04 01:00:00 | YM | Futures | 33413.4 | 33448.2 | 33386.5 | 33429.1 | 1531.0 |
| 2022-10-04 02:00:00 | YM | Futures | 33431.3 | 33484.1 | 33404.4 | 33474.0 | 2302.0 |
| 2022-10-04 03:00:00 | YM | Futures | 33477.4 | 33588.5 | 33435.8 | 33568.3 | 5201.0 |
> showing 50 of 2,100 rows — these rows as CSV