PREVIEW / futures_1hour / 2019-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-27.parquet
  size:    16 KB
  rows:    345

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-01-27 18:00:00	ES	Futures	2889.66	2893.46	2887.22	2888.3	8627.0
2019-01-27 19:00:00	ES	Futures	2888.3	2890.75	2885.59	2887.49	10950.0
2019-01-27 20:00:00	ES	Futures	2887.22	2890.2	2883.14	2888.57	14300.0
2019-01-27 21:00:00	ES	Futures	2888.85	2889.12	2884.5	2885.31	6039.0
2019-01-27 22:00:00	ES	Futures	2885.04	2886.94	2883.68	2886.67	5755.0
2019-01-27 23:00:00	ES	Futures	2886.67	2888.85	2885.59	2888.57	3457.0
2019-01-27 18:00:00	NQ	Futures	7929.14	7937.03	7916.29	7917.75	4209.0
2019-01-27 19:00:00	NQ	Futures	7917.75	7930.31	7910.73	7918.04	6425.0
2019-01-27 20:00:00	NQ	Futures	7918.04	7927.1	7905.47	7922.13	6369.0
2019-01-27 21:00:00	NQ	Futures	7922.13	7923.3	7908.4	7910.44	3279.0
2019-01-27 22:00:00	NQ	Futures	7910.15	7914.82	7903.72	7913.07	2675.0
2019-01-27 23:00:00	NQ	Futures	7912.78	7919.5	7910.15	7918.92	1609.0
2019-01-27 18:00:00	YM	Futures	26779.0	26830.0	26765.9	26775.7	2003.0
2019-01-27 19:00:00	YM	Futures	26773.5	26801.8	26751.8	26771.4	2664.0
2019-01-27 20:00:00	YM	Futures	26771.4	26801.8	26732.3	26787.6	3784.0
2019-01-27 21:00:00	YM	Futures	26788.7	26795.2	26749.6	26755.1	2741.0
2019-01-27 22:00:00	YM	Futures	26754.0	26777.9	26739.9	26774.6	1551.0
2019-01-27 23:00:00	YM	Futures	26773.5	26786.6	26764.8	26784.4	1267.0
2019-01-27 18:00:00	CL	Futures	48.61	48.68	48.33	48.34	4628.0
2019-01-27 19:00:00	CL	Futures	48.35	48.49	48.28	48.44	3886.0
2019-01-27 20:00:00	CL	Futures	48.44	48.67	48.34	48.61	10200.0
2019-01-27 21:00:00	CL	Futures	48.62	48.65	48.47	48.48	5174.0
2019-01-27 22:00:00	CL	Futures	48.47	48.48	48.37	48.4	4128.0
2019-01-27 23:00:00	CL	Futures	48.4	48.46	48.39	48.42	1646.0
2019-01-27 18:00:00	GC	Futures	1687.3	1687.4	1683.2	1683.6	1422.0
2019-01-27 19:00:00	GC	Futures	1683.6	1685.6	1682.5	1684.9	1231.0
2019-01-27 20:00:00	GC	Futures	1685.0	1686.7	1684.5	1685.4	1897.0
2019-01-27 21:00:00	GC	Futures	1685.4	1687.2	1685.0	1687.2	1464.0
2019-01-27 22:00:00	GC	Futures	1687.1	1687.4	1686.3	1686.8	913.0
2019-01-27 23:00:00	GC	Futures	1686.7	1687.3	1686.4	1687.3	684.0
2019-01-27 18:00:00	ZN	Futures	122.242282	122.289504	122.226541	122.258023	10350.0
2019-01-27 19:00:00	ZN	Futures	122.273763	122.336726	122.258023	122.320985	23471.0
2019-01-27 20:00:00	ZN	Futures	122.320985	122.336726	122.258023	122.273763	15513.0
2019-01-27 21:00:00	ZN	Futures	122.273763	122.336726	122.258023	122.336726	8883.0
2019-01-27 22:00:00	ZN	Futures	122.336726	122.352467	122.305245	122.336726	8756.0
2019-01-27 23:00:00	ZN	Futures	122.336726	122.336726	122.305245	122.336726	5843.0

> showing 36 of 345 rows — these rows as CSV

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