PREVIEW / futures_daily / 2019-06-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-24.parquet
  size:    10 KB
  rows:    118

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-06-24	ES	Futures	3181.06	3195.9	3180.25	3185.38	910166.0
2019-06-24	NQ	Futures	8916.43	8973.71	8901.75	8932.84	260978.0
2019-06-24	YM	Futures	28008.4	28156.4	27995.8	28100.8	136483.0
2019-06-24	CL	Futures	59.04	59.56	58.05	59.23	597164.0
2019-06-24	GC	Futures	1747.3	1773.7	1747.0	1765.1	375145.0
2019-06-24	ZN	Futures	127.051527	127.393691	126.942657	127.347032	987020.0
2019-06-24	A6	Futures	0.71479	0.7188	0.71468	0.71849	72851.0
2019-06-24	AD	Futures	0.76393	0.7661	0.76388	0.76554	55749.0
2019-06-24	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-06-24	B	Futures	48.75	48.97	47.7	48.28	217443.0
2019-06-24	B6	Futures	1.3052	1.308	1.302	1.3054	65498.0
2019-06-24	BTC	Futures	15335.8	15867.7	15013.8	15559.8	1048.0
2019-06-24	BZ	Futures	48.16	48.35	47.1	47.66	39427.0
2019-06-24	C	Futures	1771.0	1775.0	1756.0	1759.0	2241.0
2019-06-24	CB	Futures	286.756	287.661	286.435	287.077	42.0
2019-06-24	CC	Futures	1672.0	1687.0	1653.0	1657.0	13229.0
2019-06-24	CNH	Futures	6.8712	6.8907	6.8647	6.8783	343.0
2019-06-24	CSC	Futures	3.07	3.077	3.067	3.077	24.0
2019-06-24	CT	Futures	64.05	64.75	64.05	64.55	52.0
2019-06-24	DC	Futures	25.76	25.95	25.74	25.89	72.0
2019-06-24	DX	Futures	92.112	92.155	91.914	91.936	22606.0
2019-06-24	E1	Futures	1.19739	1.20319	1.19426	1.20203	31122.0
2019-06-24	E6	Futures	1.249	1.25227	1.24867	1.25189	155150.0
2019-06-24	E7	Futures	1.2425	1.2457	1.2422	1.2453	4415.0
2019-06-24	EBM	Futures	207.85	211.88	207.28	211.59	14327.0
2019-06-24	ED	Futures	95.4401	95.484	95.4353	95.4742	360492.0
2019-06-24	ER	Futures	98.494	98.504	98.494	98.499	115733.0
2019-06-24	EW	Futures	2024.5	2034.9	2012.0	2012.4	10166.0
2019-06-24	FBON	Futures	142.51	142.69	142.48	142.64	291.0
2019-06-24	FBTP	Futures	120.21	120.76	119.85	119.92	101605.0
2019-06-24	FBTS	Futures	106.747	106.823	106.564	106.603	60152.0
2019-06-24	FCE	Futures	5034.0	5062.8	5025.8	5039.0	49848.0
2019-06-24	FDAX	Futures	12930.7	12981.2	12874.3	12893.3	86920.0
2019-06-24	FDIV	Futures	147.53	147.53	145.86	146.04	65.0
2019-06-24	FDXM	Futures	12757.9	12820.3	12716.3	12734.5	34734.0
2019-06-24	FESX	Futures	3008.2	3023.9	2998.6	3004.7	583917.0
2019-06-24	FGBL	Futures	163.57	164.11	163.57	163.99	463680.0
2019-06-24	FGBM	Futures	134.23	134.39	134.23	134.36	339067.0
2019-06-24	FGBS	Futures	113.051	113.076	113.036	113.061	223905.0
2019-06-24	FGBX	Futures	207.59	209.53	207.49	209.16	32843.0
2019-06-24	FMWO	Futures	7353.3	7357.9	7341.8	7353.3	4633.0
2019-06-24	FOAT	Futures	150.68	151.07	150.66	150.97	82710.0
2019-06-24	FTDX	Futures	2809.8	2821.2	2807.3	2808.3	59.0
2019-06-24	FTI	Futures	527.19	530.62	525.21	526.43	16070.0
2019-06-24	FTUK	Futures	6752.5	6801.4	6746.0	6777.9	63945.0
2019-06-24	FVSA	Futures	201.43	205.58	200.05	202.12	22072.0
2019-06-24	FXXP	Futures	342.0	344.1	341.4	342.0	46963.0
2019-06-24	G	Futures	119.95	120.22	119.92	120.12	130802.0
2019-06-24	GF	Futures	261.735	262.323	256.976	258.595	5791.0
2019-06-24	GSCI	Futures	480.18	480.18	477.41	479.62	34.0

> showing 50 of 118 rows — these rows as CSV

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