PREVIEW / futures_daily / 2020-04-09

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-09.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-04-09	ES	Futures	3029.28	3108.67	2988.62	3075.75	2342733.0
2020-04-09	NQ	Futures	9395.36	9545.54	9288.17	9432.33	522648.0
2020-04-09	YM	Futures	24860.2	25490.8	24563.6	25201.7	262866.0
2020-04-09	CL	Futures	26.05	28.11	22.37	22.56	1122149.0
2020-04-09	GC	Futures	2038.0	2127.7	2033.1	2125.7	218804.0
2020-04-09	ZN	Futures	136.09589	136.713315	135.987841	136.574395	1195287.0
2020-04-09	A6	Futures	0.64056	0.65391	0.63655	0.64816	72717.0
2020-04-09	AD	Futures	0.72333	0.7282	0.72055	0.72612	72905.0
2020-04-09	ALI	Futures	1791.32	1797.39	1791.32	1796.17	12.0
2020-04-09	B	Futures	25.91	27.88	23.88	24.11	492998.0
2020-04-09	B6	Futures	1.2586	1.2679	1.2554	1.2643	62450.0
2020-04-09	BR	Futures	0.15976	0.16148	0.15923	0.16132	75.0
2020-04-09	BTC	Futures	10404.7	10518.2	10057.2	10340.9	2793.0
2020-04-09	BZ	Futures	25.01	27.07	23.21	23.39	48214.0
2020-04-09	C	Futures	1747.0	1755.0	1710.0	1719.0	2861.0
2020-04-09	CB	Futures	163.116	163.116	158.655	159.77	28.0
2020-04-09	CC	Futures	1554.0	1560.0	1506.0	1510.0	20107.0
2020-04-09	CNH	Futures	7.0028	7.0149	6.981	6.9858	449.0
2020-04-09	CSC	Futures	2.58	2.604	2.538	2.547	170.0
2020-04-09	CT	Futures	51.63	52.47	51.09	52.35	19155.0
2020-04-09	DC	Futures	21.02	21.02	20.31	20.39	410.0
2020-04-09	DX	Futures	96.891	97.031	96.03	96.218	16145.0
2020-04-09	E1	Futures	1.1744	1.18306	1.17292	1.18123	18207.0
2020-04-09	E6	Futures	1.16919	1.17918	1.16736	1.17746	167526.0
2020-04-09	E7	Futures	1.163	1.1731	1.1612	1.1714	6256.0
2020-04-09	EBM	Futures	220.89	223.41	220.89	221.73	19248.0
2020-04-09	ED	Futures	96.0681	96.1696	96.0487	96.1502	573999.0
2020-04-09	ER	Futures	98.142	98.225	98.122	98.22	247473.0
2020-04-09	ESG	Futures	250.56	250.56	250.56	250.56	30.0
2020-04-09	EW	Futures	1618.3	1705.4	1597.6	1676.2	11677.0
2020-04-09	FBON	Futures	138.94	139.94	138.94	139.83	197.0
2020-04-09	FBTP	Futures	124.47	126.1	124.02	125.52	108830.0
2020-04-09	FBTS	Futures	106.566	107.037	106.441	106.874	72772.0
2020-04-09	FCE	Futures	4319.4	4416.3	4267.1	4364.0	61653.0
2020-04-09	FDAX	Futures	11023.3	11314.7	10887.9	11159.2	105050.0
2020-04-09	FDXM	Futures	11083.9	11367.7	10940.5	11212.5	105574.0
2020-04-09	FESX	Futures	2603.9	2657.1	2565.3	2620.4	1764646.0
2020-04-09	FEU3	Futures	98.873	98.952	98.873	98.952	100.0
2020-04-09	FGBL	Futures	165.36	166.31	165.26	166.12	455321.0
2020-04-09	FGBM	Futures	133.76	134.11	133.74	134.06	235525.0
2020-04-09	FGBS	Futures	112.689	112.769	112.659	112.749	194510.0
2020-04-09	FGBX	Futures	219.31	222.69	219.29	221.39	38532.0
2020-04-09	FMWO	Futures	6769.2	6895.1	6658.6	6842.1	6576.0
2020-04-09	FOAT	Futures	150.21	151.19	149.85	150.97	85563.0
2020-04-09	FTDX	Futures	2825.3	2850.1	2789.4	2824.3	89.0
2020-04-09	FTI	Futures	470.18	475.94	464.65	472.47	564.0
2020-04-09	FTUK	Futures	5376.3	5541.8	5343.8	5487.6	147576.0
2020-04-09	FVSA	Futures	331.72	342.97	320.92	333.07	14410.0
2020-04-09	FXXP	Futures	303.6	308.5	300.0	305.0	58519.0
2020-04-09	G	Futures	124.59	125.43	124.51	125.22	174565.0

> showing 50 of 118 rows — these rows as CSV

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