PREVIEW / futures_daily / 2019-04-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-23.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-04-23	ES	Futures	3145.2	3175.44	3141.15	3173.55	1193738.0
2019-04-23	NQ	Futures	8915.76	9037.61	8900.21	9030.98	427149.0
2019-04-23	YM	Futures	27994.4	28171.8	27932.1	28119.0	165638.0
2019-04-23	CL	Futures	67.5	68.38	67.33	68.07	700598.0
2019-04-23	GC	Futures	1589.4	1591.3	1578.1	1584.7	280344.0
2019-04-23	ZN	Futures	122.28017	122.528801	122.233551	122.451104	942906.0
2019-04-23	A6	Futures	0.73673	0.73673	0.73075	0.73188	87258.0
2019-04-23	AD	Futures	0.75837	0.75868	0.75302	0.75317	82295.0
2019-04-23	B	Futures	54.18	54.43	53.89	54.27	308989.0
2019-04-23	B6	Futures	1.3332	1.3374	1.328	1.3292	101728.0
2019-04-23	BR	Futures	0.2024	0.20392	0.20196	0.20392	533.0
2019-04-23	BTC	Futures	8343.6	8753.0	8304.9	8637.1	10603.0
2019-04-23	BZ	Futures	53.9	54.28	53.75	54.12	50165.0
2019-04-23	C	Futures	1642.0	1657.0	1633.0	1642.0	3748.0
2019-04-23	CB	Futures	278.185	278.185	277.228	277.527	7.0
2019-04-23	CC	Futures	1574.0	1583.0	1532.0	1543.0	22398.0
2019-04-23	CNH	Futures	6.7245	6.7403	6.7208	6.7378	583.0
2019-04-23	CSC	Futures	2.912	2.922	2.901	2.917	87.0
2019-04-23	CT	Futures	81.85	81.85	80.8	81.29	2695.0
2019-04-23	DC	Futures	24.63	24.71	24.51	24.6	341.0
2019-04-23	DX	Futures	92.947	93.417	92.933	93.283	12187.0
2019-04-23	E1	Futures	1.15489	1.15524	1.14649	1.14975	38648.0
2019-04-23	E6	Futures	1.24123	1.24178	1.23409	1.23667	224413.0
2019-04-23	E7	Futures	1.2353	1.2356	1.228	1.2305	4161.0
2019-04-23	EBM	Futures	193.69	193.69	192.1	193.16	23020.0
2019-04-23	ED	Futures	95.1355	95.1502	95.1306	95.1453	242942.0
2019-04-23	ER	Futures	98.416	98.421	98.411	98.416	48627.0
2019-04-23	EW	Futures	2069.6	2099.3	2066.4	2095.0	12220.0
2019-04-23	FBON	Futures	135.45	135.45	134.83	134.96	214.0
2019-04-23	FBTP	Futures	115.29	115.37	114.41	114.52	84202.0
2019-04-23	FBTS	Futures	105.789	105.846	105.589	105.627	45107.0
2019-04-23	FCE	Futures	4973.1	4989.8	4959.6	4983.9	128807.0
2019-04-23	FDAX	Futures	12898.5	12925.3	12848.5	12914.3	81491.0
2019-04-23	FDXM	Futures	12797.7	12814.4	12738.2	12802.4	28865.0
2019-04-23	FESX	Futures	3002.1	3006.5	2985.5	3003.0	715870.0
2019-04-23	FGBL	Futures	159.26	159.37	158.97	159.19	557087.0
2019-04-23	FGBM	Futures	132.8	132.86	132.74	132.79	347965.0
2019-04-23	FGBS	Futures	112.744	112.749	112.724	112.734	177985.0
2019-04-23	FGBX	Futures	191.77	192.01	190.77	191.63	25352.0
2019-04-23	FMWO	Futures	7258.9	7308.7	7254.3	7297.1	2043.0
2019-04-23	FOAT	Futures	146.52	146.58	146.1	146.26	101267.0
2019-04-23	FTDX	Futures	2759.0	2805.9	2744.7	2786.1	298.0
2019-04-23	FTI	Futures	534.76	535.52	532.01	534.97	21168.0
2019-04-23	FTUK	Futures	6821.0	6854.5	6796.7	6847.6	82569.0
2019-04-23	FVSA	Futures	197.6	198.3	194.81	196.2	21974.0
2019-04-23	FXXP	Futures	345.4	346.0	343.8	345.7	62339.0
2019-04-23	G	Futures	117.15	117.17	116.88	116.97	165159.0
2019-04-23	GF	Futures	313.853	314.529	310.626	311.511	3728.0
2019-04-23	GSCI	Futures	516.75	516.75	515.11	515.68	29.0
2019-04-23	HE	Futures	87.886	88.676	86.577	86.725	593.0

> showing 50 of 113 rows — these rows as CSV

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