PREVIEW / futures_daily / 2018-08-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-14.parquet
  size:    10 KB
  rows:    114

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-08-14	ES	Futures	3070.13	3088.32	3069.04	3085.6	1022577.0
2018-08-14	NQ	Futures	8651.58	8703.46	8624.18	8695.01	305390.0
2018-08-14	YM	Futures	26578.3	26694.2	26544.6	26652.1	122398.0
2018-08-14	CL	Futures	69.53	70.54	68.64	69.09	170899.0
2018-08-14	GC	Futures	1522.3	1528.3	1519.5	1521.8	242549.0
2018-08-14	ZN	Futures	119.494536	119.58777	119.370225	119.447919	1292946.0
2018-08-14	A6	Futures	0.74804	0.74917	0.7431	0.74423	103203.0
2018-08-14	AD	Futures	0.77168	0.77614	0.77143	0.77452	61215.0
2018-08-14	B	Futures	53.08	53.89	52.6	52.82	242747.0
2018-08-14	B6	Futures	1.3181	1.3251	1.3125	1.3132	106257.0
2018-08-14	BFX	Futures	4428.3	4431.2	4428.3	4431.2	48.0
2018-08-14	BR	Futures	0.19534	0.19698	0.19481	0.19649	2761.0
2018-08-14	BTC	Futures	8889.5	8946.5	8333.9	8654.4	6904.0
2018-08-14	BZ	Futures	53.05	53.82	52.49	52.75	20737.0
2018-08-14	C	Futures	1461.0	1466.0	1451.0	1458.0	3349.0
2018-08-14	CB	Futures	287.544	289.283	287.544	289.044	141.0
2018-08-14	CC	Futures	1492.0	1505.0	1481.0	1502.0	22479.0
2018-08-14	CNH	Futures	6.969	6.9774	6.9565	6.9685	333.0
2018-08-14	CSC	Futures	3.294	3.309	3.268	3.309	90.0
2018-08-14	CT	Futures	92.88	93.69	92.76	93.59	10.0
2018-08-14	DC	Futures	26.74	26.91	26.49	26.88	461.0
2018-08-14	DX	Futures	91.121	91.556	90.941	91.495	20760.0
2018-08-14	E1	Futures	1.20636	1.2103	1.20433	1.20492	32115.0
2018-08-14	E6	Futures	1.27852	1.28132	1.27013	1.27114	263133.0
2018-08-14	E7	Futures	1.2721	1.2747	1.2637	1.2647	3538.0
2018-08-14	EBM	Futures	214.99	216.82	212.64	214.99	14385.0
2018-08-14	ED	Futures	95.074	95.0765	95.0594	95.0643	345004.0
2018-08-14	ER	Futures	98.362	98.367	98.357	98.362	55232.0
2018-08-14	EW	Futures	2105.7	2129.4	2104.9	2122.9	9672.0
2018-08-14	FBON	Futures	128.6	129.04	128.6	128.98	156.0
2018-08-14	FBTP	Futures	104.67	105.25	104.51	104.85	74887.0
2018-08-14	FBTS	Futures	101.631	101.863	101.492	101.668	40727.0
2018-08-14	FCE	Futures	4878.8	4909.0	4857.6	4868.0	180626.0
2018-08-14	FDAX	Futures	12942.8	13021.7	12843.0	12919.8	78605.0
2018-08-14	FDXM	Futures	12773.8	12856.4	12678.9	12754.8	35900.0
2018-08-14	FESX	Futures	2852.2	2868.1	2836.3	2848.0	769328.0
2018-08-14	FGBL	Futures	153.92	153.92	153.69	153.79	434945.0
2018-08-14	FGBM	Futures	131.45	131.45	131.37	131.4	280848.0
2018-08-14	FGBS	Futures	112.739	112.739	112.713	112.723	264978.0
2018-08-14	FGBX	Futures	179.48	179.6	178.98	179.22	21859.0
2018-08-14	FMWO	Futures	7127.7	7130.0	7095.1	7114.9	431.0
2018-08-14	FOAT	Futures	140.95	141.14	140.95	141.04	60427.0
2018-08-14	FTDX	Futures	2888.7	2888.7	2844.1	2855.4	405.0
2018-08-14	FTI	Futures	521.13	523.45	519.13	520.25	41434.0
2018-08-14	FTUK	Futures	6804.9	6817.4	6749.7	6772.9	75956.0
2018-08-14	FVSA	Futures	276.98	284.82	270.89	279.6	18582.0
2018-08-14	FXXP	Futures	333.6	334.4	331.7	332.8	31175.0
2018-08-14	G	Futures	115.71	115.84	115.55	115.76	174468.0
2018-08-14	GF	Futures	308.973	310.013	306.945	309.285	3416.0
2018-08-14	GSCI	Futures	518.74	518.74	512.66	512.66	253.0

> showing 50 of 114 rows — these rows as CSV

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