PREVIEW / futures_1hour / 2024-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2024/2024-06-07.parquet
  size:    55 KB
  rows:    1,622

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
2024-06-07 00:00:00	ES	Futures	5695.37	5698.02	5695.1	5697.49	1968.0
2024-06-07 01:00:00	ES	Futures	5697.49	5700.67	5697.23	5698.82	4221.0
2024-06-07 02:00:00	ES	Futures	5698.82	5700.67	5697.23	5698.02	6605.0
2024-06-07 03:00:00	ES	Futures	5698.29	5700.41	5693.51	5694.84	9053.0
2024-06-07 04:00:00	ES	Futures	5694.84	5696.96	5689.8	5691.39	10519.0
2024-06-07 05:00:00	ES	Futures	5691.39	5693.78	5689.53	5692.18	7762.0
2024-06-07 06:00:00	ES	Futures	5692.18	5693.25	5687.94	5689.0	7805.0
2024-06-07 07:00:00	ES	Futures	5689.27	5695.37	5685.02	5693.51	13896.0
2024-06-07 08:00:00	ES	Futures	5693.51	5709.16	5655.04	5666.45	133035.0
2024-06-07 09:00:00	ES	Futures	5666.19	5687.41	5664.06	5684.23	213714.0
2024-06-07 10:00:00	ES	Futures	5684.23	5709.96	5682.37	5698.29	206365.0
2024-06-07 11:00:00	ES	Futures	5698.29	5699.61	5683.7	5696.96	157960.0
2024-06-07 12:00:00	ES	Futures	5696.96	5709.69	5692.72	5709.16	122490.0
2024-06-07 13:00:00	ES	Futures	5709.16	5715.0	5702.53	5704.12	100732.0
2024-06-07 14:00:00	ES	Futures	5704.12	5704.39	5678.65	5695.63	195212.0
2024-06-07 15:00:00	ES	Futures	5695.63	5699.35	5681.31	5683.7	230864.0
2024-06-07 16:00:00	ES	Futures	5683.7	5684.23	5678.39	5681.04	54663.0
2024-06-07 00:00:00	NQ	Futures	20418.58	20430.62	20418.31	20426.07	1871.0
2024-06-07 01:00:00	NQ	Futures	20425.81	20437.58	20423.93	20429.82	2659.0
2024-06-07 02:00:00	NQ	Futures	20429.82	20438.11	20419.92	20426.61	3288.0
2024-06-07 03:00:00	NQ	Futures	20426.61	20439.98	20408.42	20416.44	5131.0
2024-06-07 04:00:00	NQ	Futures	20416.44	20432.76	20408.42	20412.7	7004.0
2024-06-07 05:00:00	NQ	Futures	20412.43	20420.46	20405.47	20414.57	4409.0
2024-06-07 06:00:00	NQ	Futures	20413.77	20417.78	20399.05	20404.14	4293.0
2024-06-07 07:00:00	NQ	Futures	20404.4	20435.17	20386.21	20424.2	9980.0
2024-06-07 08:00:00	NQ	Futures	20423.4	20487.33	20266.11	20311.31	54586.0
2024-06-07 09:00:00	NQ	Futures	20311.58	20399.86	20302.49	20365.08	82375.0
2024-06-07 10:00:00	NQ	Futures	20364.81	20456.03	20350.9	20411.63	73115.0
2024-06-07 11:00:00	NQ	Futures	20411.89	20425.27	20346.62	20419.92	63221.0
2024-06-07 12:00:00	NQ	Futures	20419.65	20486.26	20406.28	20481.98	57411.0
2024-06-07 13:00:00	NQ	Futures	20481.98	20496.16	20452.02	20453.09	46340.0
2024-06-07 14:00:00	NQ	Futures	20452.82	20454.7	20327.1	20385.41	84406.0
2024-06-07 15:00:00	NQ	Futures	20386.21	20402.8	20329.24	20373.91	78523.0
2024-06-07 16:00:00	NQ	Futures	20373.91	20378.99	20348.23	20362.67	13219.0
2024-06-07 00:00:00	YM	Futures	41403.2	41421.3	41399.0	41421.3	457.0
2024-06-07 01:00:00	YM	Futures	41421.3	41452.0	41421.3	41445.7	859.0
2024-06-07 02:00:00	YM	Futures	41442.5	41442.5	41418.1	41424.4	1441.0
2024-06-07 03:00:00	YM	Futures	41423.4	41435.1	41384.1	41393.7	1454.0
2024-06-07 04:00:00	YM	Futures	41391.5	41392.6	41324.6	41337.4	2176.0
2024-06-07 05:00:00	YM	Futures	41338.4	41357.6	41326.8	41346.9	1509.0
2024-06-07 06:00:00	YM	Futures	41346.9	41369.2	41332.1	41339.5	1361.0
2024-06-07 07:00:00	YM	Futures	41341.6	41383.0	41318.3	41369.2	2047.0
2024-06-07 08:00:00	YM	Futures	41367.1	41402.1	41104.9	41204.7	13262.0
2024-06-07 09:00:00	YM	Futures	41205.7	41346.9	41187.7	41327.8	24918.0
2024-06-07 10:00:00	YM	Futures	41327.8	41591.1	41308.7	41453.1	26270.0
2024-06-07 11:00:00	YM	Futures	41453.1	41461.6	41361.8	41425.5	16159.0
2024-06-07 12:00:00	YM	Futures	41426.6	41456.3	41367.1	41444.6	10513.0
2024-06-07 13:00:00	YM	Futures	41445.7	41491.3	41392.6	41425.5	8847.0
2024-06-07 14:00:00	YM	Futures	41424.4	41428.7	41279.0	41397.9	17131.0
2024-06-07 15:00:00	YM	Futures	41399.0	41418.1	41238.6	41254.6	19752.0

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

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