PREVIEW / futures_1hour / 2022-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-18.parquet
  size:    68 KB
  rows:    2,049

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
2022-01-18 00:00:00	ES	Futures	5242.02	5244.28	5236.36	5239.19	8686.0
2022-01-18 01:00:00	ES	Futures	5239.19	5244.28	5237.78	5241.74	6289.0
2022-01-18 02:00:00	ES	Futures	5241.74	5244.0	5232.97	5240.04	11089.0
2022-01-18 03:00:00	ES	Futures	5239.76	5240.04	5208.65	5217.13	42732.0
2022-01-18 04:00:00	ES	Futures	5217.42	5218.55	5192.53	5203.28	43398.0
2022-01-18 05:00:00	ES	Futures	5203.28	5213.17	5201.3	5207.24	23025.0
2022-01-18 06:00:00	ES	Futures	5207.52	5210.35	5199.88	5207.8	20733.0
2022-01-18 07:00:00	ES	Futures	5207.8	5220.53	5207.8	5218.83	33894.0
2022-01-18 08:00:00	ES	Futures	5218.83	5219.96	5207.24	5216.57	45495.0
2022-01-18 09:00:00	ES	Futures	5216.57	5217.98	5178.95	5189.7	286187.0
2022-01-18 10:00:00	ES	Futures	5189.7	5206.1	5179.8	5183.2	304239.0
2022-01-18 11:00:00	ES	Futures	5183.2	5196.77	5172.17	5189.14	204593.0
2022-01-18 12:00:00	ES	Futures	5189.42	5191.4	5162.27	5163.12	171840.0
2022-01-18 13:00:00	ES	Futures	5163.4	5180.65	5159.72	5178.67	156292.0
2022-01-18 14:00:00	ES	Futures	5178.39	5198.75	5173.86	5193.09	159247.0
2022-01-18 15:00:00	ES	Futures	5193.38	5195.92	5158.31	5172.45	374356.0
2022-01-18 16:00:00	ES	Futures	5172.45	5178.39	5166.51	5177.54	64022.0
2022-01-18 18:00:00	ES	Futures	5178.39	5181.78	5167.36	5167.64	13741.0
2022-01-18 19:00:00	ES	Futures	5167.93	5173.02	5160.29	5164.53	16400.0
2022-01-18 20:00:00	ES	Futures	5164.53	5178.95	5163.68	5165.38	20345.0
2022-01-18 21:00:00	ES	Futures	5165.66	5174.43	5151.52	5157.74	21575.0
2022-01-18 22:00:00	ES	Futures	5157.74	5158.59	5145.02	5148.69	19186.0
2022-01-18 23:00:00	ES	Futures	5148.69	5151.81	5137.38	5137.95	14385.0
2022-01-18 00:00:00	NQ	Futures	17912.44	17922.29	17867.81	17884.91	6114.0
2022-01-18 01:00:00	NQ	Futures	17884.91	17919.68	17878.82	17916.21	4931.0
2022-01-18 02:00:00	NQ	Futures	17916.5	17921.42	17881.14	17906.35	7238.0
2022-01-18 03:00:00	NQ	Futures	17905.77	17908.38	17752.17	17803.47	22702.0
2022-01-18 04:00:00	NQ	Futures	17803.18	17810.71	17702.03	17747.82	21449.0
2022-01-18 05:00:00	NQ	Futures	17747.24	17790.14	17737.39	17760.57	10389.0
2022-01-18 06:00:00	NQ	Futures	17761.15	17775.65	17726.96	17760.28	10624.0
2022-01-18 07:00:00	NQ	Futures	17761.15	17827.52	17761.15	17817.67	13927.0
2022-01-18 08:00:00	NQ	Futures	17817.96	17835.06	17762.31	17821.15	23437.0
2022-01-18 09:00:00	NQ	Futures	17821.44	17832.16	17704.06	17775.07	106691.0
2022-01-18 10:00:00	NQ	Futures	17774.78	17893.02	17737.39	17754.49	103310.0
2022-01-18 11:00:00	NQ	Futures	17755.65	17811.0	17684.06	17788.11	69988.0
2022-01-18 12:00:00	NQ	Futures	17788.11	17801.44	17676.24	17683.48	62735.0
2022-01-18 13:00:00	NQ	Futures	17683.48	17710.15	17649.0	17696.53	63032.0
2022-01-18 14:00:00	NQ	Futures	17696.24	17770.43	17669.57	17745.5	60571.0
2022-01-18 15:00:00	NQ	Futures	17745.79	17757.1	17586.97	17637.69	95920.0
2022-01-18 16:00:00	NQ	Futures	17637.69	17669.57	17612.77	17666.67	14370.0
2022-01-18 18:00:00	NQ	Futures	17665.8	17677.11	17611.9	17613.64	6653.0
2022-01-18 19:00:00	NQ	Futures	17613.64	17635.08	17571.32	17589.0	9713.0
2022-01-18 20:00:00	NQ	Futures	17589.58	17652.47	17577.7	17584.37	11585.0
2022-01-18 21:00:00	NQ	Futures	17585.24	17630.74	17491.04	17520.9	15715.0
2022-01-18 22:00:00	NQ	Futures	17521.77	17533.07	17484.09	17509.88	10402.0
2022-01-18 23:00:00	NQ	Futures	17510.17	17526.4	17460.9	17464.67	7362.0
2022-01-18 00:00:00	YM	Futures	40144.4	40165.7	40119.7	40145.5	1853.0
2022-01-18 01:00:00	YM	Futures	40144.4	40178.1	40138.8	40148.9	1486.0
2022-01-18 02:00:00	YM	Futures	40147.8	40178.1	40086.0	40142.1	4421.0
2022-01-18 03:00:00	YM	Futures	40141.0	40143.3	39937.6	39992.7	10666.0

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

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