PREVIEW / futures_daily / 2019-04-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-09.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
2019-04-09	ES	Futures	3130.89	3132.51	3107.93	3113.6	1182395.0
2019-04-09	NQ	Futures	8786.43	8795.64	8732.27	8748.98	389517.0
2019-04-09	YM	Futures	27808.6	27812.9	27554.3	27611.3	156731.0
2019-04-09	CL	Futures	66.13	66.53	65.39	65.7	790677.0
2019-04-09	GC	Futures	1620.0	1631.0	1618.8	1628.3	200341.0
2019-04-09	ZN	Futures	122.777433	123.072683	122.730814	122.963907	1254979.0
2019-04-09	A6	Futures	0.73559	0.73838	0.73487	0.73539	75113.0
2019-04-09	AD	Futures	0.76075	0.76227	0.75954	0.76009	52802.0
2019-04-09	B	Futures	51.85	51.96	51.2	51.43	267491.0
2019-04-09	B6	Futures	1.343	1.3487	1.3394	1.3405	109191.0
2019-04-09	BR	Futures	0.20729	0.20729	0.20693	0.20693	3.0
2019-04-09	BTC	Futures	8173.6	8220.0	7957.3	8065.5	8967.0
2019-04-09	BZ	Futures	51.63	51.82	51.06	51.29	37189.0
2019-04-09	C	Futures	1592.0	1608.0	1559.0	1605.0	9719.0
2019-04-09	CB	Futures	276.809	276.988	275.732	276.061	54.0
2019-04-09	CC	Futures	1616.0	1633.0	1595.0	1628.0	41343.0
2019-04-09	CNH	Futures	6.7259	6.7315	6.723	6.7277	325.0
2019-04-09	CSC	Futures	2.871	2.891	2.854	2.891	102.0
2019-04-09	CT	Futures	83.74	84.2	82.35	82.91	31732.0
2019-04-09	DC	Futures	24.25	24.4	24.11	24.4	179.0
2019-04-09	DX	Futures	92.665	92.689	92.459	92.603	9463.0
2019-04-09	E1	Futures	1.17554	1.17694	1.17344	1.17496	24700.0
2019-04-09	E6	Futures	1.24326	1.24573	1.24244	1.24375	131389.0
2019-04-09	E7	Futures	1.237	1.2395	1.2362	1.2376	3417.0
2019-04-09	EBM	Futures	200.31	201.1	199.78	200.31	19929.0
2019-04-09	ED	Futures	95.1453	95.1599	95.1453	95.1599	251520.0
2019-04-09	ER	Futures	98.421	98.421	98.416	98.416	48161.0
2019-04-09	EW	Futures	2073.3	2073.5	2046.0	2049.3	10225.0
2019-04-09	FBON	Futures	135.02	135.25	135.01	135.2	199.0
2019-04-09	FBTP	Futures	114.77	115.66	114.75	115.41	105055.0
2019-04-09	FBTS	Futures	105.684	105.855	105.674	105.817	49092.0
2019-04-09	FCE	Futures	4858.6	4889.3	4837.2	4840.3	83738.0
2019-04-09	FDAX	Futures	12600.1	12646.9	12491.1	12520.1	115823.0
2019-04-09	FDIV	Futures	147.2	147.2	146.42	146.42	9.0
2019-04-09	FDXM	Futures	12500.3	12536.8	12383.4	12411.6	48893.0
2019-04-09	FESX	Futures	2940.1	2950.5	2918.2	2927.8	928715.0
2019-04-09	FGBL	Futures	159.53	159.87	159.35	159.71	544323.0
2019-04-09	FGBM	Futures	132.92	132.98	132.83	132.95	366317.0
2019-04-09	FGBS	Futures	112.754	112.764	112.718	112.739	255873.0
2019-04-09	FGBX	Futures	193.36	194.37	192.98	193.86	29980.0
2019-04-09	FMWO	Futures	7212.6	7233.5	7186.0	7199.9	885.0
2019-04-09	FOAT	Futures	146.61	146.99	146.6	146.87	84741.0
2019-04-09	FTDX	Futures	2721.5	2731.8	2704.7	2709.1	65.0
2019-04-09	FTI	Futures	525.52	528.38	523.32	523.9	22417.0
2019-04-09	FTUK	Futures	6785.7	6799.9	6738.9	6757.7	94251.0
2019-04-09	FVSA	Futures	242.75	246.83	236.24	241.12	29591.0
2019-04-09	FXXP	Futures	340.7	342.8	339.3	340.1	47003.0
2019-04-09	G	Futures	118.15	118.29	117.88	118.14	180896.0
2019-04-09	GF	Futures	314.583	314.583	312.07	312.552	733.0
2019-04-09	GSCI	Futures	508.96	509.98	508.57	509.02	2435.0

> showing 50 of 114 rows — these rows as CSV

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