PREVIEW / futures_daily / 2019-03-21

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-21.parquet
  size:    10 KB
  rows:    116

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
2019-03-21	ES	Futures	3050.14	3095.78	3039.34	3092.0	1657949.0
2019-03-21	NQ	Futures	8526.89	8688.78	8489.16	8681.29	523249.0
2019-03-21	YM	Futures	27129.9	27490.9	27030.7	27456.1	227962.0
2019-03-21	CL	Futures	61.6	62.01	61.26	61.59	655380.0
2019-03-21	GC	Futures	1640.9	1650.2	1628.5	1634.1	332611.0
2019-03-21	ZN	Futures	122.761893	123.010525	122.606499	122.684196	1563387.0
2019-03-21	A6	Futures	0.7358	0.74003	0.73188	0.73353	132236.0
2019-03-21	AD	Futures	0.76166	0.76318	0.7561	0.75736	76027.0
2019-03-21	B	Futures	49.6	49.82	49.03	49.22	303229.0
2019-03-21	B6	Futures	1.3573	1.3607	1.3378	1.3449	175764.0
2019-03-21	BR	Futures	0.21029	0.21029	0.20777	0.20977	702.0
2019-03-21	BTC	Futures	6172.4	6241.6	5995.6	6095.6	3769.0
2019-03-21	BZ	Futures	49.16	49.43	48.65	48.83	35417.0
2019-03-21	C	Futures	1438.0	1443.0	1432.0	1441.0	9309.0
2019-03-21	CB	Futures	279.082	279.889	279.082	279.62	32.0
2019-03-21	CC	Futures	1446.0	1455.0	1426.0	1439.0	16532.0
2019-03-21	CNH	Futures	6.6917	6.7253	6.6826	6.723	927.0
2019-03-21	CSC	Futures	2.849	2.864	2.847	2.854	99.0
2019-03-21	CT	Futures	80.36	82.62	80.02	81.94	24839.0
2019-03-21	DC	Futures	23.88	24.15	23.88	24.05	256.0
2019-03-21	DX	Futures	91.423	92.137	91.342	92.005	28794.0
2019-03-21	E1	Futures	1.18675	1.1878	1.18278	1.18383	32192.0
2019-03-21	E6	Futures	1.26312	1.26444	1.2539	1.25506	227581.0
2019-03-21	E7	Futures	1.2568	1.258	1.2478	1.2489	5442.0
2019-03-21	EBM	Futures	200.31	200.84	198.45	200.04	12263.0
2019-03-21	ED	Futures	95.1209	95.1257	95.1111	95.116	226786.0
2019-03-21	ER	Futures	98.401	98.406	98.401	98.406	56083.0
2019-03-21	EW	Futures	1998.7	2037.0	1992.2	2030.5	19726.0
2019-03-21	FBON	Futures	134.23	134.89	134.23	134.87	717.0
2019-03-21	FBTP	Futures	114.52	115.22	114.52	115.1	61620.0
2019-03-21	FBTS	Futures	105.836	105.989	105.836	105.922	41781.0
2019-03-21	FCE	Futures	4794.8	4806.9	4757.9	4785.0	80457.0
2019-03-21	FDAX	Futures	12210.6	12265.3	12086.4	12180.6	123358.0
2019-03-21	FDIV	Futures	142.66	142.66	142.43	142.43	70.0
2019-03-21	FDXM	Futures	12102.7	12158.0	11981.6	12075.0	64148.0
2019-03-21	FESX	Futures	2878.0	2885.0	2855.3	2874.5	1170205.0
2019-03-21	FGBL	Futures	158.66	159.18	158.59	159.1	725539.0
2019-03-21	FGBM	Futures	132.49	132.66	132.47	132.62	503807.0
2019-03-21	FGBS	Futures	112.658	112.703	112.648	112.693	460091.0
2019-03-21	FGBX	Futures	189.87	192.04	189.81	191.75	44436.0
2019-03-21	FMWO	Futures	7108.5	7146.7	7058.8	7116.6	1502.0
2019-03-21	FOAT	Futures	145.57	146.23	145.56	146.21	213738.0
2019-03-21	FTDX	Futures	2641.0	2641.0	2610.4	2635.1	657.0
2019-03-21	FTI	Futures	511.46	516.52	510.89	514.27	23295.0
2019-03-21	FTUK	Futures	6639.0	6689.9	6618.3	6681.2	113037.0
2019-03-21	FVSA	Futures	241.12	259.86	239.5	247.64	45732.0
2019-03-21	FXXP	Futures	333.8	335.1	332.1	334.0	44859.0
2019-03-21	G	Futures	118.11	118.74	118.01	118.68	274933.0
2019-03-21	GF	Futures	317.577	320.785	317.363	318.486	3285.0
2019-03-21	GSCI	Futures	496.9	497.47	495.66	496.79	33.0

> showing 50 of 116 rows — these rows as CSV

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