PREVIEW / futures_1hour / 2023-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-17.parquet
  size:    67 KB
  rows:    2,036

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-17 00:00:00	ES	Futures	4582.43	4584.1	4581.88	4583.26	2119.0
2023-05-17 01:00:00	ES	Futures	4582.99	4584.93	4578.55	4581.05	6897.0
2023-05-17 02:00:00	ES	Futures	4580.77	4580.77	4576.61	4577.72	6718.0
2023-05-17 03:00:00	ES	Futures	4578.0	4584.1	4573.0	4579.38	20473.0
2023-05-17 04:00:00	ES	Futures	4579.66	4586.87	4578.55	4585.48	17776.0
2023-05-17 05:00:00	ES	Futures	4585.76	4588.81	4582.71	4588.53	9374.0
2023-05-17 06:00:00	ES	Futures	4588.81	4589.37	4583.26	4588.81	14116.0
2023-05-17 07:00:00	ES	Futures	4589.09	4592.97	4588.53	4590.75	16275.0
2023-05-17 08:00:00	ES	Futures	4590.75	4594.91	4585.48	4594.64	26815.0
2023-05-17 09:00:00	ES	Futures	4594.64	4598.24	4577.44	4579.1	178540.0
2023-05-17 10:00:00	ES	Futures	4579.1	4591.86	4577.16	4591.59	160692.0
2023-05-17 11:00:00	ES	Futures	4591.59	4602.12	4583.82	4599.35	193314.0
2023-05-17 12:00:00	ES	Futures	4599.35	4622.37	4597.41	4619.88	159972.0
2023-05-17 13:00:00	ES	Futures	4620.15	4636.24	4620.15	4634.85	191515.0
2023-05-17 14:00:00	ES	Futures	4634.85	4635.68	4620.98	4621.54	125421.0
2023-05-17 15:00:00	ES	Futures	4621.54	4632.08	4620.43	4628.75	254429.0
2023-05-17 16:00:00	ES	Futures	4628.47	4629.58	4625.7	4627.36	90782.0
2023-05-17 18:00:00	ES	Futures	4627.64	4627.64	4623.2	4625.7	5304.0
2023-05-17 19:00:00	ES	Futures	4625.42	4626.25	4624.04	4626.25	2765.0
2023-05-17 20:00:00	ES	Futures	4625.98	4628.75	4624.04	4624.04	8062.0
2023-05-17 21:00:00	ES	Futures	4624.31	4625.42	4621.82	4622.93	7622.0
2023-05-17 22:00:00	ES	Futures	4622.93	4627.09	4622.37	4626.53	5077.0
2023-05-17 23:00:00	ES	Futures	4626.53	4628.75	4625.15	4625.42	4951.0
2023-05-17 00:00:00	NQ	Futures	15221.32	15225.26	15218.79	15221.32	1402.0
2023-05-17 01:00:00	NQ	Futures	15221.04	15227.79	15204.99	15216.81	3486.0
2023-05-17 02:00:00	NQ	Futures	15216.53	15216.81	15194.29	15198.51	4041.0
2023-05-17 03:00:00	NQ	Futures	15199.08	15210.62	15174.86	15187.81	9181.0
2023-05-17 04:00:00	NQ	Futures	15187.81	15219.91	15187.25	15211.75	7240.0
2023-05-17 05:00:00	NQ	Futures	15212.03	15217.38	15198.51	15215.97	4486.0
2023-05-17 06:00:00	NQ	Futures	15216.53	15217.94	15193.16	15210.06	5982.0
2023-05-17 07:00:00	NQ	Futures	15210.34	15229.2	15209.78	15222.16	6476.0
2023-05-17 08:00:00	NQ	Futures	15222.45	15229.2	15197.11	15227.79	12599.0
2023-05-17 09:00:00	NQ	Futures	15228.08	15248.91	15176.27	15180.21	84681.0
2023-05-17 10:00:00	NQ	Futures	15180.49	15247.5	15177.96	15243.0	79043.0
2023-05-17 11:00:00	NQ	Futures	15243.28	15273.41	15209.78	15264.96	82653.0
2023-05-17 12:00:00	NQ	Futures	15264.68	15333.1	15245.81	15323.24	69767.0
2023-05-17 13:00:00	NQ	Futures	15323.24	15394.19	15322.68	15392.22	76480.0
2023-05-17 14:00:00	NQ	Futures	15392.22	15392.78	15345.77	15348.86	51464.0
2023-05-17 15:00:00	NQ	Futures	15349.14	15386.31	15337.88	15366.88	80901.0
2023-05-17 16:00:00	NQ	Futures	15366.6	15376.45	15355.9	15362.38	15195.0
2023-05-17 18:00:00	NQ	Futures	15362.1	15367.16	15357.59	15361.81	2472.0
2023-05-17 19:00:00	NQ	Futures	15361.53	15368.57	15358.72	15365.47	1820.0
2023-05-17 20:00:00	NQ	Futures	15365.19	15369.13	15351.4	15351.68	3499.0
2023-05-17 21:00:00	NQ	Futures	15352.24	15362.1	15348.3	15356.18	3324.0
2023-05-17 22:00:00	NQ	Futures	15355.9	15369.13	15354.21	15366.32	2907.0
2023-05-17 23:00:00	NQ	Futures	15366.32	15377.86	15364.91	15366.04	2790.0
2023-05-17 00:00:00	YM	Futures	36587.9	36600.1	36586.8	36593.4	590.0
2023-05-17 01:00:00	YM	Futures	36593.4	36605.6	36557.0	36570.2	1113.0
2023-05-17 02:00:00	YM	Futures	36569.1	36578.0	36547.0	36558.1	1329.0
2023-05-17 03:00:00	YM	Futures	36560.3	36616.7	36543.7	36603.4	4056.0

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

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