PREVIEW / futures_daily / 2019-12-12

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-12.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-12-12	ES	Futures	3403.59	3439.86	3396.28	3429.57	2379008.0
2019-12-12	NQ	Futures	9688.98	9792.12	9658.44	9755.53	554338.0
2019-12-12	YM	Futures	29329.1	29642.0	29251.4	29542.3	21589.0
2019-12-12	CL	Futures	60.12	60.98	59.99	60.43	530851.0
2019-12-12	GC	Futures	1819.8	1835.1	1806.3	1811.3	409855.0
2019-12-12	ZN	Futures	128.102584	128.288419	127.018544	127.250838	2587611.0
2019-12-12	A6	Futures	0.70604	0.71034	0.70563	0.70881	111636.0
2019-12-12	AD	Futures	0.76529	0.76605	0.76418	0.76484	97049.0
2019-12-12	ALI	Futures	2163.33	2176.09	2156.95	2169.4	260.0
2019-12-12	B	Futures	51.54	52.3	51.51	51.78	238305.0
2019-12-12	B6	Futures	1.3425	1.3465	1.3275	1.3364	138279.0
2019-12-12	BR	Futures	0.19701	0.19737	0.19608	0.19737	330.0
2019-12-12	BTC	Futures	10848.3	11089.0	10637.6	10931.0	4522.0
2019-12-12	BZ	Futures	50.84	51.6	50.83	51.09	32866.0
2019-12-12	C	Futures	1722.0	1724.0	1696.0	1701.0	13180.0
2019-12-12	CB	Futures	243.768	245.714	243.768	245.242	37.0
2019-12-12	CC	Futures	1681.0	1681.0	1643.0	1649.0	22080.0
2019-12-12	CNH	Futures	7.0099	7.0238	6.916	6.9369	1262.0
2019-12-12	CSC	Futures	3.316	3.325	3.301	3.322	88.0
2019-12-12	CT	Futures	62.55	64.09	62.37	63.89	31698.0
2019-12-12	DC	Futures	27.73	27.86	27.54	27.85	132.0
2019-12-12	DX	Futures	93.798	94.24	93.759	94.108	30456.0
2019-12-12	E1	Futures	1.17067	1.17273	1.16485	1.1669	34265.0
2019-12-12	E6	Futures	1.207	1.20932	1.20383	1.20496	288561.0
2019-12-12	E7	Futures	1.2007	1.2029	1.1976	1.1987	9227.0
2019-12-12	EBM	Futures	200.0	201.65	199.73	201.38	20872.0
2019-12-12	ED	Futures	95.3374	95.3471	95.2938	95.3035	439168.0
2019-12-12	ER	Futures	98.386	98.391	98.377	98.386	86478.0
2019-12-12	EW	Futures	2130.8	2153.6	2121.4	2148.6	21826.0
2019-12-12	FBON	Futures	143.24	143.51	142.74	142.75	103.0
2019-12-12	FBTP	Futures	128.63	129.34	128.33	128.43	78945.0
2019-12-12	FBTS	Futures	108.134	108.307	108.134	108.163	42763.0
2019-12-12	FCE	Futures	5304.5	5348.0	5289.6	5320.4	1325.0
2019-12-12	FDAX	Futures	13874.8	14025.7	13825.7	13965.5	134153.0
2019-12-12	FDXM	Futures	13736.0	13867.6	13679.6	13817.5	895.0
2019-12-12	FESX	Futures	3237.8	3267.8	3223.7	3255.5	350137.0
2019-12-12	FGBL	Futures	164.96	165.23	163.91	164.05	667412.0
2019-12-12	FGBM	Futures	133.94	134.0	133.56	133.61	404064.0
2019-12-12	FGBS	Futures	112.724	112.729	112.659	112.669	278681.0
2019-12-12	FGBX	Futures	214.07	214.76	210.89	211.25	53335.0
2019-12-12	FMWO	Futures	7656.5	7727.0	7647.4	7696.3	10155.0
2019-12-12	FOAT	Futures	152.17	152.51	151.44	151.49	139354.0
2019-12-12	FTDX	Futures	3052.9	3053.9	3036.3	3053.9	69.0
2019-12-12	FTI	Futures	574.99	576.57	570.3	574.22	1344.0
2019-12-12	FTUK	Futures	6717.3	6791.9	6715.4	6775.9	135149.0
2019-12-12	FVSA	Futures	141.9	143.78	135.35	138.63	27082.0
2019-12-12	FXXP	Futures	369.1	371.3	368.1	370.4	24901.0
2019-12-12	G	Futures	120.32	120.78	119.66	119.75	192281.0
2019-12-12	GF	Futures	300.753	301.28	298.647	300.279	7450.0
2019-12-12	GSCI	Futures	470.1	473.83	470.1	472.77	1690.0

> showing 50 of 116 rows — these rows as CSV

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