PREVIEW / futures_1hour / 2018-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-18.parquet
  size:    14 KB
  rows:    259

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
2018-02-18 18:00:00	ES	Futures	2989.66	2996.77	2989.12	2995.95	6706.0
2018-02-18 19:00:00	ES	Futures	2995.95	3000.87	2994.86	3000.05	8638.0
2018-02-18 20:00:00	ES	Futures	3000.05	3000.6	2998.14	2999.78	3972.0
2018-02-18 21:00:00	ES	Futures	2999.78	3001.42	2999.5	3000.32	2014.0
2018-02-18 22:00:00	ES	Futures	3000.05	3002.24	3000.05	3001.14	1713.0
2018-02-18 23:00:00	ES	Futures	3001.14	3004.15	3001.14	3002.51	2378.0
2018-02-18 18:00:00	NQ	Futures	8047.49	8074.48	8046.31	8070.33	2592.0
2018-02-18 19:00:00	NQ	Futures	8070.03	8081.6	8065.29	8077.45	2981.0
2018-02-18 20:00:00	NQ	Futures	8078.04	8079.82	8074.19	8076.56	1011.0
2018-02-18 21:00:00	NQ	Futures	8076.85	8078.93	8073.3	8073.3	673.0
2018-02-18 22:00:00	NQ	Futures	8073.3	8079.52	8073.3	8076.26	1092.0
2018-02-18 23:00:00	NQ	Futures	8075.96	8088.42	8075.67	8086.35	2116.0
2018-02-18 18:00:00	YM	Futures	27419.8	27487.2	27414.4	27476.3	1497.0
2018-02-18 19:00:00	YM	Futures	27476.3	27505.7	27457.9	27500.2	2241.0
2018-02-18 20:00:00	YM	Futures	27501.3	27508.9	27481.8	27501.3	962.0
2018-02-18 21:00:00	YM	Futures	27501.3	27518.7	27499.2	27505.7	669.0
2018-02-18 22:00:00	YM	Futures	27505.7	27535.0	27504.6	27525.2	806.0
2018-02-18 23:00:00	YM	Futures	27524.2	27542.6	27517.6	27532.8	881.0
2018-02-18 18:00:00	CL	Futures	54.89	55.08	54.87	55.07	2622.0
2018-02-18 19:00:00	CL	Futures	55.07	55.54	55.01	55.5	9779.0
2018-02-18 20:00:00	CL	Futures	55.51	55.63	55.41	55.59	8322.0
2018-02-18 21:00:00	CL	Futures	55.6	55.62	55.46	55.51	7885.0
2018-02-18 22:00:00	CL	Futures	55.5	55.66	55.5	55.63	5139.0
2018-02-18 23:00:00	CL	Futures	55.63	55.67	55.61	55.64	3317.0
2018-02-18 18:00:00	GC	Futures	1786.7	1789.7	1786.5	1787.1	3559.0
2018-02-18 19:00:00	GC	Futures	1787.1	1790.6	1785.8	1789.9	5549.0
2018-02-18 20:00:00	GC	Futures	1789.8	1791.1	1788.9	1790.3	4832.0
2018-02-18 21:00:00	GC	Futures	1790.3	1791.8	1789.9	1790.2	2122.0
2018-02-18 22:00:00	GC	Futures	1790.3	1790.5	1787.5	1788.3	2840.0
2018-02-18 23:00:00	GC	Futures	1788.2	1788.7	1786.1	1786.7	3674.0
2018-02-18 18:00:00	ZN	Futures	120.307422	120.400974	120.307422	120.338606	14018.0
2018-02-18 19:00:00	ZN	Futures	120.338606	120.338606	120.323014	120.323014	3464.0
2018-02-18 20:00:00	ZN	Futures	120.323014	120.323014	120.276238	120.307422	4834.0
2018-02-18 21:00:00	ZN	Futures	120.307422	120.307422	120.276238	120.307422	1639.0
2018-02-18 22:00:00	ZN	Futures	120.29183	120.307422	120.276238	120.29183	4034.0
2018-02-18 23:00:00	ZN	Futures	120.29183	120.307422	120.276238	120.29183	1428.0

> showing 36 of 259 rows — these rows as CSV

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