PREVIEW / futures_1hour / 2023-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-16.parquet
  size:    66 KB
  rows:    2,047

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
2023-05-16 00:00:00	ES	Futures	4595.47	4596.58	4594.08	4595.19	2977.0
2023-05-16 01:00:00	ES	Futures	4595.19	4595.19	4592.42	4592.97	4611.0
2023-05-16 02:00:00	ES	Futures	4592.69	4594.36	4589.64	4591.31	8072.0
2023-05-16 03:00:00	ES	Futures	4591.31	4605.73	4587.7	4602.68	19327.0
2023-05-16 04:00:00	ES	Futures	4602.96	4604.34	4599.35	4601.29	8934.0
2023-05-16 05:00:00	ES	Futures	4601.02	4603.79	4597.69	4600.46	8293.0
2023-05-16 06:00:00	ES	Futures	4600.46	4601.57	4593.8	4600.46	18164.0
2023-05-16 07:00:00	ES	Futures	4600.46	4602.4	4595.75	4596.58	12561.0
2023-05-16 08:00:00	ES	Futures	4596.3	4603.51	4589.64	4591.59	35019.0
2023-05-16 09:00:00	ES	Futures	4591.86	4602.68	4585.48	4588.81	188989.0
2023-05-16 10:00:00	ES	Futures	4589.09	4594.64	4578.55	4587.43	241922.0
2023-05-16 11:00:00	ES	Futures	4587.15	4594.08	4582.16	4592.14	132867.0
2023-05-16 12:00:00	ES	Futures	4592.42	4597.13	4588.26	4594.08	101265.0
2023-05-16 13:00:00	ES	Futures	4594.08	4594.91	4586.04	4591.86	75916.0
2023-05-16 14:00:00	ES	Futures	4591.86	4592.97	4582.16	4589.92	99602.0
2023-05-16 15:00:00	ES	Futures	4589.92	4591.86	4573.56	4574.11	207978.0
2023-05-16 16:00:00	ES	Futures	4574.11	4583.82	4570.78	4579.1	88569.0
2023-05-16 18:00:00	ES	Futures	4577.44	4580.77	4574.94	4578.55	7086.0
2023-05-16 19:00:00	ES	Futures	4578.55	4581.32	4578.0	4580.77	4167.0
2023-05-16 20:00:00	ES	Futures	4580.77	4582.16	4578.55	4580.77	5522.0
2023-05-16 21:00:00	ES	Futures	4580.77	4584.1	4580.49	4582.99	6719.0
2023-05-16 22:00:00	ES	Futures	4582.99	4586.04	4582.71	4586.04	4777.0
2023-05-16 23:00:00	ES	Futures	4586.04	4586.04	4581.88	4582.43	4274.0
2023-05-16 00:00:00	NQ	Futures	15157.13	15159.1	15152.06	15154.03	1519.0
2023-05-16 01:00:00	NQ	Futures	15154.03	15154.87	15144.74	15149.8	1938.0
2023-05-16 02:00:00	NQ	Futures	15149.24	15153.18	15138.82	15145.02	3494.0
2023-05-16 03:00:00	NQ	Futures	15144.46	15194.85	15134.32	15188.1	10275.0
2023-05-16 04:00:00	NQ	Futures	15188.94	15190.91	15169.23	15174.58	4796.0
2023-05-16 05:00:00	NQ	Futures	15174.3	15183.87	15160.5	15165.01	4530.0
2023-05-16 06:00:00	NQ	Futures	15164.73	15175.71	15150.37	15171.2	6386.0
2023-05-16 07:00:00	NQ	Futures	15170.92	15177.12	15153.75	15160.5	5951.0
2023-05-16 08:00:00	NQ	Futures	15160.22	15181.34	15124.75	15128.41	18388.0
2023-05-16 09:00:00	NQ	Futures	15128.41	15221.6	15120.8	15187.81	98282.0
2023-05-16 10:00:00	NQ	Futures	15187.81	15241.87	15149.8	15225.82	97929.0
2023-05-16 11:00:00	NQ	Futures	15225.26	15257.64	15205.55	15254.26	64705.0
2023-05-16 12:00:00	NQ	Futures	15254.82	15265.24	15235.4	15259.05	48381.0
2023-05-16 13:00:00	NQ	Futures	15259.05	15265.24	15230.61	15254.54	39742.0
2023-05-16 14:00:00	NQ	Futures	15254.26	15258.48	15212.03	15244.41	47513.0
2023-05-16 15:00:00	NQ	Futures	15244.41	15251.16	15183.03	15183.87	68883.0
2023-05-16 16:00:00	NQ	Futures	15183.59	15214.28	15178.24	15207.52	21958.0
2023-05-16 18:00:00	NQ	Futures	15202.17	15210.62	15187.53	15199.36	3423.0
2023-05-16 19:00:00	NQ	Futures	15198.51	15203.86	15195.42	15203.3	2614.0
2023-05-16 20:00:00	NQ	Futures	15203.58	15210.06	15200.48	15208.09	3298.0
2023-05-16 21:00:00	NQ	Futures	15207.52	15224.13	15206.96	15221.88	3848.0
2023-05-16 22:00:00	NQ	Futures	15221.88	15229.77	15218.22	15229.77	2664.0
2023-05-16 23:00:00	NQ	Futures	15229.48	15229.77	15220.19	15221.04	2297.0
2023-05-16 00:00:00	YM	Futures	36839.9	36848.8	36830.0	36839.9	510.0
2023-05-16 01:00:00	YM	Futures	36838.8	36839.9	36814.5	36814.5	888.0
2023-05-16 02:00:00	YM	Futures	36813.4	36831.1	36789.1	36809.0	1417.0
2023-05-16 03:00:00	YM	Futures	36806.8	36908.5	36772.5	36879.7	3588.0

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

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