PREVIEW / futures_1hour / 2018-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-17.parquet
  size:    55 KB
  rows:    1,697

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-17 00:00:00	ES	Futures	2973.61	2973.61	2971.42	2972.24	1324.0
2018-05-17 01:00:00	ES	Futures	2972.24	2972.79	2968.42	2969.24	5594.0
2018-05-17 02:00:00	ES	Futures	2969.24	2969.79	2965.69	2966.24	8139.0
2018-05-17 03:00:00	ES	Futures	2965.96	2968.69	2965.96	2967.6	9155.0
2018-05-17 04:00:00	ES	Futures	2967.6	2968.15	2964.87	2966.51	7894.0
2018-05-17 05:00:00	ES	Futures	2966.51	2969.51	2966.24	2969.24	6850.0
2018-05-17 06:00:00	ES	Futures	2969.24	2970.33	2966.78	2966.78	7365.0
2018-05-17 07:00:00	ES	Futures	2967.06	2968.97	2965.96	2966.51	8394.0
2018-05-17 08:00:00	ES	Futures	2966.51	2968.15	2964.33	2967.6	19638.0
2018-05-17 09:00:00	ES	Futures	2967.6	2970.06	2962.14	2967.6	134246.0
2018-05-17 10:00:00	ES	Futures	2967.6	2982.34	2967.6	2981.25	197123.0
2018-05-17 11:00:00	ES	Futures	2981.25	2982.07	2974.42	2974.97	84211.0
2018-05-17 12:00:00	ES	Futures	2974.97	2978.25	2969.79	2971.7	89091.0
2018-05-17 13:00:00	ES	Futures	2971.97	2974.42	2962.96	2963.78	99081.0
2018-05-17 14:00:00	ES	Futures	2963.78	2971.42	2959.41	2970.88	142734.0
2018-05-17 15:00:00	ES	Futures	2971.15	2972.51	2965.15	2969.51	145583.0
2018-05-17 16:00:00	ES	Futures	2969.24	2969.79	2967.06	2967.6	48405.0
2018-05-17 18:00:00	ES	Futures	2967.88	2974.7	2964.33	2971.42	8392.0
2018-05-17 19:00:00	ES	Futures	2971.15	2972.79	2968.97	2971.97	3665.0
2018-05-17 20:00:00	ES	Futures	2971.97	2975.79	2970.33	2974.97	5636.0
2018-05-17 21:00:00	ES	Futures	2974.7	2975.52	2971.7	2972.79	6328.0
2018-05-17 22:00:00	ES	Futures	2972.79	2975.24	2971.7	2974.42	3355.0
2018-05-17 23:00:00	ES	Futures	2974.42	2974.97	2973.33	2974.7	1789.0
2018-05-17 00:00:00	NQ	Futures	8200.43	8200.72	8193.92	8195.11	553.0
2018-05-17 01:00:00	NQ	Futures	8195.11	8195.11	8175.31	8179.44	3148.0
2018-05-17 02:00:00	NQ	Futures	8179.44	8181.22	8167.33	8167.62	2725.0
2018-05-17 03:00:00	NQ	Futures	8167.62	8176.19	8167.33	8171.76	4058.0
2018-05-17 04:00:00	NQ	Futures	8172.35	8173.24	8164.67	8167.62	3011.0
2018-05-17 05:00:00	NQ	Futures	8167.03	8175.6	8166.74	8175.01	2616.0
2018-05-17 06:00:00	NQ	Futures	8175.01	8177.67	8166.14	8167.33	2407.0
2018-05-17 07:00:00	NQ	Futures	8167.62	8177.08	8165.55	8168.8	3385.0
2018-05-17 08:00:00	NQ	Futures	8169.39	8173.83	8154.32	8163.78	9758.0
2018-05-17 09:00:00	NQ	Futures	8164.08	8186.24	8163.19	8174.12	42866.0
2018-05-17 10:00:00	NQ	Futures	8174.12	8229.98	8173.83	8226.73	55371.0
2018-05-17 11:00:00	NQ	Futures	8226.73	8227.32	8198.95	8199.54	30027.0
2018-05-17 12:00:00	NQ	Futures	8199.54	8209.88	8173.24	8176.78	28421.0
2018-05-17 13:00:00	NQ	Futures	8176.78	8185.06	8145.75	8147.23	31863.0
2018-05-17 14:00:00	NQ	Futures	8146.64	8178.26	8127.13	8176.78	46841.0
2018-05-17 15:00:00	NQ	Futures	8176.49	8182.99	8160.53	8168.21	36221.0
2018-05-17 16:00:00	NQ	Futures	8167.92	8169.99	8161.12	8161.71	7712.0
2018-05-17 18:00:00	NQ	Futures	8166.74	8180.33	8150.78	8170.87	2404.0
2018-05-17 19:00:00	NQ	Futures	8170.28	8176.49	8164.96	8172.94	1261.0
2018-05-17 20:00:00	NQ	Futures	8173.24	8199.54	8168.21	8192.45	4589.0
2018-05-17 21:00:00	NQ	Futures	8191.86	8197.47	8182.1	8185.94	2772.0
2018-05-17 22:00:00	NQ	Futures	8185.94	8194.22	8182.99	8191.26	1272.0
2018-05-17 23:00:00	NQ	Futures	8191.26	8192.15	8188.01	8191.56	552.0
2018-05-17 00:00:00	YM	Futures	26885.6	26886.7	26869.3	26874.7	439.0
2018-05-17 01:00:00	YM	Futures	26874.7	26878.0	26841.1	26846.5	1840.0
2018-05-17 02:00:00	YM	Futures	26847.6	26855.2	26822.6	26828.0	3084.0
2018-05-17 03:00:00	YM	Futures	26828.0	26850.8	26826.9	26837.8	2270.0

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

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