PREVIEW / futures_1hour / 2023-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-14.parquet
  size:    56 KB
  rows:    1,627

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-04-14 00:00:00	ES	Futures	4627.92	4628.47	4626.53	4626.53	2895.0
2023-04-14 01:00:00	ES	Futures	4626.53	4627.64	4625.98	4627.36	3356.0
2023-04-14 02:00:00	ES	Futures	4627.64	4627.64	4623.2	4624.59	7701.0
2023-04-14 03:00:00	ES	Futures	4624.31	4629.58	4622.93	4627.36	15313.0
2023-04-14 04:00:00	ES	Futures	4627.09	4627.64	4620.15	4621.26	14272.0
2023-04-14 05:00:00	ES	Futures	4621.26	4623.76	4619.88	4622.09	12570.0
2023-04-14 06:00:00	ES	Futures	4622.37	4627.09	4617.1	4624.59	30366.0
2023-04-14 07:00:00	ES	Futures	4624.59	4631.25	4623.2	4626.53	34646.0
2023-04-14 08:00:00	ES	Futures	4626.53	4634.58	4617.66	4622.93	74237.0
2023-04-14 09:00:00	ES	Futures	4622.65	4647.33	4618.77	4644.01	224482.0
2023-04-14 10:00:00	ES	Futures	4644.01	4645.95	4609.34	4615.16	386639.0
2023-04-14 11:00:00	ES	Futures	4615.44	4617.93	4604.34	4610.17	179413.0
2023-04-14 12:00:00	ES	Futures	4610.17	4611.0	4591.59	4594.08	161958.0
2023-04-14 13:00:00	ES	Futures	4594.08	4607.39	4590.75	4601.29	151932.0
2023-04-14 14:00:00	ES	Futures	4601.57	4614.88	4597.69	4613.77	137383.0
2023-04-14 15:00:00	ES	Futures	4614.05	4621.54	4597.69	4618.77	259445.0
2023-04-14 16:00:00	ES	Futures	4618.49	4632.08	4618.49	4628.2	90958.0
2023-04-14 00:00:00	NQ	Futures	14864.31	14867.41	14858.4	14860.09	1564.0
2023-04-14 01:00:00	NQ	Futures	14860.09	14863.18	14856.71	14862.34	1710.0
2023-04-14 02:00:00	NQ	Futures	14862.62	14866.56	14847.42	14851.08	3551.0
2023-04-14 03:00:00	NQ	Futures	14851.08	14885.43	14842.35	14875.01	7344.0
2023-04-14 04:00:00	NQ	Futures	14875.01	14878.95	14842.35	14845.45	6016.0
2023-04-14 05:00:00	NQ	Futures	14845.16	14849.39	14822.08	14829.68	7168.0
2023-04-14 06:00:00	NQ	Futures	14830.24	14837.28	14777.03	14795.05	14111.0
2023-04-14 07:00:00	NQ	Futures	14795.05	14811.94	14783.79	14804.62	13919.0
2023-04-14 08:00:00	NQ	Futures	14804.9	14835.03	14754.5	14777.31	29956.0
2023-04-14 09:00:00	NQ	Futures	14777.31	14924.28	14770.55	14904.85	79866.0
2023-04-14 10:00:00	NQ	Futures	14905.14	14927.94	14770.55	14801.52	117716.0
2023-04-14 11:00:00	NQ	Futures	14801.52	14832.21	14764.64	14785.19	63822.0
2023-04-14 12:00:00	NQ	Futures	14785.76	14786.32	14706.08	14719.59	57887.0
2023-04-14 13:00:00	NQ	Futures	14719.87	14769.43	14708.61	14762.11	51923.0
2023-04-14 14:00:00	NQ	Futures	14762.39	14833.62	14745.49	14829.12	52177.0
2023-04-14 15:00:00	NQ	Futures	14829.4	14855.58	14768.86	14844.6	71661.0
2023-04-14 16:00:00	NQ	Futures	14844.32	14879.51	14840.1	14865.44	17507.0
2023-04-14 00:00:00	YM	Futures	37739.6	37741.9	37727.5	37731.9	605.0
2023-04-14 01:00:00	YM	Futures	37729.7	37737.4	37718.6	37729.7	1222.0
2023-04-14 02:00:00	YM	Futures	37729.7	37729.7	37688.8	37698.8	2550.0
2023-04-14 03:00:00	YM	Futures	37697.6	37720.9	37687.7	37704.3	3133.0
2023-04-14 04:00:00	YM	Futures	37704.3	37712.0	37660.1	37673.3	2887.0
2023-04-14 05:00:00	YM	Futures	37672.2	37713.1	37665.6	37712.0	4983.0
2023-04-14 06:00:00	YM	Futures	37712.0	37790.5	37691.0	37781.7	11122.0
2023-04-14 07:00:00	YM	Futures	37782.8	37862.3	37772.8	37821.4	8918.0
2023-04-14 08:00:00	YM	Futures	37822.5	37884.4	37759.5	37790.5	11091.0
2023-04-14 09:00:00	YM	Futures	37789.4	37845.8	37726.4	37798.2	24133.0
2023-04-14 10:00:00	YM	Futures	37798.2	37798.2	37539.6	37593.7	31189.0
2023-04-14 11:00:00	YM	Futures	37597.1	37601.5	37518.6	37576.1	15125.0
2023-04-14 12:00:00	YM	Futures	37577.2	37588.2	37457.8	37477.7	13926.0
2023-04-14 13:00:00	YM	Futures	37477.7	37590.4	37444.5	37518.6	13777.0
2023-04-14 14:00:00	YM	Futures	37518.6	37593.7	37497.6	37581.6	9619.0
2023-04-14 15:00:00	YM	Futures	37582.7	37641.3	37470.0	37615.9	19609.0

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

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