PREVIEW / futures_1hour / 2022-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-10-25.parquet
  size:    69 KB
  rows:    2,092

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-25 00:00:00	ES	Futures	4296.06	4302.26	4294.93	4298.31	5898.0
2022-10-25 01:00:00	ES	Futures	4298.31	4300.0	4290.98	4295.21	8832.0
2022-10-25 02:00:00	ES	Futures	4295.21	4305.36	4294.37	4298.88	13375.0
2022-10-25 03:00:00	ES	Futures	4299.16	4304.52	4289.57	4295.49	21785.0
2022-10-25 04:00:00	ES	Futures	4295.49	4300.29	4286.19	4287.88	20746.0
2022-10-25 05:00:00	ES	Futures	4287.88	4288.17	4274.07	4278.02	21015.0
2022-10-25 06:00:00	ES	Futures	4278.3	4284.78	4273.51	4284.5	19727.0
2022-10-25 07:00:00	ES	Futures	4284.5	4290.42	4279.43	4280.27	21695.0
2022-10-25 08:00:00	ES	Futures	4280.55	4283.94	4273.79	4283.66	40902.0
2022-10-25 09:00:00	ES	Futures	4283.37	4338.34	4283.37	4335.24	267740.0
2022-10-25 10:00:00	ES	Futures	4335.24	4342.57	4323.12	4333.83	263031.0
2022-10-25 11:00:00	ES	Futures	4333.83	4352.72	4331.58	4348.21	172138.0
2022-10-25 12:00:00	ES	Futures	4348.21	4356.38	4342.01	4343.42	138775.0
2022-10-25 13:00:00	ES	Futures	4343.42	4349.34	4334.68	4342.29	161125.0
2022-10-25 14:00:00	ES	Futures	4342.57	4359.48	4341.44	4349.05	132492.0
2022-10-25 15:00:00	ES	Futures	4349.05	4368.51	4348.49	4363.71	272103.0
2022-10-25 16:00:00	ES	Futures	4363.99	4365.97	4335.52	4344.83	136635.0
2022-10-25 18:00:00	ES	Futures	4331.01	4332.42	4321.99	4322.27	25622.0
2022-10-25 19:00:00	ES	Futures	4322.27	4324.25	4315.79	4321.71	13412.0
2022-10-25 20:00:00	ES	Futures	4321.71	4324.25	4312.97	4314.95	15966.0
2022-10-25 21:00:00	ES	Futures	4314.95	4325.66	4312.13	4323.12	16878.0
2022-10-25 22:00:00	ES	Futures	4323.12	4329.32	4323.12	4326.5	10477.0
2022-10-25 23:00:00	ES	Futures	4326.78	4327.91	4322.84	4325.38	6057.0
2022-10-25 00:00:00	NQ	Futures	13197.17	13211.53	13193.43	13200.61	2401.0
2022-10-25 01:00:00	NQ	Futures	13200.61	13206.65	13174.47	13190.84	4084.0
2022-10-25 02:00:00	NQ	Futures	13190.56	13232.79	13190.27	13210.67	8136.0
2022-10-25 03:00:00	NQ	Futures	13210.67	13231.64	13182.22	13209.52	14649.0
2022-10-25 04:00:00	NQ	Futures	13208.95	13227.05	13180.5	13185.67	10906.0
2022-10-25 05:00:00	NQ	Futures	13185.67	13185.96	13148.32	13162.69	8351.0
2022-10-25 06:00:00	NQ	Futures	13163.84	13196.3	13148.03	13194.29	8752.0
2022-10-25 07:00:00	NQ	Futures	13194.58	13209.81	13173.89	13177.91	9449.0
2022-10-25 08:00:00	NQ	Futures	13178.2	13194.87	13155.79	13191.42	18226.0
2022-10-25 09:00:00	NQ	Futures	13191.13	13406.34	13190.84	13388.52	109185.0
2022-10-25 10:00:00	NQ	Futures	13389.1	13404.04	13338.82	13366.11	92637.0
2022-10-25 11:00:00	NQ	Futures	13366.11	13443.4	13356.92	13428.46	66407.0
2022-10-25 12:00:00	NQ	Futures	13428.75	13453.75	13385.08	13393.98	47894.0
2022-10-25 13:00:00	NQ	Futures	13394.56	13412.37	13349.45	13386.8	53001.0
2022-10-25 14:00:00	NQ	Futures	13386.8	13447.71	13382.49	13413.52	42935.0
2022-10-25 15:00:00	NQ	Futures	13413.81	13478.46	13411.22	13461.22	68835.0
2022-10-25 16:00:00	NQ	Futures	13461.22	13485.93	13262.68	13315.54	52005.0
2022-10-25 18:00:00	NQ	Futures	13228.48	13246.01	13183.66	13187.11	17929.0
2022-10-25 19:00:00	NQ	Futures	13186.82	13192.57	13160.96	13181.08	8761.0
2022-10-25 20:00:00	NQ	Futures	13181.94	13189.98	13150.33	13158.66	7548.0
2022-10-25 21:00:00	NQ	Futures	13158.66	13205.21	13143.72	13197.17	7273.0
2022-10-25 22:00:00	NQ	Futures	13198.03	13225.04	13196.59	13212.39	6452.0
2022-10-25 23:00:00	NQ	Futures	13213.54	13215.55	13198.31	13210.38	3496.0
2022-10-25 00:00:00	YM	Futures	35399.7	35448.0	35394.1	35418.8	827.0
2022-10-25 01:00:00	YM	Futures	35416.6	35427.8	35371.7	35400.9	903.0
2022-10-25 02:00:00	YM	Futures	35398.6	35462.6	35390.8	35418.8	2794.0
2022-10-25 03:00:00	YM	Futures	35419.9	35454.7	35339.1	35376.2	3243.0

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

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