PREVIEW / futures_1hour / 2018-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-02.parquet
  size:    55 KB
  rows:    1,670

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-07-02 00:00:00	ES	Futures	2962.25	2962.53	2957.35	2960.07	8223.0
2018-07-02 01:00:00	ES	Futures	2960.35	2960.62	2950.54	2951.35	12875.0
2018-07-02 02:00:00	ES	Futures	2951.35	2954.9	2944.82	2949.72	21206.0
2018-07-02 03:00:00	ES	Futures	2949.99	2951.08	2941.0	2945.91	35767.0
2018-07-02 04:00:00	ES	Futures	2945.91	2953.53	2945.36	2952.17	19287.0
2018-07-02 05:00:00	ES	Futures	2952.44	2953.53	2947.81	2950.54	13763.0
2018-07-02 06:00:00	ES	Futures	2950.27	2952.17	2945.36	2951.08	15433.0
2018-07-02 07:00:00	ES	Futures	2951.08	2952.99	2949.18	2951.9	14831.0
2018-07-02 08:00:00	ES	Futures	2951.63	2952.17	2946.72	2948.09	22110.0
2018-07-02 09:00:00	ES	Futures	2947.81	2952.44	2943.18	2952.17	154221.0
2018-07-02 10:00:00	ES	Futures	2952.44	2960.07	2947.0	2957.62	191153.0
2018-07-02 11:00:00	ES	Futures	2957.62	2963.34	2951.35	2953.53	125133.0
2018-07-02 12:00:00	ES	Futures	2953.53	2955.44	2948.09	2952.99	71502.0
2018-07-02 13:00:00	ES	Futures	2952.99	2958.98	2947.0	2957.62	86669.0
2018-07-02 14:00:00	ES	Futures	2957.35	2966.61	2957.08	2960.07	109647.0
2018-07-02 15:00:00	ES	Futures	2959.8	2973.7	2958.17	2972.33	171837.0
2018-07-02 16:00:00	ES	Futures	2972.33	2973.15	2970.43	2971.79	55918.0
2018-07-02 18:00:00	ES	Futures	2972.33	2972.61	2969.88	2970.7	4077.0
2018-07-02 19:00:00	ES	Futures	2970.7	2972.33	2970.16	2972.33	2198.0
2018-07-02 20:00:00	ES	Futures	2972.33	2972.88	2969.34	2970.43	5254.0
2018-07-02 21:00:00	ES	Futures	2970.7	2978.33	2965.8	2967.98	25810.0
2018-07-02 22:00:00	ES	Futures	2967.7	2973.97	2966.61	2969.07	10722.0
2018-07-02 23:00:00	ES	Futures	2969.34	2971.24	2964.98	2970.7	10579.0
2018-07-02 00:00:00	NQ	Futures	8317.31	8318.49	8301.12	8306.42	2499.0
2018-07-02 01:00:00	NQ	Futures	8307.01	8307.6	8279.04	8279.33	4327.0
2018-07-02 02:00:00	NQ	Futures	8280.22	8286.69	8248.42	8259.61	7621.0
2018-07-02 03:00:00	NQ	Futures	8259.61	8261.08	8234.58	8249.3	11261.0
2018-07-02 04:00:00	NQ	Futures	8249.01	8274.33	8247.83	8269.62	7304.0
2018-07-02 05:00:00	NQ	Futures	8269.62	8273.74	8257.55	8264.32	4735.0
2018-07-02 06:00:00	NQ	Futures	8264.02	8271.09	8251.07	8268.73	4809.0
2018-07-02 07:00:00	NQ	Futures	8268.44	8274.62	8262.55	8268.73	4820.0
2018-07-02 08:00:00	NQ	Futures	8268.44	8269.62	8252.54	8257.55	7356.0
2018-07-02 09:00:00	NQ	Futures	8257.55	8288.46	8228.99	8284.34	64876.0
2018-07-02 10:00:00	NQ	Futures	8284.93	8319.96	8272.27	8305.54	70145.0
2018-07-02 11:00:00	NQ	Futures	8305.54	8325.26	8283.75	8292.58	42179.0
2018-07-02 12:00:00	NQ	Futures	8292.29	8302.3	8281.98	8296.41	22063.0
2018-07-02 13:00:00	NQ	Futures	8296.7	8329.97	8276.98	8326.44	24407.0
2018-07-02 14:00:00	NQ	Futures	8326.44	8366.19	8325.26	8336.74	37789.0
2018-07-02 15:00:00	NQ	Futures	8336.74	8384.15	8334.09	8382.08	37063.0
2018-07-02 16:00:00	NQ	Futures	8382.08	8384.73	8377.08	8380.02	9002.0
2018-07-02 18:00:00	NQ	Futures	8377.67	8379.44	8370.9	8371.49	1630.0
2018-07-02 19:00:00	NQ	Futures	8371.49	8380.61	8370.31	8379.73	1034.0
2018-07-02 20:00:00	NQ	Futures	8379.73	8380.32	8366.48	8371.19	2209.0
2018-07-02 21:00:00	NQ	Futures	8371.49	8404.46	8361.77	8367.07	8903.0
2018-07-02 22:00:00	NQ	Futures	8366.78	8387.09	8363.24	8372.37	3451.0
2018-07-02 23:00:00	NQ	Futures	8372.66	8380.02	8357.35	8377.37	3284.0
2018-07-02 00:00:00	YM	Futures	26278.3	26281.6	26239.2	26267.5	3523.0
2018-07-02 01:00:00	YM	Futures	26269.6	26269.6	26169.6	26187.0	4129.0
2018-07-02 02:00:00	YM	Futures	26188.1	26214.2	26144.6	26179.4	5016.0
2018-07-02 03:00:00	YM	Futures	26178.3	26214.2	26119.6	26184.8	8446.0

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

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