PREVIEW / futures_daily / 2020-04-20

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-20.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
2020-04-20	ES	Futures	3166.21	3181.7	3102.86	3105.35	1566934.0
2020-04-20	NQ	Futures	10088.1	10141.41	9959.12	9964.86	427981.0
2020-04-20	YM	Futures	25703.2	25825.9	25012.8	25062.9	208145.0
2020-04-20	CL	Futures	18.43	18.55	15.03	15.21	1319926.0
2020-04-20	GC	Futures	2053.1	2083.9	2043.4	2075.2	186912.0
2020-04-20	ZN	Futures	137.33074	137.546839	137.238127	137.423354	741098.0
2020-04-20	A6	Futures	0.65401	0.6573	0.65062	0.65206	57700.0
2020-04-20	AD	Futures	0.72333	0.72333	0.71639	0.71725	54906.0
2020-04-20	ALI	Futures	1825.71	1826.01	1825.71	1826.01	6.0
2020-04-20	B	Futures	21.49	21.64	19.43	19.59	361825.0
2020-04-20	B6	Futures	1.2695	1.2698	1.2608	1.2636	46606.0
2020-04-20	BFX	Futures	2986.3	2986.3	2980.3	2980.3	10.0
2020-04-20	BR	Futures	0.15452	0.15521	0.15374	0.15411	227.0
2020-04-20	BTC	Futures	10213.2	10291.2	9596.1	9638.7	4302.0
2020-04-20	BZ	Futures	20.84	20.98	18.86	19.0	46467.0
2020-04-20	C	Futures	1733.0	1751.0	1729.0	1748.0	1475.0
2020-04-20	CB	Futures	152.799	152.799	151.684	152.521	56.0
2020-04-20	CC	Futures	1538.0	1543.0	1519.0	1541.0	9708.0
2020-04-20	CNH	Futures	7.0171	7.0306	7.0138	7.0305	350.0
2020-04-20	CSC	Futures	2.387	2.402	2.31	2.327	56.0
2020-04-20	CT	Futures	50.81	52.25	50.56	52.02	4548.0
2020-04-20	DC	Futures	19.42	19.53	18.56	18.94	488.0
2020-04-20	DX	Futures	96.475	96.876	96.456	96.754	13170.0
2020-04-20	E1	Futures	1.17941	1.1818	1.17611	1.17873	13721.0
2020-04-20	E6	Futures	1.17053	1.17279	1.16671	1.16897	101892.0
2020-04-20	E7	Futures	1.1645	1.1668	1.1607	1.1629	5679.0
2020-04-20	EBM	Futures	225.09	230.69	225.09	228.17	20157.0
2020-04-20	ED	Futures	96.2469	96.2518	96.1889	96.1938	283112.0
2020-04-20	ER	Futures	98.225	98.23	98.195	98.205	78272.0
2020-04-20	ESG	Futures	255.31	258.71	254.4	254.55	287.0
2020-04-20	EW	Futures	1644.4	1653.2	1611.3	1618.5	13334.0
2020-04-20	FBON	Futures	139.02	139.26	138.28	138.48	390.0
2020-04-20	FBTP	Futures	123.02	123.02	121.35	121.69	70359.0
2020-04-20	FBTS	Futures	106.393	106.393	105.989	106.114	48959.0
2020-04-20	FCE	Futures	4360.6	4372.2	4255.0	4355.7	35351.0
2020-04-20	FDAX	Futures	11259.1	11388.2	11034.9	11265.5	85384.0
2020-04-20	FDXM	Futures	11323.0	11444.2	11088.2	11319.3	60085.0
2020-04-20	FESX	Futures	2625.0	2656.2	2571.8	2631.4	1055239.0
2020-04-20	FEU3	Futures	98.942	98.942	98.942	98.942	100.0
2020-04-20	FGBL	Futures	167.82	168.17	167.38	167.59	392721.0
2020-04-20	FGBM	Futures	134.58	134.73	134.38	134.45	278942.0
2020-04-20	FGBS	Futures	112.875	112.91	112.82	112.845	252102.0
2020-04-20	FGBX	Futures	226.52	227.54	225.12	225.91	33078.0
2020-04-20	FMWO	Futures	6971.5	6983.3	6857.4	6963.3	7825.0
2020-04-20	FOAT	Futures	151.97	152.1	151.27	151.52	94352.0
2020-04-20	FTDX	Futures	2927.4	2934.0	2889.5	2934.0	36.0
2020-04-20	FTI	Futures	474.21	478.2	466.9	477.11	29100.0
2020-04-20	FTUK	Futures	5452.7	5500.8	5366.4	5457.4	86289.0
2020-04-20	FVSA	Futures	321.82	344.32	319.57	330.82	11286.0
2020-04-20	FXXP	Futures	308.4	309.3	302.3	308.0	68927.0

> showing 50 of 120 rows — these rows as CSV

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