PREVIEW / futures_daily / 2012-04-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-27.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-04-27	ES	Futures	1407.53	1413.83	1397.2	1409.29	1616584.0
2012-04-27	NQ	Futures	3115.79	3146.15	3103.47	3135.55	211998.0
2012-04-27	YM	Futures	12798.0	12847.6	12727.9	12801.9	112035.0
2012-04-27	CL	Futures	190.96	192.61	190.3	192.48	182104.0
2012-04-27	GC	Futures	2215.5	2230.3	2207.2	2225.5	97633.0
2012-04-27	ZN	Futures	114.450087	114.82915	114.314707	114.504239	1017218.0
2012-04-27	A6	Futures	0.92816	0.9376	0.92654	0.93706	132686.0
2012-04-27	AD	Futures	1.0197	1.02543	1.01819	1.02463	82806.0
2012-04-27	B	Futures	107.71	108.06	107.25	107.97	102858.0
2012-04-27	B6	Futures	1.6978	1.7083	1.695	1.707	107041.0
2012-04-27	BFX	Futures	2631.8	2690.4	2631.8	2688.6	30.0
2012-04-27	BR	Futures	0.25068	0.25163	0.25068	0.25144	264.0
2012-04-27	BZ	Futures	115.06	115.06	115.06	115.06	335.0
2012-04-27	C	Futures	1499.0	1522.0	1488.0	1517.0	2925.0
2012-04-27	CB	Futures	72.93	73.065	72.93	73.065	18.0
2012-04-27	CC	Futures	1713.0	1746.0	1693.0	1741.0	11404.0
2012-04-27	CSC	Futures	3.359	3.382	3.35	3.382	24.0
2012-04-27	CT	Futures	112.85	113.06	111.07	111.61	7732.0
2012-04-27	DC	Futures	23.2	23.36	22.89	23.3	346.0
2012-04-27	DX	Futures	76.746	76.867	76.271	76.307	22819.0
2012-04-27	E1	Futures	1.43874	1.44725	1.43429	1.44607	40724.0
2012-04-27	E6	Futures	1.57575	1.58447	1.57098	1.58315	224478.0
2012-04-27	E7	Futures	1.5608	1.5692	1.556	1.568	2908.0
2012-04-27	EBM	Futures	284.35	290.41	284.35	288.05	6391.0
2012-04-27	ED	Futures	95.0597	95.0693	95.0502	95.0693	83764.0
2012-04-27	ER	Futures	97.557	97.582	97.543	97.567	103415.0
2012-04-27	EW	Futures	1004.1	1010.7	998.1	1008.7	25836.0
2012-04-27	FBTP	Futures	65.54	65.8	65.01	65.67	28550.0
2012-04-27	FBTS	Futures	84.794	85.005	84.672	84.948	2467.0
2012-04-27	FCE	Futures	2283.9	2334.5	2253.2	2321.1	129901.0
2012-04-27	FDAX	Futures	7425.8	7555.2	7355.6	7520.3	151943.0
2012-04-27	FESX	Futures	1552.9	1588.8	1534.3	1577.8	1316195.0
2012-04-27	FEU3	Futures	98.132	98.142	98.132	98.142	200.0
2012-04-27	FGBL	Futures	115.8	115.93	115.31	115.37	691325.0
2012-04-27	FGBM	Futures	114.87	114.94	114.67	114.7	366744.0
2012-04-27	FGBS	Futures	110.208	110.233	110.163	110.178	327984.0
2012-04-27	FGBX	Futures	120.1	120.3	119.2	119.41	4861.0
2012-04-27	FOAT	Futures	94.75	94.99	94.55	94.83	7213.0
2012-04-27	FTDX	Futures	734.9	742.4	731.7	740.5	181.0
2012-04-27	FTI	Futures	265.64	269.06	262.55	266.59	38858.0
2012-04-27	FTUK	Futures	4168.8	4198.3	4137.4	4183.4	96662.0
2012-04-27	FVSA	Futures	9259.36	9259.36	8697.18	8697.18	3357.0
2012-04-27	FXXP	Futures	183.1	186.2	182.9	185.6	4609.0
2012-04-27	G	Futures	95.16	95.29	94.53	94.65	98085.0
2012-04-27	GF	Futures	308.959	310.313	307.24	309.896	1794.0
2012-04-27	GSCI	Futures	1083.63	1087.91	1080.45	1086.41	152.0
2012-04-27	HE	Futures	95.03	95.03	93.847	94.094	536.0
2012-04-27	HG	Futures	4.949	5.0282	4.9169	5.0092	58391.0
2012-04-27	HO	Futures	2.6277	2.6348	2.6062	2.617	70584.0
2012-04-27	HRC	Futures	2629.4	2629.4	2629.4	2629.4	0.0

> showing 50 of 100 rows — these rows as CSV

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