PREVIEW / futures_1hour / 2023-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-17.parquet
  size:    65 KB
  rows:    2,036

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-04-17 00:00:00	ES	Futures	4626.81	4628.2	4625.42	4626.53	2384.0
2023-04-17 01:00:00	ES	Futures	4626.81	4629.86	4625.42	4629.58	5627.0
2023-04-17 02:00:00	ES	Futures	4629.58	4630.69	4624.31	4628.2	9492.0
2023-04-17 03:00:00	ES	Futures	4628.47	4632.91	4626.53	4627.92	18030.0
2023-04-17 04:00:00	ES	Futures	4628.2	4629.31	4623.48	4624.31	12014.0
2023-04-17 05:00:00	ES	Futures	4624.31	4626.25	4619.6	4620.98	12921.0
2023-04-17 06:00:00	ES	Futures	4621.26	4624.59	4620.15	4623.76	9766.0
2023-04-17 07:00:00	ES	Futures	4623.76	4625.98	4619.88	4624.31	15057.0
2023-04-17 08:00:00	ES	Futures	4624.31	4626.53	4617.1	4619.04	29644.0
2023-04-17 09:00:00	ES	Futures	4619.04	4625.7	4614.33	4619.88	178105.0
2023-04-17 10:00:00	ES	Futures	4619.88	4625.42	4611.28	4616.27	176476.0
2023-04-17 11:00:00	ES	Futures	4616.27	4620.15	4603.23	4608.5	166092.0
2023-04-17 12:00:00	ES	Futures	4608.5	4612.11	4604.07	4609.34	91381.0
2023-04-17 13:00:00	ES	Futures	4609.61	4613.5	4603.51	4604.62	86765.0
2023-04-17 14:00:00	ES	Futures	4604.62	4621.26	4601.85	4620.15	120197.0
2023-04-17 15:00:00	ES	Futures	4620.15	4634.85	4620.15	4634.3	219161.0
2023-04-17 16:00:00	ES	Futures	4634.3	4637.9	4633.74	4633.74	71015.0
2023-04-17 18:00:00	ES	Futures	4634.02	4634.02	4631.8	4633.47	3842.0
2023-04-17 19:00:00	ES	Futures	4633.47	4634.58	4632.08	4633.47	3401.0
2023-04-17 20:00:00	ES	Futures	4633.47	4633.74	4630.41	4631.25	5447.0
2023-04-17 21:00:00	ES	Futures	4630.97	4635.68	4630.69	4633.74	8369.0
2023-04-17 22:00:00	ES	Futures	4633.74	4635.41	4632.36	4633.19	4995.0
2023-04-17 23:00:00	ES	Futures	4633.47	4634.58	4630.69	4631.52	3812.0
2023-04-17 00:00:00	NQ	Futures	14845.16	14850.23	14840.66	14844.04	1438.0
2023-04-17 01:00:00	NQ	Futures	14844.32	14862.06	14838.13	14858.68	3172.0
2023-04-17 02:00:00	NQ	Futures	14858.68	14871.07	14846.57	14870.22	4422.0
2023-04-17 03:00:00	NQ	Futures	14870.22	14886.27	14857.27	14874.16	8066.0
2023-04-17 04:00:00	NQ	Futures	14874.73	14879.23	14847.14	14851.64	5327.0
2023-04-17 05:00:00	NQ	Futures	14852.2	14856.71	14816.73	14825.17	7279.0
2023-04-17 06:00:00	NQ	Futures	14825.46	14857.55	14819.82	14851.36	6482.0
2023-04-17 07:00:00	NQ	Futures	14851.08	14868.25	14829.4	14841.79	9842.0
2023-04-17 08:00:00	NQ	Futures	14842.07	14859.24	14818.98	14838.69	15129.0
2023-04-17 09:00:00	NQ	Futures	14838.13	14872.76	14799.83	14823.2	73612.0
2023-04-17 10:00:00	NQ	Futures	14823.48	14858.12	14766.33	14797.3	105109.0
2023-04-17 11:00:00	NQ	Futures	14797.3	14813.07	14739.86	14756.48	72999.0
2023-04-17 12:00:00	NQ	Futures	14757.04	14767.46	14727.19	14764.64	46604.0
2023-04-17 13:00:00	NQ	Futures	14764.64	14785.76	14745.78	14749.44	36719.0
2023-04-17 14:00:00	NQ	Futures	14749.72	14806.03	14742.4	14802.09	40910.0
2023-04-17 15:00:00	NQ	Futures	14802.09	14856.99	14802.09	14854.17	68763.0
2023-04-17 16:00:00	NQ	Futures	14854.17	14861.49	14843.19	14844.6	13224.0
2023-04-17 18:00:00	NQ	Futures	14847.98	14848.54	14838.69	14845.73	1698.0
2023-04-17 19:00:00	NQ	Futures	14845.45	14849.67	14837.28	14842.07	1599.0
2023-04-17 20:00:00	NQ	Futures	14841.5	14844.6	14828.83	14831.09	3166.0
2023-04-17 21:00:00	NQ	Futures	14831.09	14847.42	14827.99	14837.56	3773.0
2023-04-17 22:00:00	NQ	Futures	14837.84	14844.32	14832.78	14835.59	2805.0
2023-04-17 23:00:00	NQ	Futures	14835.31	14840.38	14827.71	14831.37	1912.0
2023-04-17 00:00:00	YM	Futures	37683.3	37693.2	37675.5	37681.1	488.0
2023-04-17 01:00:00	YM	Futures	37682.2	37697.6	37678.9	37694.3	1083.0
2023-04-17 02:00:00	YM	Futures	37696.5	37696.5	37650.1	37666.7	2004.0
2023-04-17 03:00:00	YM	Futures	37667.8	37696.5	37657.9	37660.1	3713.0

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

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