PREVIEW / futures_daily / 2018-01-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-12.parquet
  size:    9 KB
  rows:    90

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-01-12	ES	Futures	3009.3	3032.39	3007.12	3031.03	1357120.0
2018-01-12	NQ	Futures	7876.77	7937.96	7850.71	7935.03	288871.0
2018-01-12	YM	Futures	26933.6	27222.6	26925.2	27209.9	152582.0
2018-01-12	CL	Futures	63.48	64.39	62.96	64.21	323616.0
2018-01-12	GC	Futures	1678.0	1698.8	1674.5	1692.4	365195.0
2018-01-12	ZN	Futures	121.419845	121.496976	121.065042	121.373566	1652546.0
2018-01-12	AD	Futures	0.81153	0.81559	0.80853	0.81371	89885.0
2018-01-12	B	Futures	49.51	50.07	49.11	50.03	302098.0
2018-01-12	B6	Futures	1.4114	1.4325	1.4108	1.4315	201323.0
2018-01-12	BTC	Futures	16649.2	18032.4	16457.1	17859.5	787.0
2018-01-12	C	Futures	1269.0	1281.0	1251.0	1262.0	8383.0
2018-01-12	CB	Futures	269.634	269.696	269.634	269.696	22.0
2018-01-12	CC	Futures	1437.0	1450.0	1413.0	1428.0	19043.0
2018-01-12	CNH	Futures	6.6435	6.6476	6.61	6.61	99.0
2018-01-12	CSC	Futures	3.127	3.133	3.099	3.103	143.0
2018-01-12	CT	Futures	96.77	98.87	93.79	95.4	41908.0
2018-01-12	DX	Futures	85.937	86.05	85.017	85.209	40561.0
2018-01-12	E1	Futures	1.24985	1.2615	1.24803	1.25883	41069.0
2018-01-12	E6	Futures	1.36976	1.3905	1.36907	1.38631	400925.0
2018-01-12	E7	Futures	1.3626	1.3835	1.3622	1.3794	9071.0
2018-01-12	EBM	Futures	171.54	171.81	169.38	169.65	26539.0
2018-01-12	ED	Futures	95.3456	95.3505	95.3213	95.331	469190.0
2018-01-12	ER	Futures	98.332	98.337	98.328	98.332	108097.0
2018-01-12	EW	Futures	2080.3	2089.0	2077.7	2085.7	12260.0
2018-01-12	FBON	Futures	125.78	126.31	125.71	126.18	307.0
2018-01-12	FBTP	Futures	110.68	111.53	110.68	111.35	121381.0
2018-01-12	FBTS	Futures	103.503	103.567	103.467	103.512	81188.0
2018-01-12	FCE	Futures	4908.5	4918.7	4889.3	4915.6	831.0
2018-01-12	FDAX	Futures	13739.8	13755.9	13650.6	13720.1	75804.0
2018-01-12	FDIV	Futures	153.02	153.02	152.44	152.44	40.0
2018-01-12	FDXM	Futures	13763.6	13779.2	13674.2	13743.3	22892.0
2018-01-12	FESX	Futures	2937.7	2945.8	2930.3	2939.3	881857.0
2018-01-12	FGBL	Futures	148.68	148.89	148.39	148.64	781171.0
2018-01-12	FGBM	Futures	128.9	128.98	128.7	128.82	898928.0
2018-01-12	FGBS	Futures	112.271	112.281	112.231	112.251	557628.0
2018-01-12	FGBX	Futures	166.36	167.53	166.21	166.91	69970.0
2018-01-12	FMWO	Futures	7179.1	7215.3	7179.1	7210.6	945.0
2018-01-12	FOAT	Futures	137.31	137.55	137.13	137.3	109582.0
2018-01-12	FTDX	Futures	2649.6	2658.1	2627.6	2650.1	361.0
2018-01-12	FTI	Futures	518.89	519.68	516.84	519.68	1388.0
2018-01-12	FTUK	Futures	6742.8	6758.1	6721.0	6745.8	90137.0
2018-01-12	FVSA	Futures	248.63	249.49	244.33	246.05	22067.0
2018-01-12	FXXP	Futures	338.3	338.9	337.1	338.2	31566.0
2018-01-12	G	Futures	114.18	114.3	113.67	113.99	219484.0
2018-01-12	GSCI	Futures	521.44	523.64	520.0	523.52	2455.0
2018-01-12	HG	Futures	3.8611	3.8892	3.8497	3.8527	84099.0
2018-01-12	HRC	Futures	1555.4	1560.0	1555.4	1560.0	0.0
2018-01-12	J1	Futures	0.0110016	0.0110339	0.0109565	0.0110205	205486.0
2018-01-12	J7	Futures	0.010966	0.010995	0.01092	0.010984	816.0
2018-01-12	JB	Futures	137.96	137.98	137.87	137.92	1045.0

> showing 50 of 90 rows — these rows as CSV

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