PREVIEW / futures_daily / 2017-03-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-13.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-03-13	ES	Futures	2570.13	2575.01	2567.15	2574.74	1042690.0
2017-03-13	NQ	Futures	6342.09	6360.36	6331.19	6359.18	85360.0
2017-03-13	YM	Futures	22002.4	22034.0	21953.8	21992.9	121530.0
2017-03-13	CL	Futures	51.41	51.65	50.83	51.36	601362.0
2017-03-13	GC	Futures	1539.4	1546.9	1535.5	1536.9	173917.0
2017-03-13	ZN	Futures	121.001427	121.170423	120.617344	120.74025	860406.0
2017-03-13	A6	Futures	0.77332	0.77794	0.77208	0.7767	62416.0
2017-03-13	AD	Futures	0.75886	0.76038	0.75778	0.75972	57039.0
2017-03-13	ALI	Futures	2523.93	2523.93	2523.93	2523.93	0.0
2017-03-13	B	Futures	37.6	37.75	37.13	37.5	276760.0
2017-03-13	B6	Futures	1.2786	1.2875	1.2774	1.2854	116940.0
2017-03-13	BFX	Futures	4563.8	4567.4	4562.5	4567.4	24.0
2017-03-13	BR	Futures	0.22499	0.22589	0.22455	0.22582	158.0
2017-03-13	BZ	Futures	37.34	37.57	36.96	37.33	28880.0
2017-03-13	C	Futures	1657.0	1724.0	1651.0	1721.0	11665.0
2017-03-13	CB	Futures	269.9	270.968	269.748	269.748	62.0
2017-03-13	CC	Futures	1485.0	1544.0	1476.0	1540.0	27515.0
2017-03-13	CNH	Futures	7.25	7.2539	7.2454	7.2501	16.0
2017-03-13	CSC	Futures	3.656	3.665	3.625	3.663	92.0
2017-03-13	CT	Futures	85.99	86.47	85.62	85.68	10916.0
2017-03-13	DC	Futures	29.57	30.01	29.57	30.0	210.0
2017-03-13	DX	Futures	94.247	94.345	93.972	94.28	22844.0
2017-03-13	E1	Futures	1.2302	1.23539	1.22834	1.23403	22324.0
2017-03-13	E6	Futures	1.2363	1.23975	1.23255	1.23348	171660.0
2017-03-13	E7	Futures	1.2303	1.2334	1.2263	1.2272	3519.0
2017-03-13	EBM	Futures	193.78	194.06	192.1	192.38	32576.0
2017-03-13	ED	Futures	95.4962	95.501	95.4865	95.4913	247536.0
2017-03-13	ER	Futures	98.303	98.318	98.293	98.313	170078.0
2017-03-13	EW	Futures	1818.9	1826.2	1812.8	1821.7	41797.0
2017-03-13	FBON	Futures	119.45	119.67	119.1	119.12	379.0
2017-03-13	FBTP	Futures	102.98	103.27	102.79	102.86	100046.0
2017-03-13	FBTS	Futures	101.483	101.537	101.447	101.447	33699.0
2017-03-13	FCE	Futures	4393.1	4409.4	4385.6	4396.6	110122.0
2017-03-13	FDAX	Futures	12619.9	12685.4	12608.9	12663.7	88595.0
2017-03-13	FDXM	Futures	12542.5	12604.3	12536.3	12586.5	4376.0
2017-03-13	FESX	Futures	2725.5	2732.0	2719.0	2726.3	1063271.0
2017-03-13	FEU3	Futures	98.976	98.986	98.976	98.986	325.0
2017-03-13	FGBL	Futures	146.21	146.75	146.07	146.3	603305.0
2017-03-13	FGBM	Futures	128.75	128.93	128.67	128.78	458128.0
2017-03-13	FGBS	Futures	112.377	112.402	112.322	112.357	265324.0
2017-03-13	FGBX	Futures	162.94	164.89	162.82	163.89	44795.0
2017-03-13	FMWO	Futures	6185.6	6194.0	6185.6	6191.6	3861.0
2017-03-13	FOAT	Futures	129.91	130.49	129.9	130.09	100578.0
2017-03-13	FTDX	Futures	1935.2	1938.1	1935.2	1938.1	1.0
2017-03-13	FTI	Futures	463.06	464.75	462.93	463.7	7938.0
2017-03-13	FTUK	Futures	6208.6	6242.4	6208.6	6236.8	259239.0
2017-03-13	FVSA	Futures	677.99	684.92	673.83	679.38	5101.0
2017-03-13	FXXP	Futures	309.2	310.6	309.1	310.1	107047.0
2017-03-13	G	Futures	114.0	114.37	113.67	113.73	151497.0
2017-03-13	GF	Futures	293.066	297.16	292.893	295.43	5491.0

> showing 50 of 110 rows — these rows as CSV

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