PREVIEW / futures_1hour / 2018-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-28.parquet
  size:    56 KB
  rows:    1,710

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-28 00:00:00	ES	Futures	2922.62	2923.44	2921.26	2923.16	3589.0
2018-11-28 01:00:00	ES	Futures	2923.16	2929.42	2922.89	2928.33	8244.0
2018-11-28 02:00:00	ES	Futures	2928.06	2928.6	2923.71	2924.25	10289.0
2018-11-28 03:00:00	ES	Futures	2924.25	2924.8	2919.08	2924.25	20495.0
2018-11-28 04:00:00	ES	Futures	2924.25	2926.43	2920.99	2923.98	14422.0
2018-11-28 05:00:00	ES	Futures	2923.98	2928.6	2922.35	2927.79	13277.0
2018-11-28 06:00:00	ES	Futures	2927.79	2929.96	2925.61	2929.69	12940.0
2018-11-28 07:00:00	ES	Futures	2929.69	2934.59	2929.15	2933.23	20631.0
2018-11-28 08:00:00	ES	Futures	2932.96	2934.32	2931.6	2932.14	18697.0
2018-11-28 09:00:00	ES	Futures	2932.41	2935.4	2927.24	2929.42	176458.0
2018-11-28 10:00:00	ES	Futures	2929.15	2932.68	2920.44	2925.61	187396.0
2018-11-28 11:00:00	ES	Futures	2925.61	2934.04	2924.8	2932.41	150757.0
2018-11-28 12:00:00	ES	Futures	2932.68	2967.77	2932.41	2962.33	417204.0
2018-11-28 13:00:00	ES	Futures	2962.6	2975.12	2956.89	2972.67	190556.0
2018-11-28 14:00:00	ES	Futures	2972.94	2975.93	2966.96	2967.5	152057.0
2018-11-28 15:00:00	ES	Futures	2967.5	2986.54	2964.51	2986.0	254957.0
2018-11-28 16:00:00	ES	Futures	2985.72	2986.54	2980.01	2982.19	90809.0
2018-11-28 18:00:00	ES	Futures	2978.92	2981.92	2977.56	2980.56	9271.0
2018-11-28 19:00:00	ES	Futures	2980.56	2983.28	2979.74	2980.01	7850.0
2018-11-28 20:00:00	ES	Futures	2979.74	2981.64	2976.75	2977.29	7570.0
2018-11-28 21:00:00	ES	Futures	2977.56	2978.65	2975.12	2975.12	7488.0
2018-11-28 22:00:00	ES	Futures	2975.12	2979.47	2975.12	2978.65	5387.0
2018-11-28 23:00:00	ES	Futures	2978.65	2979.74	2977.02	2979.74	4245.0
2018-11-28 00:00:00	NQ	Futures	7892.5	7896.9	7888.68	7895.14	2077.0
2018-11-28 01:00:00	NQ	Futures	7895.43	7911.86	7894.55	7909.8	3862.0
2018-11-28 02:00:00	NQ	Futures	7909.8	7911.86	7890.74	7892.79	4014.0
2018-11-28 03:00:00	NQ	Futures	7893.08	7893.08	7874.31	7888.98	8279.0
2018-11-28 04:00:00	NQ	Futures	7888.68	7896.02	7879.59	7887.22	6358.0
2018-11-28 05:00:00	NQ	Futures	7887.22	7910.1	7883.7	7908.04	5360.0
2018-11-28 06:00:00	NQ	Futures	7907.75	7913.03	7900.12	7912.15	6032.0
2018-11-28 07:00:00	NQ	Futures	7912.44	7927.69	7909.51	7921.83	14311.0
2018-11-28 08:00:00	NQ	Futures	7921.24	7929.75	7917.43	7924.47	10457.0
2018-11-28 09:00:00	NQ	Futures	7924.76	7937.08	7899.83	7915.38	75624.0
2018-11-28 10:00:00	NQ	Futures	7915.08	7930.92	7880.18	7889.86	74685.0
2018-11-28 11:00:00	NQ	Futures	7889.56	7916.26	7886.04	7910.98	70309.0
2018-11-28 12:00:00	NQ	Futures	7911.27	8051.18	7909.51	8019.8	128196.0
2018-11-28 13:00:00	NQ	Futures	8019.8	8080.51	7999.85	8070.83	70118.0
2018-11-28 14:00:00	NQ	Futures	8071.13	8082.86	8052.65	8060.86	50235.0
2018-11-28 15:00:00	NQ	Futures	8060.86	8120.99	8050.01	8118.64	61558.0
2018-11-28 16:00:00	NQ	Futures	8118.94	8123.04	8107.79	8114.24	14634.0
2018-11-28 18:00:00	NQ	Futures	8103.68	8114.24	8099.58	8108.38	3590.0
2018-11-28 19:00:00	NQ	Futures	8108.08	8117.47	8103.68	8104.86	3451.0
2018-11-28 20:00:00	NQ	Futures	8104.27	8109.84	8090.19	8094.59	4515.0
2018-11-28 21:00:00	NQ	Futures	8094.88	8101.04	8088.43	8090.78	4004.0
2018-11-28 22:00:00	NQ	Futures	8090.48	8104.86	8090.19	8100.75	2844.0
2018-11-28 23:00:00	NQ	Futures	8100.75	8106.62	8097.52	8106.62	1916.0
2018-11-28 00:00:00	YM	Futures	26928.1	26940.1	26921.6	26936.8	975.0
2018-11-28 01:00:00	YM	Futures	26937.9	27004.2	26933.6	26989.0	2966.0
2018-11-28 02:00:00	YM	Futures	26989.0	26995.5	26952.0	26955.3	3276.0
2018-11-28 03:00:00	YM	Futures	26956.4	26961.8	26906.4	26957.5	4844.0

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

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