PREVIEW / futures_1hour / 2018-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-10.parquet
  size:    54 KB
  rows:    1,682

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-01-10 00:00:00	ES	Futures	3007.97	3007.97	3006.33	3007.43	5330.0
2018-01-10 01:00:00	ES	Futures	3007.15	3007.7	3006.33	3006.61	2431.0
2018-01-10 02:00:00	ES	Futures	3006.33	3006.61	3002.51	3002.78	12875.0
2018-01-10 03:00:00	ES	Futures	3003.06	3005.79	3001.14	3001.42	28560.0
2018-01-10 04:00:00	ES	Futures	3001.42	3004.69	3001.14	3003.33	13147.0
2018-01-10 05:00:00	ES	Futures	3003.33	3004.15	2992.67	2993.49	59815.0
2018-01-10 06:00:00	ES	Futures	2993.22	2998.68	2993.22	2995.95	29598.0
2018-01-10 07:00:00	ES	Futures	2995.95	3000.05	2994.31	2996.5	32574.0
2018-01-10 08:00:00	ES	Futures	2996.77	3000.05	2995.68	2999.5	34673.0
2018-01-10 09:00:00	ES	Futures	2999.5	3003.06	2991.85	2996.77	266209.0
2018-01-10 10:00:00	ES	Futures	2996.77	3004.42	2994.31	3001.42	184957.0
2018-01-10 11:00:00	ES	Futures	3001.42	3006.33	3001.14	3004.15	89821.0
2018-01-10 12:00:00	ES	Futures	3004.15	3006.61	3001.96	3006.06	52780.0
2018-01-10 13:00:00	ES	Futures	3006.33	3008.52	3004.15	3007.15	71298.0
2018-01-10 14:00:00	ES	Futures	3007.15	3007.7	3000.05	3002.24	121294.0
2018-01-10 15:00:00	ES	Futures	3002.51	3006.06	3000.6	3005.24	159219.0
2018-01-10 16:00:00	ES	Futures	3005.24	3007.97	3004.42	3007.43	58108.0
2018-01-10 18:00:00	ES	Futures	3006.61	3007.43	3005.51	3007.43	4749.0
2018-01-10 19:00:00	ES	Futures	3007.43	3011.53	3005.79	3009.89	9814.0
2018-01-10 20:00:00	ES	Futures	3009.89	3010.71	3007.15	3009.07	7027.0
2018-01-10 21:00:00	ES	Futures	3009.07	3009.07	3004.15	3004.42	7646.0
2018-01-10 22:00:00	ES	Futures	3004.69	3009.61	3004.15	3009.34	8101.0
2018-01-10 23:00:00	ES	Futures	3009.61	3010.98	3009.34	3009.89	4152.0
2018-01-10 00:00:00	NQ	Futures	7928.85	7929.45	7920.85	7924.41	1360.0
2018-01-10 01:00:00	NQ	Futures	7925.0	7926.78	7922.63	7922.92	592.0
2018-01-10 02:00:00	NQ	Futures	7922.92	7924.41	7915.51	7916.1	2174.0
2018-01-10 03:00:00	NQ	Futures	7916.1	7923.81	7911.95	7912.84	3932.0
2018-01-10 04:00:00	NQ	Futures	7912.54	7920.25	7911.95	7913.43	2183.0
2018-01-10 05:00:00	NQ	Futures	7913.43	7916.4	7881.4	7881.7	9220.0
2018-01-10 06:00:00	NQ	Futures	7881.99	7895.34	7881.4	7885.55	5995.0
2018-01-10 07:00:00	NQ	Futures	7885.85	7894.75	7878.14	7887.33	6003.0
2018-01-10 08:00:00	NQ	Futures	7887.63	7898.01	7883.48	7890.89	8944.0
2018-01-10 09:00:00	NQ	Futures	7890.89	7911.95	7869.83	7882.29	76201.0
2018-01-10 10:00:00	NQ	Futures	7882.59	7899.49	7863.6	7890.3	60196.0
2018-01-10 11:00:00	NQ	Futures	7890.0	7907.5	7886.74	7898.3	30439.0
2018-01-10 12:00:00	NQ	Futures	7898.3	7906.91	7892.08	7904.24	15989.0
2018-01-10 13:00:00	NQ	Futures	7904.24	7918.18	7895.64	7913.73	19393.0
2018-01-10 14:00:00	NQ	Futures	7914.02	7915.8	7886.14	7902.46	29064.0
2018-01-10 15:00:00	NQ	Futures	7902.16	7918.18	7898.01	7916.4	26937.0
2018-01-10 16:00:00	NQ	Futures	7916.4	7922.63	7913.43	7920.55	8085.0
2018-01-10 18:00:00	NQ	Futures	7920.85	7920.85	7913.73	7918.77	889.0
2018-01-10 19:00:00	NQ	Futures	7919.07	7930.34	7915.21	7925.89	1913.0
2018-01-10 20:00:00	NQ	Futures	7925.59	7928.56	7917.58	7925.0	1457.0
2018-01-10 21:00:00	NQ	Futures	7924.41	7924.7	7906.31	7908.39	1901.0
2018-01-10 22:00:00	NQ	Futures	7908.39	7923.22	7906.31	7922.63	2111.0
2018-01-10 23:00:00	NQ	Futures	7922.63	7927.37	7922.03	7923.52	1156.0
2018-01-10 00:00:00	YM	Futures	27579.6	27580.7	27567.6	27578.5	785.0
2018-01-10 01:00:00	YM	Futures	27579.6	27585.0	27574.2	27575.2	518.0
2018-01-10 02:00:00	YM	Futures	27576.3	27576.3	27517.6	27532.8	2760.0
2018-01-10 03:00:00	YM	Futures	27532.8	27556.8	27513.3	27517.6	3638.0

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

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