PREVIEW / futures_daily / 2012-09-19

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-19.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-19	ES	Futures	1479.09	1485.2	1477.06	1479.09	1658342.0
2012-09-19	NQ	Futures	3281.83	3297.94	3273.2	3283.27	219652.0
2012-09-19	YM	Futures	13184.6	13238.3	13169.0	13179.7	104698.0
2012-09-19	CL	Futures	172.96	174.17	165.23	166.58	378443.0
2012-09-19	GC	Futures	2367.7	2378.9	2355.4	2365.5	162962.0
2012-09-19	ZN	Futures	116.203261	116.519142	116.079655	116.354334	868748.0
2012-09-19	A6	Futures	0.94253	0.94643	0.93935	0.94634	114548.0
2012-09-19	AD	Futures	1.02787	1.02998	1.02597	1.02807	68611.0
2012-09-19	B	Futures	101.86	103.02	97.93	98.65	298801.0
2012-09-19	B6	Futures	1.6956	1.6988	1.6897	1.6944	94247.0
2012-09-19	BFX	Futures	2932.5	2934.4	2912.6	2921.8	343.0
2012-09-19	BR	Futures	0.2374	0.23762	0.2374	0.23762	62.0
2012-09-19	BZ	Futures	106.08	106.08	102.67	103.39	559.0
2012-09-19	C	Futures	1662.0	1671.0	1651.0	1664.0	5313.0
2012-09-19	CB	Futures	98.483	98.483	97.947	98.483	6.0
2012-09-19	CC	Futures	1929.0	1933.0	1903.0	1914.0	9583.0
2012-09-19	CSC	Futures	4.17	4.17	4.141	4.141	3.0
2012-09-19	CT	Futures	98.48	99.46	97.74	98.64	120.0
2012-09-19	DC	Futures	30.97	31.14	30.8	31.14	244.0
2012-09-19	DX	Futures	76.782	76.99	76.588	76.643	19022.0
2012-09-19	E1	Futures	1.38767	1.39217	1.38496	1.3896	28846.0
2012-09-19	E6	Futures	1.53745	1.54228	1.53133	1.53957	264759.0
2012-09-19	E7	Futures	1.5285	1.5331	1.5222	1.5304	4568.0
2012-09-19	ED	Futures	95.2157	95.2205	95.211	95.211	100545.0
2012-09-19	ER	Futures	97.852	97.876	97.847	97.871	139090.0
2012-09-19	EW	Futures	1028.1	1032.0	1025.2	1029.2	22247.0
2012-09-19	FBTP	Futures	71.1	71.93	71.06	71.71	20930.0
2012-09-19	FBTS	Futures	89.139	89.5	89.114	89.466	2430.0
2012-09-19	FCE	Futures	2639.1	2639.1	2610.7	2632.4	140777.0
2012-09-19	FDAX	Futures	8104.9	8114.2	8030.4	8103.2	94761.0
2012-09-19	FESX	Futures	1742.3	1745.0	1724.6	1740.3	1128574.0
2012-09-19	FEU3	Futures	98.487	98.492	98.487	98.492	24.0
2012-09-19	FGBL	Futures	116.24	116.96	116.2	116.76	708784.0
2012-09-19	FGBM	Futures	115.34	115.71	115.32	115.61	403297.0
2012-09-19	FGBS	Futures	110.238	110.313	110.218	110.288	337485.0
2012-09-19	FGBX	Futures	121.51	122.5	121.32	122.08	4261.0
2012-09-19	FOAT	Futures	102.03	102.36	102.02	102.27	23997.0
2012-09-19	FTDX	Futures	759.9	766.9	759.9	766.0	2094.0
2012-09-19	FTI	Futures	286.81	287.92	285.45	286.56	33270.0
2012-09-19	FTUK	Futures	4273.1	4298.0	4268.4	4294.0	107987.0
2012-09-19	FVSA	Futures	5706.8	5743.47	5511.28	5511.28	4367.0
2012-09-19	FXXP	Futures	198.1	198.1	197.0	197.7	24875.0
2012-09-19	G	Futures	98.03	98.61	97.89	98.46	176242.0
2012-09-19	GF	Futures	286.761	286.761	283.938	286.177	1842.0
2012-09-19	GSCI	Futures	1080.17	1080.17	1053.01	1055.99	220.0
2012-09-19	HE	Futures	91.577	93.131	91.049	92.882	18783.0
2012-09-19	HG	Futures	4.8705	4.9341	4.8615	4.9013	47614.0
2012-09-19	HH	Futures	37.589	38.205	37.026	37.026	307.0
2012-09-19	HO	Futures	2.5328	2.5511	2.4478	2.4612	24586.0
2012-09-19	HRC	Futures	2471.7	2471.7	2471.7	2471.7	250.0

> showing 50 of 100 rows — these rows as CSV

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