PREVIEW / futures_daily / 2017-06-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-21.parquet
  size:    9 KB
  rows:    110

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
2017-06-21	ES	Futures	2647.23	2651.85	2638.81	2644.78	1374762.0
2017-06-21	NQ	Futures	6733.79	6814.02	6699.41	6813.44	319202.0
2017-06-21	YM	Futures	22645.4	22675.0	22559.7	22598.9	144469.0
2017-06-21	CL	Futures	44.8	45.64	43.42	43.92	1071747.0
2017-06-21	GC	Futures	1587.9	1594.2	1585.1	1590.4	170459.0
2017-06-21	ZN	Futures	124.750233	124.888742	124.596335	124.765623	1028869.0
2017-06-21	A6	Futures	0.77784	0.77794	0.77404	0.77547	66032.0
2017-06-21	AD	Futures	0.76785	0.76785	0.76317	0.76541	73496.0
2017-06-21	ALI	Futures	2467.84	2467.84	2467.84	2467.84	25.0
2017-06-21	B	Futures	32.65	33.17	31.55	31.88	389712.0
2017-06-21	B6	Futures	1.3233	1.332	1.3194	1.3274	122943.0
2017-06-21	BFX	Futures	4668.1	4669.3	4649.4	4669.3	5.0
2017-06-21	BR	Futures	0.21977	0.22007	0.21948	0.2197	46.0
2017-06-21	BZ	Futures	32.47	33.02	31.42	31.75	40210.0
2017-06-21	C	Futures	1570.0	1577.0	1528.0	1530.0	8462.0
2017-06-21	CC	Futures	1452.0	1466.0	1396.0	1407.0	23288.0
2017-06-21	CNH	Futures	7.0983	7.1014	7.097	7.097	2.0
2017-06-21	CSC	Futures	3.534	3.559	3.522	3.534	57.0
2017-06-21	CT	Futures	79.0	79.67	78.37	78.51	4164.0
2017-06-21	DC	Futures	29.56	29.84	29.34	29.44	328.0
2017-06-21	DX	Futures	90.935	91.01	90.743	90.777	14386.0
2017-06-21	E1	Futures	1.26695	1.27076	1.26646	1.26953	15468.0
2017-06-21	E6	Futures	1.28196	1.2862	1.28104	1.28505	130203.0
2017-06-21	E7	Futures	1.275	1.2793	1.2743	1.2783	2492.0
2017-06-21	EBM	Futures	196.53	196.53	194.58	195.41	15389.0
2017-06-21	ED	Futures	95.5789	95.5838	95.5741	95.5838	161908.0
2017-06-21	ER	Futures	98.332	98.337	98.332	98.332	45234.0
2017-06-21	EW	Futures	1855.5	1859.0	1839.6	1843.0	11600.0
2017-06-21	FBON	Futures	125.17	125.51	125.13	125.38	401.0
2017-06-21	FBTP	Futures	109.94	110.28	109.85	110.03	69285.0
2017-06-21	FBTS	Futures	102.9	102.954	102.9	102.918	33417.0
2017-06-21	FCE	Futures	4753.7	4762.3	4703.7	4750.6	95722.0
2017-06-21	FDAX	Futures	13464.7	13478.9	13373.6	13439.4	79664.0
2017-06-21	FDXM	Futures	13392.2	13393.3	13290.7	13356.7	24613.0
2017-06-21	FESX	Futures	2892.0	2901.8	2866.7	2894.5	836072.0
2017-06-21	FEU3	Futures	99.006	99.006	99.006	99.006	3.0
2017-06-21	FGBL	Futures	149.89	150.16	149.7	149.87	671844.0
2017-06-21	FGBM	Futures	129.59	129.69	129.39	129.49	499570.0
2017-06-21	FGBS	Futures	112.242	112.272	112.207	112.227	274055.0
2017-06-21	FGBX	Futures	171.07	172.12	170.95	171.64	51558.0
2017-06-21	FMWO	Futures	6403.1	6420.9	6399.5	6412.6	287.0
2017-06-21	FOAT	Futures	137.14	137.36	136.99	137.14	92168.0
2017-06-21	FTDX	Futures	2288.7	2288.7	2264.1	2277.7	134.0
2017-06-21	FTI	Futures	478.61	480.09	474.83	479.58	31407.0
2017-06-21	FTUK	Futures	6408.1	6408.1	6353.7	6392.6	104948.0
2017-06-21	FVSA	Futures	478.64	492.81	467.62	475.49	29912.0
2017-06-21	FXXP	Futures	329.0	330.0	327.2	329.6	27388.0
2017-06-21	G	Futures	116.57	116.83	116.08	116.33	186304.0
2017-06-21	GF	Futures	318.302	320.003	314.79	317.534	5009.0
2017-06-21	GSCI	Futures	435.63	436.17	427.65	429.17	539.0

> showing 50 of 110 rows — these rows as CSV

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