PREVIEW / futures_daily / 2018-01-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-02.parquet
  size:    9 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-01-02	ES	Futures	2907.67	2930.23	2906.86	2926.96	996265.0
2018-01-02	NQ	Futures	7501.41	7639.9	7492.91	7629.94	259593.0
2018-01-02	YM	Futures	26085.7	26214.4	26065.7	26120.5	105418.0
2018-01-02	CL	Futures	60.19	60.73	60.09	60.36	510313.0
2018-01-02	GC	Futures	1654.8	1674.0	1653.9	1668.5	279727.0
2018-01-02	ZN	Futures	122.407124	122.42255	121.959763	122.114025	1062328.0
2018-01-02	A6	Futures	0.80357	0.80686	0.80182	0.80542	64561.0
2018-01-02	AD	Futures	0.80929	0.81305	0.80904	0.81254	61516.0
2018-01-02	B	Futures	47.65	48.18	47.43	47.67	211739.0
2018-01-02	B6	Futures	1.4085	1.418	1.4078	1.4174	100481.0
2018-01-02	BR	Futures	0.23078	0.23158	0.23055	0.23158	39.0
2018-01-02	BTC	Futures	17872.3	19524.4	16751.7	19024.9	734.0
2018-01-02	BZ	Futures	46.91	47.52	46.78	47.02	24294.0
2018-01-02	C	Futures	1258.0	1271.0	1235.0	1265.0	12205.0
2018-01-02	CB	Futures	276.027	276.12	275.193	275.842	10.0
2018-01-02	CC	Futures	1418.0	1453.0	1389.0	1444.0	26852.0
2018-01-02	CNH	Futures	6.6617	6.6617	6.6425	6.6523	23.0
2018-01-02	CSC	Futures	3.214	3.214	3.193	3.193	55.0
2018-01-02	CT	Futures	91.85	92.61	90.28	90.52	20981.0
2018-01-02	DC	Futures	25.42	25.42	25.04	25.11	137.0
2018-01-02	DX	Futures	86.299	86.332	85.9	85.996	19616.0
2018-01-02	E1	Futures	1.25349	1.25823	1.25191	1.25556	23152.0
2018-01-02	E6	Futures	1.36834	1.37571	1.36681	1.37242	200345.0
2018-01-02	E7	Futures	1.3607	1.3687	1.3597	1.3655	4506.0
2018-01-02	EBM	Futures	171.27	171.81	170.73	171.0	9821.0
2018-01-02	ED	Futures	95.4087	95.4087	95.3796	95.3796	291829.0
2018-01-02	ER	Futures	98.337	98.337	98.332	98.337	64977.0
2018-01-02	EW	Futures	2013.6	2038.5	2013.6	2037.4	21228.0
2018-01-02	FBON	Futures	125.46	125.67	125.1	125.12	381.0
2018-01-02	FBTP	Futures	111.43	111.43	110.13	110.21	100431.0
2018-01-02	FBTS	Futures	103.412	103.421	103.339	103.375	44059.0
2018-01-02	FCE	Futures	4758.6	4765.8	4698.7	4728.2	72797.0
2018-01-02	FDAX	Futures	13406.2	13424.9	13208.1	13330.0	82936.0
2018-01-02	FDXM	Futures	13424.8	13446.6	13232.6	13352.6	29881.0
2018-01-02	FESX	Futures	2858.4	2861.7	2822.5	2837.2	831953.0
2018-01-02	FEU3	Futures	99.011	99.011	99.011	99.011	100.0
2018-01-02	FGBL	Futures	149.94	149.94	149.38	149.47	485951.0
2018-01-02	FGBM	Futures	129.39	129.4	129.2	129.33	363330.0
2018-01-02	FGBS	Futures	112.382	112.382	112.331	112.357	247441.0
2018-01-02	FGBX	Futures	168.46	168.46	166.97	167.34	47902.0
2018-01-02	FMWO	Futures	6955.0	6980.7	6955.0	6972.5	819.0
2018-01-02	FOAT	Futures	138.35	138.35	137.66	137.75	92246.0
2018-01-02	FTDX	Futures	2516.9	2546.8	2495.0	2543.4	329.0
2018-01-02	FTI	Futures	504.83	505.43	499.83	504.09	23273.0
2018-01-02	FTUK	Futures	6674.2	6683.8	6614.4	6627.0	98483.0
2018-01-02	FVSA	Futures	293.93	299.2	281.29	284.45	18885.0
2018-01-02	FXXP	Futures	330.3	330.3	327.8	329.0	21623.0
2018-01-02	G	Futures	115.44	115.44	114.4	114.56	178808.0
2018-01-02	GF	Futures	317.49	323.76	317.382	323.274	2081.0
2018-01-02	GSCI	Futures	514.57	517.08	514.51	515.39	125.0

> showing 50 of 111 rows — these rows as CSV

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