PREVIEW / futures_1hour / 2014-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-14.parquet
  size:    49 KB
  rows:    1,564

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-14 00:00:00	ES	Futures	1970.13	1970.64	1969.61	1969.61	2208.0
2014-05-14 01:00:00	ES	Futures	1969.61	1970.38	1969.35	1970.13	2722.0
2014-05-14 02:00:00	ES	Futures	1970.13	1970.13	1969.35	1969.61	4338.0
2014-05-14 03:00:00	ES	Futures	1969.35	1969.61	1966.75	1966.75	16253.0
2014-05-14 04:00:00	ES	Futures	1967.01	1967.53	1965.97	1966.49	14609.0
2014-05-14 05:00:00	ES	Futures	1966.49	1968.31	1965.45	1965.71	15225.0
2014-05-14 06:00:00	ES	Futures	1965.71	1966.23	1964.41	1965.19	15797.0
2014-05-14 07:00:00	ES	Futures	1965.45	1966.23	1963.63	1964.67	18779.0
2014-05-14 08:00:00	ES	Futures	1964.67	1965.19	1963.63	1964.15	28605.0
2014-05-14 09:00:00	ES	Futures	1964.15	1966.49	1961.3	1964.67	220027.0
2014-05-14 10:00:00	ES	Futures	1964.41	1965.97	1960.78	1962.34	214642.0
2014-05-14 11:00:00	ES	Futures	1962.59	1964.67	1961.3	1962.59	117627.0
2014-05-14 12:00:00	ES	Futures	1962.59	1964.41	1962.34	1963.11	67347.0
2014-05-14 13:00:00	ES	Futures	1963.37	1964.93	1962.85	1963.63	49768.0
2014-05-14 14:00:00	ES	Futures	1963.89	1963.89	1958.96	1959.48	90149.0
2014-05-14 15:00:00	ES	Futures	1959.48	1960.0	1955.06	1957.66	223036.0
2014-05-14 16:00:00	ES	Futures	1957.92	1958.7	1957.14	1957.92	60809.0
2014-05-14 17:00:00	ES	Futures	1957.92	1959.22	1957.92	1958.96	2449.0
2014-05-14 18:00:00	ES	Futures	1958.7	1959.48	1957.92	1958.7	2465.0
2014-05-14 19:00:00	ES	Futures	1958.7	1959.48	1957.14	1957.66	3117.0
2014-05-14 20:00:00	ES	Futures	1957.66	1958.44	1955.84	1957.92	6388.0
2014-05-14 21:00:00	ES	Futures	1957.92	1960.0	1957.4	1958.96	5629.0
2014-05-14 22:00:00	ES	Futures	1958.7	1958.96	1957.14	1957.14	3119.0
2014-05-14 23:00:00	ES	Futures	1957.14	1957.92	1956.62	1957.92	3040.0
2014-05-14 00:00:00	NQ	Futures	4209.04	4210.2	4208.74	4208.74	257.0
2014-05-14 01:00:00	NQ	Futures	4208.74	4211.07	4208.45	4210.49	361.0
2014-05-14 02:00:00	NQ	Futures	4210.49	4211.07	4209.33	4210.2	665.0
2014-05-14 03:00:00	NQ	Futures	4210.2	4210.49	4204.38	4204.67	2280.0
2014-05-14 04:00:00	NQ	Futures	4204.67	4205.25	4200.88	4202.63	2485.0
2014-05-14 05:00:00	NQ	Futures	4202.63	4205.25	4197.68	4198.26	3290.0
2014-05-14 06:00:00	NQ	Futures	4198.26	4200.3	4196.22	4198.84	3434.0
2014-05-14 07:00:00	NQ	Futures	4198.84	4200.88	4195.06	4196.51	2204.0
2014-05-14 08:00:00	NQ	Futures	4196.22	4197.68	4189.52	4189.81	8911.0
2014-05-14 09:00:00	NQ	Futures	4189.81	4205.54	4188.94	4204.08	45432.0
2014-05-14 10:00:00	NQ	Futures	4204.38	4209.62	4191.85	4199.43	42971.0
2014-05-14 11:00:00	NQ	Futures	4199.43	4203.21	4192.14	4195.93	22420.0
2014-05-14 12:00:00	NQ	Futures	4195.93	4203.5	4195.93	4200.88	13989.0
2014-05-14 13:00:00	NQ	Futures	4201.17	4207.58	4200.59	4202.34	10997.0
2014-05-14 14:00:00	NQ	Futures	4202.63	4203.79	4188.94	4190.4	20134.0
2014-05-14 15:00:00	NQ	Futures	4190.4	4191.27	4174.09	4183.7	44909.0
2014-05-14 16:00:00	NQ	Futures	4183.41	4193.6	4182.53	4191.27	7471.0
2014-05-14 17:00:00	NQ	Futures	4191.27	4195.06	4191.27	4194.47	301.0
2014-05-14 18:00:00	NQ	Futures	4192.73	4194.77	4190.69	4192.73	463.0
2014-05-14 19:00:00	NQ	Futures	4192.73	4193.31	4190.11	4190.4	369.0
2014-05-14 20:00:00	NQ	Futures	4190.4	4192.73	4187.78	4191.27	894.0
2014-05-14 21:00:00	NQ	Futures	4191.56	4195.35	4190.69	4191.85	789.0
2014-05-14 22:00:00	NQ	Futures	4191.56	4193.6	4190.4	4190.4	671.0
2014-05-14 23:00:00	NQ	Futures	4190.11	4191.85	4189.23	4191.56	523.0
2014-05-14 00:00:00	YM	Futures	17191.4	17192.5	17186.3	17186.3	413.0
2014-05-14 01:00:00	YM	Futures	17186.3	17189.4	17184.2	17188.4	358.0

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

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