PREVIEW / futures_1hour / 2022-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-21.parquet
  size:    68 KB
  rows:    2,037

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-06-21 00:00:00	ES	Futures	4231.51	4233.49	4228.96	4232.08	5482.0
2022-06-21 01:00:00	ES	Futures	4232.08	4234.06	4223.58	4226.41	7038.0
2022-06-21 02:00:00	ES	Futures	4226.41	4230.66	4215.36	4221.31	14361.0
2022-06-21 03:00:00	ES	Futures	4221.31	4245.39	4219.9	4241.42	28818.0
2022-06-21 04:00:00	ES	Futures	4241.14	4247.94	4238.87	4245.67	17280.0
2022-06-21 05:00:00	ES	Futures	4245.96	4247.94	4237.74	4239.16	11316.0
2022-06-21 06:00:00	ES	Futures	4239.16	4243.69	4236.04	4240.29	12255.0
2022-06-21 07:00:00	ES	Futures	4240.01	4240.57	4222.73	4226.13	20940.0
2022-06-21 08:00:00	ES	Futures	4226.41	4234.06	4221.03	4224.43	23131.0
2022-06-21 09:00:00	ES	Futures	4224.14	4269.18	4223.29	4267.77	182485.0
2022-06-21 10:00:00	ES	Futures	4267.77	4284.48	4262.67	4282.5	179083.0
2022-06-21 11:00:00	ES	Futures	4282.5	4284.48	4260.69	4260.69	130835.0
2022-06-21 12:00:00	ES	Futures	4260.97	4277.12	4257.29	4276.27	114051.0
2022-06-21 13:00:00	ES	Futures	4276.55	4280.8	4266.92	4268.05	90603.0
2022-06-21 14:00:00	ES	Futures	4268.33	4283.06	4264.37	4281.93	128895.0
2022-06-21 15:00:00	ES	Futures	4282.22	4287.31	4265.5	4270.03	209323.0
2022-06-21 16:00:00	ES	Futures	4270.03	4273.43	4264.65	4271.17	50622.0
2022-06-21 18:00:00	ES	Futures	4267.49	4269.18	4261.54	4266.64	6035.0
2022-06-21 19:00:00	ES	Futures	4266.92	4266.92	4259.55	4265.5	6069.0
2022-06-21 20:00:00	ES	Futures	4265.79	4266.35	4249.92	4253.04	11415.0
2022-06-21 21:00:00	ES	Futures	4253.04	4256.44	4242.27	4245.96	9671.0
2022-06-21 22:00:00	ES	Futures	4246.24	4248.51	4229.81	4230.38	10872.0
2022-06-21 23:00:00	ES	Futures	4230.38	4232.93	4224.14	4229.24	12727.0
2022-06-21 00:00:00	NQ	Futures	13289.96	13298.63	13282.15	13295.45	1978.0
2022-06-21 01:00:00	NQ	Futures	13295.45	13302.68	13257.27	13268.84	4250.0
2022-06-21 02:00:00	NQ	Futures	13268.55	13283.88	13225.46	13252.07	6476.0
2022-06-21 03:00:00	NQ	Futures	13252.07	13353.59	13245.99	13326.98	13906.0
2022-06-21 04:00:00	NQ	Futures	13326.69	13359.37	13318.01	13344.04	10191.0
2022-06-21 05:00:00	NQ	Futures	13344.91	13350.7	13302.1	13310.49	5754.0
2022-06-21 06:00:00	NQ	Futures	13309.62	13322.93	13294.58	13314.25	8258.0
2022-06-21 07:00:00	NQ	Futures	13313.96	13313.96	13248.31	13256.4	9722.0
2022-06-21 08:00:00	NQ	Futures	13256.11	13295.45	13237.89	13256.4	12851.0
2022-06-21 09:00:00	NQ	Futures	13255.83	13457.71	13254.67	13454.24	90174.0
2022-06-21 10:00:00	NQ	Futures	13453.95	13511.22	13438.34	13503.99	81924.0
2022-06-21 11:00:00	NQ	Futures	13504.57	13511.22	13427.92	13428.5	51943.0
2022-06-21 12:00:00	NQ	Futures	13428.5	13459.45	13407.39	13454.24	44857.0
2022-06-21 13:00:00	NQ	Futures	13454.53	13470.73	13417.51	13423.87	35380.0
2022-06-21 14:00:00	NQ	Futures	13424.45	13442.96	13393.5	13435.73	41561.0
2022-06-21 15:00:00	NQ	Futures	13436.6	13457.71	13376.73	13396.4	59001.0
2022-06-21 16:00:00	NQ	Futures	13396.11	13410.86	13379.62	13399.29	12107.0
2022-06-21 18:00:00	NQ	Futures	13397.26	13401.02	13370.65	13391.48	3533.0
2022-06-21 19:00:00	NQ	Futures	13391.19	13395.82	13369.21	13391.77	2402.0
2022-06-21 20:00:00	NQ	Futures	13393.21	13396.11	13331.03	13342.6	6615.0
2022-06-21 21:00:00	NQ	Futures	13342.6	13356.48	13307.02	13318.88	5224.0
2022-06-21 22:00:00	NQ	Futures	13318.88	13329.87	13267.68	13270.58	5691.0
2022-06-21 23:00:00	NQ	Futures	13270.29	13283.01	13243.39	13265.95	6098.0
2022-06-21 00:00:00	YM	Futures	34176.4	34193.3	34159.5	34182.0	974.0
2022-06-21 01:00:00	YM	Futures	34180.9	34194.5	34130.1	34147.1	1406.0
2022-06-21 02:00:00	YM	Futures	34145.9	34176.4	34073.7	34118.9	2415.0
2022-06-21 03:00:00	YM	Futures	34116.6	34281.3	34106.4	34264.4	4946.0

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

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