PREVIEW / futures_1hour / 2021-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-06.parquet
  size:    45 KB
  rows:    1,414

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-09-06 00:00:00	ES	Futures	5105.93	5107.34	5105.09	5105.65	3238.0
2021-09-06 01:00:00	ES	Futures	5105.93	5109.59	5104.24	5109.31	4454.0
2021-09-06 02:00:00	ES	Futures	5109.03	5114.66	5109.03	5112.41	6973.0
2021-09-06 03:00:00	ES	Futures	5112.41	5118.04	5111.56	5115.79	13238.0
2021-09-06 04:00:00	ES	Futures	5115.79	5118.32	5115.5	5118.04	6956.0
2021-09-06 05:00:00	ES	Futures	5118.04	5118.6	5116.07	5117.19	8108.0
2021-09-06 06:00:00	ES	Futures	5117.19	5120.01	5116.63	5117.48	7421.0
2021-09-06 07:00:00	ES	Futures	5117.19	5119.16	5116.91	5118.32	3966.0
2021-09-06 08:00:00	ES	Futures	5118.32	5119.16	5116.91	5117.48	3641.0
2021-09-06 09:00:00	ES	Futures	5117.76	5122.54	5116.91	5122.26	8659.0
2021-09-06 10:00:00	ES	Futures	5121.98	5122.54	5120.29	5121.14	9734.0
2021-09-06 11:00:00	ES	Futures	5121.14	5121.14	5118.04	5118.32	5939.0
2021-09-06 12:00:00	ES	Futures	5118.6	5119.73	5116.35	5118.6	4181.0
2021-09-06 18:00:00	ES	Futures	5119.45	5119.45	5114.38	5114.66	3725.0
2021-09-06 19:00:00	ES	Futures	5114.66	5116.07	5112.41	5112.41	3529.0
2021-09-06 20:00:00	ES	Futures	5112.69	5114.66	5110.72	5111.56	5724.0
2021-09-06 21:00:00	ES	Futures	5111.28	5112.41	5109.59	5111.84	5926.0
2021-09-06 22:00:00	ES	Futures	5111.84	5114.66	5111.28	5114.38	4099.0
2021-09-06 23:00:00	ES	Futures	5114.1	5114.66	5111.56	5112.41	3175.0
2021-09-06 00:00:00	NQ	Futures	18146.5	18150.85	18142.74	18149.69	917.0
2021-09-06 01:00:00	NQ	Futures	18149.69	18174.02	18143.61	18165.04	3220.0
2021-09-06 02:00:00	NQ	Futures	18164.75	18185.03	18164.46	18176.34	3415.0
2021-09-06 03:00:00	NQ	Futures	18176.34	18202.12	18174.02	18190.24	5977.0
2021-09-06 04:00:00	NQ	Futures	18190.53	18191.69	18183.0	18188.8	2576.0
2021-09-06 05:00:00	NQ	Futures	18189.09	18191.98	18181.26	18183.87	2426.0
2021-09-06 06:00:00	NQ	Futures	18184.16	18190.53	18176.05	18178.37	2814.0
2021-09-06 07:00:00	NQ	Futures	18178.37	18188.51	18177.79	18182.42	2599.0
2021-09-06 08:00:00	NQ	Futures	18182.71	18186.48	18178.37	18180.4	2071.0
2021-09-06 09:00:00	NQ	Futures	18180.4	18195.46	18176.63	18195.46	4529.0
2021-09-06 10:00:00	NQ	Futures	18195.17	18200.96	18189.38	18196.91	6522.0
2021-09-06 11:00:00	NQ	Futures	18197.2	18197.2	18187.35	18188.8	3932.0
2021-09-06 12:00:00	NQ	Futures	18189.09	18196.62	18184.45	18193.43	2221.0
2021-09-06 18:00:00	NQ	Futures	18194.3	18194.59	18183.29	18183.87	1817.0
2021-09-06 19:00:00	NQ	Futures	18183.87	18188.8	18177.21	18179.24	1716.0
2021-09-06 20:00:00	NQ	Futures	18178.95	18187.64	18175.18	18176.63	2902.0
2021-09-06 21:00:00	NQ	Futures	18176.92	18178.66	18157.22	18163.3	5562.0
2021-09-06 22:00:00	NQ	Futures	18163.3	18174.02	18161.57	18172.57	2709.0
2021-09-06 23:00:00	NQ	Futures	18172.57	18172.86	18162.44	18165.33	1714.0
2021-09-06 00:00:00	YM	Futures	39496.0	39507.1	39488.2	39489.3	645.0
2021-09-06 01:00:00	YM	Futures	39492.6	39512.7	39477.0	39508.3	662.0
2021-09-06 02:00:00	YM	Futures	39508.3	39560.8	39508.3	39530.6	1860.0
2021-09-06 03:00:00	YM	Futures	39530.6	39579.8	39520.6	39559.7	2919.0
2021-09-06 04:00:00	YM	Futures	39561.9	39588.7	39561.9	39582.0	1480.0
2021-09-06 05:00:00	YM	Futures	39582.0	39587.6	39573.1	39582.0	1297.0
2021-09-06 06:00:00	YM	Futures	39582.0	39601.0	39574.2	39576.4	2026.0
2021-09-06 07:00:00	YM	Futures	39577.5	39588.7	39570.8	39579.8	920.0
2021-09-06 08:00:00	YM	Futures	39580.9	39597.6	39578.7	39589.8	1101.0
2021-09-06 09:00:00	YM	Futures	39590.9	39635.6	39588.7	39626.7	2426.0
2021-09-06 10:00:00	YM	Futures	39626.7	39630.0	39603.2	39606.6	2547.0
2021-09-06 11:00:00	YM	Futures	39607.7	39613.3	39585.4	39585.4	1337.0

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

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