PREVIEW / futures_1hour / 2023-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-31.parquet
  size:    68 KB
  rows:    2,056

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-05-31 00:00:00	ES	Futures	4665.64	4666.47	4664.25	4664.81	4261.0
2023-05-31 01:00:00	ES	Futures	4664.53	4664.53	4659.54	4662.31	12292.0
2023-05-31 02:00:00	ES	Futures	4662.31	4663.42	4653.44	4657.04	17957.0
2023-05-31 03:00:00	ES	Futures	4657.04	4667.58	4654.54	4664.53	30189.0
2023-05-31 04:00:00	ES	Futures	4664.53	4668.13	4660.09	4666.75	17574.0
2023-05-31 05:00:00	ES	Futures	4666.47	4671.19	4663.97	4664.25	13286.0
2023-05-31 06:00:00	ES	Futures	4664.25	4666.75	4659.81	4665.92	17113.0
2023-05-31 07:00:00	ES	Futures	4665.92	4667.58	4655.1	4656.76	21348.0
2023-05-31 08:00:00	ES	Futures	4656.76	4658.15	4651.49	4653.16	28235.0
2023-05-31 09:00:00	ES	Futures	4653.16	4664.53	4650.66	4652.33	237906.0
2023-05-31 10:00:00	ES	Futures	4652.33	4654.27	4631.8	4637.63	368556.0
2023-05-31 11:00:00	ES	Futures	4637.63	4640.4	4630.69	4636.79	193191.0
2023-05-31 12:00:00	ES	Futures	4636.52	4644.01	4633.19	4639.84	145456.0
2023-05-31 13:00:00	ES	Futures	4639.84	4655.93	4638.18	4653.99	190818.0
2023-05-31 14:00:00	ES	Futures	4653.71	4658.7	4645.67	4652.05	177052.0
2023-05-31 15:00:00	ES	Futures	4652.05	4663.42	4646.5	4649.83	408893.0
2023-05-31 16:00:00	ES	Futures	4649.83	4652.88	4645.39	4646.5	114364.0
2023-05-31 18:00:00	ES	Futures	4646.78	4651.77	4646.5	4651.49	7819.0
2023-05-31 19:00:00	ES	Futures	4651.49	4656.21	4649.83	4655.38	5961.0
2023-05-31 20:00:00	ES	Futures	4655.65	4656.76	4645.95	4648.44	12402.0
2023-05-31 21:00:00	ES	Futures	4648.17	4662.31	4640.12	4647.89	28932.0
2023-05-31 22:00:00	ES	Futures	4647.89	4650.66	4642.62	4649.27	11303.0
2023-05-31 23:00:00	ES	Futures	4649.27	4652.6	4648.44	4651.77	6576.0
2023-05-31 00:00:00	NQ	Futures	16195.49	16197.75	16185.36	16185.92	2424.0
2023-05-31 01:00:00	NQ	Futures	16185.64	16185.64	16154.67	16167.9	6824.0
2023-05-31 02:00:00	NQ	Futures	16168.46	16170.15	16141.15	16151.29	6441.0
2023-05-31 03:00:00	NQ	Futures	16151.85	16181.98	16141.15	16171.0	10125.0
2023-05-31 04:00:00	NQ	Futures	16170.72	16179.16	16152.98	16177.19	8094.0
2023-05-31 05:00:00	NQ	Futures	16176.91	16201.97	16174.09	16183.67	6146.0
2023-05-31 06:00:00	NQ	Futures	16184.51	16192.4	16162.55	16189.02	6827.0
2023-05-31 07:00:00	NQ	Futures	16189.3	16196.62	16138.9	16149.88	9306.0
2023-05-31 08:00:00	NQ	Futures	16150.16	16156.36	16122.57	16127.92	13341.0
2023-05-31 09:00:00	NQ	Futures	16128.2	16231.25	16121.73	16190.14	101068.0
2023-05-31 10:00:00	NQ	Futures	16190.42	16209.01	16075.83	16116.38	118286.0
2023-05-31 11:00:00	NQ	Futures	16116.66	16121.44	16051.62	16095.26	64676.0
2023-05-31 12:00:00	NQ	Futures	16095.54	16115.81	16049.93	16081.75	55498.0
2023-05-31 13:00:00	NQ	Futures	16082.31	16178.04	16072.74	16156.36	62742.0
2023-05-31 14:00:00	NQ	Futures	16156.64	16172.69	16113.28	16136.37	58747.0
2023-05-31 15:00:00	NQ	Futures	16136.65	16168.18	16096.39	16107.08	90238.0
2023-05-31 16:00:00	NQ	Futures	16107.08	16120.6	16084.84	16092.16	21761.0
2023-05-31 18:00:00	NQ	Futures	16093.01	16104.27	16087.66	16100.61	3021.0
2023-05-31 19:00:00	NQ	Futures	16100.05	16120.6	16097.51	16116.38	2487.0
2023-05-31 20:00:00	NQ	Futures	16116.66	16124.26	16076.96	16083.72	5017.0
2023-05-31 21:00:00	NQ	Futures	16084.28	16142.84	16046.55	16078.37	13821.0
2023-05-31 22:00:00	NQ	Futures	16079.21	16086.53	16055.28	16076.96	5453.0
2023-05-31 23:00:00	NQ	Futures	16076.96	16091.04	16071.05	16081.75	3430.0
2023-05-31 00:00:00	YM	Futures	36461.9	36470.8	36454.2	36460.8	477.0
2023-05-31 01:00:00	YM	Futures	36459.7	36459.7	36432.1	36450.9	1228.0
2023-05-31 02:00:00	YM	Futures	36453.1	36456.4	36377.9	36406.6	2802.0
2023-05-31 03:00:00	YM	Futures	36407.8	36495.1	36382.3	36479.6	3663.0

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

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