PREVIEW / futures_daily / 2018-12-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-14.parquet
  size:    10 KB
  rows:    111

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-12-14	ES	Futures	2869.07	2872.05	2811.96	2820.9	1989620.0
2018-12-14	NQ	Futures	7842.62	7856.8	7649.57	7667.22	486181.0
2018-12-14	YM	Futures	25953.7	25975.8	25374.6	25449.5	194508.0
2018-12-14	CL	Futures	55.63	55.79	53.61	53.98	271679.0
2018-12-14	GC	Futures	1570.2	1571.6	1558.0	1564.2	194651.0
2018-12-14	ZN	Futures	119.728619	120.10209	119.728619	119.899793	1398432.0
2018-12-14	A6	Futures	0.74486	0.74558	0.73775	0.74043	103827.0
2018-12-14	AD	Futures	0.75995	0.76005	0.75696	0.75858	74826.0
2018-12-14	B	Futures	45.18	45.21	44.0	44.26	206560.0
2018-12-14	B6	Futures	1.3057	1.3064	1.2926	1.2978	101486.0
2018-12-14	BTC	Futures	4936.1	4981.9	4760.7	4798.8	3046.0
2018-12-14	BZ	Futures	44.69	44.76	43.43	43.69	24871.0
2018-12-14	C	Futures	1467.0	1482.0	1450.0	1458.0	10381.0
2018-12-14	CB	Futures	267.277	269.646	267.277	268.796	22.0
2018-12-14	CC	Futures	1542.0	1570.0	1527.0	1541.0	17329.0
2018-12-14	CNH	Futures	6.9037	6.932	6.9034	6.9225	373.0
2018-12-14	CSC	Futures	2.849	2.86	2.849	2.855	109.0
2018-12-14	CT	Futures	86.49	87.08	85.64	86.71	10297.0
2018-12-14	DC	Futures	24.18	24.2	24.07	24.15	128.0
2018-12-14	DX	Futures	92.089	92.695	92.084	92.423	22667.0
2018-12-14	E1	Futures	1.19347	1.19429	1.18759	1.18912	28734.0
2018-12-14	E6	Futures	1.26492	1.26591	1.25541	1.25917	283933.0
2018-12-14	E7	Futures	1.2589	1.2596	1.2493	1.253	4150.0
2018-12-14	EBM	Futures	213.34	214.37	212.05	212.57	26018.0
2018-12-14	ED	Futures	94.9158	94.9402	94.9109	94.9305	335833.0
2018-12-14	ER	Futures	98.386	98.391	98.381	98.386	60311.0
2018-12-14	EW	Futures	1873.6	1876.3	1842.3	1847.6	34288.0
2018-12-14	FBON	Futures	129.59	129.63	129.52	129.58	241.0
2018-12-14	FBTP	Futures	109.53	109.89	109.33	109.78	52142.0
2018-12-14	FBTS	Futures	104.282	104.386	104.234	104.31	54901.0
2018-12-14	FCE	Futures	4307.9	4317.7	4273.3	4300.8	40054.0
2018-12-14	FDAX	Futures	11470.6	11471.7	11282.9	11410.2	124094.0
2018-12-14	FDXM	Futures	11374.0	11419.1	11243.0	11367.2	655.0
2018-12-14	FESX	Futures	2638.9	2638.9	2601.3	2624.4	835644.0
2018-12-14	FGBL	Futures	154.88	155.27	154.8	155.17	554535.0
2018-12-14	FGBM	Futures	131.63	131.77	131.58	131.73	323179.0
2018-12-14	FGBS	Futures	112.658	112.713	112.643	112.688	234094.0
2018-12-14	FGBX	Futures	182.56	183.58	182.22	182.8	46349.0
2018-12-14	FMWO	Futures	6509.4	6525.6	6451.5	6492.0	9319.0
2018-12-14	FOAT	Futures	141.1	141.37	141.05	141.2	112125.0
2018-12-14	FTDX	Futures	2501.6	2501.6	2498.1	2498.1	1.0
2018-12-14	FTI	Futures	471.92	475.2	468.13	473.77	12050.0
2018-12-14	FTUK	Futures	6169.2	6196.6	6124.6	6164.7	103626.0
2018-12-14	FVSA	Futures	404.21	416.4	402.18	406.24	16742.0
2018-12-14	FXXP	Futures	302.5	303.7	300.5	302.5	23761.0
2018-12-14	G	Futures	116.83	117.31	116.83	117.26	152107.0
2018-12-14	GF	Futures	318.101	319.123	316.863	317.67	3526.0
2018-12-14	GSCI	Futures	469.0	469.0	462.22	462.79	202.0
2018-12-14	HE	Futures	78.498	80.331	77.505	77.566	18313.0
2018-12-14	HG	Futures	3.1899	3.1922	3.1438	3.1836	58454.0

> showing 50 of 111 rows — these rows as CSV

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