PREVIEW / futures_1hour / 2021-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-04.parquet
  size:    63 KB
  rows:    1,960

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-08-04 00:00:00	ES	Futures	4967.67	4969.36	4967.39	4968.8	1939.0
2021-08-04 01:00:00	ES	Futures	4969.08	4971.05	4967.11	4970.49	4620.0
2021-08-04 02:00:00	ES	Futures	4970.49	4972.74	4968.8	4971.05	6899.0
2021-08-04 03:00:00	ES	Futures	4971.33	4972.74	4965.42	4965.98	14198.0
2021-08-04 04:00:00	ES	Futures	4965.7	4969.93	4964.58	4968.24	12276.0
2021-08-04 05:00:00	ES	Futures	4968.24	4971.05	4967.11	4968.8	8086.0
2021-08-04 06:00:00	ES	Futures	4969.08	4972.18	4968.24	4969.93	5217.0
2021-08-04 07:00:00	ES	Futures	4969.64	4969.93	4963.45	4963.73	16925.0
2021-08-04 08:00:00	ES	Futures	4964.01	4965.98	4953.31	4957.54	56520.0
2021-08-04 09:00:00	ES	Futures	4957.25	4962.61	4953.59	4959.79	169896.0
2021-08-04 10:00:00	ES	Futures	4959.79	4965.14	4949.09	4953.88	175001.0
2021-08-04 11:00:00	ES	Futures	4953.59	4959.51	4945.99	4953.88	129511.0
2021-08-04 12:00:00	ES	Futures	4953.59	4957.25	4951.06	4955.28	62314.0
2021-08-04 13:00:00	ES	Futures	4955.57	4962.04	4955.0	4958.66	60967.0
2021-08-04 14:00:00	ES	Futures	4958.66	4963.45	4955.57	4956.97	77448.0
2021-08-04 15:00:00	ES	Futures	4956.97	4958.94	4948.24	4949.09	145981.0
2021-08-04 16:00:00	ES	Futures	4948.81	4952.47	4948.53	4951.9	41012.0
2021-08-04 18:00:00	ES	Futures	4951.62	4955.0	4949.93	4954.16	5003.0
2021-08-04 19:00:00	ES	Futures	4953.88	4954.16	4951.62	4953.03	2461.0
2021-08-04 20:00:00	ES	Futures	4953.03	4962.04	4952.75	4959.79	9379.0
2021-08-04 21:00:00	ES	Futures	4959.51	4959.79	4956.69	4958.94	6061.0
2021-08-04 22:00:00	ES	Futures	4958.66	4960.92	4956.41	4957.54	3575.0
2021-08-04 23:00:00	ES	Futures	4957.82	4959.51	4957.54	4958.38	2258.0
2021-08-04 00:00:00	NQ	Futures	17430.12	17441.13	17429.54	17435.05	1585.0
2021-08-04 01:00:00	NQ	Futures	17434.76	17461.41	17430.7	17455.61	3986.0
2021-08-04 02:00:00	NQ	Futures	17455.32	17466.33	17451.56	17454.74	3340.0
2021-08-04 03:00:00	NQ	Futures	17454.45	17461.12	17436.78	17439.68	4411.0
2021-08-04 04:00:00	NQ	Futures	17438.81	17447.5	17427.8	17442.58	3920.0
2021-08-04 05:00:00	NQ	Futures	17442.58	17449.24	17435.34	17442.0	2829.0
2021-08-04 06:00:00	NQ	Futures	17442.0	17453.88	17439.68	17444.61	2488.0
2021-08-04 07:00:00	NQ	Futures	17444.9	17448.08	17419.4	17423.75	5743.0
2021-08-04 08:00:00	NQ	Futures	17424.04	17448.08	17399.13	17415.06	17943.0
2021-08-04 09:00:00	NQ	Futures	17414.48	17461.41	17402.31	17446.34	75190.0
2021-08-04 10:00:00	NQ	Futures	17446.34	17453.88	17377.4	17416.22	89548.0
2021-08-04 11:00:00	NQ	Futures	17415.93	17446.63	17394.78	17446.34	52160.0
2021-08-04 12:00:00	NQ	Futures	17445.76	17461.12	17432.44	17455.9	33063.0
2021-08-04 13:00:00	NQ	Futures	17456.19	17500.51	17455.9	17467.49	40463.0
2021-08-04 14:00:00	NQ	Futures	17467.49	17506.02	17461.99	17469.52	35543.0
2021-08-04 15:00:00	NQ	Futures	17469.81	17489.51	17453.01	17460.83	44237.0
2021-08-04 16:00:00	NQ	Futures	17460.54	17475.31	17458.22	17475.31	7821.0
2021-08-04 18:00:00	NQ	Futures	17475.6	17483.42	17465.75	17482.55	2169.0
2021-08-04 19:00:00	NQ	Futures	17482.26	17483.42	17472.99	17477.92	1552.0
2021-08-04 20:00:00	NQ	Futures	17477.63	17500.22	17476.76	17492.11	3851.0
2021-08-04 21:00:00	NQ	Futures	17491.53	17496.75	17481.97	17489.51	3337.0
2021-08-04 22:00:00	NQ	Futures	17489.8	17497.62	17481.68	17486.03	2803.0
2021-08-04 23:00:00	NQ	Futures	17486.9	17490.09	17480.53	17484.29	1124.0
2021-08-04 00:00:00	YM	Futures	39064.7	39077.0	39055.8	39075.9	527.0
2021-08-04 01:00:00	YM	Futures	39075.9	39080.4	39054.7	39074.8	882.0
2021-08-04 02:00:00	YM	Futures	39073.7	39103.8	39059.1	39084.8	1627.0
2021-08-04 03:00:00	YM	Futures	39085.9	39099.4	39031.2	39034.6	2625.0

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

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