PREVIEW / futures_1hour / 2018-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-25.parquet
  size:    47 KB
  rows:    1,372

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-25 00:00:00	ES	Futures	2985.89	2986.71	2984.25	2985.34	3172.0
2018-05-25 01:00:00	ES	Futures	2985.07	2986.43	2984.52	2984.8	2609.0
2018-05-25 02:00:00	ES	Futures	2984.8	2985.07	2981.79	2982.07	6070.0
2018-05-25 03:00:00	ES	Futures	2982.07	2982.61	2978.25	2979.88	15505.0
2018-05-25 04:00:00	ES	Futures	2979.88	2985.07	2979.34	2984.52	9086.0
2018-05-25 05:00:00	ES	Futures	2984.8	2985.89	2982.34	2983.98	7378.0
2018-05-25 06:00:00	ES	Futures	2983.98	2985.07	2980.97	2983.16	10609.0
2018-05-25 07:00:00	ES	Futures	2982.88	2983.98	2972.24	2972.79	29620.0
2018-05-25 08:00:00	ES	Futures	2972.79	2974.15	2967.6	2968.15	41563.0
2018-05-25 09:00:00	ES	Futures	2968.15	2973.06	2965.15	2970.6	172825.0
2018-05-25 10:00:00	ES	Futures	2970.33	2976.88	2968.42	2972.79	192016.0
2018-05-25 11:00:00	ES	Futures	2973.06	2975.52	2970.6	2971.42	65741.0
2018-05-25 12:00:00	ES	Futures	2971.42	2972.51	2965.96	2968.42	77824.0
2018-05-25 13:00:00	ES	Futures	2968.15	2969.79	2963.78	2964.6	58393.0
2018-05-25 14:00:00	ES	Futures	2964.6	2968.42	2962.42	2963.51	61644.0
2018-05-25 15:00:00	ES	Futures	2963.51	2971.42	2962.42	2969.24	131582.0
2018-05-25 16:00:00	ES	Futures	2968.97	2970.6	2966.51	2970.06	39623.0
2018-05-25 00:00:00	NQ	Futures	8260.12	8260.42	8250.96	8255.69	1499.0
2018-05-25 01:00:00	NQ	Futures	8255.99	8261.31	8255.1	8256.87	1255.0
2018-05-25 02:00:00	NQ	Futures	8256.58	8256.58	8247.71	8249.48	2459.0
2018-05-25 03:00:00	NQ	Futures	8249.48	8251.85	8237.66	8242.69	4899.0
2018-05-25 04:00:00	NQ	Futures	8242.1	8256.28	8238.55	8254.21	3583.0
2018-05-25 05:00:00	NQ	Futures	8254.21	8259.53	8250.08	8257.76	2473.0
2018-05-25 06:00:00	NQ	Futures	8257.76	8259.83	8249.48	8253.33	2992.0
2018-05-25 07:00:00	NQ	Futures	8252.74	8255.1	8225.25	8227.32	9550.0
2018-05-25 08:00:00	NQ	Futures	8227.02	8233.53	8216.38	8217.86	14024.0
2018-05-25 09:00:00	NQ	Futures	8217.86	8245.05	8206.93	8239.44	64233.0
2018-05-25 10:00:00	NQ	Futures	8239.14	8260.42	8232.34	8251.26	63570.0
2018-05-25 11:00:00	NQ	Futures	8251.55	8262.49	8240.03	8249.78	28215.0
2018-05-25 12:00:00	NQ	Futures	8249.78	8253.92	8230.27	8244.46	25623.0
2018-05-25 13:00:00	NQ	Futures	8244.46	8251.55	8224.07	8227.02	23836.0
2018-05-25 14:00:00	NQ	Futures	8227.02	8241.21	8222.3	8226.73	18585.0
2018-05-25 15:00:00	NQ	Futures	8227.02	8238.25	8222.59	8232.64	26561.0
2018-05-25 16:00:00	NQ	Futures	8232.93	8235.59	8223.48	8233.82	5610.0
2018-05-25 00:00:00	YM	Futures	27014.8	27017.0	27000.7	27007.2	805.0
2018-05-25 01:00:00	YM	Futures	27008.3	27018.1	27005.1	27008.3	897.0
2018-05-25 02:00:00	YM	Futures	27007.2	27009.4	26977.9	26977.9	1774.0
2018-05-25 03:00:00	YM	Futures	26977.9	26986.6	26948.6	26966.0	4202.0
2018-05-25 04:00:00	YM	Futures	26963.8	27015.9	26957.3	27010.5	3201.0
2018-05-25 05:00:00	YM	Futures	27010.5	27024.6	26990.9	27006.1	2240.0
2018-05-25 06:00:00	YM	Futures	27005.1	27010.5	26981.2	26992.0	2445.0
2018-05-25 07:00:00	YM	Futures	26990.9	27000.7	26903.0	26909.5	7289.0
2018-05-25 08:00:00	YM	Futures	26908.4	26919.3	26856.3	26861.7	8845.0
2018-05-25 09:00:00	YM	Futures	26861.7	26911.7	26828.0	26872.6	32256.0
2018-05-25 10:00:00	YM	Futures	26871.5	26949.7	26854.1	26904.1	33350.0
2018-05-25 11:00:00	YM	Futures	26905.1	26938.8	26891.0	26892.1	15474.0
2018-05-25 12:00:00	YM	Futures	26892.1	26904.1	26837.8	26860.6	14132.0
2018-05-25 13:00:00	YM	Futures	26860.6	26870.4	26818.3	26833.5	10954.0
2018-05-25 14:00:00	YM	Futures	26834.5	26861.7	26796.5	26826.9	10867.0
2018-05-25 15:00:00	YM	Futures	26826.9	26883.4	26815.0	26865.0	18474.0

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

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