PREVIEW / futures_daily / 2014-06-27

all futures daily files

  file:    by_date/futures_daily/2014/2014-06-27.parquet
  size:    9 KB
  rows:    104

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
2014-06-27	ES	Futures	2023.84	2029.81	2018.12	2027.73	1176129.0
2014-06-27	NQ	Futures	4403.97	4427.91	4393.59	4420.7	182900.0
2014-06-27	YM	Futures	16918.7	16932.8	16836.9	16907.6	109965.0
2014-06-27	CL	Futures	192.97	193.98	192.4	193.15	128975.0
2014-06-27	GC	Futures	1735.4	1743.3	1730.3	1739.2	104663.0
2014-06-27	ZN	Futures	116.710803	116.973402	116.696214	116.798336	751827.0
2014-06-27	A6	Futures	0.90475	0.90765	0.90407	0.90581	56496.0
2014-06-27	AD	Futures	0.9481	0.95105	0.9477	0.95095	48807.0
2014-06-27	ALI	Futures	2792.49	2792.49	2792.49	2792.49	0.0
2014-06-27	B	Futures	118.44	119.13	118.25	118.69	75260.0
2014-06-27	B6	Futures	1.7887	1.7916	1.7868	1.7883	61061.0
2014-06-27	BFX	Futures	3789.3	3795.5	3789.3	3795.5	1.0
2014-06-27	BR	Futures	0.23645	0.23753	0.23468	0.2351	1618.0
2014-06-27	BZ	Futures	119.26	119.87	119.01	119.45	8215.0
2014-06-27	C	Futures	2016.0	2065.0	2015.0	2063.0	5579.0
2014-06-27	CB	Futures	123.528	124.912	123.528	123.528	12.0
2014-06-27	CC	Futures	2248.0	2306.0	2248.0	2303.0	18540.0
2014-06-27	CNH	Futures	7.167	7.167	7.153	7.153	1.0
2014-06-27	CSC	Futures	4.667	4.667	4.622	4.622	7.0
2014-06-27	CT	Futures	92.67	94.37	92.67	93.73	24.0
2014-06-27	DC	Futures	37.5	37.57	36.81	36.83	133.0
2014-06-27	DX	Futures	76.18	76.194	75.995	76.02	16745.0
2014-06-27	E1	Futures	1.43545	1.44032	1.43506	1.43942	28202.0
2014-06-27	E6	Futures	1.6066	1.61132	1.60624	1.61049	118127.0
2014-06-27	E7	Futures	1.596	1.6008	1.5959	1.6	1573.0
2014-06-27	ED	Futures	95.4162	95.4162	95.4115	95.4115	39305.0
2014-06-27	ER	Futures	97.92	97.92	97.916	97.916	35039.0
2014-06-27	EW	Futures	1469.4	1480.0	1464.1	1477.5	13843.0
2014-06-27	FBTP	Futures	91.56	91.69	91.33	91.62	59423.0
2014-06-27	FBTS	Futures	98.143	98.17	98.072	98.152	11916.0
2014-06-27	FCE	Futures	3552.5	3561.7	3532.9	3543.7	72272.0
2014-06-27	FDAX	Futures	10822.6	10853.4	10789.0	10820.4	62285.0
2014-06-27	FESX	Futures	2329.6	2334.6	2312.3	2318.8	653227.0
2014-06-27	FGBL	Futures	127.99	127.99	127.66	127.76	456902.0
2014-06-27	FGBM	Futures	121.5	121.51	121.3	121.37	340056.0
2014-06-27	FGBS	Futures	110.768	110.768	110.738	110.748	143737.0
2014-06-27	FGBX	Futures	132.93	133.15	132.61	132.93	18366.0
2014-06-27	FMWO	Futures	5768.9	5772.6	5761.3	5772.6	144.0
2014-06-27	FOAT	Futures	117.79	117.79	117.46	117.54	47881.0
2014-06-27	FTDX	Futures	1220.7	1224.9	1218.8	1224.9	69.0
2014-06-27	FTI	Futures	356.37	356.41	354.33	355.2	18093.0
2014-06-27	FTUK	Futures	5149.2	5174.6	5143.1	5165.4	57290.0
2014-06-27	FVSA	Futures	1328.04	1349.53	1315.15	1332.34	3805.0
2014-06-27	FXXP	Futures	256.9	257.5	256.2	256.9	3016.0
2014-06-27	G	Futures	94.04	94.21	93.96	94.08	96413.0
2014-06-27	GF	Futures	330.121	330.734	327.056	328.473	4133.0
2014-06-27	GSCI	Futures	1110.0	1110.0	1104.83	1106.16	474.0
2014-06-27	HE	Futures	136.6	137.836	136.179	137.731	7681.0
2014-06-27	HG	Futures	4.0544	4.0768	4.0417	4.0493	40489.0
2014-06-27	HH	Futures	55.701	55.929	55.385	55.752	230.0

> showing 50 of 104 rows — these rows as CSV

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