PREVIEW / futures_daily / 2018-09-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-19.parquet
  size:    10 KB
  rows:    116

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-09-19	ES	Futures	3159.18	3165.42	3151.32	3161.35	1361242.0
2018-09-19	NQ	Futures	8745.42	8764.87	8677.47	8742.22	407425.0
2018-09-19	YM	Futures	27718.2	27909.9	27658.2	27865.6	163811.0
2018-09-19	CL	Futures	72.71	74.4	72.61	74.08	606342.0
2018-09-19	GC	Futures	1524.5	1534.8	1523.7	1531.4	233870.0
2018-09-19	ZN	Futures	118.265595	118.374538	118.032145	118.094399	1929508.0
2018-09-19	A6	Futures	0.74331	0.74887	0.74239	0.74784	99246.0
2018-09-19	AD	Futures	0.78033	0.78528	0.77815	0.78417	71673.0
2018-09-19	B	Futures	57.56	57.94	57.22	57.87	275872.0
2018-09-19	B6	Futures	1.3576	1.3646	1.3523	1.3573	126175.0
2018-09-19	BFX	Futures	4303.0	4333.9	4303.0	4333.9	5.0
2018-09-19	BR	Futures	0.183	0.18414	0.183	0.18353	3.0
2018-09-19	BTC	Futures	9017.3	9346.2	8631.1	9117.4	3037.0
2018-09-19	BZ	Futures	57.23	57.7	56.99	57.63	19118.0
2018-09-19	C	Futures	1478.0	1484.0	1449.0	1450.0	7053.0
2018-09-19	CB	Futures	271.267	272.769	271.267	272.769	9.0
2018-09-19	CC	Futures	1574.0	1590.0	1527.0	1533.0	16527.0
2018-09-19	CNH	Futures	6.9371	6.9392	6.9078	6.918	690.0
2018-09-19	CSC	Futures	3.242	3.262	3.24	3.25	89.0
2018-09-19	CT	Futures	89.08	89.84	88.98	89.35	6.0
2018-09-19	DC	Futures	26.59	26.76	26.49	26.74	132.0
2018-09-19	DX	Futures	89.441	89.607	89.213	89.411	15320.0
2018-09-19	E1	Futures	1.23894	1.23989	1.23147	1.23527	24474.0
2018-09-19	E6	Futures	1.30669	1.31158	1.30424	1.30691	194266.0
2018-09-19	E7	Futures	1.3001	1.3051	1.2979	1.3005	3988.0
2018-09-19	EBM	Futures	208.72	211.05	208.2	210.53	19832.0
2018-09-19	ED	Futures	95.0964	95.1013	95.0769	95.0769	314358.0
2018-09-19	ER	Futures	98.372	98.381	98.372	98.377	88390.0
2018-09-19	EW	Futures	2151.6	2159.4	2137.1	2141.5	19265.0
2018-09-19	FBON	Futures	127.97	128.0	127.74	127.79	326.0
2018-09-19	FBTP	Futures	109.51	109.86	108.92	109.02	70044.0
2018-09-19	FBTS	Futures	103.483	103.614	103.22	103.248	56178.0
2018-09-19	FCE	Futures	4822.9	4863.0	4820.2	4851.3	105926.0
2018-09-19	FDAX	Futures	12783.5	12855.0	12764.0	12831.8	56592.0
2018-09-19	FDIV	Futures	146.62	146.62	146.62	146.62	10.0
2018-09-19	FDXM	Futures	12573.4	12630.3	12544.5	12609.6	1880.0
2018-09-19	FESX	Futures	2808.3	2818.4	2799.1	2814.2	1341197.0
2018-09-19	FEU3	Futures	98.996	99.001	98.996	99.001	1.0
2018-09-19	FGBL	Futures	151.85	152.04	151.61	151.8	704493.0
2018-09-19	FGBM	Futures	130.45	130.51	130.33	130.44	477370.0
2018-09-19	FGBS	Futures	112.507	112.527	112.492	112.522	307990.0
2018-09-19	FGBX	Futures	174.3	174.85	173.92	174.22	37373.0
2018-09-19	FMWO	Futures	7250.9	7270.6	7237.0	7262.5	7718.0
2018-09-19	FOAT	Futures	139.83	139.98	139.71	139.77	130025.0
2018-09-19	FTDX	Futures	2850.0	2850.0	2814.6	2814.6	1818.0
2018-09-19	FTI	Futures	504.43	505.26	501.65	503.73	33044.0
2018-09-19	FTUK	Futures	6508.8	6531.6	6471.7	6515.9	201217.0
2018-09-19	FVSA	Futures	262.25	263.11	257.07	257.07	21714.0
2018-09-19	FXXP	Futures	326.9	328.2	326.4	327.6	92325.0
2018-09-19	G	Futures	113.85	113.91	113.41	113.47	267028.0

> showing 50 of 116 rows — these rows as CSV

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