PREVIEW / futures_daily / 2018-03-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-21.parquet
  size:    9 KB
  rows:    111

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-03-21	ES	Futures	2961.45	2984.01	2949.76	2956.01	1423759.0
2018-03-21	NQ	Futures	8090.62	8135.68	8008.4	8057.26	454570.0
2018-03-21	YM	Futures	26091.7	26332.9	25976.9	26047.4	225022.0
2018-03-21	CL	Futures	63.99	65.83	63.85	65.45	763768.0
2018-03-21	GC	Futures	1674.1	1707.7	1672.7	1688.0	470286.0
2018-03-21	ZN	Futures	119.074893	119.354048	118.795739	119.059385	1518293.0
2018-03-21	A6	Futures	0.79041	0.80018	0.78908	0.79761	142643.0
2018-03-21	AD	Futures	0.77509	0.78621	0.77498	0.78429	123790.0
2018-03-21	B	Futures	48.8	50.42	48.7	50.14	401046.0
2018-03-21	B6	Futures	1.4558	1.471	1.4554	1.469	150729.0
2018-03-21	BR	Futures	0.23008	0.23107	0.22963	0.23107	6.0
2018-03-21	BTC	Futures	12470.8	12741.3	12172.6	12332.1	1829.0
2018-03-21	BZ	Futures	48.16	49.79	48.1	49.52	43370.0
2018-03-21	C	Futures	1644.0	1661.0	1626.0	1657.0	10232.0
2018-03-21	CB	Futures	278.838	279.147	278.838	279.147	8.0
2018-03-21	CC	Futures	1834.0	1864.0	1814.0	1852.0	18012.0
2018-03-21	CNH	Futures	6.4529	6.4529	6.4234	6.4234	31.0
2018-03-21	CSC	Futures	3.304	3.327	3.304	3.327	26.0
2018-03-21	CT	Futures	95.38	96.39	94.88	94.93	13920.0
2018-03-21	DC	Futures	26.24	26.58	26.21	26.56	185.0
2018-03-21	DX	Futures	84.863	84.868	84.142	84.287	32855.0
2018-03-21	E1	Futures	1.26934	1.27933	1.26897	1.27668	29174.0
2018-03-21	E6	Futures	1.38868	1.40051	1.38851	1.39814	260797.0
2018-03-21	E7	Futures	1.3814	1.3929	1.3809	1.3907	3647.0
2018-03-21	EBM	Futures	174.79	175.32	173.98	174.79	11925.0
2018-03-21	ED	Futures	94.9695	94.9889	94.9403	94.9695	634413.0
2018-03-21	ER	Futures	98.337	98.337	98.332	98.337	78408.0
2018-03-21	EW	Futures	2038.7	2056.3	2034.4	2042.0	12201.0
2018-03-21	FBON	Futures	129.01	129.01	128.7	128.71	296.0
2018-03-21	FBTP	Futures	114.19	114.29	113.9	113.99	77245.0
2018-03-21	FBTS	Futures	104.038	104.065	103.991	104.01	48037.0
2018-03-21	FCE	Futures	4623.6	4628.9	4582.2	4608.6	80984.0
2018-03-21	FDAX	Futures	12826.5	12859.2	12698.7	12791.7	101653.0
2018-03-21	FDXM	Futures	12710.2	12744.2	12588.7	12677.8	37773.0
2018-03-21	FESX	Futures	2773.1	2778.1	2743.1	2758.1	965189.0
2018-03-21	FEU3	Futures	99.021	99.021	99.021	99.021	3.0
2018-03-21	FGBL	Futures	148.68	148.78	148.45	148.57	490662.0
2018-03-21	FGBM	Futures	129.19	129.24	129.1	129.2	351960.0
2018-03-21	FGBS	Futures	112.502	112.512	112.482	112.507	281134.0
2018-03-21	FGBX	Futures	168.96	169.06	168.32	168.59	33177.0
2018-03-21	FMWO	Futures	7002.8	7027.4	6988.8	7021.5	307.0
2018-03-21	FOAT	Futures	137.88	137.91	137.64	137.8	76361.0
2018-03-21	FTDX	Futures	2652.8	2660.7	2562.7	2634.0	60.0
2018-03-21	FTI	Futures	490.06	491.62	487.4	490.47	20794.0
2018-03-21	FTUK	Futures	6158.0	6173.9	6105.8	6139.9	86169.0
2018-03-21	FVSA	Futures	401.9	410.23	388.82	394.77	27570.0
2018-03-21	FXXP	Futures	318.4	318.7	315.7	317.3	42695.0
2018-03-21	G	Futures	112.99	113.02	112.33	112.54	247580.0
2018-03-21	GF	Futures	300.184	300.947	295.611	296.7	6079.0
2018-03-21	GSCI	Futures	514.39	520.91	514.39	518.68	40.0

> showing 50 of 111 rows — these rows as CSV

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