PREVIEW / futures_daily / 2018-11-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-27.parquet
  size:    10 KB
  rows:    116

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-11-27	ES	Futures	2885.88	2913.81	2879.65	2910.29	1503048.0
2018-11-27	NQ	Futures	7711.95	7808.94	7681.46	7796.74	577173.0
2018-11-27	YM	Futures	25803.8	26095.5	25698.5	26054.4	231349.0
2018-11-27	CL	Futures	54.53	55.42	53.22	54.55	764010.0
2018-11-27	GC	Futures	1547.9	1551.9	1534.4	1537.1	135214.0
2018-11-27	ZN	Futures	118.779184	118.857001	118.639114	118.779184	3153782.0
2018-11-27	A6	Futures	0.7429	0.74825	0.74105	0.74352	96591.0
2018-11-27	AD	Futures	0.76324	0.76425	0.75889	0.76061	64953.0
2018-11-27	B	Futures	44.41	45.16	43.4	44.35	306895.0
2018-11-27	B6	Futures	1.3188	1.3195	1.3097	1.3108	91227.0
2018-11-27	BR	Futures	0.20161	0.20348	0.20153	0.20348	1230.0
2018-11-27	BTC	Futures	5691.4	5752.5	5416.8	5645.6	645.0
2018-11-27	BZ	Futures	43.85	44.58	42.84	43.78	39459.0
2018-11-27	C	Futures	1420.0	1461.0	1420.0	1450.0	3890.0
2018-11-27	CB	Futures	265.637	265.637	264.24	264.24	79.0
2018-11-27	CC	Futures	1457.0	1492.0	1452.0	1478.0	15551.0
2018-11-27	CNH	Futures	6.9835	6.9976	6.9726	6.9952	260.0
2018-11-27	CSC	Futures	2.885	2.89	2.881	2.886	53.0
2018-11-27	CT	Futures	85.51	85.51	84.45	84.84	10671.0
2018-11-27	DC	Futures	23.88	23.94	23.81	23.86	62.0
2018-11-27	DX	Futures	92.082	92.538	92.034	92.414	19326.0
2018-11-27	E1	Futures	1.18916	1.19023	1.18679	1.18892	18197.0
2018-11-27	E6	Futures	1.26177	1.26316	1.25576	1.25771	200671.0
2018-11-27	E7	Futures	1.2556	1.2568	1.2496	1.2515	3271.0
2018-11-27	EBM	Futures	207.42	207.68	206.12	206.64	10947.0
2018-11-27	ED	Futures	94.945	94.9597	94.9426	94.9499	256347.0
2018-11-27	ER	Futures	98.386	98.391	98.386	98.386	45975.0
2018-11-27	EW	Futures	1934.6	1949.9	1921.1	1926.8	17596.0
2018-11-27	FBON	Futures	127.83	128.28	127.83	128.01	485.0
2018-11-27	FBTP	Futures	106.84	107.0	106.28	106.43	106915.0
2018-11-27	FBTS	Futures	103.745	103.782	103.511	103.52	85699.0
2018-11-27	FCE	Futures	4451.2	4484.8	4423.5	4447.2	75352.0
2018-11-27	FDAX	Futures	11925.4	12029.5	11840.8	11894.4	101555.0
2018-11-27	FDIV	Futures	138.95	138.95	137.55	137.55	1.0
2018-11-27	FDXM	Futures	11722.0	11820.2	11635.2	11688.4	50860.0
2018-11-27	FESX	Futures	2657.9	2678.1	2640.3	2655.4	929272.0
2018-11-27	FGBL	Futures	153.98	154.28	153.91	154.1	669448.0
2018-11-27	FGBM	Futures	131.4	131.51	131.37	131.45	400126.0
2018-11-27	FGBS	Futures	112.698	112.713	112.688	112.708	294154.0
2018-11-27	FGBX	Futures	179.25	179.69	178.74	178.97	43245.0
2018-11-27	FMWO	Futures	6649.6	6662.3	6617.2	6648.4	2089.0
2018-11-27	FOAT	Futures	140.96	141.16	140.93	141.04	177690.0
2018-11-27	FTDX	Futures	2527.3	2536.6	2498.8	2513.6	340.0
2018-11-27	FTI	Futures	481.21	483.57	478.7	482.01	22650.0
2018-11-27	FTUK	Futures	6270.6	6333.6	6242.0	6276.9	90393.0
2018-11-27	FVSA	Futures	337.68	345.74	328.61	337.68	25727.0
2018-11-27	FXXP	Futures	309.9	312.0	307.8	309.5	60319.0
2018-11-27	G	Futures	115.85	116.06	115.79	115.93	556266.0
2018-11-27	GF	Futures	320.684	321.814	319.177	319.5	3939.0
2018-11-27	GSCI	Futures	458.16	461.43	457.37	458.84	63.0

> showing 50 of 116 rows — these rows as CSV

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