PREVIEW / futures_daily / 2018-03-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-06.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-03-06	ES	Futures	2955.22	2972.07	2945.71	2960.66	1450085.0
2018-03-06	NQ	Futures	8058.3	8127.11	8048.05	8090.22	415228.0
2018-03-06	YM	Futures	26243.9	26414.7	26043.5	26209.1	262663.0
2018-03-06	CL	Futures	63.02	63.73	62.61	63.04	634953.0
2018-03-06	GC	Futures	1687.4	1711.5	1687.1	1705.5	285918.0
2018-03-06	ZN	Futures	119.121337	119.306452	118.920796	119.136763	34443.0
2018-03-06	A6	Futures	0.79853	0.80666	0.79792	0.80419	126280.0
2018-03-06	AD	Futures	0.78239	0.7895	0.78132	0.78711	91827.0
2018-03-06	B	Futures	47.45	47.75	47.13	47.48	199793.0
2018-03-06	B6	Futures	1.4405	1.4494	1.4375	1.4449	120449.0
2018-03-06	BTC	Futures	16084.5	16167.7	14662.6	14773.6	1580.0
2018-03-06	BZ	Futures	46.76	47.16	46.56	46.9	24251.0
2018-03-06	C	Futures	1586.0	1604.0	1556.0	1601.0	9954.0
2018-03-06	CB	Futures	285.355	287.239	285.355	287.239	17.0
2018-03-06	CC	Futures	1776.0	1813.0	1764.0	1791.0	36512.0
2018-03-06	CNH	Futures	6.4586	6.4652	6.4416	6.4416	14.0
2018-03-06	CSC	Futures	3.335	3.337	3.329	3.337	19.0
2018-03-06	CT	Futures	97.67	99.54	93.92	94.75	40270.0
2018-03-06	DC	Futures	26.49	26.56	26.37	26.44	28.0
2018-03-06	DX	Futures	84.444	84.552	84.021	84.134	32814.0
2018-03-06	E1	Futures	1.29282	1.29816	1.29003	1.29161	26261.0
2018-03-06	E6	Futures	1.3994	1.40915	1.39866	1.40734	218947.0
2018-03-06	E7	Futures	1.3928	1.4021	1.3916	1.4003	4221.0
2018-03-06	EBM	Futures	177.47	178.01	176.13	177.74	16123.0
2018-03-06	ED	Futures	95.0834	95.0907	95.0664	95.0688	258563.0
2018-03-06	ER	Futures	98.337	98.342	98.332	98.337	57390.0
2018-03-06	EW	Futures	2011.6	2033.9	2005.3	2032.8	17010.0
2018-03-06	FBON	Futures	126.82	127.52	126.82	127.05	1780.0
2018-03-06	FBTP	Futures	112.1	112.93	112.05	112.35	278391.0
2018-03-06	FBTS	Futures	103.742	103.862	103.742	103.816	108946.0
2018-03-06	FCE	Futures	4588.7	4607.2	4561.3	4565.3	59065.0
2018-03-06	FDAX	Futures	12638.5	12730.3	12553.9	12563.8	94183.0
2018-03-06	FDXM	Futures	12663.1	12751.4	12575.8	12585.1	36022.0
2018-03-06	FESX	Futures	2754.7	2768.6	2738.3	2742.4	1169656.0
2018-03-06	FGBL	Futures	147.57	147.79	147.03	147.34	1391292.0
2018-03-06	FGBM	Futures	128.84	128.96	128.62	128.72	1199141.0
2018-03-06	FGBS	Futures	112.417	112.422	112.367	112.392	957210.0
2018-03-06	FGBX	Futures	165.01	165.79	164.3	165.13	164697.0
2018-03-06	FMWO	Futures	6980.7	7012.2	6969.0	6969.0	3397.0
2018-03-06	FOAT	Futures	136.8	136.95	136.25	136.55	312644.0
2018-03-06	FTDX	Futures	2547.8	2577.8	2547.3	2553.8	458.0
2018-03-06	FTI	Futures	485.7	487.58	484.32	484.96	22447.0
2018-03-06	FTUK	Futures	6241.3	6279.8	6226.0	6238.3	106518.0
2018-03-06	FVSA	Futures	430.89	445.67	423.51	444.43	24806.0
2018-03-06	FXXP	Futures	317.6	318.9	315.9	316.3	30637.0
2018-03-06	G	Futures	112.78	112.81	112.18	112.66	273694.0
2018-03-06	GF	Futures	318.964	321.49	316.549	316.878	2469.0
2018-03-06	GSCI	Futures	510.3	510.47	508.43	509.74	377.0
2018-03-06	HE	Futures	88.954	89.018	87.477	87.574	20921.0
2018-03-06	HG	Futures	3.722	3.7809	3.7197	3.7583	83845.0

> showing 50 of 110 rows — these rows as CSV

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