PREVIEW / futures_daily / 2018-12-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-21.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-12-21	ES	Futures	2690.43	2715.34	2608.42	2613.02	3016623.0
2018-12-21	NQ	Futures	7322.79	7337.84	6981.25	7014.83	862689.0
2018-12-21	YM	Futures	24301.9	24522.4	23594.2	23634.2	425491.0
2018-12-21	CL	Futures	48.51	49.05	47.33	47.82	694003.0
2018-12-21	GC	Futures	1592.0	1595.4	1583.9	1585.2	212775.0
2018-12-21	ZN	Futures	120.444438	120.646735	120.397754	120.537806	1417613.0
2018-12-21	A6	Futures	0.73363	0.73476	0.72498	0.72673	101664.0
2018-12-21	AD	Futures	0.75144	0.7519	0.74562	0.74648	98616.0
2018-12-21	B	Futures	40.36	40.63	38.76	39.52	226344.0
2018-12-21	B6	Futures	1.3054	1.3093	1.3009	1.3028	82092.0
2018-12-21	BR	Futures	0.20511	0.20511	0.20372	0.2042	7.0
2018-12-21	BTC	Futures	6164.4	6309.4	5500.7	5760.1	5616.0
2018-12-21	BZ	Futures	39.74	40.08	38.28	39.01	40930.0
2018-12-21	C	Futures	1488.0	1489.0	1452.0	1473.0	9863.0
2018-12-21	CB	Futures	271.924	273.26	271.924	271.924	7.0
2018-12-21	CC	Futures	1571.0	1578.0	1530.0	1565.0	14365.0
2018-12-21	CNH	Futures	6.9055	6.9393	6.9005	6.9358	933.0
2018-12-21	CSC	Futures	2.804	2.808	2.79	2.791	209.0
2018-12-21	CT	Futures	81.76	82.35	79.6	79.72	24738.0
2018-12-21	DC	Futures	23.91	24.04	23.78	23.84	218.0
2018-12-21	DX	Futures	91.436	92.089	91.298	91.989	20134.0
2018-12-21	E1	Futures	1.201	1.20229	1.19041	1.19136	25806.0
2018-12-21	E6	Futures	1.27453	1.27707	1.26387	1.26536	184531.0
2018-12-21	E7	Futures	1.268	1.2709	1.2578	1.2592	5282.0
2018-12-21	EBM	Futures	211.8	212.57	210.0	210.25	22235.0
2018-12-21	ED	Futures	94.9354	94.95	94.9305	94.9402	215369.0
2018-12-21	ER	Futures	98.396	98.401	98.396	98.401	32045.0
2018-12-21	EW	Futures	1755.9	1775.0	1712.2	1718.1	22442.0
2018-12-21	FBON	Futures	129.99	130.1	129.89	129.96	362.0
2018-12-21	FBTP	Futures	111.61	111.77	110.73	111.08	46124.0
2018-12-21	FBTS	Futures	104.831	104.831	104.547	104.603	30607.0
2018-12-21	FCE	Futures	4151.2	4170.7	4106.8	4165.8	127762.0
2018-12-21	FDAX	Futures	11140.6	11192.1	11019.8	11153.2	133103.0
2018-12-21	FDIV	Futures	129.93	130.74	129.93	130.74	4.0
2018-12-21	FDXM	Futures	11080.5	11164.3	10992.4	11126.1	68335.0
2018-12-21	FESX	Futures	2550.0	2556.0	2515.9	2547.5	1856589.0
2018-12-21	FGBL	Futures	155.49	155.49	155.24	155.32	385743.0
2018-12-21	FGBM	Futures	131.69	131.8	131.67	131.75	217089.0
2018-12-21	FGBS	Futures	112.668	112.708	112.643	112.688	160819.0
2018-12-21	FGBX	Futures	184.39	184.39	183.15	183.62	30697.0
2018-12-21	FMWO	Futures	6242.9	6311.7	6120.5	6262.7	7761.0
2018-12-21	FOAT	Futures	141.38	141.51	141.21	141.25	67647.0
2018-12-21	FTDX	Futures	2402.7	2423.6	2399.2	2410.1	510.0
2018-12-21	FTI	Futures	453.02	454.28	446.84	453.59	49738.0
2018-12-21	FTUK	Futures	6044.0	6088.6	5975.7	6047.2	208644.0
2018-12-21	FVSA	Futures	439.76	459.05	438.74	441.79	28768.0
2018-12-21	FXXP	Futures	293.5	294.3	290.3	293.4	118576.0
2018-12-21	G	Futures	116.67	116.81	116.29	116.45	148238.0
2018-12-21	GF	Futures	317.347	318.531	316.54	317.186	3388.0
2018-12-21	GSCI	Futures	431.78	435.26	431.15	433.38	125.0

> showing 50 of 115 rows — these rows as CSV

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