PREVIEW / futures_1hour / 2018-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-26.parquet
  size:    54 KB
  rows:    1,702

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-09-26 00:00:00	ES	Futures	3185.37	3185.64	3184.56	3185.1	2021.0
2018-09-26 01:00:00	ES	Futures	3185.1	3186.46	3184.83	3185.37	4558.0
2018-09-26 02:00:00	ES	Futures	3185.37	3185.64	3183.2	3183.74	5617.0
2018-09-26 03:00:00	ES	Futures	3183.74	3184.28	3181.84	3184.28	11864.0
2018-09-26 04:00:00	ES	Futures	3184.01	3186.19	3183.47	3184.83	7722.0
2018-09-26 05:00:00	ES	Futures	3185.1	3185.64	3183.74	3184.56	9628.0
2018-09-26 06:00:00	ES	Futures	3184.56	3185.92	3184.01	3185.37	14255.0
2018-09-26 07:00:00	ES	Futures	3185.37	3185.37	3182.38	3182.65	10507.0
2018-09-26 08:00:00	ES	Futures	3182.65	3183.2	3181.56	3182.38	11485.0
2018-09-26 09:00:00	ES	Futures	3182.11	3184.01	3178.57	3182.11	117880.0
2018-09-26 10:00:00	ES	Futures	3182.38	3184.83	3177.21	3184.01	117750.0
2018-09-26 11:00:00	ES	Futures	3184.01	3186.73	3183.74	3185.1	66857.0
2018-09-26 12:00:00	ES	Futures	3185.1	3187.55	3183.74	3187.55	41337.0
2018-09-26 13:00:00	ES	Futures	3187.55	3187.82	3184.56	3184.83	69348.0
2018-09-26 14:00:00	ES	Futures	3185.1	3194.35	3183.74	3185.1	226929.0
2018-09-26 15:00:00	ES	Futures	3185.1	3187.55	3163.34	3168.24	431308.0
2018-09-26 16:00:00	ES	Futures	3168.24	3169.87	3163.88	3168.24	91489.0
2018-09-26 18:00:00	ES	Futures	3167.69	3170.41	3166.6	3170.14	8070.0
2018-09-26 19:00:00	ES	Futures	3169.87	3170.68	3168.51	3170.14	5122.0
2018-09-26 20:00:00	ES	Futures	3170.14	3171.23	3169.32	3170.96	5327.0
2018-09-26 21:00:00	ES	Futures	3170.96	3171.77	3169.87	3171.77	5963.0
2018-09-26 22:00:00	ES	Futures	3171.5	3172.32	3170.68	3172.04	4128.0
2018-09-26 23:00:00	ES	Futures	3171.77	3172.04	3168.24	3169.32	5994.0
2018-09-26 00:00:00	NQ	Futures	8944.03	8945.2	8941.39	8943.15	1235.0
2018-09-26 01:00:00	NQ	Futures	8943.15	8950.77	8942.56	8946.08	2302.0
2018-09-26 02:00:00	NQ	Futures	8946.37	8947.25	8941.39	8942.85	2788.0
2018-09-26 03:00:00	NQ	Futures	8943.15	8944.03	8934.35	8941.1	3570.0
2018-09-26 04:00:00	NQ	Futures	8940.8	8947.25	8937.87	8943.44	3264.0
2018-09-26 05:00:00	NQ	Futures	8943.73	8946.08	8937.58	8939.04	3834.0
2018-09-26 06:00:00	NQ	Futures	8938.75	8942.85	8933.47	8933.76	5825.0
2018-09-26 07:00:00	NQ	Futures	8934.35	8935.23	8924.38	8924.38	5485.0
2018-09-26 08:00:00	NQ	Futures	8924.38	8929.36	8920.56	8928.19	4984.0
2018-09-26 09:00:00	NQ	Futures	8928.19	8937.87	8908.24	8932.0	52568.0
2018-09-26 10:00:00	NQ	Futures	8931.71	8949.31	8917.04	8945.79	54379.0
2018-09-26 11:00:00	NQ	Futures	8946.08	8966.91	8945.49	8960.16	34510.0
2018-09-26 12:00:00	NQ	Futures	8959.87	8960.45	8947.55	8959.28	16094.0
2018-09-26 13:00:00	NQ	Futures	8958.99	8963.97	8946.67	8952.24	17435.0
2018-09-26 14:00:00	NQ	Futures	8952.83	8996.53	8949.31	8968.96	76065.0
2018-09-26 15:00:00	NQ	Futures	8969.25	8977.47	8895.63	8908.83	87062.0
2018-09-26 16:00:00	NQ	Futures	8908.83	8912.64	8890.35	8905.31	17101.0
2018-09-26 18:00:00	NQ	Futures	8905.31	8920.27	8902.08	8918.51	2795.0
2018-09-26 19:00:00	NQ	Futures	8918.8	8921.74	8914.4	8921.44	2292.0
2018-09-26 20:00:00	NQ	Futures	8921.15	8929.36	8919.98	8926.72	3005.0
2018-09-26 21:00:00	NQ	Futures	8926.72	8931.42	8921.74	8929.95	2490.0
2018-09-26 22:00:00	NQ	Futures	8930.24	8934.94	8926.43	8931.71	1944.0
2018-09-26 23:00:00	NQ	Futures	8931.71	8932.59	8910.59	8917.63	4388.0
2018-09-26 00:00:00	YM	Futures	28874.1	28875.2	28867.5	28871.9	442.0
2018-09-26 01:00:00	YM	Futures	28871.9	28879.5	28862.1	28869.7	1164.0
2018-09-26 02:00:00	YM	Futures	28869.7	28870.8	28836.0	28840.4	1755.0
2018-09-26 03:00:00	YM	Futures	28841.5	28844.7	28821.9	28844.7	2351.0

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

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