PREVIEW / futures_1hour / 2020-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-10.parquet
  size:    58 KB
  rows:    1,792

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-10 00:00:00	ES	Futures	4116.83	4117.11	4112.07	4112.91	3904.0
2020-12-10 01:00:00	ES	Futures	4112.91	4114.03	4107.59	4109.27	4583.0
2020-12-10 02:00:00	ES	Futures	4108.99	4113.47	4106.19	4113.19	7507.0
2020-12-10 03:00:00	ES	Futures	4113.47	4117.95	4108.71	4115.43	16208.0
2020-12-10 04:00:00	ES	Futures	4115.15	4124.39	4114.59	4118.79	12201.0
2020-12-10 05:00:00	ES	Futures	4119.07	4122.43	4118.51	4119.35	7883.0
2020-12-10 06:00:00	ES	Futures	4119.63	4120.47	4115.99	4117.39	10592.0
2020-12-10 07:00:00	ES	Futures	4117.67	4118.51	4102.26	4106.19	30585.0
2020-12-10 08:00:00	ES	Futures	4105.91	4110.95	4091.34	4092.46	46141.0
2020-12-10 09:00:00	ES	Futures	4092.18	4116.27	4082.66	4113.75	228121.0
2020-12-10 10:00:00	ES	Futures	4113.75	4119.91	4106.75	4116.83	195591.0
2020-12-10 11:00:00	ES	Futures	4116.83	4121.31	4102.82	4104.78	130301.0
2020-12-10 12:00:00	ES	Futures	4104.5	4114.59	4102.82	4105.91	94666.0
2020-12-10 13:00:00	ES	Futures	4106.19	4115.99	4104.5	4107.03	89486.0
2020-12-10 14:00:00	ES	Futures	4107.31	4109.55	4097.5	4100.58	128824.0
2020-12-10 15:00:00	ES	Futures	4100.86	4117.11	4100.02	4108.71	186216.0
2020-12-10 16:00:00	ES	Futures	4108.71	4110.39	4103.94	4107.59	44246.0
2020-12-10 18:00:00	ES	Futures	4111.79	4116.27	4107.31	4114.31	4548.0
2020-12-10 19:00:00	ES	Futures	4114.03	4117.11	4110.11	4112.63	5384.0
2020-12-10 20:00:00	ES	Futures	4112.35	4114.87	4110.11	4113.47	4966.0
2020-12-10 21:00:00	ES	Futures	4113.19	4113.75	4104.22	4105.91	4870.0
2020-12-10 22:00:00	ES	Futures	4105.91	4106.47	4101.7	4104.78	3698.0
2020-12-10 23:00:00	ES	Futures	4105.06	4106.75	4104.22	4105.63	2640.0
2020-12-10 00:00:00	NQ	Futures	14291.65	14291.94	14266.18	14269.07	2334.0
2020-12-10 01:00:00	NQ	Futures	14269.07	14275.44	14245.62	14259.23	3055.0
2020-12-10 02:00:00	NQ	Futures	14258.65	14274.86	14247.65	14268.78	3988.0
2020-12-10 03:00:00	NQ	Futures	14268.49	14305.54	14256.04	14293.96	8705.0
2020-12-10 04:00:00	NQ	Futures	14294.54	14319.73	14291.65	14310.46	5440.0
2020-12-10 05:00:00	NQ	Futures	14310.75	14330.73	14307.28	14312.49	3630.0
2020-12-10 06:00:00	NQ	Futures	14312.49	14320.31	14291.94	14296.57	3903.0
2020-12-10 07:00:00	NQ	Futures	14297.15	14307.57	14221.02	14239.25	16761.0
2020-12-10 08:00:00	NQ	Futures	14239.25	14266.46	14188.02	14192.94	24616.0
2020-12-10 09:00:00	NQ	Futures	14192.36	14340.28	14147.2	14328.7	93744.0
2020-12-10 10:00:00	NQ	Futures	14328.7	14399.91	14300.91	14390.36	85062.0
2020-12-10 11:00:00	NQ	Futures	14390.36	14414.38	14326.67	14336.52	55023.0
2020-12-10 12:00:00	NQ	Futures	14336.52	14372.41	14302.36	14314.52	46157.0
2020-12-10 13:00:00	NQ	Futures	14314.23	14375.31	14309.31	14348.96	37656.0
2020-12-10 14:00:00	NQ	Futures	14348.96	14357.65	14307.86	14315.1	38951.0
2020-12-10 15:00:00	NQ	Futures	14314.52	14392.38	14312.49	14355.33	45164.0
2020-12-10 16:00:00	NQ	Futures	14355.62	14362.28	14340.28	14344.33	6990.0
2020-12-10 18:00:00	NQ	Futures	14347.23	14370.96	14329.57	14361.7	2960.0
2020-12-10 19:00:00	NQ	Futures	14361.99	14374.15	14343.17	14351.57	2677.0
2020-12-10 20:00:00	NQ	Futures	14350.12	14360.83	14334.2	14341.15	3210.0
2020-12-10 21:00:00	NQ	Futures	14340.86	14342.31	14312.49	14320.31	2749.0
2020-12-10 22:00:00	NQ	Futures	14319.73	14324.65	14309.31	14322.62	2034.0
2020-12-10 23:00:00	NQ	Futures	14322.91	14333.33	14315.39	14328.7	1559.0
2020-12-10 00:00:00	YM	Futures	33268.1	33271.4	33242.6	33247.0	42.0
2020-12-10 01:00:00	YM	Futures	33244.8	33253.7	33216.0	33225.9	63.0
2020-12-10 02:00:00	YM	Futures	33212.6	33254.8	33188.2	33242.6	81.0
2020-12-10 03:00:00	YM	Futures	33258.1	33278.1	33225.9	33255.9	96.0

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

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