PREVIEW / futures_daily / 2019-08-14

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-14.parquet
  size:    10 KB
  rows:    120

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
2019-08-14	ES	Futures	3162.72	3168.65	3059.93	3065.33	2786308.0
2019-08-14	NQ	Futures	8918.74	8942.91	8608.45	8621.98	825231.0
2019-08-14	YM	Futures	27617.8	27670.3	26681.2	26728.4	340944.0
2019-08-14	CL	Futures	58.26	58.38	55.46	56.74	307925.0
2019-08-14	GC	Futures	1866.4	1893.4	1855.9	1884.6	484188.0
2019-08-14	ZN	Futures	129.073402	130.08434	129.05785	129.913258	2099883.0
2019-08-14	A6	Futures	0.70007	0.70121	0.6937	0.69483	86419.0
2019-08-14	AD	Futures	0.76277	0.76337	0.75682	0.75702	88946.0
2019-08-14	ALI	Futures	2197.62	2197.62	2182.65	2186.62	162.0
2019-08-14	B	Futures	46.07	46.08	43.91	44.87	320431.0
2019-08-14	B6	Futures	1.2326	1.237	1.2312	1.2327	78447.0
2019-08-14	BR	Futures	0.20107	0.20107	0.19696	0.19756	7041.0
2019-08-14	BTC	Futures	15048.7	15083.2	13864.7	13988.6	6021.0
2019-08-14	BZ	Futures	45.41	45.48	43.36	44.29	45545.0
2019-08-14	C	Futures	1589.0	1591.0	1569.0	1570.0	4283.0
2019-08-14	CB	Futures	276.574	276.574	275.699	275.991	19.0
2019-08-14	CC	Futures	1444.0	1461.0	1438.0	1446.0	31035.0
2019-08-14	CNH	Futures	7.02	7.0662	7.0198	7.0653	1551.0
2019-08-14	CSC	Futures	3.087	3.1	3.078	3.099	148.0
2019-08-14	CT	Futures	58.64	58.94	58.41	58.87	6.0
2019-08-14	DC	Futures	26.02	26.16	25.89	26.13	351.0
2019-08-14	DX	Futures	93.98	94.254	93.874	94.188	15211.0
2019-08-14	E1	Futures	1.1916	1.19867	1.19055	1.19496	33654.0
2019-08-14	E6	Futures	1.22189	1.22402	1.21731	1.21824	171352.0
2019-08-14	E7	Futures	1.2156	1.2175	1.2108	1.2119	3582.0
2019-08-14	EBM	Futures	192.31	193.46	191.44	192.02	20618.0
2019-08-14	ED	Futures	95.372	95.4353	95.372	95.4207	353920.0
2019-08-14	ER	Futures	98.543	98.543	98.538	98.538	41492.0
2019-08-14	EW	Futures	1993.1	1994.2	1928.1	1930.8	19463.0
2019-08-14	FBON	Futures	145.42	146.13	145.42	146.03	464.0
2019-08-14	FBTP	Futures	125.25	126.32	124.95	125.89	102159.0
2019-08-14	FBTS	Futures	107.254	107.485	107.168	107.417	58892.0
2019-08-14	FCE	Futures	4866.9	4871.0	4734.6	4755.0	134487.0
2019-08-14	FDAX	Futures	12411.5	12412.1	12031.9	12082.0	144029.0
2019-08-14	FDIV	Futures	139.41	139.41	138.62	138.62	55.0
2019-08-14	FDXM	Futures	12248.3	12259.7	11887.4	11933.1	73912.0
2019-08-14	FESX	Futures	2937.4	2940.9	2855.4	2865.0	1452152.0
2019-08-14	FGBL	Futures	168.98	169.72	168.89	169.55	638591.0
2019-08-14	FGBM	Futures	135.79	135.95	135.77	135.87	370134.0
2019-08-14	FGBS	Futures	113.333	113.343	113.308	113.323	207978.0
2019-08-14	FGBX	Futures	227.03	230.39	226.57	229.54	65167.0
2019-08-14	FMWO	Futures	7199.8	7199.8	6996.8	7037.2	2592.0
2019-08-14	FOAT	Futures	155.28	155.93	155.21	155.8	104178.0
2019-08-14	FTDX	Futures	2731.3	2734.3	2638.1	2654.8	216.0
2019-08-14	FTI	Futures	516.34	516.34	503.14	506.21	30604.0
2019-08-14	FTUK	Futures	6695.2	6695.2	6529.5	6549.3	133335.0
2019-08-14	FVSA	Futures	217.6	247.7	216.34	240.17	36594.0
2019-08-14	FXXP	Futures	334.2	334.2	325.9	327.1	84012.0
2019-08-14	G	Futures	123.54	124.09	123.45	123.99	187820.0
2019-08-14	GF	Futures	261.538	272.577	261.487	270.288	11107.0

> showing 50 of 120 rows — these rows as CSV

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