PREVIEW / futures_1hour / 2014-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-03.parquet
  size:    48 KB
  rows:    1,549

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-04-03 00:00:00	ES	Futures	1954.8	1955.84	1954.8	1955.58	1926.0
2014-04-03 01:00:00	ES	Futures	1955.32	1955.58	1954.03	1954.54	4141.0
2014-04-03 02:00:00	ES	Futures	1954.54	1955.58	1954.29	1954.8	4670.0
2014-04-03 03:00:00	ES	Futures	1954.8	1955.58	1954.29	1955.06	13422.0
2014-04-03 04:00:00	ES	Futures	1955.06	1958.18	1955.06	1956.62	16639.0
2014-04-03 05:00:00	ES	Futures	1956.62	1958.18	1956.36	1957.92	10660.0
2014-04-03 06:00:00	ES	Futures	1957.92	1959.22	1957.14	1957.92	10921.0
2014-04-03 07:00:00	ES	Futures	1957.92	1958.44	1956.1	1956.62	15125.0
2014-04-03 08:00:00	ES	Futures	1956.62	1957.92	1954.29	1955.58	53902.0
2014-04-03 09:00:00	ES	Futures	1955.32	1960.52	1955.32	1959.22	166229.0
2014-04-03 10:00:00	ES	Futures	1959.22	1959.74	1952.73	1955.58	221849.0
2014-04-03 11:00:00	ES	Futures	1955.32	1955.84	1951.95	1952.73	132077.0
2014-04-03 12:00:00	ES	Futures	1952.73	1954.29	1950.13	1950.91	109630.0
2014-04-03 13:00:00	ES	Futures	1951.17	1955.32	1950.65	1953.25	80415.0
2014-04-03 14:00:00	ES	Futures	1953.25	1953.77	1948.05	1951.43	128094.0
2014-04-03 15:00:00	ES	Futures	1951.43	1956.62	1950.91	1954.03	176507.0
2014-04-03 16:00:00	ES	Futures	1954.03	1957.4	1953.51	1957.4	63893.0
2014-04-03 17:00:00	ES	Futures	1957.14	1957.66	1956.88	1957.4	1509.0
2014-04-03 18:00:00	ES	Futures	1957.14	1957.4	1956.62	1957.14	2804.0
2014-04-03 19:00:00	ES	Futures	1957.14	1958.18	1956.62	1957.4	2570.0
2014-04-03 20:00:00	ES	Futures	1957.4	1959.74	1957.14	1959.48	6649.0
2014-04-03 21:00:00	ES	Futures	1959.22	1960.0	1958.7	1959.48	4312.0
2014-04-03 22:00:00	ES	Futures	1959.74	1960.0	1958.7	1958.96	2325.0
2014-04-03 23:00:00	ES	Futures	1958.96	1958.96	1958.44	1958.44	1034.0
2014-04-03 00:00:00	NQ	Futures	4258.83	4260.87	4258.54	4260.87	174.0
2014-04-03 01:00:00	NQ	Futures	4260.87	4261.16	4258.25	4258.25	436.0
2014-04-03 02:00:00	NQ	Futures	4258.83	4261.75	4257.67	4260.29	430.0
2014-04-03 03:00:00	NQ	Futures	4259.42	4261.16	4258.25	4260.58	914.0
2014-04-03 04:00:00	NQ	Futures	4260.29	4267.28	4259.71	4263.79	2502.0
2014-04-03 05:00:00	NQ	Futures	4263.79	4266.12	4262.91	4265.82	1047.0
2014-04-03 06:00:00	NQ	Futures	4265.53	4269.61	4264.37	4266.41	1707.0
2014-04-03 07:00:00	NQ	Futures	4266.7	4266.99	4261.16	4261.46	2762.0
2014-04-03 08:00:00	NQ	Futures	4261.46	4264.66	4256.8	4257.67	10364.0
2014-04-03 09:00:00	NQ	Futures	4257.67	4272.81	4254.76	4271.65	38262.0
2014-04-03 10:00:00	NQ	Futures	4271.94	4273.98	4246.02	4256.8	45681.0
2014-04-03 11:00:00	NQ	Futures	4256.5	4257.67	4238.74	4241.07	30754.0
2014-04-03 12:00:00	NQ	Futures	4241.07	4242.82	4218.65	4223.01	34357.0
2014-04-03 13:00:00	NQ	Futures	4223.01	4234.08	4222.14	4227.67	22319.0
2014-04-03 14:00:00	NQ	Futures	4227.38	4227.96	4204.08	4216.32	34941.0
2014-04-03 15:00:00	NQ	Futures	4215.73	4232.33	4214.57	4227.96	36361.0
2014-04-03 16:00:00	NQ	Futures	4227.96	4234.37	4227.38	4234.37	5699.0
2014-04-03 17:00:00	NQ	Futures	4234.37	4236.41	4234.08	4235.83	600.0
2014-04-03 18:00:00	NQ	Futures	4235.54	4236.7	4232.92	4232.92	865.0
2014-04-03 19:00:00	NQ	Futures	4232.92	4235.54	4231.17	4234.37	754.0
2014-04-03 20:00:00	NQ	Futures	4233.79	4238.74	4233.5	4238.45	1049.0
2014-04-03 21:00:00	NQ	Futures	4238.45	4239.91	4237.58	4239.03	438.0
2014-04-03 22:00:00	NQ	Futures	4239.32	4239.91	4237.87	4238.16	426.0
2014-04-03 23:00:00	NQ	Futures	4237.87	4237.87	4236.41	4236.7	205.0
2014-04-03 00:00:00	YM	Futures	16981.4	16985.5	16979.3	16984.4	162.0
2014-04-03 01:00:00	YM	Futures	16984.4	16984.4	16975.2	16975.2	267.0

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

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