PREVIEW / futures_daily / 2018-05-04

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-04.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
2018-05-04	ES	Futures	2861.94	2903.0	2840.74	2895.93	1699202.0
2018-05-04	NQ	Futures	7802.69	7945.49	7737.15	7929.39	408713.0
2018-05-04	YM	Futures	25180.5	25576.6	24987.7	25521.8	233196.0
2018-05-04	CL	Futures	68.75	70.23	68.37	69.98	690876.0
2018-05-04	GC	Futures	1676.0	1681.3	1670.5	1678.4	308476.0
2018-05-04	ZN	Futures	118.795739	119.090402	118.67167	118.811248	1337672.0
2018-05-04	A6	Futures	0.77458	0.77746	0.77046	0.77489	130152.0
2018-05-04	AD	Futures	0.78804	0.78879	0.78384	0.78758	73007.0
2018-05-04	B	Futures	54.04	55.02	53.67	54.87	289860.0
2018-05-04	B6	Futures	1.4083	1.4095	1.3993	1.4051	116796.0
2018-05-04	BR	Futures	0.21561	0.21618	0.21416	0.2158	2261.0
2018-05-04	BTC	Futures	13635.6	13818.1	13396.8	13579.4	3762.0
2018-05-04	BZ	Futures	53.5	54.44	53.13	54.3	30457.0
2018-05-04	C	Futures	1774.0	1776.0	1751.0	1759.0	4916.0
2018-05-04	CB	Futures	296.504	296.813	294.034	295.269	51.0
2018-05-04	CC	Futures	2071.0	2071.0	2016.0	2025.0	15768.0
2018-05-04	CNH	Futures	6.4443	6.4552	6.4443	6.4552	10.0
2018-05-04	CSC	Futures	3.457	3.461	3.452	3.452	8.0
2018-05-04	CT	Futures	96.11	98.97	95.51	98.78	22647.0
2018-05-04	DC	Futures	27.87	27.91	27.82	27.85	92.0
2018-05-04	DX	Futures	87.023	87.48	86.947	87.153	25441.0
2018-05-04	E1	Futures	1.21128	1.21273	1.20574	1.20779	32079.0
2018-05-04	E6	Futures	1.35421	1.35534	1.34565	1.35168	268952.0
2018-05-04	E7	Futures	1.347	1.348	1.3386	1.3445	4545.0
2018-05-04	EBM	Futures	184.72	184.99	181.23	182.03	5447.0
2018-05-04	ED	Futures	94.9403	94.9452	94.916	94.9208	336854.0
2018-05-04	ER	Futures	98.342	98.347	98.342	98.342	18077.0
2018-05-04	EW	Futures	1987.9	2018.7	1971.2	2009.7	12531.0
2018-05-04	FBON	Futures	129.81	129.99	129.37	129.45	390.0
2018-05-04	FBTP	Futures	116.24	116.55	115.65	115.7	92927.0
2018-05-04	FBTS	Futures	104.333	104.352	104.269	104.278	70916.0
2018-05-04	FCE	Futures	4896.2	4909.1	4872.1	4898.9	59879.0
2018-05-04	FDAX	Futures	13270.7	13364.7	13215.1	13328.4	87988.0
2018-05-04	FDXM	Futures	13154.1	13245.7	13096.4	13209.7	27608.0
2018-05-04	FESX	Futures	2906.4	2923.9	2893.1	2913.1	824847.0
2018-05-04	FGBL	Futures	149.76	149.99	149.67	149.7	627363.0
2018-05-04	FGBM	Futures	129.73	129.79	129.65	129.67	356861.0
2018-05-04	FGBS	Futures	112.522	112.542	112.502	112.512	224550.0
2018-05-04	FGBX	Futures	169.6	170.22	169.48	169.54	41226.0
2018-05-04	FMWO	Futures	6882.6	6942.1	6851.0	6923.4	890.0
2018-05-04	FOAT	Futures	138.8	139.02	138.69	138.73	95222.0
2018-05-04	FTDX	Futures	2680.0	2690.4	2658.7	2668.1	144.0
2018-05-04	FTI	Futures	509.24	512.61	508.08	511.13	20767.0
2018-05-04	FTUK	Futures	6628.9	6666.1	6603.8	6647.5	105906.0
2018-05-04	FVSA	Futures	340.97	346.71	331.79	334.09	22154.0
2018-05-04	FXXP	Futures	330.9	332.3	329.6	331.4	35258.0
2018-05-04	G	Futures	114.1	114.42	113.99	114.07	193822.0
2018-05-04	GF	Futures	303.432	304.078	301.28	302.141	1053.0
2018-05-04	GSCI	Futures	535.58	540.37	534.91	540.03	78.0
2018-05-04	HE	Futures	77.304	77.803	76.437	77.251	18893.0

> showing 50 of 110 rows — these rows as CSV

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