PREVIEW / futures_1hour / 2021-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-13.parquet
  size:    65 KB
  rows:    1,992

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-05-13 00:00:00	ES	Futures	4575.87	4578.4	4574.18	4576.71	6131.0
2021-05-13 01:00:00	ES	Futures	4576.71	4577.27	4560.13	4561.26	14529.0
2021-05-13 02:00:00	ES	Futures	4561.54	4575.02	4561.26	4566.88	16929.0
2021-05-13 03:00:00	ES	Futures	4567.16	4568.0	4541.31	4542.71	53936.0
2021-05-13 04:00:00	ES	Futures	4542.43	4548.89	4528.38	4541.03	53017.0
2021-05-13 05:00:00	ES	Futures	4541.31	4552.83	4537.65	4545.24	29732.0
2021-05-13 06:00:00	ES	Futures	4544.96	4550.02	4537.37	4548.33	22994.0
2021-05-13 07:00:00	ES	Futures	4548.33	4569.12	4545.24	4562.38	50042.0
2021-05-13 08:00:00	ES	Futures	4562.38	4579.52	4561.26	4573.06	70259.0
2021-05-13 09:00:00	ES	Futures	4573.06	4612.11	4572.21	4611.55	285522.0
2021-05-13 10:00:00	ES	Futures	4611.83	4634.03	4611.83	4632.06	355938.0
2021-05-13 11:00:00	ES	Futures	4631.78	4633.18	4602.56	4607.62	280208.0
2021-05-13 12:00:00	ES	Futures	4607.9	4624.47	4605.37	4609.86	180333.0
2021-05-13 13:00:00	ES	Futures	4609.86	4616.61	4587.11	4598.06	236748.0
2021-05-13 14:00:00	ES	Futures	4598.34	4630.66	4597.5	4623.35	203632.0
2021-05-13 15:00:00	ES	Futures	4623.35	4637.96	4613.52	4614.36	320672.0
2021-05-13 16:00:00	ES	Futures	4614.36	4620.54	4609.58	4619.98	75328.0
2021-05-13 18:00:00	ES	Futures	4621.95	4621.95	4616.89	4618.57	5280.0
2021-05-13 19:00:00	ES	Futures	4618.57	4624.76	4613.8	4623.07	9237.0
2021-05-13 20:00:00	ES	Futures	4623.35	4631.22	4620.82	4630.37	13815.0
2021-05-13 21:00:00	ES	Futures	4630.09	4636.27	4626.16	4631.78	15340.0
2021-05-13 22:00:00	ES	Futures	4631.78	4633.47	4625.6	4629.81	8974.0
2021-05-13 23:00:00	ES	Futures	4630.09	4639.08	4630.09	4636.27	9351.0
2021-05-13 00:00:00	NQ	Futures	15112.81	15126.71	15108.47	15118.6	3049.0
2021-05-13 01:00:00	NQ	Futures	15117.44	15124.39	15060.7	15068.23	6506.0
2021-05-13 02:00:00	NQ	Futures	15069.1	15122.94	15067.36	15088.49	6892.0
2021-05-13 03:00:00	NQ	Futures	15089.36	15120.92	14987.46	15009.75	20268.0
2021-05-13 04:00:00	NQ	Futures	15009.75	15022.2	14955.33	14996.72	17093.0
2021-05-13 05:00:00	NQ	Futures	14998.17	15036.67	14981.67	15003.67	9311.0
2021-05-13 06:00:00	NQ	Futures	15003.38	15029.15	14979.64	15012.07	8198.0
2021-05-13 07:00:00	NQ	Futures	15012.65	15150.74	14999.62	15114.84	21339.0
2021-05-13 08:00:00	NQ	Futures	15115.13	15192.42	15089.36	15156.24	25511.0
2021-05-13 09:00:00	NQ	Futures	15155.37	15248.59	15154.21	15237.87	87164.0
2021-05-13 10:00:00	NQ	Futures	15237.58	15312.85	15231.22	15285.64	96982.0
2021-05-13 11:00:00	NQ	Futures	15285.64	15291.43	15120.92	15145.81	93308.0
2021-05-13 12:00:00	NQ	Futures	15146.1	15223.98	15131.92	15137.71	62767.0
2021-05-13 13:00:00	NQ	Futures	15137.42	15168.11	15050.57	15100.36	71385.0
2021-05-13 14:00:00	NQ	Futures	15100.65	15234.69	15098.05	15196.77	66911.0
2021-05-13 15:00:00	NQ	Futures	15197.92	15250.03	15161.16	15166.66	68813.0
2021-05-13 16:00:00	NQ	Futures	15166.95	15167.82	15130.18	15159.42	13525.0
2021-05-13 18:00:00	NQ	Futures	15163.76	15180.26	15153.63	15162.89	3668.0
2021-05-13 19:00:00	NQ	Futures	15163.47	15192.42	15135.97	15183.45	6576.0
2021-05-13 20:00:00	NQ	Futures	15183.45	15235.56	15174.18	15228.61	7666.0
2021-05-13 21:00:00	NQ	Futures	15227.74	15271.46	15224.56	15256.69	8027.0
2021-05-13 22:00:00	NQ	Futures	15256.98	15263.64	15221.08	15241.93	5244.0
2021-05-13 23:00:00	NQ	Futures	15242.22	15286.51	15241.93	15262.19	5252.0
2021-05-13 00:00:00	YM	Futures	37432.1	37451.0	37406.5	37427.6	1272.0
2021-05-13 01:00:00	YM	Futures	37426.5	37432.1	37272.8	37287.3	4507.0
2021-05-13 02:00:00	YM	Futures	37287.3	37388.7	37287.3	37324.1	3917.0
2021-05-13 03:00:00	YM	Futures	37325.2	37329.6	37103.5	37109.1	13581.0

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

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