PREVIEW / futures_1hour / 2022-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-22.parquet
  size:    68 KB
  rows:    2,035

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-09-22 00:00:00	ES	Futures	4265.61	4271.82	4264.77	4267.59	5450.0
2022-09-22 01:00:00	ES	Futures	4267.59	4276.61	4266.46	4269.28	9611.0
2022-09-22 02:00:00	ES	Futures	4269.56	4277.45	4258.57	4264.49	21149.0
2022-09-22 03:00:00	ES	Futures	4264.77	4300.85	4259.41	4298.88	42763.0
2022-09-22 04:00:00	ES	Futures	4298.6	4321.99	4296.9	4309.31	53713.0
2022-09-22 05:00:00	ES	Futures	4309.31	4310.43	4287.88	4293.24	30569.0
2022-09-22 06:00:00	ES	Futures	4293.24	4302.54	4286.19	4299.72	17145.0
2022-09-22 07:00:00	ES	Futures	4299.44	4302.26	4275.2	4293.52	44589.0
2022-09-22 08:00:00	ES	Futures	4293.52	4309.59	4285.06	4300.29	71215.0
2022-09-22 09:00:00	ES	Futures	4300.29	4301.13	4254.9	4260.54	342153.0
2022-09-22 10:00:00	ES	Futures	4260.82	4279.14	4249.55	4250.96	396913.0
2022-09-22 11:00:00	ES	Futures	4250.96	4265.9	4243.63	4255.18	277995.0
2022-09-22 12:00:00	ES	Futures	4255.18	4273.22	4251.8	4263.36	215178.0
2022-09-22 13:00:00	ES	Futures	4263.36	4270.41	4249.55	4266.46	172802.0
2022-09-22 14:00:00	ES	Futures	4266.18	4269.0	4246.73	4266.46	202958.0
2022-09-22 15:00:00	ES	Futures	4266.18	4290.42	4251.52	4252.36	461555.0
2022-09-22 16:00:00	ES	Futures	4252.65	4260.26	4248.42	4255.18	81401.0
2022-09-22 18:00:00	ES	Futures	4259.13	4261.67	4252.93	4257.16	7058.0
2022-09-22 19:00:00	ES	Futures	4257.16	4262.23	4255.47	4261.39	5081.0
2022-09-22 20:00:00	ES	Futures	4261.39	4265.9	4258.85	4260.82	9353.0
2022-09-22 21:00:00	ES	Futures	4260.54	4262.51	4255.18	4261.39	7271.0
2022-09-22 22:00:00	ES	Futures	4261.39	4261.67	4245.04	4250.11	10388.0
2022-09-22 23:00:00	ES	Futures	4250.11	4253.77	4244.47	4246.45	6459.0
2022-09-22 00:00:00	NQ	Futures	13343.7	13366.4	13340.25	13352.9	2938.0
2022-09-22 01:00:00	NQ	Futures	13351.17	13384.21	13345.71	13360.94	5499.0
2022-09-22 02:00:00	NQ	Futures	13361.23	13388.24	13328.47	13348.87	9079.0
2022-09-22 03:00:00	NQ	Futures	13348.59	13475.3	13332.5	13461.22	18732.0
2022-09-22 04:00:00	NQ	Futures	13461.51	13557.18	13458.34	13508.91	25712.0
2022-09-22 05:00:00	NQ	Futures	13508.34	13512.65	13426.74	13448.29	18116.0
2022-09-22 06:00:00	NQ	Futures	13447.43	13486.5	13424.44	13476.45	9768.0
2022-09-22 07:00:00	NQ	Futures	13475.58	13489.09	13377.89	13446.56	22950.0
2022-09-22 08:00:00	NQ	Futures	13447.43	13506.62	13404.61	13466.39	29433.0
2022-09-22 09:00:00	NQ	Futures	13466.1	13471.56	13299.45	13322.15	101153.0
2022-09-22 10:00:00	NQ	Futures	13323.3	13379.33	13257.79	13267.56	114160.0
2022-09-22 11:00:00	NQ	Futures	13267.85	13321.0	13228.48	13290.83	82291.0
2022-09-22 12:00:00	NQ	Futures	13291.41	13343.13	13263.54	13307.79	60162.0
2022-09-22 13:00:00	NQ	Futures	13307.79	13337.96	13258.65	13321.29	51572.0
2022-09-22 14:00:00	NQ	Futures	13321.29	13331.92	13241.7	13312.96	57698.0
2022-09-22 15:00:00	NQ	Futures	13312.67	13429.9	13286.24	13289.4	105652.0
2022-09-22 16:00:00	NQ	Futures	13289.11	13306.35	13266.7	13293.42	20366.0
2022-09-22 18:00:00	NQ	Futures	13313.25	13316.12	13283.65	13298.59	4159.0
2022-09-22 19:00:00	NQ	Futures	13298.88	13320.14	13294.28	13317.55	3765.0
2022-09-22 20:00:00	NQ	Futures	13317.55	13332.21	13308.65	13310.66	4238.0
2022-09-22 21:00:00	NQ	Futures	13310.08	13314.68	13290.55	13312.1	4541.0
2022-09-22 22:00:00	NQ	Futures	13311.52	13312.1	13241.99	13269.28	6737.0
2022-09-22 23:00:00	NQ	Futures	13269.57	13281.93	13248.6	13258.37	3487.0
2022-09-22 00:00:00	YM	Futures	33846.6	33889.2	33843.2	33863.4	836.0
2022-09-22 01:00:00	YM	Futures	33862.3	33922.9	33855.5	33881.4	1573.0
2022-09-22 02:00:00	YM	Futures	33880.2	33943.1	33798.3	33839.8	3943.0
2022-09-22 03:00:00	YM	Futures	33839.8	34100.2	33799.4	34082.2	6408.0

> showing 50 of 2,035 rows — these rows as CSV

> unlock the full archive -- $79 one-time