PREVIEW / futures_1hour / 2019-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-08.parquet
  size:    60 KB
  rows:    1,862

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-05-08 00:00:00	ES	Futures	3135.57	3137.47	3134.48	3137.47	8655.0
2019-05-08 01:00:00	ES	Futures	3137.47	3138.55	3133.13	3135.84	9955.0
2019-05-08 02:00:00	ES	Futures	3135.84	3137.47	3132.86	3134.76	11163.0
2019-05-08 03:00:00	ES	Futures	3134.76	3139.36	3133.94	3139.36	18233.0
2019-05-08 04:00:00	ES	Futures	3139.09	3144.24	3131.77	3134.76	43449.0
2019-05-08 05:00:00	ES	Futures	3134.76	3135.57	3120.39	3120.93	48908.0
2019-05-08 06:00:00	ES	Futures	3120.93	3123.37	3118.49	3122.01	33937.0
2019-05-08 07:00:00	ES	Futures	3122.01	3122.01	3110.9	3118.49	64916.0
2019-05-08 08:00:00	ES	Futures	3118.49	3129.88	3112.8	3123.64	139776.0
2019-05-08 09:00:00	ES	Futures	3123.91	3130.96	3115.51	3127.98	324415.0
2019-05-08 10:00:00	ES	Futures	3127.98	3135.84	3119.3	3135.57	235749.0
2019-05-08 11:00:00	ES	Futures	3135.3	3143.43	3125.54	3131.77	341299.0
2019-05-08 12:00:00	ES	Futures	3131.5	3138.28	3125.0	3138.01	119244.0
2019-05-08 13:00:00	ES	Futures	3138.01	3139.91	3132.04	3135.57	111596.0
2019-05-08 14:00:00	ES	Futures	3135.84	3138.28	3131.23	3136.11	93940.0
2019-05-08 15:00:00	ES	Futures	3136.38	3141.26	3121.74	3123.37	221637.0
2019-05-08 16:00:00	ES	Futures	3123.37	3132.04	3123.1	3127.98	78667.0
2019-05-08 18:00:00	ES	Futures	3127.44	3128.52	3123.91	3127.98	7837.0
2019-05-08 19:00:00	ES	Futures	3128.52	3129.06	3123.91	3124.72	12606.0
2019-05-08 20:00:00	ES	Futures	3124.45	3127.16	3113.34	3120.12	45939.0
2019-05-08 21:00:00	ES	Futures	3119.84	3123.91	3117.95	3118.76	30760.0
2019-05-08 22:00:00	ES	Futures	3119.03	3119.84	3109.81	3114.42	21776.0
2019-05-08 23:00:00	ES	Futures	3114.42	3114.69	3110.09	3113.61	9721.0
2019-05-08 00:00:00	NQ	Futures	8939.36	8944.02	8934.41	8943.73	2037.0
2019-05-08 01:00:00	NQ	Futures	8943.73	8947.52	8927.43	8939.36	3472.0
2019-05-08 02:00:00	NQ	Futures	8939.36	8944.02	8930.63	8937.91	3553.0
2019-05-08 03:00:00	NQ	Futures	8938.2	8949.55	8934.41	8947.81	6185.0
2019-05-08 04:00:00	NQ	Futures	8947.52	8965.28	8928.59	8939.07	11684.0
2019-05-08 05:00:00	NQ	Futures	8939.07	8941.69	8890.45	8892.2	13157.0
2019-05-08 06:00:00	NQ	Futures	8891.91	8901.51	8882.88	8893.07	9825.0
2019-05-08 07:00:00	NQ	Futures	8893.36	8893.36	8856.97	8879.68	18861.0
2019-05-08 08:00:00	NQ	Futures	8879.39	8909.08	8853.47	8890.74	39963.0
2019-05-08 09:00:00	NQ	Futures	8890.45	8922.19	8851.14	8904.72	117797.0
2019-05-08 10:00:00	NQ	Futures	8905.3	8938.2	8871.23	8937.33	89170.0
2019-05-08 11:00:00	NQ	Futures	8936.16	8958.29	8895.98	8913.45	93507.0
2019-05-08 12:00:00	NQ	Futures	8913.74	8941.69	8893.65	8938.2	42343.0
2019-05-08 13:00:00	NQ	Futures	8938.2	8945.77	8917.53	8927.14	37085.0
2019-05-08 14:00:00	NQ	Futures	8926.84	8934.41	8909.67	8926.55	26305.0
2019-05-08 15:00:00	NQ	Futures	8926.84	8947.23	8882.3	8884.34	54341.0
2019-05-08 16:00:00	NQ	Futures	8884.04	8909.38	8883.46	8900.64	17237.0
2019-05-08 18:00:00	NQ	Futures	8897.44	8901.81	8886.37	8900.35	2320.0
2019-05-08 19:00:00	NQ	Futures	8900.35	8902.97	8888.12	8889.29	3358.0
2019-05-08 20:00:00	NQ	Futures	8889.29	8900.06	8845.61	8870.07	12717.0
2019-05-08 21:00:00	NQ	Futures	8869.49	8882.01	8864.83	8867.74	8907.0
2019-05-08 22:00:00	NQ	Futures	8868.03	8871.82	8835.42	8847.94	8268.0
2019-05-08 23:00:00	NQ	Futures	8848.23	8848.81	8835.42	8846.19	4096.0
2019-05-08 00:00:00	YM	Futures	28268.5	28285.9	28255.4	28283.7	2422.0
2019-05-08 01:00:00	YM	Futures	28284.8	28293.5	28243.5	28267.4	2761.0
2019-05-08 02:00:00	YM	Futures	28266.3	28281.5	28240.2	28268.5	3036.0
2019-05-08 03:00:00	YM	Futures	28268.5	28297.8	28246.7	28296.7	3649.0

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

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