PREVIEW / futures_daily / 2018-07-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-23.parquet
  size:    10 KB
  rows:    113

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-07-23	ES	Futures	3046.78	3054.65	3032.93	3054.11	812481.0
2018-07-23	NQ	Futures	8590.37	8665.86	8524.49	8663.23	287213.0
2018-07-23	YM	Futures	26435.0	26435.0	26291.7	26377.1	114420.0
2018-07-23	CL	Futures	70.53	71.71	69.94	70.24	555915.0
2018-07-23	GC	Futures	1572.5	1577.0	1560.4	1564.7	333328.0
2018-07-23	ZN	Futures	119.354686	119.447919	118.795283	118.826361	1631269.0
2018-07-23	A6	Futures	0.76367	0.76511	0.75833	0.75894	83154.0
2018-07-23	AD	Futures	0.77168	0.77305	0.76915	0.76946	51187.0
2018-07-23	B	Futures	54.01	54.95	53.49	53.89	316980.0
2018-07-23	B6	Futures	1.3581	1.3607	1.3528	1.3546	94213.0
2018-07-23	BR	Futures	0.20052	0.20071	0.19957	0.2003	362.0
2018-07-23	BTC	Futures	10513.5	11140.4	10449.4	11019.3	8545.0
2018-07-23	BZ	Futures	53.5	54.65	53.21	53.6	29479.0
2018-07-23	C	Futures	1623.0	1627.0	1596.0	1600.0	8184.0
2018-07-23	CB	Futures	276.151	276.6	274.651	276.21	27.0
2018-07-23	CC	Futures	1670.0	1674.0	1631.0	1648.0	24398.0
2018-07-23	CNH	Futures	6.8469	6.9005	6.845	6.8927	56.0
2018-07-23	CSC	Futures	3.21	3.224	3.196	3.202	68.0
2018-07-23	CT	Futures	98.15	98.31	97.89	98.15	5.0
2018-07-23	DC	Futures	25.76	25.91	25.66	25.71	79.0
2018-07-23	DX	Futures	89.212	89.492	88.999	89.444	15262.0
2018-07-23	E1	Futures	1.2103	1.21257	1.20755	1.20887	19777.0
2018-07-23	E6	Futures	1.31677	1.31973	1.31196	1.31263	187511.0
2018-07-23	E7	Futures	1.3095	1.313	1.3054	1.3059	2532.0
2018-07-23	EBM	Futures	200.34	202.17	200.34	201.91	14611.0
2018-07-23	ED	Futures	94.9961	95.0107	94.9961	95.0059	283436.0
2018-07-23	ER	Futures	98.367	98.372	98.362	98.367	44738.0
2018-07-23	EW	Futures	2119.3	2122.2	2108.8	2117.5	10076.0
2018-07-23	FBON	Futures	128.98	129.44	128.93	129.13	46.0
2018-07-23	FBTP	Futures	108.9	109.2	108.3	108.38	41789.0
2018-07-23	FBTS	Futures	102.958	103.078	102.828	102.893	23300.0
2018-07-23	FCE	Futures	4830.2	4835.2	4804.7	4823.5	46753.0
2018-07-23	FDAX	Futures	13086.0	13156.6	13042.6	13106.9	65268.0
2018-07-23	FDXM	Futures	12929.7	12989.5	12876.0	12939.5	26020.0
2018-07-23	FESX	Futures	2874.8	2888.1	2867.2	2879.8	707828.0
2018-07-23	FEU3	Futures	99.021	99.021	99.016	99.016	99.0
2018-07-23	FGBL	Futures	153.03	153.16	152.62	152.74	570469.0
2018-07-23	FGBM	Futures	131.04	131.09	130.86	130.92	338814.0
2018-07-23	FGBS	Futures	112.678	112.693	112.643	112.648	205557.0
2018-07-23	FGBX	Futures	177.14	177.4	176.03	176.29	35900.0
2018-07-23	FMWO	Futures	7124.2	7134.7	7107.9	7119.5	1346.0
2018-07-23	FOAT	Futures	140.83	140.94	140.5	140.58	132832.0
2018-07-23	FTDX	Futures	2811.7	2830.9	2803.4	2826.9	465.0
2018-07-23	FTI	Futures	524.62	525.78	522.31	524.16	22010.0
2018-07-23	FTUK	Futures	6768.9	6785.3	6733.2	6766.6	58592.0
2018-07-23	FVSA	Futures	278.02	282.8	274.2	276.11	15114.0
2018-07-23	FXXP	Futures	331.6	332.5	330.6	331.7	29791.0
2018-07-23	G	Futures	115.87	116.06	115.59	115.67	170103.0
2018-07-23	GF	Futures	318.452	318.452	316.536	317.468	4278.0
2018-07-23	GSCI	Futures	518.85	519.08	515.64	515.7	19.0

> showing 50 of 113 rows — these rows as CSV

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