PREVIEW / futures_daily / 2012-08-29

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-29.parquet
  size:    9 KB
  rows:    101

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-08-29	ES	Futures	1425.15	1430.47	1422.62	1425.15	959745.0
2012-08-29	NQ	Futures	3193.08	3202.83	3180.74	3192.22	134170.0
2012-08-29	YM	Futures	12693.8	12739.4	12675.3	12693.8	82619.0
2012-08-29	CL	Futures	173.82	174.34	171.43	172.75	185887.0
2012-08-29	GC	Futures	2228.1	2233.0	2208.8	2220.3	112444.0
2012-08-29	ZN	Futures	116.713031	116.821981	116.49513	116.658556	1547323.0
2012-08-29	A6	Futures	0.93048	0.93335	0.92886	0.93012	89154.0
2012-08-29	AD	Futures	1.01383	1.01584	1.01223	1.01383	63001.0
2012-08-29	B	Futures	102.23	102.92	101.38	102.19	96030.0
2012-08-29	B6	Futures	1.6537	1.6569	1.6515	1.655	69257.0
2012-08-29	BFX	Futures	2817.8	2817.8	2815.4	2815.4	4.0
2012-08-29	BR	Futures	0.23303	0.23345	0.23286	0.23345	1175.0
2012-08-29	BZ	Futures	106.98	107.1	106.98	107.1	3300.0
2012-08-29	C	Futures	1711.0	1727.0	1700.0	1707.0	4235.0
2012-08-29	CB	Futures	98.215	98.215	98.215	98.215	20.0
2012-08-29	CC	Futures	1937.0	1961.0	1931.0	1941.0	12887.0
2012-08-29	CSC	Futures	4.135	4.156	4.13	4.149	9.0
2012-08-29	CT	Futures	98.52	99.94	98.52	99.89	21.0
2012-08-29	DC	Futures	30.65	31.18	30.65	31.15	210.0
2012-08-29	DX	Futures	78.974	79.207	78.96	79.167	11040.0
2012-08-29	E1	Futures	1.3512	1.35197	1.34629	1.34719	25279.0
2012-08-29	E6	Futures	1.48253	1.48347	1.47698	1.47793	177805.0
2012-08-29	E7	Futures	1.4734	1.4743	1.4678	1.4687	2611.0
2012-08-29	ED	Futures	95.1919	95.1919	95.1847	95.1895	94263.0
2012-08-29	ER	Futures	97.852	97.857	97.847	97.852	45041.0
2012-08-29	EW	Futures	985.6	989.2	982.3	985.0	13122.0
2012-08-29	FBTP	Futures	66.55	66.97	66.16	66.77	18433.0
2012-08-29	FBTS	Futures	87.295	87.585	87.122	87.428	4642.0
2012-08-29	FCE	Futures	2557.2	2560.9	2531.5	2538.9	73147.0
2012-08-29	FDAX	Futures	7653.4	7678.0	7582.4	7643.6	97896.0
2012-08-29	FESX	Futures	1652.9	1656.3	1638.0	1643.4	594191.0
2012-08-29	FEU3	Futures	98.428	98.433	98.428	98.433	50.0
2012-08-29	FGBL	Futures	118.83	119.25	118.44	118.59	616455.0
2012-08-29	FGBM	Futures	116.46	116.68	116.31	116.38	310571.0
2012-08-29	FGBS	Futures	110.457	110.497	110.442	110.457	228077.0
2012-08-29	FGBX	Futures	127.95	128.84	127.07	127.5	3996.0
2012-08-29	FOAT	Futures	103.18	103.42	102.77	102.88	32460.0
2012-08-29	FTDX	Futures	736.1	740.3	736.1	740.3	15.0
2012-08-29	FTI	Futures	280.26	281.62	279.24	281.15	21406.0
2012-08-29	FTUK	Futures	4194.9	4198.6	4173.1	4179.6	53457.0
2012-08-29	FVSA	Futures	6853.01	6891.44	6724.92	6814.58	2743.0
2012-08-29	FXXP	Futures	191.5	191.8	190.3	191.4	1465.0
2012-08-29	G	Futures	99.89	100.0	99.51	99.65	232732.0
2012-08-29	GF	Futures	282.407	284.968	281.028	283.097	1075.0
2012-08-29	GSCI	Futures	1075.76	1079.22	1071.82	1075.84	80.0
2012-08-29	HE	Futures	90.464	91.731	89.661	91.082	16547.0
2012-08-29	HG	Futures	4.4573	4.4631	4.4053	4.4323	34045.0
2012-08-29	HH	Futures	35.993	35.993	35.993	35.993	5500.0
2012-08-29	HO	Futures	2.5347	2.5436	2.517	2.531	18598.0
2012-08-29	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0

> showing 50 of 101 rows — these rows as CSV

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