PREVIEW / futures_daily / 2019-01-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-23.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-01-23	ES	Futures	2848.23	2873.13	2828.47	2856.35	1576181.0
2019-01-23	NQ	Futures	7701.38	7785.02	7632.2	7716.72	515044.0
2019-01-23	YM	Futures	25725.8	26024.3	25605.6	25895.7	250043.0
2019-01-23	CL	Futures	55.07	55.78	53.93	54.72	702866.0
2019-01-23	GC	Futures	1618.6	1620.4	1609.9	1617.8	217130.0
2019-01-23	ZN	Futures	120.989084	121.051329	120.724542	120.895716	1383476.0
2019-01-23	A6	Futures	0.73435	0.73672	0.73394	0.73652	66681.0
2019-01-23	AD	Futures	0.75919	0.76192	0.75802	0.75939	58444.0
2019-01-23	B	Futures	44.4	45.08	43.61	44.25	222753.0
2019-01-23	B6	Futures	1.3342	1.3468	1.3323	1.3452	114522.0
2019-01-23	BFX	Futures	4037.9	4047.3	4037.9	4047.3	7.0
2019-01-23	BR	Futures	0.20962	0.21173	0.20882	0.2109	322.0
2019-01-23	BTC	Futures	5226.5	5285.0	5131.4	5168.0	5040.0
2019-01-23	BZ	Futures	44.03	44.59	43.16	43.78	16700.0
2019-01-23	C	Futures	1431.0	1433.0	1411.0	1421.0	12872.0
2019-01-23	CB	Futures	272.714	275.113	272.714	272.714	38.0
2019-01-23	CC	Futures	1549.0	1560.0	1534.0	1547.0	18944.0
2019-01-23	CNH	Futures	6.8273	6.8291	6.7996	6.8062	1006.0
2019-01-23	CSC	Futures	2.732	2.732	2.682	2.682	110.0
2019-01-23	CT	Futures	79.66	80.91	79.5	80.09	12432.0
2019-01-23	DC	Futures	23.22	23.23	22.75	22.8	259.0
2019-01-23	DX	Futures	91.517	91.598	91.274	91.338	15628.0
2019-01-23	E1	Futures	1.18465	1.18889	1.18289	1.18795	15691.0
2019-01-23	E6	Futures	1.2611	1.26475	1.25983	1.26354	135435.0
2019-01-23	E7	Futures	1.2551	1.2585	1.2537	1.2574	2384.0
2019-01-23	EBM	Futures	211.8	212.57	211.54	211.54	17522.0
2019-01-23	ED	Futures	95.0135	95.0232	95.0086	95.0135	149621.0
2019-01-23	ER	Futures	98.401	98.406	98.396	98.401	42023.0
2019-01-23	EW	Futures	1906.2	1921.4	1887.9	1904.3	11974.0
2019-01-23	FBON	Futures	130.68	130.8	130.56	130.77	348.0
2019-01-23	FBTP	Futures	111.71	112.05	111.53	111.85	71673.0
2019-01-23	FBTS	Futures	105.247	105.351	105.19	105.294	39881.0
2019-01-23	FCE	Futures	4327.7	4365.3	4313.8	4333.1	75672.0
2019-01-23	FDAX	Futures	11613.5	11699.2	11562.0	11613.5	99676.0
2019-01-23	FDIV	Futures	135.63	136.39	135.4	135.4	31.0
2019-01-23	FDXM	Futures	11573.2	11671.7	11534.4	11585.2	44169.0
2019-01-23	FESX	Futures	2639.8	2669.7	2635.5	2650.9	894632.0
2019-01-23	FGBL	Futures	156.55	156.66	156.25	156.47	604097.0
2019-01-23	FGBM	Futures	132.26	132.29	132.1	132.17	413591.0
2019-01-23	FGBS	Futures	112.734	112.734	112.688	112.698	317577.0
2019-01-23	FGBX	Futures	185.32	185.69	184.77	185.26	31012.0
2019-01-23	FMWO	Futures	6642.6	6688.1	6617.0	6641.5	4160.0
2019-01-23	FOAT	Futures	142.26	142.44	142.14	142.3	103495.0
2019-01-23	FTDX	Futures	2549.3	2583.1	2538.9	2572.1	187.0
2019-01-23	FTI	Futures	475.85	481.9	473.82	478.11	31893.0
2019-01-23	FTUK	Futures	6201.6	6226.6	6147.4	6178.3	101453.0
2019-01-23	FVSA	Futures	332.95	342.33	317.0	331.07	38359.0
2019-01-23	FXXP	Futures	309.5	312.0	308.4	310.1	47351.0
2019-01-23	G	Futures	116.51	116.51	116.01	116.27	188179.0
2019-01-23	GF	Futures	309.987	314.525	308.948	314.142	7112.0

> showing 50 of 116 rows — these rows as CSV

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