PREVIEW / futures_daily / 2019-09-10

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-10.parquet
  size:    10 KB
  rows:    111

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-09-10	ES	Futures	3214.78	3220.98	3191.04	3213.97	1493346.0
2019-09-10	NQ	Futures	9019.48	9046.82	8916.15	8997.6	446533.0
2019-09-10	YM	Futures	28182.7	28239.4	28035.7	28215.2	4340.0
2019-09-10	CL	Futures	59.6	60.35	58.75	58.95	755472.0
2019-09-10	GC	Futures	1859.0	1861.5	1840.6	1849.3	397917.0
2019-09-10	ZN	Futures	129.511622	129.650982	128.644495	128.985152	2002467.0
2019-09-10	A6	Futures	0.70635	0.70686	0.70461	0.70584	50174.0
2019-09-10	AD	Futures	0.76584	0.76791	0.76458	0.7669	52374.0
2019-09-10	ALI	Futures	2195.73	2217.59	2195.12	2213.64	233.0
2019-09-10	B	Futures	48.52	49.26	48.02	48.18	267549.0
2019-09-10	B6	Futures	1.2605	1.2634	1.2561	1.261	73023.0
2019-09-10	BR	Futures	0.19631	0.19639	0.19493	0.19627	27.0
2019-09-10	BTC	Futures	14801.7	14937.4	14208.7	14373.0	3400.0
2019-09-10	BZ	Futures	47.74	48.52	47.31	47.47	32170.0
2019-09-10	C	Futures	1557.0	1565.0	1541.0	1547.0	11483.0
2019-09-10	CB	Futures	262.626	263.541	262.449	262.449	34.0
2019-09-10	CC	Futures	1515.0	1518.0	1496.0	1501.0	21008.0
2019-09-10	CNH	Futures	7.1201	7.1201	7.1015	7.1128	267.0
2019-09-10	CSC	Futures	3.047	3.064	3.047	3.057	53.0
2019-09-10	CT	Futures	58.46	59.02	58.46	58.76	19.0
2019-09-10	DC	Futures	25.58	25.77	25.58	25.71	237.0
2019-09-10	DX	Futures	94.594	94.715	94.517	94.581	6209.0
2019-09-10	E1	Futures	1.17003	1.17313	1.1683	1.17072	16947.0
2019-09-10	E6	Futures	1.20629	1.20743	1.20429	1.20602	202739.0
2019-09-10	E7	Futures	1.2	1.2011	1.1984	1.1998	3063.0
2019-09-10	EBM	Futures	184.15	186.33	183.87	186.06	29818.0
2019-09-10	ED	Futures	95.318	95.3277	95.2694	95.2889	330251.0
2019-09-10	ER	Futures	98.543	98.543	98.529	98.538	71758.0
2019-09-10	EW	Futures	2024.1	2037.8	2015.7	2037.0	116.0
2019-09-10	FBON	Futures	145.24	145.35	144.78	144.92	291.0
2019-09-10	FBTP	Futures	131.19	131.57	130.26	130.39	86669.0
2019-09-10	FBTS	Futures	108.568	108.625	108.442	108.481	75612.0
2019-09-10	FCE	Futures	5061.2	5080.3	5032.7	5067.1	79917.0
2019-09-10	FDAX	Futures	12881.2	12963.8	12823.3	12920.1	97333.0
2019-09-10	FDXM	Futures	12709.0	12796.5	12663.2	12756.9	316.0
2019-09-10	FESX	Futures	3050.1	3062.4	3036.0	3053.6	114932.0
2019-09-10	FGBL	Futures	168.39	168.59	167.84	168.07	712019.0
2019-09-10	FGBM	Futures	135.65	135.72	135.47	135.54	412618.0
2019-09-10	FGBS	Futures	113.192	113.217	113.162	113.172	241027.0
2019-09-10	FGBX	Futures	222.15	223.06	219.49	220.9	63890.0
2019-09-10	FMWO	Futures	7329.1	7331.4	7294.5	7306.0	2482.0
2019-09-10	FOAT	Futures	155.0	155.16	154.52	154.66	141428.0
2019-09-10	FTI	Futures	537.69	539.21	537.5	538.84	8.0
2019-09-10	FTUK	Futures	6677.7	6706.4	6643.9	6702.2	3240.0
2019-09-10	FVSA	Futures	192.51	195.65	188.75	191.89	27960.0
2019-09-10	FXXP	Futures	346.2	348.1	345.9	347.9	9048.0
2019-09-10	G	Futures	121.73	122.06	121.33	121.5	257670.0
2019-09-10	GF	Futures	270.288	276.881	269.555	274.317	8199.0
2019-09-10	GSCI	Futures	461.54	463.79	460.25	460.25	2302.0
2019-09-10	HE	Futures	58.107	60.748	56.503	59.168	46120.0

> showing 50 of 111 rows — these rows as CSV

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