PREVIEW / futures_1hour / 2021-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-12.parquet
  size:    66 KB
  rows:    2,001

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-05-12 00:00:00	ES	Futures	4628.69	4635.71	4619.42	4635.15	21708.0
2021-05-12 01:00:00	ES	Futures	4635.15	4645.27	4633.75	4634.31	17675.0
2021-05-12 02:00:00	ES	Futures	4634.31	4648.08	4632.62	4647.51	14090.0
2021-05-12 03:00:00	ES	Futures	4647.51	4660.72	4643.02	4656.5	28364.0
2021-05-12 04:00:00	ES	Futures	4656.22	4658.19	4641.33	4646.39	23828.0
2021-05-12 05:00:00	ES	Futures	4646.67	4651.45	4639.08	4644.98	16558.0
2021-05-12 06:00:00	ES	Futures	4644.98	4652.29	4637.96	4639.93	28739.0
2021-05-12 07:00:00	ES	Futures	4639.93	4646.67	4636.84	4645.55	24092.0
2021-05-12 08:00:00	ES	Futures	4645.27	4648.92	4602.84	4629.81	155862.0
2021-05-12 09:00:00	ES	Futures	4629.81	4640.49	4621.66	4623.91	337659.0
2021-05-12 10:00:00	ES	Futures	4623.91	4628.41	4596.94	4605.09	357765.0
2021-05-12 11:00:00	ES	Futures	4605.09	4612.95	4583.73	4586.26	244683.0
2021-05-12 12:00:00	ES	Futures	4586.54	4590.76	4574.46	4585.98	252093.0
2021-05-12 13:00:00	ES	Futures	4585.7	4595.53	4575.87	4580.64	219111.0
2021-05-12 14:00:00	ES	Futures	4580.36	4591.6	4569.69	4582.33	205004.0
2021-05-12 15:00:00	ES	Futures	4582.33	4584.01	4552.83	4560.41	437457.0
2021-05-12 16:00:00	ES	Futures	4560.41	4567.44	4552.83	4553.95	88607.0
2021-05-12 18:00:00	ES	Futures	4555.64	4568.0	4555.36	4566.31	10909.0
2021-05-12 19:00:00	ES	Futures	4566.31	4569.69	4563.78	4568.28	7007.0
2021-05-12 20:00:00	ES	Futures	4568.28	4577.27	4558.73	4574.46	21999.0
2021-05-12 21:00:00	ES	Futures	4574.46	4581.49	4568.84	4579.24	16529.0
2021-05-12 22:00:00	ES	Futures	4578.96	4580.08	4573.06	4578.68	10159.0
2021-05-12 23:00:00	ES	Futures	4578.68	4582.33	4574.46	4576.15	8641.0
2021-05-12 00:00:00	NQ	Futures	15324.43	15337.17	15267.69	15333.99	9283.0
2021-05-12 01:00:00	NQ	Futures	15332.83	15385.52	15331.38	15338.04	7404.0
2021-05-12 02:00:00	NQ	Futures	15339.2	15396.52	15331.38	15383.78	7550.0
2021-05-12 03:00:00	NQ	Futures	15383.2	15445.15	15357.15	15420.83	12133.0
2021-05-12 04:00:00	NQ	Futures	15419.97	15437.63	15363.23	15382.04	9211.0
2021-05-12 05:00:00	NQ	Futures	15382.91	15404.62	15346.14	15373.36	7498.0
2021-05-12 06:00:00	NQ	Futures	15372.78	15404.33	15343.25	15353.38	9472.0
2021-05-12 07:00:00	NQ	Futures	15354.25	15381.75	15344.7	15371.91	7783.0
2021-05-12 08:00:00	NQ	Futures	15371.91	15406.94	15158.26	15236.43	51041.0
2021-05-12 09:00:00	NQ	Futures	15236.72	15321.83	15194.16	15236.43	96573.0
2021-05-12 10:00:00	NQ	Futures	15236.14	15241.64	15095.44	15123.23	114077.0
2021-05-12 11:00:00	NQ	Futures	15123.52	15178.82	15062.44	15069.97	72922.0
2021-05-12 12:00:00	NQ	Futures	15069.97	15114.55	15030.6	15108.76	69794.0
2021-05-12 13:00:00	NQ	Futures	15108.76	15157.1	15062.44	15077.78	58782.0
2021-05-12 14:00:00	NQ	Futures	15077.78	15137.71	15038.12	15094.86	55778.0
2021-05-12 15:00:00	NQ	Futures	15094.57	15103.84	15007.15	15052.02	104463.0
2021-05-12 16:00:00	NQ	Futures	15051.44	15080.39	15009.17	15013.51	18180.0
2021-05-12 18:00:00	NQ	Futures	15017.57	15071.99	15017.57	15065.33	5882.0
2021-05-12 19:00:00	NQ	Futures	15064.18	15080.1	15056.65	15071.99	3763.0
2021-05-12 20:00:00	NQ	Futures	15072.28	15109.34	15042.46	15091.97	10696.0
2021-05-12 21:00:00	NQ	Futures	15092.55	15126.42	15077.49	15118.31	7009.0
2021-05-12 22:00:00	NQ	Futures	15116.58	15129.02	15100.65	15123.81	5294.0
2021-05-12 23:00:00	NQ	Futures	15124.68	15133.94	15103.26	15113.39	4760.0
2021-05-12 00:00:00	YM	Futures	37801.9	37862.0	37750.6	37862.0	4767.0
2021-05-12 01:00:00	YM	Futures	37862.0	37934.4	37850.9	37855.3	4061.0
2021-05-12 02:00:00	YM	Futures	37855.3	37974.5	37842.0	37972.3	3218.0
2021-05-12 03:00:00	YM	Futures	37973.4	38054.7	37941.1	38028.0	6206.0

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

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