PREVIEW / futures_1hour / 2022-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-25.parquet
  size:    66 KB
  rows:    2,030

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-25 00:00:00	ES	Futures	4914.25	4940.27	4906.33	4931.22	17200.0
2022-01-25 01:00:00	ES	Futures	4931.22	4939.7	4922.74	4931.22	13117.0
2022-01-25 02:00:00	ES	Futures	4931.5	4938.57	4896.72	4925.56	32073.0
2022-01-25 03:00:00	ES	Futures	4925.56	4930.09	4897.85	4912.56	46333.0
2022-01-25 04:00:00	ES	Futures	4912.56	4955.54	4906.05	4948.47	37887.0
2022-01-25 05:00:00	ES	Futures	4948.47	4958.09	4923.3	4929.81	31345.0
2022-01-25 06:00:00	ES	Futures	4929.52	4943.38	4911.99	4915.95	26934.0
2022-01-25 07:00:00	ES	Futures	4915.95	4922.74	4903.22	4909.44	29202.0
2022-01-25 08:00:00	ES	Futures	4909.73	4912.27	4885.69	4906.33	70822.0
2022-01-25 09:00:00	ES	Futures	4906.62	4922.74	4851.47	4860.24	299004.0
2022-01-25 10:00:00	ES	Futures	4859.67	4915.1	4837.61	4882.86	351634.0
2022-01-25 11:00:00	ES	Futures	4882.58	4903.79	4861.09	4867.87	248668.0
2022-01-25 12:00:00	ES	Futures	4867.59	4902.37	4863.91	4887.39	201155.0
2022-01-25 13:00:00	ES	Futures	4887.39	4941.97	4871.27	4941.12	185149.0
2022-01-25 14:00:00	ES	Futures	4941.12	4980.43	4925.85	4977.88	193839.0
2022-01-25 15:00:00	ES	Futures	4977.88	4979.01	4909.44	4921.89	391718.0
2022-01-25 16:00:00	ES	Futures	4921.89	4929.24	4860.24	4871.27	98765.0
2022-01-25 18:00:00	ES	Futures	4874.09	4943.38	4873.81	4929.24	50666.0
2022-01-25 19:00:00	ES	Futures	4929.24	4931.22	4902.37	4912.56	24540.0
2022-01-25 20:00:00	ES	Futures	4912.56	4928.96	4908.03	4926.13	16093.0
2022-01-25 21:00:00	ES	Futures	4926.41	4935.18	4921.04	4922.45	10256.0
2022-01-25 22:00:00	ES	Futures	4922.17	4939.42	4921.6	4936.03	8792.0
2022-01-25 23:00:00	ES	Futures	4936.03	4938.29	4930.09	4935.46	5768.0
2022-01-25 00:00:00	NQ	Futures	16496.39	16638.4	16463.93	16592.03	13257.0
2022-01-25 01:00:00	NQ	Futures	16591.45	16625.65	16555.8	16576.96	10574.0
2022-01-25 02:00:00	NQ	Futures	16578.12	16607.68	16405.1	16536.97	23670.0
2022-01-25 03:00:00	NQ	Futures	16537.55	16570.01	16423.36	16478.71	28852.0
2022-01-25 04:00:00	NQ	Futures	16477.84	16668.54	16453.21	16637.82	22190.0
2022-01-25 05:00:00	NQ	Futures	16635.79	16661.01	16525.08	16547.98	18885.0
2022-01-25 06:00:00	NQ	Futures	16549.43	16599.86	16471.76	16502.48	16560.0
2022-01-25 07:00:00	NQ	Futures	16503.06	16519.29	16441.04	16476.97	15980.0
2022-01-25 08:00:00	NQ	Futures	16477.84	16486.83	16378.73	16469.73	32033.0
2022-01-25 09:00:00	NQ	Futures	16468.57	16583.05	16303.08	16345.98	114142.0
2022-01-25 10:00:00	NQ	Futures	16342.5	16511.75	16272.07	16375.54	130191.0
2022-01-25 11:00:00	NQ	Futures	16376.41	16437.27	16245.99	16265.7	90064.0
2022-01-25 12:00:00	NQ	Futures	16265.7	16392.93	16254.68	16338.15	71236.0
2022-01-25 13:00:00	NQ	Futures	16337.86	16550.01	16277.87	16545.08	60943.0
2022-01-25 14:00:00	NQ	Futures	16544.79	16693.76	16476.11	16682.17	64235.0
2022-01-25 15:00:00	NQ	Futures	16681.01	16686.51	16363.37	16404.81	113189.0
2022-01-25 16:00:00	NQ	Futures	16404.81	16474.95	16102.24	16139.63	38854.0
2022-01-25 18:00:00	NQ	Futures	16166.58	16521.9	16166.58	16452.63	31697.0
2022-01-25 19:00:00	NQ	Futures	16452.34	16460.46	16352.06	16390.61	15250.0
2022-01-25 20:00:00	NQ	Futures	16390.61	16477.84	16365.11	16461.9	11163.0
2022-01-25 21:00:00	NQ	Futures	16463.64	16507.12	16445.38	16450.02	8466.0
2022-01-25 22:00:00	NQ	Futures	16449.15	16516.1	16447.99	16496.97	6807.0
2022-01-25 23:00:00	NQ	Futures	16498.71	16503.64	16465.09	16498.42	4564.0
2022-01-25 00:00:00	YM	Futures	38133.9	38277.8	38071.0	38219.3	4149.0
2022-01-25 01:00:00	YM	Futures	38221.6	38276.6	38164.3	38237.3	2308.0
2022-01-25 02:00:00	YM	Futures	38237.3	38283.4	38046.3	38237.3	9318.0
2022-01-25 03:00:00	YM	Futures	38239.5	38273.3	38054.1	38182.2	14134.0

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

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