PREVIEW / futures_daily / 2019-12-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-17.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
2019-12-17	ES	Futures	3452.26	3459.82	3447.4	3451.18	1615320.0
2019-12-17	NQ	Futures	9869.53	9894.76	9856.05	9870.39	311604.0
2019-12-17	YM	Futures	29681.9	29768.1	29595.8	29704.0	149803.0
2019-12-17	CL	Futures	61.68	62.51	61.48	62.4	416419.0
2019-12-17	GC	Futures	1821.5	1826.8	1818.8	1821.5	173253.0
2019-12-17	ZN	Futures	127.436674	127.57605	127.281811	127.312783	859548.0
2019-12-17	A6	Futures	0.70655	0.70665	0.70255	0.70368	92158.0
2019-12-17	AD	Futures	0.7662	0.767	0.76469	0.76585	67014.0
2019-12-17	ALI	Futures	2157.56	2157.56	2144.29	2147.91	130.0
2019-12-17	B	Futures	52.67	53.42	52.52	53.31	245832.0
2019-12-17	B6	Futures	1.3518	1.3528	1.3323	1.3343	183489.0
2019-12-17	BR	Futures	0.19932	0.19932	0.19879	0.199	645.0
2019-12-17	BTC	Futures	10351.8	10442.0	9870.3	9900.4	5979.0
2019-12-17	BZ	Futures	52.02	52.7	51.82	52.6	35092.0
2019-12-17	C	Futures	1690.0	1700.0	1674.0	1695.0	8400.0
2019-12-17	CB	Futures	246.097	246.097	245.537	245.537	21.0
2019-12-17	CC	Futures	1656.0	1671.0	1645.0	1658.0	17925.0
2019-12-17	CNH	Futures	6.977	6.9825	6.9713	6.9756	332.0
2019-12-17	CSC	Futures	3.273	3.292	3.257	3.279	122.0
2019-12-17	CT	Futures	63.49	63.8	63.06	63.2	15404.0
2019-12-17	DC	Futures	27.43	27.44	27.17	27.39	374.0
2019-12-17	DX	Futures	93.861	94.017	93.745	93.931	13271.0
2019-12-17	E1	Futures	1.17022	1.17399	1.16828	1.17296	26271.0
2019-12-17	E6	Futures	1.20765	1.21131	1.20641	1.2083	158423.0
2019-12-17	E7	Futures	1.2012	1.205	1.2	1.202	2907.0
2019-12-17	EBM	Futures	204.4	204.68	203.58	204.4	18623.0
2019-12-17	ED	Futures	95.3035	95.3132	95.2986	95.3035	206947.0
2019-12-17	ER	Futures	98.377	98.382	98.377	98.377	45763.0
2019-12-17	ESG	Futures	284.83	284.83	284.83	284.83	106.0
2019-12-17	EW	Futures	2150.5	2158.5	2146.1	2157.2	27801.0
2019-12-17	FBON	Futures	143.65	143.65	143.29	143.56	351.0
2019-12-17	FBTP	Futures	129.07	129.29	128.45	129.25	64264.0
2019-12-17	FBTS	Futures	108.22	108.288	108.105	108.278	31104.0
2019-12-17	FCE	Futures	5417.7	5422.2	5384.2	5397.3	73846.0
2019-12-17	FDAX	Futures	14148.6	14179.3	14031.2	14057.6	50289.0
2019-12-17	FDIV	Futures	162.42	162.42	161.73	161.73	1521.0
2019-12-17	FDXM	Futures	13972.0	13998.1	13856.1	13881.2	3022.0
2019-12-17	FESX	Futures	3303.9	3311.8	3284.5	3287.2	1771974.0
2019-12-17	FGBL	Futures	164.32	164.56	164.25	164.41	417995.0
2019-12-17	FGBM	Futures	133.66	133.73	133.64	133.69	257134.0
2019-12-17	FGBS	Futures	112.679	112.694	112.674	112.684	181687.0
2019-12-17	FGBX	Futures	212.25	213.4	212.25	213.0	37145.0
2019-12-17	FMWO	Futures	7794.1	7804.4	7770.3	7786.2	47777.0
2019-12-17	FOAT	Futures	151.96	152.11	151.78	151.93	81859.0
2019-12-17	FTDX	Futures	3088.1	3088.1	3067.0	3072.5	1141.0
2019-12-17	FTI	Futures	584.85	584.85	580.16	580.77	28596.0
2019-12-17	FTUK	Futures	6993.1	7022.2	6976.7	7003.9	378015.0
2019-12-17	FVSA	Futures	124.58	129.26	123.64	128.32	40671.0
2019-12-17	FXXP	Futures	378.7	379.0	376.0	376.7	267765.0
2019-12-17	G	Futures	120.07	120.49	120.04	120.36	192391.0

> showing 50 of 119 rows — these rows as CSV

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