PREVIEW / futures_daily / 2020-06-24

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-24.parquet
  size:    10 KB
  rows:    119

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
2020-06-24	ES	Futures	3504.23	3521.4	3398.99	3431.91	2387916.0
2020-06-24	NQ	Futures	11818.79	11887.27	11521.96	11618.87	661645.0
2020-06-24	YM	Futures	27849.0	28007.6	26962.7	27213.5	281371.0
2020-06-24	CL	Futures	28.99	29.39	27.05	27.56	499490.0
2020-06-24	GC	Futures	2142.4	2156.4	2125.8	2131.2	239533.0
2020-06-24	ZN	Futures	137.428279	137.660553	137.288915	137.629583	1001745.0
2020-06-24	A6	Futures	0.71277	0.71627	0.70609	0.7065	95088.0
2020-06-24	AD	Futures	0.74926	0.75048	0.74424	0.74581	59578.0
2020-06-24	ALI	Futures	1940.46	1948.62	1926.25	1928.97	509.0
2020-06-24	B	Futures	27.79	28.07	25.94	26.39	195717.0
2020-06-24	B6	Futures	1.2712	1.2741	1.261	1.2619	93622.0
2020-06-24	BR	Futures	0.15253	0.15253	0.14781	0.14849	40.0
2020-06-24	BTC	Futures	13435.4	13456.1	12760.5	12912.0	2600.0
2020-06-24	BZ	Futures	27.06	27.42	25.33	25.77	28537.0
2020-06-24	C	Futures	1732.0	1750.0	1725.0	1747.0	2698.0
2020-06-24	CB	Futures	207.531	207.531	205.686	206.488	37.0
2020-06-24	CC	Futures	1499.0	1527.0	1499.0	1512.0	9796.0
2020-06-24	CNH	Futures	6.9813	7.0048	6.9693	7.0031	236.0
2020-06-24	CSC	Futures	3.839	3.839	3.708	3.708	43.0
2020-06-24	CT	Futures	61.45	61.69	60.59	60.59	10.0
2020-06-24	DC	Futures	31.64	31.86	30.63	30.63	279.0
2020-06-24	DX	Futures	93.314	93.893	93.212	93.82	18299.0
2020-06-24	E1	Futures	1.2049	1.20684	1.20002	1.20104	16129.0
2020-06-24	E6	Futures	1.21573	1.21755	1.20918	1.21036	173612.0
2020-06-24	E7	Futures	1.2096	1.2113	1.203	1.2043	6306.0
2020-06-24	EBM	Futures	211.67	213.17	211.37	211.97	11946.0
2020-06-24	ED	Futures	96.3895	96.3943	96.3847	96.3895	101148.0
2020-06-24	ER	Futures	98.357	98.367	98.352	98.362	69147.0
2020-06-24	ESG	Futures	276.84	277.1	275.36	275.74	70.0
2020-06-24	EW	Futures	1894.5	1906.9	1816.6	1835.3	16668.0
2020-06-24	FBON	Futures	144.51	144.93	144.41	144.91	538.0
2020-06-24	FBTP	Futures	130.15	130.21	129.64	130.0	67296.0
2020-06-24	FBTS	Futures	108.473	108.502	108.386	108.434	35082.0
2020-06-24	FCE	Futures	4867.3	4873.2	4718.9	4742.4	71332.0
2020-06-24	FDAX	Futures	13209.7	13271.3	12751.3	12841.1	118756.0
2020-06-24	FDIV	Futures	143.03	143.03	140.71	140.71	200.0
2020-06-24	FDXM	Futures	13159.9	13226.6	12705.8	12794.7	62453.0
2020-06-24	FESX	Futures	3009.3	3023.2	2915.1	2934.5	1089852.0
2020-06-24	FGBL	Futures	167.71	168.28	167.4	168.17	592629.0
2020-06-24	FGBM	Futures	134.6	134.79	134.51	134.75	395328.0
2020-06-24	FGBS	Futures	112.749	112.78	112.719	112.774	247534.0
2020-06-24	FGBX	Futures	222.52	225.92	221.4	225.28	69118.0
2020-06-24	FMWO	Futures	7828.7	7831.1	7594.1	7640.3	4034.0
2020-06-24	FOAT	Futures	154.98	155.36	154.68	155.31	128753.0
2020-06-24	FTDX	Futures	3035.3	3035.8	2966.8	2975.0	80.0
2020-06-24	FTI	Futures	528.77	530.25	513.7	515.99	28782.0
2020-06-24	FTUK	Futures	5901.0	5923.6	5722.3	5758.7	104451.0
2020-06-24	FVSA	Futures	278.06	311.25	276.27	301.83	22806.0
2020-06-24	FXXP	Futures	335.9	336.3	325.7	327.8	67461.0
2020-06-24	G	Futures	126.7	127.05	126.49	126.94	180043.0

> showing 50 of 119 rows — these rows as CSV

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