PREVIEW / futures_1hour / 2023-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-27.parquet
  size:    70 KB
  rows:    2,072

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-27 00:00:00	ES	Futures	5058.7	5063.36	5058.15	5061.17	8446.0
2023-07-27 01:00:00	ES	Futures	5061.44	5061.99	5056.77	5060.07	6242.0
2023-07-27 02:00:00	ES	Futures	5060.07	5063.09	5059.25	5061.44	9446.0
2023-07-27 03:00:00	ES	Futures	5061.44	5071.05	5060.07	5069.13	27892.0
2023-07-27 04:00:00	ES	Futures	5069.13	5075.17	5068.85	5074.34	23569.0
2023-07-27 05:00:00	ES	Futures	5074.34	5075.99	5072.42	5073.52	14194.0
2023-07-27 06:00:00	ES	Futures	5073.79	5076.81	5072.97	5073.79	12784.0
2023-07-27 07:00:00	ES	Futures	5073.79	5080.11	5072.15	5078.74	20223.0
2023-07-27 08:00:00	ES	Futures	5079.01	5088.89	5077.91	5083.4	65100.0
2023-07-27 09:00:00	ES	Futures	5083.68	5087.79	5079.01	5082.58	189581.0
2023-07-27 10:00:00	ES	Futures	5082.3	5083.4	5063.64	5065.83	245802.0
2023-07-27 11:00:00	ES	Futures	5066.11	5071.87	5061.17	5065.28	149731.0
2023-07-27 12:00:00	ES	Futures	5065.56	5078.46	5064.74	5075.99	100731.0
2023-07-27 13:00:00	ES	Futures	5075.99	5078.46	5046.34	5049.91	261850.0
2023-07-27 14:00:00	ES	Futures	5050.19	5051.83	5013.4	5013.4	274403.0
2023-07-27 15:00:00	ES	Futures	5013.4	5026.03	5000.23	5010.93	324377.0
2023-07-27 16:00:00	ES	Futures	5010.93	5017.52	5009.56	5015.05	58156.0
2023-07-27 18:00:00	ES	Futures	5013.68	5018.07	5012.58	5015.6	5539.0
2023-07-27 19:00:00	ES	Futures	5015.6	5016.7	5012.03	5013.68	5597.0
2023-07-27 20:00:00	ES	Futures	5013.95	5019.44	5012.85	5018.07	9682.0
2023-07-27 21:00:00	ES	Futures	5018.34	5020.26	5016.42	5019.17	8329.0
2023-07-27 22:00:00	ES	Futures	5018.89	5019.99	5016.97	5019.72	4621.0
2023-07-27 23:00:00	ES	Futures	5019.72	5032.34	5009.28	5018.07	41578.0
2023-07-27 00:00:00	NQ	Futures	17467.19	17494.73	17463.3	17478.87	5818.0
2023-07-27 01:00:00	NQ	Futures	17478.87	17485.27	17464.69	17481.1	4058.0
2023-07-27 02:00:00	NQ	Futures	17481.38	17505.57	17477.76	17483.32	6555.0
2023-07-27 03:00:00	NQ	Futures	17482.77	17551.74	17479.99	17536.17	11815.0
2023-07-27 04:00:00	NQ	Futures	17535.89	17583.73	17535.33	17580.39	11501.0
2023-07-27 05:00:00	NQ	Futures	17580.39	17588.46	17560.37	17577.33	8133.0
2023-07-27 06:00:00	NQ	Futures	17577.33	17585.95	17567.32	17576.5	5710.0
2023-07-27 07:00:00	NQ	Futures	17576.22	17597.91	17567.32	17594.85	10026.0
2023-07-27 08:00:00	NQ	Futures	17595.13	17627.4	17586.79	17600.14	26052.0
2023-07-27 09:00:00	NQ	Futures	17600.69	17693.59	17595.41	17656.88	102599.0
2023-07-27 10:00:00	NQ	Futures	17656.32	17671.9	17535.61	17547.85	137826.0
2023-07-27 11:00:00	NQ	Futures	17547.85	17624.61	17545.62	17567.6	77604.0
2023-07-27 12:00:00	NQ	Futures	17567.88	17641.02	17565.09	17615.16	56328.0
2023-07-27 13:00:00	NQ	Futures	17615.71	17630.18	17470.81	17492.78	102356.0
2023-07-27 14:00:00	NQ	Futures	17493.61	17506.41	17298.09	17298.92	115028.0
2023-07-27 15:00:00	NQ	Futures	17299.2	17374.57	17256.65	17317.56	107741.0
2023-07-27 16:00:00	NQ	Futures	17317.56	17352.05	17311.44	17337.86	16207.0
2023-07-27 18:00:00	NQ	Futures	17333.13	17347.6	17320.06	17344.81	3983.0
2023-07-27 19:00:00	NQ	Futures	17345.09	17350.93	17331.74	17340.92	2959.0
2023-07-27 20:00:00	NQ	Futures	17340.92	17373.46	17337.58	17368.46	5313.0
2023-07-27 21:00:00	NQ	Futures	17368.73	17380.14	17353.71	17370.4	4774.0
2023-07-27 22:00:00	NQ	Futures	17370.12	17377.36	17361.22	17374.57	3699.0
2023-07-27 23:00:00	NQ	Futures	17375.13	17434.93	17333.13	17369.01	16980.0
2023-07-27 00:00:00	YM	Futures	39101.1	39126.3	39097.8	39116.4	1045.0
2023-07-27 01:00:00	YM	Futures	39117.5	39119.7	39074.8	39090.1	2096.0
2023-07-27 02:00:00	YM	Futures	39091.2	39118.6	39083.6	39112.1	2912.0
2023-07-27 03:00:00	YM	Futures	39111.0	39163.6	39085.8	39153.7	3499.0

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

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