PREVIEW / futures_1hour / 2019-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-18.parquet
  size:    47 KB
  rows:    1,440

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-04-18 00:00:00	ES	Futures	3136.92	3140.18	3136.65	3138.55	4997.0
2019-04-18 01:00:00	ES	Futures	3138.55	3139.36	3136.38	3136.92	11074.0
2019-04-18 02:00:00	ES	Futures	3137.2	3141.26	3137.2	3139.91	11573.0
2019-04-18 03:00:00	ES	Futures	3140.18	3142.08	3135.03	3136.65	24242.0
2019-04-18 04:00:00	ES	Futures	3136.38	3140.72	3133.4	3140.45	23277.0
2019-04-18 05:00:00	ES	Futures	3140.18	3147.23	3139.09	3143.97	27901.0
2019-04-18 06:00:00	ES	Futures	3143.97	3145.6	3142.35	3143.7	15839.0
2019-04-18 07:00:00	ES	Futures	3143.7	3147.23	3142.89	3146.96	13824.0
2019-04-18 08:00:00	ES	Futures	3146.68	3154.82	3146.68	3151.84	55803.0
2019-04-18 09:00:00	ES	Futures	3151.84	3157.53	3147.5	3147.77	243140.0
2019-04-18 10:00:00	ES	Futures	3147.77	3148.31	3139.36	3146.68	238088.0
2019-04-18 11:00:00	ES	Futures	3146.41	3151.84	3143.16	3151.84	142507.0
2019-04-18 12:00:00	ES	Futures	3151.84	3155.36	3151.02	3152.38	82866.0
2019-04-18 13:00:00	ES	Futures	3152.65	3155.36	3151.56	3154.55	49418.0
2019-04-18 14:00:00	ES	Futures	3154.55	3156.99	3152.92	3156.17	59485.0
2019-04-18 15:00:00	ES	Futures	3156.17	3157.26	3151.02	3154.0	176173.0
2019-04-18 16:00:00	ES	Futures	3154.0	3156.71	3153.46	3156.17	55957.0
2019-04-18 00:00:00	NQ	Futures	8930.92	8941.4	8930.92	8933.83	2398.0
2019-04-18 01:00:00	NQ	Futures	8933.83	8935.29	8925.39	8929.17	3752.0
2019-04-18 02:00:00	NQ	Futures	8929.46	8941.98	8928.88	8938.78	3668.0
2019-04-18 03:00:00	NQ	Futures	8939.07	8945.77	8923.93	8930.34	6843.0
2019-04-18 04:00:00	NQ	Futures	8930.05	8940.24	8921.31	8939.36	6262.0
2019-04-18 05:00:00	NQ	Futures	8939.36	8960.62	8936.45	8951.59	8229.0
2019-04-18 06:00:00	NQ	Futures	8951.59	8957.12	8946.93	8950.43	4671.0
2019-04-18 07:00:00	NQ	Futures	8950.43	8956.54	8946.93	8955.38	4982.0
2019-04-18 08:00:00	NQ	Futures	8955.38	8977.51	8955.09	8966.44	14917.0
2019-04-18 09:00:00	NQ	Futures	8966.44	8994.39	8948.1	8949.55	70726.0
2019-04-18 10:00:00	NQ	Futures	8949.26	8958.0	8926.84	8955.96	75270.0
2019-04-18 11:00:00	NQ	Futures	8955.96	8966.44	8947.81	8965.28	48998.0
2019-04-18 12:00:00	NQ	Futures	8965.28	8978.96	8963.53	8967.32	29972.0
2019-04-18 13:00:00	NQ	Futures	8967.32	8976.05	8962.95	8974.59	16786.0
2019-04-18 14:00:00	NQ	Futures	8974.59	8984.49	8971.68	8981.29	20218.0
2019-04-18 15:00:00	NQ	Futures	8981.29	8982.46	8969.94	8979.83	43028.0
2019-04-18 16:00:00	NQ	Futures	8979.54	8986.53	8975.18	8985.95	7531.0
2019-04-18 00:00:00	YM	Futures	28653.5	28682.9	28652.4	28669.8	1418.0
2019-04-18 01:00:00	YM	Futures	28669.8	28674.2	28652.4	28661.1	1946.0
2019-04-18 02:00:00	YM	Futures	28662.2	28691.6	28661.1	28680.7	2002.0
2019-04-18 03:00:00	YM	Futures	28680.7	28698.1	28626.3	28642.6	4683.0
2019-04-18 04:00:00	YM	Futures	28641.5	28684.0	28617.6	28677.4	4285.0
2019-04-18 05:00:00	YM	Futures	28677.4	28738.3	28662.2	28705.7	6314.0
2019-04-18 06:00:00	YM	Futures	28704.6	28726.4	28690.5	28715.5	5290.0
2019-04-18 07:00:00	YM	Futures	28715.5	28750.3	28706.8	28749.2	3838.0
2019-04-18 08:00:00	YM	Futures	28750.3	28815.6	28746.0	28801.4	7431.0
2019-04-18 09:00:00	YM	Futures	28801.4	28902.6	28791.6	28842.8	31469.0
2019-04-18 10:00:00	YM	Futures	28843.8	28847.1	28761.2	28816.7	30861.0
2019-04-18 11:00:00	YM	Futures	28818.8	28876.5	28808.0	28875.4	17902.0
2019-04-18 12:00:00	YM	Futures	28876.5	28895.0	28867.8	28868.9	11974.0
2019-04-18 13:00:00	YM	Futures	28870.0	28921.1	28861.2	28912.4	9666.0
2019-04-18 14:00:00	YM	Futures	28911.3	28925.4	28897.1	28923.2	7469.0
2019-04-18 15:00:00	YM	Futures	28922.2	28930.9	28871.0	28888.4	18402.0

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

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