PREVIEW / futures_1hour / 2018-05-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	2949.32	2950.41	2948.5	2949.04	1343.0
2018-05-10 01:00:00	ES	Futures	2949.04	2949.86	2948.23	2948.77	1913.0
2018-05-10 02:00:00	ES	Futures	2948.77	2949.04	2947.41	2947.95	4370.0
2018-05-10 03:00:00	ES	Futures	2948.23	2949.04	2944.95	2949.04	11935.0
2018-05-10 04:00:00	ES	Futures	2948.77	2949.32	2947.13	2948.23	5306.0
2018-05-10 05:00:00	ES	Futures	2948.23	2949.32	2944.4	2945.77	8672.0
2018-05-10 06:00:00	ES	Futures	2945.77	2946.59	2943.59	2944.95	7959.0
2018-05-10 07:00:00	ES	Futures	2944.95	2949.32	2943.31	2948.5	10863.0
2018-05-10 08:00:00	ES	Futures	2948.5	2953.96	2945.77	2951.77	39408.0
2018-05-10 09:00:00	ES	Futures	2952.05	2957.23	2950.14	2955.05	143880.0
2018-05-10 10:00:00	ES	Futures	2955.32	2960.51	2951.23	2958.6	158512.0
2018-05-10 11:00:00	ES	Futures	2958.6	2967.06	2957.78	2966.51	129509.0
2018-05-10 12:00:00	ES	Futures	2966.51	2973.06	2965.69	2970.88	120828.0
2018-05-10 13:00:00	ES	Futures	2971.15	2974.7	2965.15	2967.06	124132.0
2018-05-10 14:00:00	ES	Futures	2967.33	2971.15	2961.6	2969.79	109860.0
2018-05-10 15:00:00	ES	Futures	2970.06	2973.06	2965.69	2970.06	175268.0
2018-05-10 16:00:00	ES	Futures	2970.06	2970.6	2965.15	2965.15	59431.0
2018-05-10 18:00:00	ES	Futures	2965.15	2969.24	2965.15	2967.6	4309.0
2018-05-10 19:00:00	ES	Futures	2967.6	2969.79	2966.78	2969.79	2287.0
2018-05-10 20:00:00	ES	Futures	2969.79	2971.15	2968.97	2969.51	4789.0
2018-05-10 21:00:00	ES	Futures	2969.79	2971.42	2968.15	2968.97	5293.0
2018-05-10 22:00:00	ES	Futures	2969.24	2972.51	2968.69	2971.15	3971.0
2018-05-10 23:00:00	ES	Futures	2971.15	2971.97	2970.6	2971.7	2269.0
2018-05-10 00:00:00	NQ	Futures	8177.67	8180.33	8173.83	8176.49	766.0
2018-05-10 01:00:00	NQ	Futures	8176.19	8177.97	8173.53	8175.31	950.0
2018-05-10 02:00:00	NQ	Futures	8175.6	8176.19	8167.92	8170.28	1686.0
2018-05-10 03:00:00	NQ	Futures	8170.58	8173.53	8160.53	8172.35	3155.0
2018-05-10 04:00:00	NQ	Futures	8172.35	8172.65	8163.48	8167.92	1393.0
2018-05-10 05:00:00	NQ	Futures	8167.92	8170.28	8156.69	8163.48	2509.0
2018-05-10 06:00:00	NQ	Futures	8163.19	8166.14	8157.87	8162.01	2098.0
2018-05-10 07:00:00	NQ	Futures	8162.3	8170.28	8157.87	8162.89	4241.0
2018-05-10 08:00:00	NQ	Futures	8162.6	8184.47	8154.32	8178.26	11537.0
2018-05-10 09:00:00	NQ	Futures	8178.56	8195.11	8170.28	8185.65	46310.0
2018-05-10 10:00:00	NQ	Futures	8186.24	8208.11	8175.9	8202.2	43235.0
2018-05-10 11:00:00	NQ	Futures	8202.49	8216.09	8200.43	8211.66	26066.0
2018-05-10 12:00:00	NQ	Futures	8211.36	8227.91	8209.0	8225.55	25439.0
2018-05-10 13:00:00	NQ	Futures	8225.84	8239.73	8208.11	8215.2	30408.0
2018-05-10 14:00:00	NQ	Futures	8215.2	8226.43	8199.83	8222.3	26616.0
2018-05-10 15:00:00	NQ	Futures	8222.0	8240.91	8210.18	8235.89	39130.0
2018-05-10 16:00:00	NQ	Futures	8235.59	8238.85	8217.57	8218.75	8669.0
2018-05-10 18:00:00	NQ	Futures	8215.2	8231.16	8214.02	8224.66	1621.0
2018-05-10 19:00:00	NQ	Futures	8224.66	8231.46	8223.18	8231.46	1114.0
2018-05-10 20:00:00	NQ	Futures	8231.75	8237.37	8230.57	8233.53	2498.0
2018-05-10 21:00:00	NQ	Futures	8233.23	8237.37	8225.84	8229.39	2262.0
2018-05-10 22:00:00	NQ	Futures	8229.98	8239.14	8227.61	8235.89	923.0
2018-05-10 23:00:00	NQ	Futures	8236.48	8240.62	8236.19	8239.44	1132.0
2018-05-10 00:00:00	YM	Futures	26665.1	26672.7	26656.4	26661.9	432.0
2018-05-10 01:00:00	YM	Futures	26660.8	26666.2	26651.0	26656.4	692.0
2018-05-10 02:00:00	YM	Futures	26655.4	26661.9	26644.5	26652.1	1344.0
2018-05-10 03:00:00	YM	Futures	26653.2	26658.6	26614.1	26645.6	4152.0

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

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