PREVIEW / futures_daily / 2012-09-28

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-28.parquet
  size:    9 KB
  rows:    100

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
2012-09-28	ES	Futures	1466.63	1469.17	1454.41	1459.76	2101935.0
2012-09-28	NQ	Futures	3238.4	3243.86	3208.77	3212.51	242772.0
2012-09-28	YM	Futures	13096.7	13117.2	12980.5	13041.0	146311.0
2012-09-28	CL	Futures	166.68	167.32	164.96	166.39	210195.0
2012-09-28	GC	Futures	2376.5	2384.4	2362.5	2368.4	156934.0
2012-09-28	ZN	Futures	117.274512	117.645329	117.219576	117.329447	983347.0
2012-09-28	A6	Futures	0.94298	0.94562	0.9358	0.93626	128345.0
2012-09-28	AD	Futures	1.02195	1.02426	1.01693	1.01864	93319.0
2012-09-28	B	Futures	102.34	103.08	101.44	102.25	138164.0
2012-09-28	B6	Futures	1.6951	1.6991	1.6824	1.6853	157291.0
2012-09-28	BFX	Futures	2865.7	2865.7	2854.0	2854.0	13.0
2012-09-28	BR	Futures	0.23721	0.23862	0.23719	0.23777	201.0
2012-09-28	BZ	Futures	106.43	106.43	105.31	106.11	2551.0
2012-09-28	C	Futures	1646.0	1671.0	1639.0	1653.0	6712.0
2012-09-28	CB	Futures	97.907	97.907	97.412	97.907	8.0
2012-09-28	CC	Futures	1882.0	1957.0	1880.0	1897.0	17730.0
2012-09-28	CSC	Futures	4.017	4.046	4.011	4.046	12.0
2012-09-28	CT	Futures	92.14	93.15	91.08	91.17	15572.0
2012-09-28	DC	Futures	30.19	30.42	30.15	30.31	102.0
2012-09-28	DX	Futures	77.126	77.576	76.927	77.513	22453.0
2012-09-28	E1	Futures	1.37544	1.38059	1.369	1.37068	40303.0
2012-09-28	E6	Futures	1.52191	1.52744	1.51307	1.5146	305925.0
2012-09-28	E7	Futures	1.5127	1.5183	1.5039	1.5055	5670.0
2012-09-28	ED	Futures	95.2062	95.2349	95.2062	95.2253	251648.0
2012-09-28	ER	Futures	97.866	97.886	97.866	97.876	106498.0
2012-09-28	EW	Futures	1008.0	1009.6	999.8	1005.8	26700.0
2012-09-28	FBTP	Futures	70.87	71.03	70.43	70.87	17272.0
2012-09-28	FBTS	Futures	89.123	89.198	88.88	89.106	2177.0
2012-09-28	FCE	Futures	2592.8	2594.3	2506.0	2507.9	154191.0
2012-09-28	FDAX	Futures	8049.6	8057.2	7909.9	7930.1	136749.0
2012-09-28	FESX	Futures	1715.8	1717.8	1664.7	1670.9	1403904.0
2012-09-28	FEU3	Futures	98.497	98.497	98.497	98.497	2.0
2012-09-28	FGBL	Futures	118.23	118.64	118.14	118.49	640633.0
2012-09-28	FGBM	Futures	116.14	116.35	116.09	116.27	409125.0
2012-09-28	FGBS	Futures	110.343	110.387	110.328	110.377	316463.0
2012-09-28	FGBX	Futures	125.68	126.76	125.55	126.31	7475.0
2012-09-28	FOAT	Futures	102.8	103.13	102.77	103.11	24227.0
2012-09-28	FTDX	Futures	763.6	763.6	758.9	759.9	57.0
2012-09-28	FTI	Futures	281.99	282.33	275.55	276.58	34978.0
2012-09-28	FTUK	Futures	4226.7	4244.2	4179.5	4180.6	116838.0
2012-09-28	FVSA	Futures	5633.48	5829.01	5474.62	5755.69	4303.0
2012-09-28	FXXP	Futures	196.0	196.2	193.0	193.0	2890.0
2012-09-28	G	Futures	99.51	99.83	99.36	99.61	150536.0
2012-09-28	GF	Futures	284.376	284.376	278.828	279.947	3254.0
2012-09-28	GSCI	Futures	1066.47	1075.17	1066.47	1071.31	498.0
2012-09-28	HE	Futures	91.701	93.006	91.235	91.67	21375.0
2012-09-28	HG	Futures	4.8146	4.8538	4.8049	4.8294	44997.0
2012-09-28	HH	Futures	41.722	42.334	41.429	42.334	1090.0
2012-09-28	HO	Futures	2.5498	2.5602	2.5313	2.5479	29379.0
2012-09-28	HRC	Futures	2443.1	2443.1	2443.1	2443.1	0.0

> showing 50 of 100 rows — these rows as CSV

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