PREVIEW / futures_1hour / 2018-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-22.parquet
  size:    54 KB
  rows:    1,667

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-05-22 00:00:00	ES	Futures	2984.8	2985.61	2984.52	2984.8	1083.0
2018-05-22 01:00:00	ES	Futures	2985.07	2985.61	2984.52	2984.52	1619.0
2018-05-22 02:00:00	ES	Futures	2984.8	2986.16	2983.7	2985.89	5212.0
2018-05-22 03:00:00	ES	Futures	2985.89	2987.25	2984.52	2986.71	11504.0
2018-05-22 04:00:00	ES	Futures	2986.98	2988.62	2986.71	2988.07	6687.0
2018-05-22 05:00:00	ES	Futures	2988.34	2989.43	2987.8	2989.16	8021.0
2018-05-22 06:00:00	ES	Futures	2989.16	2989.98	2986.98	2989.71	9685.0
2018-05-22 07:00:00	ES	Futures	2989.43	2989.43	2987.52	2988.89	6868.0
2018-05-22 08:00:00	ES	Futures	2988.89	2989.98	2987.25	2988.07	11267.0
2018-05-22 09:00:00	ES	Futures	2988.07	2992.98	2987.25	2989.71	102757.0
2018-05-22 10:00:00	ES	Futures	2989.43	2992.16	2982.88	2985.07	166836.0
2018-05-22 11:00:00	ES	Futures	2985.07	2989.98	2985.07	2987.8	78597.0
2018-05-22 12:00:00	ES	Futures	2987.8	2989.16	2983.7	2985.34	64829.0
2018-05-22 13:00:00	ES	Futures	2985.61	2986.71	2983.43	2984.52	36201.0
2018-05-22 14:00:00	ES	Futures	2984.52	2988.34	2981.25	2981.25	63479.0
2018-05-22 15:00:00	ES	Futures	2981.25	2982.61	2970.88	2974.7	209695.0
2018-05-22 16:00:00	ES	Futures	2974.7	2977.15	2974.15	2975.24	46550.0
2018-05-22 18:00:00	ES	Futures	2974.15	2975.79	2973.88	2975.79	5090.0
2018-05-22 19:00:00	ES	Futures	2975.52	2975.79	2973.61	2974.15	2674.0
2018-05-22 20:00:00	ES	Futures	2974.15	2976.06	2972.51	2974.97	4486.0
2018-05-22 21:00:00	ES	Futures	2974.97	2975.24	2964.87	2967.88	15257.0
2018-05-22 22:00:00	ES	Futures	2967.88	2969.51	2966.51	2966.78	5282.0
2018-05-22 23:00:00	ES	Futures	2967.06	2968.42	2965.69	2967.88	4279.0
2018-05-22 00:00:00	NQ	Futures	8177.08	8180.33	8176.19	8176.78	485.0
2018-05-22 01:00:00	NQ	Futures	8176.78	8179.74	8175.6	8176.78	625.0
2018-05-22 02:00:00	NQ	Futures	8176.49	8182.1	8174.12	8180.92	1587.0
2018-05-22 03:00:00	NQ	Futures	8180.63	8183.28	8174.42	8182.4	2595.0
2018-05-22 04:00:00	NQ	Futures	8182.69	8195.11	8182.69	8193.33	2658.0
2018-05-22 05:00:00	NQ	Futures	8193.63	8204.56	8192.45	8203.97	3388.0
2018-05-22 06:00:00	NQ	Futures	8204.27	8212.54	8200.72	8212.25	4512.0
2018-05-22 07:00:00	NQ	Futures	8211.95	8212.84	8198.06	8201.9	4243.0
2018-05-22 08:00:00	NQ	Futures	8202.2	8206.63	8198.95	8200.13	3404.0
2018-05-22 09:00:00	NQ	Futures	8200.13	8221.41	8192.74	8199.24	40814.0
2018-05-22 10:00:00	NQ	Futures	8198.95	8201.61	8163.48	8176.78	62391.0
2018-05-22 11:00:00	NQ	Futures	8176.49	8188.9	8166.44	8176.19	26034.0
2018-05-22 12:00:00	NQ	Futures	8176.19	8184.47	8156.98	8169.1	24607.0
2018-05-22 13:00:00	NQ	Futures	8168.8	8181.81	8165.85	8177.97	15670.0
2018-05-22 14:00:00	NQ	Futures	8177.97	8193.92	8174.71	8175.6	20185.0
2018-05-22 15:00:00	NQ	Futures	8175.31	8182.4	8144.87	8159.64	39999.0
2018-05-22 16:00:00	NQ	Futures	8159.64	8172.35	8158.76	8166.74	6316.0
2018-05-22 18:00:00	NQ	Futures	8163.19	8166.44	8157.87	8166.14	1340.0
2018-05-22 19:00:00	NQ	Futures	8165.55	8165.55	8155.8	8158.46	1231.0
2018-05-22 20:00:00	NQ	Futures	8158.46	8163.19	8151.07	8158.46	4404.0
2018-05-22 21:00:00	NQ	Futures	8158.46	8159.64	8127.43	8129.79	5779.0
2018-05-22 22:00:00	NQ	Futures	8129.5	8136.0	8123.88	8125.66	2979.0
2018-05-22 23:00:00	NQ	Futures	8125.07	8127.72	8118.27	8124.47	2578.0
2018-05-22 00:00:00	YM	Futures	27183.2	27198.4	27183.2	27188.6	885.0
2018-05-22 01:00:00	YM	Futures	27187.5	27196.2	27184.2	27186.4	709.0
2018-05-22 02:00:00	YM	Futures	27186.4	27214.7	27177.7	27203.8	3343.0
2018-05-22 03:00:00	YM	Futures	27202.7	27208.1	27188.6	27203.8	2939.0

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

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