PREVIEW / futures_1hour / 2018-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-01.parquet
  size:    57 KB
  rows:    1,742

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-11-01 00:00:00	ES	Futures	2960.16	2960.7	2955.26	2956.62	4620.0
2018-11-01 01:00:00	ES	Futures	2956.62	2957.71	2953.63	2955.53	5572.0
2018-11-01 02:00:00	ES	Futures	2955.53	2955.53	2946.28	2948.73	10959.0
2018-11-01 03:00:00	ES	Futures	2949.0	2953.08	2945.47	2949.55	14413.0
2018-11-01 04:00:00	ES	Futures	2949.55	2959.88	2947.92	2957.98	31940.0
2018-11-01 05:00:00	ES	Futures	2957.98	2962.88	2955.8	2962.6	20708.0
2018-11-01 06:00:00	ES	Futures	2962.6	2967.23	2960.43	2964.24	21823.0
2018-11-01 07:00:00	ES	Futures	2964.24	2966.68	2961.79	2962.33	18198.0
2018-11-01 08:00:00	ES	Futures	2962.33	2964.51	2954.17	2955.8	39825.0
2018-11-01 09:00:00	ES	Futures	2955.53	2965.87	2950.64	2956.08	230616.0
2018-11-01 10:00:00	ES	Futures	2956.08	2972.67	2946.01	2970.49	358814.0
2018-11-01 11:00:00	ES	Futures	2970.49	2975.39	2964.24	2969.4	223557.0
2018-11-01 12:00:00	ES	Futures	2969.4	2975.39	2965.32	2975.12	140872.0
2018-11-01 13:00:00	ES	Futures	2974.84	2977.29	2969.13	2972.67	119224.0
2018-11-01 14:00:00	ES	Futures	2972.67	2977.02	2968.32	2975.93	107038.0
2018-11-01 15:00:00	ES	Futures	2976.2	2982.46	2971.85	2979.74	254170.0
2018-11-01 16:00:00	ES	Futures	2979.74	2980.01	2965.6	2974.57	95127.0
2018-11-01 18:00:00	ES	Futures	2963.69	2969.4	2962.33	2969.13	13120.0
2018-11-01 19:00:00	ES	Futures	2969.13	2973.48	2968.32	2973.48	10653.0
2018-11-01 20:00:00	ES	Futures	2973.21	2981.64	2972.67	2977.29	16652.0
2018-11-01 21:00:00	ES	Futures	2977.02	2977.56	2971.04	2972.67	13298.0
2018-11-01 22:00:00	ES	Futures	2972.67	2975.39	2970.22	2973.76	6454.0
2018-11-01 23:00:00	ES	Futures	2973.48	2973.76	2970.49	2971.04	3928.0
2018-11-01 00:00:00	NQ	Futures	8215.73	8218.66	8194.9	8199.3	3381.0
2018-11-01 01:00:00	NQ	Futures	8199.6	8205.17	8187.86	8194.02	3940.0
2018-11-01 02:00:00	NQ	Futures	8194.32	8194.32	8155.31	8167.04	6089.0
2018-11-01 03:00:00	NQ	Futures	8167.04	8185.52	8156.48	8168.8	7795.0
2018-11-01 04:00:00	NQ	Futures	8168.51	8206.34	8163.81	8199.6	11335.0
2018-11-01 05:00:00	NQ	Futures	8199.89	8216.9	8190.8	8216.61	8661.0
2018-11-01 06:00:00	NQ	Futures	8216.61	8231.27	8207.81	8220.42	9632.0
2018-11-01 07:00:00	NQ	Futures	8220.42	8229.22	8208.69	8211.33	9340.0
2018-11-01 08:00:00	NQ	Futures	8212.21	8221.6	8180.24	8186.4	23006.0
2018-11-01 09:00:00	NQ	Futures	8186.4	8228.64	8147.39	8175.25	87520.0
2018-11-01 10:00:00	NQ	Futures	8174.08	8239.49	8138.59	8228.64	106964.0
2018-11-01 11:00:00	NQ	Futures	8228.05	8267.35	8208.69	8246.23	70569.0
2018-11-01 12:00:00	NQ	Futures	8245.94	8275.57	8231.27	8272.34	42102.0
2018-11-01 13:00:00	NQ	Futures	8272.05	8297.86	8258.85	8280.26	46920.0
2018-11-01 14:00:00	NQ	Futures	8280.55	8293.75	8263.54	8287.0	33491.0
2018-11-01 15:00:00	NQ	Futures	8286.12	8305.48	8271.46	8298.74	46911.0
2018-11-01 16:00:00	NQ	Futures	8298.74	8306.36	8213.38	8246.82	31553.0
2018-11-01 18:00:00	NQ	Futures	8197.84	8213.68	8179.65	8213.09	7880.0
2018-11-01 19:00:00	NQ	Futures	8213.38	8233.03	8210.16	8232.15	7286.0
2018-11-01 20:00:00	NQ	Futures	8231.86	8257.97	8230.1	8246.23	9435.0
2018-11-01 21:00:00	NQ	Futures	8245.94	8247.41	8224.82	8232.45	7332.0
2018-11-01 22:00:00	NQ	Futures	8232.15	8240.95	8221.01	8236.85	4458.0
2018-11-01 23:00:00	NQ	Futures	8237.14	8237.14	8225.12	8228.34	2279.0
2018-11-01 00:00:00	YM	Futures	27348.6	27355.1	27307.3	27322.5	1237.0
2018-11-01 01:00:00	YM	Futures	27320.4	27332.3	27289.9	27305.1	1508.0
2018-11-01 02:00:00	YM	Futures	27303.0	27304.1	27233.4	27262.8	2896.0
2018-11-01 03:00:00	YM	Futures	27262.8	27300.8	27228.0	27263.9	3436.0

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

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