PREVIEW / futures_1hour / 2021-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-28.parquet
  size:    67 KB
  rows:    2,005

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
2021-09-28 00:00:00	ES	Futures	5001.09	5006.45	4999.67	5005.88	5023.0
2021-09-28 01:00:00	ES	Futures	5005.88	5014.35	5002.5	5014.07	10985.0
2021-09-28 02:00:00	ES	Futures	5014.07	5014.35	4985.0	4987.26	23514.0
2021-09-28 03:00:00	ES	Futures	4987.26	4990.64	4970.32	4973.43	52878.0
2021-09-28 04:00:00	ES	Futures	4973.71	4974.84	4962.42	4972.86	43282.0
2021-09-28 05:00:00	ES	Futures	4973.15	4976.53	4956.78	4959.32	31304.0
2021-09-28 06:00:00	ES	Futures	4959.04	4965.81	4953.39	4959.32	34285.0
2021-09-28 07:00:00	ES	Futures	4959.6	4972.3	4954.8	4968.91	41950.0
2021-09-28 08:00:00	ES	Futures	4969.2	4969.76	4957.34	4961.86	36857.0
2021-09-28 09:00:00	ES	Futures	4961.58	4977.94	4941.82	4951.13	249048.0
2021-09-28 10:00:00	ES	Futures	4951.13	4951.13	4915.29	4924.32	387768.0
2021-09-28 11:00:00	ES	Futures	4924.04	4929.12	4902.88	4912.19	250337.0
2021-09-28 12:00:00	ES	Futures	4912.19	4918.68	4895.26	4897.8	173831.0
2021-09-28 13:00:00	ES	Futures	4897.51	4916.99	4893.28	4902.03	161844.0
2021-09-28 14:00:00	ES	Futures	4902.03	4930.25	4894.13	4926.58	212825.0
2021-09-28 15:00:00	ES	Futures	4926.3	4935.61	4896.39	4903.44	400134.0
2021-09-28 16:00:00	ES	Futures	4903.44	4910.78	4902.03	4906.54	75456.0
2021-09-28 18:00:00	ES	Futures	4907.67	4913.6	4906.26	4911.91	9256.0
2021-09-28 19:00:00	ES	Futures	4911.91	4917.27	4905.13	4916.7	9479.0
2021-09-28 20:00:00	ES	Futures	4916.7	4928.56	4915.58	4924.32	20040.0
2021-09-28 21:00:00	ES	Futures	4924.32	4926.02	4907.39	4918.68	26333.0
2021-09-28 22:00:00	ES	Futures	4918.68	4928.28	4916.7	4925.45	14232.0
2021-09-28 23:00:00	ES	Futures	4925.45	4930.53	4920.37	4927.43	11284.0
2021-09-28 00:00:00	NQ	Futures	17561.47	17592.48	17553.65	17587.55	4228.0
2021-09-28 01:00:00	NQ	Futures	17587.84	17611.9	17570.45	17610.16	4722.0
2021-09-28 02:00:00	NQ	Futures	17610.74	17610.74	17463.22	17468.73	17090.0
2021-09-28 03:00:00	NQ	Futures	17469.6	17486.7	17376.28	17394.54	24368.0
2021-09-28 04:00:00	NQ	Futures	17394.25	17422.36	17344.98	17404.1	16971.0
2021-09-28 05:00:00	NQ	Futures	17404.97	17424.68	17324.11	17332.23	15279.0
2021-09-28 06:00:00	NQ	Futures	17332.23	17358.89	17301.5	17318.02	15678.0
2021-09-28 07:00:00	NQ	Futures	17318.6	17382.36	17302.66	17370.19	19114.0
2021-09-28 08:00:00	NQ	Futures	17369.9	17373.09	17323.24	17347.59	15884.0
2021-09-28 09:00:00	NQ	Futures	17347.3	17422.65	17281.22	17332.23	103825.0
2021-09-28 10:00:00	NQ	Futures	17332.23	17332.23	17179.78	17191.08	142065.0
2021-09-28 11:00:00	NQ	Futures	17190.79	17207.02	17113.12	17162.97	98967.0
2021-09-28 12:00:00	NQ	Futures	17163.55	17206.15	17095.73	17109.07	69401.0
2021-09-28 13:00:00	NQ	Futures	17108.49	17184.13	17092.55	17122.11	54981.0
2021-09-28 14:00:00	NQ	Futures	17122.4	17229.34	17088.49	17210.21	71285.0
2021-09-28 15:00:00	NQ	Futures	17209.34	17243.83	17096.6	17115.73	100138.0
2021-09-28 16:00:00	NQ	Futures	17115.15	17142.11	17090.52	17120.08	21358.0
2021-09-28 18:00:00	NQ	Futures	17121.53	17136.89	17113.12	17128.19	4486.0
2021-09-28 19:00:00	NQ	Futures	17128.48	17161.23	17110.51	17159.49	4843.0
2021-09-28 20:00:00	NQ	Futures	17158.91	17215.14	17155.44	17190.79	11432.0
2021-09-28 21:00:00	NQ	Futures	17190.21	17199.78	17126.45	17179.2	13116.0
2021-09-28 22:00:00	NQ	Futures	17179.2	17219.2	17169.93	17203.55	8902.0
2021-09-28 23:00:00	NQ	Futures	17204.13	17224.41	17183.84	17201.23	6027.0
2021-09-28 00:00:00	YM	Futures	38972.8	39009.8	38961.6	39007.6	1044.0
2021-09-28 01:00:00	YM	Futures	39007.6	39065.9	38981.8	39063.6	1780.0
2021-09-28 02:00:00	YM	Futures	39065.9	39065.9	38911.2	38920.1	3833.0
2021-09-28 03:00:00	YM	Futures	38921.3	38957.1	38796.8	38831.6	9072.0

> showing 50 of 2,005 rows — these rows as CSV

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