PREVIEW / futures_1hour / 2021-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-27.parquet
  size:    64 KB
  rows:    1,978

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-27 00:00:00	ES	Futures	4964.58	4965.7	4963.73	4964.86	1874.0
2021-07-27 01:00:00	ES	Futures	4964.86	4964.86	4961.48	4963.45	6843.0
2021-07-27 02:00:00	ES	Futures	4963.45	4964.01	4961.48	4962.61	12771.0
2021-07-27 03:00:00	ES	Futures	4962.89	4962.89	4945.15	4953.03	46397.0
2021-07-27 04:00:00	ES	Futures	4953.03	4958.94	4945.99	4952.19	28012.0
2021-07-27 05:00:00	ES	Futures	4952.19	4958.66	4947.68	4956.13	19553.0
2021-07-27 06:00:00	ES	Futures	4956.41	4962.32	4955.28	4962.32	11831.0
2021-07-27 07:00:00	ES	Futures	4962.04	4969.08	4962.04	4963.45	17892.0
2021-07-27 08:00:00	ES	Futures	4963.45	4965.7	4959.23	4964.58	19835.0
2021-07-27 09:00:00	ES	Futures	4964.58	4965.14	4944.58	4953.03	187849.0
2021-07-27 10:00:00	ES	Futures	4953.03	4957.25	4937.83	4945.15	276580.0
2021-07-27 11:00:00	ES	Futures	4944.87	4950.78	4924.87	4934.17	229025.0
2021-07-27 12:00:00	ES	Futures	4934.17	4934.45	4920.09	4925.15	146483.0
2021-07-27 13:00:00	ES	Futures	4924.87	4929.66	4916.14	4919.52	113729.0
2021-07-27 14:00:00	ES	Futures	4919.52	4939.23	4918.96	4938.95	131518.0
2021-07-27 15:00:00	ES	Futures	4938.95	4951.06	4935.29	4950.22	192288.0
2021-07-27 16:00:00	ES	Futures	4950.22	4950.78	4935.57	4937.26	66903.0
2021-07-27 18:00:00	ES	Futures	4933.32	4944.02	4933.04	4943.74	10243.0
2021-07-27 19:00:00	ES	Futures	4943.74	4947.68	4941.49	4947.12	6286.0
2021-07-27 20:00:00	ES	Futures	4947.12	4954.44	4945.99	4953.59	11946.0
2021-07-27 21:00:00	ES	Futures	4953.59	4958.1	4946.55	4947.4	15847.0
2021-07-27 22:00:00	ES	Futures	4947.12	4954.16	4938.67	4951.34	14827.0
2021-07-27 23:00:00	ES	Futures	4951.34	4952.19	4943.18	4944.02	6911.0
2021-07-27 00:00:00	NQ	Futures	17495.3	17502.54	17492.4	17499.93	1018.0
2021-07-27 01:00:00	NQ	Futures	17498.78	17499.64	17484.0	17496.46	2715.0
2021-07-27 02:00:00	NQ	Futures	17495.59	17500.8	17488.64	17495.88	2841.0
2021-07-27 03:00:00	NQ	Futures	17496.46	17499.36	17441.13	17470.97	14290.0
2021-07-27 04:00:00	NQ	Futures	17470.39	17485.74	17458.22	17474.15	7404.0
2021-07-27 05:00:00	NQ	Futures	17473.86	17499.93	17463.72	17495.01	5790.0
2021-07-27 06:00:00	NQ	Futures	17495.3	17508.91	17490.95	17508.05	4043.0
2021-07-27 07:00:00	NQ	Futures	17508.34	17533.25	17507.18	17517.03	7363.0
2021-07-27 08:00:00	NQ	Futures	17517.32	17528.61	17506.02	17521.37	7508.0
2021-07-27 09:00:00	NQ	Futures	17521.66	17522.53	17423.46	17430.41	73093.0
2021-07-27 10:00:00	NQ	Futures	17430.41	17449.24	17249.07	17278.91	139523.0
2021-07-27 11:00:00	NQ	Futures	17278.91	17306.72	17170.28	17214.89	102338.0
2021-07-27 12:00:00	NQ	Futures	17214.89	17219.81	17152.9	17173.46	71666.0
2021-07-27 13:00:00	NQ	Futures	17172.31	17189.11	17119.29	17159.27	60349.0
2021-07-27 14:00:00	NQ	Futures	17158.98	17290.49	17158.11	17287.89	54152.0
2021-07-27 15:00:00	NQ	Futures	17287.89	17326.99	17257.18	17323.23	60116.0
2021-07-27 16:00:00	NQ	Futures	17323.23	17344.67	17220.39	17247.33	36427.0
2021-07-27 18:00:00	NQ	Futures	17236.9	17291.94	17225.61	17285.86	6126.0
2021-07-27 19:00:00	NQ	Futures	17286.44	17296.58	17277.17	17289.05	3244.0
2021-07-27 20:00:00	NQ	Futures	17289.05	17320.33	17284.12	17316.28	5358.0
2021-07-27 21:00:00	NQ	Futures	17316.57	17332.79	17298.61	17303.24	7724.0
2021-07-27 22:00:00	NQ	Futures	17303.24	17326.13	17273.11	17313.38	7411.0
2021-07-27 23:00:00	NQ	Futures	17313.96	17320.04	17287.31	17291.65	4094.0
2021-07-27 00:00:00	YM	Futures	39083.7	39093.8	39075.9	39084.8	418.0
2021-07-27 01:00:00	YM	Futures	39081.5	39082.6	39051.3	39069.2	1182.0
2021-07-27 02:00:00	YM	Futures	39068.1	39071.4	39045.7	39055.8	2127.0
2021-07-27 03:00:00	YM	Futures	39054.7	39055.8	38879.3	38965.3	11067.0

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

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