PREVIEW / futures_1hour / 2023-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-18.parquet
  size:    64 KB
  rows:    2,031

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-18 00:00:00	ES	Futures	4631.25	4632.36	4628.47	4629.86	3513.0
2023-04-18 01:00:00	ES	Futures	4629.86	4634.85	4629.58	4634.58	4798.0
2023-04-18 02:00:00	ES	Futures	4634.58	4639.01	4633.19	4636.52	7812.0
2023-04-18 03:00:00	ES	Futures	4636.79	4638.46	4634.3	4636.52	12318.0
2023-04-18 04:00:00	ES	Futures	4636.52	4645.67	4635.96	4643.45	15662.0
2023-04-18 05:00:00	ES	Futures	4643.73	4652.05	4642.34	4649.27	16798.0
2023-04-18 06:00:00	ES	Futures	4649.55	4655.38	4647.61	4653.99	14854.0
2023-04-18 07:00:00	ES	Futures	4653.99	4654.54	4650.11	4651.49	21977.0
2023-04-18 08:00:00	ES	Futures	4651.49	4657.6	4651.22	4654.54	27711.0
2023-04-18 09:00:00	ES	Futures	4654.82	4655.1	4639.84	4641.79	177126.0
2023-04-18 10:00:00	ES	Futures	4642.06	4642.34	4621.82	4626.25	286685.0
2023-04-18 11:00:00	ES	Futures	4625.98	4632.08	4620.15	4625.42	147963.0
2023-04-18 12:00:00	ES	Futures	4625.15	4636.79	4624.04	4631.52	109483.0
2023-04-18 13:00:00	ES	Futures	4631.8	4639.29	4629.03	4633.47	101949.0
2023-04-18 14:00:00	ES	Futures	4633.74	4639.57	4624.87	4631.8	139635.0
2023-04-18 15:00:00	ES	Futures	4632.08	4640.68	4631.8	4636.79	175127.0
2023-04-18 16:00:00	ES	Futures	4636.52	4638.46	4631.25	4636.24	78124.0
2023-04-18 18:00:00	ES	Futures	4632.91	4635.68	4632.91	4635.41	3676.0
2023-04-18 19:00:00	ES	Futures	4635.41	4635.68	4632.36	4632.91	2741.0
2023-04-18 20:00:00	ES	Futures	4632.63	4634.58	4631.8	4633.74	4759.0
2023-04-18 21:00:00	ES	Futures	4633.74	4635.68	4629.86	4630.41	7566.0
2023-04-18 22:00:00	ES	Futures	4630.41	4632.63	4629.31	4631.52	4402.0
2023-04-18 23:00:00	ES	Futures	4631.52	4632.08	4630.69	4631.52	2377.0
2023-04-18 00:00:00	NQ	Futures	14830.81	14833.9	14821.23	14825.46	2037.0
2023-04-18 01:00:00	NQ	Futures	14825.46	14846.57	14824.61	14845.16	2888.0
2023-04-18 02:00:00	NQ	Futures	14844.32	14867.13	14840.66	14854.46	4303.0
2023-04-18 03:00:00	NQ	Futures	14854.74	14862.9	14844.6	14857.83	5704.0
2023-04-18 04:00:00	NQ	Futures	14857.55	14922.31	14857.55	14913.3	12933.0
2023-04-18 05:00:00	NQ	Futures	14913.3	14959.76	14905.98	14948.49	12247.0
2023-04-18 06:00:00	NQ	Futures	14948.78	14952.44	14934.98	14940.33	8306.0
2023-04-18 07:00:00	NQ	Futures	14940.61	14971.58	14929.63	14953.84	13411.0
2023-04-18 08:00:00	NQ	Futures	14953.56	14977.21	14947.65	14965.39	13712.0
2023-04-18 09:00:00	NQ	Futures	14965.67	14976.09	14913.3	14924.56	83438.0
2023-04-18 10:00:00	NQ	Futures	14924.84	14927.38	14817.29	14840.1	120696.0
2023-04-18 11:00:00	NQ	Futures	14839.81	14862.9	14811.38	14828.27	61880.0
2023-04-18 12:00:00	NQ	Futures	14828.55	14868.81	14822.64	14839.53	44852.0
2023-04-18 13:00:00	NQ	Futures	14840.1	14864.59	14825.74	14838.41	35709.0
2023-04-18 14:00:00	NQ	Futures	14838.69	14858.4	14796.17	14819.82	52764.0
2023-04-18 15:00:00	NQ	Futures	14820.11	14866.0	14817.29	14854.46	53713.0
2023-04-18 16:00:00	NQ	Futures	14854.17	14857.83	14805.18	14851.36	24190.0
2023-04-18 18:00:00	NQ	Futures	14832.78	14845.73	14832.78	14843.76	2684.0
2023-04-18 19:00:00	NQ	Futures	14844.32	14845.73	14835.59	14837.84	1400.0
2023-04-18 20:00:00	NQ	Futures	14837.0	14849.67	14835.31	14842.91	2573.0
2023-04-18 21:00:00	NQ	Futures	14842.35	14851.08	14828.27	14830.81	3113.0
2023-04-18 22:00:00	NQ	Futures	14830.52	14837.0	14823.2	14832.78	2122.0
2023-04-18 23:00:00	NQ	Futures	14833.06	14835.87	14826.86	14833.62	1742.0
2023-04-18 00:00:00	YM	Futures	37714.2	37727.5	37703.2	37712.0	679.0
2023-04-18 01:00:00	YM	Futures	37710.9	37743.0	37708.7	37741.9	708.0
2023-04-18 02:00:00	YM	Futures	37740.8	37767.3	37726.4	37752.9	1379.0
2023-04-18 03:00:00	YM	Futures	37754.0	37776.1	37744.1	37749.6	2253.0

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

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