PREVIEW / futures_daily / 2012-12-19

all futures daily files

  file:    by_date/futures_daily/2012/2012-12-19.parquet
  size:    9 KB
  rows:    100

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-12-19	ES	Futures	1473.91	1479.54	1461.38	1466.24	2013922.0
2012-12-19	NQ	Futures	3116.59	3130.15	3099.87	3106.21	278685.0
2012-12-19	YM	Futures	13018.4	13059.6	12925.2	12962.5	130264.0
2012-12-19	CL	Futures	156.88	160.32	156.65	159.7	233083.0
2012-12-19	GC	Futures	2227.7	2235.9	2217.8	2222.4	157436.0
2012-12-19	ZN	Futures	116.445605	116.735031	116.321566	116.569645	1131712.0
2012-12-19	A6	Futures	0.95628	0.95756	0.95234	0.9539	85776.0
2012-12-19	AD	Futures	1.01503	1.01603	1.01202	1.01332	59720.0
2012-12-19	B	Futures	101.55	103.02	101.4	102.91	162393.0
2012-12-19	B6	Futures	1.6976	1.7038	1.6971	1.6986	93483.0
2012-12-19	BFX	Futures	3017.2	3028.1	3016.6	3018.7	124.0
2012-12-19	BR	Futures	0.23375	0.23468	0.23375	0.23466	362.0
2012-12-19	BZ	Futures	104.57	106.1	104.49	106.02	703.0
2012-12-19	C	Futures	1621.0	1623.0	1587.0	1591.0	12323.0
2012-12-19	CC	Futures	1811.0	1817.0	1769.0	1779.0	20270.0
2012-12-19	CSC	Futures	3.948	3.948	3.937	3.948	3.0
2012-12-19	CT	Futures	95.58	95.71	94.9	95.51	6869.0
2012-12-19	DC	Futures	29.61	29.62	29.32	29.54	58.0
2012-12-19	DX	Futures	76.557	76.581	76.205	76.492	31551.0
2012-12-19	E1	Futures	1.41174	1.41869	1.4111	1.4138	30229.0
2012-12-19	E6	Futures	1.56094	1.57109	1.56094	1.56377	228297.0
2012-12-19	E7	Futures	1.5506	1.5602	1.5504	1.5531	2921.0
2012-12-19	EBM	Futures	283.13	285.35	280.9	281.74	19889.0
2012-12-19	ED	Futures	95.2151	95.2247	95.2151	95.2151	165803.0
2012-12-19	ER	Futures	97.847	97.862	97.837	97.842	89846.0
2012-12-19	EW	Futures	1044.7	1047.7	1039.4	1044.0	32772.0
2012-12-19	FBTP	Futures	75.49	76.08	75.46	75.87	26490.0
2012-12-19	FBTS	Futures	90.79	91.027	90.748	90.959	3991.0
2012-12-19	FCE	Futures	2755.6	2768.1	2750.0	2763.6	137269.0
2012-12-19	FDAX	Futures	8389.5	8398.8	8369.3	8389.0	116045.0
2012-12-19	FESX	Futures	1805.0	1810.4	1798.2	1805.7	1092113.0
2012-12-19	FEU3	Futures	98.448	98.448	98.448	98.448	2.0
2012-12-19	FGBL	Futures	119.24	119.36	118.86	119.15	621747.0
2012-12-19	FGBM	Futures	117.03	117.16	116.85	117.05	451377.0
2012-12-19	FGBS	Futures	110.492	110.532	110.472	110.502	240841.0
2012-12-19	FGBX	Futures	125.8	126.02	124.97	125.55	5557.0
2012-12-19	FOAT	Futures	105.62	106.0	105.56	105.95	21619.0
2012-12-19	FTDX	Futures	794.3	796.2	794.3	794.8	2468.0
2012-12-19	FTI	Futures	296.12	297.58	295.73	296.94	37962.0
2012-12-19	FTUK	Futures	4351.2	4371.4	4345.3	4360.8	180522.0
2012-12-19	FVSA	Futures	3786.89	3817.35	3644.76	3766.59	8990.0
2012-12-19	FXXP	Futures	202.1	202.8	202.1	202.6	21840.0
2012-12-19	G	Futures	97.58	97.78	97.38	97.58	137819.0
2012-12-19	GF	Futures	288.995	291.557	288.711	291.225	2714.0
2012-12-19	GSCI	Futures	1034.62	1040.25	1032.52	1038.24	699.0
2012-12-19	HE	Futures	98.523	99.585	98.093	99.355	15294.0
2012-12-19	HG	Futures	4.6897	4.7019	4.6204	4.63	52617.0
2012-12-19	HH	Futures	38.978	38.978	38.978	38.978	935.0
2012-12-19	HO	Futures	2.4077	2.4375	2.406	2.4344	14855.0
2012-12-19	HRC	Futures	2428.1	2428.1	2428.1	2428.1	0.0

> showing 50 of 100 rows — these rows as CSV

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