PREVIEW / futures_1hour / 2018-05-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	2974.42	2974.7	2972.79	2973.33	1644.0
2018-05-18 01:00:00	ES	Futures	2973.61	2974.97	2972.79	2974.15	1765.0
2018-05-18 02:00:00	ES	Futures	2974.42	2974.97	2973.61	2974.97	3906.0
2018-05-18 03:00:00	ES	Futures	2974.97	2976.88	2970.06	2971.7	13823.0
2018-05-18 04:00:00	ES	Futures	2971.42	2972.79	2969.24	2972.24	7712.0
2018-05-18 05:00:00	ES	Futures	2971.97	2975.24	2970.33	2974.7	9727.0
2018-05-18 06:00:00	ES	Futures	2974.42	2976.34	2973.33	2973.33	7778.0
2018-05-18 07:00:00	ES	Futures	2973.61	2974.15	2970.33	2971.42	10011.0
2018-05-18 08:00:00	ES	Futures	2971.42	2972.24	2960.78	2961.6	43983.0
2018-05-18 09:00:00	ES	Futures	2961.6	2968.42	2960.51	2964.05	164839.0
2018-05-18 10:00:00	ES	Futures	2964.05	2968.69	2956.96	2962.96	202479.0
2018-05-18 11:00:00	ES	Futures	2962.96	2968.97	2962.14	2967.6	123367.0
2018-05-18 12:00:00	ES	Futures	2967.6	2967.6	2961.05	2964.05	69483.0
2018-05-18 13:00:00	ES	Futures	2964.33	2966.24	2961.05	2962.42	54148.0
2018-05-18 14:00:00	ES	Futures	2962.14	2965.42	2960.78	2964.33	52439.0
2018-05-18 15:00:00	ES	Futures	2964.6	2964.87	2961.05	2961.33	130484.0
2018-05-18 16:00:00	ES	Futures	2961.33	2962.96	2960.51	2960.78	45034.0
2018-05-18 00:00:00	NQ	Futures	8191.56	8192.15	8187.72	8188.9	584.0
2018-05-18 01:00:00	NQ	Futures	8189.2	8192.15	8184.76	8189.79	801.0
2018-05-18 02:00:00	NQ	Futures	8189.79	8194.22	8185.94	8193.92	1866.0
2018-05-18 03:00:00	NQ	Futures	8193.92	8198.95	8176.19	8179.44	3963.0
2018-05-18 04:00:00	NQ	Futures	8179.15	8185.65	8170.87	8183.58	2569.0
2018-05-18 05:00:00	NQ	Futures	8183.28	8190.97	8177.08	8185.35	2551.0
2018-05-18 06:00:00	NQ	Futures	8185.06	8189.79	8181.51	8182.4	1595.0
2018-05-18 07:00:00	NQ	Futures	8182.1	8183.88	8172.05	8172.94	2384.0
2018-05-18 08:00:00	NQ	Futures	8172.94	8173.83	8120.04	8120.93	17710.0
2018-05-18 09:00:00	NQ	Futures	8120.93	8151.07	8119.15	8133.93	51842.0
2018-05-18 10:00:00	NQ	Futures	8133.64	8150.78	8112.06	8132.75	66910.0
2018-05-18 11:00:00	NQ	Futures	8132.75	8163.48	8130.68	8155.5	48480.0
2018-05-18 12:00:00	NQ	Futures	8155.8	8156.1	8135.7	8145.75	27812.0
2018-05-18 13:00:00	NQ	Futures	8146.05	8150.19	8130.09	8135.41	21384.0
2018-05-18 14:00:00	NQ	Futures	8135.11	8142.21	8129.2	8138.36	14668.0
2018-05-18 15:00:00	NQ	Futures	8138.07	8139.55	8124.18	8125.66	27317.0
2018-05-18 16:00:00	NQ	Futures	8125.36	8129.79	8123.29	8125.66	6959.0
2018-05-18 00:00:00	YM	Futures	26897.5	26897.5	26880.2	26884.5	399.0
2018-05-18 01:00:00	YM	Futures	26885.6	26896.5	26878.0	26891.0	974.0
2018-05-18 02:00:00	YM	Futures	26891.0	26893.2	26876.9	26891.0	1511.0
2018-05-18 03:00:00	YM	Futures	26891.0	26899.7	26831.3	26861.7	3882.0
2018-05-18 04:00:00	YM	Futures	26861.7	26875.8	26840.0	26866.0	1805.0
2018-05-18 05:00:00	YM	Futures	26865.0	26914.9	26850.8	26910.6	5007.0
2018-05-18 06:00:00	YM	Futures	26910.6	26936.6	26905.1	26908.4	2976.0
2018-05-18 07:00:00	YM	Futures	26909.5	26919.3	26886.7	26899.7	2634.0
2018-05-18 08:00:00	YM	Futures	26899.7	26905.1	26808.5	26812.8	9214.0
2018-05-18 09:00:00	YM	Futures	26811.7	26876.9	26805.2	26844.3	24619.0
2018-05-18 10:00:00	YM	Futures	26843.2	26900.8	26775.9	26849.8	31423.0
2018-05-18 11:00:00	YM	Futures	26850.8	26883.4	26831.3	26873.6	19319.0
2018-05-18 12:00:00	YM	Futures	26874.7	26874.7	26821.5	26853.0	9864.0
2018-05-18 13:00:00	YM	Futures	26853.0	26873.6	26819.3	26841.1	9480.0
2018-05-18 14:00:00	YM	Futures	26841.1	26867.1	26826.9	26861.7	6949.0
2018-05-18 15:00:00	YM	Futures	26860.6	26862.8	26833.5	26837.8	12707.0

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

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