PREVIEW / futures_daily / 2018-06-13

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-13.parquet
  size:    10 KB
  rows:    114

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-13	ES	Futures	3031.86	3035.94	3016.36	3016.91	614173.0
2018-06-13	NQ	Futures	8443.21	8500.56	8417.76	8432.09	94299.0
2018-06-13	YM	Futures	26700.6	26742.7	26557.3	26561.5	145830.0
2018-06-13	CL	Futures	66.79	67.64	66.29	67.38	258193.0
2018-06-13	GC	Futures	1659.2	1666.3	1652.7	1661.3	263840.0
2018-06-13	ZN	Futures	118.717589	118.810822	118.266959	118.531121	1501977.0
2018-06-13	A6	Futures	0.77951	0.78291	0.77488	0.77776	71831.0
2018-06-13	AD	Futures	0.77958	0.78318	0.77746	0.78055	38635.0
2018-06-13	B	Futures	55.21	56.29	55.11	56.19	292469.0
2018-06-13	B6	Futures	1.3861	1.3876	1.3792	1.3842	82846.0
2018-06-13	BFX	Futures	4405.8	4413.3	4405.8	4413.3	5.0
2018-06-13	BR	Futures	0.20289	0.20414	0.20289	0.2035	33.0
2018-06-13	BTC	Futures	9194.7	9407.9	8668.9	8910.5	5146.0
2018-06-13	BZ	Futures	54.75	55.76	54.55	55.67	30468.0
2018-06-13	C	Futures	1524.0	1534.0	1479.0	1489.0	5324.0
2018-06-13	CB	Futures	291.142	291.142	289.343	290.393	12.0
2018-06-13	CC	Futures	1738.0	1774.0	1706.0	1714.0	31768.0
2018-06-13	CNH	Futures	6.4987	6.4987	6.4822	6.4874	117.0
2018-06-13	CSC	Futures	3.446	3.452	3.439	3.442	104.0
2018-06-13	CT	Futures	108.33	108.74	105.96	106.64	26904.0
2018-06-13	DC	Futures	27.96	27.98	27.81	27.84	104.0
2018-06-13	DX	Futures	88.497	88.729	88.237	88.42	20806.0
2018-06-13	E1	Futures	1.22058	1.2244	1.21747	1.22142	49490.0
2018-06-13	E6	Futures	1.32314	1.32941	1.32085	1.32622	240735.0
2018-06-13	E7	Futures	1.3165	1.3223	1.3145	1.3195	8575.0
2018-06-13	EBM	Futures	191.71	191.97	188.31	188.57	23417.0
2018-06-13	ED	Futures	94.9572	94.9621	94.9182	94.9426	351814.0
2018-06-13	ER	Futures	98.347	98.352	98.347	98.347	91943.0
2018-06-13	EW	Futures	2128.4	2131.1	2112.9	2113.9	14669.0
2018-06-13	FBON	Futures	127.87	128.22	127.83	128.18	219.0
2018-06-13	FBTP	Futures	106.07	106.62	105.85	106.03	95390.0
2018-06-13	FBTS	Futures	102.021	102.318	101.9	101.993	58019.0
2018-06-13	FCE	Futures	4896.8	4914.3	4883.8	4893.6	149815.0
2018-06-13	FDAX	Futures	13366.8	13412.0	13276.4	13404.7	119810.0
2018-06-13	FDXM	Futures	13254.7	13301.2	13173.2	13295.5	2999.0
2018-06-13	FESX	Futures	2890.6	2905.7	2884.0	2900.7	1546653.0
2018-06-13	FEU3	Futures	98.991	99.001	98.991	98.996	199.0
2018-06-13	FGBL	Futures	150.58	150.97	150.41	150.83	621529.0
2018-06-13	FGBM	Futures	130.09	130.25	130.05	130.19	385344.0
2018-06-13	FGBS	Futures	112.598	112.623	112.573	112.608	301480.0
2018-06-13	FGBX	Futures	172.13	172.95	171.57	172.53	50902.0
2018-06-13	FMWO	Futures	7126.6	7147.6	7121.9	7146.5	7058.0
2018-06-13	FOAT	Futures	138.33	138.84	138.28	138.8	113205.0
2018-06-13	FTDX	Futures	2825.0	2849.0	2817.1	2846.1	1786.0
2018-06-13	FTI	Futures	519.35	522.63	519.07	520.32	32459.0
2018-06-13	FTUK	Futures	6785.8	6839.2	6776.4	6808.1	193622.0
2018-06-13	FVSA	Futures	289.62	290.59	281.84	282.82	19086.0
2018-06-13	FXXP	Futures	334.3	334.9	333.0	334.2	108975.0
2018-06-13	G	Futures	114.28	114.7	114.21	114.61	195555.0
2018-06-13	GF	Futures	302.708	303.278	300.585	301.724	3194.0

> showing 50 of 114 rows — these rows as CSV

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