PREVIEW / futures_daily / 2019-03-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-18.parquet
  size:    10 KB
  rows:    116

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-03-18	ES	Futures	3053.65	3069.86	3050.41	3068.24	1036540.0
2019-03-18	NQ	Futures	8454.88	8502.69	8436.15	8481.09	366874.0
2019-03-18	YM	Futures	27298.8	27419.1	27243.9	27407.5	138471.0
2019-03-18	CL	Futures	60.33	61.14	59.94	60.97	512123.0
2019-03-18	GC	Futures	1627.5	1633.4	1622.5	1626.9	176492.0
2019-03-18	ZN	Futures	122.28017	122.357867	122.140314	122.171393	963883.0
2019-03-18	A6	Futures	0.73126	0.73487	0.73065	0.73281	68268.0
2019-03-18	AD	Futures	0.75959	0.76166	0.75802	0.75893	50015.0
2019-03-18	B	Futures	48.7	49.1	48.37	48.99	208526.0
2019-03-18	B6	Futures	1.3684	1.3685	1.3565	1.3637	109185.0
2019-03-18	BR	Futures	0.20917	0.21025	0.20917	0.21025	1.0
2019-03-18	BTC	Futures	6095.6	6187.8	6049.4	6087.9	2756.0
2019-03-18	BZ	Futures	48.25	48.71	47.99	48.6	31752.0
2019-03-18	C	Futures	1479.0	1489.0	1464.0	1472.0	5780.0
2019-03-18	CB	Futures	277.407	277.826	277.407	277.826	6.0
2019-03-18	CC	Futures	1484.0	1501.0	1466.0	1482.0	13238.0
2019-03-18	CNH	Futures	6.727	6.7365	6.7234	6.7314	255.0
2019-03-18	CSC	Futures	2.81	2.813	2.798	2.801	13.0
2019-03-18	CT	Futures	80.05	80.59	79.51	79.91	12739.0
2019-03-18	DC	Futures	23.76	23.79	23.51	23.56	117.0
2019-03-18	DX	Futures	92.013	92.104	91.855	92.001	7961.0
2019-03-18	E1	Futures	1.17438	1.17718	1.17391	1.17554	16173.0
2019-03-18	E6	Futures	1.25226	1.25615	1.25176	1.25374	129957.0
2019-03-18	E7	Futures	1.2461	1.2499	1.2455	1.2476	2562.0
2019-03-18	EBM	Futures	199.78	200.84	199.25	199.78	14685.0
2019-03-18	ED	Futures	95.1013	95.1062	95.0916	95.0965	235187.0
2019-03-18	ER	Futures	98.406	98.406	98.401	98.406	72269.0
2019-03-18	EW	Futures	2014.8	2035.4	2013.1	2031.1	17492.0
2019-03-18	FBON	Futures	133.88	134.24	133.8	134.22	525.0
2019-03-18	FBTP	Futures	114.66	115.27	114.63	115.22	78357.0
2019-03-18	FBTS	Futures	105.95	106.074	105.922	106.036	47962.0
2019-03-18	FCE	Futures	4809.6	4814.9	4797.1	4807.3	50111.0
2019-03-18	FDAX	Futures	12305.3	12345.9	12262.2	12287.4	87937.0
2019-03-18	FDIV	Futures	144.42	144.7	144.1	144.1	19.0
2019-03-18	FDXM	Futures	12205.0	12238.4	12155.9	12181.0	40952.0
2019-03-18	FESX	Futures	2885.9	2894.6	2880.6	2886.7	765633.0
2019-03-18	FEU3	Futures	98.996	99.001	98.996	99.001	300.0
2019-03-18	FGBL	Futures	158.5	158.63	158.24	158.54	455669.0
2019-03-18	FGBM	Futures	132.49	132.49	132.34	132.46	307887.0
2019-03-18	FGBS	Futures	112.673	112.678	112.638	112.658	212918.0
2019-03-18	FGBX	Futures	189.11	189.68	188.6	189.6	25517.0
2019-03-18	FMWO	Futures	7072.6	7109.7	7072.6	7090.0	2455.0
2019-03-18	FOAT	Futures	145.38	145.57	145.26	145.49	119242.0
2019-03-18	FTDX	Futures	2635.6	2642.5	2621.3	2622.8	1138.0
2019-03-18	FTI	Futures	517.18	517.6	514.6	516.01	18501.0
2019-03-18	FTUK	Futures	6556.9	6622.9	6550.0	6611.9	70868.0
2019-03-18	FVSA	Futures	236.24	240.31	234.61	238.68	49076.0
2019-03-18	FXXP	Futures	334.5	335.7	334.3	335.1	31288.0
2019-03-18	G	Futures	116.99	117.41	116.94	117.29	157862.0
2019-03-18	GF	Futures	313.567	314.262	311.643	312.872	6723.0

> showing 50 of 116 rows — these rows as CSV

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