PREVIEW / futures_1hour / 2021-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-08.parquet
  size:    65 KB
  rows:    2,035

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-08 00:00:00	ES	Futures	5282.45	5288.1	5281.89	5287.25	6432.0
2021-11-08 01:00:00	ES	Futures	5287.25	5288.66	5283.58	5284.71	4863.0
2021-11-08 02:00:00	ES	Futures	5284.43	5289.22	5283.58	5287.53	7441.0
2021-11-08 03:00:00	ES	Futures	5287.53	5295.43	5286.68	5294.3	15885.0
2021-11-08 04:00:00	ES	Futures	5294.59	5299.38	5293.18	5296.28	15212.0
2021-11-08 05:00:00	ES	Futures	5296.28	5299.38	5294.3	5297.69	6826.0
2021-11-08 06:00:00	ES	Futures	5297.69	5299.67	5296.56	5298.82	6096.0
2021-11-08 07:00:00	ES	Futures	5298.54	5299.95	5295.43	5296.84	12066.0
2021-11-08 08:00:00	ES	Futures	5296.56	5305.59	5296.56	5305.31	26308.0
2021-11-08 09:00:00	ES	Futures	5305.31	5313.5	5299.95	5304.46	186696.0
2021-11-08 10:00:00	ES	Futures	5304.75	5308.7	5295.72	5300.23	146091.0
2021-11-08 11:00:00	ES	Futures	5300.23	5303.9	5294.3	5296.0	93461.0
2021-11-08 12:00:00	ES	Futures	5296.0	5297.41	5290.64	5295.43	78650.0
2021-11-08 13:00:00	ES	Futures	5295.15	5301.08	5293.18	5300.23	50832.0
2021-11-08 14:00:00	ES	Futures	5300.23	5305.03	5298.54	5304.75	60494.0
2021-11-08 15:00:00	ES	Futures	5305.03	5305.03	5294.59	5299.1	131760.0
2021-11-08 16:00:00	ES	Futures	5299.38	5300.8	5292.33	5296.56	56540.0
2021-11-08 18:00:00	ES	Futures	5295.15	5296.84	5291.48	5292.61	6474.0
2021-11-08 19:00:00	ES	Futures	5292.61	5294.02	5284.99	5285.84	12411.0
2021-11-08 20:00:00	ES	Futures	5285.56	5287.25	5283.3	5284.99	8790.0
2021-11-08 21:00:00	ES	Futures	5285.27	5289.51	5284.99	5288.1	5300.0
2021-11-08 22:00:00	ES	Futures	5288.38	5288.94	5283.02	5284.43	5839.0
2021-11-08 23:00:00	ES	Futures	5284.71	5286.12	5283.86	5285.27	3085.0
2021-11-08 00:00:00	NQ	Futures	18881.01	18915.5	18877.53	18908.54	3616.0
2021-11-08 01:00:00	NQ	Futures	18909.12	18914.34	18879.27	18887.96	2827.0
2021-11-08 02:00:00	NQ	Futures	18886.8	18909.41	18883.62	18894.34	2977.0
2021-11-08 03:00:00	NQ	Futures	18895.79	18939.26	18894.34	18934.62	6778.0
2021-11-08 04:00:00	NQ	Futures	18934.33	18942.45	18926.22	18935.49	5339.0
2021-11-08 05:00:00	NQ	Futures	18935.49	18961.0	18933.75	18947.09	4207.0
2021-11-08 06:00:00	NQ	Futures	18947.38	18968.53	18947.09	18958.1	2882.0
2021-11-08 07:00:00	NQ	Futures	18958.1	18965.92	18937.81	18945.35	5512.0
2021-11-08 08:00:00	NQ	Futures	18945.35	18963.9	18941.29	18959.55	6808.0
2021-11-08 09:00:00	NQ	Futures	18959.84	19005.05	18916.08	18939.84	74256.0
2021-11-08 10:00:00	NQ	Futures	18940.13	18967.95	18898.98	18938.97	74071.0
2021-11-08 11:00:00	NQ	Futures	18938.97	18974.62	18914.63	18934.91	52757.0
2021-11-08 12:00:00	NQ	Futures	18935.49	18951.43	18909.99	18947.67	33501.0
2021-11-08 13:00:00	NQ	Futures	18947.38	18973.46	18938.68	18964.77	27215.0
2021-11-08 14:00:00	NQ	Futures	18964.48	18992.88	18943.32	18974.33	28279.0
2021-11-08 15:00:00	NQ	Futures	18974.62	18975.2	18903.03	18929.99	45131.0
2021-11-08 16:00:00	NQ	Futures	18930.28	18934.04	18898.98	18922.45	10474.0
2021-11-08 18:00:00	NQ	Futures	18914.05	18922.74	18900.72	18908.25	3146.0
2021-11-08 19:00:00	NQ	Futures	18907.96	18912.6	18877.82	18882.75	4663.0
2021-11-08 20:00:00	NQ	Futures	18881.88	18894.05	18875.79	18892.89	2964.0
2021-11-08 21:00:00	NQ	Futures	18892.89	18908.25	18889.12	18903.61	2483.0
2021-11-08 22:00:00	NQ	Futures	18903.32	18906.8	18888.83	18894.63	1822.0
2021-11-08 23:00:00	NQ	Futures	18895.5	18902.74	18890.28	18896.95	1170.0
2021-11-08 00:00:00	YM	Futures	40549.9	40581.3	40543.2	40573.5	993.0
2021-11-08 01:00:00	YM	Futures	40573.5	40586.9	40557.8	40561.2	847.0
2021-11-08 02:00:00	YM	Futures	40558.9	40592.5	40547.7	40578.0	1796.0
2021-11-08 03:00:00	YM	Futures	40576.8	40615.0	40561.2	40610.5	2649.0

> showing 50 of 2,035 rows — these rows as CSV

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