PREVIEW / futures_daily / 2020-03-20

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-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-03-20	ES	Futures	2601.35	2765.11	2500.66	2532.19	3075997.0
2020-03-20	NQ	Futures	8228.0	8746.19	7900.12	7989.54	562616.0
2020-03-20	YM	Futures	20896.1	22282.2	20087.3	20316.7	286183.0
2020-03-20	CL	Futures	25.36	28.24	22.19	22.43	1133808.0
2020-03-20	GC	Futures	1794.3	1852.5	1777.1	1810.1	269974.0
2020-03-20	ZN	Futures	133.302043	135.787178	133.055073	135.077139	1686753.0
2020-03-20	A6	Futures	0.5896	0.61508	0.5822	0.59638	81587.0
2020-03-20	AD	Futures	0.69916	0.71654	0.69749	0.70251	84435.0
2020-03-20	ALI	Futures	2004.01	2006.74	1942.72	1943.32	328.0
2020-03-20	B	Futures	23.9	26.32	22.81	22.95	313837.0
2020-03-20	B6	Futures	1.1673	1.2132	1.161	1.1762	145202.0
2020-03-20	BR	Futures	0.16497	0.16501	0.16271	0.16271	9.0
2020-03-20	BTC	Futures	9162.5	10148.1	8271.8	9067.5	6787.0
2020-03-20	BZ	Futures	23.18	25.61	22.18	22.34	51866.0
2020-03-20	C	Futures	1677.0	1693.0	1638.0	1690.0	8782.0
2020-03-20	CB	Futures	200.758	207.283	200.758	205.833	101.0
2020-03-20	CC	Futures	1468.0	1487.0	1430.0	1460.0	27298.0
2020-03-20	CNH	Futures	7.0928	7.0928	7.0111	7.0639	1002.0
2020-03-20	CSC	Futures	3.025	3.046	3.011	3.031	149.0
2020-03-20	CT	Futures	53.26	54.25	51.22	51.68	22807.0
2020-03-20	DC	Futures	24.54	24.78	24.44	24.68	175.0
2020-03-20	DX	Futures	100.353	100.396	98.54	100.084	23159.0
2020-03-20	E1	Futures	1.1588	1.17406	1.15527	1.15629	41944.0
2020-03-20	E6	Futures	1.15151	1.16843	1.14731	1.14909	251136.0
2020-03-20	E7	Futures	1.1458	1.1623	1.1413	1.1431	17512.0
2020-03-20	EBM	Futures	216.69	217.81	211.93	214.17	23837.0
2020-03-20	ED	Futures	96.0294	96.2083	96.0101	96.1551	555406.0
2020-03-20	ER	Futures	98.313	98.347	98.279	98.328	161792.0
2020-03-20	EW	Futures	1359.4	1447.7	1304.1	1326.3	11141.0
2020-03-20	FBON	Futures	139.69	140.75	138.67	140.38	371.0
2020-03-20	FBTP	Futures	124.91	126.19	124.31	124.82	79090.0
2020-03-20	FBTS	Futures	107.124	107.403	106.864	106.999	57071.0
2020-03-20	FCE	Futures	3841.5	3978.0	3748.0	3898.1	119410.0
2020-03-20	FDAX	Futures	8975.7	9704.4	8969.3	9341.6	133161.0
2020-03-20	FDIV	Futures	102.25	102.25	101.18	101.18	23.0
2020-03-20	FDXM	Futures	9023.4	9752.4	9018.0	9386.3	64382.0
2020-03-20	FESX	Futures	2156.9	2350.6	2152.3	2256.9	2573908.0
2020-03-20	FEU3	Futures	99.04	99.06	99.04	99.06	200.0
2020-03-20	FGBL	Futures	163.82	166.06	163.81	165.66	543721.0
2020-03-20	FGBM	Futures	132.89	133.86	132.86	133.6	335572.0
2020-03-20	FGBS	Futures	112.689	112.885	112.649	112.79	252502.0
2020-03-20	FGBX	Futures	219.31	225.29	219.31	224.38	45464.0
2020-03-20	FMWO	Futures	6058.6	6146.9	5666.9	5822.2	4433.0
2020-03-20	FOAT	Futures	150.49	151.04	149.72	150.71	136451.0
2020-03-20	FTDX	Futures	2448.7	2450.2	2335.5	2366.8	299.0
2020-03-20	FTI	Futures	407.97	419.97	387.24	403.42	43237.0
2020-03-20	FTUK	Futures	4815.2	5064.2	4670.0	4806.7	230456.0
2020-03-20	FVSA	Futures	486.11	502.31	435.69	470.35	26078.0
2020-03-20	FXXP	Futures	271.1	275.8	253.9	264.7	148675.0
2020-03-20	G	Futures	120.73	123.35	120.73	122.65	236278.0

> showing 50 of 120 rows — these rows as CSV

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