PREVIEW / futures_1hour / 2021-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-05.parquet
  size:    56 KB
  rows:    1,625

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-11-05 00:00:00	ES	Futures	5274.83	5277.09	5274.55	5276.53	2206.0
2021-11-05 01:00:00	ES	Futures	5276.53	5276.81	5275.11	5275.4	3305.0
2021-11-05 02:00:00	ES	Futures	5275.68	5276.24	5273.42	5274.83	4281.0
2021-11-05 03:00:00	ES	Futures	5274.83	5274.83	5268.91	5272.01	8513.0
2021-11-05 04:00:00	ES	Futures	5272.29	5279.35	5272.29	5276.81	16198.0
2021-11-05 05:00:00	ES	Futures	5276.81	5287.25	5276.81	5286.12	12903.0
2021-11-05 06:00:00	ES	Futures	5286.12	5289.22	5285.27	5288.94	16875.0
2021-11-05 07:00:00	ES	Futures	5288.94	5291.48	5283.58	5287.81	24318.0
2021-11-05 08:00:00	ES	Futures	5287.53	5302.21	5286.12	5298.54	57891.0
2021-11-05 09:00:00	ES	Futures	5298.26	5316.03	5296.56	5314.62	214623.0
2021-11-05 10:00:00	ES	Futures	5314.62	5318.86	5309.26	5312.65	193744.0
2021-11-05 11:00:00	ES	Futures	5312.93	5315.19	5303.62	5303.9	141112.0
2021-11-05 12:00:00	ES	Futures	5303.9	5307.85	5297.41	5299.38	110005.0
2021-11-05 13:00:00	ES	Futures	5299.38	5301.36	5276.53	5290.64	190689.0
2021-11-05 14:00:00	ES	Futures	5290.64	5297.97	5288.38	5296.56	90997.0
2021-11-05 15:00:00	ES	Futures	5296.28	5301.92	5288.38	5294.3	209786.0
2021-11-05 16:00:00	ES	Futures	5294.3	5295.43	5286.97	5289.51	59606.0
2021-11-05 00:00:00	NQ	Futures	18936.65	18949.98	18934.91	18944.19	1651.0
2021-11-05 01:00:00	NQ	Futures	18943.32	18946.8	18937.23	18945.64	1238.0
2021-11-05 02:00:00	NQ	Futures	18945.64	18950.56	18929.99	18934.33	1623.0
2021-11-05 03:00:00	NQ	Futures	18934.91	18934.91	18898.4	18915.79	4640.0
2021-11-05 04:00:00	NQ	Futures	18915.79	18958.68	18915.21	18953.75	5919.0
2021-11-05 05:00:00	NQ	Futures	18953.75	19025.92	18953.75	19018.96	7614.0
2021-11-05 06:00:00	NQ	Futures	19018.96	19039.54	19009.11	19011.43	7562.0
2021-11-05 07:00:00	NQ	Futures	19011.14	19016.93	18947.96	18967.95	11682.0
2021-11-05 08:00:00	NQ	Futures	18968.53	19009.4	18930.86	18989.69	20229.0
2021-11-05 09:00:00	NQ	Futures	18989.11	19068.23	18982.73	19031.42	85955.0
2021-11-05 10:00:00	NQ	Futures	19031.13	19063.01	19007.08	19043.31	73558.0
2021-11-05 11:00:00	NQ	Futures	19043.6	19067.94	19018.38	19045.04	48921.0
2021-11-05 12:00:00	NQ	Futures	19045.91	19057.8	18973.75	18991.14	44655.0
2021-11-05 13:00:00	NQ	Futures	18990.85	18997.8	18886.8	18961.0	77615.0
2021-11-05 14:00:00	NQ	Futures	18961.29	18986.21	18941.0	18975.49	40988.0
2021-11-05 15:00:00	NQ	Futures	18975.2	18986.79	18931.44	18955.49	62295.0
2021-11-05 16:00:00	NQ	Futures	18955.78	18958.1	18935.78	18947.96	9542.0
2021-11-05 00:00:00	YM	Futures	40333.6	40344.8	40329.1	40338.1	454.0
2021-11-05 01:00:00	YM	Futures	40339.2	40342.6	40328.0	40328.0	489.0
2021-11-05 02:00:00	YM	Futures	40329.1	40335.9	40319.0	40332.5	710.0
2021-11-05 03:00:00	YM	Futures	40333.6	40334.7	40295.5	40323.5	2054.0
2021-11-05 04:00:00	YM	Futures	40323.5	40367.2	40317.9	40339.2	3444.0
2021-11-05 05:00:00	YM	Futures	40339.2	40384.1	40339.2	40376.2	2572.0
2021-11-05 06:00:00	YM	Futures	40377.3	40391.9	40359.4	40380.7	4176.0
2021-11-05 07:00:00	YM	Futures	40381.8	40430.0	40376.2	40412.1	5620.0
2021-11-05 08:00:00	YM	Futures	40411.0	40545.5	40391.9	40521.9	10438.0
2021-11-05 09:00:00	YM	Futures	40520.8	40732.7	40495.0	40715.8	32673.0
2021-11-05 10:00:00	YM	Futures	40715.8	40773.0	40677.7	40725.9	21856.0
2021-11-05 11:00:00	YM	Futures	40727.0	40734.9	40606.0	40606.0	14701.0
2021-11-05 12:00:00	YM	Futures	40607.1	40650.8	40589.2	40591.4	13872.0
2021-11-05 13:00:00	YM	Futures	40591.4	40615.0	40431.1	40521.9	20697.0
2021-11-05 14:00:00	YM	Futures	40521.9	40606.0	40505.1	40595.9	9939.0
2021-11-05 15:00:00	YM	Futures	40597.0	40648.6	40560.0	40589.2	17581.0

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

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