PREVIEW / futures_daily / 2018-09-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-18.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
2018-09-18	ES	Futures	3140.2	3164.33	3127.19	3157.83	1877029.0
2018-09-18	NQ	Futures	8669.05	8786.07	8621.13	8739.9	472740.0
2018-09-18	YM	Futures	27486.5	27755.1	27369.7	27696.1	163216.0
2018-09-18	CL	Futures	71.79	73.45	71.49	72.85	513859.0
2018-09-18	GC	Futures	1529.0	1531.3	1521.3	1524.6	229111.0
2018-09-18	ZN	Futures	118.763621	118.857001	118.250032	118.327848	1775605.0
2018-09-18	A6	Futures	0.73879	0.74342	0.73529	0.74259	111362.0
2018-09-18	AD	Futures	0.77694	0.78088	0.77527	0.78022	52170.0
2018-09-18	B	Futures	56.69	58.11	56.46	57.6	259175.0
2018-09-18	B6	Futures	1.3586	1.3603	1.3545	1.3565	83838.0
2018-09-18	BFX	Futures	4307.1	4332.7	4307.1	4332.7	1.0
2018-09-18	BR	Futures	0.18277	0.18331	0.18277	0.18331	2.0
2018-09-18	BTC	Futures	8881.4	9110.3	8838.5	8974.4	1108.0
2018-09-18	BZ	Futures	56.53	57.86	56.25	57.36	22637.0
2018-09-18	C	Futures	1470.0	1488.0	1463.0	1474.0	7732.0
2018-09-18	CB	Futures	268.263	268.263	268.263	268.263	2.0
2018-09-18	CC	Futures	1563.0	1593.0	1553.0	1566.0	15668.0
2018-09-18	CNH	Futures	6.9591	6.9591	6.9284	6.9284	873.0
2018-09-18	CSC	Futures	3.238	3.248	3.23	3.236	48.0
2018-09-18	CT	Futures	92.02	92.02	88.81	88.81	37.0
2018-09-18	DC	Futures	26.83	26.83	26.53	26.59	119.0
2018-09-18	DX	Futures	89.469	89.602	89.184	89.514	19090.0
2018-09-18	E1	Futures	1.24131	1.24439	1.23728	1.23799	22653.0
2018-09-18	E6	Futures	1.3083	1.31274	1.30457	1.30624	223559.0
2018-09-18	E7	Futures	1.3021	1.3063	1.2982	1.2999	4686.0
2018-09-18	EBM	Futures	205.6	208.46	205.6	207.16	23070.0
2018-09-18	ED	Futures	95.0866	95.1013	95.0866	95.0964	307120.0
2018-09-18	ER	Futures	98.372	98.377	98.372	98.372	28296.0
2018-09-18	EW	Futures	2141.7	2153.3	2134.4	2149.0	38598.0
2018-09-18	FBON	Futures	128.23	128.28	127.95	128.03	350.0
2018-09-18	FBTP	Futures	108.96	109.94	108.6	109.61	105549.0
2018-09-18	FBTS	Futures	103.258	103.67	103.183	103.52	64859.0
2018-09-18	FCE	Futures	4795.9	4849.1	4791.4	4824.3	121042.0
2018-09-18	FDAX	Futures	12657.3	12795.0	12657.3	12753.5	52510.0
2018-09-18	FDXM	Futures	12441.2	12568.3	12441.2	12532.6	1819.0
2018-09-18	FESX	Futures	2784.8	2815.0	2784.8	2804.1	1679009.0
2018-09-18	FEU3	Futures	98.996	99.001	98.996	99.001	141.0
2018-09-18	FGBL	Futures	152.23	152.42	151.84	151.92	650229.0
2018-09-18	FGBM	Futures	130.54	130.63	130.43	130.46	442059.0
2018-09-18	FGBS	Futures	112.527	112.542	112.507	112.512	357332.0
2018-09-18	FGBX	Futures	175.7	176.22	174.38	174.67	43907.0
2018-09-18	FMWO	Futures	7216.2	7256.7	7216.2	7247.5	12155.0
2018-09-18	FOAT	Futures	140.23	140.31	139.89	139.95	129238.0
2018-09-18	FTDX	Futures	2847.5	2853.4	2820.0	2852.4	2198.0
2018-09-18	FTI	Futures	499.84	505.08	499.74	503.69	31587.0
2018-09-18	FTUK	Futures	6440.0	6509.7	6427.5	6487.3	393631.0
2018-09-18	FVSA	Futures	263.98	265.7	258.8	261.39	25759.0
2018-09-18	FXXP	Futures	325.8	327.4	325.1	326.3	175313.0
2018-09-18	G	Futures	114.1	114.3	113.83	113.92	189000.0
2018-09-18	GF	Futures	330.556	332.376	328.32	328.736	5553.0

> showing 50 of 115 rows — these rows as CSV

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