PREVIEW / futures_daily / 2019-09-12

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-12.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
2019-09-12	ES	Futures	3240.41	3260.64	3238.25	3249.85	1745651.0
2019-09-12	NQ	Futures	9087.69	9190.74	9080.21	9120.22	448979.0
2019-09-12	YM	Futures	28493.4	28660.3	28446.2	28537.5	22440.0
2019-09-12	CL	Futures	57.44	57.86	55.46	56.58	845977.0
2019-09-12	GC	Futures	1856.4	1890.0	1846.4	1859.5	491465.0
2019-09-12	ZN	Futures	128.737402	129.232903	128.210932	128.272869	2603316.0
2019-09-12	A6	Futures	0.70553	0.70912	0.70553	0.70625	65481.0
2019-09-12	AD	Futures	0.76428	0.76534	0.76287	0.76343	73247.0
2019-09-12	ALI	Futures	2223.36	2223.36	2186.32	2189.05	198.0
2019-09-12	B	Futures	47.24	47.41	45.51	46.63	358089.0
2019-09-12	B6	Futures	1.2574	1.2619	1.2534	1.2598	118822.0
2019-09-12	BR	Futures	0.19687	0.20002	0.19687	0.19817	31.0
2019-09-12	BTC	Futures	14515.9	14958.8	14408.8	14873.1	3099.0
2019-09-12	BZ	Futures	46.44	46.71	44.83	45.95	44952.0
2019-09-12	C	Futures	1562.0	1572.0	1558.0	1567.0	25446.0
2019-09-12	CB	Futures	264.191	265.106	264.191	264.516	12.0
2019-09-12	CC	Futures	1515.0	1526.0	1505.0	1522.0	15573.0
2019-09-12	CNH	Futures	7.1121	7.1121	7.0574	7.0673	1335.0
2019-09-12	CSC	Futures	3.085	3.137	3.081	3.131	72.0
2019-09-12	CT	Futures	58.66	61.47	58.66	61.47	142.0
2019-09-12	DC	Futures	25.94	26.55	25.94	26.49	384.0
2019-09-12	DX	Futures	94.894	95.367	94.352	94.6	38397.0
2019-09-12	E1	Futures	1.16749	1.17336	1.16577	1.17037	30522.0
2019-09-12	E6	Futures	1.20136	1.20987	1.19242	1.2084	406694.0
2019-09-12	E7	Futures	1.1953	1.2035	1.1863	1.2021	9750.0
2019-09-12	EBM	Futures	185.51	186.33	183.6	185.51	27608.0
2019-09-12	ED	Futures	95.2889	95.318	95.2451	95.2451	513191.0
2019-09-12	ER	Futures	98.533	98.543	98.445	98.465	302228.0
2019-09-12	EW	Futures	2067.9	2078.8	2052.4	2063.5	5870.0
2019-09-12	FBON	Futures	144.81	146.86	144.81	145.43	702.0
2019-09-12	FBTP	Futures	131.22	133.37	130.27	132.42	226386.0
2019-09-12	FBTS	Futures	108.568	108.953	108.413	108.616	197592.0
2019-09-12	FCE	Futures	5089.8	5119.2	5067.2	5098.8	14873.0
2019-09-12	FDAX	Futures	13089.7	13134.4	12955.4	13073.4	136346.0
2019-09-12	FDXM	Futures	12913.1	12965.2	12763.1	12910.5	934.0
2019-09-12	FESX	Futures	3082.5	3103.6	3059.7	3089.5	445208.0
2019-09-12	FEU3	Futures	99.164	99.164	99.164	99.164	1.0
2019-09-12	FGBL	Futures	168.12	169.65	167.34	168.02	1236443.0
2019-09-12	FGBM	Futures	135.56	135.91	134.88	135.13	778292.0
2019-09-12	FGBS	Futures	113.182	113.217	112.87	112.961	835664.0
2019-09-12	FGBX	Futures	221.44	227.09	220.05	222.23	98012.0
2019-09-12	FMWO	Futures	7426.0	7435.2	7392.5	7417.9	7056.0
2019-09-12	FOAT	Futures	154.81	156.62	154.45	155.01	190822.0
2019-09-12	FTI	Futures	545.33	547.41	541.86	544.83	399.0
2019-09-12	FTUK	Futures	6802.8	6807.0	6737.5	6770.8	27393.0
2019-09-12	FVSA	Futures	187.5	188.62	179.08	181.32	23988.0
2019-09-12	FXXP	Futures	352.0	353.7	349.7	351.7	16861.0
2019-09-12	G	Futures	121.46	122.13	121.0	121.43	223865.0
2019-09-12	GF	Futures	282.114	282.585	279.603	281.539	7634.0
2019-09-12	GSCI	Futures	450.59	454.07	450.59	453.29	2479.0

> showing 50 of 116 rows — these rows as CSV

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