PREVIEW / futures_1hour / 2016-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-05.parquet
  size:    53 KB
  rows:    1,615

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
2016-05-05 00:00:00	ES	Futures	2217.89	2217.89	2216.81	2217.08	2580.0
2016-05-05 01:00:00	ES	Futures	2217.08	2217.35	2216.27	2217.35	4129.0
2016-05-05 02:00:00	ES	Futures	2217.35	2221.13	2216.81	2218.97	12987.0
2016-05-05 03:00:00	ES	Futures	2218.97	2220.59	2216.27	2217.62	25311.0
2016-05-05 04:00:00	ES	Futures	2217.62	2224.64	2215.46	2223.29	31082.0
2016-05-05 05:00:00	ES	Futures	2223.02	2223.29	2217.35	2218.43	18222.0
2016-05-05 06:00:00	ES	Futures	2218.16	2218.97	2214.92	2218.43	25573.0
2016-05-05 07:00:00	ES	Futures	2218.7	2219.51	2215.46	2218.16	18963.0
2016-05-05 08:00:00	ES	Futures	2218.16	2218.97	2215.73	2217.35	33778.0
2016-05-05 09:00:00	ES	Futures	2217.35	2217.62	2211.14	2213.57	221809.0
2016-05-05 10:00:00	ES	Futures	2213.3	2219.24	2210.6	2213.57	252565.0
2016-05-05 11:00:00	ES	Futures	2213.84	2216.27	2208.98	2214.92	143467.0
2016-05-05 12:00:00	ES	Futures	2214.92	2216.54	2210.87	2212.22	84455.0
2016-05-05 13:00:00	ES	Futures	2212.22	2212.76	2202.5	2204.93	154793.0
2016-05-05 14:00:00	ES	Futures	2204.66	2209.25	2203.31	2205.47	118988.0
2016-05-05 15:00:00	ES	Futures	2205.2	2208.44	2203.04	2208.17	201065.0
2016-05-05 16:00:00	ES	Futures	2208.17	2208.44	2206.01	2206.55	51270.0
2016-05-05 18:00:00	ES	Futures	2206.82	2207.09	2200.88	2202.77	8683.0
2016-05-05 19:00:00	ES	Futures	2202.77	2207.36	2202.77	2207.09	5571.0
2016-05-05 20:00:00	ES	Futures	2207.09	2208.98	2204.93	2207.36	6910.0
2016-05-05 21:00:00	ES	Futures	2207.09	2209.79	2203.85	2204.66	9385.0
2016-05-05 22:00:00	ES	Futures	2204.66	2205.74	2203.31	2203.58	4304.0
2016-05-05 23:00:00	ES	Futures	2203.58	2205.2	2203.04	2204.93	3277.0
2016-05-05 00:00:00	NQ	Futures	5149.35	5149.35	5145.18	5145.48	316.0
2016-05-05 01:00:00	NQ	Futures	5145.48	5147.26	5144.88	5146.37	479.0
2016-05-05 02:00:00	NQ	Futures	5147.26	5157.08	5146.37	5152.32	1878.0
2016-05-05 03:00:00	NQ	Futures	5152.02	5157.38	5145.48	5148.16	3681.0
2016-05-05 04:00:00	NQ	Futures	5147.56	5168.09	5142.5	5163.93	3981.0
2016-05-05 05:00:00	NQ	Futures	5164.22	5164.82	5147.26	5149.64	2425.0
2016-05-05 06:00:00	NQ	Futures	5149.64	5151.43	5139.23	5147.56	3761.0
2016-05-05 07:00:00	NQ	Futures	5148.16	5150.24	5141.61	5146.97	2616.0
2016-05-05 08:00:00	NQ	Futures	5147.56	5149.35	5143.1	5146.37	3231.0
2016-05-05 09:00:00	NQ	Futures	5146.37	5146.67	5120.19	5124.95	40144.0
2016-05-05 10:00:00	NQ	Futures	5124.95	5147.56	5120.19	5135.96	40661.0
2016-05-05 11:00:00	NQ	Futures	5135.96	5151.13	5125.54	5143.4	26057.0
2016-05-05 12:00:00	NQ	Futures	5143.4	5147.26	5132.39	5134.77	13975.0
2016-05-05 13:00:00	NQ	Futures	5134.47	5136.26	5108.59	5116.32	22946.0
2016-05-05 14:00:00	NQ	Futures	5116.32	5130.01	5111.26	5117.21	17436.0
2016-05-05 15:00:00	NQ	Futures	5116.92	5124.65	5111.86	5119.89	27370.0
2016-05-05 16:00:00	NQ	Futures	5119.89	5120.49	5114.54	5115.73	4126.0
2016-05-05 18:00:00	NQ	Futures	5116.62	5117.21	5102.34	5104.42	1758.0
2016-05-05 19:00:00	NQ	Futures	5104.42	5114.83	5104.42	5114.83	976.0
2016-05-05 20:00:00	NQ	Futures	5114.83	5118.11	5108.59	5115.43	839.0
2016-05-05 21:00:00	NQ	Futures	5115.73	5120.49	5106.2	5108.59	1077.0
2016-05-05 22:00:00	NQ	Futures	5108.29	5111.56	5106.2	5106.2	516.0
2016-05-05 23:00:00	NQ	Futures	5105.91	5110.37	5104.72	5108.59	574.0
2016-05-05 00:00:00	YM	Futures	18872.0	18875.3	18866.7	18868.8	396.0
2016-05-05 01:00:00	YM	Futures	18867.8	18874.2	18861.3	18866.7	756.0
2016-05-05 02:00:00	YM	Futures	18867.8	18899.9	18865.6	18882.7	2160.0
2016-05-05 03:00:00	YM	Futures	18881.7	18900.9	18866.7	18874.2	3373.0

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

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