PREVIEW / futures_daily / 2017-09-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-29.parquet
  size:    9 KB
  rows:    110

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
2017-09-29	ES	Futures	2727.66	2738.54	2724.4	2736.64	1368322.0
2017-09-29	NQ	Futures	6976.31	7030.64	6968.97	7027.11	275661.0
2017-09-29	YM	Futures	23568.7	23602.5	23528.6	23597.3	82473.0
2017-09-29	CL	Futures	52.27	52.46	51.93	52.36	551982.0
2017-09-29	GC	Futures	1641.5	1645.5	1626.4	1634.8	287446.0
2017-09-29	ZN	Futures	123.763248	123.855677	123.439744	123.547578	1811508.0
2017-09-29	A6	Futures	0.80718	0.80739	0.80358	0.80626	95113.0
2017-09-29	AD	Futures	0.81869	0.81976	0.81223	0.81656	75945.0
2017-09-29	B	Futures	40.46	40.56	39.86	40.11	343513.0
2017-09-29	B6	Futures	1.4045	1.4045	1.395	1.4012	133164.0
2017-09-29	BFX	Futures	4755.9	4776.7	4755.9	4776.7	1.0
2017-09-29	BR	Futures	0.23649	0.23664	0.23637	0.23653	1342.0
2017-09-29	BZ	Futures	40.09	40.23	39.54	39.78	27369.0
2017-09-29	C	Futures	1446.0	1485.0	1442.0	1483.0	13449.0
2017-09-29	CB	Futures	303.595	303.595	298.494	299.186	71.0
2017-09-29	CC	Futures	1467.0	1527.0	1461.0	1517.0	26899.0
2017-09-29	CNH	Futures	6.8542	6.8542	6.8455	6.8497	6.0
2017-09-29	CSC	Futures	3.458	3.495	3.458	3.468	15.0
2017-09-29	CT	Futures	81.1	81.3	80.2	80.4	8931.0
2017-09-29	DC	Futures	28.53	28.58	28.3	28.39	174.0
2017-09-29	DX	Futures	86.97	87.077	86.787	86.86	21906.0
2017-09-29	E1	Futures	1.26648	1.27064	1.26404	1.26893	25359.0
2017-09-29	E6	Futures	1.35024	1.35572	1.34882	1.35378	216250.0
2017-09-29	E7	Futures	1.3428	1.3487	1.3419	1.3467	4158.0
2017-09-29	EBM	Futures	179.09	180.17	178.82	179.09	20121.0
2017-09-29	ED	Futures	95.523	95.5279	95.5085	95.523	244715.0
2017-09-29	ER	Futures	98.337	98.342	98.337	98.342	19754.0
2017-09-29	EW	Futures	1906.3	1912.9	1904.7	1908.7	15511.0
2017-09-29	FBON	Futures	124.74	124.97	124.59	124.84	792.0
2017-09-29	FBTP	Futures	108.74	109.08	108.57	108.72	92631.0
2017-09-29	FBTS	Futures	103.246	103.301	103.237	103.283	35435.0
2017-09-29	FCE	Futures	4740.1	4773.3	4731.2	4772.4	64755.0
2017-09-29	FDAX	Futures	13363.8	13495.2	13359.0	13451.0	65776.0
2017-09-29	FDIV	Futures	149.12	150.13	149.12	150.13	15.0
2017-09-29	FDXM	Futures	13248.9	13380.2	13245.8	13337.5	19271.0
2017-09-29	FESX	Futures	2901.8	2924.6	2895.2	2917.3	887148.0
2017-09-29	FEU3	Futures	99.011	99.011	99.006	99.006	9.0
2017-09-29	FGBL	Futures	148.81	149.15	148.67	148.87	739864.0
2017-09-29	FGBM	Futures	129.51	129.63	129.45	129.51	530408.0
2017-09-29	FGBS	Futures	112.432	112.442	112.392	112.407	289636.0
2017-09-29	FGBX	Futures	166.01	166.99	165.66	166.62	53087.0
2017-09-29	FMWO	Futures	6625.8	6651.8	6625.8	6645.9	386.0
2017-09-29	FOAT	Futures	135.99	136.29	135.83	136.06	108863.0
2017-09-29	FTDX	Futures	2425.6	2427.1	2419.6	2427.1	87.0
2017-09-29	FTI	Futures	491.57	495.07	491.52	494.56	21319.0
2017-09-29	FTUK	Futures	6317.1	6370.9	6315.8	6360.5	105630.0
2017-09-29	FVSA	Futures	400.14	407.23	391.62	395.88	24442.0
2017-09-29	FXXP	Futures	327.6	329.4	326.7	328.3	21819.0
2017-09-29	G	Futures	113.25	113.55	113.14	113.39	235438.0
2017-09-29	GF	Futures	334.197	335.016	331.196	332.233	3079.0

> showing 50 of 110 rows — these rows as CSV

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