PREVIEW / futures_daily / 2020-03-18

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-18.parquet
  size:    10 KB
  rows:    119

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-18	ES	Futures	2730.25	2751.0	2502.87	2657.23	3255696.0
2020-03-18	NQ	Futures	8418.59	8460.73	7807.26	8260.67	512012.0
2020-03-18	YM	Futures	22104.0	22242.7	20024.3	21184.2	228929.0
2020-03-18	CL	Futures	27.06	27.35	20.34	20.64	1001245.0
2020-03-18	GC	Futures	1862.5	1886.2	1796.3	1801.9	435187.0
2020-03-18	ZN	Futures	133.703369	134.367101	132.391341	132.453083	2077161.0
2020-03-18	A6	Futures	0.61754	0.6196	0.5859	0.59381	106439.0
2020-03-18	AD	Futures	0.71416	0.71583	0.69202	0.69602	100958.0
2020-03-18	ALI	Futures	1977.91	1995.81	1977.91	1995.81	170.0
2020-03-18	B	Futures	24.16	24.85	20.86	21.16	348397.0
2020-03-18	B6	Futures	1.2269	1.2336	1.1648	1.1779	163160.0
2020-03-18	BR	Futures	0.15796	0.16103	0.15571	0.15714	88.0
2020-03-18	BTC	Futures	7943.2	7994.3	7286.2	7797.2	8746.0
2020-03-18	BZ	Futures	23.73	24.17	20.29	20.6	47500.0
2020-03-18	C	Futures	1693.0	1740.0	1693.0	1721.0	10674.0
2020-03-18	CB	Futures	196.325	199.643	190.219	190.553	88.0
2020-03-18	CC	Futures	1518.0	1548.0	1487.0	1496.0	27128.0
2020-03-18	CNH	Futures	6.9732	7.0321	6.9647	7.0264	1526.0
2020-03-18	CSC	Futures	3.025	3.025	2.985	2.985	226.0
2020-03-18	CT	Futures	55.8	56.41	53.58	54.53	28005.0
2020-03-18	DC	Futures	24.71	24.71	24.08	24.11	377.0
2020-03-18	DX	Futures	96.403	98.67	96.103	98.19	26162.0
2020-03-18	E1	Futures	1.19251	1.19786	1.17406	1.18078	35677.0
2020-03-18	E6	Futures	1.18778	1.1924	1.16612	1.17434	237544.0
2020-03-18	E7	Futures	1.1819	1.1861	1.16	1.1683	12687.0
2020-03-18	EBM	Futures	199.61	207.17	199.33	206.05	31971.0
2020-03-18	ED	Futures	96.2179	96.2904	96.1599	96.1648	622060.0
2020-03-18	ER	Futures	98.386	98.421	98.352	98.372	109358.0
2020-03-18	EW	Futures	1459.7	1460.5	1264.0	1323.7	26291.0
2020-03-18	FBON	Futures	135.04	135.19	130.49	133.88	621.0
2020-03-18	FBTP	Futures	116.01	119.49	110.81	117.82	156101.0
2020-03-18	FBTS	Futures	104.161	105.277	102.718	104.738	108095.0
2020-03-18	FCE	Futures	3658.0	3776.1	3499.6	3622.6	83957.0
2020-03-18	FDAX	Futures	9148.6	9387.1	8631.4	8944.0	50194.0
2020-03-18	FDIV	Futures	96.22	96.22	95.24	95.24	700.0
2020-03-18	FDXM	Futures	9259.3	9415.5	8678.0	8986.7	5959.0
2020-03-18	FESX	Futures	2178.0	2232.2	2047.7	2123.9	1995447.0
2020-03-18	FEU3	Futures	99.104	99.104	99.104	99.104	200.0
2020-03-18	FGBL	Futures	166.6	166.6	163.54	164.07	880185.0
2020-03-18	FGBM	Futures	134.53	134.53	133.09	133.48	482578.0
2020-03-18	FGBS	Futures	113.167	113.167	112.87	113.016	374619.0
2020-03-18	FGBX	Futures	228.84	229.01	219.14	219.95	59843.0
2020-03-18	FMWO	Futures	5882.2	5928.0	5583.3	5792.8	10229.0
2020-03-18	FOAT	Futures	148.16	148.67	145.28	147.56	186216.0
2020-03-18	FTDX	Futures	2263.7	2263.7	2209.6	2228.8	275.0
2020-03-18	FTI	Futures	378.52	388.37	365.35	376.89	13765.0
2020-03-18	FTUK	Futures	4859.5	4911.9	4637.4	4777.9	192595.0
2020-03-18	FVSA	Futures	579.73	660.29	534.72	591.43	38455.0
2020-03-18	FXXP	Futures	236.2	260.5	231.6	253.4	129545.0
2020-03-18	G	Futures	121.65	121.81	119.08	120.13	279974.0

> showing 50 of 119 rows — these rows as CSV

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