PREVIEW / futures_daily / 2014-04-21

all futures daily files

  file:    by_date/futures_daily/2014/2014-04-21.parquet
  size:    8 KB
  rows:    80

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2014-04-21	ES	Futures	1923.65	1930.12	1920.8	1929.08	533891.0
2014-04-21	NQ	Futures	4057.64	4091.31	4048.15	4087.86	152229.0
2014-04-21	YM	Futures	16413.0	16459.2	16401.0	16438.1	49857.0
2014-04-21	CL	Futures	187.83	188.06	186.49	187.74	186464.0
2014-04-21	GC	Futures	1706.2	1716.2	1688.9	1697.7	101889.0
2014-04-21	ZN	Futures	114.707429	114.924733	114.577047	114.721916	433570.0
2014-04-21	A6	Futures	0.89308	0.89452	0.89155	0.89299	26109.0
2014-04-21	AD	Futures	0.91856	0.91988	0.91785	0.91917	17429.0
2014-04-21	B	Futures	113.35	113.65	112.46	113.55	71867.0
2014-04-21	B6	Futures	1.7654	1.767	1.7632	1.765	19257.0
2014-04-21	BR	Futures	0.2336	0.2336	0.23176	0.23289	6.0
2014-04-21	BZ	Futures	115.29	115.83	114.63	115.73	3084.0
2014-04-21	CB	Futures	93.669	93.669	93.415	93.415	13.0
2014-04-21	CC	Futures	2217.0	2224.0	2209.0	2215.0	2580.0
2014-04-21	CNH	Futures	7.1513	7.1545	7.1502	7.1502	24.0
2014-04-21	CSC	Futures	4.419	4.421	4.33	4.341	54.0
2014-04-21	CT	Futures	101.49	102.06	100.43	100.81	4034.0
2014-04-21	DC	Futures	35.44	35.51	34.56	34.66	236.0
2014-04-21	DX	Futures	75.945	76.059	75.874	76.031	7594.0
2014-04-21	E1	Futures	1.45406	1.45573	1.45034	1.45124	8433.0
2014-04-21	E6	Futures	1.63115	1.63257	1.62738	1.62844	41121.0
2014-04-21	E7	Futures	1.6198	1.6217	1.6166	1.6176	1090.0
2014-04-21	ED	Futures	95.4043	95.4138	95.4043	95.4091	37437.0
2014-04-21	EW	Futures	1388.9	1396.5	1387.0	1395.0	9523.0
2014-04-21	GF	Futures	283.932	283.932	282.221	283.455	1661.0
2014-04-21	GSCI	Futures	1093.51	1095.99	1092.43	1094.83	22.0
2014-04-21	HE	Futures	143.363	143.451	140.563	140.913	544.0
2014-04-21	HG	Futures	3.8589	3.8877	3.8576	3.8698	8014.0
2014-04-21	HH	Futures	60.351	60.351	59.326	59.453	3588.0
2014-04-21	HO	Futures	2.3947	2.3992	2.378	2.3941	23667.0
2014-04-21	HRC	Futures	2412.7	2412.7	2412.7	2412.7	0.0
2014-04-21	J1	Futures	0.0122656	0.0122707	0.0122317	0.0122405	42260.0
2014-04-21	J7	Futures	0.012249	0.012256	0.012219	0.012227	309.0
2014-04-21	JB	Futures	130.28	130.31	130.23	130.23	663.0
2014-04-21	KC	Futures	370.27	373.36	359.39	361.21	10629.0
2014-04-21	KE	Futures	2495.98	2495.98	2399.79	2413.77	10192.0
2014-04-21	LBS	Futures	528.1	545.4	527.5	544.9	735.0
2014-04-21	LE	Futures	167.207	167.83	166.74	167.518	10859.0
2014-04-21	MFS	Futures	1811.5	1814.9	1807.8	1814.1	1976.0
2014-04-21	MGC	Futures	1676.3	1685.4	1658.4	1666.7	825.0
2014-04-21	MME	Futures	958.6	958.8	952.7	955.2	8342.0
2014-04-21	MP	Futures	0.0461	0.04622	0.04599	0.04619	9428.0
2014-04-21	N6	Futures	0.75577	0.7587	0.75453	0.75489	4052.0
2014-04-21	NG	Futures	81.999	82.568	80.809	80.982	84798.0
2014-04-21	NIY	Futures	12091.5	12225.0	12083.2	12145.7	11046.0
2014-04-21	NKD	Futures	13408.7	13565.7	13399.5	13464.1	6666.0
2014-04-21	NOK	Futures	0.171056	0.171056	0.171056	0.171056	109.0
2014-04-21	OJ	Futures	141.61	141.61	139.85	140.49	1167.0
2014-04-21	PA	Futures	857.92	865.36	827.49	839.25	5682.0
2014-04-21	PJY	Futures	141.67	141.86	141.67	141.83	39.0

> showing 50 of 80 rows — these rows as CSV

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