PREVIEW / futures_1hour / 2019-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-16.parquet
  size:    16 KB
  rows:    337

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-06-16 18:00:00	ES	Futures	3134.76	3139.1	3134.76	3138.28	4157.0
2019-06-16 19:00:00	ES	Futures	3138.28	3142.07	3136.93	3139.64	4363.0
2019-06-16 20:00:00	ES	Futures	3139.91	3140.18	3136.93	3139.37	8161.0
2019-06-16 21:00:00	ES	Futures	3139.37	3145.32	3138.01	3144.24	15387.0
2019-06-16 22:00:00	ES	Futures	3144.51	3144.78	3142.62	3143.97	6589.0
2019-06-16 23:00:00	ES	Futures	3143.7	3144.24	3141.8	3142.89	4309.0
2019-06-16 18:00:00	NQ	Futures	8713.56	8730.1	8712.4	8726.03	1838.0
2019-06-16 19:00:00	NQ	Futures	8726.03	8739.38	8721.97	8733.58	1126.0
2019-06-16 20:00:00	NQ	Futures	8732.71	8733.58	8723.42	8730.1	2179.0
2019-06-16 21:00:00	NQ	Futures	8730.39	8752.44	8724.87	8749.54	4715.0
2019-06-16 22:00:00	NQ	Futures	8749.83	8750.7	8744.89	8750.41	2217.0
2019-06-16 23:00:00	NQ	Futures	8750.7	8751.86	8744.31	8747.79	1592.0
2019-06-16 18:00:00	YM	Futures	28415.3	28457.7	28402.2	28443.6	862.0
2019-06-16 19:00:00	YM	Futures	28444.7	28481.6	28438.1	28463.1	737.0
2019-06-16 20:00:00	YM	Futures	28462.1	28465.3	28439.2	28457.7	1121.0
2019-06-16 21:00:00	YM	Futures	28458.8	28512.1	28444.7	28503.4	2458.0
2019-06-16 22:00:00	YM	Futures	28504.5	28504.5	28481.6	28499.0	1150.0
2019-06-16 23:00:00	YM	Futures	28500.1	28502.3	28475.1	28489.2	793.0
2019-06-16 18:00:00	CL	Futures	46.77	47.02	46.6	46.93	2114.0
2019-06-16 19:00:00	CL	Futures	46.91	46.98	46.86	46.97	839.0
2019-06-16 20:00:00	CL	Futures	46.98	47.02	46.9	46.93	1122.0
2019-06-16 21:00:00	CL	Futures	46.93	47.0	46.83	46.98	2156.0
2019-06-16 22:00:00	CL	Futures	46.98	47.03	46.9	46.92	1318.0
2019-06-16 23:00:00	CL	Futures	46.92	47.0	46.9	46.92	921.0
2019-06-16 18:00:00	GC	Futures	1720.1	1721.0	1719.2	1719.2	1943.0
2019-06-16 19:00:00	GC	Futures	1719.2	1719.5	1715.9	1716.0	2942.0
2019-06-16 20:00:00	GC	Futures	1715.9	1717.5	1715.0	1716.4	6482.0
2019-06-16 21:00:00	GC	Futures	1716.4	1719.8	1712.8	1718.8	13619.0
2019-06-16 22:00:00	GC	Futures	1718.8	1720.0	1717.4	1719.3	6333.0
2019-06-16 23:00:00	GC	Futures	1719.5	1722.1	1718.9	1720.5	6089.0
2019-06-16 18:00:00	ZN	Futures	128.167035	128.167035	128.104154	128.119874	9370.0
2019-06-16 19:00:00	ZN	Futures	128.104154	128.135595	128.056993	128.072714	10905.0
2019-06-16 20:00:00	ZN	Futures	128.072714	128.088434	127.931232	127.978392	23431.0
2019-06-16 21:00:00	ZN	Futures	127.962672	127.994113	127.884071	127.946952	20026.0
2019-06-16 22:00:00	ZN	Futures	127.946952	127.962672	127.931232	127.946952	5551.0
2019-06-16 23:00:00	ZN	Futures	127.946952	127.962672	127.946952	127.962672	3609.0

> showing 36 of 337 rows — these rows as CSV

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