PREVIEW / futures_daily / 2019-06-25

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-25.parquet
  size:    10 KB
  rows:    117

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-06-25	ES	Futures	3184.3	3192.12	3150.85	3153.0	1417191.0
2019-06-25	NQ	Futures	8926.22	8956.73	8761.01	8783.17	424811.0
2019-06-25	YM	Futures	28096.6	28169.0	27866.6	27890.8	216578.0
2019-06-25	CL	Futures	59.06	60.19	58.51	59.16	673140.0
2019-06-25	GC	Futures	1771.6	1795.9	1761.3	1765.7	643590.0
2019-06-25	ZN	Futures	127.378138	127.65809	127.300373	127.533667	1649628.0
2019-06-25	A6	Futures	0.71849	0.71972	0.71592	0.71777	108633.0
2019-06-25	AD	Futures	0.76594	0.76766	0.76438	0.76589	83201.0
2019-06-25	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-06-25	B	Futures	48.28	49.02	47.74	48.32	249597.0
2019-06-25	B6	Futures	1.305	1.3096	1.2983	1.3005	90012.0
2019-06-25	BTC	Futures	15573.8	16441.7	15573.8	16287.7	1563.0
2019-06-25	BZ	Futures	47.66	48.37	47.14	47.71	29671.0
2019-06-25	C	Futures	1761.0	1766.0	1746.0	1748.0	5690.0
2019-06-25	CB	Futures	287.077	287.661	286.202	287.632	53.0
2019-06-25	CC	Futures	1660.0	1672.0	1639.0	1641.0	17816.0
2019-06-25	CNH	Futures	6.8783	6.8924	6.8695	6.8892	652.0
2019-06-25	CSC	Futures	3.087	3.087	3.067	3.077	16.0
2019-06-25	CT	Futures	64.38	65.26	64.38	64.83	64.0
2019-06-25	DC	Futures	25.92	25.99	25.79	25.95	88.0
2019-06-25	DX	Futures	91.948	92.309	91.818	92.091	24236.0
2019-06-25	E1	Futures	1.20227	1.20516	1.19507	1.19844	46109.0
2019-06-25	E6	Futures	1.25145	1.25298	1.24562	1.24883	211965.0
2019-06-25	E7	Futures	1.245	1.2464	1.239	1.2423	10277.0
2019-06-25	EBM	Futures	212.17	213.32	209.58	211.31	17705.0
2019-06-25	ED	Futures	95.4742	95.4986	95.4401	95.4645	392196.0
2019-06-25	ER	Futures	98.499	98.504	98.499	98.504	48606.0
2019-06-25	EW	Futures	2015.3	2020.0	1999.6	2001.1	9570.0
2019-06-25	FBON	Futures	142.63	142.92	142.54	142.9	280.0
2019-06-25	FBTP	Futures	119.83	120.09	119.36	119.93	99401.0
2019-06-25	FBTS	Futures	106.603	106.67	106.478	106.622	64052.0
2019-06-25	FCE	Futures	5020.8	5042.7	5014.4	5034.0	57969.0
2019-06-25	FDAX	Futures	12905.9	12924.4	12799.6	12870.1	103069.0
2019-06-25	FDXM	Futures	12735.0	12767.2	12645.5	12711.6	34014.0
2019-06-25	FESX	Futures	3004.7	3010.8	2986.3	3001.2	622391.0
2019-06-25	FGBL	Futures	163.98	164.41	163.98	164.38	579798.0
2019-06-25	FGBM	Futures	134.34	134.47	134.33	134.46	322868.0
2019-06-25	FGBS	Futures	113.066	113.086	113.051	113.081	240538.0
2019-06-25	FGBX	Futures	209.09	210.37	209.01	210.25	51577.0
2019-06-25	FMWO	Futures	7327.9	7345.2	7281.8	7321.0	1690.0
2019-06-25	FOAT	Futures	151.05	151.4	150.96	151.37	103862.0
2019-06-25	FTDX	Futures	2810.8	2810.8	2798.5	2809.3	58.0
2019-06-25	FTI	Futures	525.02	526.06	522.43	524.76	19117.0
2019-06-25	FTUK	Futures	6777.9	6795.9	6740.9	6791.7	70638.0
2019-06-25	FVSA	Futures	205.58	206.97	200.74	202.81	19218.0
2019-06-25	FXXP	Futures	341.2	342.3	340.4	342.0	37893.0
2019-06-25	G	Futures	120.05	120.42	120.0	120.33	211346.0
2019-06-25	GF	Futures	259.429	259.625	257.27	257.712	4183.0
2019-06-25	GSCI	Futures	480.18	482.45	480.18	481.15	8.0
2019-06-25	HE	Futures	66.281	67.544	65.921	67.093	7391.0

> showing 50 of 117 rows — these rows as CSV

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