PREVIEW / futures_1hour / 2018-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-06.parquet
  size:    55 KB
  rows:    1,666

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-06 00:00:00	ES	Futures	2971.62	2974.36	2970.8	2973.81	2910.0
2018-03-06 01:00:00	ES	Futures	2973.81	2978.18	2972.17	2978.18	4164.0
2018-03-06 02:00:00	ES	Futures	2977.91	2981.74	2975.45	2980.92	14031.0
2018-03-06 03:00:00	ES	Futures	2980.92	2981.19	2975.45	2977.36	14135.0
2018-03-06 04:00:00	ES	Futures	2977.36	2979.55	2976.27	2978.73	8538.0
2018-03-06 05:00:00	ES	Futures	2978.73	2980.37	2976.0	2979.0	9608.0
2018-03-06 06:00:00	ES	Futures	2979.0	2989.66	2978.18	2987.75	36375.0
2018-03-06 07:00:00	ES	Futures	2987.75	2988.02	2982.01	2985.29	18165.0
2018-03-06 08:00:00	ES	Futures	2985.29	2986.93	2980.1	2981.74	33143.0
2018-03-06 09:00:00	ES	Futures	2981.74	2987.75	2973.54	2979.55	179338.0
2018-03-06 10:00:00	ES	Futures	2979.82	2983.1	2965.88	2968.07	229311.0
2018-03-06 11:00:00	ES	Futures	2968.34	2974.63	2963.15	2973.26	189559.0
2018-03-06 12:00:00	ES	Futures	2973.54	2982.56	2967.52	2982.28	118955.0
2018-03-06 13:00:00	ES	Futures	2982.28	2984.74	2974.63	2976.54	116549.0
2018-03-06 14:00:00	ES	Futures	2976.54	2985.29	2973.81	2982.56	102129.0
2018-03-06 15:00:00	ES	Futures	2982.28	2983.65	2975.45	2982.01	172607.0
2018-03-06 16:00:00	ES	Futures	2982.28	2982.83	2977.09	2978.18	52468.0
2018-03-06 18:00:00	ES	Futures	2951.94	2952.76	2941.01	2944.29	63784.0
2018-03-06 19:00:00	ES	Futures	2944.29	2946.48	2931.44	2937.46	38144.0
2018-03-06 20:00:00	ES	Futures	2937.73	2955.77	2936.64	2955.5	28551.0
2018-03-06 21:00:00	ES	Futures	2955.22	2957.14	2946.75	2949.21	18141.0
2018-03-06 22:00:00	ES	Futures	2948.94	2951.4	2943.74	2945.38	8836.0
2018-03-06 23:00:00	ES	Futures	2945.38	2949.48	2941.01	2947.57	10114.0
2018-03-06 00:00:00	NQ	Futures	8168.5	8178.29	8165.54	8177.7	2218.0
2018-03-06 01:00:00	NQ	Futures	8177.4	8186.59	8171.47	8186.3	2429.0
2018-03-06 02:00:00	NQ	Futures	8186.3	8196.98	8182.44	8193.71	5271.0
2018-03-06 03:00:00	NQ	Futures	8193.71	8195.2	8180.37	8187.48	5357.0
2018-03-06 04:00:00	NQ	Futures	8187.78	8194.6	8182.15	8191.64	3967.0
2018-03-06 05:00:00	NQ	Futures	8191.34	8200.53	8181.55	8195.79	4445.0
2018-03-06 06:00:00	NQ	Futures	8196.09	8216.85	8194.31	8212.99	9276.0
2018-03-06 07:00:00	NQ	Futures	8212.99	8213.29	8200.53	8212.1	5746.0
2018-03-06 08:00:00	NQ	Futures	8211.81	8214.18	8195.79	8202.02	8686.0
2018-03-06 09:00:00	NQ	Futures	8201.72	8226.04	8183.63	8220.41	62520.0
2018-03-06 10:00:00	NQ	Futures	8220.41	8232.57	8171.76	8176.81	77313.0
2018-03-06 11:00:00	NQ	Futures	8177.1	8190.15	8152.49	8189.56	63566.0
2018-03-06 12:00:00	NQ	Futures	8189.26	8212.69	8174.73	8212.1	36351.0
2018-03-06 13:00:00	NQ	Futures	8212.4	8218.33	8179.18	8186.59	33962.0
2018-03-06 14:00:00	NQ	Futures	8186.3	8212.1	8176.81	8202.91	30291.0
2018-03-06 15:00:00	NQ	Futures	8203.2	8205.58	8183.63	8202.91	32971.0
2018-03-06 16:00:00	NQ	Futures	8203.2	8207.95	8192.82	8197.87	9121.0
2018-03-06 18:00:00	NQ	Futures	8136.17	8136.47	8089.31	8098.21	14090.0
2018-03-06 19:00:00	NQ	Futures	8097.91	8103.55	8065.29	8080.71	14982.0
2018-03-06 20:00:00	NQ	Futures	8081.01	8139.14	8080.12	8138.25	11018.0
2018-03-06 21:00:00	NQ	Futures	8138.25	8143.0	8113.04	8120.16	8128.0
2018-03-06 22:00:00	NQ	Futures	8119.56	8125.5	8106.81	8111.85	4240.0
2018-03-06 23:00:00	NQ	Futures	8111.56	8119.27	8099.4	8115.12	3136.0
2018-03-06 00:00:00	YM	Futures	27031.8	27065.5	27025.3	27057.9	1806.0
2018-03-06 01:00:00	YM	Futures	27060.1	27101.4	27047.0	27101.4	2578.0
2018-03-06 02:00:00	YM	Futures	27101.4	27134.0	27067.7	27119.8	4009.0
2018-03-06 03:00:00	YM	Futures	27120.9	27124.2	27063.3	27088.3	4560.0

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

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