PREVIEW / futures_1hour / 2019-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-31.parquet
  size:    57 KB
  rows:    1,790

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-01-31 00:00:00	ES	Futures	2921.44	2921.44	2916.55	2918.18	7635.0
2019-01-31 01:00:00	ES	Futures	2918.18	2918.99	2916.0	2917.36	5149.0
2019-01-31 02:00:00	ES	Futures	2917.36	2919.53	2917.09	2918.72	7293.0
2019-01-31 03:00:00	ES	Futures	2918.99	2922.52	2916.55	2918.99	21630.0
2019-01-31 04:00:00	ES	Futures	2918.99	2920.08	2915.19	2916.0	21439.0
2019-01-31 05:00:00	ES	Futures	2916.28	2917.9	2912.74	2915.46	16664.0
2019-01-31 06:00:00	ES	Futures	2915.73	2918.72	2914.65	2918.18	10998.0
2019-01-31 07:00:00	ES	Futures	2918.45	2918.99	2913.56	2917.36	28267.0
2019-01-31 08:00:00	ES	Futures	2917.09	2918.18	2910.3	2912.47	32281.0
2019-01-31 09:00:00	ES	Futures	2912.74	2915.73	2906.77	2914.92	200746.0
2019-01-31 10:00:00	ES	Futures	2915.19	2931.21	2914.1	2926.6	283861.0
2019-01-31 11:00:00	ES	Futures	2926.32	2941.8	2925.24	2940.72	209576.0
2019-01-31 12:00:00	ES	Futures	2940.72	2941.8	2929.31	2931.48	157960.0
2019-01-31 13:00:00	ES	Futures	2931.76	2934.74	2928.22	2933.93	127419.0
2019-01-31 14:00:00	ES	Futures	2933.93	2936.1	2929.04	2933.38	119932.0
2019-01-31 15:00:00	ES	Futures	2933.38	2940.99	2925.78	2936.1	375432.0
2019-01-31 16:00:00	ES	Futures	2935.83	2947.24	2933.66	2946.15	127587.0
2019-01-31 18:00:00	ES	Futures	2941.53	2942.89	2936.37	2938.0	13712.0
2019-01-31 19:00:00	ES	Futures	2937.73	2944.25	2937.73	2941.26	13188.0
2019-01-31 20:00:00	ES	Futures	2941.53	2945.88	2934.47	2937.19	21640.0
2019-01-31 21:00:00	ES	Futures	2937.19	2939.09	2934.74	2938.27	10184.0
2019-01-31 22:00:00	ES	Futures	2938.27	2940.45	2936.64	2937.73	5055.0
2019-01-31 23:00:00	ES	Futures	2937.73	2939.09	2936.92	2936.92	2986.0
2019-01-31 00:00:00	NQ	Futures	8032.28	8032.87	8019.72	8026.15	3910.0
2019-01-31 01:00:00	NQ	Futures	8026.44	8028.19	8018.55	8026.73	2512.0
2019-01-31 02:00:00	NQ	Futures	8027.03	8034.04	8022.35	8028.78	4397.0
2019-01-31 03:00:00	NQ	Futures	8029.07	8039.01	8020.01	8026.73	7732.0
2019-01-31 04:00:00	NQ	Futures	8026.73	8029.36	8012.12	8015.34	7619.0
2019-01-31 05:00:00	NQ	Futures	8015.34	8022.64	8003.36	8015.34	6228.0
2019-01-31 06:00:00	NQ	Futures	8015.63	8030.24	8009.2	8029.07	5801.0
2019-01-31 07:00:00	NQ	Futures	8029.36	8039.01	8020.31	8032.58	11886.0
2019-01-31 08:00:00	NQ	Futures	8032.28	8037.84	8006.28	8013.0	10897.0
2019-01-31 09:00:00	NQ	Futures	8013.0	8040.47	7993.42	8036.08	69331.0
2019-01-31 10:00:00	NQ	Futures	8036.08	8080.5	8030.24	8063.55	81420.0
2019-01-31 11:00:00	NQ	Futures	8063.55	8114.68	8060.33	8107.38	61066.0
2019-01-31 12:00:00	NQ	Futures	8107.38	8110.01	8074.65	8084.59	50193.0
2019-01-31 13:00:00	NQ	Futures	8084.88	8096.57	8063.55	8086.63	41409.0
2019-01-31 14:00:00	NQ	Futures	8086.63	8091.6	8066.18	8076.11	40017.0
2019-01-31 15:00:00	NQ	Futures	8076.11	8085.76	8044.56	8076.41	76846.0
2019-01-31 16:00:00	NQ	Futures	8076.41	8107.38	8057.12	8102.41	35307.0
2019-01-31 18:00:00	NQ	Futures	8077.28	8077.28	8050.4	8053.91	5887.0
2019-01-31 19:00:00	NQ	Futures	8053.61	8074.07	8052.74	8065.3	6336.0
2019-01-31 20:00:00	NQ	Futures	8064.72	8077.57	8042.51	8044.56	9129.0
2019-01-31 21:00:00	NQ	Futures	8044.26	8053.91	8037.25	8050.4	6620.0
2019-01-31 22:00:00	NQ	Futures	8050.11	8057.41	8045.43	8050.11	2654.0
2019-01-31 23:00:00	NQ	Futures	8049.82	8053.61	8044.56	8044.56	1623.0
2019-01-31 00:00:00	YM	Futures	27136.2	27136.2	27094.9	27112.3	2005.0
2019-01-31 01:00:00	YM	Futures	27112.3	27122.0	27086.2	27105.8	1716.0
2019-01-31 02:00:00	YM	Futures	27105.8	27124.2	27102.5	27123.1	2547.0
2019-01-31 03:00:00	YM	Futures	27123.1	27159.0	27104.7	27130.7	5229.0

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

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