PREVIEW / futures_1hour / 2018-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-06.parquet
  size:    56 KB
  rows:    1,738

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-06 00:00:00	ES	Futures	2982.46	2984.36	2981.37	2983.55	3722.0
2018-11-06 01:00:00	ES	Futures	2983.55	2985.45	2983.55	2984.36	3837.0
2018-11-06 02:00:00	ES	Futures	2984.36	2988.17	2981.64	2983.0	10351.0
2018-11-06 03:00:00	ES	Futures	2982.73	2983.0	2973.76	2976.2	19810.0
2018-11-06 04:00:00	ES	Futures	2976.2	2979.47	2971.31	2972.12	14009.0
2018-11-06 05:00:00	ES	Futures	2972.12	2976.75	2969.95	2970.76	14722.0
2018-11-06 06:00:00	ES	Futures	2971.04	2976.75	2971.04	2974.3	10364.0
2018-11-06 07:00:00	ES	Futures	2974.3	2976.75	2971.58	2975.39	17402.0
2018-11-06 08:00:00	ES	Futures	2975.39	2975.66	2972.12	2973.76	17335.0
2018-11-06 09:00:00	ES	Futures	2973.76	2993.88	2973.76	2991.16	181586.0
2018-11-06 10:00:00	ES	Futures	2991.16	2991.98	2983.28	2989.26	187853.0
2018-11-06 11:00:00	ES	Futures	2988.99	2993.34	2983.82	2989.26	142734.0
2018-11-06 12:00:00	ES	Futures	2989.26	2995.52	2987.63	2992.52	94965.0
2018-11-06 13:00:00	ES	Futures	2992.52	2994.7	2990.35	2992.25	74432.0
2018-11-06 14:00:00	ES	Futures	2992.52	2992.8	2978.65	2984.36	120671.0
2018-11-06 15:00:00	ES	Futures	2984.36	2999.05	2981.92	2996.88	205428.0
2018-11-06 16:00:00	ES	Futures	2996.88	3003.95	2995.79	3000.68	70464.0
2018-11-06 18:00:00	ES	Futures	2999.32	2999.87	2992.52	2995.24	16268.0
2018-11-06 19:00:00	ES	Futures	2995.24	3001.23	2986.27	2994.97	30905.0
2018-11-06 20:00:00	ES	Futures	2994.97	3014.01	2992.8	3009.39	73147.0
2018-11-06 21:00:00	ES	Futures	3009.39	3018.64	3003.13	3006.4	48035.0
2018-11-06 22:00:00	ES	Futures	3006.12	3010.48	2999.6	3008.57	37006.0
2018-11-06 23:00:00	ES	Futures	3008.84	3010.48	3004.49	3008.3	9219.0
2018-11-06 00:00:00	NQ	Futures	8147.68	8157.07	8143.87	8152.96	2188.0
2018-11-06 01:00:00	NQ	Futures	8153.25	8163.52	8153.25	8156.77	2110.0
2018-11-06 02:00:00	NQ	Futures	8156.48	8170.85	8147.09	8149.44	5517.0
2018-11-06 03:00:00	NQ	Futures	8149.44	8150.32	8120.99	8132.72	6910.0
2018-11-06 04:00:00	NQ	Futures	8132.72	8147.68	8109.55	8112.78	8123.0
2018-11-06 05:00:00	NQ	Futures	8112.48	8128.91	8103.39	8111.9	8368.0
2018-11-06 06:00:00	NQ	Futures	8111.9	8137.71	8111.9	8131.25	6268.0
2018-11-06 07:00:00	NQ	Futures	8130.96	8137.41	8118.35	8133.31	8120.0
2018-11-06 08:00:00	NQ	Futures	8133.01	8136.53	8121.87	8127.15	11985.0
2018-11-06 09:00:00	NQ	Futures	8127.15	8253.57	8126.56	8236.85	85929.0
2018-11-06 10:00:00	NQ	Futures	8237.14	8239.78	8184.34	8189.92	87745.0
2018-11-06 11:00:00	NQ	Futures	8190.5	8208.4	8164.69	8192.56	58074.0
2018-11-06 12:00:00	NQ	Futures	8192.85	8219.84	8186.1	8202.53	42233.0
2018-11-06 13:00:00	NQ	Futures	8202.53	8215.44	8186.1	8189.33	42299.0
2018-11-06 14:00:00	NQ	Futures	8189.33	8191.09	8133.31	8160.59	52877.0
2018-11-06 15:00:00	NQ	Futures	8160.29	8214.26	8148.85	8207.52	50217.0
2018-11-06 16:00:00	NQ	Futures	8207.81	8239.19	8205.46	8228.64	13618.0
2018-11-06 18:00:00	NQ	Futures	8226.29	8227.76	8204.0	8211.92	4436.0
2018-11-06 19:00:00	NQ	Futures	8211.04	8233.33	8179.36	8206.64	11826.0
2018-11-06 20:00:00	NQ	Futures	8206.05	8284.07	8200.18	8272.34	29142.0
2018-11-06 21:00:00	NQ	Futures	8272.93	8306.36	8248.29	8257.09	14288.0
2018-11-06 22:00:00	NQ	Futures	8258.55	8272.34	8236.26	8269.7	13726.0
2018-11-06 23:00:00	NQ	Futures	8268.82	8274.1	8253.86	8269.41	4589.0
2018-11-06 00:00:00	YM	Futures	27677.8	27694.1	27661.5	27682.2	1231.0
2018-11-06 01:00:00	YM	Futures	27683.2	27699.5	27683.2	27688.7	1055.0
2018-11-06 02:00:00	YM	Futures	27687.6	27727.8	27674.6	27684.3	4516.0
2018-11-06 03:00:00	YM	Futures	27684.3	27684.3	27602.8	27627.8	6040.0

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

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