PREVIEW / futures_daily / 2017-07-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-05.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
2017-07-05	ES	Futures	2634.19	2643.42	2629.3	2638.81	1287423.0
2017-07-05	NQ	Futures	6572.74	6662.67	6536.3	6643.57	392297.0
2017-07-05	YM	Futures	22643.3	22699.3	22567.1	22645.4	159867.0
2017-07-05	CL	Futures	48.58	48.87	45.96	46.6	1173581.0
2017-07-05	GC	Futures	1557.6	1568.1	1553.0	1559.6	366767.0
2017-07-05	ZN	Futures	123.211247	123.611384	123.103518	123.334366	1649926.0
2017-07-05	A6	Futures	0.78575	0.78852	0.77681	0.77948	136793.0
2017-07-05	AD	Futures	0.7826	0.7886	0.78239	0.78489	105165.0
2017-07-05	ALI	Futures	2537.22	2537.22	2537.22	2537.22	0.0
2017-07-05	B	Futures	35.12	35.24	33.23	33.79	372984.0
2017-07-05	B6	Futures	1.3549	1.3573	1.3504	1.3546	110939.0
2017-07-05	BFX	Futures	4591.4	4633.7	4591.4	4632.5	2.0
2017-07-05	BR	Futures	0.22119	0.22274	0.22055	0.22271	22.0
2017-07-05	BZ	Futures	34.84	35.05	33.21	33.57	40863.0
2017-07-05	C	Futures	1560.0	1564.0	1540.0	1557.0	1572.0
2017-07-05	CB	Futures	324.786	324.786	324.421	324.421	10.0
2017-07-05	CC	Futures	1481.0	1487.0	1458.0	1478.0	15562.0
2017-07-05	CNH	Futures	7.0655	7.0714	7.0614	7.0614	40.0
2017-07-05	CSC	Futures	3.487	3.515	3.487	3.503	38.0
2017-07-05	CT	Futures	79.1	80.54	78.85	80.54	6.0
2017-07-05	DC	Futures	28.97	29.22	28.94	29.15	141.0
2017-07-05	DX	Futures	89.553	89.88	89.478	89.697	19131.0
2017-07-05	E1	Futures	1.28034	1.2823	1.27334	1.27837	33075.0
2017-07-05	E6	Futures	1.30716	1.3086	1.30109	1.30447	257199.0
2017-07-05	E7	Futures	1.3004	1.3015	1.2943	1.2976	3967.0
2017-07-05	EBM	Futures	200.7	204.04	199.59	200.98	18955.0
2017-07-05	ED	Futures	95.5596	95.5692	95.5547	95.5596	273304.0
2017-07-05	ER	Futures	98.337	98.337	98.332	98.332	26856.0
2017-07-05	EW	Futures	1861.6	1867.2	1850.6	1860.9	15537.0
2017-07-05	FBON	Futures	123.9	124.05	123.52	123.71	553.0
2017-07-05	FBTP	Futures	107.82	107.95	107.43	107.7	79456.0
2017-07-05	FBTS	Futures	102.754	102.763	102.699	102.717	28219.0
2017-07-05	FCE	Futures	4670.8	4680.7	4650.1	4668.5	70674.0
2017-07-05	FDAX	Futures	13085.6	13153.0	13052.4	13108.8	80831.0
2017-07-05	FDXM	Futures	13006.1	13071.0	12971.6	13028.1	22587.0
2017-07-05	FESX	Futures	2834.9	2842.2	2823.4	2834.9	690544.0
2017-07-05	FEU3	Futures	99.006	99.011	99.006	99.011	5.0
2017-07-05	FGBL	Futures	147.03	147.28	146.75	147.1	658078.0
2017-07-05	FGBM	Futures	128.59	128.68	128.46	128.6	443514.0
2017-07-05	FGBS	Futures	112.106	112.121	112.061	112.106	313560.0
2017-07-05	FGBX	Futures	163.76	164.59	162.95	164.36	51300.0
2017-07-05	FMWO	Futures	6405.5	6413.8	6394.7	6411.4	542.0
2017-07-05	FOAT	Futures	134.81	134.99	134.55	134.88	98653.0
2017-07-05	FTDX	Futures	2208.6	2223.6	2195.0	2221.6	157.0
2017-07-05	FTI	Futures	472.8	473.03	470.4	471.65	22753.0
2017-07-05	FTUK	Futures	6292.8	6329.0	6291.0	6308.7	88627.0
2017-07-05	FVSA	Futures	486.51	497.54	478.64	486.51	24021.0
2017-07-05	FXXP	Futures	323.9	325.4	323.3	325.0	31901.0
2017-07-05	G	Futures	114.13	114.13	113.64	114.01	196695.0
2017-07-05	GF	Futures	320.771	320.991	311.826	312.21	6863.0

> showing 50 of 110 rows — these rows as CSV

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