PREVIEW / futures_1hour / 2014-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-04.parquet
  size:    47 KB
  rows:    1,533

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-06-04 00:00:00	ES	Futures	1994.02	1995.05	1994.02	1994.79	1479.0
2014-06-04 01:00:00	ES	Futures	1994.53	1994.79	1993.24	1994.02	3273.0
2014-06-04 02:00:00	ES	Futures	1993.76	1995.05	1993.76	1994.02	4827.0
2014-06-04 03:00:00	ES	Futures	1994.27	1996.87	1993.76	1996.35	16730.0
2014-06-04 04:00:00	ES	Futures	1996.35	1996.61	1992.46	1992.72	19221.0
2014-06-04 05:00:00	ES	Futures	1992.98	1993.24	1991.42	1992.72	11820.0
2014-06-04 06:00:00	ES	Futures	1992.46	1994.79	1992.46	1994.27	12235.0
2014-06-04 07:00:00	ES	Futures	1994.53	1994.79	1992.98	1994.02	10687.0
2014-06-04 08:00:00	ES	Futures	1993.76	1994.27	1990.12	1991.68	42687.0
2014-06-04 09:00:00	ES	Futures	1991.42	1995.31	1990.9	1994.79	155665.0
2014-06-04 10:00:00	ES	Futures	1995.05	1998.43	1994.02	1998.17	165023.0
2014-06-04 11:00:00	ES	Futures	1998.17	2000.77	1997.91	1999.47	116080.0
2014-06-04 12:00:00	ES	Futures	1999.47	2001.29	1998.95	2000.77	49803.0
2014-06-04 13:00:00	ES	Futures	2000.77	2001.55	1999.99	2001.03	46286.0
2014-06-04 14:00:00	ES	Futures	2001.03	2001.29	1998.43	1999.73	59474.0
2014-06-04 15:00:00	ES	Futures	1999.47	2001.29	1999.21	2000.25	116608.0
2014-06-04 16:00:00	ES	Futures	1999.99	2001.29	1999.73	2000.77	53217.0
2014-06-04 17:00:00	ES	Futures	2000.77	2001.03	1999.99	1999.99	1523.0
2014-06-04 18:00:00	ES	Futures	1999.99	2000.51	1999.21	1999.73	2134.0
2014-06-04 19:00:00	ES	Futures	1999.73	2000.51	1999.21	2000.25	1227.0
2014-06-04 20:00:00	ES	Futures	1999.99	2000.25	1999.21	1999.73	2488.0
2014-06-04 21:00:00	ES	Futures	1999.73	2000.25	1999.47	2000.25	2738.0
2014-06-04 22:00:00	ES	Futures	2000.25	2000.51	1999.73	1999.99	1004.0
2014-06-04 23:00:00	ES	Futures	1999.99	2000.25	1999.47	1999.73	1023.0
2014-06-04 00:00:00	NQ	Futures	4340.96	4343.0	4340.96	4341.54	183.0
2014-06-04 01:00:00	NQ	Futures	4341.83	4341.83	4339.5	4340.38	436.0
2014-06-04 02:00:00	NQ	Futures	4340.09	4342.71	4340.09	4340.67	463.0
2014-06-04 03:00:00	NQ	Futures	4340.38	4346.78	4339.5	4345.33	2446.0
2014-06-04 04:00:00	NQ	Futures	4345.04	4346.49	4336.3	4337.76	2441.0
2014-06-04 05:00:00	NQ	Futures	4337.76	4338.63	4333.68	4335.72	2531.0
2014-06-04 06:00:00	NQ	Futures	4335.72	4342.12	4335.43	4341.54	2372.0
2014-06-04 07:00:00	NQ	Futures	4341.83	4342.12	4337.46	4339.21	1424.0
2014-06-04 08:00:00	NQ	Futures	4339.21	4340.67	4330.48	4333.1	6137.0
2014-06-04 09:00:00	NQ	Futures	4333.1	4344.45	4326.4	4343.0	39255.0
2014-06-04 10:00:00	NQ	Futures	4343.58	4353.77	4339.79	4353.48	35993.0
2014-06-04 11:00:00	NQ	Futures	4353.48	4359.6	4350.86	4356.39	24364.0
2014-06-04 12:00:00	NQ	Futures	4356.39	4366.59	4355.52	4365.71	18529.0
2014-06-04 13:00:00	NQ	Futures	4365.42	4367.46	4363.09	4366.88	9443.0
2014-06-04 14:00:00	NQ	Futures	4366.88	4367.46	4357.27	4360.47	14357.0
2014-06-04 15:00:00	NQ	Futures	4360.18	4362.22	4356.69	4359.89	20582.0
2014-06-04 16:00:00	NQ	Futures	4359.6	4362.8	4359.6	4361.64	4225.0
2014-06-04 17:00:00	NQ	Futures	4361.34	4362.51	4360.47	4360.76	238.0
2014-06-04 18:00:00	NQ	Futures	4360.76	4361.64	4357.56	4359.31	440.0
2014-06-04 19:00:00	NQ	Futures	4359.6	4359.6	4357.85	4359.02	330.0
2014-06-04 20:00:00	NQ	Futures	4358.72	4359.02	4356.98	4357.56	407.0
2014-06-04 21:00:00	NQ	Futures	4357.27	4359.6	4356.69	4359.6	499.0
2014-06-04 22:00:00	NQ	Futures	4359.31	4360.18	4358.14	4358.43	417.0
2014-06-04 23:00:00	NQ	Futures	4358.72	4359.02	4357.56	4358.14	132.0
2014-06-04 00:00:00	YM	Futures	17193.5	17202.8	17192.5	17197.6	305.0
2014-06-04 01:00:00	YM	Futures	17198.7	17198.7	17189.4	17192.5	652.0

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

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