PREVIEW / futures_1hour / 2015-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-07.parquet
  size:    54 KB
  rows:    1,605

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
2015-05-07 00:00:00	ES	Futures	2193.5	2194.82	2193.23	2194.03	1957.0
2015-05-07 01:00:00	ES	Futures	2194.03	2194.03	2191.39	2191.91	2901.0
2015-05-07 02:00:00	ES	Futures	2191.91	2192.44	2187.42	2188.22	8485.0
2015-05-07 03:00:00	ES	Futures	2188.48	2189.8	2184.25	2185.84	37427.0
2015-05-07 04:00:00	ES	Futures	2185.84	2190.06	2180.29	2182.93	36695.0
2015-05-07 05:00:00	ES	Futures	2183.2	2183.2	2173.16	2179.24	51333.0
2015-05-07 06:00:00	ES	Futures	2179.24	2181.08	2175.01	2179.5	32520.0
2015-05-07 07:00:00	ES	Futures	2179.5	2188.22	2179.24	2188.22	37547.0
2015-05-07 08:00:00	ES	Futures	2188.22	2193.23	2185.05	2186.63	74132.0
2015-05-07 09:00:00	ES	Futures	2186.63	2195.61	2186.37	2187.69	242569.0
2015-05-07 10:00:00	ES	Futures	2187.69	2198.25	2186.1	2196.14	272803.0
2015-05-07 11:00:00	ES	Futures	2196.4	2202.21	2194.55	2199.04	147011.0
2015-05-07 12:00:00	ES	Futures	2199.04	2206.18	2198.52	2204.06	103573.0
2015-05-07 13:00:00	ES	Futures	2204.33	2205.91	2200.37	2201.69	72309.0
2015-05-07 14:00:00	ES	Futures	2201.69	2204.86	2201.42	2203.01	61523.0
2015-05-07 15:00:00	ES	Futures	2203.27	2204.59	2197.99	2200.89	158523.0
2015-05-07 16:00:00	ES	Futures	2200.63	2202.48	2200.1	2201.42	66265.0
2015-05-07 17:00:00	ES	Futures	2201.16	2202.74	2201.16	2202.74	2340.0
2015-05-07 18:00:00	ES	Futures	2203.01	2203.53	2201.69	2201.95	4178.0
2015-05-07 19:00:00	ES	Futures	2202.21	2203.01	2201.69	2203.01	1598.0
2015-05-07 20:00:00	ES	Futures	2202.74	2204.86	2201.95	2203.53	6625.0
2015-05-07 21:00:00	ES	Futures	2203.27	2205.65	2203.01	2204.86	3419.0
2015-05-07 22:00:00	ES	Futures	2204.86	2204.86	2203.53	2204.33	2627.0
2015-05-07 23:00:00	ES	Futures	2204.33	2204.86	2204.33	2204.86	1387.0
2015-05-07 00:00:00	NQ	Futures	5148.17	5150.82	5147.88	5148.17	279.0
2015-05-07 01:00:00	NQ	Futures	5148.17	5148.46	5142.58	5144.05	405.0
2015-05-07 02:00:00	NQ	Futures	5143.17	5144.94	5134.64	5137.0	1215.0
2015-05-07 03:00:00	NQ	Futures	5137.0	5139.94	5125.53	5130.82	5674.0
2015-05-07 04:00:00	NQ	Futures	5131.11	5141.7	5114.65	5122.59	6039.0
2015-05-07 05:00:00	NQ	Futures	5122.88	5122.88	5096.12	5111.41	10181.0
2015-05-07 06:00:00	NQ	Futures	5111.12	5117.0	5102.0	5113.47	6939.0
2015-05-07 07:00:00	NQ	Futures	5113.47	5137.88	5113.18	5137.58	6363.0
2015-05-07 08:00:00	NQ	Futures	5137.58	5149.05	5127.29	5132.0	11844.0
2015-05-07 09:00:00	NQ	Futures	5132.0	5172.87	5130.23	5148.76	52195.0
2015-05-07 10:00:00	NQ	Futures	5148.46	5172.87	5141.11	5164.05	47820.0
2015-05-07 11:00:00	NQ	Futures	5163.76	5175.81	5158.46	5167.58	23191.0
2015-05-07 12:00:00	NQ	Futures	5167.28	5186.1	5165.52	5181.99	17347.0
2015-05-07 13:00:00	NQ	Futures	5182.28	5186.4	5170.52	5172.28	13150.0
2015-05-07 14:00:00	NQ	Futures	5172.58	5184.34	5172.58	5180.22	10875.0
2015-05-07 15:00:00	NQ	Futures	5179.93	5183.16	5164.34	5172.28	26485.0
2015-05-07 16:00:00	NQ	Futures	5172.28	5179.34	5171.11	5175.81	5907.0
2015-05-07 17:00:00	NQ	Futures	5175.81	5179.64	5175.52	5179.05	178.0
2015-05-07 18:00:00	NQ	Futures	5180.22	5182.28	5176.99	5177.87	504.0
2015-05-07 19:00:00	NQ	Futures	5177.87	5180.52	5176.69	5179.93	228.0
2015-05-07 20:00:00	NQ	Futures	5180.52	5185.81	5177.87	5182.28	1007.0
2015-05-07 21:00:00	NQ	Futures	5182.28	5188.75	5180.81	5186.69	731.0
2015-05-07 22:00:00	NQ	Futures	5186.69	5186.99	5184.63	5185.81	533.0
2015-05-07 23:00:00	NQ	Futures	5186.1	5188.16	5186.1	5187.87	261.0
2015-05-07 00:00:00	YM	Futures	18655.8	18675.7	18653.7	18668.4	1978.0
2015-05-07 01:00:00	YM	Futures	18668.4	18669.4	18650.5	18655.8	604.0

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

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