PREVIEW / futures_1hour / 2020-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-09.parquet
  size:    60 KB
  rows:    1,873

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
2020-12-09 00:00:00	ES	Futures	4157.72	4158.56	4154.92	4157.72	3530.0
2020-12-09 01:00:00	ES	Futures	4157.72	4159.4	4156.6	4157.44	3694.0
2020-12-09 02:00:00	ES	Futures	4157.44	4159.4	4153.52	4155.2	6392.0
2020-12-09 03:00:00	ES	Futures	4155.2	4161.08	4152.4	4160.24	20095.0
2020-12-09 04:00:00	ES	Futures	4160.24	4160.52	4156.6	4158.0	9548.0
2020-12-09 05:00:00	ES	Futures	4158.0	4158.56	4154.92	4156.88	10231.0
2020-12-09 06:00:00	ES	Futures	4156.88	4156.88	4152.68	4154.36	7979.0
2020-12-09 07:00:00	ES	Futures	4154.64	4156.32	4150.44	4153.24	12702.0
2020-12-09 08:00:00	ES	Futures	4152.96	4154.92	4152.4	4154.64	13086.0
2020-12-09 09:00:00	ES	Futures	4154.36	4157.16	4149.6	4154.64	150283.0
2020-12-09 10:00:00	ES	Futures	4154.36	4154.64	4138.4	4144.84	200475.0
2020-12-09 11:00:00	ES	Futures	4144.84	4145.12	4134.19	4142.32	142441.0
2020-12-09 12:00:00	ES	Futures	4142.32	4142.6	4120.19	4128.59	154486.0
2020-12-09 13:00:00	ES	Futures	4128.59	4129.43	4100.3	4101.14	280197.0
2020-12-09 14:00:00	ES	Futures	4100.86	4117.95	4100.86	4109.55	226693.0
2020-12-09 15:00:00	ES	Futures	4109.55	4123.27	4100.02	4110.39	305921.0
2020-12-09 16:00:00	ES	Futures	4110.39	4114.03	4105.91	4113.19	74037.0
2020-12-09 18:00:00	ES	Futures	4111.23	4119.91	4111.23	4117.11	8870.0
2020-12-09 19:00:00	ES	Futures	4117.11	4120.19	4115.43	4117.67	7654.0
2020-12-09 20:00:00	ES	Futures	4117.39	4120.19	4113.75	4116.27	8468.0
2020-12-09 21:00:00	ES	Futures	4115.99	4120.19	4115.99	4119.63	4633.0
2020-12-09 22:00:00	ES	Futures	4119.63	4120.47	4109.83	4112.07	9293.0
2020-12-09 23:00:00	ES	Futures	4112.07	4117.95	4111.51	4116.55	4070.0
2020-12-09 00:00:00	NQ	Futures	14646.83	14649.72	14635.54	14643.64	1456.0
2020-12-09 01:00:00	NQ	Futures	14643.93	14651.17	14640.75	14642.48	1477.0
2020-12-09 02:00:00	NQ	Futures	14643.06	14648.56	14635.25	14642.48	1935.0
2020-12-09 03:00:00	NQ	Futures	14641.91	14645.09	14620.49	14628.01	6247.0
2020-12-09 04:00:00	NQ	Futures	14628.01	14639.01	14624.54	14636.41	3070.0
2020-12-09 05:00:00	NQ	Futures	14636.41	14639.3	14619.62	14632.35	4454.0
2020-12-09 06:00:00	NQ	Futures	14631.48	14632.06	14617.59	14621.35	2658.0
2020-12-09 07:00:00	NQ	Futures	14621.35	14628.3	14607.17	14617.01	5476.0
2020-12-09 08:00:00	NQ	Futures	14616.72	14627.14	14612.09	14621.93	5686.0
2020-12-09 09:00:00	NQ	Futures	14621.64	14637.27	14575.04	14630.91	58271.0
2020-12-09 10:00:00	NQ	Futures	14631.2	14632.35	14550.14	14607.17	76694.0
2020-12-09 11:00:00	NQ	Futures	14607.17	14609.49	14551.59	14578.22	49804.0
2020-12-09 12:00:00	NQ	Futures	14578.22	14578.8	14422.78	14466.78	70815.0
2020-12-09 13:00:00	NQ	Futures	14467.07	14476.33	14285.57	14287.31	110565.0
2020-12-09 14:00:00	NQ	Futures	14287.6	14366.91	14282.39	14327.25	90629.0
2020-12-09 15:00:00	NQ	Futures	14326.38	14346.36	14249.68	14305.83	94818.0
2020-12-09 16:00:00	NQ	Futures	14305.25	14325.81	14282.39	14301.78	12777.0
2020-12-09 18:00:00	NQ	Futures	14291.36	14325.23	14290.78	14314.81	3698.0
2020-12-09 19:00:00	NQ	Futures	14315.67	14326.38	14309.31	14313.36	2547.0
2020-12-09 20:00:00	NQ	Futures	14313.07	14317.12	14281.52	14300.62	4106.0
2020-12-09 21:00:00	NQ	Futures	14300.62	14312.2	14298.6	14309.6	2073.0
2020-12-09 22:00:00	NQ	Futures	14309.6	14312.78	14260.68	14271.1	5672.0
2020-12-09 23:00:00	NQ	Futures	14271.39	14293.67	14269.07	14291.07	2233.0
2020-12-09 00:00:00	YM	Futures	33468.2	33472.6	33445.0	33460.5	900.0
2020-12-09 01:00:00	YM	Futures	33461.6	33479.3	33457.1	33464.9	1042.0
2020-12-09 02:00:00	YM	Futures	33466.0	33477.1	33417.3	33429.5	2322.0
2020-12-09 03:00:00	YM	Futures	33431.7	33495.8	33391.9	33493.6	6593.0

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

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