PREVIEW / futures_daily / 2021-07-20

all futures daily files

  file:    by_date/futures_daily/2021/2021-07-20.parquet
  size:    10 KB
  rows:    123

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
2021-07-20	ES	Futures	4791.65	4866.12	4780.4	4850.94	1844380.0
2021-07-20	NQ	Futures	16836.62	17054.38	16747.79	16985.45	529359.0
2021-07-20	YM	Futures	36777.9	37411.2	36696.6	37300.6	222415.0
2021-07-20	CL	Futures	48.21	48.93	47.05	48.64	561629.0
2021-07-20	GC	Futures	2121.1	2135.6	2111.4	2118.7	221136.0
2021-07-20	ZN	Futures	136.223822	136.856391	136.065679	136.302893	2194456.0
2021-07-20	A6	Futures	0.75352	0.75464	0.74875	0.75188	81383.0
2021-07-20	AD	Futures	0.79527	0.79984	0.79284	0.79862	106210.0
2021-07-20	ALI	Futures	2806.78	2847.91	2798.5	2844.77	2953.0
2021-07-20	B	Futures	45.55	46.04	44.53	45.79	316477.0
2021-07-20	B6	Futures	1.3882	1.39	1.3782	1.3836	132652.0
2021-07-20	BR	Futures	0.15206	0.15286	0.15038	0.15278	2602.0
2021-07-20	BTC	Futures	43707.0	44184.3	41620.0	42332.3	4343.0
2021-07-20	BZ	Futures	44.38	45.0	43.51	44.76	43067.0
2021-07-20	C	Futures	1377.0	1380.0	1366.0	1373.0	6788.0
2021-07-20	CB	Futures	138.82	139.201	138.8	138.86	9.0
2021-07-20	CC	Futures	1473.0	1482.0	1464.0	1480.0	17429.0
2021-07-20	CNH	Futures	6.2931	6.2931	6.2793	6.2832	274.0
2021-07-20	CSC	Futures	2.498	2.5	2.437	2.443	187.0
2021-07-20	CT	Futures	81.27	82.63	80.99	82.19	15.0
2021-07-20	DC	Futures	22.54	22.66	21.96	22.02	450.0
2021-07-20	DX	Futures	89.772	90.067	89.704	89.872	17810.0
2021-07-20	E1	Futures	1.22504	1.22583	1.21786	1.22078	19778.0
2021-07-20	E6	Futures	1.256	1.25674	1.25174	1.25456	171809.0
2021-07-20	E7	Futures	1.2501	1.2503	1.2455	1.2483	4519.0
2021-07-20	EBM	Futures	319.96	320.7	316.65	317.02	13347.0
2021-07-20	ED	Futures	96.5393	96.5393	96.5152	96.5248	382772.0
2021-07-20	ER	Futures	98.465	98.465	98.45	98.455	106940.0
2021-07-20	ESG	Futures	398.17	402.58	396.52	401.54	341.0
2021-07-20	EW	Futures	2765.1	2849.0	2756.3	2835.0	15059.0
2021-07-20	FBON	Futures	150.01	150.34	150.01	150.15	647.0
2021-07-20	FBTP	Futures	140.01	140.29	139.95	140.16	101166.0
2021-07-20	FBTS	Futures	110.263	110.302	110.234	110.273	73884.0
2021-07-20	FCE	Futures	6293.3	6370.1	6285.8	6329.7	72648.0
2021-07-20	FDAX	Futures	16215.3	16376.0	16151.0	16293.5	95948.0
2021-07-20	FDIV	Futures	181.18	181.91	180.49	181.86	62.0
2021-07-20	FDXM	Futures	16121.0	16303.2	16070.9	16212.6	59669.0
2021-07-20	FDXS	Futures	16023.9	16190.1	15969.8	16109.6	12978.0
2021-07-20	FESX	Futures	3723.8	3765.0	3708.6	3744.1	987422.0
2021-07-20	FGBL	Futures	169.99	170.76	169.92	170.34	912579.0
2021-07-20	FGBM	Futures	135.3	135.6	135.3	135.5	485300.0
2021-07-20	FGBS	Futures	112.639	112.709	112.634	112.694	418230.0
2021-07-20	FGBX	Futures	226.85	230.03	226.53	228.41	164022.0
2021-07-20	FMWO	Futures	10531.9	10648.2	10481.4	10595.3	2797.0
2021-07-20	FOAT	Futures	157.27	157.76	157.19	157.48	201012.0
2021-07-20	FTDX	Futures	3662.9	3676.3	3650.1	3658.3	41.0
2021-07-20	FTI	Futures	688.45	693.62	683.14	688.06	24358.0
2021-07-20	FTUK	Futures	6679.6	6753.9	6650.5	6709.1	160454.0
2021-07-20	FVSA	Futures	96.55	99.72	90.85	94.65	56128.0
2021-07-20	FXXP	Futures	421.3	426.1	420.5	423.4	78413.0

> showing 50 of 123 rows — these rows as CSV

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