PREVIEW / futures_1hour / 2023-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-21.parquet
  size:    55 KB
  rows:    1,625

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-21 00:00:00	ES	Futures	4609.34	4609.61	4605.45	4605.45	4382.0
2023-04-21 01:00:00	ES	Futures	4605.73	4607.95	4605.18	4605.73	6141.0
2023-04-21 02:00:00	ES	Futures	4606.01	4607.67	4599.07	4599.91	10358.0
2023-04-21 03:00:00	ES	Futures	4599.63	4604.07	4594.64	4602.12	20031.0
2023-04-21 04:00:00	ES	Futures	4602.12	4609.06	4599.91	4608.23	15743.0
2023-04-21 05:00:00	ES	Futures	4608.23	4610.72	4604.34	4604.9	12817.0
2023-04-21 06:00:00	ES	Futures	4604.9	4606.29	4594.36	4595.75	18177.0
2023-04-21 07:00:00	ES	Futures	4595.75	4599.91	4592.97	4599.07	17719.0
2023-04-21 08:00:00	ES	Futures	4598.8	4609.06	4596.02	4608.23	33074.0
2023-04-21 09:00:00	ES	Futures	4607.95	4614.05	4595.75	4596.3	230137.0
2023-04-21 10:00:00	ES	Futures	4596.3	4613.22	4587.7	4594.64	349232.0
2023-04-21 11:00:00	ES	Futures	4594.64	4607.67	4593.8	4605.45	204549.0
2023-04-21 12:00:00	ES	Futures	4605.73	4608.5	4599.91	4603.79	120058.0
2023-04-21 13:00:00	ES	Futures	4604.07	4612.66	4601.02	4610.72	121272.0
2023-04-21 14:00:00	ES	Futures	4611.0	4616.27	4605.18	4608.78	120801.0
2023-04-21 15:00:00	ES	Futures	4608.5	4613.22	4601.29	4610.72	212428.0
2023-04-21 16:00:00	ES	Futures	4610.45	4612.11	4607.39	4607.67	58425.0
2023-04-21 00:00:00	NQ	Futures	14744.93	14746.06	14730.85	14733.11	1812.0
2023-04-21 01:00:00	NQ	Futures	14733.67	14742.96	14730.85	14734.51	2678.0
2023-04-21 02:00:00	NQ	Futures	14733.95	14742.96	14702.7	14711.15	6035.0
2023-04-21 03:00:00	NQ	Futures	14711.43	14722.69	14682.99	14708.33	9684.0
2023-04-21 04:00:00	NQ	Futures	14708.33	14737.33	14700.73	14735.92	8608.0
2023-04-21 05:00:00	NQ	Futures	14734.8	14743.81	14714.52	14717.9	6744.0
2023-04-21 06:00:00	NQ	Futures	14718.18	14719.31	14652.02	14655.12	12398.0
2023-04-21 07:00:00	NQ	Futures	14655.68	14677.64	14646.39	14666.66	10475.0
2023-04-21 08:00:00	NQ	Futures	14666.66	14704.67	14653.99	14702.98	15630.0
2023-04-21 09:00:00	NQ	Futures	14702.14	14726.91	14634.56	14635.97	86133.0
2023-04-21 10:00:00	NQ	Futures	14636.25	14732.82	14621.05	14688.9	125289.0
2023-04-21 11:00:00	NQ	Futures	14689.47	14750.0	14686.65	14735.36	80620.0
2023-04-21 12:00:00	NQ	Futures	14735.36	14744.37	14706.36	14722.69	49252.0
2023-04-21 13:00:00	NQ	Futures	14722.97	14760.98	14711.99	14753.94	47204.0
2023-04-21 14:00:00	NQ	Futures	14754.22	14778.15	14728.6	14738.46	40635.0
2023-04-21 15:00:00	NQ	Futures	14738.46	14746.62	14704.95	14740.15	57175.0
2023-04-21 16:00:00	NQ	Futures	14740.15	14747.75	14722.69	14726.35	11638.0
2023-04-21 00:00:00	YM	Futures	37470.0	37471.1	37447.8	37449.0	661.0
2023-04-21 01:00:00	YM	Futures	37447.8	37458.9	37443.4	37449.0	756.0
2023-04-21 02:00:00	YM	Futures	37447.8	37458.9	37405.8	37411.4	1815.0
2023-04-21 03:00:00	YM	Futures	37412.5	37444.5	37379.3	37436.8	3373.0
2023-04-21 04:00:00	YM	Futures	37434.6	37484.3	37429.1	37478.8	3471.0
2023-04-21 05:00:00	YM	Futures	37481.0	37505.3	37457.8	37464.4	3161.0
2023-04-21 06:00:00	YM	Futures	37463.3	37472.2	37419.1	37442.3	3940.0
2023-04-21 07:00:00	YM	Futures	37441.2	37465.5	37413.6	37457.8	2764.0
2023-04-21 08:00:00	YM	Futures	37456.7	37539.6	37436.8	37533.0	4612.0
2023-04-21 09:00:00	YM	Futures	37531.9	37571.6	37454.5	37472.2	22546.0
2023-04-21 10:00:00	YM	Futures	37471.1	37576.1	37369.4	37397.0	29639.0
2023-04-21 11:00:00	YM	Futures	37398.1	37484.3	37380.4	37465.5	15850.0
2023-04-21 12:00:00	YM	Futures	37466.6	37510.9	37426.8	37458.9	11171.0
2023-04-21 13:00:00	YM	Futures	37458.9	37520.8	37434.6	37504.2	10664.0
2023-04-21 14:00:00	YM	Futures	37505.3	37541.8	37470.0	37493.2	9193.0
2023-04-21 15:00:00	YM	Futures	37492.1	37544.0	37446.7	37521.9	14345.0

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

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