PREVIEW / futures_1hour / 2023-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-09.parquet
  size:    65 KB
  rows:    2,045

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-05-09 00:00:00	ES	Futures	4605.73	4607.39	4605.18	4605.73	2206.0
2023-05-09 01:00:00	ES	Futures	4605.73	4607.12	4604.34	4604.9	3177.0
2023-05-09 02:00:00	ES	Futures	4604.9	4604.9	4600.46	4600.74	6936.0
2023-05-09 03:00:00	ES	Futures	4601.02	4601.85	4596.3	4597.13	13878.0
2023-05-09 04:00:00	ES	Futures	4597.41	4599.91	4587.98	4590.48	17208.0
2023-05-09 05:00:00	ES	Futures	4590.2	4592.69	4587.15	4591.31	11491.0
2023-05-09 06:00:00	ES	Futures	4591.59	4592.42	4587.98	4590.2	9003.0
2023-05-09 07:00:00	ES	Futures	4590.2	4591.31	4586.32	4589.37	16763.0
2023-05-09 08:00:00	ES	Futures	4589.37	4593.25	4587.98	4589.09	20335.0
2023-05-09 09:00:00	ES	Futures	4589.09	4594.08	4582.99	4593.8	143567.0
2023-05-09 10:00:00	ES	Futures	4593.53	4596.02	4584.93	4590.75	153188.0
2023-05-09 11:00:00	ES	Futures	4590.75	4594.91	4586.32	4586.87	104661.0
2023-05-09 12:00:00	ES	Futures	4586.87	4591.31	4584.65	4590.48	75137.0
2023-05-09 13:00:00	ES	Futures	4590.75	4597.13	4588.81	4596.3	73590.0
2023-05-09 14:00:00	ES	Futures	4596.3	4598.8	4587.7	4591.86	90447.0
2023-05-09 15:00:00	ES	Futures	4591.86	4595.75	4584.65	4586.87	163556.0
2023-05-09 16:00:00	ES	Futures	4586.87	4591.31	4585.48	4587.7	39985.0
2023-05-09 18:00:00	ES	Futures	4585.21	4590.2	4584.37	4589.37	5446.0
2023-05-09 19:00:00	ES	Futures	4589.09	4591.86	4588.26	4590.75	2671.0
2023-05-09 20:00:00	ES	Futures	4590.48	4594.08	4588.81	4592.14	5472.0
2023-05-09 21:00:00	ES	Futures	4592.14	4593.53	4590.48	4591.59	4366.0
2023-05-09 22:00:00	ES	Futures	4591.59	4592.42	4589.64	4590.75	3507.0
2023-05-09 23:00:00	ES	Futures	4591.03	4592.14	4589.92	4590.2	2242.0
2023-05-09 00:00:00	NQ	Futures	15024.8	15031.55	15023.11	15024.8	1330.0
2023-05-09 01:00:00	NQ	Futures	15024.8	15029.58	15018.04	15021.98	1946.0
2023-05-09 02:00:00	NQ	Futures	15021.7	15022.26	15001.43	15006.21	3504.0
2023-05-09 03:00:00	NQ	Futures	15006.49	15017.47	14996.08	14999.46	6545.0
2023-05-09 04:00:00	NQ	Futures	14999.74	15007.62	14962.57	14973.83	7630.0
2023-05-09 05:00:00	NQ	Futures	14973.55	14982.84	14960.6	14978.34	5211.0
2023-05-09 06:00:00	NQ	Futures	14978.34	14983.13	14967.36	14978.34	4549.0
2023-05-09 07:00:00	NQ	Futures	14978.06	14982.84	14950.47	14962.85	7665.0
2023-05-09 08:00:00	NQ	Futures	14963.14	14971.86	14948.78	14951.87	11339.0
2023-05-09 09:00:00	NQ	Futures	14952.15	14991.57	14943.71	14989.32	96520.0
2023-05-09 10:00:00	NQ	Futures	14989.88	14998.33	14950.47	14971.02	111640.0
2023-05-09 11:00:00	NQ	Futures	14970.74	14977.78	14933.57	14937.8	69938.0
2023-05-09 12:00:00	NQ	Futures	14937.8	14964.54	14929.35	14962.01	45352.0
2023-05-09 13:00:00	NQ	Futures	14962.57	14968.48	14944.83	14962.29	40473.0
2023-05-09 14:00:00	NQ	Futures	14962.29	14972.43	14935.54	14950.18	43198.0
2023-05-09 15:00:00	NQ	Futures	14950.18	14956.66	14922.87	14940.61	68385.0
2023-05-09 16:00:00	NQ	Futures	14940.61	14947.09	14933.29	14934.98	12199.0
2023-05-09 18:00:00	NQ	Futures	14932.16	14948.49	14925.69	14947.09	2528.0
2023-05-09 19:00:00	NQ	Futures	14946.8	14954.69	14942.86	14950.18	1641.0
2023-05-09 20:00:00	NQ	Futures	14950.18	14962.85	14945.96	14954.69	3276.0
2023-05-09 21:00:00	NQ	Futures	14955.25	14960.88	14944.27	14948.78	2511.0
2023-05-09 22:00:00	NQ	Futures	14949.34	14953.28	14942.02	14947.09	1842.0
2023-05-09 23:00:00	NQ	Futures	14946.8	14953.0	14945.4	14946.52	1360.0
2023-05-09 00:00:00	YM	Futures	37208.0	37219.0	37203.6	37209.1	390.0
2023-05-09 01:00:00	YM	Futures	37208.0	37219.0	37196.9	37201.4	652.0
2023-05-09 02:00:00	YM	Futures	37200.3	37202.5	37170.4	37172.6	1162.0
2023-05-09 03:00:00	YM	Futures	37173.7	37184.8	37128.4	37139.5	2978.0

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

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