PREVIEW / futures_1hour / 2014-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-01.parquet
  size:    14 KB
  rows:    266

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-01 18:00:00	ES	Futures	1995.57	1996.61	1994.79	1995.31	5960.0
2014-06-01 19:00:00	ES	Futures	1995.31	1995.57	1994.27	1995.05	2171.0
2014-06-01 20:00:00	ES	Futures	1994.79	1996.35	1994.79	1996.35	4072.0
2014-06-01 21:00:00	ES	Futures	1996.35	1997.13	1996.09	1996.61	5439.0
2014-06-01 22:00:00	ES	Futures	1996.87	1998.17	1996.87	1997.91	3748.0
2014-06-01 23:00:00	ES	Futures	1998.17	1998.69	1997.39	1997.91	2690.0
2014-06-01 18:00:00	NQ	Futures	4350.86	4351.44	4347.37	4349.11	848.0
2014-06-01 19:00:00	NQ	Futures	4349.11	4349.7	4344.75	4346.2	441.0
2014-06-01 20:00:00	NQ	Futures	4345.91	4351.15	4345.91	4351.15	672.0
2014-06-01 21:00:00	NQ	Futures	4351.15	4352.61	4350.86	4351.44	647.0
2014-06-01 22:00:00	NQ	Futures	4351.44	4354.94	4351.44	4354.36	579.0
2014-06-01 23:00:00	NQ	Futures	4354.65	4355.52	4352.61	4354.06	340.0
2014-06-01 18:00:00	YM	Futures	17202.8	17223.4	17200.7	17207.9	885.0
2014-06-01 19:00:00	YM	Futures	17206.9	17210.0	17198.7	17203.8	278.0
2014-06-01 20:00:00	YM	Futures	17203.8	17214.1	17202.8	17214.1	986.0
2014-06-01 21:00:00	YM	Futures	17213.1	17223.4	17213.1	17218.2	1554.0
2014-06-01 22:00:00	YM	Futures	17218.2	17233.7	17218.2	17231.6	748.0
2014-06-01 23:00:00	YM	Futures	17232.6	17236.8	17227.5	17229.6	634.0
2014-06-01 18:00:00	CL	Futures	166.14	166.25	166.01	166.14	861.0
2014-06-01 19:00:00	CL	Futures	166.15	166.38	166.12	166.31	575.0
2014-06-01 20:00:00	CL	Futures	166.31	166.38	166.27	166.31	493.0
2014-06-01 21:00:00	CL	Futures	166.31	166.43	166.3	166.43	522.0
2014-06-01 22:00:00	CL	Futures	166.43	166.54	166.41	166.51	600.0
2014-06-01 23:00:00	CL	Futures	166.51	166.59	166.48	166.57	464.0
2014-06-01 18:00:00	GC	Futures	1712.8	1713.5	1709.4	1709.5	1385.0
2014-06-01 19:00:00	GC	Futures	1709.5	1710.3	1708.3	1708.3	498.0
2014-06-01 20:00:00	GC	Futures	1708.1	1709.4	1707.4	1708.4	1554.0
2014-06-01 21:00:00	GC	Futures	1708.3	1710.3	1707.4	1709.1	1455.0
2014-06-01 22:00:00	GC	Futures	1709.1	1710.2	1708.7	1709.4	899.0
2014-06-01 23:00:00	GC	Futures	1709.2	1709.8	1708.7	1709.0	624.0
2014-06-01 18:00:00	ZN	Futures	118.093686	118.122943	118.079058	118.079058	816.0
2014-06-01 19:00:00	ZN	Futures	118.079058	118.093686	118.06443	118.06443	164.0
2014-06-01 20:00:00	ZN	Futures	118.06443	118.06443	118.020545	118.035173	864.0
2014-06-01 21:00:00	ZN	Futures	118.035173	118.079058	118.035173	118.079058	215.0
2014-06-01 22:00:00	ZN	Futures	118.049802	118.049802	118.035173	118.049802	428.0
2014-06-01 23:00:00	ZN	Futures	118.049802	118.049802	118.049802	118.049802	132.0

> showing 36 of 266 rows — these rows as CSV

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