PREVIEW / futures_1hour / 2021-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-05.parquet
  size:    63 KB
  rows:    1,959

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-05-05 00:00:00	ES	Futures	4687.13	4687.97	4686.01	4687.41	2361.0
2021-05-05 01:00:00	ES	Futures	4687.41	4687.69	4677.3	4683.2	9801.0
2021-05-05 02:00:00	ES	Futures	4683.2	4686.01	4678.7	4680.39	10737.0
2021-05-05 03:00:00	ES	Futures	4680.39	4689.66	4678.98	4686.85	20745.0
2021-05-05 04:00:00	ES	Futures	4687.13	4692.75	4684.6	4688.82	16867.0
2021-05-05 05:00:00	ES	Futures	4688.82	4693.03	4688.82	4689.94	11676.0
2021-05-05 06:00:00	ES	Futures	4689.94	4694.15	4688.82	4690.22	12249.0
2021-05-05 07:00:00	ES	Futures	4690.22	4692.47	4686.01	4690.5	15091.0
2021-05-05 08:00:00	ES	Futures	4690.22	4696.68	4688.54	4692.19	38671.0
2021-05-05 09:00:00	ES	Futures	4691.91	4696.68	4682.35	4686.01	192693.0
2021-05-05 10:00:00	ES	Futures	4686.29	4687.13	4667.46	4683.76	266893.0
2021-05-05 11:00:00	ES	Futures	4684.04	4697.25	4680.95	4696.96	129264.0
2021-05-05 12:00:00	ES	Futures	4697.25	4697.81	4686.01	4686.85	93085.0
2021-05-05 13:00:00	ES	Futures	4686.85	4692.19	4683.2	4689.66	83774.0
2021-05-05 14:00:00	ES	Futures	4689.66	4693.31	4684.32	4687.41	99701.0
2021-05-05 15:00:00	ES	Futures	4687.41	4688.82	4669.99	4676.45	283934.0
2021-05-05 16:00:00	ES	Futures	4676.73	4678.42	4671.12	4673.36	48736.0
2021-05-05 18:00:00	ES	Futures	4673.92	4676.17	4669.99	4670.55	7307.0
2021-05-05 19:00:00	ES	Futures	4670.27	4676.73	4670.27	4676.17	6501.0
2021-05-05 20:00:00	ES	Futures	4675.89	4680.67	4674.49	4678.42	11465.0
2021-05-05 21:00:00	ES	Futures	4678.42	4684.32	4678.14	4682.63	11012.0
2021-05-05 22:00:00	ES	Futures	4682.92	4683.2	4665.78	4670.83	13257.0
2021-05-05 23:00:00	ES	Futures	4670.55	4672.8	4668.59	4671.68	8028.0
2021-05-05 00:00:00	NQ	Futures	15719.01	15722.78	15711.2	15719.3	1215.0
2021-05-05 01:00:00	NQ	Futures	15719.01	15719.3	15664.3	15701.07	6498.0
2021-05-05 02:00:00	NQ	Futures	15701.36	15709.75	15669.22	15681.09	6642.0
2021-05-05 03:00:00	NQ	Futures	15681.67	15725.38	15677.91	15711.78	7397.0
2021-05-05 04:00:00	NQ	Futures	15712.07	15754.33	15712.07	15738.7	7628.0
2021-05-05 05:00:00	NQ	Futures	15738.41	15762.73	15736.96	15747.67	5063.0
2021-05-05 06:00:00	NQ	Futures	15748.25	15776.33	15746.52	15767.94	5140.0
2021-05-05 07:00:00	NQ	Futures	15767.65	15784.15	15745.94	15769.97	7957.0
2021-05-05 08:00:00	NQ	Futures	15770.55	15810.21	15740.73	15774.02	21945.0
2021-05-05 09:00:00	NQ	Futures	15774.31	15824.39	15736.96	15743.33	77699.0
2021-05-05 10:00:00	NQ	Futures	15744.49	15772.86	15666.62	15764.18	97661.0
2021-05-05 11:00:00	NQ	Futures	15763.89	15783.28	15720.17	15778.65	51735.0
2021-05-05 12:00:00	NQ	Futures	15779.23	15785.02	15709.17	15714.38	36753.0
2021-05-05 13:00:00	NQ	Futures	15714.38	15743.33	15689.49	15716.41	34107.0
2021-05-05 14:00:00	NQ	Futures	15716.99	15721.33	15678.78	15682.25	38785.0
2021-05-05 15:00:00	NQ	Futures	15681.67	15689.2	15589.61	15625.8	79743.0
2021-05-05 16:00:00	NQ	Futures	15625.8	15635.06	15604.95	15613.64	9086.0
2021-05-05 18:00:00	NQ	Futures	15614.22	15628.4	15599.74	15600.32	3237.0
2021-05-05 19:00:00	NQ	Futures	15601.77	15635.06	15601.48	15632.75	3493.0
2021-05-05 20:00:00	NQ	Futures	15632.75	15663.43	15629.56	15650.12	4784.0
2021-05-05 21:00:00	NQ	Futures	15650.12	15666.62	15646.06	15658.51	4118.0
2021-05-05 22:00:00	NQ	Futures	15658.8	15661.12	15581.22	15599.16	7359.0
2021-05-05 23:00:00	NQ	Futures	15597.43	15606.4	15576.0	15601.48	5709.0
2021-05-05 00:00:00	YM	Futures	37989.0	37996.8	37984.5	37991.2	723.0
2021-05-05 01:00:00	YM	Futures	37991.2	37995.7	37927.7	37964.5	3002.0
2021-05-05 02:00:00	YM	Futures	37965.6	37990.1	37945.6	37956.7	2131.0
2021-05-05 03:00:00	YM	Futures	37957.8	38023.5	37940.0	38007.9	4568.0

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

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