PREVIEW / futures_daily / 2019-01-04

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-04.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
2019-01-04	ES	Futures	2654.44	2749.17	2640.09	2740.51	2350836.0
2019-01-04	NQ	Futures	7141.89	7481.4	7104.55	7448.99	696539.0
2019-01-04	YM	Futures	23951.7	24791.3	23798.8	24676.4	320826.0
2019-01-04	CL	Futures	49.19	51.62	48.93	50.3	817277.0
2019-01-04	GC	Futures	1633.6	1638.5	1610.4	1620.1	316063.0
2019-01-04	ZN	Futures	122.654142	122.731949	121.627097	121.798271	2132973.0
2019-01-04	A6	Futures	0.7224	0.73476	0.72127	0.73394	135661.0
2019-01-04	AD	Futures	0.75236	0.75828	0.75165	0.75711	94945.0
2019-01-04	B	Futures	40.19	42.1	39.95	41.19	321106.0
2019-01-04	B6	Futures	1.3018	1.3132	1.2998	1.3126	97488.0
2019-01-04	BR	Futures	0.21181	0.21401	0.2111	0.21365	23.0
2019-01-04	BTC	Futures	5489.6	5665.1	5394.6	5475.0	3919.0
2019-01-04	BZ	Futures	39.79	41.74	39.63	40.85	42426.0
2019-01-04	C	Futures	1542.0	1542.0	1493.0	1510.0	10856.0
2019-01-04	CB	Futures	274.111	275.326	274.02	275.326	34.0
2019-01-04	CC	Futures	1653.0	1655.0	1594.0	1627.0	22432.0
2019-01-04	CNH	Futures	6.8976	6.8983	6.8784	6.8784	553.0
2019-01-04	CSC	Futures	2.838	2.842	2.831	2.836	63.0
2019-01-04	CT	Futures	77.34	79.92	77.27	79.0	19774.0
2019-01-04	DC	Futures	24.29	24.32	24.2	24.29	117.0
2019-01-04	DX	Futures	91.36	91.746	91.188	91.317	29005.0
2019-01-04	E1	Futures	1.19959	1.20135	1.19465	1.19994	29607.0
2019-01-04	E6	Futures	1.26663	1.26928	1.26105	1.26702	211982.0
2019-01-04	E7	Futures	1.2605	1.2629	1.255	1.2608	4394.0
2019-01-04	EBM	Futures	212.05	213.08	211.54	212.83	15508.0
2019-01-04	ED	Futures	95.0379	95.0428	94.9891	95.0037	461310.0
2019-01-04	ER	Futures	98.401	98.401	98.396	98.396	61389.0
2019-01-04	EW	Futures	1738.4	1801.5	1730.3	1794.8	16101.0
2019-01-04	FBON	Futures	129.52	129.6	129.06	129.06	425.0
2019-01-04	FBTP	Futures	110.87	111.29	110.37	110.58	71706.0
2019-01-04	FBTS	Futures	104.613	104.812	104.566	104.726	65571.0
2019-01-04	FCE	Futures	4135.2	4219.5	4114.3	4204.0	97232.0
2019-01-04	FDAX	Futures	10939.9	11379.2	10921.5	11297.7	118831.0
2019-01-04	FDXM	Futures	10924.3	11349.9	10897.0	11270.2	53021.0
2019-01-04	FESX	Futures	2510.7	2600.5	2504.7	2586.8	1228183.0
2019-01-04	FGBL	Futures	156.89	156.92	155.82	155.9	650458.0
2019-01-04	FGBM	Futures	132.41	132.42	132.05	132.09	420442.0
2019-01-04	FGBS	Futures	112.774	112.779	112.713	112.729	281504.0
2019-01-04	FGBX	Futures	185.14	186.58	183.94	184.08	36015.0
2019-01-04	FMWO	Futures	6221.9	6404.9	6221.9	6380.4	3650.0
2019-01-04	FOAT	Futures	141.89	141.97	141.44	141.5	102058.0
2019-01-04	FTDX	Futures	2402.7	2491.6	2392.8	2449.4	450.0
2019-01-04	FTI	Futures	452.74	462.47	452.04	460.26	34881.0
2019-01-04	FTUK	Futures	6034.4	6195.2	6028.1	6170.6	114223.0
2019-01-04	FVSA	Futures	462.1	462.1	414.37	422.49	22199.0
2019-01-04	FXXP	Futures	294.6	301.0	293.4	299.6	46849.0
2019-01-04	G	Futures	117.47	117.48	116.72	116.76	224857.0
2019-01-04	GF	Futures	315.248	315.248	311.428	311.912	2392.0
2019-01-04	GSCI	Futures	442.15	445.92	441.53	441.58	76.0
2019-01-04	HE	Futures	75.491	75.702	73.838	74.499	16599.0

> showing 50 of 115 rows — these rows as CSV

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