PREVIEW / futures_daily / 2018-01-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-24.parquet
  size:    9 KB
  rows:    110

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-24	ES	Futures	3083.48	3103.31	3070.98	3087.82	1885278.0
2018-01-24	NQ	Futures	8147.31	8203.23	8067.38	8117.74	526387.0
2018-01-24	YM	Futures	27614.9	27827.9	27511.5	27704.5	239662.0
2018-01-24	CL	Futures	64.4	66.03	64.32	65.59	887018.0
2018-01-24	GC	Futures	1700.6	1726.2	1697.7	1719.5	505627.0
2018-01-24	ZN	Futures	120.926206	120.98791	120.586829	120.648533	1616438.0
2018-01-24	A6	Futures	0.8225	0.83124	0.82209	0.83073	140815.0
2018-01-24	AD	Futures	0.81772	0.82478	0.81737	0.82437	105798.0
2018-01-24	B	Futures	49.9	50.53	49.59	50.25	250177.0
2018-01-24	B6	Futures	1.459	1.4863	1.4585	1.4812	200657.0
2018-01-24	BR	Futures	0.23731	0.24141	0.23689	0.2378	2291.0
2018-01-24	BTC	Futures	14209.5	14899.1	13649.9	14515.3	232.0
2018-01-24	BZ	Futures	49.08	49.86	48.95	49.59	14390.0
2018-01-24	C	Futures	1250.0	1250.0	1216.0	1241.0	9436.0
2018-01-24	CB	Futures	268.862	269.634	268.584	269.016	40.0
2018-01-24	CC	Futures	1447.0	1465.0	1424.0	1459.0	22769.0
2018-01-24	CNH	Futures	6.5419	6.5424	6.4946	6.4946	77.0
2018-01-24	CSC	Futures	3.133	3.146	3.112	3.125	36.0
2018-01-24	CT	Futures	95.85	96.63	95.32	96.09	25404.0
2018-01-24	DC	Futures	25.31	25.31	24.83	25.04	229.0
2018-01-24	DX	Futures	84.402	84.43	83.538	83.59	32301.0
2018-01-24	E1	Futures	1.27243	1.29282	1.27182	1.28918	43264.0
2018-01-24	E6	Futures	1.39866	1.41204	1.3977	1.41079	323260.0
2018-01-24	E7	Futures	1.3917	1.405	1.3909	1.4038	7190.0
2018-01-24	EBM	Futures	167.5	168.84	167.5	168.84	14295.0
2018-01-24	ED	Futures	95.3262	95.331	95.3165	95.3165	290649.0
2018-01-24	ER	Futures	98.337	98.337	98.332	98.337	36523.0
2018-01-24	EW	Futures	2113.1	2124.9	2100.5	2108.7	19637.0
2018-01-24	FBON	Futures	127.48	127.65	127.42	127.53	188.0
2018-01-24	FBTP	Futures	112.34	112.4	112.01	112.15	95882.0
2018-01-24	FBTS	Futures	103.686	103.704	103.65	103.677	34519.0
2018-01-24	FCE	Futures	4940.6	4940.6	4883.5	4898.2	72952.0
2018-01-24	FDAX	Futures	14074.9	14080.6	13868.9	13950.4	88598.0
2018-01-24	FDXM	Futures	14101.4	14107.6	13892.5	13974.1	29649.0
2018-01-24	FESX	Futures	2992.4	2994.8	2959.7	2974.4	878980.0
2018-01-24	FGBL	Futures	149.07	149.07	148.58	148.66	675757.0
2018-01-24	FGBM	Futures	129.05	129.06	128.89	128.95	539958.0
2018-01-24	FGBS	Futures	112.331	112.331	112.306	112.316	305600.0
2018-01-24	FGBX	Futures	167.69	167.69	166.5	166.6	57866.0
2018-01-24	FMWO	Futures	7372.8	7396.2	7339.0	7370.5	1509.0
2018-01-24	FOAT	Futures	137.64	137.65	137.2	137.33	112015.0
2018-01-24	FTDX	Futures	2694.0	2694.0	2624.1	2650.1	226.0
2018-01-24	FTI	Futures	528.55	528.6	522.28	524.42	21633.0
2018-01-24	FTUK	Futures	6709.6	6711.8	6610.9	6644.1	113769.0
2018-01-24	FVSA	Futures	246.91	254.65	243.47	248.63	12504.0
2018-01-24	FXXP	Futures	342.2	342.6	339.2	340.9	48420.0
2018-01-24	G	Futures	113.79	113.83	113.15	113.31	250865.0
2018-01-24	GF	Futures	323.466	324.399	320.831	321.49	4209.0
2018-01-24	GSCI	Futures	530.63	534.84	529.59	533.17	112.0
2018-01-24	HE	Futures	96.081	98.007	95.342	97.204	19713.0

> showing 50 of 110 rows — these rows as CSV

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