PREVIEW / futures_1hour / 2023-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-06.parquet
  size:    69 KB
  rows:    2,090

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-02-06 00:00:00	ES	Futures	4622.46	4623.29	4616.58	4622.74	8774.0
2023-02-06 01:00:00	ES	Futures	4622.74	4624.41	4616.02	4616.86	10503.0
2023-02-06 02:00:00	ES	Futures	4616.86	4620.22	4614.63	4618.82	11975.0
2023-02-06 03:00:00	ES	Futures	4619.1	4621.9	4611.83	4613.79	22770.0
2023-02-06 04:00:00	ES	Futures	4614.07	4615.19	4600.37	4600.93	25764.0
2023-02-06 05:00:00	ES	Futures	4600.65	4602.04	4592.54	4599.53	23476.0
2023-02-06 06:00:00	ES	Futures	4599.53	4603.72	4593.66	4602.88	17750.0
2023-02-06 07:00:00	ES	Futures	4602.88	4612.95	4602.04	4610.99	23378.0
2023-02-06 08:00:00	ES	Futures	4611.27	4612.95	4599.53	4604.28	39399.0
2023-02-06 09:00:00	ES	Futures	4604.0	4621.62	4602.04	4614.91	205441.0
2023-02-06 10:00:00	ES	Futures	4614.91	4619.38	4590.02	4614.63	279616.0
2023-02-06 11:00:00	ES	Futures	4614.63	4626.37	4606.8	4608.48	188746.0
2023-02-06 12:00:00	ES	Futures	4608.2	4616.86	4603.72	4610.99	112788.0
2023-02-06 13:00:00	ES	Futures	4610.71	4615.47	4602.04	4611.27	102334.0
2023-02-06 14:00:00	ES	Futures	4610.99	4623.57	4608.2	4614.63	117287.0
2023-02-06 15:00:00	ES	Futures	4614.35	4615.47	4597.57	4610.99	217505.0
2023-02-06 16:00:00	ES	Futures	4610.71	4613.79	4609.59	4611.55	37204.0
2023-02-06 18:00:00	ES	Futures	4611.83	4618.82	4611.55	4618.82	5783.0
2023-02-06 19:00:00	ES	Futures	4618.82	4622.74	4617.42	4622.46	6750.0
2023-02-06 20:00:00	ES	Futures	4622.74	4626.09	4621.34	4625.25	7337.0
2023-02-06 21:00:00	ES	Futures	4625.25	4625.53	4621.34	4624.13	4957.0
2023-02-06 22:00:00	ES	Futures	4624.41	4624.69	4619.66	4620.5	5950.0
2023-02-06 23:00:00	ES	Futures	4620.5	4621.9	4615.19	4615.47	5388.0
2023-02-06 00:00:00	NQ	Futures	14300.95	14309.77	14272.5	14306.92	6385.0
2023-02-06 01:00:00	NQ	Futures	14306.92	14315.74	14277.05	14279.89	6163.0
2023-02-06 02:00:00	NQ	Futures	14279.61	14300.66	14272.5	14284.16	8392.0
2023-02-06 03:00:00	NQ	Futures	14285.02	14311.47	14259.41	14264.82	13564.0
2023-02-06 04:00:00	NQ	Futures	14265.1	14270.22	14210.19	14210.76	12980.0
2023-02-06 05:00:00	NQ	Futures	14211.33	14221.57	14186.3	14215.88	12753.0
2023-02-06 06:00:00	NQ	Futures	14215.88	14220.72	14176.05	14216.45	10971.0
2023-02-06 07:00:00	NQ	Futures	14216.17	14267.95	14215.6	14256.85	14743.0
2023-02-06 08:00:00	NQ	Futures	14256.85	14268.8	14203.65	14225.56	17438.0
2023-02-06 09:00:00	NQ	Futures	14225.56	14303.22	14211.62	14280.75	74479.0
2023-02-06 10:00:00	NQ	Futures	14281.6	14329.68	14174.35	14289.57	89172.0
2023-02-06 11:00:00	NQ	Futures	14290.14	14348.17	14259.13	14268.52	59574.0
2023-02-06 12:00:00	NQ	Futures	14268.23	14301.8	14245.19	14275.06	35253.0
2023-02-06 13:00:00	NQ	Futures	14274.77	14278.47	14227.26	14258.27	32430.0
2023-02-06 14:00:00	NQ	Futures	14257.42	14308.34	14237.79	14259.98	36891.0
2023-02-06 15:00:00	NQ	Futures	14259.41	14265.1	14188.0	14239.78	56183.0
2023-02-06 16:00:00	NQ	Futures	14240.07	14247.18	14229.26	14239.5	9874.0
2023-02-06 18:00:00	NQ	Futures	14239.5	14267.38	14236.08	14265.67	3678.0
2023-02-06 19:00:00	NQ	Futures	14265.1	14287.29	14261.4	14284.45	3732.0
2023-02-06 20:00:00	NQ	Futures	14284.45	14300.38	14281.89	14296.4	3987.0
2023-02-06 21:00:00	NQ	Futures	14296.68	14298.1	14280.18	14290.42	2296.0
2023-02-06 22:00:00	NQ	Futures	14290.42	14291.27	14270.22	14274.77	2984.0
2023-02-06 23:00:00	NQ	Futures	14275.06	14283.02	14257.7	14259.98	3074.0
2023-02-06 00:00:00	YM	Futures	37751.8	37754.1	37718.4	37745.1	970.0
2023-02-06 01:00:00	YM	Futures	37746.3	37757.4	37706.1	37711.7	1583.0
2023-02-06 02:00:00	YM	Futures	37712.8	37734.0	37696.1	37727.3	1580.0
2023-02-06 03:00:00	YM	Futures	37728.4	37735.1	37660.5	37683.9	3176.0

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

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