PREVIEW / futures_1hour / 2014-05-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	1983.63	1984.15	1983.37	1983.89	777.0
2014-05-28 01:00:00	ES	Futures	1983.89	1985.71	1983.63	1985.19	4778.0
2014-05-28 02:00:00	ES	Futures	1985.19	1986.22	1984.15	1984.67	12464.0
2014-05-28 03:00:00	ES	Futures	1984.41	1984.67	1983.11	1983.89	17516.0
2014-05-28 04:00:00	ES	Futures	1983.89	1985.45	1983.37	1984.67	9545.0
2014-05-28 05:00:00	ES	Futures	1984.41	1986.74	1983.89	1986.48	13150.0
2014-05-28 06:00:00	ES	Futures	1986.74	1988.04	1986.48	1986.48	17052.0
2014-05-28 07:00:00	ES	Futures	1986.74	1987.26	1985.71	1986.22	15972.0
2014-05-28 08:00:00	ES	Futures	1985.97	1986.74	1982.07	1982.33	43277.0
2014-05-28 09:00:00	ES	Futures	1982.59	1985.45	1981.29	1982.07	185307.0
2014-05-28 10:00:00	ES	Futures	1981.81	1982.33	1978.18	1981.03	213974.0
2014-05-28 11:00:00	ES	Futures	1981.03	1984.93	1980.77	1983.63	104931.0
2014-05-28 12:00:00	ES	Futures	1983.63	1985.45	1982.07	1983.37	66476.0
2014-05-28 13:00:00	ES	Futures	1983.37	1986.48	1982.85	1985.45	64714.0
2014-05-28 14:00:00	ES	Futures	1985.71	1986.22	1983.11	1984.67	70995.0
2014-05-28 15:00:00	ES	Futures	1984.67	1985.97	1981.03	1981.29	125887.0
2014-05-28 16:00:00	ES	Futures	1981.29	1983.89	1981.03	1983.11	68812.0
2014-05-28 17:00:00	ES	Futures	1983.11	1983.37	1982.85	1983.37	2138.0
2014-05-28 18:00:00	ES	Futures	1983.63	1983.63	1982.33	1982.85	3195.0
2014-05-28 19:00:00	ES	Futures	1982.85	1982.85	1982.07	1982.33	1174.0
2014-05-28 20:00:00	ES	Futures	1982.33	1983.37	1982.33	1983.11	1858.0
2014-05-28 21:00:00	ES	Futures	1982.85	1983.37	1981.81	1982.07	3391.0
2014-05-28 22:00:00	ES	Futures	1982.33	1983.89	1982.07	1983.89	2196.0
2014-05-28 23:00:00	ES	Futures	1983.89	1984.93	1983.63	1984.67	1868.0
2014-05-28 00:00:00	NQ	Futures	4337.76	4338.63	4337.76	4338.34	416.0
2014-05-28 01:00:00	NQ	Futures	4338.34	4343.29	4337.46	4343.29	1248.0
2014-05-28 02:00:00	NQ	Futures	4343.29	4343.87	4339.21	4341.54	1429.0
2014-05-28 03:00:00	NQ	Futures	4341.54	4341.54	4334.84	4335.72	2758.0
2014-05-28 04:00:00	NQ	Futures	4335.72	4340.09	4335.13	4337.76	1350.0
2014-05-28 05:00:00	NQ	Futures	4337.76	4343.0	4336.59	4342.71	1812.0
2014-05-28 06:00:00	NQ	Futures	4343.0	4345.33	4340.96	4341.54	1640.0
2014-05-28 07:00:00	NQ	Futures	4341.25	4343.0	4336.88	4337.76	3249.0
2014-05-28 08:00:00	NQ	Futures	4338.05	4339.21	4330.48	4331.06	6705.0
2014-05-28 09:00:00	NQ	Futures	4331.06	4337.46	4324.07	4328.44	40035.0
2014-05-28 10:00:00	NQ	Futures	4328.44	4332.81	4318.83	4325.82	43001.0
2014-05-28 11:00:00	NQ	Futures	4325.52	4338.92	4324.65	4333.68	24985.0
2014-05-28 12:00:00	NQ	Futures	4333.68	4340.38	4328.44	4332.81	15325.0
2014-05-28 13:00:00	NQ	Futures	4333.1	4340.67	4331.93	4338.05	14488.0
2014-05-28 14:00:00	NQ	Futures	4338.05	4339.21	4327.56	4330.48	16496.0
2014-05-28 15:00:00	NQ	Futures	4330.77	4336.01	4320.86	4321.74	26108.0
2014-05-28 16:00:00	NQ	Futures	4321.74	4330.48	4321.16	4329.31	7432.0
2014-05-28 17:00:00	NQ	Futures	4329.31	4330.77	4328.73	4329.89	122.0
2014-05-28 18:00:00	NQ	Futures	4329.02	4330.18	4326.98	4328.15	232.0
2014-05-28 19:00:00	NQ	Futures	4328.15	4328.44	4325.52	4327.27	386.0
2014-05-28 20:00:00	NQ	Futures	4327.27	4328.73	4326.98	4328.44	174.0
2014-05-28 21:00:00	NQ	Futures	4328.15	4329.02	4325.82	4326.69	491.0
2014-05-28 22:00:00	NQ	Futures	4326.69	4329.31	4326.11	4328.73	599.0
2014-05-28 23:00:00	NQ	Futures	4329.31	4331.64	4329.02	4331.64	403.0
2014-05-28 00:00:00	YM	Futures	17162.6	17165.7	17162.6	17165.7	215.0
2014-05-28 01:00:00	YM	Futures	17164.7	17180.1	17163.6	17179.1	1081.0

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

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