PREVIEW / futures_daily / 2018-03-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-19.parquet
  size:    10 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-19	ES	Futures	2997.33	2997.61	2933.17	2960.9	1986809.0
2018-03-19	NQ	Futures	8243.36	8243.36	7983.82	8092.67	571979.0
2018-03-19	YM	Futures	26309.7	26318.2	25767.2	26009.5	272836.0
2018-03-19	CL	Futures	62.57	62.71	61.71	62.39	557264.0
2018-03-19	GC	Futures	1677.0	1685.6	1670.0	1683.3	300474.0
2018-03-19	ZN	Futures	119.431591	119.602185	119.183454	119.493625	1377324.0
2018-03-19	A6	Futures	0.79339	0.79473	0.79072	0.79432	112652.0
2018-03-19	AD	Futures	0.77392	0.77686	0.77225	0.7763	81791.0
2018-03-19	B	Futures	47.64	47.91	47.19	47.67	272416.0
2018-03-19	B6	Futures	1.4501	1.465	1.4468	1.461	173315.0
2018-03-19	BR	Futures	0.22856	0.23077	0.22856	0.2305	15.0
2018-03-19	BTC	Futures	11479.0	12096.3	11236.2	11652.4	2746.0
2018-03-19	BZ	Futures	47.14	47.3	46.62	47.09	28050.0
2018-03-19	C	Futures	1684.0	1685.0	1615.0	1616.0	19706.0
2018-03-19	CB	Futures	278.622	278.622	277.077	277.077	31.0
2018-03-19	CC	Futures	1860.0	1884.0	1790.0	1794.0	25324.0
2018-03-19	CNH	Futures	6.4472	6.4472	6.437	6.437	11.0
2018-03-19	CSC	Futures	3.308	3.325	3.285	3.312	50.0
2018-03-19	CT	Futures	95.39	95.39	93.32	93.37	16728.0
2018-03-19	DC	Futures	26.37	26.42	26.22	26.4	227.0
2018-03-19	DX	Futures	84.656	84.825	84.241	84.252	25842.0
2018-03-19	E1	Futures	1.27512	1.27873	1.27102	1.27849	19579.0
2018-03-19	E6	Futures	1.3942	1.40203	1.39048	1.40181	229672.0
2018-03-19	E7	Futures	1.3867	1.3945	1.383	1.3944	3107.0
2018-03-19	EBM	Futures	175.59	175.86	174.25	174.25	33122.0
2018-03-19	ED	Futures	94.9792	95.0084	94.9743	95.0035	400778.0
2018-03-19	ER	Futures	98.337	98.342	98.332	98.342	90846.0
2018-03-19	EW	Futures	2053.9	2053.9	2016.5	2034.5	18403.0
2018-03-19	FBON	Futures	128.39	128.74	128.23	128.63	329.0
2018-03-19	FBTP	Futures	113.56	113.75	113.27	113.68	80488.0
2018-03-19	FBTS	Futures	103.917	103.945	103.89	103.936	32360.0
2018-03-19	FCE	Futures	4625.8	4635.5	4568.9	4594.5	70308.0
2018-03-19	FDAX	Futures	12826.5	12861.3	12635.3	12691.9	106639.0
2018-03-19	FDXM	Futures	12717.4	12747.3	12525.9	12578.9	34607.0
2018-03-19	FESX	Futures	2776.4	2784.8	2739.0	2751.5	1041774.0
2018-03-19	FEU3	Futures	99.026	99.026	99.021	99.021	500.0
2018-03-19	FGBL	Futures	148.84	148.97	148.37	148.9	655359.0
2018-03-19	FGBM	Futures	129.28	129.32	129.07	129.27	463725.0
2018-03-19	FGBS	Futures	112.507	112.517	112.462	112.507	307707.0
2018-03-19	FGBX	Futures	168.67	169.17	167.91	169.02	49009.0
2018-03-19	FMWO	Futures	7051.9	7054.2	6981.8	6991.2	4152.0
2018-03-19	FOAT	Futures	137.87	138.01	137.55	137.97	112496.0
2018-03-19	FTDX	Futures	2648.8	2658.7	2602.3	2620.1	180.0
2018-03-19	FTI	Futures	489.83	490.84	483.77	485.88	26599.0
2018-03-19	FTUK	Futures	6236.2	6245.9	6129.2	6144.7	118744.0
2018-03-19	FVSA	Futures	392.39	431.63	387.63	422.12	35213.0
2018-03-19	FXXP	Futures	319.5	319.5	314.9	316.4	26475.0
2018-03-19	G	Futures	113.33	113.43	112.75	113.37	231860.0
2018-03-19	GF	Futures	306.555	306.773	300.566	301.001	6821.0
2018-03-19	GSCI	Futures	505.64	506.5	503.41	504.27	34.0

> showing 50 of 112 rows — these rows as CSV

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