PREVIEW / futures_daily / 2019-09-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-20.parquet
  size:    10 KB
  rows:    120

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-09-20	ES	Futures	3255.28	3267.19	3231.73	3236.34	1476593.0
2019-09-20	NQ	Futures	9128.32	9164.34	9001.27	9024.03	425158.0
2019-09-20	YM	Futures	28430.4	28529.1	28213.1	28233.1	158528.0
2019-09-20	CL	Futures	60.26	60.82	59.48	59.64	576019.0
2019-09-20	GC	Futures	1858.7	1880.5	1856.9	1869.0	284387.0
2019-09-20	ZN	Futures	128.334807	128.799339	128.210932	128.52062	1238680.0
2019-09-20	A6	Futures	0.69917	0.7006	0.69547	0.69588	89370.0
2019-09-20	AD	Futures	0.7605	0.76096	0.75839	0.7595	65817.0
2019-09-20	ALI	Futures	2169.79	2186.09	2169.79	2186.09	77.0
2019-09-20	B	Futures	50.2	50.42	49.47	49.65	224881.0
2019-09-20	B6	Futures	1.2783	1.2836	1.2709	1.2724	128898.0
2019-09-20	BR	Futures	0.19218	0.19388	0.19186	0.1936	95.0
2019-09-20	BTC	Futures	14508.8	14794.5	14423.1	14544.5	2400.0
2019-09-20	BZ	Futures	49.45	49.67	48.74	48.91	23355.0
2019-09-20	C	Futures	1644.0	1658.0	1639.0	1652.0	11846.0
2019-09-20	CB	Futures	255.069	255.069	255.069	255.069	22.0
2019-09-20	CC	Futures	1619.0	1630.0	1599.0	1623.0	28040.0
2019-09-20	CNH	Futures	7.0983	7.1351	7.0807	7.1219	966.0
2019-09-20	CSC	Futures	3.114	3.16	3.114	3.151	34.0
2019-09-20	CT	Futures	58.61	58.69	58.28	58.39	56.0
2019-09-20	DC	Futures	26.24	26.63	26.22	26.57	223.0
2019-09-20	DX	Futures	94.657	94.961	94.463	94.851	13513.0
2019-09-20	E1	Futures	1.16692	1.17129	1.16565	1.16784	25020.0
2019-09-20	E6	Futures	1.20407	1.2071	1.19908	1.20114	151007.0
2019-09-20	E7	Futures	1.1979	1.2007	1.193	1.1949	3125.0
2019-09-20	EBM	Futures	187.98	188.52	187.16	187.43	13115.0
2019-09-20	ED	Futures	95.2111	95.25	95.2063	95.2354	484707.0
2019-09-20	ER	Futures	98.431	98.435	98.431	98.431	25721.0
2019-09-20	EW	Futures	2049.6	2062.3	2037.7	2043.6	15688.0
2019-09-20	FBON	Futures	144.99	145.16	144.77	145.01	146.0
2019-09-20	FBTP	Futures	132.07	132.2	131.49	131.59	44720.0
2019-09-20	FBTS	Futures	108.404	108.452	108.317	108.336	23730.0
2019-09-20	FCE	Futures	5108.8	5149.1	5102.5	5143.7	113054.0
2019-09-20	FDAX	Futures	13110.3	13162.5	13071.3	13137.7	104834.0
2019-09-20	FDIV	Futures	149.99	150.17	149.99	150.17	10.0
2019-09-20	FDXM	Futures	12930.8	12991.2	12900.6	12966.2	38534.0
2019-09-20	FESX	Futures	3095.7	3123.7	3093.1	3116.7	1419098.0
2019-09-20	FGBL	Futures	167.43	167.93	167.34	167.57	477045.0
2019-09-20	FGBM	Futures	134.8	134.86	134.76	134.79	253043.0
2019-09-20	FGBS	Futures	112.93	112.93	112.905	112.91	246165.0
2019-09-20	FGBX	Futures	222.17	224.83	221.38	223.08	46023.0
2019-09-20	FMWO	Futures	7356.3	7369.9	7329.0	7352.9	2279.0
2019-09-20	FOAT	Futures	154.32	154.46	154.16	154.31	96067.0
2019-09-20	FTDX	Futures	2838.9	2839.4	2820.7	2826.6	102.0
2019-09-20	FTI	Futures	548.41	550.45	544.85	547.49	37188.0
2019-09-20	FTUK	Futures	6765.7	6803.7	6742.6	6770.8	123996.0
2019-09-20	FVSA	Futures	175.71	182.45	173.46	177.39	29314.0
2019-09-20	FXXP	Futures	352.3	354.4	351.9	353.7	64295.0
2019-09-20	G	Futures	121.13	121.71	121.11	121.55	141925.0
2019-09-20	GF	Futures	291.22	292.214	289.755	291.377	3138.0

> showing 50 of 120 rows — these rows as CSV

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