PREVIEW / futures_daily / 2019-07-03

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-03.parquet
  size:    10 KB
  rows:    120

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-07-03	ES	Futures	3214.51	3238.79	3208.84	3237.44	805258.0
2019-07-03	NQ	Futures	9026.67	9087.12	9008.54	9081.07	209604.0
2019-07-03	YM	Futures	28138.6	28331.8	28088.2	28319.2	119169.0
2019-07-03	CL	Futures	57.79	58.8	57.33	58.66	600131.0
2019-07-03	GC	Futures	1773.2	1793.5	1760.8	1768.5	419609.0
2019-07-03	ZN	Futures	127.564773	127.844724	127.54922	127.65809	1229180.0
2019-07-03	A6	Futures	0.72096	0.7259	0.72034	0.72569	86297.0
2019-07-03	AD	Futures	0.76998	0.773	0.76937	0.77224	51894.0
2019-07-03	ALI	Futures	2172.57	2191.51	2171.96	2191.51	23.0
2019-07-03	B	Futures	47.29	48.12	46.68	47.98	282110.0
2019-07-03	B6	Futures	1.29	1.2906	1.2859	1.288	68909.0
2019-07-03	BR	Futures	0.20575	0.20703	0.20535	0.20663	31.0
2019-07-03	BTC	Futures	15244.8	16469.7	15195.8	15916.7	6772.0
2019-07-03	BZ	Futures	46.58	47.51	46.07	47.37	35881.0
2019-07-03	C	Futures	1732.0	1744.0	1713.0	1715.0	1443.0
2019-07-03	CB	Futures	286.027	286.027	284.802	285.093	57.0
2019-07-03	CC	Futures	1643.0	1659.0	1619.0	1621.0	14463.0
2019-07-03	CNH	Futures	6.8889	6.9007	6.8842	6.8842	774.0
2019-07-03	CSC	Futures	3.151	3.151	3.137	3.144	85.0
2019-07-03	CT	Futures	65.67	66.15	65.53	65.72	28.0
2019-07-03	DC	Futures	26.33	26.38	26.21	26.29	152.0
2019-07-03	DX	Futures	92.69	92.848	92.545	92.748	9442.0
2019-07-03	E1	Futures	1.18394	1.18719	1.18243	1.18336	18515.0
2019-07-03	E6	Futures	1.23858	1.24131	1.23645	1.23787	135337.0
2019-07-03	E7	Futures	1.2322	1.2348	1.23	1.2315	5625.0
2019-07-03	EBM	Futures	203.53	206.13	203.25	205.55	16626.0
2019-07-03	ED	Futures	95.3915	95.4158	95.3817	95.3963	223783.0
2019-07-03	ER	Futures	98.529	98.543	98.524	98.529	75035.0
2019-07-03	EW	Futures	2049.5	2068.7	2045.0	2066.7	6625.0
2019-07-03	FBON	Futures	144.1	144.88	144.1	144.78	562.0
2019-07-03	FBTP	Futures	123.17	125.62	123.17	124.74	205233.0
2019-07-03	FBTS	Futures	107.389	107.619	107.389	107.523	120829.0
2019-07-03	FCE	Futures	5099.8	5145.5	5093.4	5132.2	50741.0
2019-07-03	FDAX	Futures	13194.4	13320.3	13168.6	13268.2	86615.0
2019-07-03	FDIV	Futures	149.29	149.71	149.29	149.71	8.0
2019-07-03	FDXM	Futures	13038.7	13155.2	13006.4	13104.7	30974.0
2019-07-03	FESX	Futures	3057.1	3092.0	3051.8	3081.5	836663.0
2019-07-03	FEU3	Futures	99.154	99.159	99.154	99.159	5.0
2019-07-03	FGBL	Futures	165.06	165.35	165.0	165.14	653582.0
2019-07-03	FGBM	Futures	134.7	134.77	134.59	134.63	475334.0
2019-07-03	FGBS	Futures	113.152	113.152	113.101	113.111	273897.0
2019-07-03	FGBX	Futures	210.1	211.82	210.1	211.67	54241.0
2019-07-03	FMWO	Futures	7413.3	7468.7	7413.3	7447.9	2087.0
2019-07-03	FOAT	Futures	152.22	152.66	152.22	152.53	131897.0
2019-07-03	FTDX	Futures	2882.4	2902.1	2882.4	2895.7	104.0
2019-07-03	FTI	Futures	536.5	540.55	535.89	539.14	17533.0
2019-07-03	FTUK	Futures	6927.0	6980.1	6921.0	6969.0	76801.0
2019-07-03	FVSA	Futures	179.97	180.66	170.97	177.9	26222.0
2019-07-03	FXXP	Futures	348.1	351.4	347.7	350.4	62392.0
2019-07-03	G	Futures	121.34	121.65	121.18	121.41	241627.0

> showing 50 of 120 rows — these rows as CSV

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