PREVIEW / futures_daily / 2018-03-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-12.parquet
  size:    9 KB
  rows:    112

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-03-12	ES	Futures	3025.87	3043.8	3020.44	3025.87	1232395.0
2018-03-12	NQ	Futures	8314.5	8384.18	8303.66	8361.64	185865.0
2018-03-12	YM	Futures	26718.5	26898.6	26524.6	26585.7	198055.0
2018-03-12	CL	Futures	62.54	62.77	61.1	61.79	537990.0
2018-03-12	GC	Futures	1691.3	1692.5	1680.1	1687.1	220355.0
2018-03-12	ZN	Futures	119.090402	119.354048	118.997351	119.307522	968757.0
2018-03-12	A6	Futures	0.80728	0.81057	0.80728	0.81026	16316.0
2018-03-12	AD	Futures	0.79122	0.79183	0.78915	0.79001	25922.0
2018-03-12	B	Futures	47.27	47.53	46.32	46.88	240034.0
2018-03-12	B6	Futures	1.4407	1.4475	1.4396	1.4465	37945.0
2018-03-12	BFX	Futures	4630.8	4630.8	4630.2	4630.2	32.0
2018-03-12	BR	Futures	0.23203	0.23214	0.23195	0.23214	15.0
2018-03-12	BTC	Futures	13164.4	13788.7	12117.1	12359.9	2732.0
2018-03-12	BZ	Futures	46.72	46.93	45.75	46.3	19165.0
2018-03-12	C	Futures	1620.0	1679.0	1620.0	1672.0	18049.0
2018-03-12	CB	Futures	281.37	281.37	279.95	279.95	31.0
2018-03-12	CC	Futures	1814.0	1885.0	1800.0	1868.0	27048.0
2018-03-12	CNH	Futures	6.4506	6.451	6.4449	6.4449	221.0
2018-03-12	CSC	Futures	3.317	3.319	3.304	3.306	56.0
2018-03-12	CT	Futures	97.12	97.74	95.27	95.73	14497.0
2018-03-12	DC	Futures	26.31	26.37	26.19	26.21	74.0
2018-03-12	DX	Futures	84.58	84.618	84.283	84.34	12127.0
2018-03-12	E1	Futures	1.27728	1.28391	1.27584	1.28319	8480.0
2018-03-12	E6	Futures	1.39674	1.40102	1.39482	1.4	74121.0
2018-03-12	E7	Futures	1.3898	1.3937	1.3876	1.3926	1222.0
2018-03-12	EBM	Futures	175.05	175.59	174.52	175.32	12616.0
2018-03-12	ED	Futures	95.0327	95.0375	95.0132	95.023	333796.0
2018-03-12	ER	Futures	98.337	98.337	98.332	98.337	26010.0
2018-03-12	EW	Futures	2067.8	2079.0	2065.2	2072.0	42928.0
2018-03-12	FBON	Futures	127.3	127.87	127.26	127.84	175.0
2018-03-12	FBTP	Futures	113.09	113.31	112.78	113.29	82067.0
2018-03-12	FBTS	Futures	103.853	103.917	103.825	103.908	46872.0
2018-03-12	FCE	Futures	4658.0	4663.3	4619.2	4636.0	163707.0
2018-03-12	FDAX	Futures	12901.0	12943.5	12820.6	12890.6	112578.0
2018-03-12	FDXM	Futures	12811.2	12854.4	12744.2	12810.6	1195.0
2018-03-12	FESX	Futures	2790.6	2798.1	2773.1	2784.8	1004938.0
2018-03-12	FEU3	Futures	99.016	99.021	99.016	99.021	150.0
2018-03-12	FGBL	Futures	147.74	148.08	147.66	148.0	440187.0
2018-03-12	FGBM	Futures	128.81	129.01	128.8	128.98	336238.0
2018-03-12	FGBS	Futures	112.417	112.462	112.417	112.447	223428.0
2018-03-12	FGBX	Futures	166.06	167.12	165.75	166.79	32391.0
2018-03-12	FMWO	Futures	7132.4	7132.4	7099.7	7112.6	9720.0
2018-03-12	FOAT	Futures	137.0	137.33	136.91	137.23	61059.0
2018-03-12	FTDX	Futures	2679.5	2689.4	2676.5	2680.0	14.0
2018-03-12	FTI	Futures	493.13	494.19	490.33	492.26	10312.0
2018-03-12	FTUK	Futures	6305.5	6334.3	6275.5	6297.1	215016.0
2018-03-12	FVSA	Futures	382.88	395.96	380.5	390.01	10550.0
2018-03-12	FXXP	Futures	322.3	322.3	320.0	321.2	73669.0
2018-03-12	G	Futures	112.85	112.96	112.77	112.83	114767.0
2018-03-12	GF	Futures	312.98	313.307	309.55	310.53	5387.0

> showing 50 of 112 rows — these rows as CSV

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