PREVIEW / futures_daily / 2018-08-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-24.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-08-24	ES	Futures	3104.34	3125.25	3102.17	3124.43	1058571.0
2018-08-24	NQ	Futures	8659.15	8743.68	8654.2	8739.31	278682.0
2018-08-24	YM	Futures	27060.9	27214.8	27030.4	27176.8	111236.0
2018-08-24	CL	Futures	70.73	72.19	70.6	71.58	517796.0
2018-08-24	GC	Futures	1510.3	1540.4	1507.6	1537.8	293979.0
2018-08-24	ZN	Futures	119.851932	119.960705	119.696543	119.851932	1894629.0
2018-08-24	A6	Futures	0.74588	0.75555	0.74454	0.75359	133525.0
2018-08-24	AD	Futures	0.77467	0.77877	0.7732	0.77771	66224.0
2018-08-24	B	Futures	54.48	55.71	54.44	55.27	235091.0
2018-08-24	B6	Futures	1.3229	1.3301	1.3215	1.3265	84262.0
2018-08-24	BR	Futures	0.18529	0.18681	0.18388	0.18521	5797.0
2018-08-24	BTC	Futures	9124.6	9439.2	9124.6	9432.0	240.0
2018-08-24	BZ	Futures	54.41	55.62	54.38	55.19	19745.0
2018-08-24	C	Futures	1573.0	1592.0	1570.0	1586.0	2907.0
2018-08-24	CB	Futures	270.876	270.876	270.876	270.876	2.0
2018-08-24	CC	Futures	1636.0	1659.0	1631.0	1651.0	16173.0
2018-08-24	CNH	Futures	6.9689	6.9714	6.8724	6.8738	362.0
2018-08-24	CSC	Futures	3.286	3.307	3.286	3.307	105.0
2018-08-24	CT	Futures	91.96	92.82	91.79	91.79	10.0
2018-08-24	DC	Futures	26.73	27.06	26.69	27.01	378.0
2018-08-24	DX	Futures	90.515	90.552	89.913	90.034	23377.0
2018-08-24	E1	Futures	1.21401	1.2201	1.21341	1.21771	27200.0
2018-08-24	E6	Futures	1.29289	1.3038	1.292	1.30217	240625.0
2018-08-24	E7	Futures	1.2865	1.2976	1.2855	1.2956	4062.0
2018-08-24	EBM	Futures	212.11	213.16	209.76	210.02	5972.0
2018-08-24	ED	Futures	95.0911	95.0911	95.0765	95.0862	219636.0
2018-08-24	ER	Futures	98.367	98.372	98.362	98.367	30753.0
2018-08-24	EW	Futures	2148.2	2159.3	2147.6	2155.3	7874.0
2018-08-24	FBON	Futures	129.59	129.61	129.29	129.4	198.0
2018-08-24	FBTP	Futures	104.99	105.14	104.27	104.46	55271.0
2018-08-24	FBTS	Futures	102.021	102.03	101.706	101.743	28724.0
2018-08-24	FCE	Futures	4886.9	4910.8	4883.3	4894.6	42324.0
2018-08-24	FDAX	Futures	12941.8	13008.1	12895.8	12954.3	62822.0
2018-08-24	FDXM	Futures	12778.0	12840.9	12732.6	12788.8	30594.0
2018-08-24	FESX	Futures	2858.9	2869.8	2853.9	2863.9	528948.0
2018-08-24	FEU3	Futures	99.021	99.021	99.016	99.016	198.0
2018-08-24	FGBL	Futures	153.6	153.74	153.4	153.68	500671.0
2018-08-24	FGBM	Futures	131.28	131.3	131.17	131.26	273673.0
2018-08-24	FGBS	Futures	112.668	112.678	112.648	112.663	160315.0
2018-08-24	FGBX	Futures	178.62	178.94	178.1	178.74	18602.0
2018-08-24	FMWO	Futures	7173.1	7208.0	7167.3	7198.7	873.0
2018-08-24	FOAT	Futures	141.15	141.26	140.94	141.14	98062.0
2018-08-24	FTDX	Futures	2912.2	2927.0	2899.0	2926.0	116.0
2018-08-24	FTI	Futures	518.25	520.66	518.21	519.5	14902.0
2018-08-24	FTUK	Futures	6720.3	6755.5	6709.6	6752.4	55313.0
2018-08-24	FVSA	Futures	261.3	262.18	255.21	256.95	18546.0
2018-08-24	FXXP	Futures	331.6	332.8	331.1	332.0	24091.0
2018-08-24	G	Futures	114.81	114.93	114.62	114.87	486094.0
2018-08-24	GF	Futures	310.065	312.197	306.321	306.789	3896.0
2018-08-24	GSCI	Futures	522.74	524.82	522.18	522.18	108.0

> showing 50 of 113 rows — these rows as CSV

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