PREVIEW / futures_daily / 2018-04-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-25.parquet
  size:    10 KB
  rows:    113

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-04-25	ES	Futures	2865.75	2879.89	2839.65	2875.81	1902899.0
2018-04-25	NQ	Futures	7637.96	7697.06	7525.01	7673.07	544882.0
2018-04-25	YM	Futures	25279.5	25395.4	25052.0	25363.8	284650.0
2018-04-25	CL	Futures	68.0	68.43	67.36	68.3	764049.0
2018-04-25	GC	Futures	1700.5	1702.8	1685.5	1688.8	269901.0
2018-04-25	ZN	Futures	118.299464	118.392516	118.082344	118.190904	1647855.0
2018-04-25	A6	Futures	0.78167	0.78219	0.77653	0.77787	96177.0
2018-04-25	AD	Futures	0.7895	0.78991	0.78525	0.78834	63761.0
2018-04-25	B	Futures	53.69	53.77	53.05	53.67	271357.0
2018-04-25	B6	Futures	1.4509	1.4528	1.4452	1.447	75375.0
2018-04-25	BR	Futures	0.21843	0.21866	0.21603	0.21717	7521.0
2018-04-25	BTC	Futures	13446.0	13691.7	12329.6	12638.5	795.0
2018-04-25	BZ	Futures	52.99	53.22	52.51	53.12	21931.0
2018-04-25	C	Futures	1685.0	1696.0	1657.0	1692.0	7134.0
2018-04-25	CB	Futures	301.508	301.539	300.581	300.581	18.0
2018-04-25	CC	Futures	2056.0	2089.0	2031.0	2068.0	20544.0
2018-04-25	CNH	Futures	6.406	6.4337	6.4058	6.4249	27.0
2018-04-25	CSC	Futures	3.446	3.448	3.421	3.425	23.0
2018-04-25	CT	Futures	92.67	96.1	92.67	95.42	23967.0
2018-04-25	DC	Futures	27.84	27.89	27.58	27.75	170.0
2018-04-25	DX	Futures	85.391	85.858	85.368	85.781	26434.0
2018-04-25	E1	Futures	1.23549	1.23585	1.22827	1.23091	26463.0
2018-04-25	E6	Futures	1.38333	1.38406	1.37505	1.37708	205367.0
2018-04-25	E7	Futures	1.376	1.3765	1.3677	1.3697	3882.0
2018-04-25	EBM	Futures	176.4	177.74	176.13	177.47	25846.0
2018-04-25	ED	Futures	94.9403	94.9403	94.916	94.916	277800.0
2018-04-25	ER	Futures	98.342	98.342	98.337	98.342	19426.0
2018-04-25	EW	Futures	1999.7	2009.0	1982.6	1999.7	14552.0
2018-04-25	FBON	Futures	129.28	129.47	129.2	129.23	376.0
2018-04-25	FBTP	Futures	115.97	116.11	115.64	115.81	87308.0
2018-04-25	FBTS	Futures	104.241	104.269	104.223	104.241	41413.0
2018-04-25	FCE	Futures	4774.1	4809.7	4760.2	4783.4	87045.0
2018-04-25	FDAX	Futures	12935.6	12984.4	12803.6	12909.6	121163.0
2018-04-25	FDIV	Futures	149.53	150.25	149.53	150.25	34.0
2018-04-25	FDXM	Futures	12817.3	12867.8	12689.6	12794.7	48155.0
2018-04-25	FESX	Futures	2842.3	2853.9	2828.9	2846.4	1064597.0
2018-04-25	FEU3	Futures	99.03	99.03	99.026	99.026	99.0
2018-04-25	FGBL	Futures	148.57	148.57	148.17	148.42	744664.0
2018-04-25	FGBM	Futures	129.27	129.28	129.11	129.21	611055.0
2018-04-25	FGBS	Futures	112.467	112.467	112.437	112.462	248830.0
2018-04-25	FGBX	Futures	167.51	167.66	166.91	167.33	51541.0
2018-04-25	FMWO	Futures	6891.9	6891.9	6844.0	6888.4	3039.0
2018-04-25	FOAT	Futures	137.95	137.95	137.55	137.72	86011.0
2018-04-25	FTDX	Futures	2574.1	2574.1	2525.1	2537.5	355.0
2018-04-25	FTI	Futures	504.76	507.39	502.91	505.64	31808.0
2018-04-25	FTUK	Futures	6478.7	6496.0	6432.8	6473.9	113440.0
2018-04-25	FVSA	Futures	357.05	369.68	346.71	358.2	47295.0
2018-04-25	FXXP	Futures	324.9	325.9	322.7	324.6	39004.0
2018-04-25	G	Futures	112.55	112.69	112.37	112.65	199086.0
2018-04-25	GF	Futures	301.065	304.885	300.635	304.185	2790.0

> showing 50 of 113 rows — these rows as CSV

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