PREVIEW / futures_1hour / 2023-05-11
file: by_date/futures_1hour/2023/2023-05-11.parquet size: 67 KB rows: 2,054
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-11 00:00:00 | ES | Futures | 4616.27 | 4618.21 | 4615.44 | 4617.1 | 2973.0 |
| 2023-05-11 01:00:00 | ES | Futures | 4616.82 | 4619.32 | 4614.61 | 4617.93 | 5144.0 |
| 2023-05-11 02:00:00 | ES | Futures | 4617.93 | 4618.21 | 4611.55 | 4612.39 | 8514.0 |
| 2023-05-11 03:00:00 | ES | Futures | 4612.11 | 4624.31 | 4611.83 | 4619.6 | 21730.0 |
| 2023-05-11 04:00:00 | ES | Futures | 4619.6 | 4624.31 | 4617.38 | 4619.32 | 12976.0 |
| 2023-05-11 05:00:00 | ES | Futures | 4619.6 | 4624.59 | 4616.55 | 4619.88 | 14898.0 |
| 2023-05-11 06:00:00 | ES | Futures | 4619.88 | 4622.09 | 4613.22 | 4613.5 | 14369.0 |
| 2023-05-11 07:00:00 | ES | Futures | 4613.22 | 4614.33 | 4597.96 | 4600.46 | 31883.0 |
| 2023-05-11 08:00:00 | ES | Futures | 4600.46 | 4618.49 | 4599.63 | 4601.29 | 73825.0 |
| 2023-05-11 09:00:00 | ES | Futures | 4601.29 | 4601.57 | 4574.39 | 4576.05 | 230688.0 |
| 2023-05-11 10:00:00 | ES | Futures | 4576.33 | 4588.53 | 4572.45 | 4587.7 | 224716.0 |
| 2023-05-11 11:00:00 | ES | Futures | 4587.98 | 4595.19 | 4583.26 | 4593.53 | 141737.0 |
| 2023-05-11 12:00:00 | ES | Futures | 4593.8 | 4597.96 | 4586.59 | 4595.19 | 115044.0 |
| 2023-05-11 13:00:00 | ES | Futures | 4595.47 | 4596.3 | 4575.78 | 4587.7 | 126150.0 |
| 2023-05-11 14:00:00 | ES | Futures | 4587.7 | 4600.46 | 4583.26 | 4598.24 | 124065.0 |
| 2023-05-11 15:00:00 | ES | Futures | 4597.96 | 4599.07 | 4589.09 | 4597.41 | 177464.0 |
| 2023-05-11 16:00:00 | ES | Futures | 4597.41 | 4599.35 | 4594.36 | 4598.8 | 61953.0 |
| 2023-05-11 18:00:00 | ES | Futures | 4597.96 | 4603.51 | 4597.13 | 4602.68 | 6197.0 |
| 2023-05-11 19:00:00 | ES | Futures | 4602.4 | 4602.68 | 4599.63 | 4599.63 | 2912.0 |
| 2023-05-11 20:00:00 | ES | Futures | 4599.35 | 4606.29 | 4598.8 | 4605.73 | 8327.0 |
| 2023-05-11 21:00:00 | ES | Futures | 4605.45 | 4609.61 | 4604.9 | 4607.39 | 9149.0 |
| 2023-05-11 22:00:00 | ES | Futures | 4607.12 | 4607.39 | 4602.12 | 4604.07 | 5623.0 |
| 2023-05-11 23:00:00 | ES | Futures | 4604.07 | 4604.34 | 4601.85 | 4603.23 | 3696.0 |
| 2023-05-11 00:00:00 | NQ | Futures | 15129.25 | 15134.6 | 15121.09 | 15129.53 | 1947.0 |
| 2023-05-11 01:00:00 | NQ | Futures | 15129.25 | 15135.16 | 15121.65 | 15129.81 | 2525.0 |
| 2023-05-11 02:00:00 | NQ | Futures | 15129.81 | 15137.42 | 15112.64 | 15113.77 | 4661.0 |
| 2023-05-11 03:00:00 | NQ | Futures | 15114.05 | 15155.15 | 15112.36 | 15138.26 | 9922.0 |
| 2023-05-11 04:00:00 | NQ | Futures | 15138.54 | 15161.35 | 15128.41 | 15146.43 | 7204.0 |
| 2023-05-11 05:00:00 | NQ | Futures | 15146.99 | 15163.04 | 15137.7 | 15151.78 | 5737.0 |
| 2023-05-11 06:00:00 | NQ | Futures | 15151.78 | 15159.66 | 15129.81 | 15130.66 | 5450.0 |
| 2023-05-11 07:00:00 | NQ | Futures | 15130.38 | 15132.63 | 15096.03 | 15110.11 | 13927.0 |
| 2023-05-11 08:00:00 | NQ | Futures | 15110.11 | 15167.26 | 15109.26 | 15129.25 | 29668.0 |
| 2023-05-11 09:00:00 | NQ | Futures | 15129.53 | 15130.94 | 15059.99 | 15075.19 | 107861.0 |
| 2023-05-11 10:00:00 | NQ | Futures | 15074.91 | 15113.2 | 15047.88 | 15112.08 | 113923.0 |
| 2023-05-11 11:00:00 | NQ | Futures | 15112.08 | 15147.27 | 15094.9 | 15137.98 | 77685.0 |
| 2023-05-11 12:00:00 | NQ | Futures | 15138.54 | 15158.53 | 15112.36 | 15148.4 | 56012.0 |
| 2023-05-11 13:00:00 | NQ | Futures | 15148.68 | 15153.18 | 15083.92 | 15120.8 | 61569.0 |
| 2023-05-11 14:00:00 | NQ | Futures | 15121.09 | 15170.36 | 15110.39 | 15163.04 | 55869.0 |
| 2023-05-11 15:00:00 | NQ | Futures | 15163.6 | 15167.82 | 15125.31 | 15144.46 | 63525.0 |
| 2023-05-11 16:00:00 | NQ | Futures | 15144.46 | 15148.12 | 15131.22 | 15144.17 | 13306.0 |
| 2023-05-11 18:00:00 | NQ | Futures | 15143.05 | 15166.13 | 15141.64 | 15162.47 | 3194.0 |
| 2023-05-11 19:00:00 | NQ | Futures | 15162.47 | 15163.04 | 15151.49 | 15153.18 | 1622.0 |
| 2023-05-11 20:00:00 | NQ | Futures | 15152.34 | 15184.72 | 15150.93 | 15181.34 | 5932.0 |
| 2023-05-11 21:00:00 | NQ | Futures | 15181.06 | 15197.39 | 15177.4 | 15192.04 | 5772.0 |
| 2023-05-11 22:00:00 | NQ | Futures | 15191.47 | 15192.32 | 15175.71 | 15181.34 | 3441.0 |
| 2023-05-11 23:00:00 | NQ | Futures | 15181.34 | 15185.28 | 15172.61 | 15183.59 | 2126.0 |
| 2023-05-11 00:00:00 | YM | Futures | 37172.6 | 37187.0 | 37167.1 | 37175.9 | 809.0 |
| 2023-05-11 01:00:00 | YM | Futures | 37175.9 | 37195.8 | 37157.2 | 37188.1 | 941.0 |
| 2023-05-11 02:00:00 | YM | Futures | 37188.1 | 37188.1 | 37125.1 | 37128.4 | 2140.0 |
| 2023-05-11 03:00:00 | YM | Futures | 37129.5 | 37230.1 | 37126.2 | 37195.8 | 4104.0 |
> showing 50 of 2,054 rows — these rows as CSV