PREVIEW / futures_daily / 2018-08-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-27.parquet
  size:    10 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
2018-08-27	ES	Futures	3125.52	3149.14	3124.43	3148.05	961496.0
2018-08-27	NQ	Futures	8743.1	8824.71	8742.81	8823.55	280533.0
2018-08-27	YM	Futures	27194.8	27489.8	27190.5	27477.1	108051.0
2018-08-27	CL	Futures	71.42	71.84	71.18	71.74	332612.0
2018-08-27	GC	Futures	1539.3	1544.7	1532.7	1541.2	209187.0
2018-08-27	ZN	Futures	119.945166	119.991783	119.649926	119.681004	1687935.0
2018-08-27	A6	Futures	0.75431	0.75678	0.75164	0.75575	78436.0
2018-08-27	AD	Futures	0.77827	0.78227	0.77538	0.78151	77711.0
2018-08-27	B	Futures	55.27	55.86	55.18	55.76	83002.0
2018-08-27	B6	Futures	1.3262	1.3321	1.3246	1.3311	51134.0
2018-08-27	BR	Futures	0.18521	0.1886	0.18513	0.18513	1908.0
2018-08-27	BTC	Futures	9510.7	9625.1	9510.7	9603.7	379.0
2018-08-27	BZ	Futures	55.19	55.62	54.95	55.52	6014.0
2018-08-27	CB	Futures	272.979	274.842	272.979	273.43	18.0
2018-08-27	CC	Futures	1652.0	1674.0	1624.0	1638.0	12588.0
2018-08-27	CNH	Futures	6.8627	6.8875	6.8627	6.8721	213.0
2018-08-27	CSC	Futures	3.307	3.341	3.307	3.319	50.0
2018-08-27	CT	Futures	92.18	93.71	92.18	93.71	2.0
2018-08-27	DC	Futures	27.01	27.31	26.99	27.15	137.0
2018-08-27	DX	Futures	90.05	90.193	89.591	89.675	18839.0
2018-08-27	E1	Futures	1.21759	1.22309	1.2158	1.22189	17565.0
2018-08-27	E6	Futures	1.30212	1.30978	1.29865	1.30805	192624.0
2018-08-27	E7	Futures	1.2951	1.303	1.292	1.3014	2991.0
2018-08-27	EBM	Futures	209.5	209.5	205.84	206.1	9998.0
2018-08-27	ED	Futures	95.0838	95.0838	95.0765	95.0789	106256.0
2018-08-27	ER	Futures	98.367	98.372	98.362	98.367	14112.0
2018-08-27	EW	Futures	2157.3	2175.7	2157.2	2165.7	9897.0
2018-08-27	FBON	Futures	129.43	129.51	129.14	129.19	93.0
2018-08-27	FBTP	Futures	104.4	104.83	104.17	104.25	29256.0
2018-08-27	FBTS	Futures	101.678	101.826	101.631	101.678	19175.0
2018-08-27	FCE	Futures	4910.3	4945.0	4907.6	4936.9	42175.0
2018-08-27	FDAX	Futures	12987.7	13130.4	12986.7	13109.5	64395.0
2018-08-27	FDIV	Futures	149.13	149.58	149.13	149.58	6.0
2018-08-27	FDXM	Futures	12824.4	12962.7	12820.3	12942.1	25285.0
2018-08-27	FESX	Futures	2869.8	2889.8	2866.4	2887.3	523231.0
2018-08-27	FGBL	Futures	153.75	153.93	153.17	153.25	391910.0
2018-08-27	FGBM	Futures	131.27	131.33	131.09	131.11	241561.0
2018-08-27	FGBS	Futures	112.668	112.673	112.633	112.643	137063.0
2018-08-27	FGBX	Futures	178.8	179.4	177.3	177.46	22859.0
2018-08-27	FMWO	Futures	7218.5	7274.4	7218.5	7267.4	2373.0
2018-08-27	FOAT	Futures	141.18	141.32	140.71	140.77	83366.0
2018-08-27	FTDX	Futures	2933.3	2970.6	2933.3	2966.2	229.0
2018-08-27	FTI	Futures	520.01	523.86	520.01	523.12	13695.0
2018-08-27	FVSA	Futures	255.21	256.08	252.59	253.47	15876.0
2018-08-27	FXXP	Futures	333.0	334.3	332.3	334.1	20959.0
2018-08-27	GF	Futures	305.593	314.954	304.708	313.446	5115.0
2018-08-27	GSCI	Futures	522.01	523.81	522.01	523.47	16.0
2018-08-27	HE	Futures	70.11	74.172	69.974	74.172	24166.0
2018-08-27	HG	Futures	3.1369	3.1588	3.1289	3.1473	33532.0
2018-08-27	HH	Futures	18.645	18.645	18.427	18.452	2875.0

> showing 50 of 110 rows — these rows as CSV

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