PREVIEW / futures_1hour / 2019-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-27.parquet
  size:    58 KB
  rows:    1,838

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-06-27 00:00:00	ES	Futures	3169.96	3170.23	3167.52	3167.79	3576.0
2019-06-27 01:00:00	ES	Futures	3168.06	3171.04	3167.25	3170.5	8228.0
2019-06-27 02:00:00	ES	Futures	3170.5	3173.48	3169.41	3172.66	15014.0
2019-06-27 03:00:00	ES	Futures	3172.93	3176.45	3172.39	3174.56	26504.0
2019-06-27 04:00:00	ES	Futures	3174.83	3174.83	3170.77	3172.39	15396.0
2019-06-27 05:00:00	ES	Futures	3172.12	3178.89	3165.08	3167.25	35496.0
2019-06-27 06:00:00	ES	Futures	3167.25	3167.25	3159.4	3165.35	34010.0
2019-06-27 07:00:00	ES	Futures	3165.35	3166.71	3161.02	3164.54	19494.0
2019-06-27 08:00:00	ES	Futures	3164.27	3168.87	3163.19	3168.87	28234.0
2019-06-27 09:00:00	ES	Futures	3168.6	3175.64	3166.98	3173.75	134678.0
2019-06-27 10:00:00	ES	Futures	3173.75	3174.56	3167.79	3171.04	140262.0
2019-06-27 11:00:00	ES	Futures	3170.77	3172.66	3164.0	3168.87	138545.0
2019-06-27 12:00:00	ES	Futures	3168.87	3174.83	3167.52	3172.93	69507.0
2019-06-27 13:00:00	ES	Futures	3173.2	3176.45	3172.66	3174.56	49210.0
2019-06-27 14:00:00	ES	Futures	3174.29	3176.45	3171.58	3172.12	50249.0
2019-06-27 15:00:00	ES	Futures	3172.12	3174.83	3169.96	3170.5	138331.0
2019-06-27 16:00:00	ES	Futures	3170.5	3176.72	3169.96	3176.45	52434.0
2019-06-27 18:00:00	ES	Futures	3175.64	3180.78	3175.64	3178.62	5618.0
2019-06-27 19:00:00	ES	Futures	3178.89	3178.89	3175.1	3178.89	4244.0
2019-06-27 20:00:00	ES	Futures	3179.16	3182.68	3178.89	3179.43	12246.0
2019-06-27 21:00:00	ES	Futures	3179.43	3180.51	3174.83	3177.54	11816.0
2019-06-27 22:00:00	ES	Futures	3177.54	3177.81	3172.66	3173.48	7376.0
2019-06-27 23:00:00	ES	Futures	3173.2	3175.91	3172.66	3175.64	4804.0
2019-06-27 00:00:00	NQ	Futures	8918.69	8919.56	8904.76	8907.95	2098.0
2019-06-27 01:00:00	NQ	Futures	8908.24	8919.27	8905.63	8916.37	3000.0
2019-06-27 02:00:00	NQ	Futures	8916.37	8934.94	8914.05	8931.74	5724.0
2019-06-27 03:00:00	NQ	Futures	8932.03	8942.77	8928.84	8935.23	6811.0
2019-06-27 04:00:00	NQ	Futures	8935.23	8938.42	8920.14	8926.23	5969.0
2019-06-27 05:00:00	NQ	Futures	8926.52	8955.54	8901.86	8912.89	12328.0
2019-06-27 06:00:00	NQ	Futures	8912.6	8912.6	8879.23	8903.31	12638.0
2019-06-27 07:00:00	NQ	Futures	8903.31	8907.37	8886.77	8902.15	6934.0
2019-06-27 08:00:00	NQ	Futures	8902.15	8925.65	8898.38	8925.07	9269.0
2019-06-27 09:00:00	NQ	Futures	8925.07	8938.42	8907.08	8927.97	50071.0
2019-06-27 10:00:00	NQ	Futures	8927.39	8936.39	8909.98	8923.33	47420.0
2019-06-27 11:00:00	NQ	Futures	8923.33	8930.0	8893.45	8906.79	36295.0
2019-06-27 12:00:00	NQ	Futures	8906.21	8933.2	8902.73	8923.04	22828.0
2019-06-27 13:00:00	NQ	Futures	8923.33	8933.2	8920.43	8927.39	11094.0
2019-06-27 14:00:00	NQ	Futures	8927.1	8937.55	8920.72	8922.46	15635.0
2019-06-27 15:00:00	NQ	Futures	8922.75	8928.26	8916.37	8917.82	25174.0
2019-06-27 16:00:00	NQ	Futures	8917.24	8931.16	8915.21	8920.43	7355.0
2019-06-27 18:00:00	NQ	Futures	8919.27	8934.65	8917.53	8931.45	1730.0
2019-06-27 19:00:00	NQ	Futures	8931.45	8932.03	8920.43	8931.74	1264.0
2019-06-27 20:00:00	NQ	Futures	8932.03	8946.54	8932.03	8935.52	3785.0
2019-06-27 21:00:00	NQ	Futures	8934.94	8939.87	8914.63	8924.78	4558.0
2019-06-27 22:00:00	NQ	Futures	8924.78	8926.81	8905.92	8907.95	3855.0
2019-06-27 23:00:00	NQ	Futures	8907.66	8917.53	8904.18	8915.21	2207.0
2019-06-27 00:00:00	YM	Futures	28940.6	28940.6	28916.6	28921.0	961.0
2019-06-27 01:00:00	YM	Futures	28922.1	28951.4	28922.1	28941.6	1949.0
2019-06-27 02:00:00	YM	Futures	28942.7	28976.4	28934.0	28967.7	2668.0
2019-06-27 03:00:00	YM	Futures	28968.8	28998.2	28961.2	28978.6	5708.0

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

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