PREVIEW / futures_1hour / 2023-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-12.parquet
  size:    67 KB
  rows:    2,033

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
2023-07-12 00:00:00	ES	Futures	4913.48	4916.77	4913.48	4915.4	2574.0
2023-07-12 01:00:00	ES	Futures	4915.13	4916.77	4914.03	4914.85	3683.0
2023-07-12 02:00:00	ES	Futures	4914.85	4918.15	4913.21	4914.3	6724.0
2023-07-12 03:00:00	ES	Futures	4914.58	4919.79	4913.21	4918.7	16194.0
2023-07-12 04:00:00	ES	Futures	4918.97	4920.89	4917.32	4920.34	12431.0
2023-07-12 05:00:00	ES	Futures	4920.07	4923.64	4919.79	4921.99	13374.0
2023-07-12 06:00:00	ES	Futures	4921.99	4922.26	4919.24	4919.52	8003.0
2023-07-12 07:00:00	ES	Futures	4919.52	4926.38	4919.24	4924.73	16577.0
2023-07-12 08:00:00	ES	Futures	4924.73	4953.01	4921.44	4946.7	126623.0
2023-07-12 09:00:00	ES	Futures	4946.7	4962.34	4946.15	4960.97	257093.0
2023-07-12 10:00:00	ES	Futures	4960.97	4967.28	4956.03	4961.24	221623.0
2023-07-12 11:00:00	ES	Futures	4961.52	4963.17	4939.28	4941.21	252776.0
2023-07-12 12:00:00	ES	Futures	4940.93	4952.46	4937.91	4948.62	181275.0
2023-07-12 13:00:00	ES	Futures	4948.62	4955.75	4946.42	4954.38	96819.0
2023-07-12 14:00:00	ES	Futures	4954.38	4958.77	4950.54	4953.56	109199.0
2023-07-12 15:00:00	ES	Futures	4953.28	4954.66	4941.21	4951.36	264405.0
2023-07-12 16:00:00	ES	Futures	4951.36	4954.66	4949.72	4951.64	73487.0
2023-07-12 18:00:00	ES	Futures	4952.73	4958.22	4951.36	4955.75	5844.0
2023-07-12 19:00:00	ES	Futures	4955.75	4956.85	4954.38	4954.93	2591.0
2023-07-12 20:00:00	ES	Futures	4954.93	4958.5	4954.11	4957.13	6138.0
2023-07-12 21:00:00	ES	Futures	4957.4	4957.4	4954.11	4956.58	5641.0
2023-07-12 22:00:00	ES	Futures	4956.58	4958.5	4955.75	4958.22	4154.0
2023-07-12 23:00:00	ES	Futures	4957.95	4962.34	4957.68	4962.07	7684.0
2023-07-12 00:00:00	NQ	Futures	16995.2	17011.33	16993.53	17000.49	2268.0
2023-07-12 01:00:00	NQ	Futures	17000.21	17004.94	16989.36	16994.09	2350.0
2023-07-12 02:00:00	NQ	Futures	16994.37	17009.39	16990.48	16996.32	2819.0
2023-07-12 03:00:00	NQ	Futures	16996.04	17020.79	16987.14	17012.17	5798.0
2023-07-12 04:00:00	NQ	Futures	17011.89	17020.51	17004.38	17011.06	4313.0
2023-07-12 05:00:00	NQ	Futures	17011.33	17025.8	17008.55	17016.9	4158.0
2023-07-12 06:00:00	NQ	Futures	17017.18	17018.57	17005.22	17008.55	3923.0
2023-07-12 07:00:00	NQ	Futures	17008.55	17039.98	17004.94	17034.7	6381.0
2023-07-12 08:00:00	NQ	Futures	17034.7	17160.41	17021.63	17134.27	54043.0
2023-07-12 09:00:00	NQ	Futures	17133.99	17210.75	17129.54	17202.69	101433.0
2023-07-12 10:00:00	NQ	Futures	17202.97	17252.75	17186.0	17199.35	95175.0
2023-07-12 11:00:00	NQ	Futures	17199.35	17217.99	17070.58	17089.21	104251.0
2023-07-12 12:00:00	NQ	Futures	17088.66	17170.7	17076.14	17147.62	68687.0
2023-07-12 13:00:00	NQ	Futures	17147.62	17201.3	17135.38	17193.79	43859.0
2023-07-12 14:00:00	NQ	Futures	17193.79	17219.66	17178.49	17190.17	40678.0
2023-07-12 15:00:00	NQ	Futures	17190.73	17212.98	17156.52	17190.45	70137.0
2023-07-12 16:00:00	NQ	Futures	17190.45	17206.03	17180.99	17197.68	13096.0
2023-07-12 18:00:00	NQ	Futures	17197.13	17228.0	17195.74	17213.26	4013.0
2023-07-12 19:00:00	NQ	Futures	17213.26	17219.1	17206.3	17212.42	2019.0
2023-07-12 20:00:00	NQ	Futures	17212.42	17230.5	17210.75	17224.66	3605.0
2023-07-12 21:00:00	NQ	Futures	17224.94	17228.56	17212.7	17225.22	3800.0
2023-07-12 22:00:00	NQ	Futures	17225.77	17236.9	17221.32	17232.45	2606.0
2023-07-12 23:00:00	NQ	Futures	17231.89	17250.81	17230.22	17245.8	4661.0
2023-07-12 00:00:00	YM	Futures	37735.0	37755.8	37732.8	37750.3	920.0
2023-07-12 01:00:00	YM	Futures	37749.2	37763.4	37744.8	37753.6	777.0
2023-07-12 02:00:00	YM	Futures	37753.6	37781.0	37748.1	37759.1	2572.0
2023-07-12 03:00:00	YM	Futures	37759.1	37787.5	37744.8	37786.5	3072.0

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

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