PREVIEW / futures_daily / 2018-07-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-09.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-07-09	ES	Futures	2999.8	3028.04	2999.53	3027.5	970337.0
2018-07-09	NQ	Futures	8432.39	8515.17	8432.09	8511.38	269931.0
2018-07-09	YM	Futures	25770.2	26122.1	25765.9	26104.2	142170.0
2018-07-09	CL	Futures	74.82	75.24	73.93	74.8	533003.0
2018-07-09	GC	Futures	1603.1	1617.4	1603.1	1608.1	238968.0
2018-07-09	ZN	Futures	119.712082	119.72762	119.43238	119.463458	804790.0
2018-07-09	A6	Futures	0.7648	0.76974	0.76408	0.7681	76812.0
2018-07-09	AD	Futures	0.77411	0.77609	0.77275	0.77351	44571.0
2018-07-09	B	Futures	56.95	57.76	56.83	57.59	212186.0
2018-07-09	B6	Futures	1.3782	1.3828	1.3649	1.3717	224633.0
2018-07-09	BR	Futures	0.19618	0.19645	0.19496	0.19618	19.0
2018-07-09	BTC	Futures	9608.9	9630.3	9466.5	9537.7	1765.0
2018-07-09	BZ	Futures	56.67	57.45	56.54	57.28	14925.0
2018-07-09	C	Futures	1705.0	1705.0	1688.0	1699.0	1308.0
2018-07-09	CB	Futures	267.455	271.713	267.455	271.713	28.0
2018-07-09	CC	Futures	1764.0	1780.0	1733.0	1751.0	17028.0
2018-07-09	CNH	Futures	6.7357	6.7357	6.6988	6.6999	195.0
2018-07-09	CSC	Futures	3.198	3.206	3.166	3.202	277.0
2018-07-09	CT	Futures	96.45	97.72	95.86	97.15	26.0
2018-07-09	DC	Futures	25.31	25.36	24.78	25.1	544.0
2018-07-09	DX	Futures	88.772	88.971	88.497	88.845	17464.0
2018-07-09	E1	Futures	1.2152	1.21938	1.21042	1.21185	22765.0
2018-07-09	E6	Futures	1.32068	1.32544	1.31889	1.32068	186245.0
2018-07-09	E7	Futures	1.3134	1.3186	1.3122	1.314	2879.0
2018-07-09	EBM	Futures	193.28	194.33	192.23	192.76	12149.0
2018-07-09	ED	Futures	94.9864	94.9913	94.9815	94.9864	76279.0
2018-07-09	ER	Futures	98.367	98.367	98.362	98.367	26075.0
2018-07-09	EW	Futures	2112.2	2133.1	2111.7	2130.9	9241.0
2018-07-09	FBON	Futures	129.02	129.29	129.0	129.26	421.0
2018-07-09	FBTP	Futures	107.98	108.22	107.54	108.07	35586.0
2018-07-09	FBTS	Futures	102.448	102.596	102.336	102.54	19840.0
2018-07-09	FCE	Futures	4850.5	4869.4	4837.5	4850.5	48257.0
2018-07-09	FDAX	Futures	13118.9	13129.9	13040.5	13110.6	63946.0
2018-07-09	FDXM	Futures	12950.3	12964.8	12875.0	12943.1	22844.0
2018-07-09	FESX	Futures	2887.3	2894.0	2876.4	2887.3	615246.0
2018-07-09	FEU3	Futures	99.016	99.016	99.016	99.016	34.0
2018-07-09	FGBL	Futures	153.28	153.34	152.98	153.22	406314.0
2018-07-09	FGBM	Futures	131.21	131.24	131.12	131.19	230685.0
2018-07-09	FGBS	Futures	112.744	112.754	112.718	112.729	107671.0
2018-07-09	FGBX	Futures	178.52	178.54	177.04	177.74	36970.0
2018-07-09	FMWO	Futures	7083.4	7102.0	7077.6	7095.1	3625.0
2018-07-09	FOAT	Futures	141.28	141.38	141.12	141.3	55899.0
2018-07-09	FTDX	Futures	2712.2	2735.7	2712.2	2725.9	232.0
2018-07-09	FTI	Futures	513.12	515.7	512.84	514.64	18497.0
2018-07-09	FTUK	Futures	6741.7	6817.0	6737.2	6800.0	83473.0
2018-07-09	FVSA	Futures	291.56	291.56	277.96	281.84	22705.0
2018-07-09	FXXP	Futures	330.7	332.0	330.3	331.6	31199.0
2018-07-09	G	Futures	115.5	115.82	115.18	115.54	173658.0
2018-07-09	GF	Futures	315.345	316.018	311.461	313.739	8478.0
2018-07-09	GSCI	Futures	540.55	541.23	540.55	541.0	2112.0

> showing 50 of 115 rows — these rows as CSV

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