PREVIEW / futures_1hour / 2019-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-16.parquet
  size:    54 KB
  rows:    1,730

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-16 00:00:00	ES	Futures	3158.88	3159.43	3158.34	3159.43	2472.0
2019-04-16 01:00:00	ES	Futures	3159.15	3162.68	3158.61	3161.32	9167.0
2019-04-16 02:00:00	ES	Futures	3161.05	3162.14	3159.15	3159.7	13580.0
2019-04-16 03:00:00	ES	Futures	3159.97	3166.75	3158.61	3165.66	30862.0
2019-04-16 04:00:00	ES	Futures	3165.39	3167.83	3164.58	3167.29	17614.0
2019-04-16 05:00:00	ES	Futures	3167.29	3167.56	3163.49	3164.85	19059.0
2019-04-16 06:00:00	ES	Futures	3164.85	3166.47	3164.03	3165.12	9344.0
2019-04-16 07:00:00	ES	Futures	3164.85	3166.47	3164.85	3165.66	9679.0
2019-04-16 08:00:00	ES	Futures	3165.93	3167.56	3164.85	3165.39	20917.0
2019-04-16 09:00:00	ES	Futures	3165.39	3166.75	3161.05	3162.41	163925.0
2019-04-16 10:00:00	ES	Futures	3162.41	3164.31	3157.26	3158.61	192599.0
2019-04-16 11:00:00	ES	Futures	3158.61	3161.32	3156.99	3158.61	101365.0
2019-04-16 12:00:00	ES	Futures	3158.34	3160.78	3157.8	3160.51	65884.0
2019-04-16 13:00:00	ES	Futures	3160.51	3160.51	3156.44	3157.8	62002.0
2019-04-16 14:00:00	ES	Futures	3157.8	3159.43	3155.36	3159.15	81872.0
2019-04-16 15:00:00	ES	Futures	3159.15	3160.51	3149.67	3157.53	179593.0
2019-04-16 16:00:00	ES	Futures	3157.26	3158.61	3154.0	3156.71	74644.0
2019-04-16 18:00:00	ES	Futures	3155.9	3156.71	3154.27	3154.55	3695.0
2019-04-16 19:00:00	ES	Futures	3154.82	3156.71	3154.55	3155.9	3439.0
2019-04-16 20:00:00	ES	Futures	3155.9	3159.15	3154.55	3158.34	11680.0
2019-04-16 21:00:00	ES	Futures	3158.34	3164.31	3154.55	3162.41	16201.0
2019-04-16 22:00:00	ES	Futures	3162.68	3164.31	3159.7	3160.78	25438.0
2019-04-16 23:00:00	ES	Futures	3160.51	3160.78	3158.34	3159.7	11801.0
2019-04-16 00:00:00	NQ	Futures	8922.77	8925.39	8922.19	8924.81	1592.0
2019-04-16 01:00:00	NQ	Futures	8924.81	8936.45	8922.48	8930.63	4680.0
2019-04-16 02:00:00	NQ	Futures	8930.63	8933.54	8925.1	8927.14	4572.0
2019-04-16 03:00:00	NQ	Futures	8926.84	8948.1	8923.93	8944.61	7303.0
2019-04-16 04:00:00	NQ	Futures	8944.61	8951.59	8941.11	8950.43	4346.0
2019-04-16 05:00:00	NQ	Futures	8950.43	8950.43	8939.66	8943.44	4587.0
2019-04-16 06:00:00	NQ	Futures	8943.44	8948.1	8940.24	8943.73	3182.0
2019-04-16 07:00:00	NQ	Futures	8943.73	8945.77	8935.87	8941.69	3639.0
2019-04-16 08:00:00	NQ	Futures	8941.69	8949.55	8936.45	8941.69	7363.0
2019-04-16 09:00:00	NQ	Futures	8941.4	8946.64	8930.63	8942.86	46896.0
2019-04-16 10:00:00	NQ	Futures	8942.57	8960.62	8933.83	8943.15	68243.0
2019-04-16 11:00:00	NQ	Futures	8942.86	8954.8	8932.96	8938.49	45542.0
2019-04-16 12:00:00	NQ	Futures	8938.2	8950.14	8936.45	8948.68	22225.0
2019-04-16 13:00:00	NQ	Futures	8948.68	8951.88	8941.11	8944.31	19021.0
2019-04-16 14:00:00	NQ	Futures	8944.31	8950.72	8938.49	8950.14	22607.0
2019-04-16 15:00:00	NQ	Futures	8949.85	8955.67	8913.16	8941.69	58883.0
2019-04-16 16:00:00	NQ	Futures	8941.4	8961.78	8920.44	8940.53	25120.0
2019-04-16 18:00:00	NQ	Futures	8940.24	8941.69	8930.92	8934.12	2078.0
2019-04-16 19:00:00	NQ	Futures	8934.41	8941.11	8932.96	8941.11	1805.0
2019-04-16 20:00:00	NQ	Futures	8941.11	8955.67	8936.74	8953.34	4906.0
2019-04-16 21:00:00	NQ	Futures	8953.63	8972.26	8944.61	8967.02	7334.0
2019-04-16 22:00:00	NQ	Futures	8967.61	8971.97	8958.58	8960.62	8276.0
2019-04-16 23:00:00	NQ	Futures	8960.33	8960.62	8953.34	8959.16	4423.0
2019-04-16 00:00:00	YM	Futures	28736.2	28742.7	28734.0	28741.6	450.0
2019-04-16 01:00:00	YM	Futures	28742.7	28766.6	28734.0	28755.7	1903.0
2019-04-16 02:00:00	YM	Futures	28753.6	28764.4	28739.4	28742.7	7479.0
2019-04-16 03:00:00	YM	Futures	28742.7	28805.8	28731.8	28788.4	6934.0

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

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