PREVIEW / futures_daily / 2018-01-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-31.parquet
  size:    10 KB
  rows:    111

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
2018-01-31	ES	Futures	3068.53	3086.46	3057.39	3071.25	1841227.0
2018-01-31	NQ	Futures	8125.94	8187.72	8106.32	8154.34	413798.0
2018-01-31	YM	Futures	27467.2	27746.7	27447.2	27563.2	243904.0
2018-01-31	CL	Futures	64.01	64.92	63.65	64.71	613258.0
2018-01-31	GC	Futures	1713.9	1725.7	1705.9	1715.6	377142.0
2018-01-31	ZN	Futures	120.108615	120.309156	119.784665	120.031484	2439319.0
2018-01-31	A6	Futures	0.83145	0.83484	0.82641	0.82795	162301.0
2018-01-31	AD	Futures	0.82341	0.8293	0.82265	0.82569	103444.0
2018-01-31	B	Futures	48.79	49.51	48.66	49.43	290975.0
2018-01-31	B6	Futures	1.4742	1.4828	1.4712	1.4769	178846.0
2018-01-31	BR	Futures	0.23867	0.24057	0.2367	0.2375	3326.0
2018-01-31	BTC	Futures	13012.3	13370.2	12361.7	13012.3	842.0
2018-01-31	BZ	Futures	48.18	48.85	48.01	48.79	26008.0
2018-01-31	C	Futures	1263.0	1285.0	1263.0	1280.0	15317.0
2018-01-31	CB	Futures	268.831	269.325	268.584	268.584	20.0
2018-01-31	CC	Futures	1476.0	1501.0	1473.0	1489.0	30072.0
2018-01-31	CNH	Futures	6.4631	6.4631	6.43	6.4369	50.0
2018-01-31	CSC	Futures	3.122	3.163	3.118	3.163	105.0
2018-01-31	CT	Futures	90.21	91.33	89.37	90.26	38453.0
2018-01-31	DC	Futures	24.7	25.13	24.7	25.11	235.0
2018-01-31	DX	Futures	83.533	83.707	83.218	83.537	29179.0
2018-01-31	E1	Futures	1.30351	1.31127	1.30156	1.30812	36096.0
2018-01-31	E6	Futures	1.41011	1.41833	1.4083	1.41113	303231.0
2018-01-31	E7	Futures	1.4032	1.4112	1.4014	1.4041	5980.0
2018-01-31	EBM	Futures	172.62	172.89	170.46	170.73	27707.0
2018-01-31	ED	Futures	95.3019	95.3019	95.2873	95.2922	311467.0
2018-01-31	ER	Futures	98.337	98.337	98.332	98.337	40190.0
2018-01-31	EW	Futures	2078.3	2092.8	2065.1	2072.2	19419.0
2018-01-31	FBON	Futures	127.04	127.13	126.72	126.75	399.0
2018-01-31	FBTP	Futures	111.11	111.3	110.94	111.07	110367.0
2018-01-31	FBTS	Futures	103.54	103.604	103.54	103.586	47320.0
2018-01-31	FCE	Futures	4881.7	4900.4	4876.4	4886.6	68864.0
2018-01-31	FDAX	Futures	13694.7	13762.1	13648.0	13675.5	78334.0
2018-01-31	FDXM	Futures	13723.1	13785.4	13670.1	13698.7	22739.0
2018-01-31	FESX	Futures	2944.2	2952.4	2935.2	2940.9	972171.0
2018-01-31	FEU3	Futures	99.011	99.011	99.006	99.011	325.0
2018-01-31	FGBL	Futures	147.32	147.67	146.9	147.19	917380.0
2018-01-31	FGBM	Futures	128.28	128.38	128.14	128.23	672553.0
2018-01-31	FGBS	Futures	112.216	112.241	112.201	112.211	354506.0
2018-01-31	FGBX	Futures	165.62	167.36	165.62	166.4	97363.0
2018-01-31	FMWO	Futures	7327.3	7337.8	7297.0	7299.3	2019.0
2018-01-31	FOAT	Futures	136.25	136.46	136.02	136.1	142147.0
2018-01-31	FTDX	Futures	2614.2	2657.1	2614.2	2637.1	178.0
2018-01-31	FTI	Futures	519.45	520.84	518.1	519.4	22597.0
2018-01-31	FTUK	Futures	6569.8	6595.6	6520.4	6523.5	121190.0
2018-01-31	FVSA	Futures	273.58	276.16	260.67	272.72	33609.0
2018-01-31	FXXP	Futures	337.2	337.7	335.4	335.8	31800.0
2018-01-31	G	Futures	112.93	113.02	112.39	112.64	265087.0
2018-01-31	GF	Futures	321.709	323.686	317.866	318.525	5243.0
2018-01-31	GSCI	Futures	525.54	527.91	525.37	527.16	97.0

> showing 50 of 111 rows — these rows as CSV

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