PREVIEW / futures_1hour / 2021-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-19.parquet
  size:    66 KB
  rows:    2,001

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-19 00:00:00	ES	Futures	4618.85	4620.82	4608.46	4612.39	8596.0
2021-05-19 01:00:00	ES	Futures	4612.67	4617.73	4609.86	4617.45	8804.0
2021-05-19 02:00:00	ES	Futures	4617.45	4622.79	4611.83	4616.89	17062.0
2021-05-19 03:00:00	ES	Futures	4617.17	4618.29	4602.0	4606.21	42982.0
2021-05-19 04:00:00	ES	Futures	4606.21	4607.62	4591.88	4596.38	29403.0
2021-05-19 05:00:00	ES	Futures	4596.38	4609.02	4589.91	4592.16	26734.0
2021-05-19 06:00:00	ES	Futures	4592.16	4598.91	4590.2	4596.66	19793.0
2021-05-19 07:00:00	ES	Futures	4596.38	4596.38	4580.36	4584.3	42128.0
2021-05-19 08:00:00	ES	Futures	4584.3	4592.16	4569.69	4573.06	66908.0
2021-05-19 09:00:00	ES	Futures	4573.06	4584.3	4564.07	4576.43	332408.0
2021-05-19 10:00:00	ES	Futures	4576.15	4581.49	4557.88	4577.55	387000.0
2021-05-19 11:00:00	ES	Futures	4577.27	4593.01	4570.53	4592.16	219221.0
2021-05-19 12:00:00	ES	Futures	4591.88	4604.24	4587.67	4601.43	130855.0
2021-05-19 13:00:00	ES	Futures	4601.15	4613.52	4598.62	4603.96	125839.0
2021-05-19 14:00:00	ES	Futures	4604.24	4616.89	4583.45	4590.2	299705.0
2021-05-19 15:00:00	ES	Futures	4590.48	4622.51	4583.73	4620.82	342870.0
2021-05-19 16:00:00	ES	Futures	4620.82	4623.35	4612.95	4616.61	82402.0
2021-05-19 18:00:00	ES	Futures	4616.61	4618.57	4607.9	4607.9	8668.0
2021-05-19 19:00:00	ES	Futures	4607.9	4610.99	4607.34	4608.46	7559.0
2021-05-19 20:00:00	ES	Futures	4608.74	4622.79	4607.34	4617.73	15367.0
2021-05-19 21:00:00	ES	Futures	4617.73	4619.7	4607.62	4617.17	14314.0
2021-05-19 22:00:00	ES	Futures	4616.89	4619.7	4612.39	4613.52	9469.0
2021-05-19 23:00:00	ES	Futures	4613.52	4620.26	4611.83	4617.73	5826.0
2021-05-19 00:00:00	NQ	Futures	15244.53	15254.37	15200.82	15217.32	4880.0
2021-05-19 01:00:00	NQ	Futures	15217.61	15231.5	15206.32	15229.77	4771.0
2021-05-19 02:00:00	NQ	Futures	15229.77	15237.29	15171.0	15216.45	9197.0
2021-05-19 03:00:00	NQ	Futures	15217.03	15223.69	15120.63	15135.97	23401.0
2021-05-19 04:00:00	NQ	Futures	15134.52	15149.29	15091.39	15108.18	13028.0
2021-05-19 05:00:00	NQ	Futures	15109.34	15155.08	15079.23	15089.36	10991.0
2021-05-19 06:00:00	NQ	Futures	15090.23	15131.34	15085.31	15118.6	7455.0
2021-05-19 07:00:00	NQ	Futures	15118.02	15127.29	15047.39	15061.28	16670.0
2021-05-19 08:00:00	NQ	Futures	15061.28	15099.21	15014.09	15031.75	21925.0
2021-05-19 09:00:00	NQ	Futures	15030.88	15143.5	15000.78	15104.42	94038.0
2021-05-19 10:00:00	NQ	Futures	15102.39	15189.82	15059.26	15164.05	93945.0
2021-05-19 11:00:00	NQ	Futures	15163.47	15227.16	15135.1	15207.77	63512.0
2021-05-19 12:00:00	NQ	Futures	15207.48	15253.22	15186.92	15228.03	47237.0
2021-05-19 13:00:00	NQ	Futures	15228.03	15283.03	15223.11	15243.66	39850.0
2021-05-19 14:00:00	NQ	Futures	15244.82	15335.14	15173.32	15225.43	86201.0
2021-05-19 15:00:00	NQ	Futures	15225.71	15330.51	15197.63	15320.67	72215.0
2021-05-19 16:00:00	NQ	Futures	15320.67	15330.51	15283.61	15307.06	13941.0
2021-05-19 18:00:00	NQ	Futures	15309.09	15316.62	15263.06	15265.09	3696.0
2021-05-19 19:00:00	NQ	Futures	15264.8	15276.38	15258.72	15268.56	2894.0
2021-05-19 20:00:00	NQ	Futures	15268.85	15331.09	15261.9	15305.04	6722.0
2021-05-19 21:00:00	NQ	Futures	15305.62	15319.22	15269.14	15305.62	6034.0
2021-05-19 22:00:00	NQ	Futures	15305.91	15314.59	15283.03	15284.77	3965.0
2021-05-19 23:00:00	NQ	Futures	15284.48	15316.33	15276.67	15301.27	3314.0
2021-05-19 00:00:00	YM	Futures	37746.2	37765.1	37668.2	37700.5	1846.0
2021-05-19 01:00:00	YM	Futures	37701.6	37745.1	37681.6	37744.0	1549.0
2021-05-19 02:00:00	YM	Futures	37744.0	37797.4	37721.7	37748.4	3298.0
2021-05-19 03:00:00	YM	Futures	37749.5	37755.1	37657.1	37692.7	7832.0

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

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