PREVIEW / futures_daily / 2012-07-19

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-19.parquet
  size:    9 KB
  rows:    99

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
2012-07-19	ES	Futures	1384.64	1393.5	1383.38	1389.45	1743124.0
2012-07-19	NQ	Futures	3010.58	3050.75	3010.58	3044.15	254512.0
2012-07-19	YM	Futures	12478.4	12550.2	12452.2	12495.9	113531.0
2012-07-19	CL	Futures	163.98	169.24	163.64	168.74	288797.0
2012-07-19	GC	Futures	2102.8	2127.5	2101.6	2112.7	134865.0
2012-07-19	ZN	Futures	117.325876	117.434827	117.17607	117.203307	776003.0
2012-07-19	A6	Futures	0.92679	0.93416	0.92634	0.93308	137655.0
2012-07-19	AD	Futures	0.99108	0.99468	0.99077	0.99408	99168.0
2012-07-19	B	Futures	94.61	97.18	94.58	96.84	206167.0
2012-07-19	B6	Futures	1.6358	1.6446	1.6339	1.6429	102754.0
2012-07-19	BFX	Futures	2728.6	2750.9	2728.6	2744.1	91.0
2012-07-19	BR	Futures	0.2346	0.23544	0.2346	0.2348	2.0
2012-07-19	BZ	Futures	101.42	104.09	101.42	103.76	581.0
2012-07-19	C	Futures	1540.0	1584.0	1527.0	1559.0	6829.0
2012-07-19	CB	Futures	88.539	88.539	88.539	88.539	2.0
2012-07-19	CC	Futures	1669.0	1722.0	1669.0	1680.0	12023.0
2012-07-19	CSC	Futures	4.019	4.062	4.019	4.049	19.0
2012-07-19	CT	Futures	93.75	95.11	93.61	94.57	112.0
2012-07-19	DC	Futures	29.76	30.11	29.44	29.87	413.0
2012-07-19	DX	Futures	80.663	80.809	80.367	80.542	18933.0
2012-07-19	E1	Futures	1.32189	1.32653	1.31633	1.32163	37606.0
2012-07-19	E6	Futures	1.44997	1.45504	1.44348	1.44938	255789.0
2012-07-19	E7	Futures	1.4403	1.446	1.4346	1.4404	3979.0
2012-07-19	ED	Futures	95.18	95.2086	95.1752	95.1895	164792.0
2012-07-19	ER	Futures	97.744	97.744	97.729	97.739	49528.0
2012-07-19	EW	Futures	960.1	965.9	956.6	959.8	22866.0
2012-07-19	FBTP	Futures	64.89	65.52	64.8	65.24	18177.0
2012-07-19	FBTS	Futures	84.939	85.178	84.914	85.005	3215.0
2012-07-19	FCE	Futures	2416.9	2435.5	2410.2	2428.4	76541.0
2012-07-19	FDAX	Futures	7329.1	7398.5	7313.8	7372.8	120780.0
2012-07-19	FESX	Futures	1548.1	1561.6	1544.0	1553.5	1133074.0
2012-07-19	FEU3	Futures	98.32	98.325	98.32	98.32	2.0
2012-07-19	FGBL	Futures	119.94	120.05	119.63	119.88	453890.0
2012-07-19	FGBM	Futures	116.86	116.92	116.74	116.86	248010.0
2012-07-19	FGBS	Futures	110.542	110.557	110.502	110.532	176562.0
2012-07-19	FGBX	Futures	129.36	130.12	129.06	129.53	4969.0
2012-07-19	FOAT	Futures	102.55	103.13	102.47	102.84	22783.0
2012-07-19	FTDX	Futures	712.8	725.9	712.8	720.7	106.0
2012-07-19	FTI	Futures	271.27	273.74	270.93	273.06	20561.0
2012-07-19	FTUK	Futures	4111.6	4138.9	4106.1	4123.6	71037.0
2012-07-19	FVSA	Futures	6498.78	6568.06	6484.92	6526.49	2038.0
2012-07-19	FXXP	Futures	185.7	187.4	185.6	187.1	5257.0
2012-07-19	G	Futures	100.46	100.59	100.01	100.25	122013.0
2012-07-19	GF	Futures	270.925	274.872	265.744	274.527	4782.0
2012-07-19	GSCI	Futures	1032.21	1043.67	1029.82	1040.96	197.0
2012-07-19	HE	Futures	99.817	100.752	99.122	99.469	14322.0
2012-07-19	HG	Futures	4.4755	4.567	4.4697	4.5534	54753.0
2012-07-19	HO	Futures	2.3589	2.4122	2.3561	2.4093	37686.0
2012-07-19	HRC	Futures	2450.1	2450.1	2450.1	2450.1	20.0
2012-07-19	J1	Futures	0.015908	0.0159982	0.015908	0.0159569	65485.0

> showing 50 of 99 rows — these rows as CSV

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