PREVIEW / futures_daily / 2010-03-23

all futures daily files

  file:    by_date/futures_daily/2010/2010-03-23.parquet
  size:    9 KB
  rows:    91

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
2010-03-23	ES	Futures	1131.3	1139.82	1128.62	1138.84	1856410.0
2010-03-23	NQ	Futures	2209.88	2226.04	2201.37	2226.04	218369.0
2010-03-23	YM	Futures	9859.1	9956.6	9851.8	9953.8	113084.0
2010-03-23	CL	Futures	191.41	192.32	189.17	191.65	261873.0
2010-03-23	GC	Futures	1512.7	1520.2	1501.0	1514.3	146151.0
2010-03-23	ZN	Futures	95.741537	95.881827	95.665015	95.728784	587672.0
2010-03-23	A6	Futures	0.74684	0.74799	0.74291	0.74586	69519.0
2010-03-23	AD	Futures	0.96948	0.97235	0.96494	0.96998	62332.0
2010-03-23	B	Futures	72.26	72.65	71.46	72.22	142260.0
2010-03-23	B6	Futures	1.5675	1.5682	1.5537	1.5598	104308.0
2010-03-23	BFX	Futures	2968.1	2995.4	2968.1	2982.8	173.0
2010-03-23	BR	Futures	0.22318	0.22574	0.22318	0.22496	69.0
2010-03-23	BZ	Futures	75.24	76.37	75.16	75.95	201.0
2010-03-23	C	Futures	2230.0	2249.0	2218.0	2229.0	4797.0
2010-03-23	CB	Futures	74.024	74.024	73.777	73.777	1.0
2010-03-23	CC	Futures	2438.0	2485.0	2418.0	2451.0	6513.0
2010-03-23	CT	Futures	67.08	67.46	66.68	67.41	4168.0
2010-03-23	DC	Futures	22.08	22.25	21.72	22.07	428.0
2010-03-23	DX	Futures	81.864	82.336	81.854	82.202	19867.0
2010-03-23	E1	Futures	1.24512	1.24893	1.23788	1.24551	49713.0
2010-03-23	E6	Futures	1.60472	1.60531	1.59407	1.59573	324045.0
2010-03-23	E7	Futures	1.5918	1.592	1.5811	1.5827	4734.0
2010-03-23	EBM	Futures	208.09	209.32	205.63	206.45	4503.0
2010-03-23	ED	Futures	94.3708	94.3944	94.366	94.385	191890.0
2010-03-23	ER	Futures	97.375	97.394	97.37	97.394	116474.0
2010-03-23	EW	Futures	771.0	778.2	768.3	776.7	24283.0
2010-03-23	FBTP	Futures	64.46	64.6	64.43	64.56	3411.0
2010-03-23	FCE	Futures	2511.2	2541.6	2509.9	2530.4	100532.0
2010-03-23	FDAX	Futures	6521.9	6586.6	6513.8	6562.2	126386.0
2010-03-23	FESX	Futures	1725.1	1749.0	1723.3	1740.4	1057553.0
2010-03-23	FEU3	Futures	97.943	97.953	97.943	97.953	100.0
2010-03-23	FGBL	Futures	96.43	96.6	96.4	96.51	632006.0
2010-03-23	FGBM	Futures	101.86	101.98	101.83	101.92	361408.0
2010-03-23	FGBS	Futures	106.326	106.39	106.317	106.361	348598.0
2010-03-23	FGBX	Futures	90.88	91.37	90.88	91.17	3741.0
2010-03-23	FTDX	Futures	718.6	729.6	718.6	721.7	454.0
2010-03-23	FTI	Futures	272.74	276.51	272.34	274.89	30930.0
2010-03-23	FTUK	Futures	3795.1	3826.2	3789.0	3815.7	109254.0
2010-03-23	G	Futures	76.96	77.02	76.75	76.9	83920.0
2010-03-23	GF	Futures	281.164	282.534	278.294	279.337	1473.0
2010-03-23	GSCI	Futures	962.72	967.23	959.13	962.44	161.0
2010-03-23	HE	Futures	97.823	97.823	96.023	96.694	169.0
2010-03-23	HG	Futures	4.6254	4.6582	4.5879	4.6165	22111.0
2010-03-23	HO	Futures	1.9257	1.9412	1.9109	1.9389	15132.0
2010-03-23	HRC	Futures	3037.7	3037.7	3037.7	3037.7	0.0
2010-03-23	J1	Futures	0.0139636	0.0139661	0.013902	0.0139121	69763.0
2010-03-23	J7	Futures	0.013856	0.013856	0.01379	0.013801	88.0
2010-03-23	JB	Futures	117.87	118.11	117.76	118.04	3076.0
2010-03-23	KC	Futures	341.58	346.72	340.04	346.08	10534.0
2010-03-23	KE	Futures	2184.62	2195.69	2146.95	2149.17	6075.0

> showing 50 of 91 rows — these rows as CSV

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