PREVIEW / futures_daily / 2020-03-27

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-27.parquet
  size:    10 KB
  rows:    118

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
2020-03-27	ES	Futures	2907.57	2915.04	2772.02	2792.77	2320755.0
2020-03-27	NQ	Futures	9037.1	9049.14	8657.05	8676.83	443315.0
2020-03-27	YM	Futures	24030.0	24056.7	22745.3	22874.4	258114.0
2020-03-27	CL	Futures	23.08	23.23	20.69	21.32	603124.0
2020-03-27	GC	Futures	2005.1	2014.3	1977.6	2006.0	159263.0
2020-03-27	ZN	Futures	135.725435	137.068335	135.679129	136.58983	1247294.0
2020-03-27	A6	Futures	0.62124	0.63717	0.61888	0.63624	97501.0
2020-03-27	AD	Futures	0.72217	0.72845	0.71629	0.72723	82284.0
2020-03-27	ALI	Futures	1883.55	1883.55	1883.55	1883.55	5.0
2020-03-27	B	Futures	22.26	22.47	20.82	21.41	329043.0
2020-03-27	B6	Futures	1.2364	1.2695	1.2333	1.2689	112472.0
2020-03-27	BR	Futures	0.1614	0.1614	0.1598	0.16128	66.0
2020-03-27	BTC	Futures	9589.0	9808.9	9383.4	9475.6	2372.0
2020-03-27	BZ	Futures	21.85	21.85	20.21	20.77	34510.0
2020-03-27	C	Futures	1669.0	1669.0	1642.0	1647.0	4684.0
2020-03-27	CB	Futures	178.452	178.452	173.712	173.712	42.0
2020-03-27	CC	Futures	1475.0	1485.0	1460.0	1478.0	13400.0
2020-03-27	CNH	Futures	7.0121	7.0461	6.9994	7.0179	508.0
2020-03-27	CSC	Futures	2.903	2.903	2.772	2.785	197.0
2020-03-27	CT	Futures	50.82	51.34	49.25	49.42	14026.0
2020-03-27	DC	Futures	23.35	23.39	22.23	22.27	604.0
2020-03-27	DX	Futures	96.146	96.717	95.097	95.283	15805.0
2020-03-27	E1	Futures	1.18693	1.20276	1.18431	1.19968	40028.0
2020-03-27	E6	Futures	1.18977	1.2024	1.18128	1.19912	198780.0
2020-03-27	E7	Futures	1.1837	1.1961	1.1751	1.1928	11182.0
2020-03-27	EBM	Futures	218.09	221.17	217.53	218.37	23151.0
2020-03-27	ED	Futures	96.1309	96.1454	96.0826	96.0826	364178.0
2020-03-27	ER	Futures	98.313	98.333	98.308	98.313	93627.0
2020-03-27	EW	Futures	1546.6	1547.1	1470.0	1496.8	10368.0
2020-03-27	FBON	Futures	143.16	143.34	142.79	142.79	460.0
2020-03-27	FBTP	Futures	129.56	130.18	128.12	128.47	92596.0
2020-03-27	FBTS	Futures	108.028	108.22	107.691	107.816	48630.0
2020-03-27	FCE	Futures	4358.7	4362.0	4143.2	4206.6	66737.0
2020-03-27	FDAX	Futures	10624.6	10624.6	10052.4	10132.2	91007.0
2020-03-27	FDIV	Futures	108.56	108.56	108.05	108.05	50.0
2020-03-27	FDXM	Futures	10669.5	10670.5	10103.1	10180.6	100956.0
2020-03-27	FESX	Futures	2568.1	2568.1	2413.0	2435.9	1676986.0
2020-03-27	FEU3	Futures	99.055	99.055	99.055	99.055	50.0
2020-03-27	FGBL	Futures	166.17	168.23	166.12	167.74	560936.0
2020-03-27	FGBM	Futures	134.05	134.71	133.95	134.53	309338.0
2020-03-27	FGBS	Futures	112.78	112.915	112.749	112.87	248288.0
2020-03-27	FGBX	Futures	218.83	226.97	218.8	225.0	47006.0
2020-03-27	FMWO	Futures	6415.1	6475.1	6246.9	6310.4	11537.0
2020-03-27	FOAT	Futures	152.69	153.72	152.27	153.16	120625.0
2020-03-27	FTDX	Futures	2571.5	2571.5	2514.9	2514.9	91.0
2020-03-27	FTI	Futures	447.82	447.82	427.98	434.84	47699.0
2020-03-27	FTUK	Futures	5375.4	5396.6	5066.5	5154.7	165504.0
2020-03-27	FVSA	Futures	392.04	443.35	386.63	433.89	17363.0
2020-03-27	FXXP	Futures	289.5	289.5	278.8	282.4	117592.0
2020-03-27	G	Futures	124.71	125.24	124.37	124.84	120465.0

> showing 50 of 118 rows — these rows as CSV

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