PREVIEW / futures_1hour / 2022-11-03
file: by_date/futures_1hour/2022/2022-11-03.parquet size: 69 KB rows: 2,097
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-11-03 00:00:00 | ES | Futures | 4259.13 | 4261.95 | 4255.75 | 4257.72 | 6478.0 |
| 2022-11-03 01:00:00 | ES | Futures | 4257.72 | 4265.05 | 4256.88 | 4258.0 | 7173.0 |
| 2022-11-03 02:00:00 | ES | Futures | 4258.0 | 4258.85 | 4247.85 | 4253.21 | 11793.0 |
| 2022-11-03 03:00:00 | ES | Futures | 4252.93 | 4259.13 | 4241.93 | 4250.11 | 22315.0 |
| 2022-11-03 04:00:00 | ES | Futures | 4250.11 | 4257.72 | 4236.58 | 4243.34 | 40063.0 |
| 2022-11-03 05:00:00 | ES | Futures | 4243.06 | 4248.7 | 4233.2 | 4241.09 | 23013.0 |
| 2022-11-03 06:00:00 | ES | Futures | 4241.09 | 4244.19 | 4219.1 | 4224.46 | 32561.0 |
| 2022-11-03 07:00:00 | ES | Futures | 4224.18 | 4225.58 | 4211.77 | 4216.0 | 34799.0 |
| 2022-11-03 08:00:00 | ES | Futures | 4216.0 | 4225.3 | 4202.75 | 4204.16 | 56313.0 |
| 2022-11-03 09:00:00 | ES | Futures | 4204.16 | 4216.56 | 4179.92 | 4181.61 | 276636.0 |
| 2022-11-03 10:00:00 | ES | Futures | 4181.61 | 4231.5 | 4176.82 | 4230.1 | 348370.0 |
| 2022-11-03 11:00:00 | ES | Futures | 4230.1 | 4232.63 | 4202.19 | 4210.08 | 214021.0 |
| 2022-11-03 12:00:00 | ES | Futures | 4210.36 | 4237.99 | 4206.13 | 4234.04 | 167275.0 |
| 2022-11-03 13:00:00 | ES | Futures | 4234.04 | 4236.3 | 4215.72 | 4216.0 | 112206.0 |
| 2022-11-03 14:00:00 | ES | Futures | 4216.28 | 4232.07 | 4211.49 | 4230.66 | 118344.0 |
| 2022-11-03 15:00:00 | ES | Futures | 4230.66 | 4231.5 | 4201.06 | 4201.62 | 218432.0 |
| 2022-11-03 16:00:00 | ES | Futures | 4201.62 | 4207.54 | 4199.65 | 4200.78 | 60066.0 |
| 2022-11-03 18:00:00 | ES | Futures | 4199.09 | 4200.21 | 4189.78 | 4195.14 | 11074.0 |
| 2022-11-03 19:00:00 | ES | Futures | 4195.42 | 4197.11 | 4192.32 | 4195.7 | 5281.0 |
| 2022-11-03 20:00:00 | ES | Futures | 4195.7 | 4203.03 | 4195.7 | 4200.5 | 9159.0 |
| 2022-11-03 21:00:00 | ES | Futures | 4200.78 | 4202.75 | 4194.86 | 4202.47 | 10414.0 |
| 2022-11-03 22:00:00 | ES | Futures | 4202.47 | 4204.44 | 4200.21 | 4202.47 | 7694.0 |
| 2022-11-03 23:00:00 | ES | Futures | 4202.19 | 4204.16 | 4200.5 | 4203.88 | 6125.0 |
| 2022-11-03 00:00:00 | NQ | Futures | 12619.35 | 12627.4 | 12606.71 | 12614.76 | 3272.0 |
| 2022-11-03 01:00:00 | NQ | Futures | 12615.62 | 12637.74 | 12611.88 | 12614.76 | 4228.0 |
| 2022-11-03 02:00:00 | NQ | Futures | 12613.61 | 12617.34 | 12578.55 | 12596.08 | 6504.0 |
| 2022-11-03 03:00:00 | NQ | Futures | 12596.08 | 12613.32 | 12551.83 | 12575.97 | 10469.0 |
| 2022-11-03 04:00:00 | NQ | Futures | 12576.83 | 12601.54 | 12523.39 | 12548.38 | 17093.0 |
| 2022-11-03 05:00:00 | NQ | Futures | 12547.52 | 12566.49 | 12517.35 | 12544.65 | 11649.0 |
| 2022-11-03 06:00:00 | NQ | Futures | 12544.36 | 12552.69 | 12473.1 | 12488.33 | 14388.0 |
| 2022-11-03 07:00:00 | NQ | Futures | 12487.18 | 12493.5 | 12430.87 | 12444.95 | 15684.0 |
| 2022-11-03 08:00:00 | NQ | Futures | 12444.66 | 12480.29 | 12415.06 | 12418.22 | 29702.0 |
| 2022-11-03 09:00:00 | NQ | Futures | 12417.65 | 12468.22 | 12323.98 | 12327.14 | 110667.0 |
| 2022-11-03 10:00:00 | NQ | Futures | 12328.0 | 12507.3 | 12306.74 | 12489.48 | 120647.0 |
| 2022-11-03 11:00:00 | NQ | Futures | 12490.06 | 12514.19 | 12359.61 | 12374.84 | 80069.0 |
| 2022-11-03 12:00:00 | NQ | Futures | 12375.7 | 12483.45 | 12357.31 | 12471.67 | 63080.0 |
| 2022-11-03 13:00:00 | NQ | Futures | 12471.95 | 12478.85 | 12386.33 | 12386.91 | 41155.0 |
| 2022-11-03 14:00:00 | NQ | Futures | 12387.77 | 12432.59 | 12371.1 | 12423.11 | 44037.0 |
| 2022-11-03 15:00:00 | NQ | Futures | 12423.4 | 12426.84 | 12317.09 | 12325.99 | 71269.0 |
| 2022-11-03 16:00:00 | NQ | Futures | 12326.28 | 12345.24 | 12316.51 | 12330.3 | 17270.0 |
| 2022-11-03 18:00:00 | NQ | Futures | 12311.34 | 12322.55 | 12289.22 | 12310.76 | 6105.0 |
| 2022-11-03 19:00:00 | NQ | Futures | 12311.63 | 12320.25 | 12303.58 | 12309.62 | 3361.0 |
| 2022-11-03 20:00:00 | NQ | Futures | 12309.9 | 12337.49 | 12309.62 | 12335.48 | 4509.0 |
| 2022-11-03 21:00:00 | NQ | Futures | 12335.48 | 12345.82 | 12316.22 | 12344.38 | 4981.0 |
| 2022-11-03 22:00:00 | NQ | Futures | 12345.53 | 12353.86 | 12336.62 | 12347.54 | 3286.0 |
| 2022-11-03 23:00:00 | NQ | Futures | 12348.12 | 12352.14 | 12339.5 | 12349.27 | 2308.0 |
| 2022-11-03 00:00:00 | YM | Futures | 36179.7 | 36195.4 | 36156.1 | 36169.6 | 629.0 |
| 2022-11-03 01:00:00 | YM | Futures | 36171.8 | 36217.8 | 36164.0 | 36175.2 | 844.0 |
| 2022-11-03 02:00:00 | YM | Futures | 36174.1 | 36179.7 | 36109.0 | 36140.4 | 1683.0 |
| 2022-11-03 03:00:00 | YM | Futures | 36139.3 | 36186.4 | 36059.6 | 36121.3 | 3226.0 |
> showing 50 of 2,097 rows — these rows as CSV