PREVIEW / futures_1hour / 2018-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-30.parquet
  size:    57 KB
  rows:    1,707

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-30 00:00:00	ES	Futures	2940.04	2941.95	2939.49	2940.04	4462.0
2018-05-30 01:00:00	ES	Futures	2939.77	2941.95	2934.58	2941.13	10486.0
2018-05-30 02:00:00	ES	Futures	2941.13	2947.95	2940.86	2946.86	24550.0
2018-05-30 03:00:00	ES	Futures	2947.13	2952.05	2943.04	2948.77	27416.0
2018-05-30 04:00:00	ES	Futures	2948.5	2950.14	2941.95	2946.32	20033.0
2018-05-30 05:00:00	ES	Futures	2946.32	2951.5	2943.86	2950.95	19132.0
2018-05-30 06:00:00	ES	Futures	2950.95	2955.05	2948.23	2952.59	23769.0
2018-05-30 07:00:00	ES	Futures	2952.87	2955.87	2952.32	2952.59	23462.0
2018-05-30 08:00:00	ES	Futures	2952.59	2953.41	2946.04	2949.86	41564.0
2018-05-30 09:00:00	ES	Futures	2949.86	2956.14	2947.41	2950.41	166033.0
2018-05-30 10:00:00	ES	Futures	2950.41	2964.05	2949.32	2964.05	199422.0
2018-05-30 11:00:00	ES	Futures	2964.05	2972.24	2961.33	2970.6	164126.0
2018-05-30 12:00:00	ES	Futures	2970.88	2974.15	2969.51	2971.42	132310.0
2018-05-30 13:00:00	ES	Futures	2971.42	2977.97	2969.24	2975.52	115392.0
2018-05-30 14:00:00	ES	Futures	2975.79	2979.34	2974.7	2976.88	97771.0
2018-05-30 15:00:00	ES	Futures	2976.88	2978.52	2970.33	2973.88	181222.0
2018-05-30 16:00:00	ES	Futures	2973.61	2976.34	2972.24	2972.79	65047.0
2018-05-30 18:00:00	ES	Futures	2969.51	2971.42	2967.06	2970.06	8145.0
2018-05-30 19:00:00	ES	Futures	2970.06	2970.88	2968.69	2969.51	2068.0
2018-05-30 20:00:00	ES	Futures	2969.79	2972.24	2967.88	2972.24	7089.0
2018-05-30 21:00:00	ES	Futures	2971.97	2972.24	2968.97	2970.6	6116.0
2018-05-30 22:00:00	ES	Futures	2970.6	2972.24	2970.06	2970.88	2580.0
2018-05-30 23:00:00	ES	Futures	2970.88	2973.33	2970.6	2971.97	3822.0
2018-05-30 00:00:00	NQ	Futures	8205.45	8211.95	8202.49	8203.38	1326.0
2018-05-30 01:00:00	NQ	Futures	8203.38	8213.72	8190.38	8209.88	2574.0
2018-05-30 02:00:00	NQ	Futures	8209.29	8230.87	8208.11	8226.43	4829.0
2018-05-30 03:00:00	NQ	Futures	8226.73	8239.44	8213.43	8227.61	6569.0
2018-05-30 04:00:00	NQ	Futures	8228.21	8235.3	8212.84	8224.66	4549.0
2018-05-30 05:00:00	NQ	Futures	8224.66	8236.78	8216.98	8235.0	5103.0
2018-05-30 06:00:00	NQ	Futures	8235.0	8242.69	8228.21	8235.0	4998.0
2018-05-30 07:00:00	NQ	Futures	8234.41	8248.3	8232.64	8239.44	6182.0
2018-05-30 08:00:00	NQ	Futures	8239.73	8241.21	8222.59	8225.55	13088.0
2018-05-30 09:00:00	NQ	Futures	8225.55	8241.8	8212.25	8217.57	48849.0
2018-05-30 10:00:00	NQ	Futures	8217.57	8252.14	8206.93	8248.6	46801.0
2018-05-30 11:00:00	NQ	Futures	8248.6	8263.67	8241.5	8258.65	32358.0
2018-05-30 12:00:00	NQ	Futures	8258.94	8268.69	8242.39	8247.12	32543.0
2018-05-30 13:00:00	NQ	Futures	8247.12	8261.6	8237.66	8251.85	26098.0
2018-05-30 14:00:00	NQ	Futures	8252.14	8264.85	8251.55	8261.31	16724.0
2018-05-30 15:00:00	NQ	Futures	8261.31	8264.85	8249.19	8254.21	28155.0
2018-05-30 16:00:00	NQ	Futures	8253.92	8265.15	8252.44	8255.99	7155.0
2018-05-30 18:00:00	NQ	Futures	8249.48	8253.92	8240.03	8250.67	1604.0
2018-05-30 19:00:00	NQ	Futures	8249.78	8252.44	8243.57	8247.71	1026.0
2018-05-30 20:00:00	NQ	Futures	8247.71	8256.28	8242.39	8255.1	1740.0
2018-05-30 21:00:00	NQ	Futures	8255.39	8258.05	8245.05	8252.14	5558.0
2018-05-30 22:00:00	NQ	Futures	8252.44	8257.17	8250.08	8253.33	832.0
2018-05-30 23:00:00	NQ	Futures	8253.92	8263.97	8253.03	8260.42	1591.0
2018-05-30 00:00:00	YM	Futures	26512.0	26547.8	26506.6	26522.9	2964.0
2018-05-30 01:00:00	YM	Futures	26522.9	26525.0	26456.6	26513.1	3595.0
2018-05-30 02:00:00	YM	Futures	26514.2	26577.2	26509.8	26568.5	6819.0
2018-05-30 03:00:00	YM	Futures	26570.6	26604.3	26530.5	26571.7	7840.0

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

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