PREVIEW / futures_daily / 2019-04-26

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-26.parquet
  size:    10 KB
  rows:    115

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
2019-04-26	ES	Futures	3158.16	3178.69	3151.14	3177.33	1246988.0
2019-04-26	NQ	Futures	8986.33	9039.62	8935.92	9033.57	467051.0
2019-04-26	YM	Futures	27882.5	28003.9	27809.7	27990.2	168330.0
2019-04-26	CL	Futures	66.87	66.92	63.94	64.99	1000836.0
2019-04-26	GC	Futures	1592.0	1606.7	1588.1	1604.1	278887.0
2019-04-26	ZN	Futures	122.715275	123.072683	122.606499	122.994986	1492354.0
2019-04-26	A6	Futures	0.72374	0.72879	0.72322	0.72652	100316.0
2019-04-26	AD	Futures	0.75064	0.75246	0.74983	0.7519	81962.0
2019-04-26	B	Futures	54.2	54.27	52.02	52.78	480792.0
2019-04-26	B6	Futures	1.324	1.3294	1.3223	1.3274	94628.0
2019-04-26	BFX	Futures	4369.2	4369.2	4324.1	4324.1	4.0
2019-04-26	BR	Futures	0.2018	0.20352	0.20096	0.20308	20415.0
2019-04-26	BTC	Futures	8351.0	8351.0	7624.2	7856.2	8655.0
2019-04-26	BZ	Futures	54.11	54.12	51.87	52.64	48946.0
2019-04-26	C	Futures	1636.0	1672.0	1618.0	1669.0	4770.0
2019-04-26	CB	Futures	278.125	279.321	278.125	279.321	11.0
2019-04-26	CC	Futures	1534.0	1577.0	1524.0	1572.0	22016.0
2019-04-26	CNH	Futures	6.7577	6.7594	6.739	6.747	591.0
2019-04-26	CSC	Futures	2.98	3.006	2.973	2.989	142.0
2019-04-26	CT	Futures	82.11	82.11	80.88	81.33	13746.0
2019-04-26	DC	Futures	24.97	25.26	24.92	25.1	474.0
2019-04-26	DX	Futures	93.82	94.016	93.513	93.672	14694.0
2019-04-26	E1	Futures	1.14905	1.15116	1.1452	1.15046	24549.0
2019-04-26	E6	Futures	1.22707	1.23163	1.22444	1.22932	254031.0
2019-04-26	E7	Futures	1.2211	1.2254	1.2184	1.2232	5864.0
2019-04-26	EBM	Futures	192.63	194.48	192.37	194.22	12649.0
2019-04-26	ED	Futures	95.155	95.1697	95.1453	95.155	198332.0
2019-04-26	ER	Futures	98.416	98.421	98.411	98.416	28046.0
2019-04-26	EW	Futures	2075.0	2099.0	2071.0	2097.0	9797.0
2019-04-26	FBON	Futures	135.37	135.96	135.21	135.88	519.0
2019-04-26	FBTP	Futures	114.61	115.78	114.51	115.54	80495.0
2019-04-26	FBTS	Futures	105.627	105.827	105.608	105.808	49039.0
2019-04-26	FCE	Futures	4967.7	4977.6	4951.5	4972.2	58213.0
2019-04-26	FDAX	Futures	12938.0	13000.1	12921.1	12994.3	84118.0
2019-04-26	FDIV	Futures	149.29	150.31	149.15	150.31	82.0
2019-04-26	FDXM	Futures	12830.0	12887.4	12809.2	12881.7	33278.0
2019-04-26	FESX	Futures	2992.5	3005.6	2987.2	3002.1	647738.0
2019-04-26	FGBL	Futures	159.99	160.14	159.78	160.04	503350.0
2019-04-26	FGBM	Futures	133.09	133.14	133.02	133.11	332943.0
2019-04-26	FGBS	Futures	112.769	112.794	112.769	112.784	218432.0
2019-04-26	FGBX	Futures	193.71	194.35	193.34	194.06	24997.0
2019-04-26	FMWO	Futures	7255.4	7290.2	7254.3	7285.5	630.0
2019-04-26	FOAT	Futures	146.66	146.9	146.59	146.87	86586.0
2019-04-26	FTDX	Futures	2841.4	2858.7	2841.4	2858.2	79.0
2019-04-26	FTI	Futures	533.38	535.38	531.96	534.28	21085.0
2019-04-26	FTUK	Futures	6776.5	6786.6	6741.7	6766.0	71833.0
2019-04-26	FVSA	Futures	199.7	201.79	196.2	197.6	19842.0
2019-04-26	FXXP	Futures	345.2	346.2	344.1	345.7	38322.0
2019-04-26	G	Futures	117.7	117.96	117.56	117.81	144153.0
2019-04-26	GF	Futures	298.759	302.818	297.666	299.696	2665.0

> showing 50 of 115 rows — these rows as CSV

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