PREVIEW / futures_daily / 2018-08-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-23.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-23	ES	Futures	3108.14	3116.83	3100.54	3104.07	1050042.0
2018-08-23	NQ	Futures	8666.73	8715.12	8640.79	8656.24	356371.0
2018-08-23	YM	Futures	27112.6	27150.5	26981.9	27049.3	127109.0
2018-08-23	CL	Futures	70.9	70.95	70.12	70.65	450690.0
2018-08-23	GC	Futures	1524.5	1525.2	1508.5	1513.3	232882.0
2018-08-23	ZN	Futures	119.945166	120.0384	119.836393	119.929627	1382001.0
2018-08-23	A6	Futures	0.75617	0.75627	0.74475	0.74526	117022.0
2018-08-23	AD	Futures	0.77963	0.77984	0.77346	0.77396	59557.0
2018-08-23	B	Futures	54.47	54.58	54.1	54.48	199661.0
2018-08-23	B6	Futures	1.3333	1.3338	1.3222	1.3232	97518.0
2018-08-23	BR	Futures	0.18753	0.18826	0.18445	0.18529	3787.0
2018-08-23	BTC	Futures	9046.2	9210.0	8868.1	9124.6	3554.0
2018-08-23	BZ	Futures	54.52	54.52	54.02	54.4	14222.0
2018-08-23	C	Futures	1549.0	1571.0	1539.0	1569.0	2412.0
2018-08-23	CB	Futures	268.563	270.456	268.563	269.464	12.0
2018-08-23	CC	Futures	1613.0	1637.0	1594.0	1632.0	18012.0
2018-08-23	CNH	Futures	6.9266	6.9657	6.9266	6.9657	272.0
2018-08-23	CSC	Futures	3.248	3.288	3.248	3.288	67.0
2018-08-23	CT	Futures	92.56	92.56	91.45	91.7	5.0
2018-08-23	DC	Futures	26.33	26.79	26.31	26.74	325.0
2018-08-23	DX	Futures	90.05	90.567	90.05	90.527	18332.0
2018-08-23	E1	Futures	1.21807	1.21891	1.21341	1.21389	24855.0
2018-08-23	E6	Futures	1.29899	1.29943	1.29155	1.29233	222981.0
2018-08-23	E7	Futures	1.2923	1.2928	1.2851	1.2858	3805.0
2018-08-23	EBM	Futures	214.47	214.73	210.8	213.42	8254.0
2018-08-23	ED	Futures	95.0886	95.0984	95.0886	95.0935	214068.0
2018-08-23	ER	Futures	98.367	98.372	98.362	98.367	50568.0
2018-08-23	EW	Futures	2155.9	2158.0	2143.2	2147.4	11967.0
2018-08-23	FBON	Futures	129.65	129.68	129.45	129.53	199.0
2018-08-23	FBTP	Futures	105.15	105.39	104.51	104.73	61644.0
2018-08-23	FBTS	Futures	102.002	102.067	101.835	101.891	26328.0
2018-08-23	FCE	Futures	4876.1	4899.1	4875.6	4882.4	37904.0
2018-08-23	FDAX	Futures	12913.5	12971.0	12905.7	12926.1	55415.0
2018-08-23	FDXM	Futures	12750.1	12804.8	12740.8	12760.9	27439.0
2018-08-23	FESX	Futures	2852.2	2864.7	2850.5	2854.7	516284.0
2018-08-23	FEU3	Futures	99.021	99.021	99.016	99.016	50.0
2018-08-23	FGBL	Futures	153.8	153.81	153.52	153.65	454943.0
2018-08-23	FGBM	Futures	131.38	131.38	131.2	131.26	370760.0
2018-08-23	FGBS	Futures	112.688	112.688	112.648	112.663	284860.0
2018-08-23	FGBX	Futures	179.26	179.4	178.58	178.72	26275.0
2018-08-23	FMWO	Futures	7192.9	7192.9	7161.4	7162.6	545.0
2018-08-23	FOAT	Futures	141.2	141.25	141.07	141.14	90443.0
2018-08-23	FTDX	Futures	2889.7	2907.8	2886.8	2900.0	194.0
2018-08-23	FTI	Futures	518.11	520.57	517.28	518.02	14072.0
2018-08-23	FTUK	Futures	6740.8	6769.3	6710.5	6735.4	74642.0
2018-08-23	FVSA	Futures	264.79	266.53	260.43	262.18	22695.0
2018-08-23	FXXP	Futures	331.6	333.2	331.0	331.5	27946.0
2018-08-23	G	Futures	115.82	115.85	115.58	115.68	464020.0
2018-08-23	GF	Futures	310.013	310.741	308.401	310.273	2965.0
2018-08-23	GSCI	Futures	516.54	517.73	515.75	517.73	18.0

> showing 50 of 114 rows — these rows as CSV

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