PREVIEW / futures_1hour / 2023-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-01.parquet
  size:    57 KB
  rows:    1,663

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
2023-12-01 00:00:00	ES	Futures	4968.43	4969.79	4965.72	4968.7	6507.0
2023-12-01 01:00:00	ES	Futures	4968.43	4970.33	4966.53	4967.62	5764.0
2023-12-01 02:00:00	ES	Futures	4967.89	4970.06	4966.26	4967.62	8493.0
2023-12-01 03:00:00	ES	Futures	4967.35	4977.94	4967.07	4977.12	21353.0
2023-12-01 04:00:00	ES	Futures	4977.12	4979.84	4976.31	4976.58	15738.0
2023-12-01 05:00:00	ES	Futures	4976.31	4976.58	4971.42	4971.69	12595.0
2023-12-01 06:00:00	ES	Futures	4971.69	4974.13	4969.52	4971.15	14455.0
2023-12-01 07:00:00	ES	Futures	4970.88	4971.15	4958.66	4960.01	27949.0
2023-12-01 08:00:00	ES	Futures	4959.74	4964.36	4958.93	4960.01	39165.0
2023-12-01 09:00:00	ES	Futures	4959.74	4967.62	4955.94	4965.99	197272.0
2023-12-01 10:00:00	ES	Futures	4966.53	4977.39	4957.57	4968.7	300403.0
2023-12-01 11:00:00	ES	Futures	4968.7	4995.04	4958.38	4990.7	390953.0
2023-12-01 12:00:00	ES	Futures	4990.7	5005.09	4988.53	5002.65	176683.0
2023-12-01 13:00:00	ES	Futures	5002.38	5003.46	4989.07	4990.43	142472.0
2023-12-01 14:00:00	ES	Futures	4990.7	4999.12	4989.07	4998.85	104663.0
2023-12-01 15:00:00	ES	Futures	4998.57	5001.56	4991.24	4998.03	227802.0
2023-12-01 16:00:00	ES	Futures	4998.03	5002.11	4996.4	5001.02	86747.0
2023-12-01 00:00:00	NQ	Futures	17529.62	17537.58	17519.18	17530.17	3916.0
2023-12-01 01:00:00	NQ	Futures	17530.17	17538.68	17525.5	17529.07	2401.0
2023-12-01 02:00:00	NQ	Futures	17529.62	17534.56	17518.91	17521.1	3605.0
2023-12-01 03:00:00	NQ	Futures	17520.83	17562.58	17520.55	17558.18	9093.0
2023-12-01 04:00:00	NQ	Futures	17557.91	17579.33	17554.34	17560.66	9891.0
2023-12-01 05:00:00	NQ	Futures	17560.38	17564.23	17541.7	17541.7	6610.0
2023-12-01 06:00:00	NQ	Futures	17541.98	17552.14	17531.27	17537.03	6750.0
2023-12-01 07:00:00	NQ	Futures	17536.48	17537.86	17489.79	17495.83	13611.0
2023-12-01 08:00:00	NQ	Futures	17495.56	17521.38	17493.91	17502.15	17010.0
2023-12-01 09:00:00	NQ	Futures	17502.15	17516.16	17441.73	17483.75	84991.0
2023-12-01 10:00:00	NQ	Futures	17483.47	17538.41	17429.09	17485.95	104550.0
2023-12-01 11:00:00	NQ	Futures	17485.67	17598.01	17451.06	17571.09	130952.0
2023-12-01 12:00:00	NQ	Futures	17571.92	17633.44	17555.16	17620.53	59507.0
2023-12-01 13:00:00	NQ	Futures	17620.53	17625.48	17562.85	17572.47	44027.0
2023-12-01 14:00:00	NQ	Futures	17572.74	17613.67	17566.42	17612.57	32875.0
2023-12-01 15:00:00	NQ	Futures	17612.84	17619.71	17581.25	17605.97	53074.0
2023-12-01 16:00:00	NQ	Futures	17605.97	17618.88	17589.49	17611.74	15605.0
2023-12-01 00:00:00	YM	Futures	39087.3	39090.5	39068.8	39084.0	970.0
2023-12-01 01:00:00	YM	Futures	39084.0	39092.7	39072.1	39078.6	1024.0
2023-12-01 02:00:00	YM	Futures	39078.6	39112.2	39073.2	39103.6	2491.0
2023-12-01 03:00:00	YM	Futures	39101.4	39158.9	39099.2	39156.7	3602.0
2023-12-01 04:00:00	YM	Futures	39154.5	39162.1	39131.8	39136.1	3079.0
2023-12-01 05:00:00	YM	Futures	39135.0	39136.1	39104.6	39104.6	2149.0
2023-12-01 06:00:00	YM	Futures	39105.7	39129.6	39092.7	39122.0	2486.0
2023-12-01 07:00:00	YM	Futures	39120.9	39120.9	39037.4	39042.8	3561.0
2023-12-01 08:00:00	YM	Futures	39043.9	39064.5	39029.8	39034.1	4388.0
2023-12-01 09:00:00	YM	Futures	39034.1	39133.9	39012.4	39126.3	21634.0
2023-12-01 10:00:00	YM	Futures	39128.5	39205.5	39088.4	39133.9	25211.0
2023-12-01 11:00:00	YM	Futures	39135.0	39295.6	39049.3	39273.9	30664.0
2023-12-01 12:00:00	YM	Futures	39274.9	39419.2	39254.3	39398.6	13056.0
2023-12-01 13:00:00	YM	Futures	39398.6	39404.0	39314.0	39323.8	9429.0
2023-12-01 14:00:00	YM	Futures	39325.9	39387.8	39318.3	39386.7	5741.0
2023-12-01 15:00:00	YM	Futures	39386.7	39411.6	39323.8	39385.6	13611.0

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

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