PREVIEW / futures_daily / 2019-04-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-01.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-04-01	ES	Futures	3072.56	3103.88	3072.56	3100.64	1256933.0
2019-04-01	NQ	Futures	8560.88	8649.02	8559.15	8639.81	412914.0
2019-04-01	YM	Futures	27419.1	27748.5	27419.1	27716.8	158713.0
2019-04-01	CL	Futures	61.86	63.46	61.74	63.24	670808.0
2019-04-01	GC	Futures	1614.5	1620.1	1606.8	1610.8	236657.0
2019-04-01	ZN	Futures	123.47671	123.492249	122.839591	122.932828	1761109.0
2019-04-01	A6	Futures	0.73384	0.73632	0.73343	0.73436	96038.0
2019-04-01	AD	Futures	0.75868	0.76171	0.75741	0.7611	81982.0
2019-04-01	B	Futures	49.22	50.42	49.22	50.27	320766.0
2019-04-01	B6	Futures	1.3403	1.3521	1.3377	1.3498	112478.0
2019-04-01	BR	Futures	0.20488	0.20609	0.20488	0.20581	38.0
2019-04-01	BTC	Futures	6319.5	6404.5	6242.2	6373.6	1897.0
2019-04-01	BZ	Futures	49.06	50.26	49.06	50.13	49439.0
2019-04-01	C	Futures	1539.0	1557.0	1536.0	1556.0	10883.0
2019-04-01	CB	Futures	279.201	279.261	279.201	279.201	8.0
2019-04-01	CC	Futures	1546.0	1588.0	1536.0	1571.0	31198.0
2019-04-01	CNH	Futures	6.7172	6.732	6.7163	6.732	484.0
2019-04-01	CSC	Futures	2.847	2.856	2.847	2.849	37.0
2019-04-01	CT	Futures	82.52	82.68	81.94	82.13	17584.0
2019-04-01	DC	Futures	24.05	24.12	23.97	24.08	120.0
2019-04-01	DX	Futures	92.78	92.852	92.574	92.784	14049.0
2019-04-01	E1	Futures	1.18173	1.1836	1.17589	1.17659	30856.0
2019-04-01	E6	Futures	1.24002	1.24271	1.23761	1.23854	176889.0
2019-04-01	E7	Futures	1.2339	1.2365	1.2315	1.2324	4894.0
2019-04-01	EBM	Futures	196.34	198.45	195.54	197.92	14017.0
2019-04-01	ED	Futures	95.1599	95.1648	95.1404	95.1502	279953.0
2019-04-01	ER	Futures	98.411	98.416	98.411	98.416	36814.0
2019-04-01	EW	Futures	2021.1	2045.6	2021.1	2044.9	17158.0
2019-04-01	FBON	Futures	134.92	134.93	134.44	134.48	536.0
2019-04-01	FBTP	Futures	114.75	114.83	114.08	114.62	67148.0
2019-04-01	FBTS	Futures	105.703	105.76	105.57	105.693	38616.0
2019-04-01	FCE	Futures	4798.4	4827.8	4784.6	4811.8	68284.0
2019-04-01	FDAX	Futures	12212.2	12351.1	12212.2	12319.5	110252.0
2019-04-01	FDIV	Futures	142.43	142.75	142.43	142.75	3.0
2019-04-01	FDXM	Futures	12104.8	12243.6	12104.8	12212.8	43632.0
2019-04-01	FESX	Futures	2873.6	2901.6	2873.6	2893.7	840399.0
2019-04-01	FGBL	Futures	160.42	160.42	159.83	159.89	733687.0
2019-04-01	FGBM	Futures	133.15	133.15	132.98	133.01	505124.0
2019-04-01	FGBS	Futures	112.809	112.814	112.774	112.809	410899.0
2019-04-01	FGBX	Futures	195.37	195.39	193.38	193.94	56819.0
2019-04-01	FMWO	Futures	7127.0	7158.3	7123.5	7146.7	4065.0
2019-04-01	FOAT	Futures	147.11	147.11	146.46	146.53	169331.0
2019-04-01	FTDX	Futures	2659.3	2685.4	2659.3	2684.0	428.0
2019-04-01	FTI	Futures	517.64	520.55	516.57	518.62	23198.0
2019-04-01	FTUK	Futures	6635.3	6675.7	6622.9	6647.2	87601.0
2019-04-01	FVSA	Futures	242.75	248.46	239.5	244.38	16553.0
2019-04-01	FXXP	Futures	335.5	338.3	335.0	337.4	48893.0
2019-04-01	G	Futures	119.01	119.32	118.69	118.84	165707.0
2019-04-01	GF	Futures	310.787	314.797	310.092	311.055	1784.0
2019-04-01	GSCI	Futures	495.03	498.49	494.75	497.64	56.0

> showing 50 of 115 rows — these rows as CSV

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