PREVIEW / futures_1hour / 2021-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-29.parquet
  size:    56 KB
  rows:    1,618

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-10-29 00:00:00	ES	Futures	5163.36	5164.77	5158.28	5158.28	4982.0
2021-10-29 01:00:00	ES	Futures	5158.28	5159.12	5154.61	5155.74	8726.0
2021-10-29 02:00:00	ES	Futures	5156.02	5157.15	5150.09	5155.17	12043.0
2021-10-29 03:00:00	ES	Futures	5155.46	5161.66	5147.27	5156.58	22333.0
2021-10-29 04:00:00	ES	Futures	5156.58	5159.41	5150.66	5155.46	13221.0
2021-10-29 05:00:00	ES	Futures	5155.17	5157.43	5150.66	5154.05	10363.0
2021-10-29 06:00:00	ES	Futures	5154.05	5156.58	5146.71	5152.63	18763.0
2021-10-29 07:00:00	ES	Futures	5152.35	5158.84	5151.22	5154.05	18510.0
2021-10-29 08:00:00	ES	Futures	5154.33	5160.54	5147.55	5150.66	48088.0
2021-10-29 09:00:00	ES	Futures	5150.66	5171.82	5146.71	5165.62	175282.0
2021-10-29 10:00:00	ES	Futures	5165.62	5171.26	5158.28	5168.16	182511.0
2021-10-29 11:00:00	ES	Futures	5168.16	5181.42	5167.87	5176.34	126215.0
2021-10-29 12:00:00	ES	Futures	5176.62	5189.04	5175.21	5184.24	96854.0
2021-10-29 13:00:00	ES	Futures	5184.52	5188.76	5180.86	5183.96	58308.0
2021-10-29 14:00:00	ES	Futures	5183.96	5184.81	5172.95	5178.32	97459.0
2021-10-29 15:00:00	ES	Futures	5178.32	5193.84	5171.26	5189.6	311614.0
2021-10-29 16:00:00	ES	Futures	5189.6	5196.66	5188.19	5195.53	83999.0
2021-10-29 00:00:00	NQ	Futures	18165.45	18166.32	18132.12	18143.42	3974.0
2021-10-29 01:00:00	NQ	Futures	18143.42	18144.29	18122.85	18132.12	5499.0
2021-10-29 02:00:00	NQ	Futures	18132.12	18143.71	18108.36	18130.38	6516.0
2021-10-29 03:00:00	NQ	Futures	18130.96	18156.18	18105.46	18146.61	9605.0
2021-10-29 04:00:00	NQ	Futures	18146.03	18146.03	18117.05	18126.61	6939.0
2021-10-29 05:00:00	NQ	Futures	18126.32	18135.89	18106.62	18117.92	6010.0
2021-10-29 06:00:00	NQ	Futures	18117.34	18127.48	18079.37	18111.25	10666.0
2021-10-29 07:00:00	NQ	Futures	18110.96	18137.92	18103.43	18124.01	7938.0
2021-10-29 08:00:00	NQ	Futures	18124.01	18148.06	18094.73	18114.15	19005.0
2021-10-29 09:00:00	NQ	Futures	18113.57	18199.94	18102.27	18180.81	77668.0
2021-10-29 10:00:00	NQ	Futures	18180.52	18208.63	18162.84	18190.95	68407.0
2021-10-29 11:00:00	NQ	Futures	18191.53	18254.71	18188.63	18243.7	48348.0
2021-10-29 12:00:00	NQ	Futures	18243.41	18309.49	18238.77	18297.9	43989.0
2021-10-29 13:00:00	NQ	Futures	18297.9	18326.59	18284.56	18297.32	27626.0
2021-10-29 14:00:00	NQ	Futures	18297.32	18312.39	18268.62	18301.08	35082.0
2021-10-29 15:00:00	NQ	Futures	18300.79	18370.64	18283.4	18363.1	64109.0
2021-10-29 16:00:00	NQ	Futures	18362.24	18391.51	18355.28	18390.64	14857.0
2021-10-29 00:00:00	YM	Futures	39888.6	39906.5	39868.4	39868.4	979.0
2021-10-29 01:00:00	YM	Futures	39867.3	39872.9	39838.2	39844.9	1536.0
2021-10-29 02:00:00	YM	Futures	39846.0	39853.9	39800.1	39838.2	2684.0
2021-10-29 03:00:00	YM	Futures	39839.3	39888.6	39776.5	39846.0	5463.0
2021-10-29 04:00:00	YM	Futures	39844.9	39877.4	39813.5	39852.7	3168.0
2021-10-29 05:00:00	YM	Futures	39851.6	39872.9	39829.2	39860.6	2184.0
2021-10-29 06:00:00	YM	Futures	39861.7	39877.4	39827.0	39864.0	3805.0
2021-10-29 07:00:00	YM	Futures	39862.8	39905.4	39858.3	39870.7	3501.0
2021-10-29 08:00:00	YM	Futures	39870.7	39906.5	39816.9	39848.3	5817.0
2021-10-29 09:00:00	YM	Futures	39848.3	40007.4	39798.9	39934.6	27084.0
2021-10-29 10:00:00	YM	Futures	39932.3	39961.5	39839.3	39931.2	22576.0
2021-10-29 11:00:00	YM	Futures	39930.1	40023.1	39927.8	39966.0	14624.0
2021-10-29 12:00:00	YM	Futures	39967.1	40048.9	39955.9	39994.0	10808.0
2021-10-29 13:00:00	YM	Futures	39995.1	40007.4	39969.3	39992.9	5816.0
2021-10-29 14:00:00	YM	Futures	39992.9	39994.0	39894.2	39939.1	11215.0
2021-10-29 15:00:00	YM	Futures	39941.3	40057.9	39898.7	40024.2	20316.0

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

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