PREVIEW / futures_1hour / 2021-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-13.parquet
  size:    63 KB
  rows:    1,915

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-13 00:00:00	ES	Futures	4268.09	4268.66	4262.76	4264.73	6499.0
2021-01-13 01:00:00	ES	Futures	4264.73	4266.97	4263.32	4266.69	6870.0
2021-01-13 02:00:00	ES	Futures	4266.97	4268.09	4264.16	4266.41	7609.0
2021-01-13 03:00:00	ES	Futures	4266.13	4267.81	4262.2	4263.6	11113.0
2021-01-13 04:00:00	ES	Futures	4263.6	4268.66	4262.2	4265.57	8847.0
2021-01-13 05:00:00	ES	Futures	4265.85	4266.41	4251.53	4256.59	20754.0
2021-01-13 06:00:00	ES	Futures	4256.59	4258.83	4247.61	4254.06	15356.0
2021-01-13 07:00:00	ES	Futures	4254.06	4256.03	4239.75	4243.68	34887.0
2021-01-13 08:00:00	ES	Futures	4243.68	4253.22	4242.27	4251.82	27252.0
2021-01-13 09:00:00	ES	Futures	4251.82	4263.32	4250.97	4257.99	144748.0
2021-01-13 10:00:00	ES	Futures	4257.99	4268.66	4246.76	4268.37	145067.0
2021-01-13 11:00:00	ES	Futures	4268.09	4270.34	4262.2	4266.41	86779.0
2021-01-13 12:00:00	ES	Futures	4266.41	4275.11	4261.08	4272.87	116517.0
2021-01-13 13:00:00	ES	Futures	4272.87	4275.67	4270.62	4274.55	60126.0
2021-01-13 14:00:00	ES	Futures	4274.55	4281.29	4269.78	4275.67	98213.0
2021-01-13 15:00:00	ES	Futures	4275.67	4277.64	4266.97	4268.94	152855.0
2021-01-13 16:00:00	ES	Futures	4268.94	4274.55	4268.09	4272.58	30874.0
2021-01-13 18:00:00	ES	Futures	4275.67	4278.76	4273.15	4273.43	6547.0
2021-01-13 19:00:00	ES	Futures	4273.43	4281.29	4272.02	4279.6	7911.0
2021-01-13 20:00:00	ES	Futures	4279.88	4284.09	4278.2	4283.81	8490.0
2021-01-13 21:00:00	ES	Futures	4283.81	4284.65	4277.92	4279.32	12134.0
2021-01-13 22:00:00	ES	Futures	4279.32	4286.06	4278.48	4281.85	10620.0
2021-01-13 23:00:00	ES	Futures	4281.85	4282.69	4279.32	4281.57	3592.0
2021-01-13 00:00:00	NQ	Futures	14962.28	14966.91	14947.81	14953.3	2382.0
2021-01-13 01:00:00	NQ	Futures	14952.73	14963.43	14948.09	14962.86	2182.0
2021-01-13 02:00:00	NQ	Futures	14962.86	14966.62	14950.7	14965.46	2855.0
2021-01-13 03:00:00	NQ	Futures	14964.88	14971.25	14941.44	14951.57	6792.0
2021-01-13 04:00:00	NQ	Futures	14951.57	14967.2	14950.41	14958.8	3598.0
2021-01-13 05:00:00	NQ	Futures	14959.38	14968.07	14903.23	14926.1	7591.0
2021-01-13 06:00:00	NQ	Futures	14926.1	14931.02	14884.71	14908.44	6861.0
2021-01-13 07:00:00	NQ	Futures	14907.57	14923.2	14857.5	14869.08	12962.0
2021-01-13 08:00:00	NQ	Futures	14869.66	14902.94	14843.03	14898.89	13786.0
2021-01-13 09:00:00	NQ	Futures	14899.47	14987.46	14889.92	14951.28	72839.0
2021-01-13 10:00:00	NQ	Futures	14950.41	15020.74	14901.21	15018.72	74905.0
2021-01-13 11:00:00	NQ	Futures	15018.43	15042.74	14988.9	15014.66	47980.0
2021-01-13 12:00:00	NQ	Futures	15014.95	15024.22	14979.06	15019.01	38181.0
2021-01-13 13:00:00	NQ	Futures	15019.01	15036.66	15009.45	15025.08	21396.0
2021-01-13 14:00:00	NQ	Futures	15025.08	15054.03	15010.03	15038.11	32030.0
2021-01-13 15:00:00	NQ	Futures	15038.11	15045.06	15001.64	15013.22	39291.0
2021-01-13 16:00:00	NQ	Futures	15013.8	15027.69	15007.72	15019.3	8631.0
2021-01-13 18:00:00	NQ	Futures	15022.19	15033.77	15013.8	15016.98	2548.0
2021-01-13 19:00:00	NQ	Futures	15017.27	15052.29	15012.64	15047.08	3728.0
2021-01-13 20:00:00	NQ	Futures	15046.21	15065.6	15043.9	15060.97	3469.0
2021-01-13 21:00:00	NQ	Futures	15062.13	15067.92	15027.69	15032.9	5089.0
2021-01-13 22:00:00	NQ	Futures	15032.32	15039.27	14973.56	15000.48	7954.0
2021-01-13 23:00:00	NQ	Futures	15000.77	15002.51	14983.98	14999.61	2017.0
2021-01-13 00:00:00	YM	Futures	34428.3	34429.4	34379.5	34402.8	1828.0
2021-01-13 01:00:00	YM	Futures	34398.4	34417.2	34388.4	34412.8	1358.0
2021-01-13 02:00:00	YM	Futures	34412.8	34425.0	34392.8	34402.8	1821.0
2021-01-13 03:00:00	YM	Futures	34401.7	34410.6	34358.4	34377.3	4813.0

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

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