PREVIEW / futures_daily / 2018-11-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-14.parquet
  size:    10 KB
  rows:    115

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-11-14	ES	Futures	2962.07	2980.51	2913.27	2926.55	2295505.0
2018-11-14	NQ	Futures	7970.1	8048.79	7835.65	7861.5	731312.0
2018-11-14	YM	Futures	26713.6	26841.0	26243.9	26372.4	294560.0
2018-11-14	CL	Futures	58.71	60.89	58.51	59.72	417864.0
2018-11-14	GC	Futures	1524.5	1542.7	1518.5	1533.7	277865.0
2018-11-14	ZN	Futures	118.032145	118.514608	117.907639	118.281158	2188936.0
2018-11-14	A6	Futures	0.74301	0.74661	0.73992	0.74589	118883.0
2018-11-14	AD	Futures	0.7644	0.76602	0.76273	0.76496	84090.0
2018-11-14	B	Futures	48.5	49.99	48.06	48.87	379718.0
2018-11-14	B6	Futures	1.3422	1.3465	1.3265	1.3423	270534.0
2018-11-14	BFX	Futures	4144.4	4144.4	4131.6	4131.6	17.0
2018-11-14	BR	Futures	0.1998	0.20197	0.19923	0.20071	3594.0
2018-11-14	BTC	Futures	9105.1	9105.1	7570.7	7766.1	8940.0
2018-11-14	BZ	Futures	47.92	49.64	47.72	48.54	47372.0
2018-11-14	C	Futures	1474.0	1482.0	1450.0	1465.0	4419.0
2018-11-14	CB	Futures	266.761	268.563	266.761	267.962	28.0
2018-11-14	CC	Futures	1552.0	1555.0	1505.0	1523.0	35172.0
2018-11-14	CNH	Futures	6.9869	6.9964	6.9838	6.9859	955.0
2018-11-14	CSC	Futures	2.974	3.002	2.974	2.98	77.0
2018-11-14	CT	Futures	85.4	86.19	85.15	85.75	18349.0
2018-11-14	DC	Futures	24.74	25.01	24.73	24.86	456.0
2018-11-14	DX	Futures	92.063	92.395	91.754	91.824	37707.0
2018-11-14	E1	Futures	1.18027	1.18371	1.17624	1.183	27691.0
2018-11-14	E6	Futures	1.25915	1.26488	1.25543	1.26377	247663.0
2018-11-14	E7	Futures	1.253	1.2587	1.2493	1.2576	5604.0
2018-11-14	EBM	Futures	209.24	209.76	208.72	208.98	21302.0
2018-11-14	ED	Futures	94.9841	94.9939	94.9743	94.989	333192.0
2018-11-14	ER	Futures	98.381	98.386	98.381	98.386	11800.0
2018-11-14	EW	Futures	1953.9	1971.1	1923.7	1937.0	19024.0
2018-11-14	FBON	Futures	127.31	127.31	127.08	127.1	340.0
2018-11-14	FBTP	Futures	104.17	104.68	103.82	104.33	82208.0
2018-11-14	FBTS	Futures	102.302	102.537	102.227	102.424	66192.0
2018-11-14	FCE	Futures	4531.3	4580.1	4483.9	4522.8	143254.0
2018-11-14	FDAX	Futures	12018.5	12157.3	11888.6	11986.4	135608.0
2018-11-14	FDXM	Futures	11810.9	11946.2	11682.7	11778.8	65321.0
2018-11-14	FESX	Futures	2688.2	2715.9	2663.0	2685.7	1375879.0
2018-11-14	FGBL	Futures	153.47	153.57	153.09	153.26	709577.0
2018-11-14	FGBM	Futures	131.21	131.29	131.09	131.17	386314.0
2018-11-14	FGBS	Futures	112.703	112.713	112.673	112.683	192999.0
2018-11-14	FGBX	Futures	178.02	178.02	176.77	177.21	58156.0
2018-11-14	FMWO	Futures	6727.2	6793.3	6700.6	6727.2	5692.0
2018-11-14	FOAT	Futures	140.44	140.46	140.15	140.25	118787.0
2018-11-14	FTDX	Futures	2534.2	2579.9	2498.8	2543.0	435.0
2018-11-14	FTI	Futures	487.29	491.37	483.2	487.9	38365.0
2018-11-14	FTUK	Futures	6280.9	6340.3	6218.3	6267.5	131224.0
2018-11-14	FVSA	Futures	342.72	352.8	333.65	342.72	31687.0
2018-11-14	FXXP	Futures	313.9	316.0	311.3	313.3	49368.0
2018-11-14	G	Futures	114.59	114.92	114.43	114.56	297016.0
2018-11-14	GF	Futures	315.84	318.585	314.549	316.379	6458.0
2018-11-14	GSCI	Futures	488.4	489.7	486.2	488.07	49.0

> showing 50 of 115 rows — these rows as CSV

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