PREVIEW / futures_1hour / 2018-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-16.parquet
  size:    55 KB
  rows:    1,683

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-16 00:00:00	ES	Futures	2959.69	2960.51	2958.32	2958.6	2196.0
2018-05-16 01:00:00	ES	Futures	2958.6	2960.51	2957.23	2959.41	3208.0
2018-05-16 02:00:00	ES	Futures	2959.69	2959.69	2955.05	2957.5	8224.0
2018-05-16 03:00:00	ES	Futures	2957.5	2963.51	2957.5	2962.69	15213.0
2018-05-16 04:00:00	ES	Futures	2962.42	2962.96	2958.32	2959.14	7776.0
2018-05-16 05:00:00	ES	Futures	2958.87	2959.14	2954.23	2956.96	13657.0
2018-05-16 06:00:00	ES	Futures	2957.23	2959.41	2955.32	2959.41	10986.0
2018-05-16 07:00:00	ES	Futures	2959.14	2959.96	2955.32	2956.14	13600.0
2018-05-16 08:00:00	ES	Futures	2956.14	2957.78	2952.32	2953.14	24121.0
2018-05-16 09:00:00	ES	Futures	2953.14	2968.69	2952.32	2967.33	164449.0
2018-05-16 10:00:00	ES	Futures	2967.6	2969.24	2961.6	2965.96	132119.0
2018-05-16 11:00:00	ES	Futures	2965.69	2968.15	2960.51	2967.88	87058.0
2018-05-16 12:00:00	ES	Futures	2968.15	2977.15	2967.88	2974.15	120484.0
2018-05-16 13:00:00	ES	Futures	2974.15	2975.79	2971.42	2974.7	52573.0
2018-05-16 14:00:00	ES	Futures	2974.7	2977.97	2973.61	2976.61	80957.0
2018-05-16 15:00:00	ES	Futures	2976.88	2976.88	2966.24	2972.24	202895.0
2018-05-16 16:00:00	ES	Futures	2971.97	2972.79	2970.88	2971.15	57022.0
2018-05-16 18:00:00	ES	Futures	2971.15	2974.42	2971.15	2973.33	3942.0
2018-05-16 19:00:00	ES	Futures	2973.61	2974.7	2971.97	2974.15	2417.0
2018-05-16 20:00:00	ES	Futures	2974.15	2974.97	2973.33	2973.88	3784.0
2018-05-16 21:00:00	ES	Futures	2973.88	2974.42	2969.51	2970.33	5917.0
2018-05-16 22:00:00	ES	Futures	2970.33	2973.06	2969.79	2973.06	5369.0
2018-05-16 23:00:00	ES	Futures	2973.06	2974.15	2971.97	2973.61	2525.0
2018-05-16 00:00:00	NQ	Futures	8150.19	8152.85	8143.68	8143.68	1028.0
2018-05-16 01:00:00	NQ	Futures	8144.27	8149.59	8138.96	8146.93	1772.0
2018-05-16 02:00:00	NQ	Futures	8146.64	8147.82	8136.0	8144.87	2555.0
2018-05-16 03:00:00	NQ	Futures	8145.16	8164.96	8143.98	8159.94	6071.0
2018-05-16 04:00:00	NQ	Futures	8160.53	8162.3	8148.41	8150.78	2356.0
2018-05-16 05:00:00	NQ	Futures	8150.48	8150.78	8136.0	8146.64	3939.0
2018-05-16 06:00:00	NQ	Futures	8146.64	8158.16	8143.98	8157.57	3128.0
2018-05-16 07:00:00	NQ	Futures	8157.28	8158.46	8142.5	8148.12	5077.0
2018-05-16 08:00:00	NQ	Futures	8147.82	8151.66	8138.07	8141.02	6218.0
2018-05-16 09:00:00	NQ	Futures	8140.73	8185.06	8138.36	8181.81	45554.0
2018-05-16 10:00:00	NQ	Futures	8182.1	8199.54	8168.8	8184.47	44629.0
2018-05-16 11:00:00	NQ	Futures	8183.58	8190.08	8164.08	8190.08	28252.0
2018-05-16 12:00:00	NQ	Futures	8190.08	8219.93	8189.79	8210.18	29926.0
2018-05-16 13:00:00	NQ	Futures	8210.47	8214.32	8196.29	8207.81	17090.0
2018-05-16 14:00:00	NQ	Futures	8207.52	8218.16	8200.43	8216.09	18084.0
2018-05-16 15:00:00	NQ	Futures	8216.09	8216.09	8182.69	8201.31	35571.0
2018-05-16 16:00:00	NQ	Futures	8201.31	8204.27	8195.11	8197.17	7937.0
2018-05-16 18:00:00	NQ	Futures	8198.36	8208.11	8197.17	8203.68	890.0
2018-05-16 19:00:00	NQ	Futures	8204.27	8208.11	8198.06	8206.63	722.0
2018-05-16 20:00:00	NQ	Futures	8206.63	8209.29	8202.49	8203.38	1019.0
2018-05-16 21:00:00	NQ	Futures	8203.68	8204.86	8187.72	8190.67	2529.0
2018-05-16 22:00:00	NQ	Futures	8190.38	8203.97	8189.79	8203.97	2641.0
2018-05-16 23:00:00	NQ	Futures	8203.68	8204.56	8198.65	8200.72	1271.0
2018-05-16 00:00:00	YM	Futures	26803.1	26815.0	26790.0	26792.2	1038.0
2018-05-16 01:00:00	YM	Futures	26792.2	26816.1	26779.2	26808.5	1453.0
2018-05-16 02:00:00	YM	Futures	26807.4	26807.4	26764.0	26785.7	1824.0
2018-05-16 03:00:00	YM	Futures	26785.7	26833.5	26785.7	26822.6	3323.0

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

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