PREVIEW / futures_1hour / 2021-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-26.parquet
  size:    62 KB
  rows:    1,946

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
2021-01-26 00:00:00	ES	Futures	4293.92	4299.81	4293.63	4295.6	6751.0
2021-01-26 01:00:00	ES	Futures	4295.88	4296.16	4290.83	4291.95	7661.0
2021-01-26 02:00:00	ES	Futures	4291.95	4300.37	4291.67	4297.0	10561.0
2021-01-26 03:00:00	ES	Futures	4297.28	4313.56	4297.0	4311.04	21957.0
2021-01-26 04:00:00	ES	Futures	4311.32	4319.46	4308.51	4310.76	17568.0
2021-01-26 05:00:00	ES	Futures	4310.76	4314.97	4308.51	4312.72	9919.0
2021-01-26 06:00:00	ES	Futures	4313.0	4325.63	4311.6	4320.3	22509.0
2021-01-26 07:00:00	ES	Futures	4320.3	4329.84	4320.02	4325.91	28015.0
2021-01-26 08:00:00	ES	Futures	4326.19	4328.16	4323.1	4328.16	22202.0
2021-01-26 09:00:00	ES	Futures	4328.16	4336.01	4320.02	4324.23	148025.0
2021-01-26 10:00:00	ES	Futures	4323.95	4330.4	4313.56	4320.58	187622.0
2021-01-26 11:00:00	ES	Futures	4320.58	4326.47	4311.04	4311.6	154582.0
2021-01-26 12:00:00	ES	Futures	4311.6	4318.89	4311.32	4315.81	78471.0
2021-01-26 13:00:00	ES	Futures	4315.81	4325.07	4314.68	4321.7	57340.0
2021-01-26 14:00:00	ES	Futures	4321.98	4325.91	4316.93	4323.1	88009.0
2021-01-26 15:00:00	ES	Futures	4322.82	4326.75	4311.04	4313.84	184019.0
2021-01-26 16:00:00	ES	Futures	4314.12	4326.75	4312.16	4318.33	53374.0
2021-01-26 18:00:00	ES	Futures	4316.93	4325.63	4315.81	4318.89	11477.0
2021-01-26 19:00:00	ES	Futures	4319.18	4320.58	4315.81	4318.61	8145.0
2021-01-26 20:00:00	ES	Futures	4318.61	4321.14	4309.07	4311.88	11272.0
2021-01-26 21:00:00	ES	Futures	4311.6	4311.88	4306.26	4309.07	9628.0
2021-01-26 22:00:00	ES	Futures	4309.07	4311.6	4306.55	4309.91	6190.0
2021-01-26 23:00:00	ES	Futures	4309.91	4311.32	4304.86	4307.39	5593.0
2021-01-26 00:00:00	NQ	Futures	15500.62	15684.99	15499.76	15516.25	2821.0
2021-01-26 01:00:00	NQ	Futures	15516.54	15524.07	15494.26	15500.91	2395.0
2021-01-26 02:00:00	NQ	Futures	15500.62	15535.07	15498.89	15518.86	4577.0
2021-01-26 03:00:00	NQ	Futures	15520.02	15568.93	15515.96	15562.56	7841.0
2021-01-26 04:00:00	NQ	Futures	15561.98	15579.35	15541.14	15549.25	7053.0
2021-01-26 05:00:00	NQ	Futures	15549.25	15561.98	15537.38	15555.33	3376.0
2021-01-26 06:00:00	NQ	Futures	15555.62	15605.4	15551.27	15586.01	8115.0
2021-01-26 07:00:00	NQ	Futures	15586.3	15616.4	15585.14	15589.19	9532.0
2021-01-26 08:00:00	NQ	Futures	15590.35	15605.98	15572.98	15603.95	8948.0
2021-01-26 09:00:00	NQ	Futures	15603.66	15640.13	15544.62	15603.95	84948.0
2021-01-26 10:00:00	NQ	Futures	15603.95	15656.05	15560.25	15640.13	102762.0
2021-01-26 11:00:00	NQ	Futures	15640.13	15667.63	15577.61	15580.8	69275.0
2021-01-26 12:00:00	NQ	Futures	15581.38	15623.92	15579.64	15605.98	32938.0
2021-01-26 13:00:00	NQ	Futures	15606.27	15644.76	15592.66	15629.71	26450.0
2021-01-26 14:00:00	NQ	Futures	15629.71	15642.16	15606.85	15625.08	30167.0
2021-01-26 15:00:00	NQ	Futures	15625.08	15638.39	15593.53	15611.77	49366.0
2021-01-26 16:00:00	NQ	Futures	15612.63	15744.91	15608.29	15689.91	28075.0
2021-01-26 18:00:00	NQ	Futures	15688.47	15729.57	15685.86	15697.15	5266.0
2021-01-26 19:00:00	NQ	Futures	15699.75	15707.28	15680.07	15693.68	3462.0
2021-01-26 20:00:00	NQ	Futures	15693.68	15710.17	15674.57	15688.47	4271.0
2021-01-26 21:00:00	NQ	Futures	15689.33	15693.1	15671.97	15683.26	3172.0
2021-01-26 22:00:00	NQ	Futures	15682.39	15695.99	15670.23	15683.55	2692.0
2021-01-26 23:00:00	NQ	Futures	15683.55	15689.91	15676.31	15685.57	1604.0
2021-01-26 00:00:00	YM	Futures	34046.7	34085.6	34043.4	34056.7	1605.0
2021-01-26 01:00:00	YM	Futures	34054.5	34057.8	34014.6	34027.9	1797.0
2021-01-26 02:00:00	YM	Futures	34026.8	34102.2	34025.7	34083.3	3500.0
2021-01-26 03:00:00	YM	Futures	34083.3	34212.0	34083.3	34195.4	6009.0

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

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