PREVIEW / futures_1hour / 2022-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-01.parquet
  size:    58 KB
  rows:    1,647

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-07-01 00:00:00	ES	Futures	4255.02	4259.84	4245.11	4250.49	12584.0
2022-07-01 01:00:00	ES	Futures	4250.77	4259.84	4245.11	4253.89	11250.0
2022-07-01 02:00:00	ES	Futures	4253.89	4264.37	4249.07	4256.44	15055.0
2022-07-01 03:00:00	ES	Futures	4256.72	4270.03	4242.84	4259.55	30342.0
2022-07-01 04:00:00	ES	Futures	4259.84	4281.93	4252.47	4279.38	24177.0
2022-07-01 05:00:00	ES	Futures	4279.38	4292.13	4275.98	4291.28	20381.0
2022-07-01 06:00:00	ES	Futures	4291.28	4292.98	4273.43	4276.27	18041.0
2022-07-01 07:00:00	ES	Futures	4276.55	4283.63	4264.09	4270.03	22365.0
2022-07-01 08:00:00	ES	Futures	4270.32	4287.31	4266.07	4284.48	32500.0
2022-07-01 09:00:00	ES	Futures	4284.2	4320.74	4275.7	4308.84	232957.0
2022-07-01 10:00:00	ES	Futures	4309.69	4324.71	4253.04	4271.17	313221.0
2022-07-01 11:00:00	ES	Futures	4271.17	4295.53	4262.39	4271.45	188966.0
2022-07-01 12:00:00	ES	Futures	4271.45	4291.56	4265.5	4274.57	114255.0
2022-07-01 13:00:00	ES	Futures	4274.28	4304.88	4272.02	4303.74	112804.0
2022-07-01 14:00:00	ES	Futures	4304.03	4326.41	4293.26	4323.01	130755.0
2022-07-01 15:00:00	ES	Futures	4323.01	4343.69	4311.68	4337.45	274784.0
2022-07-01 16:00:00	ES	Futures	4337.45	4340.0	4334.05	4334.62	50467.0
2022-07-01 00:00:00	NQ	Futures	13213.31	13228.64	13168.19	13191.9	7512.0
2022-07-01 01:00:00	NQ	Futures	13192.19	13222.56	13169.63	13200.87	7520.0
2022-07-01 02:00:00	NQ	Futures	13200.29	13245.99	13184.96	13227.19	8570.0
2022-07-01 03:00:00	NQ	Futures	13226.9	13277.23	13176.86	13234.42	13842.0
2022-07-01 04:00:00	NQ	Futures	13235.29	13303.84	13203.76	13291.69	11905.0
2022-07-01 05:00:00	NQ	Futures	13291.11	13333.05	13279.25	13328.42	9082.0
2022-07-01 06:00:00	NQ	Futures	13329.58	13337.39	13257.27	13267.4	8678.0
2022-07-01 07:00:00	NQ	Futures	13268.26	13307.02	13223.43	13243.68	10633.0
2022-07-01 08:00:00	NQ	Futures	13244.55	13314.54	13228.64	13300.95	16774.0
2022-07-01 09:00:00	NQ	Futures	13300.08	13420.11	13208.97	13374.12	93265.0
2022-07-01 10:00:00	NQ	Futures	13375.86	13440.65	13190.46	13255.83	113942.0
2022-07-01 11:00:00	NQ	Futures	13256.4	13341.15	13219.38	13250.04	61710.0
2022-07-01 12:00:00	NQ	Futures	13251.2	13301.24	13219.96	13230.37	40563.0
2022-07-01 13:00:00	NQ	Futures	13230.95	13332.47	13226.61	13331.03	41569.0
2022-07-01 14:00:00	NQ	Futures	13331.03	13406.81	13285.91	13396.11	42007.0
2022-07-01 15:00:00	NQ	Futures	13395.82	13455.11	13353.01	13435.15	65643.0
2022-07-01 16:00:00	NQ	Futures	13435.44	13444.12	13424.45	13432.84	10567.0
2022-07-01 00:00:00	YM	Futures	34419.0	34450.6	34359.2	34390.8	2287.0
2022-07-01 01:00:00	YM	Futures	34390.8	34464.1	34354.7	34428.0	2498.0
2022-07-01 02:00:00	YM	Futures	34428.0	34482.2	34385.1	34421.2	2932.0
2022-07-01 03:00:00	YM	Futures	34423.5	34514.9	34326.5	34454.0	5515.0
2022-07-01 04:00:00	YM	Futures	34456.2	34632.2	34412.2	34610.8	4984.0
2022-07-01 05:00:00	YM	Futures	34607.4	34712.4	34587.1	34707.8	4344.0
2022-07-01 06:00:00	YM	Futures	34701.1	34715.7	34577.0	34599.5	3207.0
2022-07-01 07:00:00	YM	Futures	34601.8	34641.3	34512.6	34552.1	4139.0
2022-07-01 08:00:00	YM	Futures	34553.3	34659.3	34521.7	34636.8	4459.0
2022-07-01 09:00:00	YM	Futures	34635.6	34891.8	34605.2	34815.0	27510.0
2022-07-01 10:00:00	YM	Futures	34821.8	34915.5	34361.4	34501.4	31987.0
2022-07-01 11:00:00	YM	Futures	34495.7	34681.9	34442.7	34510.4	19319.0
2022-07-01 12:00:00	YM	Futures	34510.4	34678.5	34481.1	34579.2	9416.0
2022-07-01 13:00:00	YM	Futures	34578.1	34835.4	34565.7	34824.1	10745.0
2022-07-01 14:00:00	YM	Futures	34824.1	35001.2	34749.6	34965.1	11912.0
2022-07-01 15:00:00	YM	Futures	34966.2	35109.5	34890.6	35056.5	18643.0

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

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