PREVIEW / futures_1hour / 2018-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-18.parquet
  size:    54 KB
  rows:    1,679

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-04-18 00:00:00	ES	Futures	2960.23	2960.78	2959.96	2960.51	1355.0
2018-04-18 01:00:00	ES	Futures	2960.51	2962.96	2959.96	2960.23	5637.0
2018-04-18 02:00:00	ES	Futures	2960.23	2961.05	2956.96	2956.96	5001.0
2018-04-18 03:00:00	ES	Futures	2956.96	2960.78	2956.69	2959.96	9197.0
2018-04-18 04:00:00	ES	Futures	2959.96	2962.96	2959.69	2961.05	14321.0
2018-04-18 05:00:00	ES	Futures	2961.05	2962.42	2958.32	2959.41	9363.0
2018-04-18 06:00:00	ES	Futures	2959.41	2963.24	2957.78	2963.24	14295.0
2018-04-18 07:00:00	ES	Futures	2962.96	2967.6	2962.96	2967.33	25673.0
2018-04-18 08:00:00	ES	Futures	2967.33	2967.6	2963.51	2964.05	29352.0
2018-04-18 09:00:00	ES	Futures	2964.33	2965.15	2957.78	2960.51	163502.0
2018-04-18 10:00:00	ES	Futures	2960.51	2963.78	2951.5	2963.24	190403.0
2018-04-18 11:00:00	ES	Futures	2963.24	2967.06	2961.05	2961.05	109259.0
2018-04-18 12:00:00	ES	Futures	2961.33	2965.42	2959.41	2962.96	77231.0
2018-04-18 13:00:00	ES	Futures	2962.96	2965.69	2958.87	2959.41	68817.0
2018-04-18 14:00:00	ES	Futures	2959.14	2965.96	2956.69	2962.69	85060.0
2018-04-18 15:00:00	ES	Futures	2962.69	2965.42	2956.41	2956.96	132751.0
2018-04-18 16:00:00	ES	Futures	2956.96	2959.41	2956.14	2958.87	50410.0
2018-04-18 18:00:00	ES	Futures	2960.23	2961.05	2959.14	2959.96	4981.0
2018-04-18 19:00:00	ES	Futures	2959.96	2961.6	2959.69	2961.33	2804.0
2018-04-18 20:00:00	ES	Futures	2961.33	2961.87	2960.51	2961.6	4428.0
2018-04-18 21:00:00	ES	Futures	2961.6	2961.87	2958.87	2960.23	4832.0
2018-04-18 22:00:00	ES	Futures	2960.23	2961.05	2959.69	2960.78	3163.0
2018-04-18 23:00:00	ES	Futures	2960.78	2961.6	2959.96	2961.05	2066.0
2018-04-18 00:00:00	NQ	Futures	8085.17	8087.83	8083.4	8086.35	708.0
2018-04-18 01:00:00	NQ	Futures	8086.05	8094.63	8085.17	8089.6	1823.0
2018-04-18 02:00:00	NQ	Futures	8089.9	8093.44	8080.74	8080.74	1849.0
2018-04-18 03:00:00	NQ	Futures	8081.03	8094.92	8079.26	8090.78	2334.0
2018-04-18 04:00:00	NQ	Futures	8090.78	8101.72	8090.49	8096.1	3711.0
2018-04-18 05:00:00	NQ	Futures	8095.51	8099.65	8086.35	8088.42	2525.0
2018-04-18 06:00:00	NQ	Futures	8088.42	8096.1	8080.74	8095.81	3092.0
2018-04-18 07:00:00	NQ	Futures	8095.51	8107.33	8094.63	8102.01	5106.0
2018-04-18 08:00:00	NQ	Futures	8101.72	8103.2	8089.01	8091.97	4347.0
2018-04-18 09:00:00	NQ	Futures	8091.67	8092.85	8054.43	8066.85	56987.0
2018-04-18 10:00:00	NQ	Futures	8067.14	8084.58	8034.63	8083.4	66153.0
2018-04-18 11:00:00	NQ	Futures	8083.4	8100.83	8080.44	8086.94	31860.0
2018-04-18 12:00:00	NQ	Futures	8086.94	8106.74	8086.94	8101.42	23326.0
2018-04-18 13:00:00	NQ	Futures	8101.13	8109.11	8086.94	8088.71	19402.0
2018-04-18 14:00:00	NQ	Futures	8088.42	8117.68	8080.44	8103.49	28176.0
2018-04-18 15:00:00	NQ	Futures	8103.79	8114.72	8087.53	8088.71	27918.0
2018-04-18 16:00:00	NQ	Futures	8088.71	8094.33	8085.76	8093.74	5786.0
2018-04-18 18:00:00	NQ	Futures	8103.79	8110.58	8101.13	8105.56	1925.0
2018-04-18 19:00:00	NQ	Futures	8105.86	8113.83	8104.97	8112.95	1429.0
2018-04-18 20:00:00	NQ	Futures	8112.65	8115.31	8110.58	8113.54	1513.0
2018-04-18 21:00:00	NQ	Futures	8112.95	8115.02	8105.56	8112.06	1875.0
2018-04-18 22:00:00	NQ	Futures	8112.36	8114.72	8109.99	8112.65	1143.0
2018-04-18 23:00:00	NQ	Futures	8112.95	8116.79	8109.99	8111.47	1294.0
2018-04-18 00:00:00	YM	Futures	26913.8	26914.9	26901.9	26903.0	486.0
2018-04-18 01:00:00	YM	Futures	26904.1	26926.9	26883.4	26884.5	2698.0
2018-04-18 02:00:00	YM	Futures	26885.6	26895.4	26854.1	26859.5	1763.0
2018-04-18 03:00:00	YM	Futures	26858.4	26896.5	26854.1	26885.6	2062.0

> showing 50 of 1,679 rows — these rows as CSV

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