PREVIEW / futures_1hour / 2015-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-21.parquet
  size:    53 KB
  rows:    1,576

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-01-21 00:00:00	ES	Futures	2125.48	2127.06	2124.42	2124.69	2240.0
2015-01-21 01:00:00	ES	Futures	2124.95	2126.27	2122.58	2123.37	2326.0
2015-01-21 02:00:00	ES	Futures	2123.37	2123.9	2119.16	2122.32	6781.0
2015-01-21 03:00:00	ES	Futures	2122.58	2123.9	2118.37	2119.95	15966.0
2015-01-21 04:00:00	ES	Futures	2119.95	2124.42	2119.69	2121.27	10569.0
2015-01-21 05:00:00	ES	Futures	2121.27	2124.42	2120.74	2123.11	8108.0
2015-01-21 06:00:00	ES	Futures	2123.11	2123.11	2117.58	2118.37	15893.0
2015-01-21 07:00:00	ES	Futures	2118.37	2119.43	2113.64	2115.21	21623.0
2015-01-21 08:00:00	ES	Futures	2115.21	2120.21	2114.16	2116.53	40377.0
2015-01-21 09:00:00	ES	Futures	2116.53	2130.74	2110.74	2124.16	415644.0
2015-01-21 10:00:00	ES	Futures	2123.9	2138.11	2119.16	2137.06	307760.0
2015-01-21 11:00:00	ES	Futures	2137.06	2139.69	2131.53	2135.21	189342.0
2015-01-21 12:00:00	ES	Futures	2135.21	2137.85	2128.9	2131.27	110195.0
2015-01-21 13:00:00	ES	Futures	2131.27	2133.64	2123.9	2124.42	120769.0
2015-01-21 14:00:00	ES	Futures	2124.42	2132.32	2122.32	2131.27	130166.0
2015-01-21 15:00:00	ES	Futures	2131.53	2134.95	2126.79	2133.37	154235.0
2015-01-21 16:00:00	ES	Futures	2133.37	2134.69	2132.06	2133.37	52978.0
2015-01-21 17:00:00	ES	Futures	2133.37	2134.69	2132.85	2133.9	2115.0
2015-01-21 18:00:00	ES	Futures	2133.37	2134.69	2132.06	2133.37	4694.0
2015-01-21 19:00:00	ES	Futures	2133.37	2133.9	2132.32	2133.11	3808.0
2015-01-21 20:00:00	ES	Futures	2132.85	2137.32	2132.85	2136.79	4459.0
2015-01-21 21:00:00	ES	Futures	2136.79	2136.79	2135.48	2136.27	1862.0
2015-01-21 22:00:00	ES	Futures	2136.27	2137.06	2135.21	2136.0	2409.0
2015-01-21 23:00:00	ES	Futures	2136.0	2137.06	2135.74	2136.53	1436.0
2015-01-21 00:00:00	NQ	Futures	4903.13	4907.24	4900.19	4901.95	500.0
2015-01-21 01:00:00	NQ	Futures	4902.25	4904.01	4894.32	4896.96	937.0
2015-01-21 02:00:00	NQ	Futures	4896.37	4897.55	4886.39	4893.73	1721.0
2015-01-21 03:00:00	NQ	Futures	4894.02	4897.84	4880.22	4884.33	4544.0
2015-01-21 04:00:00	NQ	Futures	4884.63	4897.25	4884.63	4887.86	2950.0
2015-01-21 05:00:00	NQ	Futures	4887.56	4895.49	4886.97	4893.73	1482.0
2015-01-21 06:00:00	NQ	Futures	4893.14	4893.14	4880.81	4883.16	3071.0
2015-01-21 07:00:00	NQ	Futures	4883.45	4886.09	4874.05	4878.16	4493.0
2015-01-21 08:00:00	NQ	Futures	4878.16	4890.5	4876.11	4881.39	5615.0
2015-01-21 09:00:00	NQ	Futures	4881.69	4911.64	4859.96	4887.27	84987.0
2015-01-21 10:00:00	NQ	Futures	4886.97	4936.02	4878.75	4931.91	64431.0
2015-01-21 11:00:00	NQ	Futures	4931.91	4940.13	4917.81	4927.5	34049.0
2015-01-21 12:00:00	NQ	Futures	4927.5	4932.5	4907.24	4916.64	21707.0
2015-01-21 13:00:00	NQ	Futures	4916.64	4924.57	4895.49	4895.49	26326.0
2015-01-21 14:00:00	NQ	Futures	4895.79	4919.57	4890.21	4917.22	27373.0
2015-01-21 15:00:00	NQ	Futures	4917.22	4921.63	4904.3	4917.81	28360.0
2015-01-21 16:00:00	NQ	Futures	4917.52	4918.4	4912.53	4915.76	6937.0
2015-01-21 17:00:00	NQ	Futures	4915.46	4917.81	4914.58	4915.46	167.0
2015-01-21 18:00:00	NQ	Futures	4914.88	4916.64	4911.06	4913.41	692.0
2015-01-21 19:00:00	NQ	Futures	4913.11	4914.58	4910.76	4911.94	866.0
2015-01-21 20:00:00	NQ	Futures	4911.94	4921.92	4911.94	4921.92	1094.0
2015-01-21 21:00:00	NQ	Futures	4921.63	4921.92	4917.22	4918.99	513.0
2015-01-21 22:00:00	NQ	Futures	4918.99	4921.34	4917.81	4918.99	622.0
2015-01-21 23:00:00	NQ	Futures	4919.57	4921.63	4918.69	4920.46	413.0
2015-01-21 00:00:00	YM	Futures	18225.1	18235.5	18216.7	18220.9	433.0
2015-01-21 01:00:00	YM	Futures	18224.0	18229.2	18201.0	18207.3	404.0

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

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