PREVIEW / futures_1hour / 2018-05-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	2973.88	2975.24	2973.33	2973.88	1604.0
2018-05-24 01:00:00	ES	Futures	2973.61	2977.7	2973.33	2976.06	5527.0
2018-05-24 02:00:00	ES	Futures	2976.06	2979.61	2974.42	2978.79	8206.0
2018-05-24 03:00:00	ES	Futures	2978.79	2983.16	2977.7	2982.34	17459.0
2018-05-24 04:00:00	ES	Futures	2982.34	2983.7	2980.43	2983.43	8660.0
2018-05-24 05:00:00	ES	Futures	2983.43	2983.7	2980.97	2982.34	6556.0
2018-05-24 06:00:00	ES	Futures	2982.07	2982.61	2980.16	2982.07	6364.0
2018-05-24 07:00:00	ES	Futures	2982.07	2982.07	2977.15	2977.97	10884.0
2018-05-24 08:00:00	ES	Futures	2977.97	2978.52	2974.7	2976.34	20296.0
2018-05-24 09:00:00	ES	Futures	2976.34	2980.7	2962.42	2965.96	218491.0
2018-05-24 10:00:00	ES	Futures	2965.96	2970.33	2953.96	2955.59	251723.0
2018-05-24 11:00:00	ES	Futures	2955.59	2970.88	2953.68	2970.6	189220.0
2018-05-24 12:00:00	ES	Futures	2970.6	2974.7	2968.42	2973.06	87150.0
2018-05-24 13:00:00	ES	Futures	2972.79	2978.25	2972.51	2976.88	77513.0
2018-05-24 14:00:00	ES	Futures	2976.61	2979.06	2973.61	2975.79	60510.0
2018-05-24 15:00:00	ES	Futures	2975.52	2979.61	2972.79	2976.88	139795.0
2018-05-24 16:00:00	ES	Futures	2976.61	2978.25	2976.34	2977.15	51039.0
2018-05-24 18:00:00	ES	Futures	2976.61	2979.06	2976.61	2977.97	4347.0
2018-05-24 19:00:00	ES	Futures	2977.97	2980.16	2977.7	2979.88	2226.0
2018-05-24 20:00:00	ES	Futures	2979.88	2982.88	2979.34	2981.52	7853.0
2018-05-24 21:00:00	ES	Futures	2981.79	2988.62	2980.7	2986.16	12613.0
2018-05-24 22:00:00	ES	Futures	2986.16	2986.98	2985.07	2985.61	4363.0
2018-05-24 23:00:00	ES	Futures	2985.34	2987.52	2985.07	2986.16	2761.0
2018-05-24 00:00:00	NQ	Futures	8201.02	8204.86	8196.88	8198.36	1037.0
2018-05-24 01:00:00	NQ	Futures	8198.06	8214.61	8197.17	8208.41	2250.0
2018-05-24 02:00:00	NQ	Futures	8208.41	8224.36	8204.86	8221.11	3027.0
2018-05-24 03:00:00	NQ	Futures	8221.41	8245.35	8216.38	8240.62	7563.0
2018-05-24 04:00:00	NQ	Futures	8240.62	8242.39	8229.98	8241.8	3105.0
2018-05-24 05:00:00	NQ	Futures	8241.8	8242.1	8231.16	8237.37	2350.0
2018-05-24 06:00:00	NQ	Futures	8237.66	8238.85	8227.91	8233.53	2045.0
2018-05-24 07:00:00	NQ	Futures	8233.82	8234.12	8218.45	8222.89	5038.0
2018-05-24 08:00:00	NQ	Futures	8222.89	8225.84	8206.63	8215.2	8043.0
2018-05-24 09:00:00	NQ	Futures	8215.2	8237.66	8172.35	8181.81	67990.0
2018-05-24 10:00:00	NQ	Futures	8181.81	8198.95	8141.32	8144.57	82463.0
2018-05-24 11:00:00	NQ	Futures	8144.57	8199.24	8139.25	8198.36	55425.0
2018-05-24 12:00:00	NQ	Futures	8198.36	8220.82	8193.04	8211.95	34503.0
2018-05-24 13:00:00	NQ	Futures	8211.95	8227.02	8209.29	8221.41	25944.0
2018-05-24 14:00:00	NQ	Futures	8221.7	8235.59	8214.91	8225.84	23979.0
2018-05-24 15:00:00	NQ	Futures	8225.84	8238.25	8212.25	8222.0	32864.0
2018-05-24 16:00:00	NQ	Futures	8222.0	8226.43	8218.45	8222.0	5530.0
2018-05-24 18:00:00	NQ	Futures	8221.7	8231.16	8221.41	8224.66	1184.0
2018-05-24 19:00:00	NQ	Futures	8225.25	8233.53	8224.96	8231.75	1085.0
2018-05-24 20:00:00	NQ	Futures	8232.34	8244.76	8230.87	8239.73	3126.0
2018-05-24 21:00:00	NQ	Futures	8239.73	8279.33	8235.59	8264.26	6313.0
2018-05-24 22:00:00	NQ	Futures	8264.56	8268.99	8257.46	8258.94	2234.0
2018-05-24 23:00:00	NQ	Futures	8258.94	8265.44	8258.35	8260.12	1436.0
2018-05-24 00:00:00	YM	Futures	26925.8	26936.6	26920.3	26925.8	481.0
2018-05-24 01:00:00	YM	Futures	26924.7	26956.2	26918.2	26942.1	1308.0
2018-05-24 02:00:00	YM	Futures	26942.1	26970.3	26930.1	26962.7	2171.0
2018-05-24 03:00:00	YM	Futures	26962.7	27002.9	26949.7	26995.3	3542.0

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

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