PREVIEW / futures_1hour / 2023-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-04.parquet
  size:    51 KB
  rows:    1,605

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-07-04 00:00:00	ES	Futures	4931.6	4933.79	4931.05	4932.15	2657.0
2023-07-04 01:00:00	ES	Futures	4932.42	4933.52	4931.05	4931.32	2961.0
2023-07-04 02:00:00	ES	Futures	4931.32	4932.7	4929.68	4932.7	4440.0
2023-07-04 03:00:00	ES	Futures	4932.7	4934.34	4931.05	4933.24	7461.0
2023-07-04 04:00:00	ES	Futures	4933.52	4933.52	4927.21	4928.58	6168.0
2023-07-04 05:00:00	ES	Futures	4928.58	4930.77	4927.48	4930.22	5489.0
2023-07-04 06:00:00	ES	Futures	4930.22	4930.5	4926.11	4928.85	4854.0
2023-07-04 07:00:00	ES	Futures	4928.85	4931.87	4928.3	4930.22	3627.0
2023-07-04 08:00:00	ES	Futures	4930.22	4932.15	4929.68	4930.5	4491.0
2023-07-04 09:00:00	ES	Futures	4930.5	4932.15	4927.75	4931.05	7492.0
2023-07-04 10:00:00	ES	Futures	4931.05	4931.6	4928.3	4930.22	6989.0
2023-07-04 11:00:00	ES	Futures	4929.95	4931.6	4929.68	4930.5	4316.0
2023-07-04 12:00:00	ES	Futures	4930.5	4931.32	4929.4	4930.77	4146.0
2023-07-04 18:00:00	ES	Futures	4930.22	4931.05	4928.3	4929.4	2978.0
2023-07-04 19:00:00	ES	Futures	4929.13	4929.95	4928.03	4929.4	1861.0
2023-07-04 20:00:00	ES	Futures	4929.4	4931.32	4927.75	4931.32	5985.0
2023-07-04 21:00:00	ES	Futures	4931.32	4933.24	4930.22	4932.42	5949.0
2023-07-04 22:00:00	ES	Futures	4932.15	4932.42	4929.4	4929.68	4159.0
2023-07-04 23:00:00	ES	Futures	4929.68	4929.95	4928.03	4929.13	3499.0
2023-07-04 00:00:00	NQ	Futures	17076.7	17084.21	17074.19	17076.7	1481.0
2023-07-04 01:00:00	NQ	Futures	17077.25	17081.7	17072.8	17074.75	1428.0
2023-07-04 02:00:00	NQ	Futures	17074.47	17076.14	17063.62	17075.03	2412.0
2023-07-04 03:00:00	NQ	Futures	17075.31	17089.49	17073.64	17086.71	2972.0
2023-07-04 04:00:00	NQ	Futures	17086.43	17087.26	17068.63	17071.97	2307.0
2023-07-04 05:00:00	NQ	Futures	17072.8	17080.87	17070.58	17078.64	1617.0
2023-07-04 06:00:00	NQ	Futures	17079.48	17080.03	17066.96	17073.64	1717.0
2023-07-04 07:00:00	NQ	Futures	17073.91	17084.21	17069.19	17077.81	1854.0
2023-07-04 08:00:00	NQ	Futures	17077.53	17087.26	17073.91	17086.15	2381.0
2023-07-04 09:00:00	NQ	Futures	17086.15	17097.83	17080.03	17093.66	4897.0
2023-07-04 10:00:00	NQ	Futures	17093.94	17095.61	17071.97	17075.03	5258.0
2023-07-04 11:00:00	NQ	Futures	17074.75	17084.48	17071.97	17076.7	3455.0
2023-07-04 12:00:00	NQ	Futures	17076.7	17078.09	17066.68	17071.13	3239.0
2023-07-04 18:00:00	NQ	Futures	17071.97	17078.36	17067.52	17071.41	1893.0
2023-07-04 19:00:00	NQ	Futures	17071.41	17071.41	17061.95	17066.96	1180.0
2023-07-04 20:00:00	NQ	Futures	17067.52	17072.8	17056.11	17067.8	2902.0
2023-07-04 21:00:00	NQ	Futures	17067.52	17084.48	17065.85	17082.26	3742.0
2023-07-04 22:00:00	NQ	Futures	17082.54	17082.81	17072.8	17073.91	2217.0
2023-07-04 23:00:00	NQ	Futures	17073.64	17074.75	17065.85	17070.86	1672.0
2023-07-04 00:00:00	YM	Futures	37950.8	37959.5	37946.4	37950.8	557.0
2023-07-04 01:00:00	YM	Futures	37951.9	37962.8	37934.3	37937.6	1198.0
2023-07-04 02:00:00	YM	Futures	37937.6	37954.1	37926.7	37948.6	2004.0
2023-07-04 03:00:00	YM	Futures	37949.7	37962.8	37927.8	37949.7	2172.0
2023-07-04 04:00:00	YM	Futures	37949.7	37953.0	37910.2	37913.5	3845.0
2023-07-04 05:00:00	YM	Futures	37915.7	37930.0	37898.2	37925.6	1766.0
2023-07-04 06:00:00	YM	Futures	37925.6	37928.9	37891.6	37923.4	3105.0
2023-07-04 07:00:00	YM	Futures	37923.4	37945.3	37912.4	37928.9	2420.0
2023-07-04 08:00:00	YM	Futures	37930.0	37946.4	37907.0	37913.5	3161.0
2023-07-04 09:00:00	YM	Futures	37912.4	37919.0	37887.2	37898.2	2438.0
2023-07-04 10:00:00	YM	Futures	37899.3	37913.5	37891.6	37910.2	1715.0
2023-07-04 11:00:00	YM	Futures	37910.2	37923.4	37904.8	37908.1	993.0

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

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