PREVIEW / futures_daily / 2018-10-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-05.parquet
  size:    10 KB
  rows:    117

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-10-05	ES	Futures	3155.93	3161.89	3116.07	3138.58	2291213.0
2018-10-05	NQ	Futures	8735.84	8757.9	8533.73	8637.11	735015.0
2018-10-05	YM	Futures	28085.7	28154.2	27706.6	27897.2	273829.0
2018-10-05	CL	Futures	78.17	78.74	77.29	77.82	613218.0
2018-10-05	GC	Futures	1525.6	1533.3	1522.0	1528.0	255479.0
2018-10-05	ZN	Futures	117.425176	117.502993	117.051657	117.20729	2363170.0
2018-10-05	A6	Futures	0.7287	0.72973	0.7251	0.72603	97947.0
2018-10-05	AD	Futures	0.78351	0.78563	0.78149	0.7825	62347.0
2018-10-05	B	Futures	62.37	62.54	61.66	61.84	300619.0
2018-10-05	B6	Futures	1.3435	1.354	1.3416	1.3526	129738.0
2018-10-05	BR	Futures	0.19626	0.19843	0.19504	0.19633	289.0
2018-10-05	BTC	Futures	9423.0	9495.1	9379.7	9423.0	928.0
2018-10-05	BZ	Futures	61.78	62.07	61.2	61.37	27778.0
2018-10-05	C	Futures	1393.0	1430.0	1393.0	1414.0	6715.0
2018-10-05	CB	Futures	272.769	275.863	272.318	272.889	48.0
2018-10-05	CC	Futures	1402.0	1442.0	1402.0	1414.0	18216.0
2018-10-05	CNH	Futures	6.9629	6.9867	6.9629	6.9777	292.0
2018-10-05	CSC	Futures	3.206	3.21	3.196	3.196	17.0
2018-10-05	CT	Futures	85.31	86.13	85.31	85.42	12078.0
2018-10-05	DC	Futures	26.73	26.73	26.58	26.64	75.0
2018-10-05	DX	Futures	90.638	90.842	90.415	90.538	23060.0
2018-10-05	E1	Futures	1.20244	1.2035	1.19805	1.20291	24131.0
2018-10-05	E6	Futures	1.28706	1.29123	1.28384	1.28851	230503.0
2018-10-05	E7	Futures	1.2808	1.2849	1.2775	1.2822	4746.0
2018-10-05	EBM	Futures	211.31	211.83	210.79	211.57	15909.0
2018-10-05	ED	Futures	95.0622	95.0818	95.0622	95.0671	302755.0
2018-10-05	ER	Futures	98.372	98.377	98.372	98.377	28649.0
2018-10-05	EW	Futures	2090.6	2095.7	2060.9	2073.1	23597.0
2018-10-05	FBON	Futures	127.39	127.39	127.13	127.2	365.0
2018-10-05	FBTP	Futures	105.21	105.21	104.17	104.26	71605.0
2018-10-05	FBTS	Futures	101.797	101.834	101.253	101.488	73232.0
2018-10-05	FCE	Futures	4876.1	4882.0	4802.6	4827.9	78778.0
2018-10-05	FDAX	Futures	12850.2	12871.8	12661.5	12715.1	103558.0
2018-10-05	FDIV	Futures	143.93	143.93	143.25	143.25	14.0
2018-10-05	FDXM	Futures	12633.4	12649.9	12443.2	12494.9	49938.0
2018-10-05	FESX	Futures	2823.4	2828.5	2785.6	2798.2	1024120.0
2018-10-05	FEU3	Futures	98.996	99.001	98.996	99.001	16.0
2018-10-05	FGBL	Futures	151.24	151.32	150.57	150.84	848352.0
2018-10-05	FGBM	Futures	130.11	130.17	129.95	130.04	459860.0
2018-10-05	FGBS	Futures	112.472	112.502	112.462	112.487	375653.0
2018-10-05	FGBX	Futures	174.24	174.34	172.02	172.77	56782.0
2018-10-05	FMWO	Futures	7202.3	7208.1	7145.5	7168.7	3979.0
2018-10-05	FOAT	Futures	139.01	139.07	138.54	138.76	152505.0
2018-10-05	FTDX	Futures	2750.3	2750.8	2686.9	2692.3	278.0
2018-10-05	FTI	Futures	504.61	505.59	498.21	500.49	27539.0
2018-10-05	FTUK	Futures	6602.6	6627.2	6491.8	6516.4	113653.0
2018-10-05	FVSA	Futures	269.15	292.44	268.29	281.23	41374.0
2018-10-05	FXXP	Futures	328.2	328.3	323.5	324.9	62352.0
2018-10-05	G	Futures	112.83	112.93	112.33	112.58	314750.0
2018-10-05	GF	Futures	326.655	329.048	325.927	328.216	1048.0

> showing 50 of 117 rows — these rows as CSV

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