PREVIEW / futures_daily / 2018-12-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-31.parquet
  size:    9 KB
  rows:    95

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-12-31	ES	Futures	2701.8	2720.75	2688.0	2712.36	1414594.0
2018-12-31	NQ	Futures	7308.03	7382.7	7274.17	7332.34	386061.0
2018-12-31	YM	Futures	24401.1	24631.0	24354.6	24542.4	173053.0
2018-12-31	CL	Futures	47.43	48.8	46.92	47.63	476970.0
2018-12-31	GC	Futures	1616.6	1621.0	1612.4	1614.4	113258.0
2018-12-31	ZN	Futures	121.175819	121.627097	121.06689	121.518168	797287.0
2018-12-31	A6	Futures	0.72652	0.72941	0.72549	0.72652	50795.0
2018-12-31	AD	Futures	0.74365	0.74512	0.74208	0.74421	38357.0
2018-12-31	B	Futures	38.26	39.58	38.02	38.84	109109.0
2018-12-31	B6	Futures	1.3092	1.3206	1.3068	1.3132	68614.0
2018-12-31	BR	Futures	0.20615	0.20615	0.20495	0.20495	11.0
2018-12-31	BTC	Futures	5555.4	5570.0	5263.0	5336.1	1961.0
2018-12-31	BZ	Futures	37.99	39.22	37.7	38.52	21966.0
2018-12-31	C	Futures	1541.0	1549.0	1524.0	1546.0	8352.0
2018-12-31	CB	Futures	271.438	271.499	271.438	271.499	2.0
2018-12-31	CC	Futures	1660.0	1680.0	1640.0	1665.0	14105.0
2018-12-31	CNH	Futures	6.8949	6.8979	6.883	6.883	125.0
2018-12-31	CSC	Futures	2.806	2.829	2.806	2.827	66.0
2018-12-31	CT	Futures	78.7	79.37	78.54	78.65	9103.0
2018-12-31	DC	Futures	24.13	24.37	24.0	24.1	226.0
2018-12-31	DX	Futures	91.522	91.622	91.159	91.302	16649.0
2018-12-31	E1	Futures	1.20288	1.20699	1.19912	1.20441	20540.0
2018-12-31	E6	Futures	1.27221	1.27514	1.27005	1.27315	94737.0
2018-12-31	E7	Futures	1.2658	1.269	1.2639	1.267	2079.0
2018-12-31	EBM	Futures	208.97	209.23	208.71	208.97	1394.0
2018-12-31	ED	Futures	94.9939	95.0037	94.9891	94.9988	104269.0
2018-12-31	ER	Futures	98.396	98.401	98.396	98.396	7567.0
2018-12-31	EW	Futures	1764.4	1776.5	1744.3	1769.9	17537.0
2018-12-31	FCE	Futures	4168.9	4205.3	4167.6	4198.7	27006.0
2018-12-31	FTI	Futures	454.85	457.93	453.58	456.41	5654.0
2018-12-31	FTUK	Futures	6100.9	6100.9	6061.8	6065.4	29666.0
2018-12-31	G	Futures	116.87	116.95	116.47	116.77	51052.0
2018-12-31	GF	Futures	321.652	322.567	320.253	320.415	2691.0
2018-12-31	GSCI	Futures	429.5	429.5	424.09	427.73	105.0
2018-12-31	HE	Futures	73.176	73.928	73.116	73.326	15858.0
2018-12-31	HG	Futures	3.0862	3.1156	3.0246	3.032	44006.0
2018-12-31	HH	Futures	20.433	20.759	19.496	19.543	1792.0
2018-12-31	HO	Futures	1.0891	1.1268	1.0887	1.1056	17788.0
2018-12-31	HRC	Futures	1823.5	1823.5	1820.9	1820.9	104.0
2018-12-31	J1	Futures	0.0108132	0.0108897	0.0107972	0.0108766	72333.0
2018-12-31	J7	Futures	0.010776	0.010847	0.010756	0.010835	793.0
2018-12-31	JB	Futures	140.17	140.25	140.07	140.23	1102.0
2018-12-31	KC	Futures	111.68	112.84	109.85	112.67	12052.0
2018-12-31	KE	Futures	769.02	770.57	755.46	757.78	15027.0
2018-12-31	L	Futures	99.329	99.334	99.319	99.324	17937.0
2018-12-31	LBS	Futures	550.7	557.3	549.1	553.2	171.0
2018-12-31	LE	Futures	174.575	174.68	173.107	173.177	27846.0
2018-12-31	MFC	Futures	4280.2	4322.7	4280.2	4322.7	40.0
2018-12-31	MFS	Futures	1765.1	1766.7	1748.6	1754.1	39509.0
2018-12-31	MGC	Futures	1577.2	1581.5	1573.1	1575.2	6211.0

> showing 50 of 95 rows — these rows as CSV

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