PREVIEW / futures_1hour / 2019-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-07.parquet
  size:    57 KB
  rows:    1,775

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
2019-02-07 00:00:00	ES	Futures	2958.37	2959.46	2957.56	2959.19	3679.0
2019-02-07 01:00:00	ES	Futures	2959.19	2960.0	2958.37	2959.73	2693.0
2019-02-07 02:00:00	ES	Futures	2960.0	2960.0	2955.11	2955.93	10034.0
2019-02-07 03:00:00	ES	Futures	2955.93	2960.0	2955.93	2959.73	13412.0
2019-02-07 04:00:00	ES	Futures	2959.73	2961.09	2958.1	2960.81	11724.0
2019-02-07 05:00:00	ES	Futures	2961.09	2961.09	2948.59	2951.04	29006.0
2019-02-07 06:00:00	ES	Futures	2950.77	2951.85	2943.98	2946.15	32541.0
2019-02-07 07:00:00	ES	Futures	2945.88	2949.14	2944.79	2945.88	28358.0
2019-02-07 08:00:00	ES	Futures	2945.61	2949.14	2942.62	2948.59	38141.0
2019-02-07 09:00:00	ES	Futures	2948.59	2949.95	2939.9	2944.25	223401.0
2019-02-07 10:00:00	ES	Futures	2944.25	2953.21	2934.2	2934.74	325413.0
2019-02-07 11:00:00	ES	Futures	2934.74	2936.92	2919.26	2920.08	343340.0
2019-02-07 12:00:00	ES	Futures	2920.08	2928.22	2917.36	2920.35	210509.0
2019-02-07 13:00:00	ES	Futures	2920.35	2933.11	2919.81	2929.58	157467.0
2019-02-07 14:00:00	ES	Futures	2929.58	2932.57	2921.16	2928.5	141964.0
2019-02-07 15:00:00	ES	Futures	2928.22	2938.82	2925.51	2938.0	204517.0
2019-02-07 16:00:00	ES	Futures	2937.73	2939.36	2935.56	2936.64	64634.0
2019-02-07 18:00:00	ES	Futures	2935.29	2936.64	2929.85	2930.4	10147.0
2019-02-07 19:00:00	ES	Futures	2930.4	2933.38	2929.04	2930.94	14819.0
2019-02-07 20:00:00	ES	Futures	2930.94	2931.76	2925.51	2926.87	14956.0
2019-02-07 21:00:00	ES	Futures	2927.14	2927.41	2922.25	2927.14	12727.0
2019-02-07 22:00:00	ES	Futures	2927.14	2928.77	2924.42	2925.24	5935.0
2019-02-07 23:00:00	ES	Futures	2925.24	2926.32	2923.61	2924.15	3541.0
2019-02-07 00:00:00	NQ	Futures	8156.47	8158.51	8152.67	8157.34	1534.0
2019-02-07 01:00:00	NQ	Futures	8157.34	8159.09	8152.67	8157.93	1330.0
2019-02-07 02:00:00	NQ	Futures	8157.93	8159.09	8140.39	8142.15	4596.0
2019-02-07 03:00:00	NQ	Futures	8142.73	8155.59	8141.86	8155.59	5060.0
2019-02-07 04:00:00	NQ	Futures	8155.3	8162.02	8150.04	8161.72	5190.0
2019-02-07 05:00:00	NQ	Futures	8162.02	8162.02	8124.32	8133.09	9386.0
2019-02-07 06:00:00	NQ	Futures	8132.8	8137.18	8117.02	8124.91	10035.0
2019-02-07 07:00:00	NQ	Futures	8124.62	8135.43	8119.65	8121.69	8473.0
2019-02-07 08:00:00	NQ	Futures	8121.99	8130.17	8112.05	8126.08	11390.0
2019-02-07 09:00:00	NQ	Futures	8126.08	8129.88	8079.04	8103.29	78885.0
2019-02-07 10:00:00	NQ	Futures	8102.99	8133.67	8076.11	8078.16	96808.0
2019-02-07 11:00:00	NQ	Futures	8077.87	8089.85	8025.56	8026.44	108924.0
2019-02-07 12:00:00	NQ	Futures	8026.15	8053.32	8013.29	8027.03	62949.0
2019-02-07 13:00:00	NQ	Futures	8027.32	8063.55	8025.27	8053.91	52278.0
2019-02-07 14:00:00	NQ	Futures	8053.61	8066.18	8029.36	8050.69	52866.0
2019-02-07 15:00:00	NQ	Futures	8050.4	8077.28	8038.71	8076.11	56187.0
2019-02-07 16:00:00	NQ	Futures	8076.11	8081.37	8067.35	8069.69	11145.0
2019-02-07 18:00:00	NQ	Futures	8066.76	8068.52	8043.68	8046.89	3239.0
2019-02-07 19:00:00	NQ	Futures	8046.89	8054.78	8041.93	8046.6	4399.0
2019-02-07 20:00:00	NQ	Futures	8046.89	8049.82	8027.03	8033.16	5632.0
2019-02-07 21:00:00	NQ	Futures	8032.87	8035.5	8020.31	8034.91	4191.0
2019-02-07 22:00:00	NQ	Futures	8035.21	8040.17	8024.1	8028.78	2889.0
2019-02-07 23:00:00	NQ	Futures	8029.36	8032.28	8022.93	8026.44	1773.0
2019-02-07 00:00:00	YM	Futures	27443.4	27451.0	27435.8	27446.7	1052.0
2019-02-07 01:00:00	YM	Futures	27447.8	27463.0	27441.2	27459.7	1048.0
2019-02-07 02:00:00	YM	Futures	27459.7	27460.8	27419.5	27423.9	3431.0
2019-02-07 03:00:00	YM	Futures	27425.0	27464.0	27425.0	27464.0	4377.0

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

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