PREVIEW / futures_daily / 2019-01-03

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-03.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
2019-01-03	ES	Futures	2687.46	2699.64	2645.23	2650.1	2257341.0
2019-01-03	NQ	Futures	7227.57	7298.77	7118.45	7134.08	714536.0
2019-01-03	YM	Futures	24328.3	24389.5	23853.6	23900.0	346019.0
2019-01-03	CL	Futures	48.52	49.81	47.57	49.39	788718.0
2019-01-03	GC	Futures	1623.5	1634.1	1620.9	1631.5	244542.0
2019-01-03	ZN	Futures	122.093936	122.74751	121.720465	122.654142	2637572.0
2019-01-03	A6	Futures	0.71014	0.72405	0.70314	0.7222	135729.0
2019-01-03	AD	Futures	0.7439	0.75296	0.74264	0.75241	113617.0
2019-01-03	B	Futures	39.19	40.65	38.93	40.39	278356.0
2019-01-03	B6	Futures	1.2966	1.3032	1.2847	1.3015	98348.0
2019-01-03	BR	Futures	0.21062	0.21213	0.21062	0.21185	244.0
2019-01-03	BTC	Futures	5628.5	5657.7	5423.8	5496.9	3620.0
2019-01-03	BZ	Futures	39.21	40.3	38.61	40.05	36535.0
2019-01-03	C	Futures	1545.0	1552.0	1533.0	1541.0	9220.0
2019-01-03	CB	Futures	273.23	275.326	273.23	275.326	8.0
2019-01-03	CC	Futures	1651.0	1669.0	1639.0	1653.0	21118.0
2019-01-03	CNH	Futures	6.9005	6.91	6.8929	6.8931	804.0
2019-01-03	CSC	Futures	2.825	2.84	2.819	2.838	75.0
2019-01-03	CT	Futures	77.16	78.43	76.96	77.16	14610.0
2019-01-03	DC	Futures	24.16	24.29	24.15	24.28	158.0
2019-01-03	DX	Futures	91.889	91.908	91.34	91.439	31519.0
2019-01-03	E1	Futures	1.19641	1.20217	1.19571	1.19759	29757.0
2019-01-03	E6	Futures	1.26182	1.26851	1.25713	1.26635	217663.0
2019-01-03	E7	Futures	1.2554	1.2623	1.2509	1.2602	4520.0
2019-01-03	EBM	Futures	209.48	212.05	209.23	211.8	13345.0
2019-01-03	ED	Futures	95.0037	95.0525	94.9939	95.0476	423943.0
2019-01-03	ER	Futures	98.401	98.401	98.391	98.396	79482.0
2019-01-03	EW	Futures	1750.5	1767.0	1729.0	1737.1	17738.0
2019-01-03	FBON	Futures	130.0	130.38	129.44	129.51	918.0
2019-01-03	FBTP	Futures	112.24	112.32	110.51	110.65	80501.0
2019-01-03	FBTS	Futures	104.897	104.906	104.509	104.547	52451.0
2019-01-03	FCE	Futures	4121.9	4146.3	4088.6	4092.6	92811.0
2019-01-03	FDAX	Futures	11086.0	11091.8	10919.4	10950.9	107458.0
2019-01-03	FDXM	Futures	11067.9	11067.9	10892.8	10924.3	45558.0
2019-01-03	FESX	Futures	2531.2	2538.9	2509.9	2517.6	994251.0
2019-01-03	FGBL	Futures	156.8	156.98	156.29	156.71	685071.0
2019-01-03	FGBM	Futures	132.38	132.43	132.17	132.35	415869.0
2019-01-03	FGBS	Futures	112.789	112.794	112.734	112.774	326284.0
2019-01-03	FGBX	Futures	186.46	187.06	185.18	186.19	41014.0
2019-01-03	FMWO	Futures	6263.9	6293.0	6206.8	6239.4	2649.0
2019-01-03	FOAT	Futures	142.35	142.35	141.73	142.0	121621.0
2019-01-03	FTDX	Futures	2423.1	2423.1	2368.9	2374.9	563.0
2019-01-03	FTI	Futures	450.73	452.65	447.27	449.42	33360.0
2019-01-03	FTUK	Futures	6045.8	6095.9	6026.7	6049.0	100577.0
2019-01-03	FVSA	Futures	472.26	485.46	460.07	466.16	39635.0
2019-01-03	FXXP	Futures	292.4	294.1	291.1	291.7	40778.0
2019-01-03	G	Futures	117.59	117.71	117.03	117.58	246938.0
2019-01-03	GF	Futures	317.778	318.477	314.764	315.41	2759.0
2019-01-03	GSCI	Futures	431.5	435.14	428.3	435.14	11.0
2019-01-03	HE	Futures	74.679	75.431	74.499	74.739	15374.0

> showing 50 of 113 rows — these rows as CSV

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