PREVIEW / futures_daily / 2012-04-17

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-17.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-04-17	ES	Futures	1374.78	1399.47	1369.74	1394.18	1848818.0
2012-04-17	NQ	Futures	3053.34	3125.81	3041.03	3108.05	300859.0
2012-04-17	YM	Futures	12496.5	12710.4	12463.4	12665.7	121341.0
2012-04-17	CL	Futures	190.06	193.53	189.13	191.95	157359.0
2012-04-17	GC	Futures	2210.7	2216.9	2185.9	2207.2	142002.0
2012-04-17	ZN	Futures	114.043948	114.179327	113.773188	113.867954	936471.0
2012-04-17	A6	Futures	0.92537	0.93095	0.92078	0.9305	110030.0
2012-04-17	AD	Futures	1.00501	1.01869	1.0037	1.01537	140020.0
2012-04-17	B	Futures	107.2	107.93	106.7	107.43	248457.0
2012-04-17	B6	Futures	1.6681	1.6761	1.6643	1.6734	103769.0
2012-04-17	BFX	Futures	2670.7	2729.6	2670.7	2729.6	1728.0
2012-04-17	BR	Futures	0.25642	0.25657	0.2544	0.25554	50.0
2012-04-17	BZ	Futures	113.33	114.13	112.89	113.63	741.0
2012-04-17	C	Futures	1461.0	1490.0	1452.0	1480.0	3247.0
2012-04-17	CB	Futures	79.12	79.12	78.178	78.191	13.0
2012-04-17	CC	Futures	1678.0	1728.0	1672.0	1720.0	12166.0
2012-04-17	CSC	Futures	3.513	3.513	3.485	3.487	96.0
2012-04-17	CT	Futures	110.18	112.8	109.41	111.92	10312.0
2012-04-17	DC	Futures	24.56	24.66	24.05	24.14	310.0
2012-04-17	DX	Futures	77.293	77.453	77.085	77.15	15480.0
2012-04-17	E1	Futures	1.43128	1.43586	1.42709	1.43285	33179.0
2012-04-17	E6	Futures	1.56835	1.57313	1.56322	1.56895	226444.0
2012-04-17	E7	Futures	1.5535	1.5578	1.5482	1.5539	3363.0
2012-04-17	EBM	Futures	282.33	286.37	281.32	285.36	20449.0
2012-04-17	ED	Futures	95.0597	95.074	95.0549	95.0693	132104.0
2012-04-17	ER	Futures	97.489	97.513	97.484	97.503	63197.0
2012-04-17	EW	Futures	973.8	995.2	970.3	987.7	20294.0
2012-04-17	FBTP	Futures	65.93	66.49	65.74	66.38	12442.0
2012-04-17	FBTS	Futures	84.647	84.932	84.623	84.9	1720.0
2012-04-17	FCE	Futures	2267.7	2339.9	2265.2	2332.7	137253.0
2012-04-17	FDAX	Futures	7331.3	7537.5	7322.5	7519.2	161217.0
2012-04-17	FESX	Futures	1544.7	1593.0	1541.2	1589.5	1331191.0
2012-04-17	FGBL	Futures	115.04	115.13	114.65	114.76	673036.0
2012-04-17	FGBM	Futures	114.48	114.54	114.29	114.36	334388.0
2012-04-17	FGBS	Futures	110.094	110.118	110.049	110.059	250707.0
2012-04-17	FGBX	Futures	119.8	119.98	118.85	119.02	5798.0
2012-04-17	FOAT	Futures	94.55	94.81	94.16	94.5	3743.0
2012-04-17	FTDX	Futures	728.4	745.7	723.7	735.9	351.0
2012-04-17	FTI	Futures	260.86	267.24	260.51	266.94	16369.0
2012-04-17	FTUK	Futures	4102.4	4180.8	4089.6	4176.8	92982.0
2012-04-17	FVSA	Futures	9623.12	9672.72	9358.56	9457.77	10633.0
2012-04-17	FXXP	Futures	181.4	185.3	181.4	185.2	7094.0
2012-04-17	G	Futures	95.33	95.33	94.7	94.8	111388.0
2012-04-17	GF	Futures	317.499	320.05	316.561	318.957	2532.0
2012-04-17	GSCI	Futures	1076.4	1081.64	1076.4	1077.67	409.0
2012-04-17	HE	Futures	98.029	98.827	96.488	98.827	512.0
2012-04-17	HG	Futures	4.7565	4.7912	4.6994	4.7814	68255.0
2012-04-17	HO	Futures	2.572	2.5812	2.5563	2.5737	35317.0
2012-04-17	HRC	Futures	2680.3	2680.3	2680.3	2680.3	0.0
2012-04-17	J1	Futures	0.0156021	0.0156184	0.0155018	0.0155269	80215.0

> showing 50 of 99 rows — these rows as CSV

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