PREVIEW / futures_1hour / 2021-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-01.parquet
  size:    65 KB
  rows:    1,995

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
2021-02-01 00:00:00	ES	Futures	4179.68	4181.93	4176.6	4180.53	9274.0
2021-02-01 01:00:00	ES	Futures	4180.53	4181.93	4175.75	4178.28	8854.0
2021-02-01 02:00:00	ES	Futures	4178.28	4198.77	4170.98	4193.16	29195.0
2021-02-01 03:00:00	ES	Futures	4193.16	4200.73	4178.28	4193.72	35236.0
2021-02-01 04:00:00	ES	Futures	4193.72	4202.98	4189.23	4196.8	25459.0
2021-02-01 05:00:00	ES	Futures	4196.8	4201.86	4190.35	4192.59	18953.0
2021-02-01 06:00:00	ES	Futures	4192.59	4211.4	4191.19	4199.61	31659.0
2021-02-01 07:00:00	ES	Futures	4199.61	4209.15	4197.65	4198.49	27026.0
2021-02-01 08:00:00	ES	Futures	4198.77	4201.58	4194.0	4196.24	35635.0
2021-02-01 09:00:00	ES	Futures	4196.24	4206.91	4173.23	4186.42	215069.0
2021-02-01 10:00:00	ES	Futures	4186.14	4202.14	4176.32	4188.95	243662.0
2021-02-01 11:00:00	ES	Futures	4189.23	4222.91	4182.49	4215.05	189778.0
2021-02-01 12:00:00	ES	Futures	4215.33	4230.48	4215.33	4230.2	105194.0
2021-02-01 13:00:00	ES	Futures	4230.2	4233.01	4222.91	4229.92	82137.0
2021-02-01 14:00:00	ES	Futures	4229.92	4240.31	4225.43	4234.69	96418.0
2021-02-01 15:00:00	ES	Futures	4234.98	4239.75	4224.87	4226.56	254170.0
2021-02-01 16:00:00	ES	Futures	4226.56	4227.96	4217.29	4225.43	79083.0
2021-02-01 18:00:00	ES	Futures	4226.56	4236.1	4225.43	4232.17	11676.0
2021-02-01 19:00:00	ES	Futures	4232.17	4232.45	4221.22	4229.36	14203.0
2021-02-01 20:00:00	ES	Futures	4229.36	4252.38	4228.24	4250.41	24353.0
2021-02-01 21:00:00	ES	Futures	4250.41	4257.15	4245.08	4251.53	14231.0
2021-02-01 22:00:00	ES	Futures	4251.82	4252.38	4247.32	4251.25	7711.0
2021-02-01 23:00:00	ES	Futures	4251.25	4252.38	4247.04	4249.29	5867.0
2021-02-01 00:00:00	NQ	Futures	14997.59	15030.58	14992.38	15021.61	5272.0
2021-02-01 01:00:00	NQ	Futures	15021.9	15027.11	15000.48	15010.32	3324.0
2021-02-01 02:00:00	NQ	Futures	15010.9	15092.23	14970.96	15070.53	12728.0
2021-02-01 03:00:00	NQ	Futures	15069.95	15106.99	15030.87	15087.89	16955.0
2021-02-01 04:00:00	NQ	Futures	15087.02	15122.33	15074.0	15103.23	11419.0
2021-02-01 05:00:00	NQ	Futures	15102.36	15117.41	15076.6	15092.81	7934.0
2021-02-01 06:00:00	NQ	Futures	15093.68	15147.8	15079.79	15097.15	10584.0
2021-02-01 07:00:00	NQ	Futures	15096.57	15134.78	15086.44	15102.65	10332.0
2021-02-01 08:00:00	NQ	Futures	15103.81	15118.86	15093.68	15105.55	11520.0
2021-02-01 09:00:00	NQ	Futures	15105.55	15170.96	15016.11	15072.84	71341.0
2021-02-01 10:00:00	NQ	Futures	15072.84	15203.66	15035.79	15135.07	92797.0
2021-02-01 11:00:00	NQ	Futures	15135.36	15279.21	15098.6	15253.45	63301.0
2021-02-01 12:00:00	NQ	Futures	15253.45	15347.51	15253.45	15345.49	44425.0
2021-02-01 13:00:00	NQ	Futures	15345.78	15364.88	15313.65	15353.01	31537.0
2021-02-01 14:00:00	NQ	Futures	15353.01	15361.98	15321.75	15339.7	27074.0
2021-02-01 15:00:00	NQ	Futures	15339.99	15362.27	15313.94	15317.41	52748.0
2021-02-01 16:00:00	NQ	Futures	15316.83	15326.67	15289.34	15322.91	14467.0
2021-02-01 18:00:00	NQ	Futures	15319.73	15370.38	15317.41	15353.88	7834.0
2021-02-01 19:00:00	NQ	Futures	15353.3	15355.04	15318.86	15342.88	5635.0
2021-02-01 20:00:00	NQ	Futures	15344.04	15443.61	15343.46	15434.92	9017.0
2021-02-01 21:00:00	NQ	Futures	15435.79	15480.36	15423.06	15454.89	8035.0
2021-02-01 22:00:00	NQ	Futures	15455.18	15459.23	15433.76	15447.95	4363.0
2021-02-01 23:00:00	NQ	Futures	15448.24	15453.74	15424.5	15425.37	3722.0
2021-02-01 00:00:00	YM	Futures	33286.9	33300.3	33249.2	33274.7	2134.0
2021-02-01 01:00:00	YM	Futures	33275.9	33293.6	33252.6	33265.9	1728.0
2021-02-01 02:00:00	YM	Futures	33265.9	33392.3	33210.4	33359.0	5689.0
2021-02-01 03:00:00	YM	Futures	33359.0	33420.0	33247.0	33366.8	5795.0

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

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