PREVIEW / futures_daily / 2019-10-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-01.parquet
  size:    10 KB
  rows:    121

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-10-01	ES	Futures	3230.38	3241.75	3179.5	3180.31	1601531.0
2019-10-01	NQ	Futures	8970.44	9036.71	8863.27	8868.45	478759.0
2019-10-01	YM	Futures	28303.4	28386.3	27835.2	27841.5	204735.0
2019-10-01	CL	Futures	55.73	56.3	54.47	55.05	589176.0
2019-10-01	GC	Futures	1823.2	1842.3	1807.2	1836.8	450174.0
2019-10-01	ZN	Futures	129.201934	129.743888	128.458682	129.480653	2172846.0
2019-10-01	A6	Futures	0.69404	0.69701	0.68634	0.68963	140343.0
2019-10-01	AD	Futures	0.76161	0.76338	0.75874	0.76312	110579.0
2019-10-01	ALI	Futures	2087.99	2114.55	2086.18	2113.34	303.0
2019-10-01	B	Futures	47.04	47.61	46.27	46.65	291672.0
2019-10-01	B6	Futures	1.2536	1.2583	1.2446	1.2542	174888.0
2019-10-01	BR	Futures	0.19348	0.19364	0.19227	0.19356	105.0
2019-10-01	BTC	Futures	12023.9	12311.6	11844.1	11973.6	3539.0
2019-10-01	BZ	Futures	46.5	46.94	45.62	46.0	41174.0
2019-10-01	C	Futures	1691.0	1706.0	1685.0	1690.0	6762.0
2019-10-01	CB	Futures	256.25	256.25	255.984	255.984	1.0
2019-10-01	CC	Futures	1610.0	1620.0	1605.0	1610.0	21774.0
2019-10-01	CNH	Futures	7.1386	7.155	7.1329	7.1434	564.0
2019-10-01	CSC	Futures	3.139	3.143	3.129	3.129	14.0
2019-10-01	CT	Futures	59.34	59.5	58.6	59.36	19430.0
2019-10-01	DC	Futures	26.27	26.43	26.25	26.31	121.0
2019-10-01	DX	Futures	95.72	95.981	95.401	95.471	23620.0
2019-10-01	E1	Futures	1.16036	1.16646	1.15565	1.16542	36575.0
2019-10-01	E6	Futures	1.18759	1.19253	1.18559	1.19182	221896.0
2019-10-01	E7	Futures	1.1815	1.1863	1.1795	1.1856	3783.0
2019-10-01	EBM	Futures	192.08	192.63	190.99	191.81	28894.0
2019-10-01	ED	Futures	95.2743	95.3229	95.2403	95.3132	381090.0
2019-10-01	ER	Futures	98.455	98.47	98.45	98.465	67394.0
2019-10-01	EW	Futures	2040.2	2051.8	1994.0	1996.9	19748.0
2019-10-01	FBON	Futures	146.04	146.1	145.38	146.05	242.0
2019-10-01	FBTP	Futures	132.4	132.65	131.99	132.37	92729.0
2019-10-01	FBTS	Futures	108.597	108.625	108.5	108.587	46205.0
2019-10-01	FCE	Futures	5154.1	5164.5	5050.9	5065.8	89726.0
2019-10-01	FDAX	Futures	13099.2	13174.7	12888.2	12946.8	122242.0
2019-10-01	FDIV	Futures	149.62	149.62	147.67	147.76	105.0
2019-10-01	FDXM	Futures	12926.6	13000.6	12719.4	12777.7	48291.0
2019-10-01	FESX	Futures	3119.4	3136.9	3065.9	3079.9	1137084.0
2019-10-01	FEU3	Futures	99.154	99.164	99.154	99.164	100.0
2019-10-01	FGBL	Futures	168.31	168.33	167.42	168.28	848962.0
2019-10-01	FGBM	Futures	135.21	135.23	134.97	135.21	534480.0
2019-10-01	FGBS	Futures	113.026	113.031	112.996	113.021	277738.0
2019-10-01	FGBX	Futures	225.55	225.8	222.07	225.35	62634.0
2019-10-01	FMWO	Futures	7296.0	7302.8	7183.4	7232.3	6681.0
2019-10-01	FOAT	Futures	154.83	155.03	154.2	154.96	169495.0
2019-10-01	FTDX	Futures	2797.0	2797.0	2742.7	2745.6	102.0
2019-10-01	FTI	Futures	552.06	554.1	542.58	544.13	30972.0
2019-10-01	FTUK	Futures	6850.1	6857.0	6740.7	6788.0	110505.0
2019-10-01	FVSA	Futures	183.01	193.67	179.64	189.18	30969.0
2019-10-01	FXXP	Futures	354.9	355.7	348.6	349.7	52903.0
2019-10-01	G	Futures	122.9	123.31	122.16	123.26	319256.0

> showing 50 of 121 rows — these rows as CSV

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