PREVIEW / futures_1hour / 2021-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-13.parquet
  size:    63 KB
  rows:    1,941

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-07-13 00:00:00	ES	Futures	4927.41	4927.41	4926.28	4926.28	2614.0
2021-07-13 01:00:00	ES	Futures	4926.28	4926.84	4924.31	4924.59	4290.0
2021-07-13 02:00:00	ES	Futures	4924.59	4925.72	4922.34	4923.47	7300.0
2021-07-13 03:00:00	ES	Futures	4923.18	4924.59	4919.8	4923.75	20418.0
2021-07-13 04:00:00	ES	Futures	4924.03	4931.07	4922.06	4929.94	18327.0
2021-07-13 05:00:00	ES	Futures	4930.22	4931.07	4927.13	4929.38	13902.0
2021-07-13 06:00:00	ES	Futures	4929.66	4931.63	4928.53	4929.94	7708.0
2021-07-13 07:00:00	ES	Futures	4929.66	4931.07	4927.97	4929.94	16397.0
2021-07-13 08:00:00	ES	Futures	4929.94	4930.5	4907.13	4907.7	89402.0
2021-07-13 09:00:00	ES	Futures	4907.7	4929.38	4906.85	4926.0	184230.0
2021-07-13 10:00:00	ES	Futures	4925.72	4933.6	4922.9	4927.13	145532.0
2021-07-13 11:00:00	ES	Futures	4927.13	4936.98	4926.84	4936.14	90517.0
2021-07-13 12:00:00	ES	Futures	4936.14	4937.54	4932.48	4933.88	45215.0
2021-07-13 13:00:00	ES	Futures	4933.6	4934.17	4913.89	4921.78	174653.0
2021-07-13 14:00:00	ES	Futures	4921.78	4922.62	4911.92	4919.8	135224.0
2021-07-13 15:00:00	ES	Futures	4919.8	4920.09	4909.1	4912.48	200121.0
2021-07-13 16:00:00	ES	Futures	4912.2	4913.89	4908.54	4909.95	43542.0
2021-07-13 18:00:00	ES	Futures	4910.23	4914.45	4909.67	4912.48	3955.0
2021-07-13 19:00:00	ES	Futures	4912.48	4913.33	4904.6	4906.01	4971.0
2021-07-13 20:00:00	ES	Futures	4906.01	4912.2	4905.44	4911.64	7617.0
2021-07-13 21:00:00	ES	Futures	4911.64	4915.3	4909.95	4914.17	6788.0
2021-07-13 22:00:00	ES	Futures	4913.89	4914.45	4908.82	4910.23	6267.0
2021-07-13 23:00:00	ES	Futures	4910.51	4911.36	4907.13	4908.54	4189.0
2021-07-13 00:00:00	NQ	Futures	17243.57	17245.3	17238.64	17239.51	1036.0
2021-07-13 01:00:00	NQ	Futures	17239.22	17241.54	17232.56	17234.59	2081.0
2021-07-13 02:00:00	NQ	Futures	17234.59	17238.06	17215.47	17223.87	3623.0
2021-07-13 03:00:00	NQ	Futures	17223.87	17229.37	17207.36	17224.45	5171.0
2021-07-13 04:00:00	NQ	Futures	17224.45	17272.25	17222.71	17265.29	10060.0
2021-07-13 05:00:00	NQ	Futures	17265.29	17294.55	17262.11	17290.21	7646.0
2021-07-13 06:00:00	NQ	Futures	17290.49	17296.87	17282.96	17290.78	4899.0
2021-07-13 07:00:00	NQ	Futures	17290.49	17294.84	17277.46	17280.07	4995.0
2021-07-13 08:00:00	NQ	Futures	17280.36	17285.57	17149.13	17150.29	37052.0
2021-07-13 09:00:00	NQ	Futures	17151.45	17287.6	17142.76	17281.23	79999.0
2021-07-13 10:00:00	NQ	Futures	17281.23	17349.59	17281.23	17322.94	67901.0
2021-07-13 11:00:00	NQ	Futures	17323.52	17374.79	17322.07	17368.42	36773.0
2021-07-13 12:00:00	NQ	Futures	17368.13	17369.87	17348.72	17355.96	20750.0
2021-07-13 13:00:00	NQ	Futures	17355.96	17357.41	17214.89	17249.36	79293.0
2021-07-13 14:00:00	NQ	Futures	17248.49	17275.72	17187.95	17269.35	61828.0
2021-07-13 15:00:00	NQ	Futures	17269.64	17269.93	17205.33	17224.74	58418.0
2021-07-13 16:00:00	NQ	Futures	17224.45	17235.46	17211.7	17224.45	8969.0
2021-07-13 18:00:00	NQ	Futures	17229.95	17238.93	17219.23	17230.53	2016.0
2021-07-13 19:00:00	NQ	Futures	17230.24	17235.46	17197.8	17200.69	2687.0
2021-07-13 20:00:00	NQ	Futures	17199.82	17226.77	17199.82	17223.87	3635.0
2021-07-13 21:00:00	NQ	Futures	17224.45	17250.23	17218.94	17242.99	4286.0
2021-07-13 22:00:00	NQ	Futures	17242.12	17245.01	17227.63	17235.17	2999.0
2021-07-13 23:00:00	NQ	Futures	17234.59	17240.67	17230.82	17235.75	1501.0
2021-07-13 00:00:00	YM	Futures	38960.8	38961.9	38949.6	38953.0	463.0
2021-07-13 01:00:00	YM	Futures	38953.0	38957.5	38926.2	38929.5	1120.0
2021-07-13 02:00:00	YM	Futures	38929.5	38944.1	38912.8	38919.5	1565.0
2021-07-13 03:00:00	YM	Futures	38918.4	38950.8	38888.2	38937.4	4528.0

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

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