PREVIEW / futures_1hour / 2023-06-05

all futures 1-hour files

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

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-06-05 00:00:00	ES	Futures	4752.73	4753.28	4749.95	4752.17	4478.0
2023-06-05 01:00:00	ES	Futures	4752.45	4755.22	4750.79	4754.39	5739.0
2023-06-05 02:00:00	ES	Futures	4754.39	4756.89	4753.28	4756.33	6636.0
2023-06-05 03:00:00	ES	Futures	4756.33	4761.88	4753.01	4758.83	22847.0
2023-06-05 04:00:00	ES	Futures	4758.83	4760.77	4755.78	4757.17	13461.0
2023-06-05 05:00:00	ES	Futures	4757.17	4758.55	4755.5	4756.89	8194.0
2023-06-05 06:00:00	ES	Futures	4756.61	4760.49	4755.5	4760.22	10767.0
2023-06-05 07:00:00	ES	Futures	4760.22	4761.88	4757.72	4758.55	12029.0
2023-06-05 08:00:00	ES	Futures	4758.55	4761.05	4756.33	4758.0	20328.0
2023-06-05 09:00:00	ES	Futures	4758.27	4771.87	4757.72	4761.88	197399.0
2023-06-05 10:00:00	ES	Futures	4761.6	4775.19	4754.67	4765.21	325914.0
2023-06-05 11:00:00	ES	Futures	4765.21	4771.87	4762.99	4769.37	133762.0
2023-06-05 12:00:00	ES	Futures	4769.37	4776.3	4764.38	4776.03	102187.0
2023-06-05 13:00:00	ES	Futures	4776.3	4776.86	4759.38	4764.38	139086.0
2023-06-05 14:00:00	ES	Futures	4764.38	4764.93	4740.52	4754.95	235107.0
2023-06-05 15:00:00	ES	Futures	4754.95	4756.33	4740.52	4748.84	247628.0
2023-06-05 16:00:00	ES	Futures	4748.84	4752.17	4748.01	4748.57	59857.0
2023-06-05 18:00:00	ES	Futures	4748.01	4748.29	4743.02	4743.3	5684.0
2023-06-05 19:00:00	ES	Futures	4743.3	4746.9	4741.63	4743.58	4715.0
2023-06-05 20:00:00	ES	Futures	4743.85	4747.18	4741.91	4746.63	5833.0
2023-06-05 21:00:00	ES	Futures	4746.9	4750.23	4746.35	4749.95	7008.0
2023-06-05 22:00:00	ES	Futures	4749.95	4752.17	4748.84	4749.95	5784.0
2023-06-05 23:00:00	ES	Futures	4749.95	4751.34	4747.74	4749.95	3969.0
2023-06-05 00:00:00	NQ	Futures	16362.45	16364.14	16348.38	16356.82	2832.0
2023-06-05 01:00:00	NQ	Futures	16357.39	16371.18	16352.32	16369.49	3315.0
2023-06-05 02:00:00	NQ	Futures	16369.49	16374.56	16359.36	16371.18	2948.0
2023-06-05 03:00:00	NQ	Futures	16371.46	16414.54	16362.45	16390.05	8524.0
2023-06-05 04:00:00	NQ	Futures	16390.61	16396.8	16371.18	16376.81	5693.0
2023-06-05 05:00:00	NQ	Futures	16376.81	16385.54	16363.3	16369.21	4967.0
2023-06-05 06:00:00	NQ	Futures	16369.49	16390.05	16361.61	16386.39	6258.0
2023-06-05 07:00:00	NQ	Futures	16386.95	16401.31	16379.91	16392.02	7648.0
2023-06-05 08:00:00	NQ	Futures	16391.74	16407.22	16380.75	16397.65	8509.0
2023-06-05 09:00:00	NQ	Futures	16398.49	16501.54	16393.71	16439.32	95395.0
2023-06-05 10:00:00	NQ	Futures	16439.88	16523.5	16431.72	16515.9	119480.0
2023-06-05 11:00:00	NQ	Futures	16515.9	16542.65	16492.53	16520.97	55601.0
2023-06-05 12:00:00	NQ	Futures	16520.69	16547.15	16496.47	16545.46	42029.0
2023-06-05 13:00:00	NQ	Futures	16545.74	16549.4	16453.96	16479.3	52208.0
2023-06-05 14:00:00	NQ	Futures	16479.3	16486.34	16380.19	16452.27	78633.0
2023-06-05 15:00:00	NQ	Futures	16452.27	16457.9	16379.07	16428.62	75870.0
2023-06-05 16:00:00	NQ	Futures	16428.9	16435.94	16422.71	16422.71	10183.0
2023-06-05 18:00:00	NQ	Futures	16422.42	16424.68	16402.15	16403.28	2571.0
2023-06-05 19:00:00	NQ	Futures	16403.28	16417.07	16395.68	16404.4	2609.0
2023-06-05 20:00:00	NQ	Futures	16405.25	16414.26	16393.71	16413.98	3071.0
2023-06-05 21:00:00	NQ	Futures	16413.98	16431.72	16411.73	16431.15	4006.0
2023-06-05 22:00:00	NQ	Futures	16430.87	16439.04	16426.93	16432.84	3697.0
2023-06-05 23:00:00	NQ	Futures	16432.84	16436.5	16420.74	16430.31	2267.0
2023-06-05 00:00:00	YM	Futures	37397.0	37401.4	37371.6	37388.2	857.0
2023-06-05 01:00:00	YM	Futures	37389.3	37414.7	37379.3	37407.0	1105.0
2023-06-05 02:00:00	YM	Futures	37407.0	37428.0	37399.2	37421.3	1285.0
2023-06-05 03:00:00	YM	Futures	37423.5	37452.3	37398.1	37435.7	3660.0

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

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