PREVIEW / futures_daily / 2018-06-28

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-28.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-06-28	ES	Futures	2937.89	2960.97	2925.13	2953.64	1678667.0
2018-06-28	NQ	Futures	8159.86	8250.51	8110.01	8231.85	483220.0
2018-06-28	YM	Futures	25440.4	25599.5	25265.4	25520.4	263092.0
2018-06-28	CL	Futures	73.2	74.99	73.13	74.4	717347.0
2018-06-28	GC	Futures	1600.4	1603.3	1592.3	1597.1	241824.0
2018-06-28	ZN	Futures	119.712082	119.789776	119.494536	119.525614	1409221.0
2018-06-28	A6	Futures	0.75534	0.7573	0.75411	0.75586	98960.0
2018-06-28	AD	Futures	0.7608	0.76596	0.75968	0.76424	90525.0
2018-06-28	B	Futures	57.06	57.68	56.85	57.25	426008.0
2018-06-28	B6	Futures	1.3583	1.3585	1.351	1.3529	133168.0
2018-06-28	BR	Futures	0.19668	0.19744	0.19637	0.19656	116.0
2018-06-28	BTC	Futures	8682.9	8739.9	8526.2	8640.2	521.0
2018-06-28	BZ	Futures	56.53	57.37	56.53	56.94	35911.0
2018-06-28	C	Futures	1650.0	1722.0	1635.0	1715.0	3070.0
2018-06-28	CB	Futures	277.56	278.249	275.881	277.95	39.0
2018-06-28	CC	Futures	1697.0	1768.0	1678.0	1757.0	24946.0
2018-06-28	CNH	Futures	6.7062	6.7305	6.7055	6.7285	76.0
2018-06-28	CSC	Futures	3.339	3.341	3.333	3.335	33.0
2018-06-28	CT	Futures	96.41	96.47	94.89	94.89	10.0
2018-06-28	DC	Futures	26.49	26.66	26.33	26.53	191.0
2018-06-28	DX	Futures	89.946	90.216	89.776	90.066	19785.0
2018-06-28	E1	Futures	1.20707	1.20779	1.20397	1.20468	22343.0
2018-06-28	E6	Futures	1.30016	1.30503	1.29669	1.29994	264551.0
2018-06-28	E7	Futures	1.2937	1.2984	1.2901	1.2934	4194.0
2018-06-28	EBM	Futures	182.3	183.87	181.77	182.03	11539.0
2018-06-28	ED	Futures	94.9961	94.9961	94.9864	94.9864	165158.0
2018-06-28	ER	Futures	98.362	98.367	98.357	98.362	92576.0
2018-06-28	EW	Futures	2062.4	2073.3	2049.5	2068.8	15137.0
2018-06-28	FBON	Futures	128.63	128.84	128.52	128.67	479.0
2018-06-28	FBTP	Futures	106.38	106.95	105.99	106.78	77036.0
2018-06-28	FBTS	Futures	102.216	102.364	102.077	102.262	41610.0
2018-06-28	FCE	Futures	4760.6	4797.5	4715.3	4737.7	113011.0
2018-06-28	FDAX	Futures	12833.0	12921.9	12634.4	12694.0	120459.0
2018-06-28	FDXM	Futures	12673.7	12757.3	12472.5	12531.8	53814.0
2018-06-28	FESX	Futures	2813.8	2835.5	2787.1	2798.8	1191558.0
2018-06-28	FEU3	Futures	99.011	99.011	99.011	99.011	33.0
2018-06-28	FGBL	Futures	153.04	153.27	152.82	153.08	512915.0
2018-06-28	FGBM	Futures	131.28	131.35	131.17	131.26	287482.0
2018-06-28	FGBS	Futures	112.804	112.814	112.774	112.789	235322.0
2018-06-28	FGBX	Futures	176.23	177.14	175.91	176.87	39403.0
2018-06-28	FMWO	Futures	6916.9	6937.8	6885.4	6918.0	1986.0
2018-06-28	FOAT	Futures	140.49	140.75	140.39	140.71	99384.0
2018-06-28	FTDX	Futures	2672.5	2672.5	2571.5	2583.3	338.0
2018-06-28	FTI	Futures	506.94	509.84	501.95	505.27	39580.0
2018-06-28	FTUK	Futures	6708.7	6767.1	6694.0	6727.4	115481.0
2018-06-28	FVSA	Futures	327.52	347.93	322.66	340.16	37889.0
2018-06-28	FXXP	Futures	325.9	327.4	322.8	324.0	74353.0
2018-06-28	G	Futures	115.75	115.84	115.54	115.65	185828.0
2018-06-28	GF	Futures	301.206	305.246	300.896	304.158	4828.0
2018-06-28	GSCI	Futures	539.26	543.24	538.98	539.49	660.0

> showing 50 of 113 rows — these rows as CSV

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