PREVIEW / futures_daily / 2009-01-21

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-21.parquet
  size:    8 KB
  rows:    86

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
2009-01-21	ES	Futures	761.8	791.79	755.9	790.13	2859490.0
2009-01-21	NQ	Futures	1283.73	1324.81	1274.51	1320.9	299364.0
2009-01-21	YM	Futures	7077.7	7297.6	7023.4	7281.6	207318.0
2009-01-21	CL	Futures	135.91	147.6	133.68	144.68	276261.0
2009-01-21	GC	Futures	1195.3	1205.4	1175.3	1185.2	123210.0
2009-01-21	ZN	Futures	96.363814	96.363814	95.300011	95.431492	496284.0
2009-01-21	A6	Futures	0.51044	0.52559	0.50941	0.51964	30063.0
2009-01-21	AD	Futures	0.7756	0.78297	0.76921	0.77845	37017.0
2009-01-21	B	Futures	45.29	47.22	44.21	46.45	93858.0
2009-01-21	B6	Futures	1.44	1.4562	1.4143	1.445	89858.0
2009-01-21	BFX	Futures	1973.7	1984.6	1923.1	1962.1	315.0
2009-01-21	BZ	Futures	45.15	46.79	44.94	46.64	191.0
2009-01-21	C	Futures	1887.0	1977.0	1867.0	1971.0	10269.0
2009-01-21	CB	Futures	76.672	76.672	76.507	76.507	6.0
2009-01-21	CC	Futures	2170.0	2334.0	2156.0	2296.0	14461.0
2009-01-21	CT	Futures	45.85	46.45	45.41	45.97	6419.0
2009-01-21	DC	Futures	26.06	26.86	25.98	26.62	162.0
2009-01-21	DX	Futures	90.239	90.42	89.057	89.71	3706.0
2009-01-21	E1	Futures	1.1573	1.16846	1.1448	1.14826	37164.0
2009-01-21	E6	Futures	1.52072	1.54854	1.5167	1.53114	195377.0
2009-01-21	E7	Futures	1.5036	1.5306	1.4995	1.5136	3283.0
2009-01-21	EBM	Futures	226.25	227.4	223.19	226.25	2718.0
2009-01-21	ED	Futures	93.2555	93.2697	93.1331	93.1425	277979.0
2009-01-21	ER	Futures	96.248	96.292	96.233	96.263	166466.0
2009-01-21	EW	Futures	475.7	496.0	470.6	493.8	32311.0
2009-01-21	FCE	Futures	1796.4	1850.2	1757.8	1797.3	145611.0
2009-01-21	FDAX	Futures	4622.2	4777.2	4529.4	4653.9	204413.0
2009-01-21	FESX	Futures	1261.1	1294.4	1230.1	1255.3	1596199.0
2009-01-21	FEU3	Futures	96.835	96.835	96.815	96.83	433.0
2009-01-21	FGBL	Futures	93.57	93.78	93.27	93.59	537166.0
2009-01-21	FGBM	Futures	98.01	98.14	97.85	98.01	365171.0
2009-01-21	FGBS	Futures	103.623	103.685	103.56	103.632	400278.0
2009-01-21	FGBX	Futures	84.27	85.04	84.27	84.8	1132.0
2009-01-21	FTDX	Futures	413.5	418.8	400.9	411.7	364.0
2009-01-21	FTI	Futures	192.73	193.3	187.09	191.16	41091.0
2009-01-21	FTUK	Futures	2632.8	2708.2	2600.0	2634.5	166466.0
2009-01-21	G	Futures	74.83	75.43	74.66	74.91	83563.0
2009-01-21	GF	Futures	257.4	259.504	254.174	256.278	1045.0
2009-01-21	GSCI	Futures	775.83	803.04	768.09	799.05	303.0
2009-01-21	HE	Futures	127.004	127.777	124.491	126.328	4505.0
2009-01-21	HG	Futures	2.0838	2.1358	2.007	2.0176	12083.0
2009-01-21	HO	Futures	1.5315	1.5464	1.4953	1.5372	29466.0
2009-01-21	HRC	Futures	3189.6	3189.6	3189.6	3189.6	0.0
2009-01-21	J1	Futures	0.0140877	0.0145209	0.014022	0.0141799	129997.0
2009-01-21	J7	Futures	0.013915	0.014345	0.013857	0.014009	236.0
2009-01-21	JB	Futures	116.92	117.12	116.82	116.93	1.0
2009-01-21	KC	Futures	328.67	337.25	322.1	335.96	12200.0
2009-01-21	KE	Futures	2909.21	3002.9	2904.22	3000.4	5832.0
2009-01-21	L	Futures	97.097	97.156	96.974	97.009	91622.0
2009-01-21	LBS	Futures	897.5	900.3	869.4	870.6	86.0

> showing 50 of 86 rows — these rows as CSV

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