PREVIEW / futures_1hour / 2022-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-20.parquet
  size:    56 KB
  rows:    1,638

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-20 00:00:00	ES	Futures	4181.37	4184.2	4172.02	4173.44	4725.0
2022-06-20 01:00:00	ES	Futures	4173.16	4178.82	4167.49	4178.25	6401.0
2022-06-20 02:00:00	ES	Futures	4178.25	4187.04	4177.4	4184.49	7591.0
2022-06-20 03:00:00	ES	Futures	4184.49	4191.28	4172.87	4186.19	14481.0
2022-06-20 04:00:00	ES	Futures	4186.19	4197.52	4183.07	4194.12	10692.0
2022-06-20 05:00:00	ES	Futures	4194.12	4194.12	4183.92	4191.57	9771.0
2022-06-20 06:00:00	ES	Futures	4191.57	4200.07	4190.44	4192.7	9745.0
2022-06-20 07:00:00	ES	Futures	4192.7	4203.47	4190.44	4200.63	7960.0
2022-06-20 08:00:00	ES	Futures	4200.92	4202.9	4193.83	4194.4	8071.0
2022-06-20 09:00:00	ES	Futures	4194.4	4200.35	4189.3	4198.65	20047.0
2022-06-20 10:00:00	ES	Futures	4198.37	4203.47	4195.53	4202.62	16668.0
2022-06-20 11:00:00	ES	Futures	4202.33	4220.75	4201.2	4213.38	22352.0
2022-06-20 12:00:00	ES	Futures	4213.66	4215.93	4206.58	4210.55	11742.0
2022-06-20 18:00:00	ES	Futures	4210.55	4212.53	4205.73	4210.83	5803.0
2022-06-20 19:00:00	ES	Futures	4210.55	4217.35	4204.32	4211.68	7087.0
2022-06-20 20:00:00	ES	Futures	4211.4	4224.14	4206.86	4218.76	11052.0
2022-06-20 21:00:00	ES	Futures	4218.76	4221.88	4211.11	4220.75	8394.0
2022-06-20 22:00:00	ES	Futures	4220.75	4225.56	4219.9	4224.43	7307.0
2022-06-20 23:00:00	ES	Futures	4224.14	4239.16	4223.01	4231.51	12463.0
2022-06-20 00:00:00	NQ	Futures	13154.01	13157.48	13119.88	13124.8	3288.0
2022-06-20 01:00:00	NQ	Futures	13125.67	13150.25	13106.0	13150.25	4846.0
2022-06-20 02:00:00	NQ	Futures	13150.54	13173.97	13139.84	13165.29	4739.0
2022-06-20 03:00:00	NQ	Futures	13164.43	13187.57	13108.6	13154.88	9709.0
2022-06-20 04:00:00	NQ	Futures	13154.01	13185.25	13140.71	13175.71	5801.0
2022-06-20 05:00:00	NQ	Futures	13174.55	13174.55	13146.49	13169.63	5184.0
2022-06-20 06:00:00	NQ	Futures	13169.34	13191.33	13158.64	13163.56	5286.0
2022-06-20 07:00:00	NQ	Futures	13164.43	13185.83	13156.04	13180.62	3371.0
2022-06-20 08:00:00	NQ	Futures	13180.04	13188.14	13149.96	13151.7	5080.0
2022-06-20 09:00:00	NQ	Futures	13151.12	13161.53	13111.78	13147.65	13490.0
2022-06-20 10:00:00	NQ	Futures	13147.07	13172.24	13146.2	13163.56	9058.0
2022-06-20 11:00:00	NQ	Futures	13163.27	13216.2	13159.22	13205.79	8432.0
2022-06-20 12:00:00	NQ	Futures	13206.65	13224.88	13192.77	13213.31	7451.0
2022-06-20 18:00:00	NQ	Futures	13219.09	13224.01	13193.35	13214.18	3101.0
2022-06-20 19:00:00	NQ	Futures	13213.6	13239.92	13187.57	13217.36	3950.0
2022-06-20 20:00:00	NQ	Futures	13217.07	13257.27	13201.45	13244.83	5035.0
2022-06-20 21:00:00	NQ	Futures	13243.97	13255.83	13218.51	13253.51	4648.0
2022-06-20 22:00:00	NQ	Futures	13252.07	13268.84	13247.15	13260.74	4085.0
2022-06-20 23:00:00	NQ	Futures	13261.61	13312.81	13257.85	13289.96	5790.0
2022-06-20 00:00:00	YM	Futures	33774.7	33780.3	33711.5	33717.2	1090.0
2022-06-20 01:00:00	YM	Futures	33722.8	33756.7	33678.8	33747.6	1376.0
2022-06-20 02:00:00	YM	Futures	33752.1	33830.0	33745.4	33787.1	2328.0
2022-06-20 03:00:00	YM	Futures	33788.2	33837.9	33729.6	33817.6	3982.0
2022-06-20 04:00:00	YM	Futures	33818.7	33898.8	33800.7	33879.6	3527.0
2022-06-20 05:00:00	YM	Futures	33877.4	33877.4	33795.0	33843.5	2251.0
2022-06-20 06:00:00	YM	Futures	33846.9	33907.9	33844.7	33867.2	1956.0
2022-06-20 07:00:00	YM	Futures	33869.5	33953.0	33850.3	33936.1	1967.0
2022-06-20 08:00:00	YM	Futures	33933.8	33948.5	33888.7	33901.1	2100.0
2022-06-20 09:00:00	YM	Futures	33903.3	33955.2	33833.4	33934.9	6165.0
2022-06-20 10:00:00	YM	Futures	33933.8	33975.6	33893.2	33969.9	5014.0
2022-06-20 11:00:00	YM	Futures	33967.7	34097.4	33950.7	34037.6	7194.0

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

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