PREVIEW / futures_daily / 2012-05-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-05-18.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-05-18	ES	Futures	1312.05	1320.61	1299.7	1300.71	2816411.0
2012-05-18	NQ	Futures	2872.32	2889.22	2827.64	2827.92	421401.0
2012-05-18	YM	Futures	12080.3	12136.7	11979.1	11995.7	184650.0
2012-05-18	CL	Futures	170.88	170.88	167.23	168.24	173283.0
2012-05-18	GC	Futures	2104.8	2135.5	2095.8	2128.0	176041.0
2012-05-18	ZN	Futures	115.858037	115.966341	115.654967	115.939265	1187271.0
2012-05-18	A6	Futures	0.88704	0.88794	0.87859	0.88048	193238.0
2012-05-18	AD	Futures	0.98609	0.99163	0.98307	0.98438	119078.0
2012-05-18	B	Futures	96.53	97.65	96.21	96.88	206500.0
2012-05-18	B6	Futures	1.6563	1.662	1.651	1.6584	130916.0
2012-05-18	BFX	Futures	2507.5	2516.3	2505.3	2516.3	1.0
2012-05-18	BR	Futures	0.23749	0.23758	0.23124	0.23401	82.0
2012-05-18	BZ	Futures	103.12	104.03	102.97	103.24	617.0
2012-05-18	C	Futures	1527.0	1553.0	1522.0	1550.0	4554.0
2012-05-18	CB	Futures	75.352	75.352	74.814	75.352	3.0
2012-05-18	CC	Futures	1675.0	1723.0	1674.0	1714.0	9210.0
2012-05-18	CSC	Futures	3.543	3.556	3.531	3.556	27.0
2012-05-18	CT	Futures	93.89	95.57	93.55	95.41	9741.0
2012-05-18	DC	Futures	25.14	25.35	24.97	25.25	135.0
2012-05-18	DX	Futures	79.11	79.381	78.63	78.891	31550.0
2012-05-18	E1	Futures	1.38271	1.39514	1.37865	1.38899	50304.0
2012-05-18	E6	Futures	1.51439	1.52753	1.50938	1.52072	307173.0
2012-05-18	E7	Futures	1.5	1.5128	1.4938	1.5061	4134.0
2012-05-18	ED	Futures	95.0478	95.0478	95.0334	95.0454	116185.0
2012-05-18	ER	Futures	97.513	97.518	97.499	97.503	58320.0
2012-05-18	EW	Futures	925.2	931.3	911.2	911.5	30109.0
2012-05-18	FBTP	Futures	64.9	65.82	64.69	65.35	18947.0
2012-05-18	FBTS	Futures	84.192	84.533	83.996	84.273	5705.0
2012-05-18	FCE	Futures	2162.5	2214.1	2161.0	2195.3	179491.0
2012-05-18	FDAX	Futures	6881.4	7006.3	6877.5	6936.1	178400.0
2012-05-18	FESX	Futures	1446.7	1486.7	1439.1	1466.7	1866403.0
2012-05-18	FGBL	Futures	118.08	118.12	117.7	117.78	576322.0
2012-05-18	FGBM	Futures	115.74	115.77	115.54	115.59	316939.0
2012-05-18	FGBS	Futures	110.308	110.328	110.258	110.268	261074.0
2012-05-18	FGBX	Futures	126.58	126.84	125.79	125.98	5444.0
2012-05-18	FOAT	Futures	95.94	96.31	95.87	96.08	8952.0
2012-05-18	FTDX	Futures	697.9	701.7	689.1	695.1	242.0
2012-05-18	FTI	Futures	247.99	252.49	247.73	250.02	5553.0
2012-05-18	FTUK	Futures	3858.0	3866.7	3802.2	3828.8	156278.0
2012-05-18	FVSA	Futures	10961.63	10961.63	10476.88	10727.07	4072.0
2012-05-18	FXXP	Futures	172.9	174.4	172.0	172.5	5005.0
2012-05-18	G	Futures	97.53	97.65	97.18	97.39	111057.0
2012-05-18	GF	Futures	315.479	318.242	315.183	317.157	4205.0
2012-05-18	GSCI	Futures	1000.68	1004.33	995.05	997.51	149.0
2012-05-18	HE	Futures	93.526	93.819	92.593	93.259	14629.0
2012-05-18	HG	Futures	4.5365	4.6046	4.4939	4.5424	58325.0
2012-05-18	HO	Futures	2.342	2.3547	2.3263	2.3308	12707.0
2012-05-18	HRC	Futures	2609.8	2609.8	2609.8	2609.8	0.0
2012-05-18	J1	Futures	0.0158115	0.015878	0.0157827	0.0158617	90852.0
2012-05-18	J7	Futures	0.015725	0.015806	0.015711	0.015787	340.0

> showing 50 of 99 rows — these rows as CSV

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