PREVIEW / futures_daily / 2018-07-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-27.parquet
  size:    10 KB
  rows:    112

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-27	ES	Futures	3084.79	3092.12	3050.58	3060.08	1492056.0
2018-07-27	NQ	Futures	8662.07	8705.79	8468.53	8512.54	534684.0
2018-07-27	YM	Futures	26874.4	26945.0	26709.0	26778.5	194279.0
2018-07-27	CL	Futures	71.99	72.19	70.62	71.07	460450.0
2018-07-27	GC	Futures	1560.7	1567.2	1554.2	1562.3	156036.0
2018-07-27	ZN	Futures	118.670972	118.857439	118.593277	118.779744	1273355.0
2018-07-27	A6	Futures	0.75894	0.76275	0.75812	0.76162	73900.0
2018-07-27	AD	Futures	0.77503	0.77731	0.77503	0.77574	50593.0
2018-07-27	B	Futures	54.72	54.96	54.2	54.5	203340.0
2018-07-27	B6	Futures	1.3553	1.3574	1.3525	1.3556	78187.0
2018-07-27	BR	Futures	0.20262	0.20456	0.20262	0.2041	5120.0
2018-07-27	BTC	Futures	11368.3	11767.2	11076.3	11681.7	9284.0
2018-07-27	BZ	Futures	54.56	54.87	54.12	54.42	17721.0
2018-07-27	C	Futures	1615.0	1629.0	1567.0	1571.0	11997.0
2018-07-27	CB	Futures	273.452	274.351	273.032	273.452	59.0
2018-07-27	CC	Futures	1665.0	1672.0	1586.0	1601.0	25049.0
2018-07-27	CNH	Futures	6.9061	6.9258	6.8803	6.8969	59.0
2018-07-27	CSC	Futures	3.206	3.256	3.206	3.23	56.0
2018-07-27	DC	Futures	25.86	26.25	25.68	26.06	199.0
2018-07-27	DX	Futures	89.544	89.691	89.425	89.463	15966.0
2018-07-27	E1	Futures	1.20672	1.20803	1.20253	1.20707	22844.0
2018-07-27	E6	Futures	1.30659	1.30922	1.3043	1.30838	202612.0
2018-07-27	E7	Futures	1.2998	1.3025	1.2976	1.3017	3026.0
2018-07-27	EBM	Futures	208.97	210.02	206.36	207.4	16801.0
2018-07-27	ED	Futures	95.0107	95.0156	95.0059	95.0107	143240.0
2018-07-27	ER	Futures	98.367	98.367	98.362	98.367	18586.0
2018-07-27	EW	Futures	2117.2	2121.6	2085.9	2092.8	13415.0
2018-07-27	FBON	Futures	129.38	129.44	129.25	129.36	19.0
2018-07-27	FBTP	Futures	107.94	108.17	107.56	107.68	52485.0
2018-07-27	FBTS	Futures	102.772	102.856	102.614	102.707	34034.0
2018-07-27	FCE	Futures	4913.2	4946.4	4910.5	4943.3	53554.0
2018-07-27	FDAX	Futures	13403.8	13464.4	13363.0	13448.2	75807.0
2018-07-27	FDIV	Futures	152.99	152.99	152.9	152.9	30.0
2018-07-27	FDXM	Futures	13235.1	13291.9	13191.8	13276.4	27132.0
2018-07-27	FESX	Futures	2925.7	2944.1	2924.0	2943.3	663408.0
2018-07-27	FGBL	Futures	152.7	152.86	152.62	152.71	456075.0
2018-07-27	FGBM	Futures	130.87	130.96	130.84	130.9	254119.0
2018-07-27	FGBS	Futures	112.633	112.658	112.628	112.643	163485.0
2018-07-27	FGBX	Futures	176.43	177.0	176.29	176.51	26032.0
2018-07-27	FMWO	Futures	7210.4	7223.2	7164.9	7203.4	460.0
2018-07-27	FOAT	Futures	140.67	140.83	140.62	140.68	86686.0
2018-07-27	FTDX	Futures	2888.2	2904.9	2882.3	2893.1	128.0
2018-07-27	FTI	Futures	527.49	530.12	526.52	529.47	17614.0
2018-07-27	FTUK	Futures	6788.0	6822.8	6777.3	6810.7	71787.0
2018-07-27	FVSA	Futures	257.96	267.51	253.18	257.0	20541.0
2018-07-27	FXXP	Futures	337.1	338.3	336.4	338.2	29862.0
2018-07-27	G	Futures	115.55	115.69	115.44	115.53	125012.0
2018-07-27	GF	Futures	313.118	316.277	312.393	315.5	5918.0
2018-07-27	GSCI	Futures	526.35	526.35	523.36	523.36	5.0
2018-07-27	HE	Futures	71.567	71.818	70.787	70.926	6648.0

> showing 50 of 112 rows — these rows as CSV

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