PREVIEW / futures_daily / 2019-03-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-05.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-03-05	ES	Futures	3021.19	3030.39	3013.34	3022.27	1203448.0
2019-03-05	NQ	Futures	8271.57	8314.99	8248.13	8295.88	364928.0
2019-03-05	YM	Futures	27222.6	27308.0	27129.7	27241.6	172953.0
2019-03-05	CL	Futures	58.35	59.12	57.98	58.47	538399.0
2019-03-05	GC	Futures	1609.7	1613.2	1602.5	1605.9	216929.0
2019-03-05	ZN	Futures	121.175819	121.222503	120.973522	121.191381	61859.0
2019-03-05	A6	Futures	0.73013	0.73136	0.72735	0.73023	76561.0
2019-03-05	AD	Futures	0.76081	0.76081	0.75797	0.75883	56862.0
2019-03-05	B	Futures	47.48	48.04	47.18	47.77	216385.0
2019-03-05	B6	Futures	1.3538	1.3561	1.3456	1.3531	132452.0
2019-03-05	BR	Futures	0.21061	0.21149	0.21061	0.21081	7.0
2019-03-05	BTC	Futures	5649.7	5941.8	5619.0	5895.7	4969.0
2019-03-05	BZ	Futures	47.29	47.65	46.8	47.39	28346.0
2019-03-05	C	Futures	1447.0	1452.0	1436.0	1441.0	5270.0
2019-03-05	CB	Futures	278.723	279.321	278.394	278.394	23.0
2019-03-05	CC	Futures	1450.0	1465.0	1446.0	1456.0	19876.0
2019-03-05	CNH	Futures	6.7169	6.7231	6.7111	6.7168	858.0
2019-03-05	CSC	Futures	2.791	2.798	2.778	2.791	55.0
2019-03-05	CT	Futures	77.67	79.31	77.6	79.21	16861.0
2019-03-05	DC	Futures	23.65	23.79	23.6	23.73	47.0
2019-03-05	DX	Futures	92.142	92.461	92.113	92.313	14581.0
2019-03-05	E1	Futures	1.1776	1.17842	1.17066	1.17184	23667.0
2019-03-05	E6	Futures	1.25398	1.2542	1.24873	1.25017	158626.0
2019-03-05	E7	Futures	1.2479	1.2482	1.2426	1.2441	4087.0
2019-03-05	EBM	Futures	197.66	198.72	196.6	198.45	14203.0
2019-03-05	ED	Futures	95.1013	95.1038	95.094	95.0965	220737.0
2019-03-05	ER	Futures	98.406	98.411	98.406	98.406	27012.0
2019-03-05	EW	Futures	2037.6	2044.8	2029.7	2031.8	11993.0
2019-03-05	FBON	Futures	132.59	132.95	132.59	132.89	2080.0
2019-03-05	FBTP	Futures	112.34	112.67	112.01	112.56	207917.0
2019-03-05	FBTS	Futures	105.417	105.522	105.313	105.446	142151.0
2019-03-05	FCE	Futures	4715.1	4728.9	4697.2	4724.9	58441.0
2019-03-05	FDAX	Futures	12133.2	12225.6	12130.5	12209.3	101908.0
2019-03-05	FDIV	Futures	143.61	143.61	143.52	143.52	1.0
2019-03-05	FDXM	Futures	12096.3	12195.9	12093.1	12179.6	41500.0
2019-03-05	FESX	Futures	2827.8	2846.6	2825.2	2842.3	1046295.0
2019-03-05	FEU3	Futures	98.996	98.996	98.996	98.996	200.0
2019-03-05	FGBL	Futures	157.44	157.54	157.03	157.28	1197241.0
2019-03-05	FGBM	Futures	132.15	132.15	131.96	132.05	1011547.0
2019-03-05	FGBS	Futures	112.582	112.603	112.572	112.588	827036.0
2019-03-05	FGBX	Futures	186.82	187.19	185.88	186.58	161243.0
2019-03-05	FMWO	Futures	7014.4	7031.9	7005.0	7023.7	5958.0
2019-03-05	FOAT	Futures	143.3	143.38	143.02	143.28	342570.0
2019-03-05	FTDX	Futures	2627.8	2643.7	2620.3	2642.7	150.0
2019-03-05	FTI	Futures	507.34	509.36	504.99	508.09	22406.0
2019-03-05	FTUK	Futures	6483.5	6538.1	6468.4	6534.0	97737.0
2019-03-05	FVSA	Futures	250.78	254.28	249.03	252.53	13980.0
2019-03-05	FXXP	Futures	328.5	330.4	328.0	330.0	58344.0
2019-03-05	G	Futures	116.23	116.43	116.07	116.13	193599.0
2019-03-05	GF	Futures	309.331	309.331	307.636	308.074	2550.0

> showing 50 of 117 rows — these rows as CSV

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