PREVIEW / futures_daily / 2018-09-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-14.parquet
  size:    10 KB
  rows:    113

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-14	ES	Futures	3155.39	3163.79	3147.25	3157.55	1363971.0
2018-09-14	NQ	Futures	8819.47	8858.96	8762.84	8796.82	334597.0
2018-09-14	YM	Futures	27580.3	27654.0	27488.6	27573.9	130785.0
2018-09-14	CL	Futures	71.84	72.96	70.96	71.99	225309.0
2018-09-14	GC	Futures	1529.3	1538.4	1518.0	1522.3	282261.0
2018-09-14	ZN	Futures	118.888127	118.950381	118.639114	118.701368	1462638.0
2018-09-14	A6	Futures	0.74023	0.7427	0.73601	0.73755	112946.0
2018-09-14	AD	Futures	0.77921	0.78017	0.77593	0.77729	79901.0
2018-09-14	B	Futures	57.18	57.54	56.39	56.92	261057.0
2018-09-14	B6	Futures	1.3532	1.3582	1.3481	1.3491	106388.0
2018-09-14	BR	Futures	0.17999	0.18197	0.17999	0.18197	76.0
2018-09-14	BTC	Futures	9224.7	9403.4	9053.0	9331.9	2085.0
2018-09-14	BZ	Futures	56.87	57.28	56.16	56.67	24296.0
2018-09-14	C	Futures	1513.0	1519.0	1465.0	1467.0	14416.0
2018-09-14	CB	Futures	265.559	265.559	265.559	265.559	1.0
2018-09-14	CC	Futures	1620.0	1625.0	1540.0	1550.0	28599.0
2018-09-14	CNH	Futures	6.9095	6.946	6.9087	6.9382	324.0
2018-09-14	CSC	Futures	3.254	3.256	3.242	3.256	62.0
2018-09-14	CT	Futures	91.99	92.1	91.72	91.9	8.0
2018-09-14	DC	Futures	26.76	26.89	26.63	26.89	160.0
2018-09-14	DX	Futures	89.408	89.845	89.222	89.778	26152.0
2018-09-14	E1	Futures	1.2374	1.24025	1.23491	1.23574	27794.0
2018-09-14	E6	Futures	1.30913	1.31258	1.30124	1.30257	283375.0
2018-09-14	E7	Futures	1.3025	1.3066	1.2949	1.2962	5609.0
2018-09-14	EBM	Futures	204.3	207.16	203.26	205.6	24013.0
2018-09-14	ED	Futures	95.0866	95.0915	95.0769	95.0818	313001.0
2018-09-14	ER	Futures	98.372	98.377	98.372	98.377	59719.0
2018-09-14	EW	Futures	2151.3	2164.2	2149.6	2159.5	31140.0
2018-09-14	FBON	Futures	128.3	128.34	128.18	128.2	314.0
2018-09-14	FBTP	Futures	108.05	108.05	107.73	107.78	53700.0
2018-09-14	FBTS	Futures	102.921	102.977	102.874	102.911	30532.0
2018-09-14	FCE	Futures	4803.5	4821.6	4797.7	4814.4	15691.0
2018-09-14	FDAX	Futures	12636.0	12684.6	12619.8	12680.4	86434.0
2018-09-14	FDXM	Futures	12478.4	12520.7	12462.9	12519.2	241.0
2018-09-14	FESX	Futures	2789.8	2800.7	2785.6	2796.5	455121.0
2018-09-14	FEU3	Futures	99.001	99.001	99.001	99.001	48.0
2018-09-14	FGBL	Futures	152.64	152.68	152.18	152.33	558067.0
2018-09-14	FGBM	Futures	130.77	130.8	130.63	130.67	359414.0
2018-09-14	FGBS	Futures	112.562	112.578	112.547	112.547	230308.0
2018-09-14	FGBX	Futures	175.98	175.98	174.69	175.23	36755.0
2018-09-14	FMWO	Futures	7230.2	7234.8	7199.9	7225.5	6867.0
2018-09-14	FOAT	Futures	140.49	140.56	140.12	140.21	127361.0
2018-09-14	FTDX	Futures	2832.3	2859.3	2832.3	2859.3	382.0
2018-09-14	FTI	Futures	501.88	503.04	500.21	501.37	3832.0
2018-09-14	FTUK	Futures	6482.9	6510.6	6473.5	6496.7	103292.0
2018-09-14	FVSA	Futures	263.11	263.98	258.8	259.66	15471.0
2018-09-14	FXXP	Futures	325.6	326.1	324.9	326.0	33286.0
2018-09-14	G	Futures	114.35	114.41	114.05	114.24	208784.0
2018-09-14	GF	Futures	323.899	332.636	323.327	330.504	10640.0
2018-09-14	GSCI	Futures	517.9	523.84	517.85	519.53	3391.0

> showing 50 of 113 rows — these rows as CSV

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