PREVIEW / futures_1hour / 2021-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-12.parquet
  size:    54 KB
  rows:    1,589

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-12 00:00:00	ES	Futures	5248.3	5250.28	5245.76	5250.0	3767.0
2021-11-12 01:00:00	ES	Futures	5250.0	5251.41	5243.22	5244.64	5778.0
2021-11-12 02:00:00	ES	Futures	5244.64	5248.87	5242.94	5245.2	6623.0
2021-11-12 03:00:00	ES	Futures	5245.48	5250.84	5242.94	5248.59	16763.0
2021-11-12 04:00:00	ES	Futures	5248.87	5250.0	5242.1	5245.76	13171.0
2021-11-12 05:00:00	ES	Futures	5245.76	5251.41	5244.92	5249.15	8848.0
2021-11-12 06:00:00	ES	Futures	5249.15	5254.51	5247.18	5253.67	8592.0
2021-11-12 07:00:00	ES	Futures	5253.67	5254.23	5249.43	5249.72	8674.0
2021-11-12 08:00:00	ES	Futures	5250.0	5256.21	5249.43	5254.79	14925.0
2021-11-12 09:00:00	ES	Futures	5254.79	5259.31	5244.35	5246.33	133322.0
2021-11-12 10:00:00	ES	Futures	5246.33	5258.75	5244.64	5258.46	147135.0
2021-11-12 11:00:00	ES	Futures	5258.18	5280.48	5258.18	5278.5	204858.0
2021-11-12 12:00:00	ES	Futures	5278.5	5281.32	5273.42	5275.11	87551.0
2021-11-12 13:00:00	ES	Futures	5275.11	5277.37	5270.32	5276.81	71222.0
2021-11-12 14:00:00	ES	Futures	5276.81	5277.09	5268.62	5273.14	63997.0
2021-11-12 15:00:00	ES	Futures	5273.14	5286.97	5272.57	5279.91	198455.0
2021-11-12 16:00:00	ES	Futures	5280.19	5289.22	5279.35	5284.14	66445.0
2021-11-12 00:00:00	NQ	Futures	18612.06	18624.81	18599.6	18622.78	2238.0
2021-11-12 01:00:00	NQ	Futures	18622.78	18625.68	18585.39	18593.8	3189.0
2021-11-12 02:00:00	NQ	Futures	18592.93	18619.01	18592.93	18606.84	3442.0
2021-11-12 03:00:00	NQ	Futures	18606.26	18639.3	18598.15	18628.58	6429.0
2021-11-12 04:00:00	NQ	Futures	18629.16	18633.79	18591.48	18601.62	5362.0
2021-11-12 05:00:00	NQ	Futures	18601.04	18625.97	18596.41	18616.98	3161.0
2021-11-12 06:00:00	NQ	Futures	18616.98	18631.77	18605.97	18624.81	3353.0
2021-11-12 07:00:00	NQ	Futures	18624.23	18628.29	18609.45	18612.06	3454.0
2021-11-12 08:00:00	NQ	Futures	18612.64	18630.03	18606.55	18623.65	6197.0
2021-11-12 09:00:00	NQ	Futures	18623.94	18652.05	18550.33	18571.77	73480.0
2021-11-12 10:00:00	NQ	Futures	18572.06	18678.72	18571.48	18674.37	72972.0
2021-11-12 11:00:00	NQ	Futures	18673.79	18778.99	18667.12	18768.85	67871.0
2021-11-12 12:00:00	NQ	Futures	18768.85	18780.15	18743.34	18750.01	28105.0
2021-11-12 13:00:00	NQ	Futures	18750.59	18774.07	18729.14	18764.5	26391.0
2021-11-12 14:00:00	NQ	Futures	18764.79	18773.2	18730.59	18749.14	22644.0
2021-11-12 15:00:00	NQ	Futures	18749.14	18795.51	18743.05	18768.27	57000.0
2021-11-12 16:00:00	NQ	Futures	18767.98	18790.3	18766.82	18780.15	12147.0
2021-11-12 00:00:00	YM	Futures	40217.0	40223.8	40198.0	40221.5	653.0
2021-11-12 01:00:00	YM	Futures	40221.5	40233.9	40186.8	40198.0	937.0
2021-11-12 02:00:00	YM	Futures	40199.1	40215.9	40175.6	40193.5	2160.0
2021-11-12 03:00:00	YM	Futures	40191.3	40227.1	40183.4	40218.2	4557.0
2021-11-12 04:00:00	YM	Futures	40217.0	40224.9	40178.9	40206.9	2293.0
2021-11-12 05:00:00	YM	Futures	40206.9	40246.2	40198.0	40224.9	1861.0
2021-11-12 06:00:00	YM	Futures	40223.8	40293.3	40221.5	40288.8	2681.0
2021-11-12 07:00:00	YM	Futures	40287.7	40291.0	40250.7	40252.9	1726.0
2021-11-12 08:00:00	YM	Futures	40254.0	40305.6	40254.0	40293.3	2920.0
2021-11-12 09:00:00	YM	Futures	40292.1	40315.7	40218.2	40223.8	19814.0
2021-11-12 10:00:00	YM	Futures	40222.6	40285.4	40172.2	40226.0	19818.0
2021-11-12 11:00:00	YM	Futures	40226.0	40370.6	40226.0	40353.8	17783.0
2021-11-12 12:00:00	YM	Futures	40352.7	40381.8	40311.2	40320.2	9728.0
2021-11-12 13:00:00	YM	Futures	40320.2	40343.7	40288.8	40341.5	6930.0
2021-11-12 14:00:00	YM	Futures	40340.3	40344.8	40296.6	40314.6	5798.0
2021-11-12 15:00:00	YM	Futures	40315.7	40414.3	40312.3	40363.9	15009.0

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

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