PREVIEW / futures_1hour / 2018-11-05

all futures 1-hour files

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

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-11-05 00:00:00	ES	Futures	2954.72	2957.16	2953.36	2955.8	4832.0
2018-11-05 01:00:00	ES	Futures	2956.08	2959.07	2955.26	2957.71	3479.0
2018-11-05 02:00:00	ES	Futures	2957.71	2958.25	2955.8	2956.08	7652.0
2018-11-05 03:00:00	ES	Futures	2955.8	2958.52	2953.9	2954.99	16202.0
2018-11-05 04:00:00	ES	Futures	2954.99	2960.7	2952.81	2960.16	14566.0
2018-11-05 05:00:00	ES	Futures	2960.43	2962.6	2958.25	2962.06	17148.0
2018-11-05 06:00:00	ES	Futures	2962.06	2967.77	2961.79	2967.23	18113.0
2018-11-05 07:00:00	ES	Futures	2967.23	2969.68	2961.79	2965.6	25089.0
2018-11-05 08:00:00	ES	Futures	2965.32	2966.68	2959.88	2965.32	23102.0
2018-11-05 09:00:00	ES	Futures	2965.32	2973.76	2963.96	2965.05	158125.0
2018-11-05 10:00:00	ES	Futures	2965.05	2973.76	2956.08	2972.67	232179.0
2018-11-05 11:00:00	ES	Futures	2972.4	2974.84	2963.96	2971.58	123433.0
2018-11-05 12:00:00	ES	Futures	2971.31	2972.94	2963.96	2966.41	84015.0
2018-11-05 13:00:00	ES	Futures	2966.41	2974.3	2964.78	2972.67	73375.0
2018-11-05 14:00:00	ES	Futures	2972.67	2985.18	2970.22	2982.19	146778.0
2018-11-05 15:00:00	ES	Futures	2982.46	2984.64	2972.67	2978.92	219900.0
2018-11-05 16:00:00	ES	Futures	2978.92	2983.0	2978.38	2981.1	55813.0
2018-11-05 18:00:00	ES	Futures	2980.01	2983.0	2978.38	2981.64	4711.0
2018-11-05 19:00:00	ES	Futures	2981.64	2987.36	2980.01	2985.45	10725.0
2018-11-05 20:00:00	ES	Futures	2985.72	2986.81	2980.01	2980.28	8098.0
2018-11-05 21:00:00	ES	Futures	2980.56	2983.55	2979.2	2981.92	7683.0
2018-11-05 22:00:00	ES	Futures	2981.64	2981.92	2978.92	2980.28	5222.0
2018-11-05 23:00:00	ES	Futures	2980.28	2983.82	2979.47	2982.19	3839.0
2018-11-05 00:00:00	NQ	Futures	8175.25	8186.98	8167.92	8180.53	3420.0
2018-11-05 01:00:00	NQ	Futures	8180.82	8191.97	8175.84	8187.28	1951.0
2018-11-05 02:00:00	NQ	Futures	8187.28	8187.86	8175.55	8178.48	2708.0
2018-11-05 03:00:00	NQ	Futures	8178.19	8186.1	8166.45	8168.8	5227.0
2018-11-05 04:00:00	NQ	Futures	8169.68	8189.33	8161.47	8188.45	6826.0
2018-11-05 05:00:00	NQ	Futures	8188.74	8198.42	8180.24	8192.85	6068.0
2018-11-05 06:00:00	NQ	Futures	8192.56	8206.34	8191.09	8204.29	5659.0
2018-11-05 07:00:00	NQ	Futures	8204.29	8211.04	8168.51	8181.41	9571.0
2018-11-05 08:00:00	NQ	Futures	8181.12	8182.58	8161.76	8176.13	15180.0
2018-11-05 09:00:00	NQ	Futures	8175.84	8179.36	8093.42	8101.34	78652.0
2018-11-05 10:00:00	NQ	Futures	8102.22	8115.12	8054.41	8110.43	100428.0
2018-11-05 11:00:00	NQ	Futures	8110.43	8123.04	8071.42	8099.58	59519.0
2018-11-05 12:00:00	NQ	Futures	8099.87	8106.62	8076.41	8090.78	35141.0
2018-11-05 13:00:00	NQ	Futures	8090.48	8117.18	8080.8	8108.96	33542.0
2018-11-05 14:00:00	NQ	Futures	8108.96	8163.81	8101.92	8150.61	55048.0
2018-11-05 15:00:00	NQ	Futures	8150.91	8162.05	8123.63	8145.92	51468.0
2018-11-05 16:00:00	NQ	Futures	8145.63	8162.64	8142.99	8152.96	9695.0
2018-11-05 18:00:00	NQ	Futures	8150.91	8158.53	8143.87	8156.48	2375.0
2018-11-05 19:00:00	NQ	Futures	8156.77	8177.01	8149.73	8169.97	4728.0
2018-11-05 20:00:00	NQ	Futures	8170.27	8174.08	8147.68	8148.85	4050.0
2018-11-05 21:00:00	NQ	Futures	8148.85	8158.83	8144.16	8151.49	3736.0
2018-11-05 22:00:00	NQ	Futures	8151.49	8152.08	8137.12	8140.93	2494.0
2018-11-05 23:00:00	NQ	Futures	8141.23	8152.96	8137.71	8147.39	1694.0
2018-11-05 00:00:00	YM	Futures	27339.9	27355.1	27320.4	27342.1	1301.0
2018-11-05 01:00:00	YM	Futures	27343.2	27377.9	27337.7	27360.6	1185.0
2018-11-05 02:00:00	YM	Futures	27359.5	27363.8	27332.3	27337.7	1841.0
2018-11-05 03:00:00	YM	Futures	27335.6	27363.8	27326.9	27335.6	3239.0

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

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