PREVIEW / futures_daily / 2019-07-26

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-26.parquet
  size:    10 KB
  rows:    120

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-07-26	ES	Futures	3244.18	3269.0	3243.64	3263.61	961015.0
2019-07-26	NQ	Futures	9201.39	9257.51	9196.21	9233.34	322305.0
2019-07-26	YM	Futures	28438.9	28553.3	28431.5	28507.1	120612.0
2019-07-26	CL	Futures	57.07	57.72	56.82	57.35	476785.0
2019-07-26	GC	Futures	1760.8	1773.4	1758.5	1766.7	118103.0
2019-07-26	ZN	Futures	126.647152	126.787128	126.444965	126.631599	1002499.0
2019-07-26	A6	Futures	0.71623	0.71664	0.71119	0.7117	63648.0
2019-07-26	AD	Futures	0.7664	0.7668	0.76433	0.76594	58008.0
2019-07-26	ALI	Futures	2254.12	2254.12	2254.12	2254.12	0.0
2019-07-26	B	Futures	47.65	48.11	47.47	47.81	204519.0
2019-07-26	B6	Futures	1.2739	1.2748	1.2662	1.2671	78075.0
2019-07-26	BR	Futures	0.21082	0.21186	0.21006	0.21146	4155.0
2019-07-26	BTC	Futures	13720.1	13844.0	13410.3	13795.8	2604.0
2019-07-26	BZ	Futures	47.05	47.48	46.87	47.19	19426.0
2019-07-26	C	Futures	1743.0	1750.0	1715.0	1718.0	5646.0
2019-07-26	CB	Futures	281.826	281.943	280.659	281.622	75.0
2019-07-26	CC	Futures	1627.0	1633.0	1590.0	1591.0	17821.0
2019-07-26	CNH	Futures	6.8825	6.8867	6.8774	6.8856	363.0
2019-07-26	CSC	Futures	3.137	3.137	3.105	3.129	89.0
2019-07-26	CT	Futures	63.02	63.44	62.66	63.44	8.0
2019-07-26	DC	Futures	26.36	26.43	26.2	26.41	161.0
2019-07-26	DX	Futures	93.907	94.196	93.879	94.115	11842.0
2019-07-26	E1	Futures	1.17594	1.17664	1.17107	1.17176	20808.0
2019-07-26	E6	Futures	1.22064	1.22124	1.21698	1.21851	185146.0
2019-07-26	E7	Futures	1.2143	1.2154	1.2106	1.2121	2560.0
2019-07-26	EBM	Futures	201.81	202.38	201.23	201.81	12513.0
2019-07-26	ED	Futures	95.26	95.2697	95.2308	95.2454	277066.0
2019-07-26	ER	Futures	98.533	98.538	98.524	98.529	57097.0
2019-07-26	EW	Futures	2062.9	2087.6	2061.1	2085.5	10704.0
2019-07-26	FBON	Futures	143.82	143.87	143.61	143.63	244.0
2019-07-26	FBTP	Futures	125.93	126.11	125.11	125.26	77112.0
2019-07-26	FBTS	Futures	107.839	107.906	107.609	107.676	47802.0
2019-07-26	FCE	Futures	5093.3	5115.2	5071.0	5109.7	60349.0
2019-07-26	FDAX	Futures	13012.8	13097.6	12997.0	13070.2	77782.0
2019-07-26	FDIV	Futures	147.76	147.76	147.67	147.67	15.0
2019-07-26	FDXM	Futures	12837.9	12936.7	12836.9	12909.2	29176.0
2019-07-26	FESX	Futures	3057.1	3077.2	3056.2	3074.5	639942.0
2019-07-26	FGBL	Futures	165.69	165.74	165.37	165.65	407859.0
2019-07-26	FGBM	Futures	134.82	134.84	134.68	134.73	322108.0
2019-07-26	FGBS	Futures	113.111	113.116	113.066	113.071	187574.0
2019-07-26	FGBX	Futures	211.24	212.23	210.78	211.96	31371.0
2019-07-26	FMWO	Futures	7435.2	7454.8	7429.5	7452.5	1660.0
2019-07-26	FOAT	Futures	152.75	152.91	152.52	152.8	95891.0
2019-07-26	FTDX	Futures	2891.7	2900.1	2888.8	2900.1	64.0
2019-07-26	FTI	Futures	546.69	548.4	545.08	547.47	18065.0
2019-07-26	FTUK	Futures	6846.2	6923.7	6842.5	6911.7	71831.0
2019-07-26	FVSA	Futures	171.27	171.89	166.32	166.94	16420.0
2019-07-26	FXXP	Futures	348.2	349.4	347.4	349.2	34611.0
2019-07-26	G	Futures	121.38	121.51	121.19	121.46	137692.0
2019-07-26	GF	Futures	280.623	282.34	279.494	282.046	4989.0

> showing 50 of 120 rows — these rows as CSV

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