PREVIEW / futures_1hour / 2021-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-02.parquet
  size:    53 KB
  rows:    1,552

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-07-02 00:00:00	ES	Futures	4857.29	4858.7	4857.01	4857.86	2315.0
2021-07-02 01:00:00	ES	Futures	4857.86	4858.14	4854.76	4855.32	4446.0
2021-07-02 02:00:00	ES	Futures	4855.6	4856.17	4853.35	4855.6	8363.0
2021-07-02 03:00:00	ES	Futures	4855.89	4863.77	4853.91	4861.24	27451.0
2021-07-02 04:00:00	ES	Futures	4860.95	4862.36	4853.91	4855.32	14658.0
2021-07-02 05:00:00	ES	Futures	4855.32	4858.98	4854.48	4856.73	9501.0
2021-07-02 06:00:00	ES	Futures	4856.73	4859.83	4855.32	4857.57	9421.0
2021-07-02 07:00:00	ES	Futures	4857.57	4861.24	4857.57	4860.11	15198.0
2021-07-02 08:00:00	ES	Futures	4860.39	4871.09	4857.01	4867.99	62099.0
2021-07-02 09:00:00	ES	Futures	4867.99	4872.22	4864.61	4869.96	126116.0
2021-07-02 10:00:00	ES	Futures	4870.25	4871.94	4867.71	4871.09	94235.0
2021-07-02 11:00:00	ES	Futures	4871.37	4880.1	4870.25	4877.29	90074.0
2021-07-02 12:00:00	ES	Futures	4877.29	4887.14	4876.16	4886.58	81438.0
2021-07-02 13:00:00	ES	Futures	4886.86	4889.39	4884.04	4887.42	74949.0
2021-07-02 14:00:00	ES	Futures	4887.42	4890.24	4885.73	4886.58	63246.0
2021-07-02 15:00:00	ES	Futures	4886.58	4896.15	4885.73	4891.65	172332.0
2021-07-02 16:00:00	ES	Futures	4891.93	4891.93	4885.73	4886.86	49904.0
2021-07-02 00:00:00	NQ	Futures	16829.32	16835.12	16828.74	16830.77	1304.0
2021-07-02 01:00:00	NQ	Futures	16830.77	16834.25	16819.18	16820.92	1869.0
2021-07-02 02:00:00	NQ	Futures	16820.92	16836.85	16816.87	16834.25	2987.0
2021-07-02 03:00:00	NQ	Futures	16834.25	16906.09	16833.38	16886.39	12581.0
2021-07-02 04:00:00	NQ	Futures	16887.26	16893.05	16865.82	16874.51	5603.0
2021-07-02 05:00:00	NQ	Futures	16873.06	16892.47	16870.75	16880.89	4322.0
2021-07-02 06:00:00	NQ	Futures	16881.75	16896.24	16878.28	16887.84	4571.0
2021-07-02 07:00:00	NQ	Futures	16887.55	16919.41	16887.55	16913.33	8350.0
2021-07-02 08:00:00	NQ	Futures	16913.33	16961.42	16895.66	16944.33	30341.0
2021-07-02 09:00:00	NQ	Futures	16944.33	16992.99	16939.69	16978.8	69949.0
2021-07-02 10:00:00	NQ	Futures	16979.09	16986.33	16946.93	16953.6	54232.0
2021-07-02 11:00:00	NQ	Futures	16953.31	17006.61	16950.7	16996.18	40581.0
2021-07-02 12:00:00	NQ	Futures	16996.47	17020.8	16981.98	17019.93	29336.0
2021-07-02 13:00:00	NQ	Futures	17020.22	17026.31	17004.29	17022.25	25964.0
2021-07-02 14:00:00	NQ	Futures	17022.25	17030.94	17013.27	17021.96	21205.0
2021-07-02 15:00:00	NQ	Futures	17021.67	17066.86	17017.33	17050.35	48028.0
2021-07-02 16:00:00	NQ	Futures	17050.06	17050.64	17031.23	17034.42	11065.0
2021-07-02 00:00:00	YM	Futures	38599.9	38611.1	38599.9	38602.2	435.0
2021-07-02 01:00:00	YM	Futures	38602.2	38605.5	38582.1	38586.5	902.0
2021-07-02 02:00:00	YM	Futures	38587.7	38595.5	38568.7	38582.1	1433.0
2021-07-02 03:00:00	YM	Futures	38579.8	38632.3	38553.0	38611.1	4934.0
2021-07-02 04:00:00	YM	Futures	38613.3	38623.4	38540.7	38550.8	2793.0
2021-07-02 05:00:00	YM	Futures	38549.7	38579.8	38540.7	38556.4	1812.0
2021-07-02 06:00:00	YM	Futures	38558.6	38597.7	38548.5	38573.1	2050.0
2021-07-02 07:00:00	YM	Futures	38570.9	38587.7	38563.1	38567.5	1954.0
2021-07-02 08:00:00	YM	Futures	38567.5	38673.7	38535.1	38644.6	8708.0
2021-07-02 09:00:00	YM	Futures	38642.4	38662.5	38546.3	38599.9	18527.0
2021-07-02 10:00:00	YM	Futures	38598.8	38646.9	38583.2	38625.6	9788.0
2021-07-02 11:00:00	YM	Futures	38624.5	38710.5	38607.8	38694.9	8007.0
2021-07-02 12:00:00	YM	Futures	38693.8	38763.1	38679.3	38757.5	7480.0
2021-07-02 13:00:00	YM	Futures	38757.5	38777.6	38708.3	38734.0	7163.0
2021-07-02 14:00:00	YM	Futures	38734.0	38763.1	38724.0	38731.8	5053.0
2021-07-02 15:00:00	YM	Futures	38731.8	38784.3	38727.3	38744.1	12330.0

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

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