PREVIEW / futures_daily / 2018-06-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-20.parquet
  size:    10 KB
  rows:    115

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-06-20	ES	Futures	3003.33	3017.45	2994.64	3010.66	1082802.0
2018-06-20	NQ	Futures	8457.16	8553.64	8425.68	8526.53	320649.0
2018-06-20	YM	Futures	26042.0	26192.7	25954.6	25994.6	181063.0
2018-06-20	CL	Futures	65.77	67.21	65.63	66.56	801625.0
2018-06-20	GC	Futures	1630.7	1632.4	1620.9	1627.1	233184.0
2018-06-20	ZN	Futures	119.13714	119.29253	118.857439	118.950673	1231414.0
2018-06-20	A6	Futures	0.75905	0.76172	0.7575	0.75791	107395.0
2018-06-20	AD	Futures	0.76378	0.76444	0.7613	0.76191	73904.0
2018-06-20	B	Futures	55.07	55.55	54.26	54.73	368837.0
2018-06-20	B6	Futures	1.3643	1.369	1.3618	1.3659	109082.0
2018-06-20	BR	Futures	0.2019	0.2019	0.20049	0.20049	313.0
2018-06-20	BTC	Futures	9528.7	9685.0	9301.3	9585.5	2108.0
2018-06-20	BZ	Futures	54.42	55.02	53.76	54.22	47160.0
2018-06-20	C	Futures	1625.0	1681.0	1624.0	1679.0	3554.0
2018-06-20	CB	Futures	283.736	283.736	279.809	280.078	45.0
2018-06-20	CC	Futures	1753.0	1836.0	1750.0	1830.0	24017.0
2018-06-20	CNH	Futures	6.5746	6.5751	6.5745	6.5751	17.0
2018-06-20	CSC	Futures	3.369	3.401	3.359	3.375	79.0
2018-06-20	CT	Futures	94.63	97.42	94.46	94.59	6148.0
2018-06-20	DC	Futures	26.89	27.06	26.66	26.81	179.0
2018-06-20	DX	Futures	89.638	89.96	89.582	89.706	16231.0
2018-06-20	E1	Futures	1.2115	1.21174	1.20612	1.20899	16663.0
2018-06-20	E6	Futures	1.30447	1.30586	1.29876	1.30435	233958.0
2018-06-20	E7	Futures	1.2978	1.2992	1.2923	1.2977	5311.0
2018-06-20	EBM	Futures	180.99	183.34	180.73	181.77	16968.0
2018-06-20	ED	Futures	94.9767	94.9815	94.9621	94.9669	208707.0
2018-06-20	ER	Futures	98.357	98.362	98.352	98.357	34174.0
2018-06-20	EW	Futures	2113.9	2127.3	2108.8	2125.1	11626.0
2018-06-20	FBON	Futures	129.92	130.07	129.77	129.89	388.0
2018-06-20	FBTP	Futures	108.69	108.96	108.58	108.69	44187.0
2018-06-20	FBTS	Futures	103.041	103.041	102.837	102.976	26475.0
2018-06-20	FCE	Futures	4870.7	4875.2	4820.4	4821.7	71498.0
2018-06-20	FDAX	Futures	13318.6	13327.0	13222.9	13266.9	77167.0
2018-06-20	FDXM	Futures	13146.4	13155.7	13054.5	13097.4	33934.0
2018-06-20	FESX	Futures	2881.4	2883.1	2862.2	2870.6	877064.0
2018-06-20	FEU3	Futures	99.011	99.011	99.001	99.001	198.0
2018-06-20	FGBL	Futures	152.11	152.36	152.0	152.19	522082.0
2018-06-20	FGBM	Futures	130.91	131.02	130.86	130.98	379347.0
2018-06-20	FGBS	Futures	112.698	112.734	112.683	112.723	290445.0
2018-06-20	FGBX	Futures	173.63	173.99	172.99	173.35	53600.0
2018-06-20	FMWO	Futures	7065.9	7077.6	7059.0	7065.9	2795.0
2018-06-20	FOAT	Futures	140.35	140.62	140.35	140.45	103769.0
2018-06-20	FTDX	Futures	2758.3	2779.4	2753.4	2772.5	177.0
2018-06-20	FTI	Futures	514.5	515.8	512.06	512.06	22322.0
2018-06-20	FTUK	Futures	6743.0	6804.9	6727.4	6747.9	108795.0
2018-06-20	FVSA	Futures	289.62	289.62	279.9	283.79	23576.0
2018-06-20	FXXP	Futures	331.4	332.6	330.5	331.2	56891.0
2018-06-20	G	Futures	115.31	115.46	115.15	115.29	197720.0
2018-06-20	GF	Futures	310.269	312.289	307.835	309.544	6732.0
2018-06-20	GSCI	Futures	521.49	521.49	518.8	519.36	117.0

> showing 50 of 115 rows — these rows as CSV

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