PREVIEW / futures_1hour / 2014-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-19.parquet
  size:    48 KB
  rows:    1,508

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
2014-05-19 00:00:00	ES	Futures	1947.27	1947.79	1947.01	1947.01	2333.0
2014-05-19 01:00:00	ES	Futures	1947.01	1947.27	1944.94	1944.94	4635.0
2014-05-19 02:00:00	ES	Futures	1944.94	1945.98	1944.16	1944.68	6936.0
2014-05-19 03:00:00	ES	Futures	1944.42	1945.98	1942.6	1944.42	23284.0
2014-05-19 04:00:00	ES	Futures	1944.16	1944.16	1938.45	1940.0	35293.0
2014-05-19 05:00:00	ES	Futures	1939.74	1940.26	1937.93	1939.48	22552.0
2014-05-19 06:00:00	ES	Futures	1939.48	1942.08	1938.96	1940.52	21296.0
2014-05-19 07:00:00	ES	Futures	1940.78	1945.2	1940.52	1944.68	28692.0
2014-05-19 08:00:00	ES	Futures	1944.68	1945.46	1941.82	1942.08	30772.0
2014-05-19 09:00:00	ES	Futures	1942.08	1950.65	1941.56	1949.09	200186.0
2014-05-19 10:00:00	ES	Futures	1948.83	1951.43	1946.24	1949.87	166831.0
2014-05-19 11:00:00	ES	Futures	1949.87	1954.54	1949.61	1953.51	123630.0
2014-05-19 12:00:00	ES	Futures	1953.51	1954.8	1951.17	1951.95	68754.0
2014-05-19 13:00:00	ES	Futures	1952.21	1954.29	1951.43	1953.51	48544.0
2014-05-19 14:00:00	ES	Futures	1953.51	1955.58	1952.99	1953.77	58034.0
2014-05-19 15:00:00	ES	Futures	1953.77	1955.84	1951.95	1954.29	113824.0
2014-05-19 16:00:00	ES	Futures	1954.54	1955.84	1954.03	1954.29	56884.0
2014-05-19 17:00:00	ES	Futures	1954.54	1954.54	1954.29	1954.54	1237.0
2014-05-19 18:00:00	ES	Futures	1954.29	1954.29	1952.47	1952.99	6327.0
2014-05-19 19:00:00	ES	Futures	1953.25	1953.51	1952.73	1953.25	1014.0
2014-05-19 20:00:00	ES	Futures	1952.99	1953.25	1951.95	1952.73	3895.0
2014-05-19 21:00:00	ES	Futures	1952.47	1954.54	1952.47	1954.54	2991.0
2014-05-19 22:00:00	ES	Futures	1954.54	1954.8	1954.03	1954.54	2153.0
2014-05-19 23:00:00	ES	Futures	1954.29	1955.06	1954.29	1954.8	1208.0
2014-05-19 00:00:00	NQ	Futures	4175.25	4177.0	4174.38	4174.96	252.0
2014-05-19 01:00:00	NQ	Futures	4174.96	4175.25	4168.56	4168.85	765.0
2014-05-19 02:00:00	NQ	Futures	4168.85	4170.89	4166.23	4168.26	786.0
2014-05-19 03:00:00	NQ	Futures	4167.97	4172.34	4163.31	4168.56	4030.0
2014-05-19 04:00:00	NQ	Futures	4168.85	4168.85	4153.99	4157.2	5373.0
2014-05-19 05:00:00	NQ	Futures	4157.2	4157.78	4153.41	4157.49	2404.0
2014-05-19 06:00:00	NQ	Futures	4157.78	4161.28	4155.16	4157.49	3407.0
2014-05-19 07:00:00	NQ	Futures	4157.78	4168.26	4157.78	4167.39	3451.0
2014-05-19 08:00:00	NQ	Futures	4167.39	4168.26	4164.77	4166.23	3951.0
2014-05-19 09:00:00	NQ	Futures	4166.23	4190.11	4158.36	4182.83	43003.0
2014-05-19 10:00:00	NQ	Futures	4182.83	4198.55	4174.96	4196.22	42457.0
2014-05-19 11:00:00	NQ	Futures	4196.22	4209.33	4195.35	4207.29	32205.0
2014-05-19 12:00:00	NQ	Futures	4207.29	4213.11	4203.5	4205.25	19301.0
2014-05-19 13:00:00	NQ	Futures	4205.25	4209.91	4202.05	4208.74	13520.0
2014-05-19 14:00:00	NQ	Futures	4208.74	4212.53	4206.41	4208.16	12684.0
2014-05-19 15:00:00	NQ	Futures	4208.16	4213.99	4202.05	4208.16	24077.0
2014-05-19 16:00:00	NQ	Futures	4207.87	4211.95	4205.83	4206.12	5965.0
2014-05-19 17:00:00	NQ	Futures	4206.41	4206.71	4205.83	4206.71	112.0
2014-05-19 18:00:00	NQ	Futures	4206.71	4206.71	4202.05	4203.79	772.0
2014-05-19 19:00:00	NQ	Futures	4204.08	4204.96	4203.79	4204.38	186.0
2014-05-19 20:00:00	NQ	Futures	4204.08	4204.67	4202.34	4203.79	614.0
2014-05-19 21:00:00	NQ	Futures	4203.79	4208.45	4203.79	4207.87	497.0
2014-05-19 22:00:00	NQ	Futures	4207.87	4209.91	4206.71	4209.33	520.0
2014-05-19 23:00:00	NQ	Futures	4209.33	4211.66	4209.04	4211.37	502.0
2014-05-19 00:00:00	YM	Futures	16951.5	16953.5	16948.4	16950.5	295.0
2014-05-19 01:00:00	YM	Futures	16949.4	16949.4	16931.9	16934.0	728.0

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

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