PREVIEW / futures_daily / 2019-11-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-29.parquet
  size:    10 KB
  rows:    116

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-11-29	ES	Futures	3415.23	3415.5	3398.72	3403.32	902189.0
2019-11-29	NQ	Futures	9745.73	9747.46	9687.82	9700.5	242603.0
2019-11-29	YM	Futures	29551.6	29560.0	29438.2	29470.8	100093.0
2019-11-29	CL	Futures	59.36	59.53	56.18	56.33	718724.0
2019-11-29	GC	Futures	1797.7	1812.1	1795.1	1811.8	272344.0
2019-11-29	ZN	Futures	128.195447	128.365776	127.99415	128.13351	154267.0
2019-11-29	A6	Futures	0.69558	0.69588	0.69322	0.69435	91161.0
2019-11-29	AD	Futures	0.75834	0.75864	0.75658	0.75844	75911.0
2019-11-29	ALI	Futures	2166.06	2166.06	2166.06	2166.06	0.0
2019-11-29	B	Futures	50.97	50.97	48.67	48.79	284787.0
2019-11-29	B6	Futures	1.3167	1.3174	1.31	1.3154	127341.0
2019-11-29	BR	Futures	0.18971	0.19109	0.18963	0.19092	15.0
2019-11-29	BTC	Futures	11344.8	11931.6	11081.5	11736.0	4898.0
2019-11-29	BZ	Futures	50.14	50.45	48.02	48.14	47386.0
2019-11-29	C	Futures	1774.0	1776.0	1754.0	1760.0	11896.0
2019-11-29	CC	Futures	1696.0	1707.0	1670.0	1680.0	15920.0
2019-11-29	CNH	Futures	7.0156	7.025	7.01	7.0183	976.0
2019-11-29	CT	Futures	62.51	62.57	61.93	62.17	8965.0
2019-11-29	DX	Futures	94.976	95.198	94.869	94.915	11821.0
2019-11-29	E1	Futures	1.15277	1.15369	1.14886	1.15185	32053.0
2019-11-29	E6	Futures	1.19399	1.19643	1.19122	1.19518	193646.0
2019-11-29	E7	Futures	1.1877	1.1902	1.1851	1.189	3838.0
2019-11-29	EBM	Futures	200.56	203.03	199.47	203.03	13007.0
2019-11-29	ED	Futures	95.3253	95.3326	95.3229	95.3253	107869.0
2019-11-29	ER	Futures	98.396	98.401	98.396	98.396	23390.0
2019-11-29	ESG	Futures	280.13	280.13	279.52	279.52	14.0
2019-11-29	EW	Futures	2135.3	2135.5	2109.3	2111.2	13884.0
2019-11-29	FBON	Futures	143.23	143.35	142.99	143.04	357.0
2019-11-29	FBTP	Futures	128.61	128.66	128.12	128.53	98701.0
2019-11-29	FBTS	Futures	108.153	108.163	108.038	108.095	67122.0
2019-11-29	FCE	Futures	5331.2	5362.0	5320.8	5339.4	48465.0
2019-11-29	FDAX	Futures	13984.0	14024.6	13886.4	13977.1	83988.0
2019-11-29	FDIV	Futures	161.22	161.63	161.12	161.12	167.0
2019-11-29	FDXM	Futures	13798.3	13842.0	13705.6	13794.6	32918.0
2019-11-29	FESX	Futures	3247.4	3258.8	3229.9	3246.5	921867.0
2019-11-29	FGBL	Futures	165.47	165.57	165.1	165.26	907313.0
2019-11-29	FGBM	Futures	133.96	134.0	133.81	133.87	375817.0
2019-11-29	FGBS	Futures	112.684	112.699	112.669	112.674	657940.0
2019-11-29	FGBX	Futures	216.36	216.77	215.34	216.23	45678.0
2019-11-29	FMWO	Futures	7661.1	7661.1	7639.5	7649.7	1755.0
2019-11-29	FOAT	Futures	152.84	152.91	152.51	152.66	186151.0
2019-11-29	FTDX	Futures	3008.2	3036.4	3008.2	3027.5	63.0
2019-11-29	FTI	Futures	570.52	574.97	569.85	571.75	21864.0
2019-11-29	FTUK	Futures	6876.9	6881.1	6801.9	6826.0	86220.0
2019-11-29	FVSA	Futures	132.27	134.3	131.26	132.27	27326.0
2019-11-29	FXXP	Futures	368.9	370.4	367.2	368.7	40753.0
2019-11-29	G	Futures	121.35	121.5	120.92	121.09	201747.0
2019-11-29	GF	Futures	302.228	302.702	298.752	299.7	4011.0
2019-11-29	GSCI	Futures	463.1	463.1	459.02	459.02	18.0
2019-11-29	HE	Futures	50.349	52.331	49.613	51.463	22873.0

> showing 50 of 116 rows — these rows as CSV

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