PREVIEW / futures_1hour / 2021-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-18.parquet
  size:    56 KB
  rows:    1,610

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-06-18 00:00:00	ES	Futures	4750.01	4750.01	4746.91	4748.04	5937.0
2021-06-18 01:00:00	ES	Futures	4748.32	4750.29	4747.48	4749.17	5704.0
2021-06-18 02:00:00	ES	Futures	4749.17	4750.01	4747.19	4748.04	8409.0
2021-06-18 03:00:00	ES	Futures	4748.04	4749.45	4741.0	4742.13	18559.0
2021-06-18 04:00:00	ES	Futures	4742.13	4744.94	4741.56	4743.53	17149.0
2021-06-18 05:00:00	ES	Futures	4743.53	4746.35	4742.13	4744.66	12706.0
2021-06-18 06:00:00	ES	Futures	4744.66	4744.66	4737.34	4738.75	19167.0
2021-06-18 07:00:00	ES	Futures	4738.75	4740.16	4726.92	4731.99	34489.0
2021-06-18 08:00:00	ES	Futures	4732.27	4732.27	4700.73	4719.04	141005.0
2021-06-18 09:00:00	ES	Futures	4718.75	4719.6	4694.54	4705.24	335320.0
2021-06-18 10:00:00	ES	Futures	4705.24	4707.77	4689.47	4693.69	305188.0
2021-06-18 11:00:00	ES	Futures	4693.41	4701.86	4686.65	4699.89	179824.0
2021-06-18 12:00:00	ES	Futures	4699.89	4705.8	4694.82	4699.33	94416.0
2021-06-18 13:00:00	ES	Futures	4699.61	4705.24	4691.72	4698.48	90047.0
2021-06-18 14:00:00	ES	Futures	4698.2	4704.11	4688.06	4689.47	100960.0
2021-06-18 15:00:00	ES	Futures	4689.47	4702.14	4676.24	4679.61	308982.0
2021-06-18 16:00:00	ES	Futures	4679.61	4680.46	4663.85	4664.97	152138.0
2021-06-18 00:00:00	NQ	Futures	16443.47	16443.76	16435.07	16439.12	1742.0
2021-06-18 01:00:00	NQ	Futures	16439.7	16459.4	16435.65	16454.19	3164.0
2021-06-18 02:00:00	NQ	Futures	16454.19	16459.11	16436.8	16444.63	4267.0
2021-06-18 03:00:00	NQ	Futures	16443.76	16450.71	16417.4	16426.09	6214.0
2021-06-18 04:00:00	NQ	Futures	16426.09	16441.73	16421.16	16435.07	5965.0
2021-06-18 05:00:00	NQ	Futures	16434.49	16441.15	16428.11	16438.54	4329.0
2021-06-18 06:00:00	NQ	Futures	16437.96	16438.54	16415.37	16427.53	5394.0
2021-06-18 07:00:00	NQ	Futures	16426.96	16431.88	16378.0	16403.49	11987.0
2021-06-18 08:00:00	NQ	Futures	16404.07	16404.36	16281.25	16344.69	39804.0
2021-06-18 09:00:00	NQ	Futures	16344.69	16374.52	16273.71	16333.97	100732.0
2021-06-18 10:00:00	NQ	Futures	16334.84	16366.99	16296.31	16310.5	88036.0
2021-06-18 11:00:00	NQ	Futures	16310.21	16329.91	16233.74	16282.4	72887.0
2021-06-18 12:00:00	NQ	Futures	16282.11	16328.17	16273.13	16317.46	38577.0
2021-06-18 13:00:00	NQ	Futures	16317.46	16348.74	16288.78	16311.08	33448.0
2021-06-18 14:00:00	NQ	Futures	16311.08	16337.73	16260.39	16267.34	37249.0
2021-06-18 15:00:00	NQ	Futures	16267.34	16329.62	16249.38	16270.53	66874.0
2021-06-18 16:00:00	NQ	Futures	16270.53	16278.93	16239.53	16242.72	20238.0
2021-06-18 00:00:00	YM	Futures	37684.9	37684.9	37658.1	37673.7	969.0
2021-06-18 01:00:00	YM	Futures	37672.6	37674.9	37654.7	37664.8	866.0
2021-06-18 02:00:00	YM	Futures	37663.7	37682.7	37648.0	37669.3	1572.0
2021-06-18 03:00:00	YM	Futures	37668.2	37689.4	37603.4	37612.3	2803.0
2021-06-18 04:00:00	YM	Futures	37615.6	37650.3	37612.3	37633.5	2822.0
2021-06-18 05:00:00	YM	Futures	37633.5	37672.6	37622.3	37654.7	2294.0
2021-06-18 06:00:00	YM	Futures	37653.6	37654.7	37573.2	37584.4	3995.0
2021-06-18 07:00:00	YM	Futures	37583.2	37587.7	37465.9	37499.4	6304.0
2021-06-18 08:00:00	YM	Futures	37499.4	37499.4	37215.7	37372.1	25866.0
2021-06-18 09:00:00	YM	Futures	37371.0	37379.9	37144.2	37211.2	42247.0
2021-06-18 10:00:00	YM	Futures	37210.1	37226.8	37061.5	37070.4	35749.0
2021-06-18 11:00:00	YM	Futures	37069.3	37235.8	37045.8	37216.8	22353.0
2021-06-18 12:00:00	YM	Futures	37214.5	37232.4	37129.6	37159.8	11069.0
2021-06-18 13:00:00	YM	Futures	37157.6	37212.3	37118.5	37169.9	8830.0
2021-06-18 14:00:00	YM	Futures	37168.7	37216.8	37120.7	37136.3	9674.0
2021-06-18 15:00:00	YM	Futures	37136.3	37206.7	37029.1	37049.2	21315.0

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

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