PREVIEW / futures_daily / 2018-09-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-12.parquet
  size:    9 KB
  rows:    108

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-12	ES	Futures	3138.82	3144.52	3127.42	3137.19	1581597.0
2018-09-12	NQ	Futures	8762.04	8792.07	8656.82	8727.65	586137.0
2018-09-12	YM	Futures	27413.9	27571.8	27340.2	27417.0	14788.0
2018-09-12	CL	Futures	72.8	74.22	72.39	73.3	800543.0
2018-09-12	GC	Futures	1525.3	1538.5	1517.9	1534.7	304315.0
2018-09-12	ZN	Futures	118.872564	119.028197	118.857001	118.965944	1308068.0
2018-09-12	A6	Futures	0.73282	0.7394	0.73025	0.73889	73177.0
2018-09-12	AD	Futures	0.77527	0.78038	0.77446	0.78002	62437.0
2018-09-12	B	Futures	57.89	58.4	57.4	58.12	315266.0
2018-09-12	B6	Futures	1.3442	1.3511	1.3405	1.3483	70875.0
2018-09-12	BR	Futures	0.18323	0.18323	0.18304	0.18312	2.0
2018-09-12	BTC	Futures	8967.2	9060.2	8831.4	8995.8	1581.0
2018-09-12	BZ	Futures	57.68	58.14	57.15	57.87	29906.0
2018-09-12	C	Futures	1525.0	1544.0	1503.0	1527.0	26107.0
2018-09-12	CB	Futures	262.195	263.787	261.353	261.383	43.0
2018-09-12	CC	Futures	1596.0	1635.0	1580.0	1624.0	18253.0
2018-09-12	CNH	Futures	6.9564	6.9607	6.8954	6.8954	484.0
2018-09-12	CSC	Futures	3.266	3.272	3.262	3.266	30.0
2018-09-12	CT	Futures	93.58	93.58	92.86	92.86	1.0
2018-09-12	DC	Futures	26.89	27.01	26.81	26.91	66.0
2018-09-12	DX	Futures	90.001	90.125	89.579	89.638	16096.0
2018-09-12	E1	Futures	1.22887	1.23266	1.2259	1.23207	23833.0
2018-09-12	E6	Futures	1.29946	1.30479	1.29596	1.30285	168716.0
2018-09-12	E7	Futures	1.2929	1.2983	1.2896	1.2964	2526.0
2018-09-12	EBM	Futures	210.01	212.61	206.64	207.42	40280.0
2018-09-12	ED	Futures	95.0622	95.0866	95.0622	95.0769	432713.0
2018-09-12	ER	Futures	98.377	98.377	98.372	98.377	45572.0
2018-09-12	EW	Futures	2147.2	2150.3	2133.2	2147.5	1082.0
2018-09-12	FBON	Futures	128.43	128.53	128.24	128.44	381.0
2018-09-12	FBTP	Futures	108.01	108.47	107.52	107.82	105322.0
2018-09-12	FBTS	Futures	103.136	103.295	102.874	102.967	75441.0
2018-09-12	FCE	Futures	4761.2	4796.8	4761.2	4795.9	405.0
2018-09-12	FDAX	Futures	12541.9	12592.1	12489.1	12585.8	92403.0
2018-09-12	FDXM	Futures	12382.3	12431.9	12334.7	12425.7	392.0
2018-09-12	FESX	Futures	2772.2	2782.3	2761.3	2780.6	320514.0
2018-09-12	FGBL	Futures	152.5	152.93	152.49	152.77	669892.0
2018-09-12	FGBM	Futures	130.73	130.89	130.73	130.83	441359.0
2018-09-12	FGBS	Futures	112.542	112.578	112.542	112.562	332390.0
2018-09-12	FGBX	Futures	175.29	176.4	175.29	176.06	38091.0
2018-09-12	FMWO	Futures	7161.4	7181.2	7145.1	7180.1	3343.0
2018-09-12	FOAT	Futures	140.46	140.79	140.43	140.66	117190.0
2018-09-12	FTDX	Futures	2853.9	2864.2	2839.7	2847.0	523.0
2018-09-12	FTI	Futures	503.36	503.64	499.56	501.09	52.0
2018-09-12	FTUK	Futures	6466.3	6513.2	6447.6	6498.5	25833.0
2018-09-12	FVSA	Futures	270.01	273.47	267.43	268.29	11028.0
2018-09-12	FXXP	Futures	323.8	325.3	323.8	325.2	5706.0
2018-09-12	G	Futures	114.49	114.68	114.45	114.61	170888.0
2018-09-12	GF	Futures	317.294	322.911	316.982	322.495	8674.0
2018-09-12	GSCI	Futures	526.76	528.1	526.76	527.54	2340.0
2018-09-12	HE	Futures	74.003	76.474	73.224	75.56	37660.0

> showing 50 of 108 rows — these rows as CSV

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