PREVIEW / futures_1hour / 2015-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-20.parquet
  size:    52 KB
  rows:    1,572

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-20 00:00:00	ES	Futures	2121.27	2125.48	2121.0	2123.37	4603.0
2015-01-20 01:00:00	ES	Futures	2123.37	2126.27	2123.11	2125.48	2895.0
2015-01-20 02:00:00	ES	Futures	2125.48	2126.53	2122.85	2125.74	7824.0
2015-01-20 03:00:00	ES	Futures	2126.0	2128.37	2122.32	2123.11	16933.0
2015-01-20 04:00:00	ES	Futures	2123.11	2125.74	2121.27	2123.37	9688.0
2015-01-20 05:00:00	ES	Futures	2123.64	2127.58	2122.32	2127.06	12430.0
2015-01-20 06:00:00	ES	Futures	2127.06	2130.21	2124.16	2129.69	20519.0
2015-01-20 07:00:00	ES	Futures	2129.42	2133.11	2128.11	2131.27	25396.0
2015-01-20 08:00:00	ES	Futures	2131.27	2132.06	2128.11	2128.9	30597.0
2015-01-20 09:00:00	ES	Futures	2128.64	2129.69	2108.9	2112.32	301428.0
2015-01-20 10:00:00	ES	Futures	2111.79	2117.58	2106.53	2109.43	292402.0
2015-01-20 11:00:00	ES	Futures	2109.43	2112.58	2102.58	2105.74	281766.0
2015-01-20 12:00:00	ES	Futures	2106.0	2112.32	2104.16	2110.74	107958.0
2015-01-20 13:00:00	ES	Futures	2111.0	2116.0	2106.79	2113.64	122781.0
2015-01-20 14:00:00	ES	Futures	2113.37	2124.16	2112.85	2123.9	125585.0
2015-01-20 15:00:00	ES	Futures	2123.9	2126.0	2119.69	2122.85	170603.0
2015-01-20 16:00:00	ES	Futures	2122.58	2123.64	2120.21	2121.53	60733.0
2015-01-20 17:00:00	ES	Futures	2121.53	2122.58	2121.27	2122.32	2398.0
2015-01-20 18:00:00	ES	Futures	2121.79	2124.16	2121.0	2123.11	4260.0
2015-01-20 19:00:00	ES	Futures	2123.11	2123.11	2121.0	2121.53	3613.0
2015-01-20 20:00:00	ES	Futures	2121.53	2122.32	2119.16	2120.48	3987.0
2015-01-20 21:00:00	ES	Futures	2120.48	2123.11	2119.95	2122.85	3217.0
2015-01-20 22:00:00	ES	Futures	2122.85	2127.85	2120.48	2121.0	9344.0
2015-01-20 23:00:00	ES	Futures	2120.74	2127.32	2120.74	2125.48	4846.0
2015-01-20 00:00:00	NQ	Futures	4868.47	4877.28	4867.59	4873.76	1978.0
2015-01-20 01:00:00	NQ	Futures	4873.76	4879.93	4873.76	4879.34	803.0
2015-01-20 02:00:00	NQ	Futures	4879.34	4880.22	4872.0	4877.28	1969.0
2015-01-20 03:00:00	NQ	Futures	4877.28	4884.92	4868.77	4871.12	4723.0
2015-01-20 04:00:00	NQ	Futures	4870.82	4876.4	4866.42	4872.0	1685.0
2015-01-20 05:00:00	NQ	Futures	4871.41	4883.74	4869.06	4881.1	3512.0
2015-01-20 06:00:00	NQ	Futures	4881.1	4888.74	4874.35	4885.8	2945.0
2015-01-20 07:00:00	NQ	Futures	4885.51	4896.67	4882.86	4892.26	4126.0
2015-01-20 08:00:00	NQ	Futures	4892.26	4893.73	4883.45	4884.33	5521.0
2015-01-20 09:00:00	NQ	Futures	4884.33	4893.44	4842.92	4851.14	62144.0
2015-01-20 10:00:00	NQ	Futures	4851.14	4869.06	4837.64	4844.39	52628.0
2015-01-20 11:00:00	NQ	Futures	4844.39	4856.14	4827.06	4838.52	37516.0
2015-01-20 12:00:00	NQ	Futures	4838.22	4859.96	4833.52	4858.19	19544.0
2015-01-20 13:00:00	NQ	Futures	4857.9	4873.76	4847.62	4871.41	23871.0
2015-01-20 14:00:00	NQ	Futures	4871.41	4900.48	4869.35	4900.19	26857.0
2015-01-20 15:00:00	NQ	Futures	4899.9	4904.89	4888.15	4891.38	37051.0
2015-01-20 16:00:00	NQ	Futures	4891.67	4896.37	4883.74	4893.73	12152.0
2015-01-20 17:00:00	NQ	Futures	4893.44	4896.08	4893.44	4896.08	164.0
2015-01-20 18:00:00	NQ	Futures	4894.02	4899.9	4893.44	4897.55	973.0
2015-01-20 19:00:00	NQ	Futures	4896.96	4897.25	4892.56	4893.73	761.0
2015-01-20 20:00:00	NQ	Futures	4893.44	4895.49	4887.27	4891.09	781.0
2015-01-20 21:00:00	NQ	Futures	4891.09	4898.14	4889.32	4897.25	571.0
2015-01-20 22:00:00	NQ	Futures	4897.55	4908.71	4889.32	4891.09	2619.0
2015-01-20 23:00:00	NQ	Futures	4890.79	4907.83	4890.21	4902.54	1845.0
2015-01-20 00:00:00	YM	Futures	18217.7	18249.1	18213.6	18232.4	764.0
2015-01-20 01:00:00	YM	Futures	18235.5	18259.5	18235.5	18251.2	709.0

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

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