PREVIEW / futures_daily / 2018-03-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-14.parquet
  size:    9 KB
  rows:    109

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-14	ES	Futures	3009.02	3026.97	2988.63	2994.89	1930552.0
2018-03-14	NQ	Futures	8266.48	8335.24	8235.75	8260.92	470283.0
2018-03-14	YM	Futures	26351.9	26518.3	26006.4	26111.7	275678.0
2018-03-14	CL	Futures	61.14	61.6	60.44	61.28	316240.0
2018-03-14	GC	Futures	1694.6	1699.5	1688.3	1693.2	252583.0
2018-03-14	ZN	Futures	119.462608	119.788288	119.338539	119.648711	1692033.0
2018-03-14	A6	Futures	0.80841	0.81447	0.80779	0.81098	62207.0
2018-03-14	AD	Futures	0.78247	0.7846	0.78121	0.78323	40287.0
2018-03-14	B	Futures	46.72	47.06	46.23	46.83	267591.0
2018-03-14	B6	Futures	1.4529	1.4558	1.4486	1.4534	68170.0
2018-03-14	BTC	Futures	12352.9	13032.6	11354.1	11479.0	2638.0
2018-03-14	BZ	Futures	46.1	46.47	45.67	46.26	29439.0
2018-03-14	C	Futures	1661.0	1686.0	1655.0	1675.0	24160.0
2018-03-14	CB	Futures	279.764	280.197	279.764	280.135	23.0
2018-03-14	CC	Futures	1856.0	1894.0	1847.0	1875.0	20178.0
2018-03-14	CNH	Futures	6.4374	6.4379	6.4238	6.4238	90.0
2018-03-14	CSC	Futures	3.273	3.281	3.262	3.275	83.0
2018-03-14	CT	Futures	95.85	96.41	94.73	95.91	11018.0
2018-03-14	DC	Futures	25.96	26.05	25.79	25.99	172.0
2018-03-14	DX	Futures	84.146	84.34	84.028	84.153	14125.0
2018-03-14	E1	Futures	1.28716	1.28849	1.28126	1.28584	26228.0
2018-03-14	E6	Futures	1.40626	1.40862	1.4013	1.40445	205359.0
2018-03-14	E7	Futures	1.399	1.401	1.3939	1.3969	4101.0
2018-03-14	EBM	Futures	175.59	177.2	175.59	177.2	11018.0
2018-03-14	ED	Futures	95.0035	95.0181	94.9841	95.0084	436350.0
2018-03-14	ER	Futures	98.337	98.337	98.332	98.332	38657.0
2018-03-14	EW	Futures	2059.5	2071.3	2043.2	2047.4	20490.0
2018-03-14	FBON	Futures	128.12	128.12	127.75	128.01	248.0
2018-03-14	FBTP	Futures	113.44	113.49	112.75	113.21	111272.0
2018-03-14	FBTS	Futures	103.917	103.917	103.862	103.89	48648.0
2018-03-14	FCE	Futures	4583.0	4633.3	4583.0	4597.1	108440.0
2018-03-14	FDAX	Futures	12632.3	12785.3	12620.3	12681.0	147590.0
2018-03-14	FDXM	Futures	12556.8	12699.9	12543.4	12595.9	3536.0
2018-03-14	FESX	Futures	2750.6	2773.1	2743.1	2751.5	1556930.0
2018-03-14	FGBL	Futures	148.33	148.66	148.06	148.63	676595.0
2018-03-14	FGBM	Futures	129.08	129.18	128.98	129.16	469002.0
2018-03-14	FGBS	Futures	112.462	112.477	112.432	112.472	309678.0
2018-03-14	FGBX	Futures	167.22	167.95	166.5	167.93	52619.0
2018-03-14	FMWO	Futures	7092.7	7102.1	7034.4	7044.9	24480.0
2018-03-14	FOAT	Futures	137.44	137.74	137.2	137.73	101734.0
2018-03-14	FTDX	Futures	2668.6	2677.5	2646.9	2646.9	3612.0
2018-03-14	FTI	Futures	484.92	488.87	484.46	485.42	32261.0
2018-03-14	FTUK	Futures	6223.4	6264.0	6205.2	6234.0	210236.0
2018-03-14	FVSA	Futures	409.04	420.93	398.34	416.17	10488.0
2018-03-14	FXXP	Futures	317.4	319.8	316.7	317.5	123511.0
2018-03-14	G	Futures	113.0	113.53	112.93	113.5	195853.0
2018-03-14	GF	Futures	311.946	315.485	310.04	310.857	6353.0
2018-03-14	GSCI	Futures	506.33	506.33	502.38	504.33	177.0
2018-03-14	HE	Futures	86.611	86.964	85.551	85.872	20596.0
2018-03-14	HG	Futures	3.7286	3.7976	3.7197	3.7577	113107.0

> showing 50 of 109 rows — these rows as CSV

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