PREVIEW / futures_daily / 2018-08-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-09.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-08-09	ES	Futures	3099.18	3109.23	3095.92	3099.45	696695.0
2018-08-09	NQ	Futures	8701.71	8750.68	8696.17	8715.7	236834.0
2018-08-09	YM	Futures	26874.4	26977.7	26826.0	26861.8	96582.0
2018-08-09	CL	Futures	69.1	69.74	68.79	69.12	509401.0
2018-08-09	GC	Futures	1548.8	1553.3	1544.2	1546.1	232037.0
2018-08-09	ZN	Futures	118.872978	119.13714	118.8419	119.059446	1137612.0
2018-08-09	A6	Futures	0.7647	0.76666	0.75843	0.75966	105095.0
2018-08-09	AD	Futures	0.77852	0.77958	0.77568	0.77731	48642.0
2018-08-09	B	Futures	52.6	53.13	52.38	52.54	197055.0
2018-08-09	B6	Futures	1.3313	1.3339	1.324	1.3273	105490.0
2018-08-09	BR	Futures	0.20174	0.20174	0.19892	0.19991	4094.0
2018-08-09	BTC	Futures	8975.0	9324.0	8789.8	9202.9	6827.0
2018-08-09	BZ	Futures	52.51	53.05	52.3	52.46	15939.0
2018-08-09	C	Futures	1480.0	1493.0	1460.0	1467.0	5485.0
2018-08-09	CB	Futures	280.108	281.128	280.108	280.648	10.0
2018-08-09	CC	Futures	1501.0	1510.0	1479.0	1487.0	23282.0
2018-08-09	CNH	Futures	6.8995	6.9121	6.8894	6.9121	395.0
2018-08-09	CSC	Futures	3.256	3.288	3.256	3.282	127.0
2018-08-09	CT	Futures	98.04	98.04	97.67	97.91	15.0
2018-08-09	DC	Futures	26.25	26.74	26.25	26.64	608.0
2018-08-09	DX	Futures	89.932	90.434	89.852	90.311	19152.0
2018-08-09	E1	Futures	1.20719	1.21138	1.20457	1.20684	28288.0
2018-08-09	E6	Futures	1.30245	1.3029	1.29228	1.29423	227087.0
2018-08-09	E7	Futures	1.2956	1.2963	1.2857	1.2877	2288.0
2018-08-09	EBM	Futures	223.88	223.88	220.22	220.74	17515.0
2018-08-09	ED	Futures	95.04	95.0546	95.0351	95.0497	395316.0
2018-08-09	ER	Futures	98.357	98.362	98.357	98.362	33379.0
2018-08-09	EW	Futures	2125.4	2138.1	2125.4	2127.1	7689.0
2018-08-09	FBON	Futures	129.11	129.22	128.98	129.16	60.0
2018-08-09	FBTP	Futures	106.06	106.51	105.71	106.28	50493.0
2018-08-09	FBTS	Futures	102.225	102.364	102.049	102.225	37181.0
2018-08-09	FCE	Futures	4928.5	4937.0	4903.8	4935.2	51837.0
2018-08-09	FDAX	Futures	13192.6	13269.5	13136.7	13232.4	82803.0
2018-08-09	FDXM	Futures	13023.6	13100.0	12969.9	13063.3	36432.0
2018-08-09	FESX	Futures	2914.9	2919.9	2903.2	2914.9	580596.0
2018-08-09	FGBL	Futures	152.9	153.23	152.86	153.12	446669.0
2018-08-09	FGBM	Futures	130.98	131.15	130.97	131.13	286500.0
2018-08-09	FGBS	Futures	112.633	112.683	112.633	112.678	433351.0
2018-08-09	FGBX	Futures	176.91	177.64	176.55	177.42	26578.0
2018-08-09	FMWO	Futures	7198.7	7218.5	7198.7	7218.5	707.0
2018-08-09	FOAT	Futures	140.47	140.73	140.45	140.7	74245.0
2018-08-09	FTDX	Futures	2872.0	2892.1	2867.6	2883.8	183.0
2018-08-09	FTI	Futures	529.06	529.43	527.67	528.64	17540.0
2018-08-09	FTUK	Futures	6872.7	6911.4	6853.1	6880.7	72483.0
2018-08-09	FVSA	Futures	256.05	257.96	249.36	251.27	18752.0
2018-08-09	FXXP	Futures	336.4	337.3	335.1	336.9	22950.0
2018-08-09	G	Futures	115.37	115.51	115.22	115.42	148790.0
2018-08-09	GF	Futures	312.341	312.548	307.421	309.389	1795.0
2018-08-09	GSCI	Futures	517.28	519.02	514.57	515.59	2553.0
2018-08-09	HE	Futures	64.795	69.602	64.761	69.602	30835.0

> showing 50 of 112 rows — these rows as CSV

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