PREVIEW / futures_daily / 2017-09-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-19.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-09-19	ES	Futures	2722.23	2725.76	2720.32	2724.4	961109.0
2017-09-19	NQ	Futures	7035.63	7053.25	7018.3	7044.15	212483.0
2017-09-19	YM	Futures	23547.6	23594.1	23544.5	23586.7	84470.0
2017-09-19	CL	Futures	51.05	51.5	50.39	50.56	748119.0
2017-09-19	GC	Futures	1667.5	1673.6	1665.2	1667.6	275307.0
2017-09-19	ZN	Futures	124.317825	124.441065	124.163776	124.209991	1100219.0
2017-09-19	A6	Futures	0.81778	0.82426	0.81778	0.82344	85267.0
2017-09-19	AD	Futures	0.8279	0.8306	0.82699	0.82953	61256.0
2017-09-19	B	Futures	38.91	39.19	38.49	38.67	221760.0
2017-09-19	B6	Futures	1.4111	1.4167	1.4082	1.4138	136627.0
2017-09-19	BR	Futures	0.24018	0.24018	0.23834	0.23834	2.0
2017-09-19	BZ	Futures	38.55	38.85	38.16	38.34	19337.0
2017-09-19	C	Futures	1439.0	1455.0	1428.0	1436.0	8712.0
2017-09-19	CB	Futures	314.933	317.452	314.933	316.193	15.0
2017-09-19	CC	Futures	1459.0	1482.0	1443.0	1459.0	19698.0
2017-09-19	CNH	Futures	6.7972	6.7985	6.7913	6.7913	22.0
2017-09-19	CSC	Futures	3.379	3.398	3.373	3.387	31.0
2017-09-19	CT	Futures	82.5	82.79	81.67	81.67	20.0
2017-09-19	DC	Futures	27.61	27.68	27.47	27.61	87.0
2017-09-19	DX	Futures	85.815	85.89	85.581	85.624	24294.0
2017-09-19	E1	Futures	1.27847	1.28152	1.27443	1.27749	23458.0
2017-09-19	E6	Futures	1.37044	1.3766	1.37016	1.37552	199854.0
2017-09-19	E7	Futures	1.3633	1.3693	1.3633	1.3683	5191.0
2017-09-19	EBM	Futures	174.51	175.86	173.97	174.78	14683.0
2017-09-19	ED	Futures	95.5327	95.5424	95.523	95.5327	254355.0
2017-09-19	ER	Futures	98.337	98.342	98.337	98.342	51312.0
2017-09-19	EW	Futures	1873.9	1877.0	1871.7	1872.4	8320.0
2017-09-19	FBON	Futures	125.01	125.59	124.94	125.26	300.0
2017-09-19	FBTP	Futures	109.03	109.44	108.98	109.15	84695.0
2017-09-19	FBTS	Futures	103.228	103.274	103.219	103.237	40678.0
2017-09-19	FCE	Futures	4681.4	4683.7	4666.2	4682.3	46142.0
2017-09-19	FDAX	Futures	13199.8	13206.1	13152.5	13191.4	54363.0
2017-09-19	FDIV	Futures	145.85	146.36	145.85	146.36	60.0
2017-09-19	FDXM	Futures	13088.4	13093.6	13042.6	13080.1	15175.0
2017-09-19	FESX	Futures	2868.3	2869.9	2860.1	2868.3	545284.0
2017-09-19	FEU3	Futures	99.011	99.011	99.006	99.006	20.0
2017-09-19	FGBL	Futures	148.87	149.21	148.79	148.95	633854.0
2017-09-19	FGBM	Futures	129.47	129.6	129.43	129.5	464822.0
2017-09-19	FGBS	Futures	112.407	112.422	112.392	112.392	194529.0
2017-09-19	FGBX	Futures	166.32	167.34	166.15	166.6	39094.0
2017-09-19	FMWO	Futures	6629.3	6637.6	6629.3	6631.7	716.0
2017-09-19	FOAT	Futures	136.3	136.55	136.16	136.31	83573.0
2017-09-19	FTDX	Futures	2377.7	2401.1	2377.7	2392.7	141.0
2017-09-19	FTI	Futures	487.33	487.42	486.0	486.64	16418.0
2017-09-19	FTUK	Futures	6271.1	6286.8	6248.1	6275.0	95678.0
2017-09-19	FVSA	Futures	425.68	431.35	417.16	422.84	36146.0
2017-09-19	FXXP	Futures	322.9	323.6	322.4	323.5	23316.0
2017-09-19	G	Futures	113.91	114.09	113.51	113.65	226974.0
2017-09-19	GF	Futures	331.742	333.924	330.814	333.488	4061.0
2017-09-19	GSCI	Futures	474.06	474.06	471.13	471.13	4.0

> showing 50 of 110 rows — these rows as CSV

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