PREVIEW / futures_daily / 2009-12-17

all futures daily files

  file:    by_date/futures_daily/2009/2009-12-17.parquet
  size:    9 KB
  rows:    90

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-12-17	ES	Futures	1071.37	1072.58	1057.31	1060.71	2014202.0
2009-12-17	NQ	Futures	2036.45	2039.0	2006.48	2019.49	317003.0
2009-12-17	YM	Futures	9487.0	9496.1	9359.1	9382.8	114726.0
2009-12-17	CL	Futures	176.7	177.79	172.9	175.68	213975.0
2009-12-17	GC	Futures	1567.3	1573.1	1508.1	1524.2	236024.0
2009-12-17	ZN	Futures	94.491868	95.234906	94.46668	95.146749	734075.0
2009-12-17	A6	Futures	0.7251	0.72551	0.71242	0.71445	88872.0
2009-12-17	AD	Futures	0.93009	0.93039	0.91844	0.92249	93955.0
2009-12-17	B	Futures	68.69	68.69	66.46	67.4	128473.0
2009-12-17	B6	Futures	1.6945	1.6964	1.6692	1.677	128429.0
2009-12-17	BFX	Futures	2853.0	2853.0	2817.1	2819.6	645.0
2009-12-17	BR	Futures	0.22184	0.22192	0.22184	0.22192	89.0
2009-12-17	C	Futures	2342.0	2371.0	2319.0	2337.0	6981.0
2009-12-17	CB	Futures	71.31	71.803	70.816	70.816	42.0
2009-12-17	CC	Futures	2986.0	2998.0	2921.0	2942.0	9804.0
2009-12-17	CT	Futures	61.97	62.1	61.15	61.75	10093.0
2009-12-17	DC	Futures	24.84	24.94	24.79	24.87	99.0
2009-12-17	DX	Futures	78.62	79.606	78.6	79.413	27815.0
2009-12-17	E1	Futures	1.27021	1.27073	1.25557	1.26058	56736.0
2009-12-17	E6	Futures	1.71991	1.72026	1.69315	1.69848	302014.0
2009-12-17	E7	Futures	1.7082	1.7083	1.6815	1.6867	4882.0
2009-12-17	EBM	Futures	224.78	224.78	222.66	222.66	3334.0
2009-12-17	ED	Futures	94.2731	94.311	94.2731	94.3063	208941.0
2009-12-17	ER	Futures	97.198	97.228	97.198	97.213	93899.0
2009-12-17	EW	Futures	695.4	696.2	687.3	692.3	25862.0
2009-12-17	FBTP	Futures	63.35	63.64	63.21	63.59	2740.0
2009-12-17	FCE	Futures	2522.1	2525.3	2492.7	2503.4	61368.0
2009-12-17	FDAX	Futures	6412.1	6444.9	6369.0	6405.6	69800.0
2009-12-17	FESX	Futures	1737.1	1744.9	1719.7	1731.7	1009402.0
2009-12-17	FEU3	Futures	97.776	97.786	97.776	97.776	453.0
2009-12-17	FGBL	Futures	94.61	95.26	94.6	95.15	592253.0
2009-12-17	FGBM	Futures	100.23	100.64	100.23	100.59	362527.0
2009-12-17	FGBS	Futures	105.377	105.523	105.367	105.503	372584.0
2009-12-17	FGBX	Futures	88.62	89.55	88.37	89.26	2124.0
2009-12-17	FTDX	Futures	721.7	726.1	712.8	722.1	2051.0
2009-12-17	FTI	Futures	266.27	268.51	265.25	266.55	16108.0
2009-12-17	FTUK	Futures	3515.0	3526.3	3451.7	3476.4	118253.0
2009-12-17	G	Futures	75.74	76.07	75.65	75.98	72486.0
2009-12-17	GF	Futures	251.847	255.17	251.847	254.898	3474.0
2009-12-17	GSCI	Futures	946.21	951.33	939.01	945.26	630.0
2009-12-17	HE	Futures	88.884	89.119	87.346	87.714	8518.0
2009-12-17	HG	Futures	4.4069	4.4207	4.298	4.3152	21000.0
2009-12-17	HO	Futures	1.8735	1.8735	1.8244	1.8518	12201.0
2009-12-17	HRC	Futures	2561.7	2561.7	2561.7	2561.7	0.0
2009-12-17	J1	Futures	0.014019	0.014058	0.0139309	0.0139976	99801.0
2009-12-17	J7	Futures	0.013818	0.013879	0.013759	0.013822	328.0
2009-12-17	JB	Futures	118.13	118.21	118.02	118.06	1390.0
2009-12-17	KC	Futures	384.45	385.75	377.16	380.55	9307.0
2009-12-17	KE	Futures	2396.89	2403.67	2303.05	2329.05	8952.0
2009-12-17	KRW	Futures	0.0008326	0.0008358	0.0008305	0.0008358	80.0

> showing 50 of 90 rows — these rows as CSV

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