PREVIEW / futures_daily / 2017-04-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-18.parquet
  size:    9 KB
  rows:    109

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
2017-04-18	ES	Futures	2546.77	2548.94	2530.75	2538.35	1432200.0
2017-04-18	NQ	Futures	6357.12	6366.25	6331.21	6347.4	246219.0
2017-04-18	YM	Futures	21696.4	21719.6	21519.1	21560.3	163328.0
2017-04-18	CL	Futures	55.5	55.61	54.82	55.14	471804.0
2017-04-18	GC	Futures	1645.4	1655.3	1637.6	1654.9	280737.0
2017-04-18	ZN	Futures	123.766822	124.504261	123.705369	124.396718	1436201.0
2017-04-18	A6	Futures	0.77845	0.77896	0.77249	0.77486	81055.0
2017-04-18	AD	Futures	0.7664	0.76655	0.76166	0.76283	71710.0
2017-04-18	ALI	Futures	2494.49	2494.49	2494.49	2494.49	0.0
2017-04-18	B	Futures	40.17	40.24	39.61	39.81	373099.0
2017-04-18	B6	Futures	1.3193	1.3554	1.3139	1.3493	281421.0
2017-04-18	BR	Futures	0.23038	0.2314	0.23028	0.23028	27.0
2017-04-18	BZ	Futures	40.12	40.13	39.5	39.7	38436.0
2017-04-18	C	Futures	1577.0	1595.0	1527.0	1553.0	5675.0
2017-04-18	CB	Futures	255.68	255.711	254.795	254.795	10.0
2017-04-18	CC	Futures	1473.0	1493.0	1451.0	1465.0	20020.0
2017-04-18	CNH	Futures	7.2039	7.2039	7.191	7.191	5.0
2017-04-18	CSC	Futures	3.487	3.489	3.487	3.489	38.0
2017-04-18	CT	Futures	86.12	86.37	85.02	85.63	15172.0
2017-04-18	DC	Futures	28.65	28.91	28.5	28.75	146.0
2017-04-18	DX	Futures	93.39	93.455	92.575	92.611	26523.0
2017-04-18	E1	Futures	1.23427	1.24564	1.23415	1.24478	26786.0
2017-04-18	E6	Futures	1.22968	1.24027	1.22893	1.2397	182698.0
2017-04-18	E7	Futures	1.2235	1.234	1.2227	1.2334	3388.0
2017-04-18	EBM	Futures	184.26	185.1	183.42	184.26	19723.0
2017-04-18	ED	Futures	95.5736	95.6075	95.5688	95.5978	253787.0
2017-04-18	ER	Futures	98.323	98.328	98.318	98.323	39894.0
2017-04-18	EW	Futures	1806.7	1809.6	1794.1	1806.4	15937.0
2017-04-18	FBON	Futures	121.77	121.99	121.6	121.84	562.0
2017-04-18	FBTP	Futures	105.02	105.53	104.93	105.31	79884.0
2017-04-18	FBTS	Futures	101.782	101.891	101.764	101.882	29850.0
2017-04-18	FCE	Futures	4478.5	4478.9	4369.8	4389.4	153944.0
2017-04-18	FDAX	Futures	12863.8	12890.2	12647.9	12726.6	107671.0
2017-04-18	FDXM	Futures	12748.7	12773.8	12537.3	12614.7	29888.0
2017-04-18	FESX	Futures	2770.4	2772.0	2714.9	2735.3	1257858.0
2017-04-18	FGBL	Futures	150.36	150.71	150.12	150.43	567995.0
2017-04-18	FGBM	Futures	130.23	130.3	130.1	130.21	320766.0
2017-04-18	FGBS	Futures	112.607	112.622	112.577	112.592	173821.0
2017-04-18	FGBX	Futures	175.0	176.28	174.42	175.46	36337.0
2017-04-18	FMWO	Futures	6184.4	6185.6	6145.9	6167.6	401.0
2017-04-18	FOAT	Futures	132.2	132.65	132.03	132.37	137183.0
2017-04-18	FTDX	Futures	1986.7	1993.0	1945.0	1965.6	178.0
2017-04-18	FTI	Futures	467.4	467.81	460.52	462.03	33503.0
2017-04-18	FTUK	Futures	6233.4	6237.7	6031.5	6077.7	176180.0
2017-04-18	FVSA	Futures	699.72	730.14	687.19	708.67	46173.0
2017-04-18	FXXP	Futures	317.7	317.7	312.3	313.9	26557.0
2017-04-18	G	Futures	116.17	116.52	115.87	116.16	141364.0
2017-04-18	GF	Futures	322.609	325.072	319.344	320.948	7522.0
2017-04-18	GSCI	Futures	498.6	501.24	496.53	498.98	831.0
2017-04-18	HE	Futures	81.169	81.169	78.988	80.273	248.0

> showing 50 of 109 rows — these rows as CSV

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