PREVIEW / futures_1hour / 2022-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-07.parquet
  size:    55 KB
  rows:    1,624

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
2022-01-07 00:00:00	ES	Futures	5314.7	5316.68	5309.04	5315.55	6074.0
2022-01-07 01:00:00	ES	Futures	5315.27	5318.38	5311.59	5312.44	4798.0
2022-01-07 02:00:00	ES	Futures	5312.44	5313.57	5306.5	5309.61	6642.0
2022-01-07 03:00:00	ES	Futures	5309.61	5310.46	5292.64	5296.6	23226.0
2022-01-07 04:00:00	ES	Futures	5296.32	5313.0	5294.06	5307.63	16633.0
2022-01-07 05:00:00	ES	Futures	5307.63	5316.68	5304.24	5313.85	10751.0
2022-01-07 06:00:00	ES	Futures	5313.85	5316.68	5308.48	5308.76	8557.0
2022-01-07 07:00:00	ES	Futures	5308.48	5316.11	5304.8	5305.65	14398.0
2022-01-07 08:00:00	ES	Futures	5305.93	5318.09	5282.74	5291.23	118348.0
2022-01-07 09:00:00	ES	Futures	5291.23	5316.11	5288.4	5309.61	225034.0
2022-01-07 10:00:00	ES	Futures	5309.61	5311.02	5264.36	5271.43	275758.0
2022-01-07 11:00:00	ES	Futures	5271.43	5303.39	5264.64	5298.58	223891.0
2022-01-07 12:00:00	ES	Futures	5298.58	5300.28	5284.72	5293.77	109036.0
2022-01-07 13:00:00	ES	Futures	5293.77	5298.86	5286.42	5290.1	75961.0
2022-01-07 14:00:00	ES	Futures	5290.38	5299.71	5281.05	5296.6	102313.0
2022-01-07 15:00:00	ES	Futures	5296.6	5302.54	5278.78	5281.33	228604.0
2022-01-07 16:00:00	ES	Futures	5281.61	5287.83	5278.78	5279.92	59422.0
2022-01-07 00:00:00	NQ	Futures	18302.53	18309.2	18270.36	18299.63	4302.0
2022-01-07 01:00:00	NQ	Futures	18299.06	18318.47	18276.16	18279.64	3141.0
2022-01-07 02:00:00	NQ	Futures	18278.77	18285.43	18250.08	18262.54	4960.0
2022-01-07 03:00:00	NQ	Futures	18261.67	18270.36	18161.68	18186.61	12174.0
2022-01-07 04:00:00	NQ	Futures	18185.74	18291.52	18180.23	18260.22	9919.0
2022-01-07 05:00:00	NQ	Futures	18259.64	18328.62	18246.6	18308.91	5953.0
2022-01-07 06:00:00	NQ	Futures	18309.78	18341.66	18294.13	18306.01	6018.0
2022-01-07 07:00:00	NQ	Futures	18306.3	18345.72	18276.16	18285.72	7589.0
2022-01-07 08:00:00	NQ	Futures	18286.59	18345.14	18112.41	18174.14	52122.0
2022-01-07 09:00:00	NQ	Futures	18173.85	18348.61	18170.09	18307.75	116257.0
2022-01-07 10:00:00	NQ	Futures	18308.04	18314.13	17980.26	18030.1	130767.0
2022-01-07 11:00:00	NQ	Futures	18030.1	18169.22	18007.21	18136.76	91708.0
2022-01-07 12:00:00	NQ	Futures	18137.05	18153.86	18066.33	18128.06	51779.0
2022-01-07 13:00:00	NQ	Futures	18127.77	18150.67	18071.26	18090.68	39101.0
2022-01-07 14:00:00	NQ	Futures	18091.26	18147.19	18033.29	18129.22	47237.0
2022-01-07 15:00:00	NQ	Futures	18128.06	18166.03	18054.16	18067.2	67161.0
2022-01-07 16:00:00	NQ	Futures	18067.49	18088.94	18049.81	18050.1	14158.0
2022-01-07 00:00:00	YM	Futures	40680.4	40697.3	40650.1	40697.3	982.0
2022-01-07 01:00:00	YM	Futures	40690.6	40710.8	40672.6	40680.4	964.0
2022-01-07 02:00:00	YM	Futures	40679.3	40689.4	40637.7	40667.0	1947.0
2022-01-07 03:00:00	YM	Futures	40669.2	40681.6	40578.2	40604.0	4757.0
2022-01-07 04:00:00	YM	Futures	40602.9	40670.3	40588.3	40641.1	3471.0
2022-01-07 05:00:00	YM	Futures	40640.0	40672.6	40619.8	40653.5	2259.0
2022-01-07 06:00:00	YM	Futures	40652.3	40656.8	40587.2	40589.4	2446.0
2022-01-07 07:00:00	YM	Futures	40589.4	40633.2	40563.6	40572.6	4705.0
2022-01-07 08:00:00	YM	Futures	40573.7	40680.4	40498.4	40534.3	17454.0
2022-01-07 09:00:00	YM	Futures	40536.6	40611.9	40472.5	40581.5	38946.0
2022-01-07 10:00:00	YM	Futures	40583.8	40596.2	40443.3	40498.4	34008.0
2022-01-07 11:00:00	YM	Futures	40499.5	40754.6	40461.3	40719.8	33028.0
2022-01-07 12:00:00	YM	Futures	40719.8	40732.1	40644.5	40682.7	13702.0
2022-01-07 13:00:00	YM	Futures	40682.7	40711.9	40652.3	40687.2	10088.0
2022-01-07 14:00:00	YM	Futures	40688.3	40727.6	40623.1	40714.2	13170.0
2022-01-07 15:00:00	YM	Futures	40715.3	40745.6	40565.8	40577.1	21489.0

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

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