PREVIEW / futures_daily / 2018-07-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-02.parquet
  size:    10 KB
  rows:    113

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-07-02	ES	Futures	2955.27	2963.42	2930.83	2962.06	1213215.0
2018-07-02	NQ	Futures	8240.89	8300.93	8146.74	8297.14	379570.0
2018-07-02	YM	Futures	25577.3	25630.0	25316.0	25590.0	199515.0
2018-07-02	CL	Futures	74.57	75.31	73.45	74.9	652167.0
2018-07-02	GC	Futures	1600.2	1603.0	1583.8	1585.3	262872.0
2018-07-02	ZN	Futures	119.463458	119.774237	119.370225	119.416841	1072783.0
2018-07-02	A6	Futures	0.76141	0.76192	0.75215	0.75329	91977.0
2018-07-02	AD	Futures	0.77103	0.77184	0.76672	0.76809	55115.0
2018-07-02	B	Futures	57.94	58.24	56.92	57.02	265384.0
2018-07-02	B6	Futures	1.3675	1.3675	1.3555	1.3585	99873.0
2018-07-02	BR	Futures	0.19805	0.19805	0.19325	0.19359	58.0
2018-07-02	BTC	Futures	8939.4	9516.3	8918.0	9438.0	3977.0
2018-07-02	BZ	Futures	57.89	57.91	56.62	56.71	30859.0
2018-07-02	C	Futures	1720.0	1736.0	1708.0	1734.0	1982.0
2018-07-02	CB	Futures	279.659	279.659	276.42	277.35	61.0
2018-07-02	CC	Futures	1801.0	1803.0	1760.0	1793.0	22164.0
2018-07-02	CNH	Futures	6.7239	6.7815	6.7218	6.7738	164.0
2018-07-02	CSC	Futures	3.347	3.347	3.299	3.317	102.0
2018-07-02	CT	Futures	96.5	96.5	93.95	93.99	43.0
2018-07-02	DC	Futures	26.64	26.81	26.18	26.45	256.0
2018-07-02	DX	Futures	89.312	89.866	89.274	89.765	16215.0
2018-07-02	E1	Futures	1.21436	1.2146	1.20672	1.20887	21504.0
2018-07-02	E6	Futures	1.31274	1.31386	1.30352	1.30564	192483.0
2018-07-02	E7	Futures	1.3054	1.3071	1.2969	1.299	3635.0
2018-07-02	EBM	Futures	187.27	191.19	187.27	188.57	22130.0
2018-07-02	ED	Futures	94.9913	94.9961	94.9767	94.9815	159406.0
2018-07-02	ER	Futures	98.362	98.362	98.357	98.362	64945.0
2018-07-02	EW	Futures	2069.8	2073.7	2053.0	2070.9	14139.0
2018-07-02	FBON	Futures	128.99	129.37	128.77	129.37	366.0
2018-07-02	FBTP	Futures	107.59	108.24	106.8	108.12	55848.0
2018-07-02	FBTS	Futures	102.587	102.791	102.41	102.735	27662.0
2018-07-02	FCE	Futures	4741.8	4759.3	4707.6	4739.5	79377.0
2018-07-02	FDAX	Futures	12748.9	12852.4	12664.2	12788.1	86178.0
2018-07-02	FDXM	Futures	12579.8	12688.2	12502.4	12624.7	39297.0
2018-07-02	FESX	Futures	2802.1	2821.3	2784.6	2808.8	912513.0
2018-07-02	FGBL	Futures	153.19	153.49	153.04	153.24	460778.0
2018-07-02	FGBM	Futures	131.23	131.38	131.19	131.3	309989.0
2018-07-02	FGBS	Futures	112.779	112.814	112.769	112.804	317541.0
2018-07-02	FGBX	Futures	178.06	178.4	177.68	178.12	47576.0
2018-07-02	FMWO	Futures	6907.6	6926.2	6888.9	6912.2	1234.0
2018-07-02	FOAT	Futures	140.89	141.21	140.89	141.2	98636.0
2018-07-02	FTDX	Futures	2627.9	2627.9	2591.6	2609.7	752.0
2018-07-02	FTI	Futures	504.91	506.47	501.95	504.31	29509.0
2018-07-02	FTUK	Futures	6746.1	6747.9	6659.7	6678.4	113872.0
2018-07-02	FVSA	Futures	333.35	347.93	324.61	334.33	22099.0
2018-07-02	FXXP	Futures	324.0	325.9	322.9	324.4	51528.0
2018-07-02	G	Futures	115.61	115.73	115.46	115.67	139748.0
2018-07-02	GF	Futures	313.273	317.054	313.273	314.723	10632.0
2018-07-02	GSCI	Futures	542.63	542.63	537.97	537.97	222.0
2018-07-02	HE	Futures	85.022	85.997	82.264	82.877	33537.0

> showing 50 of 113 rows — these rows as CSV

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