PREVIEW / futures_1hour / 2014-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-06.parquet
  size:    12 KB
  rows:    232

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-07-06 18:00:00	ES	Futures	2059.63	2060.94	2059.37	2060.41	1802.0
2014-07-06 19:00:00	ES	Futures	2060.15	2060.94	2059.89	2060.94	1639.0
2014-07-06 20:00:00	ES	Futures	2060.67	2061.46	2060.41	2061.2	2705.0
2014-07-06 21:00:00	ES	Futures	2061.2	2061.46	2060.67	2060.94	1422.0
2014-07-06 22:00:00	ES	Futures	2060.94	2060.94	2059.37	2059.63	1746.0
2014-07-06 23:00:00	ES	Futures	2059.63	2059.89	2059.11	2059.89	1384.0
2014-07-06 18:00:00	NQ	Futures	4570.32	4572.95	4570.32	4571.49	372.0
2014-07-06 19:00:00	NQ	Futures	4571.78	4572.66	4571.49	4572.37	147.0
2014-07-06 20:00:00	NQ	Futures	4572.37	4573.24	4571.78	4573.24	235.0
2014-07-06 21:00:00	NQ	Futures	4573.24	4573.24	4572.37	4572.66	188.0
2014-07-06 22:00:00	NQ	Futures	4572.37	4572.37	4570.32	4570.61	419.0
2014-07-06 23:00:00	NQ	Futures	4570.32	4571.2	4569.74	4571.2	288.0
2014-07-06 18:00:00	YM	Futures	17553.5	17563.8	17552.5	17560.7	298.0
2014-07-06 19:00:00	YM	Futures	17560.7	17562.8	17558.7	17561.8	77.0
2014-07-06 20:00:00	YM	Futures	17561.8	17563.8	17559.7	17561.8	394.0
2014-07-06 21:00:00	YM	Futures	17561.8	17561.8	17555.6	17557.6	270.0
2014-07-06 22:00:00	YM	Futures	17558.7	17558.7	17550.4	17550.4	444.0
2014-07-06 23:00:00	YM	Futures	17550.4	17553.5	17547.3	17553.5	180.0
2014-07-06 18:00:00	CL	Futures	168.76	168.95	168.67	168.82	423.0
2014-07-06 19:00:00	CL	Futures	168.82	168.9	168.74	168.77	387.0
2014-07-06 20:00:00	CL	Futures	168.79	168.82	168.76	168.8	97.0
2014-07-06 21:00:00	CL	Futures	168.8	169.23	168.77	169.21	1026.0
2014-07-06 22:00:00	CL	Futures	169.19	169.31	169.08	169.1	982.0
2014-07-06 23:00:00	CL	Futures	169.1	169.24	169.06	169.11	522.0
2014-07-06 18:00:00	GC	Futures	1809.9	1810.3	1803.6	1806.6	1807.0
2014-07-06 19:00:00	GC	Futures	1806.6	1807.0	1805.2	1805.9	275.0
2014-07-06 20:00:00	GC	Futures	1805.9	1808.1	1805.4	1805.9	760.0
2014-07-06 21:00:00	GC	Futures	1805.9	1806.6	1802.8	1804.6	3014.0
2014-07-06 22:00:00	GC	Futures	1804.4	1805.1	1803.7	1804.4	1408.0
2014-07-06 23:00:00	GC	Futures	1804.4	1805.1	1804.1	1804.6	602.0
2014-07-06 18:00:00	ZN	Futures	117.141889	117.156624	117.038745	117.05348	4923.0
2014-07-06 19:00:00	ZN	Futures	117.05348	117.068215	117.02401	117.02401	3160.0
2014-07-06 20:00:00	ZN	Futures	117.038745	117.05348	116.994541	117.009276	8530.0
2014-07-06 21:00:00	ZN	Futures	117.009276	117.02401	116.994541	116.994541	4877.0
2014-07-06 22:00:00	ZN	Futures	116.994541	117.02401	116.994541	117.02401	1982.0
2014-07-06 23:00:00	ZN	Futures	117.009276	117.02401	117.009276	117.02401	2389.0

> showing 36 of 232 rows — these rows as CSV

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