PREVIEW / futures_1hour / 2013-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-09.parquet
  size:    14 KB
  rows:    253

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
2013-06-09 18:00:00	ES	Futures	1686.15	1687.43	1684.09	1685.63	10251.0
2013-06-09 19:00:00	ES	Futures	1685.63	1688.21	1685.37	1687.69	4234.0
2013-06-09 20:00:00	ES	Futures	1687.69	1689.24	1687.18	1687.69	7163.0
2013-06-09 21:00:00	ES	Futures	1687.95	1690.53	1687.43	1690.01	6736.0
2013-06-09 22:00:00	ES	Futures	1690.27	1691.3	1689.24	1689.75	4483.0
2013-06-09 23:00:00	ES	Futures	1689.5	1691.3	1689.5	1690.53	2572.0
2013-06-09 18:00:00	NQ	Futures	3477.85	3477.85	3472.31	3475.81	804.0
2013-06-09 19:00:00	NQ	Futures	3475.81	3479.6	3475.81	3479.02	524.0
2013-06-09 20:00:00	NQ	Futures	3479.02	3481.35	3478.14	3479.89	712.0
2013-06-09 21:00:00	NQ	Futures	3479.89	3484.85	3479.31	3484.56	971.0
2013-06-09 22:00:00	NQ	Futures	3484.85	3487.47	3484.27	3484.85	792.0
2013-06-09 23:00:00	NQ	Futures	3484.85	3486.89	3484.27	3484.85	404.0
2013-06-09 18:00:00	YM	Futures	15360.3	15364.3	15344.1	15360.3	773.0
2013-06-09 19:00:00	YM	Futures	15359.3	15375.5	15359.3	15373.4	606.0
2013-06-09 20:00:00	YM	Futures	15373.4	15383.6	15369.4	15373.4	807.0
2013-06-09 21:00:00	YM	Futures	15374.5	15393.7	15370.4	15389.6	769.0
2013-06-09 22:00:00	YM	Futures	15389.6	15399.7	15386.6	15389.6	703.0
2013-06-09 23:00:00	YM	Futures	15389.6	15400.7	15389.6	15392.6	369.0
2013-06-09 18:00:00	CL	Futures	150.55	150.75	150.47	150.71	773.0
2013-06-09 19:00:00	CL	Futures	150.72	150.8	150.69	150.77	281.0
2013-06-09 20:00:00	CL	Futures	150.74	150.77	150.46	150.53	864.0
2013-06-09 21:00:00	CL	Futures	150.53	150.67	150.52	150.64	720.0
2013-06-09 22:00:00	CL	Futures	150.63	150.75	150.58	150.71	572.0
2013-06-09 23:00:00	CL	Futures	150.72	150.75	150.6	150.61	293.0
2013-06-09 18:00:00	GC	Futures	1896.8	1897.9	1889.1	1895.1	2959.0
2013-06-09 19:00:00	GC	Futures	1895.1	1903.2	1894.7	1897.7	1826.0
2013-06-09 20:00:00	GC	Futures	1897.7	1901.2	1897.7	1899.5	1535.0
2013-06-09 21:00:00	GC	Futures	1899.5	1900.9	1898.1	1900.6	962.0
2013-06-09 22:00:00	GC	Futures	1900.7	1902.8	1899.6	1901.4	1705.0
2013-06-09 23:00:00	GC	Futures	1901.2	1901.8	1899.2	1901.2	848.0
2013-06-09 18:00:00	ZN	Futures	116.830567	116.844718	116.73151	116.745661	6487.0
2013-06-09 19:00:00	ZN	Futures	116.73151	116.788114	116.73151	116.773963	7763.0
2013-06-09 20:00:00	ZN	Futures	116.773963	116.929624	116.745661	116.929624	16120.0
2013-06-09 21:00:00	ZN	Futures	116.929624	116.943775	116.901322	116.915473	11724.0
2013-06-09 22:00:00	ZN	Futures	116.929624	116.972077	116.915473	116.915473	7498.0
2013-06-09 23:00:00	ZN	Futures	116.915473	116.915473	116.830567	116.844718	5590.0

> showing 36 of 253 rows — these rows as CSV

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