PREVIEW / futures_1hour / 2022-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-01.parquet
  size:    58 KB
  rows:    1,669

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-04-01 00:00:00	ES	Futures	5154.36	5155.21	5149.54	5150.11	3753.0
2022-04-01 01:00:00	ES	Futures	5150.39	5154.08	5146.71	5146.71	5995.0
2022-04-01 02:00:00	ES	Futures	5146.71	5157.19	5145.29	5155.49	9383.0
2022-04-01 03:00:00	ES	Futures	5155.49	5160.03	5148.12	5155.21	16340.0
2022-04-01 04:00:00	ES	Futures	5155.21	5159.46	5153.79	5158.33	8823.0
2022-04-01 05:00:00	ES	Futures	5158.33	5163.43	5151.81	5161.73	16081.0
2022-04-01 06:00:00	ES	Futures	5161.73	5164.85	5158.33	5161.16	7349.0
2022-04-01 07:00:00	ES	Futures	5160.88	5162.58	5157.76	5160.03	12545.0
2022-04-01 08:00:00	ES	Futures	5160.03	5163.15	5148.97	5149.83	32438.0
2022-04-01 09:00:00	ES	Futures	5149.83	5156.06	5131.97	5139.34	159848.0
2022-04-01 10:00:00	ES	Futures	5138.77	5145.57	5122.33	5135.65	217431.0
2022-04-01 11:00:00	ES	Futures	5135.65	5141.04	5114.4	5116.95	140802.0
2022-04-01 12:00:00	ES	Futures	5116.95	5118.93	5105.89	5112.69	109706.0
2022-04-01 13:00:00	ES	Futures	5112.69	5123.47	5103.34	5119.78	97164.0
2022-04-01 14:00:00	ES	Futures	5119.5	5145.01	5118.65	5134.24	137428.0
2022-04-01 15:00:00	ES	Futures	5133.95	5149.54	5117.23	5145.01	299230.0
2022-04-01 16:00:00	ES	Futures	5145.29	5147.84	5137.92	5145.57	60591.0
2022-04-01 00:00:00	NQ	Futures	17309.77	17320.79	17293.53	17295.85	1927.0
2022-04-01 01:00:00	NQ	Futures	17295.85	17314.7	17289.76	17289.76	2329.0
2022-04-01 02:00:00	NQ	Futures	17290.34	17338.19	17284.25	17332.68	5129.0
2022-04-01 03:00:00	NQ	Futures	17333.26	17343.7	17295.56	17321.37	8169.0
2022-04-01 04:00:00	NQ	Futures	17319.34	17332.97	17304.55	17316.44	4364.0
2022-04-01 05:00:00	NQ	Futures	17316.15	17338.19	17290.05	17332.68	6817.0
2022-04-01 06:00:00	NQ	Futures	17333.84	17352.11	17325.43	17335.0	4442.0
2022-04-01 07:00:00	NQ	Futures	17335.0	17341.67	17319.05	17340.22	4284.0
2022-04-01 08:00:00	NQ	Futures	17340.22	17346.31	17277.29	17279.32	14212.0
2022-04-01 09:00:00	NQ	Futures	17279.61	17319.63	17176.09	17211.47	76186.0
2022-04-01 10:00:00	NQ	Futures	17211.47	17281.35	17174.06	17270.91	88976.0
2022-04-01 11:00:00	NQ	Futures	17270.62	17277.29	17113.75	17125.93	66211.0
2022-04-01 12:00:00	NQ	Futures	17125.64	17151.44	17088.81	17102.73	48545.0
2022-04-01 13:00:00	NQ	Futures	17102.15	17153.76	17079.53	17126.51	41631.0
2022-04-01 14:00:00	NQ	Futures	17126.22	17232.06	17115.2	17183.34	50172.0
2022-04-01 15:00:00	NQ	Futures	17182.76	17250.04	17105.92	17236.99	77303.0
2022-04-01 16:00:00	NQ	Futures	17236.12	17239.6	17200.45	17227.13	17015.0
2022-04-01 00:00:00	YM	Futures	39153.3	39163.5	39125.1	39128.5	699.0
2022-04-01 01:00:00	YM	Futures	39125.1	39155.6	39102.6	39102.6	1249.0
2022-04-01 02:00:00	YM	Futures	39101.5	39164.6	39090.2	39155.6	1643.0
2022-04-01 03:00:00	YM	Futures	39156.7	39189.4	39115.0	39164.6	2715.0
2022-04-01 04:00:00	YM	Futures	39163.5	39199.5	39155.6	39190.5	3081.0
2022-04-01 05:00:00	YM	Futures	39190.5	39228.9	39148.8	39221.0	3799.0
2022-04-01 06:00:00	YM	Futures	39219.8	39236.7	39192.8	39214.2	1644.0
2022-04-01 07:00:00	YM	Futures	39215.3	39233.4	39196.2	39207.4	2000.0
2022-04-01 08:00:00	YM	Futures	39206.3	39231.1	39139.8	39154.5	5155.0
2022-04-01 09:00:00	YM	Futures	39151.1	39196.2	39041.7	39078.9	20096.0
2022-04-01 10:00:00	YM	Futures	39086.8	39099.2	38874.9	38983.1	22178.0
2022-04-01 11:00:00	YM	Futures	38982.0	39049.6	38904.2	38935.7	14831.0
2022-04-01 12:00:00	YM	Futures	38934.6	38940.3	38842.2	38908.7	11985.0
2022-04-01 13:00:00	YM	Futures	38905.3	38986.5	38821.9	38975.2	10995.0
2022-04-01 14:00:00	YM	Futures	38974.1	39160.1	38967.3	39077.8	15335.0
2022-04-01 15:00:00	YM	Futures	39075.5	39174.7	38957.2	39128.5	22075.0

> showing 50 of 1,669 rows — these rows as CSV

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