PREVIEW / futures_1hour / 2023-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-18.parquet
  size:    66 KB
  rows:    2,064

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-18 00:00:00	ES	Futures	5136.8	5137.6	5136.26	5137.06	3255.0
2023-12-18 01:00:00	ES	Futures	5137.06	5138.41	5135.45	5135.45	4182.0
2023-12-18 02:00:00	ES	Futures	5135.45	5137.6	5133.3	5133.57	6531.0
2023-12-18 03:00:00	ES	Futures	5133.57	5133.84	5125.78	5133.3	19062.0
2023-12-18 04:00:00	ES	Futures	5133.3	5136.8	5131.15	5134.65	10802.0
2023-12-18 05:00:00	ES	Futures	5134.65	5137.6	5132.23	5132.5	7477.0
2023-12-18 06:00:00	ES	Futures	5132.5	5135.72	5128.74	5130.08	10033.0
2023-12-18 07:00:00	ES	Futures	5130.08	5135.72	5130.08	5135.45	11313.0
2023-12-18 08:00:00	ES	Futures	5135.45	5140.29	5132.77	5138.14	26698.0
2023-12-18 09:00:00	ES	Futures	5138.14	5142.7	5134.11	5141.9	162933.0
2023-12-18 10:00:00	ES	Futures	5141.9	5147.81	5138.68	5140.82	178877.0
2023-12-18 11:00:00	ES	Futures	5140.82	5150.76	5138.94	5148.61	115237.0
2023-12-18 12:00:00	ES	Futures	5148.88	5156.13	5148.61	5153.45	80313.0
2023-12-18 13:00:00	ES	Futures	5153.18	5155.87	5149.96	5154.25	67729.0
2023-12-18 14:00:00	ES	Futures	5154.25	5159.36	5151.03	5155.06	94682.0
2023-12-18 15:00:00	ES	Futures	5154.79	5157.75	5148.61	5149.15	174609.0
2023-12-18 16:00:00	ES	Futures	5149.15	5149.69	5144.32	5146.46	63116.0
2023-12-18 18:00:00	ES	Futures	5146.73	5147.54	5144.85	5147.27	4533.0
2023-12-18 19:00:00	ES	Futures	5147.0	5148.08	5145.39	5147.0	3875.0
2023-12-18 20:00:00	ES	Futures	5147.0	5147.27	5143.78	5147.27	4944.0
2023-12-18 21:00:00	ES	Futures	5147.27	5151.03	5147.0	5149.15	7004.0
2023-12-18 22:00:00	ES	Futures	5149.15	5151.84	5148.61	5150.49	5544.0
2023-12-18 23:00:00	ES	Futures	5150.22	5151.03	5148.88	5150.22	2910.0
2023-12-18 00:00:00	NQ	Futures	18281.7	18288.75	18280.07	18282.78	2031.0
2023-12-18 01:00:00	NQ	Futures	18283.06	18288.48	18270.58	18272.48	2827.0
2023-12-18 02:00:00	NQ	Futures	18273.02	18285.22	18263.8	18268.14	4388.0
2023-12-18 03:00:00	NQ	Futures	18268.14	18274.11	18233.7	18270.85	10075.0
2023-12-18 04:00:00	NQ	Futures	18271.39	18283.87	18261.63	18270.58	6932.0
2023-12-18 05:00:00	NQ	Futures	18270.85	18284.41	18262.99	18264.07	4965.0
2023-12-18 06:00:00	NQ	Futures	18264.61	18270.58	18243.46	18249.97	5866.0
2023-12-18 07:00:00	NQ	Futures	18249.7	18271.12	18244.82	18269.22	7399.0
2023-12-18 08:00:00	NQ	Futures	18269.5	18283.87	18257.56	18283.06	13107.0
2023-12-18 09:00:00	NQ	Futures	18283.33	18315.06	18260.27	18310.18	76681.0
2023-12-18 10:00:00	NQ	Futures	18310.45	18339.47	18296.62	18299.87	69206.0
2023-12-18 11:00:00	NQ	Futures	18299.87	18349.5	18285.5	18338.92	52017.0
2023-12-18 12:00:00	NQ	Futures	18338.92	18374.45	18338.65	18368.21	34433.0
2023-12-18 13:00:00	NQ	Futures	18368.21	18396.15	18356.01	18392.62	28564.0
2023-12-18 14:00:00	NQ	Futures	18392.62	18413.78	18385.03	18399.67	35389.0
2023-12-18 15:00:00	NQ	Futures	18399.67	18411.61	18373.91	18374.99	55244.0
2023-12-18 16:00:00	NQ	Futures	18374.45	18375.27	18347.33	18357.09	16144.0
2023-12-18 18:00:00	NQ	Futures	18351.94	18364.15	18350.86	18360.35	2803.0
2023-12-18 19:00:00	NQ	Futures	18359.81	18361.98	18351.94	18357.91	2635.0
2023-12-18 20:00:00	NQ	Futures	18357.37	18359.54	18345.16	18357.37	3246.0
2023-12-18 21:00:00	NQ	Futures	18357.37	18371.47	18355.47	18360.62	4819.0
2023-12-18 22:00:00	NQ	Futures	18361.16	18374.99	18360.08	18365.77	3941.0
2023-12-18 23:00:00	NQ	Futures	18365.77	18370.38	18355.74	18364.42	2443.0
2023-12-18 00:00:00	YM	Futures	40534.6	40541.1	40531.4	40536.8	462.0
2023-12-18 01:00:00	YM	Futures	40536.8	40546.4	40530.3	40532.5	505.0
2023-12-18 02:00:00	YM	Futures	40531.4	40543.2	40506.7	40509.9	1246.0
2023-12-18 03:00:00	YM	Futures	40508.8	40511.0	40470.2	40497.0	3026.0

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

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