PREVIEW / futures_1hour / 2018-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-24.parquet
  size:    58 KB
  rows:    1,740

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-10-24 00:00:00	ES	Futures	2989.53	2991.44	2988.44	2989.8	10496.0
2018-10-24 01:00:00	ES	Futures	2989.8	2990.35	2979.47	2980.28	15346.0
2018-10-24 02:00:00	ES	Futures	2980.28	2980.83	2971.85	2972.12	18515.0
2018-10-24 03:00:00	ES	Futures	2972.12	2972.94	2960.7	2967.5	53874.0
2018-10-24 04:00:00	ES	Futures	2967.5	2969.95	2958.8	2959.61	42460.0
2018-10-24 05:00:00	ES	Futures	2959.34	2969.13	2958.52	2968.04	35334.0
2018-10-24 06:00:00	ES	Futures	2968.32	2972.4	2966.96	2972.12	22758.0
2018-10-24 07:00:00	ES	Futures	2972.4	2986.0	2970.22	2985.72	45034.0
2018-10-24 08:00:00	ES	Futures	2986.0	2988.17	2980.28	2983.55	40967.0
2018-10-24 09:00:00	ES	Futures	2983.55	2984.91	2971.58	2974.3	188793.0
2018-10-24 10:00:00	ES	Futures	2974.3	2977.84	2960.16	2960.7	282649.0
2018-10-24 11:00:00	ES	Futures	2960.7	2968.86	2941.66	2965.87	383440.0
2018-10-24 12:00:00	ES	Futures	2965.87	2967.5	2947.1	2954.99	163011.0
2018-10-24 13:00:00	ES	Futures	2954.72	2954.99	2934.32	2938.4	263332.0
2018-10-24 14:00:00	ES	Futures	2938.12	2950.64	2929.69	2935.4	292083.0
2018-10-24 15:00:00	ES	Futures	2935.13	2935.4	2885.63	2891.61	659127.0
2018-10-24 16:00:00	ES	Futures	2891.61	2910.65	2889.71	2910.11	177000.0
2018-10-24 18:00:00	ES	Futures	2909.02	2909.56	2900.32	2908.2	17993.0
2018-10-24 19:00:00	ES	Futures	2907.93	2910.65	2892.7	2898.14	19664.0
2018-10-24 20:00:00	ES	Futures	2898.41	2906.84	2898.41	2905.48	22870.0
2018-10-24 21:00:00	ES	Futures	2905.76	2907.93	2898.96	2904.94	26824.0
2018-10-24 22:00:00	ES	Futures	2904.94	2913.1	2902.22	2910.11	16001.0
2018-10-24 23:00:00	ES	Futures	2910.11	2912.01	2906.03	2907.93	8702.0
2018-10-24 00:00:00	NQ	Futures	8393.77	8397.0	8384.97	8391.42	3780.0
2018-10-24 01:00:00	NQ	Futures	8392.01	8393.77	8345.37	8353.0	6204.0
2018-10-24 02:00:00	NQ	Futures	8352.41	8356.52	8317.8	8321.91	5833.0
2018-10-24 03:00:00	NQ	Futures	8320.74	8330.71	8291.7	8313.99	13025.0
2018-10-24 04:00:00	NQ	Futures	8313.11	8321.32	8276.74	8278.21	14111.0
2018-10-24 05:00:00	NQ	Futures	8277.91	8311.64	8274.1	8304.6	13660.0
2018-10-24 06:00:00	NQ	Futures	8304.6	8326.02	8300.79	8324.55	8376.0
2018-10-24 07:00:00	NQ	Futures	8324.84	8384.38	8318.98	8384.38	17534.0
2018-10-24 08:00:00	NQ	Futures	8383.8	8387.32	8357.69	8375.29	17131.0
2018-10-24 09:00:00	NQ	Futures	8375.29	8381.16	8304.02	8318.98	75014.0
2018-10-24 10:00:00	NQ	Futures	8318.1	8342.73	8277.33	8279.09	92244.0
2018-10-24 11:00:00	NQ	Futures	8279.38	8288.18	8193.44	8275.57	114939.0
2018-10-24 12:00:00	NQ	Futures	8275.27	8279.97	8211.33	8237.14	65121.0
2018-10-24 13:00:00	NQ	Futures	8236.85	8237.14	8146.21	8153.84	100233.0
2018-10-24 14:00:00	NQ	Futures	8153.84	8183.46	8124.8	8139.76	87697.0
2018-10-24 15:00:00	NQ	Futures	8139.47	8139.76	7961.43	7976.09	163074.0
2018-10-24 16:00:00	NQ	Futures	7976.09	8069.07	7970.52	8067.61	49771.0
2018-10-24 18:00:00	NQ	Futures	8070.25	8074.35	8029.18	8058.51	6989.0
2018-10-24 19:00:00	NQ	Futures	8059.1	8065.55	7997.8	8016.86	7741.0
2018-10-24 20:00:00	NQ	Futures	8017.16	8064.38	8016.28	8060.86	8240.0
2018-10-24 21:00:00	NQ	Futures	8061.15	8076.7	8031.82	8057.63	8755.0
2018-10-24 22:00:00	NQ	Futures	8057.34	8087.55	8043.26	8072.01	6631.0
2018-10-24 23:00:00	NQ	Futures	8071.42	8072.59	8051.47	8061.15	3836.0
2018-10-24 00:00:00	YM	Futures	27434.4	27469.2	27425.7	27451.8	1533.0
2018-10-24 01:00:00	YM	Futures	27454.0	27459.4	27356.2	27362.7	3259.0
2018-10-24 02:00:00	YM	Futures	27363.8	27371.4	27285.6	27286.7	3960.0
2018-10-24 03:00:00	YM	Futures	27285.6	27303.0	27187.8	27245.4	9624.0

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

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