PREVIEW / futures_daily / 2018-07-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-25.parquet
  size:    10 KB
  rows:    115

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-25	ES	Futures	3061.98	3094.84	3056.28	3085.88	1302896.0
2018-07-25	NQ	Futures	8639.92	8779.24	8624.18	8708.7	351372.0
2018-07-25	YM	Futures	26569.9	26817.5	26435.0	26767.0	183826.0
2018-07-25	CL	Futures	71.15	72.11	70.56	71.7	622913.0
2018-07-25	GC	Futures	1562.9	1575.8	1561.6	1572.6	272250.0
2018-07-25	ZN	Futures	118.888517	119.043907	118.670972	118.99729	1673593.0
2018-07-25	A6	Futures	0.76326	0.76789	0.76049	0.76511	108054.0
2018-07-25	AD	Futures	0.77027	0.77832	0.76991	0.7765	98859.0
2018-07-25	B	Futures	54.36	55.03	53.9	54.53	210868.0
2018-07-25	B6	Futures	1.3589	1.365	1.3578	1.3621	97599.0
2018-07-25	BR	Futures	0.20266	0.2057	0.20266	0.2046	22625.0
2018-07-25	BTC	Futures	11809.9	12094.8	11425.3	11589.1	1073.0
2018-07-25	BZ	Futures	54.04	54.51	53.62	54.24	25329.0
2018-07-25	C	Futures	1572.0	1581.0	1560.0	1569.0	9158.0
2018-07-25	CB	Futures	271.053	273.452	270.813	272.792	45.0
2018-07-25	CC	Futures	1608.0	1628.0	1601.0	1609.0	17556.0
2018-07-25	CNH	Futures	6.8916	6.8916	6.8397	6.84	63.0
2018-07-25	CSC	Futures	3.26	3.268	3.246	3.258	67.0
2018-07-25	CT	Futures	99.77	100.29	99.42	99.64	27.0
2018-07-25	DC	Futures	26.03	26.3	25.95	26.13	202.0
2018-07-25	DX	Futures	89.383	89.454	88.938	89.15	19406.0
2018-07-25	E1	Futures	1.20791	1.2115	1.20636	1.20911	20419.0
2018-07-25	E6	Futures	1.31168	1.318	1.3095	1.31369	223726.0
2018-07-25	E7	Futures	1.3049	1.3113	1.3028	1.3071	3340.0
2018-07-25	EBM	Futures	207.14	210.28	206.1	209.76	26926.0
2018-07-25	ED	Futures	95.0205	95.0253	95.0107	95.0156	205810.0
2018-07-25	ER	Futures	98.367	98.367	98.362	98.367	29013.0
2018-07-25	EW	Futures	2103.8	2110.9	2091.4	2108.0	15986.0
2018-07-25	FBON	Futures	129.48	129.6	129.36	129.59	87.0
2018-07-25	FBTP	Futures	108.12	108.55	108.05	108.26	43449.0
2018-07-25	FBTS	Futures	102.716	102.93	102.716	102.856	25144.0
2018-07-25	FCE	Futures	4872.0	4915.0	4854.5	4866.1	64853.0
2018-07-25	FDAX	Futures	13233.9	13314.4	13092.3	13118.9	89247.0
2018-07-25	FDIV	Futures	150.34	150.34	149.71	149.71	4.0
2018-07-25	FDXM	Futures	13063.8	13144.3	12925.5	12951.3	35930.0
2018-07-25	FESX	Futures	2899.8	2920.7	2884.0	2888.1	853784.0
2018-07-25	FEU3	Futures	99.011	99.016	99.011	99.016	227.0
2018-07-25	FGBL	Futures	152.97	153.09	152.55	153.0	441496.0
2018-07-25	FGBM	Futures	131.0	131.05	130.79	130.97	302020.0
2018-07-25	FGBS	Futures	112.658	112.673	112.623	112.648	199698.0
2018-07-25	FGBX	Futures	177.28	177.62	176.39	177.58	30071.0
2018-07-25	FMWO	Futures	7160.3	7171.9	7149.8	7163.8	274.0
2018-07-25	FOAT	Futures	140.81	140.98	140.77	140.89	74611.0
2018-07-25	FTDX	Futures	2852.9	2872.5	2841.6	2851.0	128.0
2018-07-25	FTI	Futures	526.24	530.4	525.13	526.38	24701.0
2018-07-25	FTUK	Futures	6810.7	6819.2	6750.1	6764.8	90254.0
2018-07-25	FVSA	Futures	270.38	274.2	265.6	273.25	15176.0
2018-07-25	FXXP	Futures	334.6	336.5	333.2	333.7	49005.0
2018-07-25	G	Futures	115.65	115.77	115.56	115.68	154244.0
2018-07-25	GF	Futures	316.484	317.209	314.568	316.588	4676.0

> showing 50 of 115 rows — these rows as CSV

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