PREVIEW / futures_1hour / 2022-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-14.parquet
  size:    70 KB
  rows:    2,046

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-14 00:00:00	ES	Futures	4283.06	4301.76	4283.06	4297.23	14739.0
2022-06-14 01:00:00	ES	Futures	4297.51	4309.13	4295.53	4305.44	11432.0
2022-06-14 02:00:00	ES	Futures	4305.44	4314.22	4303.74	4308.28	17428.0
2022-06-14 03:00:00	ES	Futures	4308.28	4310.26	4284.48	4300.63	29127.0
2022-06-14 04:00:00	ES	Futures	4300.34	4303.18	4273.43	4277.12	27476.0
2022-06-14 05:00:00	ES	Futures	4277.12	4281.37	4269.75	4273.43	25147.0
2022-06-14 06:00:00	ES	Futures	4273.15	4278.25	4258.14	4272.02	33975.0
2022-06-14 07:00:00	ES	Futures	4271.73	4273.43	4256.44	4257.29	24238.0
2022-06-14 08:00:00	ES	Futures	4257.29	4292.13	4257.29	4274.85	59644.0
2022-06-14 09:00:00	ES	Futures	4274.57	4287.03	4245.67	4279.67	238713.0
2022-06-14 10:00:00	ES	Futures	4279.67	4285.33	4230.38	4253.6	309146.0
2022-06-14 11:00:00	ES	Futures	4253.6	4262.95	4230.94	4251.62	227588.0
2022-06-14 12:00:00	ES	Futures	4251.91	4252.47	4224.43	4240.86	159206.0
2022-06-14 13:00:00	ES	Futures	4240.86	4268.9	4225.56	4231.51	161931.0
2022-06-14 14:00:00	ES	Futures	4231.79	4246.24	4218.48	4220.46	144409.0
2022-06-14 15:00:00	ES	Futures	4220.75	4253.04	4202.05	4239.72	313872.0
2022-06-14 16:00:00	ES	Futures	4239.72	4242.27	4230.38	4240.57	55809.0
2022-06-14 18:00:00	ES	Futures	4241.71	4254.17	4240.57	4246.24	6704.0
2022-06-14 19:00:00	ES	Futures	4246.52	4264.09	4241.42	4260.12	7887.0
2022-06-14 20:00:00	ES	Futures	4260.12	4260.97	4248.22	4251.91	9089.0
2022-06-14 21:00:00	ES	Futures	4251.62	4264.65	4250.77	4257.0	12002.0
2022-06-14 22:00:00	ES	Futures	4257.0	4264.94	4256.72	4260.12	7224.0
2022-06-14 23:00:00	ES	Futures	4260.12	4263.8	4252.47	4252.75	5670.0
2022-06-14 00:00:00	NQ	Futures	13218.8	13287.06	13218.8	13264.21	6096.0
2022-06-14 01:00:00	NQ	Futures	13265.37	13325.53	13259.87	13314.83	5457.0
2022-06-14 02:00:00	NQ	Futures	13314.54	13344.91	13308.47	13325.53	6001.0
2022-06-14 03:00:00	NQ	Futures	13324.66	13328.14	13231.53	13282.72	12661.0
2022-06-14 04:00:00	NQ	Futures	13281.57	13291.11	13198.27	13212.44	9668.0
2022-06-14 05:00:00	NQ	Futures	13211.28	13230.95	13189.59	13204.05	9855.0
2022-06-14 06:00:00	NQ	Futures	13202.32	13231.82	13154.3	13208.39	12343.0
2022-06-14 07:00:00	NQ	Futures	13210.42	13212.44	13138.11	13144.47	10315.0
2022-06-14 08:00:00	NQ	Futures	13143.6	13277.23	13143.6	13208.68	23584.0
2022-06-14 09:00:00	NQ	Futures	13208.68	13253.51	13067.82	13196.53	74345.0
2022-06-14 10:00:00	NQ	Futures	13197.69	13232.11	13038.61	13125.09	93255.0
2022-06-14 11:00:00	NQ	Futures	13125.67	13180.04	13056.54	13165.29	68554.0
2022-06-14 12:00:00	NQ	Futures	13165.58	13168.19	13081.7	13139.84	47394.0
2022-06-14 13:00:00	NQ	Futures	13140.13	13253.22	13096.17	13109.47	60163.0
2022-06-14 14:00:00	NQ	Futures	13110.05	13157.2	13074.47	13076.5	44031.0
2022-06-14 15:00:00	NQ	Futures	13076.79	13185.83	12999.56	13132.03	84592.0
2022-06-14 16:00:00	NQ	Futures	13132.03	13147.36	13103.98	13144.76	14051.0
2022-06-14 18:00:00	NQ	Futures	13148.52	13191.04	13146.49	13164.14	3655.0
2022-06-14 19:00:00	NQ	Futures	13164.72	13247.44	13145.05	13225.17	5252.0
2022-06-14 20:00:00	NQ	Futures	13225.46	13228.93	13181.78	13196.82	4101.0
2022-06-14 21:00:00	NQ	Futures	13195.95	13245.12	13189.3	13217.07	5244.0
2022-06-14 22:00:00	NQ	Futures	13216.78	13245.41	13212.44	13227.48	2904.0
2022-06-14 23:00:00	NQ	Futures	13228.06	13239.92	13197.11	13200.58	2815.0
2022-06-14 00:00:00	YM	Futures	34622.1	34748.5	34622.1	34716.9	3253.0
2022-06-14 01:00:00	YM	Futures	34716.9	34778.9	34693.2	34753.0	2451.0
2022-06-14 02:00:00	YM	Futures	34754.1	34807.1	34734.9	34755.2	3267.0
2022-06-14 03:00:00	YM	Futures	34756.4	34773.3	34609.7	34722.5	5096.0

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

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