PREVIEW / futures_1hour / 2021-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-26.parquet
  size:    60 KB
  rows:    1,938

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-04-26 00:00:00	ES	Futures	4691.34	4693.31	4691.06	4692.75	2567.0
2021-04-26 01:00:00	ES	Futures	4692.75	4693.03	4688.82	4689.38	4980.0
2021-04-26 02:00:00	ES	Futures	4689.38	4691.06	4688.25	4689.94	4480.0
2021-04-26 03:00:00	ES	Futures	4689.94	4692.47	4686.85	4687.97	13584.0
2021-04-26 04:00:00	ES	Futures	4687.69	4689.1	4681.23	4682.92	12206.0
2021-04-26 05:00:00	ES	Futures	4682.92	4686.01	4682.07	4683.2	6726.0
2021-04-26 06:00:00	ES	Futures	4682.92	4684.88	4679.54	4682.07	8581.0
2021-04-26 07:00:00	ES	Futures	4682.07	4687.97	4680.67	4687.69	11892.0
2021-04-26 08:00:00	ES	Futures	4687.41	4691.06	4686.57	4688.82	18833.0
2021-04-26 09:00:00	ES	Futures	4689.1	4701.74	4688.82	4698.65	160535.0
2021-04-26 10:00:00	ES	Futures	4698.65	4703.99	4697.25	4699.21	145909.0
2021-04-26 11:00:00	ES	Futures	4699.49	4703.71	4697.81	4698.37	74739.0
2021-04-26 12:00:00	ES	Futures	4698.65	4700.05	4694.15	4697.53	74986.0
2021-04-26 13:00:00	ES	Futures	4697.53	4699.21	4694.15	4698.93	56470.0
2021-04-26 14:00:00	ES	Futures	4698.93	4703.43	4698.65	4702.86	52072.0
2021-04-26 15:00:00	ES	Futures	4703.15	4704.55	4690.22	4698.09	237297.0
2021-04-26 16:00:00	ES	Futures	4698.37	4701.46	4694.15	4699.21	61134.0
2021-04-26 18:00:00	ES	Futures	4699.49	4700.62	4697.25	4698.37	3946.0
2021-04-26 19:00:00	ES	Futures	4698.37	4703.15	4697.25	4701.46	5651.0
2021-04-26 20:00:00	ES	Futures	4701.46	4701.46	4696.4	4699.21	6999.0
2021-04-26 21:00:00	ES	Futures	4698.93	4700.9	4697.25	4700.62	8034.0
2021-04-26 22:00:00	ES	Futures	4700.62	4701.46	4698.09	4698.93	3386.0
2021-04-26 23:00:00	ES	Futures	4698.93	4701.46	4697.81	4700.05	3561.0
2021-04-26 00:00:00	NQ	Futures	16132.41	16137.05	16131.26	16133.28	983.0
2021-04-26 01:00:00	NQ	Futures	16133.86	16135.02	16112.15	16112.73	2897.0
2021-04-26 02:00:00	NQ	Futures	16113.31	16117.94	16106.07	16115.62	2397.0
2021-04-26 03:00:00	NQ	Futures	16115.62	16138.49	16098.25	16104.33	5917.0
2021-04-26 04:00:00	NQ	Futures	16103.75	16113.02	16067.57	16078.28	7492.0
2021-04-26 05:00:00	NQ	Futures	16077.7	16084.36	16068.15	16077.12	3382.0
2021-04-26 06:00:00	NQ	Futures	16077.41	16088.99	16068.15	16073.94	3798.0
2021-04-26 07:00:00	NQ	Futures	16073.65	16093.33	16055.99	16091.31	7186.0
2021-04-26 08:00:00	NQ	Futures	16091.6	16121.12	16082.91	16114.18	9402.0
2021-04-26 09:00:00	NQ	Futures	16114.18	16154.99	16098.54	16133.86	66813.0
2021-04-26 10:00:00	NQ	Futures	16133.86	16186.55	16133.28	16165.13	64662.0
2021-04-26 11:00:00	NQ	Futures	16164.84	16199.58	16164.84	16178.73	35566.0
2021-04-26 12:00:00	NQ	Futures	16178.73	16199.0	16159.05	16191.18	32965.0
2021-04-26 13:00:00	NQ	Futures	16191.18	16207.68	16172.94	16204.21	31649.0
2021-04-26 14:00:00	NQ	Futures	16204.21	16236.92	16203.63	16236.34	30201.0
2021-04-26 15:00:00	NQ	Futures	16236.34	16242.13	16192.34	16227.95	54724.0
2021-04-26 16:00:00	NQ	Futures	16227.08	16257.19	16203.63	16236.92	17607.0
2021-04-26 18:00:00	NQ	Futures	16240.4	16242.71	16227.66	16231.42	2312.0
2021-04-26 19:00:00	NQ	Futures	16232.0	16248.5	16228.82	16243.29	2412.0
2021-04-26 20:00:00	NQ	Futures	16243.0	16243.29	16229.4	16234.32	2551.0
2021-04-26 21:00:00	NQ	Futures	16234.32	16241.26	16228.53	16238.08	3243.0
2021-04-26 22:00:00	NQ	Futures	16238.66	16239.24	16229.68	16234.03	1505.0
2021-04-26 23:00:00	NQ	Futures	16233.45	16238.95	16229.68	16236.34	1751.0
2021-04-26 00:00:00	YM	Futures	37848.7	37865.4	37848.7	37862.0	700.0
2021-04-26 01:00:00	YM	Futures	37862.0	37868.7	37835.3	37839.8	1010.0
2021-04-26 02:00:00	YM	Futures	37840.9	37866.5	37836.4	37847.5	929.0
2021-04-26 03:00:00	YM	Futures	37850.9	37855.3	37821.9	37845.3	2267.0

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

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