PREVIEW / futures_1hour / 2021-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-19.parquet
  size:    64 KB
  rows:    1,972

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-08-19 00:00:00	ES	Futures	4946.55	4947.68	4944.02	4945.15	5235.0
2021-08-19 01:00:00	ES	Futures	4944.87	4945.71	4935.57	4935.57	13781.0
2021-08-19 02:00:00	ES	Futures	4935.57	4938.39	4913.33	4915.3	37914.0
2021-08-19 03:00:00	ES	Futures	4915.58	4922.62	4909.1	4913.89	51933.0
2021-08-19 04:00:00	ES	Futures	4913.61	4914.45	4901.78	4905.44	43894.0
2021-08-19 05:00:00	ES	Futures	4905.73	4922.9	4897.0	4919.52	42343.0
2021-08-19 06:00:00	ES	Futures	4919.52	4925.72	4911.08	4911.36	29073.0
2021-08-19 07:00:00	ES	Futures	4911.36	4915.86	4904.88	4905.73	35602.0
2021-08-19 08:00:00	ES	Futures	4906.01	4915.3	4901.22	4906.01	44696.0
2021-08-19 09:00:00	ES	Futures	4906.01	4947.4	4905.73	4943.18	289054.0
2021-08-19 10:00:00	ES	Futures	4943.18	4959.79	4931.35	4953.88	309841.0
2021-08-19 11:00:00	ES	Futures	4954.16	4971.62	4946.27	4967.96	199937.0
2021-08-19 12:00:00	ES	Futures	4967.96	4972.46	4959.23	4969.64	116851.0
2021-08-19 13:00:00	ES	Futures	4969.64	4970.21	4947.12	4947.4	119134.0
2021-08-19 14:00:00	ES	Futures	4947.4	4956.41	4930.79	4955.57	217236.0
2021-08-19 15:00:00	ES	Futures	4955.57	4971.62	4951.06	4958.38	228893.0
2021-08-19 16:00:00	ES	Futures	4958.38	4964.29	4957.54	4959.51	44372.0
2021-08-19 18:00:00	ES	Futures	4960.07	4960.35	4954.44	4955.0	6435.0
2021-08-19 19:00:00	ES	Futures	4955.28	4956.69	4947.68	4949.65	8285.0
2021-08-19 20:00:00	ES	Futures	4949.65	4962.89	4949.37	4959.79	12928.0
2021-08-19 21:00:00	ES	Futures	4959.79	4961.76	4942.89	4946.55	17175.0
2021-08-19 22:00:00	ES	Futures	4946.55	4950.78	4945.99	4948.53	8589.0
2021-08-19 23:00:00	ES	Futures	4948.53	4954.16	4946.84	4951.62	8076.0
2021-08-19 00:00:00	NQ	Futures	17204.17	17207.36	17190.84	17198.67	3114.0
2021-08-19 01:00:00	NQ	Futures	17198.96	17200.4	17164.77	17167.67	7120.0
2021-08-19 02:00:00	NQ	Futures	17166.51	17176.65	17078.45	17088.3	17276.0
2021-08-19 03:00:00	NQ	Futures	17088.88	17116.11	17071.79	17093.8	15692.0
2021-08-19 04:00:00	NQ	Futures	17093.51	17097.86	17045.42	17071.21	17144.0
2021-08-19 05:00:00	NQ	Futures	17071.21	17136.38	17047.16	17126.25	15348.0
2021-08-19 06:00:00	NQ	Futures	17125.38	17148.55	17097.28	17100.46	11859.0
2021-08-19 07:00:00	NQ	Futures	17099.6	17114.66	17080.77	17083.08	11519.0
2021-08-19 08:00:00	NQ	Futures	17083.37	17122.77	17072.36	17079.03	16741.0
2021-08-19 09:00:00	NQ	Futures	17078.74	17190.55	17078.16	17151.74	107622.0
2021-08-19 10:00:00	NQ	Futures	17151.74	17264.42	17150.0	17261.53	105768.0
2021-08-19 11:00:00	NQ	Futures	17261.53	17367.55	17249.07	17357.7	81085.0
2021-08-19 12:00:00	NQ	Futures	17357.7	17379.72	17325.55	17365.81	54357.0
2021-08-19 13:00:00	NQ	Futures	17366.1	17367.84	17296.87	17298.32	48748.0
2021-08-19 14:00:00	NQ	Futures	17297.74	17314.25	17215.47	17306.43	79134.0
2021-08-19 15:00:00	NQ	Futures	17305.85	17357.99	17280.65	17298.61	87192.0
2021-08-19 16:00:00	NQ	Futures	17298.9	17321.78	17296.58	17315.7	11120.0
2021-08-19 18:00:00	NQ	Futures	17315.12	17319.46	17292.81	17297.45	3199.0
2021-08-19 19:00:00	NQ	Futures	17297.45	17305.56	17276.59	17284.41	3213.0
2021-08-19 20:00:00	NQ	Futures	17284.99	17331.05	17283.25	17322.36	5835.0
2021-08-19 21:00:00	NQ	Futures	17322.36	17328.15	17275.43	17284.7	6792.0
2021-08-19 22:00:00	NQ	Futures	17284.12	17300.05	17282.09	17286.15	3974.0
2021-08-19 23:00:00	NQ	Futures	17285.28	17302.37	17280.07	17290.49	3645.0
2021-08-19 00:00:00	YM	Futures	38965.3	38973.1	38945.2	38950.8	787.0
2021-08-19 01:00:00	YM	Futures	38950.8	38958.6	38864.7	38864.7	2854.0
2021-08-19 02:00:00	YM	Futures	38863.6	38887.1	38689.3	38705.0	8430.0
2021-08-19 03:00:00	YM	Futures	38706.1	38770.9	38634.6	38689.3	13468.0

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

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