PREVIEW / futures_1hour / 2023-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-14.parquet
  size:    69 KB
  rows:    2,099

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-14 00:00:00	ES	Futures	5136.53	5136.8	5132.5	5134.11	6565.0
2023-12-14 01:00:00	ES	Futures	5134.11	5135.45	5132.77	5134.92	8769.0
2023-12-14 02:00:00	ES	Futures	5134.65	5134.65	5127.39	5127.66	18356.0
2023-12-14 03:00:00	ES	Futures	5127.66	5135.99	5127.13	5130.08	36635.0
2023-12-14 04:00:00	ES	Futures	5129.81	5130.08	5121.75	5124.71	30371.0
2023-12-14 05:00:00	ES	Futures	5124.98	5133.03	5122.83	5129.54	23544.0
2023-12-14 06:00:00	ES	Futures	5129.54	5132.5	5125.25	5126.86	24242.0
2023-12-14 07:00:00	ES	Futures	5126.86	5133.57	5126.86	5130.89	26172.0
2023-12-14 08:00:00	ES	Futures	5130.89	5144.05	5125.25	5144.05	74762.0
2023-12-14 09:00:00	ES	Futures	5144.05	5148.08	5131.69	5141.9	255579.0
2023-12-14 10:00:00	ES	Futures	5141.63	5142.44	5125.78	5135.72	280406.0
2023-12-14 11:00:00	ES	Futures	5135.72	5136.8	5123.63	5134.92	171116.0
2023-12-14 12:00:00	ES	Futures	5134.92	5144.05	5128.47	5129.01	136596.0
2023-12-14 13:00:00	ES	Futures	5129.27	5129.27	5099.19	5109.4	280682.0
2023-12-14 14:00:00	ES	Futures	5109.4	5124.71	5108.86	5123.9	156509.0
2023-12-14 15:00:00	ES	Futures	5123.9	5130.89	5119.07	5130.35	269479.0
2023-12-14 16:00:00	ES	Futures	5130.08	5131.15	5122.56	5123.1	65833.0
2023-12-14 18:00:00	ES	Futures	5122.29	5127.13	5120.14	5126.59	8265.0
2023-12-14 19:00:00	ES	Futures	5126.59	5130.08	5126.59	5127.39	7965.0
2023-12-14 20:00:00	ES	Futures	5127.66	5128.74	5123.1	5127.66	11840.0
2023-12-14 21:00:00	ES	Futures	5127.66	5130.62	5127.13	5129.81	6202.0
2023-12-14 22:00:00	ES	Futures	5129.81	5133.84	5129.01	5133.84	6662.0
2023-12-14 23:00:00	ES	Futures	5133.84	5134.65	5132.77	5134.65	5609.0
2023-12-14 00:00:00	NQ	Futures	18307.19	18308.28	18297.43	18303.4	2837.0
2023-12-14 01:00:00	NQ	Futures	18302.85	18315.87	18298.79	18309.09	4005.0
2023-12-14 02:00:00	NQ	Futures	18308.82	18309.63	18280.07	18280.34	6597.0
2023-12-14 03:00:00	NQ	Futures	18280.89	18309.09	18272.21	18278.17	13217.0
2023-12-14 04:00:00	NQ	Futures	18278.44	18278.44	18246.99	18258.65	11385.0
2023-12-14 05:00:00	NQ	Futures	18258.92	18285.22	18250.78	18275.46	8096.0
2023-12-14 06:00:00	NQ	Futures	18276.0	18281.16	18251.87	18258.65	7954.0
2023-12-14 07:00:00	NQ	Futures	18258.65	18283.33	18258.1	18268.68	9267.0
2023-12-14 08:00:00	NQ	Futures	18268.41	18284.68	18232.61	18282.51	32234.0
2023-12-14 09:00:00	NQ	Futures	18282.51	18308.82	18237.49	18278.44	103737.0
2023-12-14 10:00:00	NQ	Futures	18278.44	18280.07	18188.95	18238.85	128814.0
2023-12-14 11:00:00	NQ	Futures	18238.85	18244.0	18162.1	18202.24	72079.0
2023-12-14 12:00:00	NQ	Futures	18202.78	18244.54	18153.42	18154.5	54543.0
2023-12-14 13:00:00	NQ	Futures	18154.78	18155.59	18038.43	18081.82	86258.0
2023-12-14 14:00:00	NQ	Futures	18081.82	18162.1	18080.19	18157.49	65779.0
2023-12-14 15:00:00	NQ	Futures	18157.22	18179.45	18147.72	18176.74	69395.0
2023-12-14 16:00:00	NQ	Futures	18176.74	18188.13	18159.93	18163.18	15399.0
2023-12-14 18:00:00	NQ	Futures	18159.11	18185.15	18151.52	18182.44	4425.0
2023-12-14 19:00:00	NQ	Futures	18182.71	18197.35	18176.2	18181.9	5099.0
2023-12-14 20:00:00	NQ	Futures	18181.9	18188.13	18167.79	18182.98	4683.0
2023-12-14 21:00:00	NQ	Futures	18182.71	18194.91	18181.08	18190.3	3037.0
2023-12-14 22:00:00	NQ	Futures	18190.57	18201.69	18187.59	18201.42	2626.0
2023-12-14 23:00:00	NQ	Futures	18201.69	18203.32	18197.08	18201.42	2291.0
2023-12-14 00:00:00	YM	Futures	40378.9	40378.9	40345.6	40353.1	934.0
2023-12-14 01:00:00	YM	Futures	40353.1	40371.4	40346.7	40368.1	1219.0
2023-12-14 02:00:00	YM	Futures	40368.1	40368.1	40331.6	40331.6	2432.0
2023-12-14 03:00:00	YM	Futures	40332.7	40427.2	40331.6	40375.7	5607.0

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

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