PREVIEW / futures_daily / 2017-09-25

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-25.parquet
  size:    9 KB
  rows:    108

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-09-25	ES	Futures	2718.15	2724.13	2702.92	2715.97	1539626.0
2017-09-25	NQ	Futures	6966.33	6993.93	6862.08	6902.6	447828.0
2017-09-25	YM	Futures	23548.7	23594.1	23415.6	23523.3	144993.0
2017-09-25	CL	Futures	51.35	52.98	51.06	52.91	701244.0
2017-09-25	GC	Futures	1656.0	1674.2	1643.6	1668.8	362671.0
2017-09-25	ZN	Futures	123.978917	124.36404	123.948107	124.287015	1260658.0
2017-09-25	A6	Futures	0.81778	0.81963	0.81469	0.81634	95494.0
2017-09-25	AD	Futures	0.82515	0.82668	0.82195	0.82393	48092.0
2017-09-25	B	Futures	39.87	41.43	39.71	41.26	373286.0
2017-09-25	B6	Futures	1.4104	1.4185	1.4041	1.4081	125580.0
2017-09-25	BR	Futures	0.23803	0.23803	0.23736	0.23736	1.0
2017-09-25	BZ	Futures	39.53	41.07	39.4	40.93	23672.0
2017-09-25	C	Futures	1434.0	1461.0	1429.0	1438.0	7732.0
2017-09-25	CB	Futures	310.839	310.839	307.249	309.894	28.0
2017-09-25	CC	Futures	1467.0	1498.0	1455.0	1464.0	21975.0
2017-09-25	CNH	Futures	6.8151	6.8251	6.8142	6.8178	39.0
2017-09-25	CSC	Futures	3.483	3.553	3.483	3.543	204.0
2017-09-25	CT	Futures	80.63	81.69	80.26	81.59	11349.0
2017-09-25	DC	Futures	28.49	29.24	28.49	29.18	591.0
2017-09-25	DX	Futures	86.147	86.526	86.035	86.447	26581.0
2017-09-25	E1	Futures	1.26697	1.27504	1.26074	1.27174	33693.0
2017-09-25	E6	Futures	1.36588	1.36822	1.35624	1.35783	243300.0
2017-09-25	E7	Futures	1.3588	1.3609	1.3492	1.3507	6278.0
2017-09-25	EBM	Futures	177.21	179.36	176.67	179.09	19833.0
2017-09-25	ED	Futures	95.5085	95.5279	95.5036	95.5182	174622.0
2017-09-25	ER	Futures	98.337	98.342	98.337	98.342	31773.0
2017-09-25	EW	Futures	1880.2	1886.0	1874.8	1883.7	12707.0
2017-09-25	FBON	Futures	124.6	124.85	124.23	124.83	739.0
2017-09-25	FBTP	Futures	108.72	108.95	108.34	108.84	96930.0
2017-09-25	FBTS	Futures	103.21	103.246	103.182	103.237	29359.0
2017-09-25	FCE	Futures	4722.7	4733.9	4707.4	4715.9	57255.0
2017-09-25	FDAX	Futures	13192.5	13268.7	13178.3	13225.0	63710.0
2017-09-25	FDXM	Futures	13086.3	13159.3	13066.5	13113.4	21497.0
2017-09-25	FESX	Futures	2873.2	2884.6	2867.5	2877.3	646360.0
2017-09-25	FGBL	Futures	149.14	149.77	148.98	149.73	805436.0
2017-09-25	FGBM	Futures	129.47	129.76	129.41	129.75	533105.0
2017-09-25	FGBS	Futures	112.392	112.457	112.377	112.452	316224.0
2017-09-25	FGBX	Futures	167.28	168.71	166.99	168.38	51163.0
2017-09-25	FMWO	Futures	6615.2	6615.2	6598.6	6605.7	429.0
2017-09-25	FOAT	Futures	136.31	136.84	136.12	136.73	110813.0
2017-09-25	FTDX	Futures	2394.7	2413.6	2391.7	2405.6	116.0
2017-09-25	FTI	Futures	486.04	487.75	484.98	485.86	17526.0
2017-09-25	FTUK	Futures	6304.6	6316.7	6272.4	6305.0	65281.0
2017-09-25	FVSA	Futures	421.42	424.26	408.65	417.16	15837.0
2017-09-25	FXXP	Futures	324.2	325.5	323.8	325.3	29074.0
2017-09-25	G	Futures	113.43	113.74	113.24	113.61	149367.0
2017-09-25	GF	Futures	334.797	334.961	330.869	330.869	2408.0
2017-09-25	GSCI	Futures	481.0	484.17	481.0	482.85	578.0
2017-09-25	HE	Futures	83.13	85.271	82.835	84.791	17051.0
2017-09-25	HG	Futures	3.5551	3.5762	3.5327	3.5484	85089.0

> showing 50 of 108 rows — these rows as CSV

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