PREVIEW / futures_daily / 2018-04-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-09.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-04-09	ES	Futures	2835.57	2885.87	2835.57	2848.08	1762078.0
2018-04-09	NQ	Futures	7564.51	7745.93	7561.0	7604.31	482071.0
2018-04-09	YM	Futures	25226.8	25646.1	25187.9	25294.3	271313.0
2018-04-09	CL	Futures	62.26	63.88	62.19	63.69	655831.0
2018-04-09	GC	Futures	1708.2	1712.7	1698.1	1710.9	228812.0
2018-04-09	ZN	Futures	120.082951	120.113968	119.819305	120.005408	1019971.0
2018-04-09	A6	Futures	0.78866	0.79298	0.78692	0.79226	85221.0
2018-04-09	AD	Futures	0.79279	0.79851	0.79021	0.7976	68812.0
2018-04-09	B	Futures	48.77	50.01	48.7	49.9	257496.0
2018-04-09	B6	Futures	1.4628	1.471	1.4621	1.4678	83421.0
2018-04-09	BR	Futures	0.22498	0.22601	0.22247	0.22319	360.0
2018-04-09	BTC	Futures	9976.6	10260.6	9380.1	9479.6	3348.0
2018-04-09	BZ	Futures	48.09	49.36	48.09	49.25	23967.0
2018-04-09	C	Futures	1573.0	1617.0	1560.0	1610.0	7429.0
2018-04-09	CB	Futures	290.945	295.238	290.945	295.238	34.0
2018-04-09	CC	Futures	1824.0	1874.0	1804.0	1861.0	38536.0
2018-04-09	CNH	Futures	6.3972	6.4217	6.3972	6.4046	51.0
2018-04-09	CSC	Futures	3.377	3.398	3.377	3.398	16.0
2018-04-09	CT	Futures	95.28	96.2	95.06	95.3	28417.0
2018-04-09	DC	Futures	26.85	27.28	26.85	27.19	222.0
2018-04-09	DX	Futures	84.74	84.863	84.42	84.442	22271.0
2018-04-09	E1	Futures	1.26283	1.26693	1.26042	1.26645	15494.0
2018-04-09	E6	Futures	1.38992	1.39612	1.38806	1.39499	188055.0
2018-04-09	E7	Futures	1.3825	1.3885	1.3807	1.3875	2232.0
2018-04-09	EBM	Futures	180.16	180.96	179.62	180.42	24440.0
2018-04-09	ED	Futures	94.9889	95.0035	94.9695	95.0035	293413.0
2018-04-09	ER	Futures	98.337	98.342	98.337	98.337	13196.0
2018-04-09	EW	Futures	1969.7	1992.1	1962.6	1965.3	15316.0
2018-04-09	FBON	Futures	130.06	130.17	129.93	129.98	316.0
2018-04-09	FBTP	Futures	115.49	115.89	115.49	115.81	63201.0
2018-04-09	FBTS	Futures	104.232	104.25	104.213	104.241	33441.0
2018-04-09	FCE	Futures	4622.3	4657.6	4618.8	4633.8	60936.0
2018-04-09	FDAX	Futures	12737.1	12863.9	12686.2	12735.1	102024.0
2018-04-09	FDXM	Futures	12625.8	12749.4	12572.2	12621.7	37592.0
2018-04-09	FESX	Futures	2768.9	2793.9	2768.1	2776.4	913014.0
2018-04-09	FEU3	Futures	99.026	99.026	99.026	99.026	5.0
2018-04-09	FGBL	Futures	150.04	150.09	149.85	149.91	488561.0
2018-04-09	FGBM	Futures	129.75	129.77	129.65	129.66	237357.0
2018-04-09	FGBS	Futures	112.537	112.542	112.507	112.512	207890.0
2018-04-09	FGBX	Futures	170.95	171.15	170.51	170.7	31493.0
2018-04-09	FMWO	Futures	6855.7	6896.6	6841.7	6883.7	913.0
2018-04-09	FOAT	Futures	139.09	139.21	139.01	139.1	98412.0
2018-04-09	FTDX	Futures	2487.1	2502.9	2473.7	2496.5	228.0
2018-04-09	FTI	Futures	492.95	496.76	492.31	494.6	21182.0
2018-04-09	FTUK	Futures	6266.7	6314.8	6248.5	6286.1	81628.0
2018-04-09	FVSA	Futures	406.66	426.87	401.9	413.79	14821.0
2018-04-09	FXXP	Futures	317.7	320.7	317.7	318.9	34367.0
2018-04-09	G	Futures	113.9	113.93	113.72	113.87	134494.0
2018-04-09	GF	Futures	296.21	300.62	292.071	292.834	1727.0
2018-04-09	GSCI	Futures	515.65	515.65	515.65	515.65	2785.0

> showing 50 of 111 rows — these rows as CSV

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