PREVIEW / futures_1hour / 2018-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-27.parquet
  size:    57 KB
  rows:    1,705

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-06-27 00:00:00	ES	Futures	2972.06	2975.06	2972.06	2974.79	3813.0
2018-06-27 01:00:00	ES	Futures	2974.51	2974.79	2968.52	2969.07	7478.0
2018-06-27 02:00:00	ES	Futures	2969.07	2969.07	2962.53	2964.98	21231.0
2018-06-27 03:00:00	ES	Futures	2964.98	2965.52	2951.63	2952.99	47677.0
2018-06-27 04:00:00	ES	Futures	2952.99	2956.8	2948.63	2949.99	34840.0
2018-06-27 05:00:00	ES	Futures	2949.99	2964.98	2949.45	2964.43	36488.0
2018-06-27 06:00:00	ES	Futures	2964.16	2965.8	2960.62	2961.44	25734.0
2018-06-27 07:00:00	ES	Futures	2961.44	2975.88	2955.71	2972.88	84406.0
2018-06-27 08:00:00	ES	Futures	2972.88	2979.42	2968.25	2973.15	87326.0
2018-06-27 09:00:00	ES	Futures	2973.15	2988.41	2973.15	2988.41	187201.0
2018-06-27 10:00:00	ES	Futures	2988.14	2994.95	2984.87	2989.23	200958.0
2018-06-27 11:00:00	ES	Futures	2989.23	2991.14	2974.51	2982.96	248706.0
2018-06-27 12:00:00	ES	Futures	2983.23	2988.14	2972.06	2972.06	131712.0
2018-06-27 13:00:00	ES	Futures	2972.06	2975.06	2957.62	2961.98	206271.0
2018-06-27 14:00:00	ES	Futures	2961.98	2965.52	2952.17	2954.08	182555.0
2018-06-27 15:00:00	ES	Futures	2954.08	2959.8	2943.73	2944.54	421298.0
2018-06-27 16:00:00	ES	Futures	2944.54	2950.54	2944.27	2948.9	97955.0
2018-06-27 18:00:00	ES	Futures	2948.09	2953.26	2945.63	2949.99	8990.0
2018-06-27 19:00:00	ES	Futures	2949.99	2954.35	2949.99	2952.72	3822.0
2018-06-27 20:00:00	ES	Futures	2952.72	2954.35	2946.72	2950.54	12667.0
2018-06-27 21:00:00	ES	Futures	2950.54	2956.26	2949.45	2955.17	15719.0
2018-06-27 22:00:00	ES	Futures	2954.9	2957.62	2951.63	2955.71	10208.0
2018-06-27 23:00:00	ES	Futures	2955.71	2957.08	2953.53	2955.71	5244.0
2018-06-27 00:00:00	NQ	Futures	8357.65	8368.84	8356.76	8365.01	1285.0
2018-06-27 01:00:00	NQ	Futures	8364.42	8365.89	8343.52	8345.28	2688.0
2018-06-27 02:00:00	NQ	Futures	8345.58	8346.17	8317.31	8326.73	7012.0
2018-06-27 03:00:00	NQ	Futures	8327.03	8327.62	8273.15	8279.33	13621.0
2018-06-27 04:00:00	NQ	Futures	8279.63	8289.64	8259.31	8264.61	11400.0
2018-06-27 05:00:00	NQ	Futures	8264.32	8312.01	8263.73	8310.25	8663.0
2018-06-27 06:00:00	NQ	Futures	8310.84	8312.01	8297.0	8301.71	6424.0
2018-06-27 07:00:00	NQ	Futures	8301.41	8359.12	8282.87	8353.23	20371.0
2018-06-27 08:00:00	NQ	Futures	8353.53	8382.38	8336.16	8359.41	26666.0
2018-06-27 09:00:00	NQ	Futures	8359.12	8410.94	8359.12	8408.29	60384.0
2018-06-27 10:00:00	NQ	Futures	8407.99	8422.13	8381.79	8391.21	59601.0
2018-06-27 11:00:00	NQ	Futures	8391.51	8400.34	8351.17	8374.72	65707.0
2018-06-27 12:00:00	NQ	Futures	8374.72	8387.38	8326.15	8326.73	40086.0
2018-06-27 13:00:00	NQ	Futures	8326.44	8337.04	8273.44	8292.58	60650.0
2018-06-27 14:00:00	NQ	Futures	8292.58	8308.77	8268.14	8275.51	44527.0
2018-06-27 15:00:00	NQ	Futures	8275.51	8294.64	8229.58	8231.05	81486.0
2018-06-27 16:00:00	NQ	Futures	8231.05	8249.01	8229.87	8242.82	18362.0
2018-06-27 18:00:00	NQ	Futures	8242.24	8258.43	8233.4	8251.36	2044.0
2018-06-27 19:00:00	NQ	Futures	8252.25	8263.14	8250.19	8256.66	1924.0
2018-06-27 20:00:00	NQ	Futures	8256.96	8261.37	8238.41	8251.36	5179.0
2018-06-27 21:00:00	NQ	Futures	8250.77	8266.08	8246.36	8262.85	5966.0
2018-06-27 22:00:00	NQ	Futures	8263.43	8271.97	8253.72	8264.91	4017.0
2018-06-27 23:00:00	NQ	Futures	8264.61	8267.85	8258.13	8263.73	1851.0
2018-06-27 00:00:00	YM	Futures	26379.4	26402.3	26378.3	26399.0	1176.0
2018-06-27 01:00:00	YM	Futures	26397.9	26400.1	26339.2	26343.6	2106.0
2018-06-27 02:00:00	YM	Futures	26343.6	26349.0	26278.3	26300.1	4721.0
2018-06-27 03:00:00	YM	Futures	26301.2	26306.6	26181.6	26197.9	8190.0

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

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