PREVIEW / futures_daily / 2018-11-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-05.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
2018-11-05	ES	Futures	2952.58	2975.63	2942.01	2971.02	1311938.0
2018-11-05	NQ	Futures	8099.03	8128.94	7973.87	8072.02	506045.0
2018-11-05	YM	Futures	26557.8	26815.8	26464.0	26790.5	175812.0
2018-11-05	CL	Futures	65.64	66.84	65.15	65.76	609129.0
2018-11-05	GC	Futures	1564.6	1567.5	1556.9	1561.8	159425.0
2018-11-05	ZN	Futures	117.580809	117.783132	117.565246	117.674189	1230676.0
2018-11-05	A6	Futures	0.74043	0.74311	0.73951	0.7428	77431.0
2018-11-05	AD	Futures	0.77239	0.77416	0.77153	0.77198	46870.0
2018-11-05	B	Futures	53.84	54.79	53.41	54.08	231141.0
2018-11-05	B6	Futures	1.34	1.3452	1.3357	1.3448	109646.0
2018-11-05	BR	Futures	0.20582	0.2059	0.20357	0.20445	2334.0
2018-11-05	BTC	Futures	9264.3	9336.7	9213.7	9249.9	2336.0
2018-11-05	BZ	Futures	53.4	54.41	53.02	53.71	28438.0
2018-11-05	C	Futures	1548.0	1574.0	1541.0	1571.0	15406.0
2018-11-05	CB	Futures	269.855	270.666	269.855	270.666	4.0
2018-11-05	CC	Futures	1583.0	1614.0	1571.0	1609.0	26575.0
2018-11-05	CNH	Futures	6.9433	6.9708	6.9364	6.954	1114.0
2018-11-05	CSC	Futures	3.054	3.054	3.026	3.032	38.0
2018-11-05	CT	Futures	88.55	89.12	87.88	88.53	17763.0
2018-11-05	DC	Futures	25.28	25.33	25.08	25.11	272.0
2018-11-05	DX	Futures	91.46	91.683	91.241	91.277	16868.0
2018-11-05	E1	Futures	1.18596	1.18667	1.18134	1.18489	17968.0
2018-11-05	E6	Futures	1.27044	1.27428	1.26627	1.27366	158016.0
2018-11-05	E7	Futures	1.2642	1.268	1.26	1.2674	2373.0
2018-11-05	EBM	Futures	208.98	209.24	207.68	208.2	13913.0
2018-11-05	ED	Futures	94.9548	94.9792	94.9499	94.9694	216108.0
2018-11-05	ER	Futures	98.386	98.391	98.381	98.386	68757.0
2018-11-05	EW	Futures	1957.5	1975.5	1950.9	1967.7	20825.0
2018-11-05	FBON	Futures	127.48	127.57	127.36	127.54	194.0
2018-11-05	FBTP	Futures	105.67	105.86	104.97	105.75	65040.0
2018-11-05	FBTS	Futures	102.911	102.958	102.574	102.93	62953.0
2018-11-05	FCE	Futures	4561.3	4586.4	4556.4	4564.9	54906.0
2018-11-05	FDAX	Futures	12112.6	12145.2	12055.3	12078.4	78682.0
2018-11-05	FDXM	Futures	11903.9	11934.9	11847.0	11869.2	40534.0
2018-11-05	FESX	Futures	2688.2	2707.5	2687.3	2695.7	687019.0
2018-11-05	FEU3	Futures	99.006	99.016	99.006	99.016	297.0
2018-11-05	FGBL	Futures	152.74	153.04	152.72	152.87	481541.0
2018-11-05	FGBM	Futures	130.99	131.11	130.97	131.0	367945.0
2018-11-05	FGBS	Futures	112.693	112.724	112.678	112.683	286837.0
2018-11-05	FGBX	Futures	176.44	177.25	176.42	177.01	45165.0
2018-11-05	FMWO	Futures	6781.7	6791.0	6753.9	6775.9	2895.0
2018-11-05	FOAT	Futures	140.06	140.3	140.0	140.13	110083.0
2018-11-05	FTDX	Futures	2619.6	2624.1	2593.1	2597.5	230.0
2018-11-05	FTI	Futures	486.64	488.55	485.01	485.83	20592.0
2018-11-05	FTUK	Futures	6316.6	6359.5	6302.3	6333.2	88179.0
2018-11-05	FVSA	Futures	356.75	361.5	348.19	351.99	21129.0
2018-11-05	FXXP	Futures	314.5	315.6	313.9	314.2	38363.0
2018-11-05	G	Futures	114.61	114.65	114.3	114.52	203938.0
2018-11-05	GF	Futures	317.766	317.922	309.865	310.853	2520.0
2018-11-05	GSCI	Futures	518.63	518.63	514.57	514.57	63.0

> showing 50 of 115 rows — these rows as CSV

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