PREVIEW / futures_daily / 2018-03-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-22.parquet
  size:    9 KB
  rows:    110

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
2018-03-22	ES	Futures	2956.01	2964.71	2872.82	2874.45	2548609.0
2018-03-22	NQ	Futures	8056.39	8093.55	7825.52	7832.54	685491.0
2018-03-22	YM	Futures	26052.7	26127.5	25210.0	25242.7	408367.0
2018-03-22	CL	Futures	65.78	66.02	64.41	64.57	689172.0
2018-03-22	GC	Futures	1701.4	1705.3	1692.0	1695.5	358556.0
2018-03-22	ZN	Futures	119.214471	119.88134	119.198962	119.617694	2424965.0
2018-03-22	A6	Futures	0.79833	0.8008	0.79062	0.79298	139015.0
2018-03-22	AD	Futures	0.78535	0.78981	0.78262	0.78449	107218.0
2018-03-22	B	Futures	50.25	50.3	49.5	49.73	286629.0
2018-03-22	B6	Futures	1.4695	1.4781	1.4629	1.4666	145405.0
2018-03-22	BR	Futures	0.22913	0.2297	0.22894	0.22936	265.0
2018-03-22	BTC	Futures	12352.9	12616.5	11791.1	11971.4	2123.0
2018-03-22	BZ	Futures	49.74	49.84	48.89	49.12	37699.0
2018-03-22	C	Futures	1662.0	1675.0	1647.0	1668.0	9150.0
2018-03-22	CB	Futures	279.147	279.703	278.93	279.703	6.0
2018-03-22	CC	Futures	1871.0	1883.0	1839.0	1860.0	16097.0
2018-03-22	CNH	Futures	6.4237	6.4485	6.4237	6.4485	48.0
2018-03-22	CSC	Futures	3.296	3.348	3.296	3.327	27.0
2018-03-22	CT	Futures	95.01	95.65	93.99	94.43	12699.0
2018-03-22	DC	Futures	26.33	26.64	26.08	26.37	125.0
2018-03-22	DX	Futures	84.189	84.481	83.929	84.385	26349.0
2018-03-22	E1	Futures	1.27813	1.28234	1.27512	1.2762	28942.0
2018-03-22	E6	Futures	1.3991	1.40451	1.39291	1.39538	239058.0
2018-03-22	E7	Futures	1.3918	1.3969	1.3854	1.388	3447.0
2018-03-22	EBM	Futures	175.05	176.13	174.79	175.59	18839.0
2018-03-22	ED	Futures	94.9841	95.0181	94.9646	94.9986	567079.0
2018-03-22	ER	Futures	98.337	98.342	98.332	98.337	58918.0
2018-03-22	EW	Futures	2042.2	2049.8	1986.1	1989.0	21839.0
2018-03-22	FBON	Futures	128.89	129.54	128.89	129.35	585.0
2018-03-22	FBTP	Futures	114.04	114.72	114.03	114.57	97973.0
2018-03-22	FBTS	Futures	103.991	104.121	103.991	104.102	55048.0
2018-03-22	FCE	Futures	4587.9	4602.4	4491.3	4544.7	112905.0
2018-03-22	FDAX	Futures	12725.7	12755.8	12443.6	12559.4	147558.0
2018-03-22	FDXM	Futures	12615.5	12642.3	12329.2	12447.6	57944.0
2018-03-22	FESX	Futures	2747.3	2754.8	2684.8	2709.8	1599520.0
2018-03-22	FGBL	Futures	148.77	149.63	148.73	149.59	948815.0
2018-03-22	FGBM	Futures	129.24	129.61	129.23	129.58	555862.0
2018-03-22	FGBS	Futures	112.517	112.573	112.512	112.563	352727.0
2018-03-22	FGBX	Futures	169.25	170.86	169.19	170.78	63429.0
2018-03-22	FMWO	Futures	6979.5	6979.5	6846.4	6921.1	3316.0
2018-03-22	FOAT	Futures	138.05	138.77	137.98	138.73	119440.0
2018-03-22	FTDX	Futures	2636.0	2636.0	2533.6	2540.5	613.0
2018-03-22	FTI	Futures	488.77	490.15	477.99	482.99	41684.0
2018-03-22	FTUK	Futures	6139.4	6145.2	6012.6	6063.4	141626.0
2018-03-22	FVSA	Futures	404.28	464.92	391.2	436.39	73633.0
2018-03-22	FXXP	Futures	316.1	316.9	309.7	312.2	38772.0
2018-03-22	G	Futures	112.94	113.79	112.66	113.64	304985.0
2018-03-22	GF	Futures	296.754	301.273	295.338	300.62	5829.0
2018-03-22	GSCI	Futures	518.28	518.28	514.16	515.08	35.0
2018-03-22	HE	Futures	81.661	81.69	78.902	79.164	273.0

> showing 50 of 110 rows — these rows as CSV

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