PREVIEW / futures_1hour / 2021-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-20.parquet
  size:    64 KB
  rows:    1,971

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-20 00:00:00	ES	Futures	4617.73	4623.63	4616.89	4623.35	4795.0
2021-05-20 01:00:00	ES	Futures	4623.07	4623.91	4619.42	4620.26	8038.0
2021-05-20 02:00:00	ES	Futures	4619.98	4621.1	4614.08	4614.92	10939.0
2021-05-20 03:00:00	ES	Futures	4614.92	4619.42	4613.52	4616.61	22685.0
2021-05-20 04:00:00	ES	Futures	4616.33	4616.61	4596.66	4599.75	23796.0
2021-05-20 05:00:00	ES	Futures	4599.75	4602.0	4590.48	4597.22	21493.0
2021-05-20 06:00:00	ES	Futures	4597.5	4605.09	4594.13	4604.81	11726.0
2021-05-20 07:00:00	ES	Futures	4604.81	4614.08	4603.96	4612.95	19224.0
2021-05-20 08:00:00	ES	Futures	4612.95	4625.04	4611.27	4625.04	34095.0
2021-05-20 09:00:00	ES	Futures	4625.04	4647.23	4624.19	4645.27	206530.0
2021-05-20 10:00:00	ES	Futures	4645.55	4657.91	4643.86	4655.38	171055.0
2021-05-20 11:00:00	ES	Futures	4655.66	4680.39	4655.38	4673.64	178851.0
2021-05-20 12:00:00	ES	Futures	4673.64	4673.92	4657.07	4665.5	142852.0
2021-05-20 13:00:00	ES	Futures	4665.21	4673.36	4662.12	4668.59	93877.0
2021-05-20 14:00:00	ES	Futures	4668.59	4676.73	4668.02	4673.64	96472.0
2021-05-20 15:00:00	ES	Futures	4673.92	4685.73	4666.34	4670.27	277105.0
2021-05-20 16:00:00	ES	Futures	4670.27	4671.96	4664.93	4666.34	56615.0
2021-05-20 18:00:00	ES	Futures	4666.9	4672.24	4665.78	4670.55	5261.0
2021-05-20 19:00:00	ES	Futures	4670.83	4677.58	4669.71	4676.73	4573.0
2021-05-20 20:00:00	ES	Futures	4676.73	4682.63	4673.92	4680.11	10016.0
2021-05-20 21:00:00	ES	Futures	4680.39	4682.63	4675.89	4675.89	9220.0
2021-05-20 22:00:00	ES	Futures	4675.61	4676.73	4670.55	4675.61	8537.0
2021-05-20 23:00:00	ES	Futures	4675.61	4677.86	4671.96	4673.64	5940.0
2021-05-20 00:00:00	NQ	Futures	15300.69	15322.99	15298.96	15321.54	2022.0
2021-05-20 01:00:00	NQ	Futures	15320.38	15325.59	15300.98	15311.98	3303.0
2021-05-20 02:00:00	NQ	Futures	15310.83	15325.3	15283.32	15291.43	6373.0
2021-05-20 03:00:00	NQ	Futures	15292.3	15354.54	15270.88	15333.12	12156.0
2021-05-20 04:00:00	NQ	Futures	15333.12	15336.01	15245.98	15270.01	9565.0
2021-05-20 05:00:00	NQ	Futures	15269.72	15274.64	15228.32	15249.74	8035.0
2021-05-20 06:00:00	NQ	Futures	15250.03	15280.43	15235.85	15279.56	5388.0
2021-05-20 07:00:00	NQ	Futures	15279.85	15331.67	15276.96	15321.83	7393.0
2021-05-20 08:00:00	NQ	Futures	15322.7	15380.02	15312.56	15380.02	14771.0
2021-05-20 09:00:00	NQ	Futures	15379.44	15515.5	15375.38	15499.29	73111.0
2021-05-20 10:00:00	NQ	Futures	15499.0	15571.37	15495.24	15554.0	61762.0
2021-05-20 11:00:00	NQ	Futures	15554.29	15637.09	15544.74	15620.01	53756.0
2021-05-20 12:00:00	NQ	Futures	15620.3	15620.88	15567.9	15594.82	47578.0
2021-05-20 13:00:00	NQ	Futures	15594.82	15630.14	15582.95	15608.72	28004.0
2021-05-20 14:00:00	NQ	Futures	15609.01	15646.64	15598.58	15639.11	26577.0
2021-05-20 15:00:00	NQ	Futures	15639.11	15659.09	15610.74	15617.11	61031.0
2021-05-20 16:00:00	NQ	Futures	15617.98	15639.69	15608.72	15620.3	12154.0
2021-05-20 18:00:00	NQ	Futures	15624.06	15636.8	15616.82	15629.27	2329.0
2021-05-20 19:00:00	NQ	Futures	15629.56	15657.06	15625.8	15655.04	2701.0
2021-05-20 20:00:00	NQ	Futures	15656.77	15683.41	15646.35	15674.43	6339.0
2021-05-20 21:00:00	NQ	Futures	15674.14	15687.46	15645.19	15646.06	5817.0
2021-05-20 22:00:00	NQ	Futures	15645.77	15652.43	15623.48	15641.14	4631.0
2021-05-20 23:00:00	NQ	Futures	15641.43	15652.72	15627.53	15633.9	3371.0
2021-05-20 00:00:00	YM	Futures	37641.5	37697.2	37633.7	37693.8	1097.0
2021-05-20 01:00:00	YM	Futures	37692.7	37698.3	37666.0	37678.2	1230.0
2021-05-20 02:00:00	YM	Futures	37677.1	37684.9	37629.2	37632.6	2177.0
2021-05-20 03:00:00	YM	Futures	37633.7	37670.5	37612.5	37628.1	3903.0

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

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