PREVIEW / futures_daily / 2017-01-25

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-25.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-01-25	ES	Futures	2467.14	2488.28	2466.06	2486.92	1386477.0
2017-01-25	NQ	Futures	6010.9	6069.83	6010.61	6065.71	153214.0
2017-01-25	YM	Futures	20909.0	21082.8	20904.8	21069.1	123956.0
2017-01-25	CL	Futures	56.66	57.22	56.25	56.45	589709.0
2017-01-25	GC	Futures	1552.1	1553.0	1531.5	1538.2	299179.0
2017-01-25	ZN	Futures	121.568569	121.660261	121.018415	121.094826	1407113.0
2017-01-25	A6	Futures	0.77587	0.7773	0.7689	0.77331	112655.0
2017-01-25	AD	Futures	0.77648	0.7824	0.77633	0.78128	71102.0
2017-01-25	ALI	Futures	2501.14	2521.35	2487.98	2497.93	70.0
2017-01-25	B	Futures	41.07	41.33	40.68	40.87	278658.0
2017-01-25	B6	Futures	1.3153	1.3271	1.3116	1.3258	108707.0
2017-01-25	BR	Futures	0.22123	0.22283	0.22123	0.22283	68.0
2017-01-25	BZ	Futures	40.84	41.11	40.48	40.66	26234.0
2017-01-25	C	Futures	1824.0	1835.0	1799.0	1811.0	8210.0
2017-01-25	CB	Futures	272.555	272.799	272.067	272.067	12.0
2017-01-25	CC	Futures	1689.0	1690.0	1649.0	1669.0	17031.0
2017-01-25	CNH	Futures	7.2531	7.2626	7.2516	7.2518	123.0
2017-01-25	CSC	Futures	3.932	3.937	3.909	3.921	104.0
2017-01-25	CT	Futures	84.18	85.2	84.02	84.87	14200.0
2017-01-25	DC	Futures	32.63	32.73	32.27	32.5	435.0
2017-01-25	DX	Futures	93.332	93.477	92.937	93.126	28271.0
2017-01-25	E1	Futures	1.24074	1.24669	1.23938	1.24235	15645.0
2017-01-25	E6	Futures	1.24188	1.24633	1.23957	1.24303	166635.0
2017-01-25	E7	Futures	1.2354	1.2399	1.2332	1.2367	2530.0
2017-01-25	EBM	Futures	193.13	193.99	192.85	193.13	11547.0
2017-01-25	ED	Futures	95.552	95.5568	95.5423	95.5423	166596.0
2017-01-25	ER	Futures	98.308	98.308	98.303	98.303	36728.0
2017-01-25	EW	Futures	1803.5	1821.1	1800.9	1819.0	14354.0
2017-01-25	FBON	Futures	121.57	121.81	121.27	121.34	801.0
2017-01-25	FBTP	Futures	105.33	105.45	104.75	104.97	115587.0
2017-01-25	FBTS	Futures	101.819	101.837	101.746	101.791	29319.0
2017-01-25	FCE	Futures	4268.6	4305.6	4268.6	4294.2	94165.0
2017-01-25	FDAX	Futures	12292.7	12489.6	12285.3	12483.2	87985.0
2017-01-25	FDXM	Futures	12242.1	12438.7	12233.7	12432.9	26176.0
2017-01-25	FESX	Futures	2631.9	2662.3	2630.3	2659.1	999702.0
2017-01-25	FEU3	Futures	98.976	98.976	98.976	98.976	3.0
2017-01-25	FGBL	Futures	146.5	146.54	145.67	145.88	1046323.0
2017-01-25	FGBM	Futures	128.63	128.65	128.31	128.38	635078.0
2017-01-25	FGBS	Futures	112.037	112.042	111.987	112.012	319927.0
2017-01-25	FGBX	Futures	164.69	164.83	162.6	163.31	67786.0
2017-01-25	FMWO	Futures	6011.9	6038.4	6011.9	6037.2	1676.0
2017-01-25	FOAT	Futures	131.73	131.8	130.97	131.12	144487.0
2017-01-25	FTDX	Futures	1806.8	1842.6	1804.3	1814.6	242.0
2017-01-25	FTI	Futures	441.42	444.75	441.28	443.79	30940.0
2017-01-25	FTUK	Futures	6030.0	6056.3	6010.1	6027.0	96831.0
2017-01-25	FVSA	Futures	828.95	838.42	812.37	821.84	10232.0
2017-01-25	FXXP	Futures	300.4	303.6	300.3	303.2	29096.0
2017-01-25	G	Futures	110.82	110.86	110.1	110.29	218967.0
2017-01-25	GF	Futures	296.081	298.417	294.542	296.024	3666.0
2017-01-25	GSCI	Futures	524.39	528.22	524.39	525.25	560.0

> showing 50 of 109 rows — these rows as CSV

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