PREVIEW / futures_1hour / 2018-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-21.parquet
  size:    54 KB
  rows:    1,647

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-03-21 00:00:00	ES	Futures	2975.79	2977.7	2975.24	2977.15	1883.0
2018-03-21 01:00:00	ES	Futures	2977.15	2977.15	2974.15	2974.15	1686.0
2018-03-21 02:00:00	ES	Futures	2974.42	2976.88	2973.88	2975.79	3174.0
2018-03-21 03:00:00	ES	Futures	2975.79	2976.34	2972.51	2974.7	7312.0
2018-03-21 04:00:00	ES	Futures	2974.7	2974.7	2968.15	2969.79	13192.0
2018-03-21 05:00:00	ES	Futures	2970.06	2970.6	2966.78	2969.79	10098.0
2018-03-21 06:00:00	ES	Futures	2970.06	2974.15	2968.42	2972.51	11200.0
2018-03-21 07:00:00	ES	Futures	2972.51	2973.88	2966.24	2969.51	24892.0
2018-03-21 08:00:00	ES	Futures	2969.51	2971.42	2968.15	2971.15	19288.0
2018-03-21 09:00:00	ES	Futures	2971.15	2971.42	2964.05	2965.96	124109.0
2018-03-21 10:00:00	ES	Futures	2966.24	2972.51	2964.87	2970.06	109476.0
2018-03-21 11:00:00	ES	Futures	2969.79	2984.52	2968.69	2981.25	112998.0
2018-03-21 12:00:00	ES	Futures	2981.25	2984.25	2979.61	2983.43	74361.0
2018-03-21 13:00:00	ES	Futures	2983.7	2983.98	2975.52	2981.25	77651.0
2018-03-21 14:00:00	ES	Futures	2981.25	2995.44	2961.05	2968.69	411110.0
2018-03-21 15:00:00	ES	Futures	2968.69	2983.7	2963.24	2963.51	300646.0
2018-03-21 16:00:00	ES	Futures	2963.51	2967.88	2962.96	2967.06	64028.0
2018-03-21 18:00:00	ES	Futures	2967.33	2969.24	2966.78	2967.6	4316.0
2018-03-21 19:00:00	ES	Futures	2967.88	2968.42	2965.96	2967.6	2593.0
2018-03-21 20:00:00	ES	Futures	2967.6	2971.97	2966.78	2970.88	5424.0
2018-03-21 21:00:00	ES	Futures	2971.15	2976.06	2971.15	2972.51	9075.0
2018-03-21 22:00:00	ES	Futures	2972.24	2973.33	2967.33	2968.15	5901.0
2018-03-21 23:00:00	ES	Futures	2968.15	2969.24	2966.24	2967.6	3457.0
2018-03-21 00:00:00	NQ	Futures	8180.63	8184.47	8177.97	8182.99	855.0
2018-03-21 01:00:00	NQ	Futures	8182.69	8184.17	8175.9	8175.9	623.0
2018-03-21 02:00:00	NQ	Futures	8175.6	8181.81	8170.28	8177.97	1454.0
2018-03-21 03:00:00	NQ	Futures	8177.97	8180.92	8168.51	8175.6	2643.0
2018-03-21 04:00:00	NQ	Futures	8175.9	8175.9	8144.27	8150.19	5359.0
2018-03-21 05:00:00	NQ	Futures	8150.48	8152.55	8137.18	8148.41	4817.0
2018-03-21 06:00:00	NQ	Futures	8148.71	8159.05	8143.68	8147.82	3873.0
2018-03-21 07:00:00	NQ	Futures	8147.82	8157.28	8134.82	8143.98	6609.0
2018-03-21 08:00:00	NQ	Futures	8144.27	8153.73	8140.14	8152.55	6117.0
2018-03-21 09:00:00	NQ	Futures	8152.25	8158.76	8130.98	8150.48	46212.0
2018-03-21 10:00:00	NQ	Futures	8150.48	8178.85	8147.23	8153.44	58439.0
2018-03-21 11:00:00	NQ	Futures	8153.14	8190.67	8147.53	8181.51	32013.0
2018-03-21 12:00:00	NQ	Futures	8181.81	8191.86	8175.6	8190.08	17455.0
2018-03-21 13:00:00	NQ	Futures	8190.38	8191.56	8166.14	8175.9	20463.0
2018-03-21 14:00:00	NQ	Futures	8177.08	8216.98	8088.42	8120.34	130522.0
2018-03-21 15:00:00	NQ	Futures	8120.04	8164.08	8116.49	8122.11	88460.0
2018-03-21 16:00:00	NQ	Futures	8122.41	8140.73	8120.93	8136.3	10799.0
2018-03-21 18:00:00	NQ	Futures	8136.89	8147.23	8136.59	8142.5	1397.0
2018-03-21 19:00:00	NQ	Futures	8142.5	8142.5	8137.18	8138.36	1527.0
2018-03-21 20:00:00	NQ	Futures	8138.07	8156.1	8137.18	8154.32	3223.0
2018-03-21 21:00:00	NQ	Futures	8154.62	8174.42	8154.62	8159.94	5156.0
2018-03-21 22:00:00	NQ	Futures	8159.64	8162.01	8142.8	8146.05	3574.0
2018-03-21 23:00:00	NQ	Futures	8146.64	8150.19	8137.77	8141.61	2729.0
2018-03-21 00:00:00	YM	Futures	26919.3	26939.9	26916.0	26934.5	618.0
2018-03-21 01:00:00	YM	Futures	26933.4	26934.5	26904.1	26905.1	589.0
2018-03-21 02:00:00	YM	Futures	26905.1	26924.7	26898.6	26913.8	1392.0
2018-03-21 03:00:00	YM	Futures	26913.8	26917.1	26882.3	26896.5	2638.0

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

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