PREVIEW / futures_1hour / 2023-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-20.parquet
  size:    66 KB
  rows:    2,051

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-11-20 00:00:00	ES	Futures	4912.76	4914.12	4909.78	4909.78	4708.0
2023-11-20 01:00:00	ES	Futures	4909.78	4911.4	4909.78	4910.59	4728.0
2023-11-20 02:00:00	ES	Futures	4910.86	4913.85	4910.32	4913.03	7684.0
2023-11-20 03:00:00	ES	Futures	4913.03	4917.38	4912.76	4914.66	19223.0
2023-11-20 04:00:00	ES	Futures	4914.66	4924.17	4914.66	4923.9	17482.0
2023-11-20 05:00:00	ES	Futures	4923.62	4924.98	4918.47	4920.37	11195.0
2023-11-20 06:00:00	ES	Futures	4920.37	4923.08	4917.92	4921.18	10519.0
2023-11-20 07:00:00	ES	Futures	4921.18	4922.0	4913.58	4914.93	20264.0
2023-11-20 08:00:00	ES	Futures	4914.93	4921.72	4913.31	4920.09	23461.0
2023-11-20 09:00:00	ES	Futures	4920.37	4932.86	4914.66	4932.59	142581.0
2023-11-20 10:00:00	ES	Futures	4932.59	4937.47	4924.98	4937.47	162749.0
2023-11-20 11:00:00	ES	Futures	4937.75	4941.0	4936.66	4939.38	107932.0
2023-11-20 12:00:00	ES	Futures	4939.1	4942.91	4936.39	4938.02	71068.0
2023-11-20 13:00:00	ES	Futures	4938.02	4954.04	4937.75	4952.68	141883.0
2023-11-20 14:00:00	ES	Futures	4952.68	4960.56	4950.24	4958.66	93932.0
2023-11-20 15:00:00	ES	Futures	4958.66	4965.17	4952.14	4955.67	220097.0
2023-11-20 16:00:00	ES	Futures	4955.67	4956.75	4951.32	4954.58	47650.0
2023-11-20 18:00:00	ES	Futures	4955.13	4957.84	4953.77	4957.84	8126.0
2023-11-20 19:00:00	ES	Futures	4957.57	4960.01	4955.94	4958.38	7189.0
2023-11-20 20:00:00	ES	Futures	4958.38	4960.29	4956.75	4957.84	6959.0
2023-11-20 21:00:00	ES	Futures	4957.84	4959.2	4956.48	4958.93	4832.0
2023-11-20 22:00:00	ES	Futures	4958.93	4960.83	4958.11	4958.93	4617.0
2023-11-20 23:00:00	ES	Futures	4958.93	4959.2	4956.75	4957.3	2922.0
2023-11-20 00:00:00	NQ	Futures	17418.38	17420.3	17399.7	17401.62	3582.0
2023-11-20 01:00:00	NQ	Futures	17401.62	17410.96	17401.08	17409.59	3059.0
2023-11-20 02:00:00	NQ	Futures	17409.59	17426.62	17407.67	17425.52	5970.0
2023-11-20 03:00:00	NQ	Futures	17425.52	17457.38	17425.52	17450.79	13512.0
2023-11-20 04:00:00	NQ	Futures	17451.34	17500.23	17451.34	17499.95	11854.0
2023-11-20 05:00:00	NQ	Futures	17499.95	17503.8	17477.43	17485.95	7183.0
2023-11-20 06:00:00	NQ	Futures	17485.4	17500.5	17474.41	17490.34	7546.0
2023-11-20 07:00:00	NQ	Futures	17489.79	17495.29	17458.75	17463.15	9875.0
2023-11-20 08:00:00	NQ	Futures	17463.15	17490.34	17454.63	17482.65	13249.0
2023-11-20 09:00:00	NQ	Futures	17482.93	17575.21	17458.21	17574.39	93265.0
2023-11-20 10:00:00	NQ	Futures	17574.11	17580.98	17510.12	17578.23	91265.0
2023-11-20 11:00:00	NQ	Futures	17577.96	17601.85	17577.96	17593.07	55579.0
2023-11-20 12:00:00	NQ	Futures	17593.61	17613.67	17582.35	17590.32	32013.0
2023-11-20 13:00:00	NQ	Futures	17590.87	17662.28	17589.77	17656.24	63909.0
2023-11-20 14:00:00	NQ	Futures	17656.51	17686.45	17643.05	17682.33	41920.0
2023-11-20 15:00:00	NQ	Futures	17682.61	17706.78	17661.46	17675.74	60822.0
2023-11-20 16:00:00	NQ	Futures	17675.74	17677.39	17665.58	17676.84	12330.0
2023-11-20 18:00:00	NQ	Futures	17674.64	17690.57	17669.7	17689.47	4383.0
2023-11-20 19:00:00	NQ	Futures	17688.92	17697.71	17680.41	17691.4	4037.0
2023-11-20 20:00:00	NQ	Futures	17691.4	17703.48	17686.18	17694.42	5010.0
2023-11-20 21:00:00	NQ	Futures	17694.14	17703.48	17691.4	17699.91	2907.0
2023-11-20 22:00:00	NQ	Futures	17700.18	17713.09	17698.26	17702.93	5648.0
2023-11-20 23:00:00	NQ	Futures	17702.93	17705.68	17694.97	17698.54	2180.0
2023-11-20 00:00:00	YM	Futures	37967.8	37979.7	37952.6	37953.7	622.0
2023-11-20 01:00:00	YM	Futures	37952.6	37962.3	37945.0	37949.3	761.0
2023-11-20 02:00:00	YM	Futures	37950.4	37968.9	37940.7	37950.4	2141.0
2023-11-20 03:00:00	YM	Futures	37950.4	37990.6	37949.3	37958.0	2657.0

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

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