PREVIEW / futures_daily / 2020-01-02

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-02.parquet
  size:    10 KB
  rows:    119

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
2020-01-02	ES	Futures	3496.0	3522.73	3493.03	3519.76	1416241.0
2020-01-02	NQ	Futures	10067.1	10210.19	10058.78	10199.01	416637.0
2020-01-02	YM	Futures	29986.5	30320.5	29970.8	30289.0	183583.0
2020-01-02	CL	Futures	63.15	63.15	62.17	62.72	486873.0
2020-01-02	GC	Futures	1871.2	1887.2	1869.6	1880.0	270546.0
2020-01-02	ZN	Futures	127.15792	127.777372	127.018544	127.483132	1250468.0
2020-01-02	A6	Futures	0.72008	0.72101	0.7167	0.71701	102367.0
2020-01-02	AD	Futures	0.77663	0.77728	0.77486	0.77587	81158.0
2020-01-02	ALI	Futures	2201.28	2201.28	2201.28	2201.28	5.0
2020-01-02	B	Futures	54.3	54.44	53.73	54.17	205689.0
2020-01-02	B6	Futures	1.346	1.348	1.3327	1.3341	98603.0
2020-01-02	BR	Futures	0.20204	0.20228	0.2005	0.20111	659.0
2020-01-02	BTC	Futures	10952.1	10952.1	10459.5	10520.1	4754.0
2020-01-02	BZ	Futures	53.58	53.66	52.98	53.4	25810.0
2020-01-02	C	Futures	1727.0	1759.0	1720.0	1747.0	8113.0
2020-01-02	CB	Futures	246.775	248.573	246.775	247.6	8.0
2020-01-02	CC	Futures	1651.0	1678.0	1639.0	1656.0	23966.0
2020-01-02	CNH	Futures	6.9352	6.9451	6.9331	6.9359	611.0
2020-01-02	CSC	Futures	3.394	3.394	3.348	3.351	77.0
2020-01-02	CT	Futures	65.75	66.34	65.67	65.89	21477.0
2020-01-02	DC	Futures	28.24	28.25	27.86	27.9	231.0
2020-01-02	DX	Futures	93.313	93.721	93.274	93.687	17442.0
2020-01-02	E1	Futures	1.18701	1.18746	1.17924	1.18073	34208.0
2020-01-02	E6	Futures	1.21379	1.21471	1.20803	1.20841	177128.0
2020-01-02	E7	Futures	1.207	1.2088	1.2017	1.2021	3306.0
2020-01-02	EBM	Futures	207.42	209.62	207.42	208.25	16539.0
2020-01-02	ED	Futures	95.318	95.3277	95.3083	95.3229	161911.0
2020-01-02	ER	Futures	98.367	98.372	98.367	98.372	40185.0
2020-01-02	ESG	Futures	289.52	289.73	288.82	289.29	1856.0
2020-01-02	EW	Futures	2177.6	2190.7	2155.8	2175.8	17774.0
2020-01-02	FBON	Futures	142.69	143.16	142.21	143.02	502.0
2020-01-02	FBTP	Futures	128.08	128.2	126.98	127.7	70751.0
2020-01-02	FBTS	Futures	108.163	108.191	108.028	108.124	43090.0
2020-01-02	FCE	Futures	5443.5	5488.3	5434.5	5463.4	82342.0
2020-01-02	FDAX	Futures	13931.8	14216.3	13929.2	14153.9	118258.0
2020-01-02	FDXM	Futures	13751.7	14036.8	13751.7	13976.2	46032.0
2020-01-02	FESX	Futures	3290.7	3344.4	3290.7	3331.2	962880.0
2020-01-02	FGBL	Futures	162.89	163.73	162.56	163.58	511156.0
2020-01-02	FGBM	Futures	133.06	133.55	133.06	133.51	308562.0
2020-01-02	FGBS	Futures	112.613	112.659	112.593	112.649	248450.0
2020-01-02	FGBX	Futures	207.86	210.2	206.56	209.78	49295.0
2020-01-02	FMWO	Futures	7878.0	7929.1	7878.0	7898.4	5153.0
2020-01-02	FOAT	Futures	150.54	151.28	150.23	151.13	113949.0
2020-01-02	FTDX	Futures	3044.9	3086.1	3044.9	3078.5	149.0
2020-01-02	FTI	Futures	582.89	589.88	581.93	586.87	31189.0
2020-01-02	FTUK	Futures	7048.4	7102.9	7028.3	7078.9	92944.0
2020-01-02	FVSA	Futures	129.73	130.66	124.11	125.98	21829.0
2020-01-02	FXXP	Futures	378.8	383.1	378.8	381.9	48735.0
2020-01-02	G	Futures	119.27	120.33	119.15	120.13	195899.0
2020-01-02	GF	Futures	306.441	307.231	300.753	304.703	4062.0

> showing 50 of 119 rows — these rows as CSV

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