PREVIEW / futures_1hour / 2023-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-07.parquet
  size:    68 KB
  rows:    2,080

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-07 00:00:00	ES	Futures	4615.74	4619.66	4615.47	4618.26	4119.0
2023-02-07 01:00:00	ES	Futures	4618.26	4619.66	4615.74	4616.86	3735.0
2023-02-07 02:00:00	ES	Futures	4616.86	4619.66	4613.51	4614.91	7230.0
2023-02-07 03:00:00	ES	Futures	4614.63	4617.14	4600.09	4610.43	26625.0
2023-02-07 04:00:00	ES	Futures	4610.15	4622.74	4610.15	4620.22	18527.0
2023-02-07 05:00:00	ES	Futures	4619.94	4622.74	4612.67	4613.23	9085.0
2023-02-07 06:00:00	ES	Futures	4613.23	4617.42	4609.87	4613.23	14780.0
2023-02-07 07:00:00	ES	Futures	4613.23	4619.1	4612.39	4616.58	15108.0
2023-02-07 08:00:00	ES	Futures	4616.3	4616.86	4602.32	4605.12	45679.0
2023-02-07 09:00:00	ES	Futures	4604.84	4606.24	4593.94	4599.53	182202.0
2023-02-07 10:00:00	ES	Futures	4599.53	4604.28	4592.26	4596.73	172673.0
2023-02-07 11:00:00	ES	Futures	4596.73	4618.82	4596.45	4613.51	134526.0
2023-02-07 12:00:00	ES	Futures	4613.51	4669.43	4607.92	4659.92	286470.0
2023-02-07 13:00:00	ES	Futures	4660.2	4667.19	4583.59	4598.97	502060.0
2023-02-07 14:00:00	ES	Futures	4598.97	4652.65	4597.85	4651.26	283316.0
2023-02-07 15:00:00	ES	Futures	4651.26	4684.25	4641.19	4669.43	315105.0
2023-02-07 16:00:00	ES	Futures	4669.43	4669.71	4657.41	4659.64	65553.0
2023-02-07 18:00:00	ES	Futures	4660.76	4666.91	4659.92	4661.6	10164.0
2023-02-07 19:00:00	ES	Futures	4661.6	4664.96	4659.08	4664.68	7539.0
2023-02-07 20:00:00	ES	Futures	4664.96	4667.47	4661.04	4663.56	8002.0
2023-02-07 21:00:00	ES	Futures	4663.28	4666.35	4663.0	4666.35	3372.0
2023-02-07 22:00:00	ES	Futures	4666.35	4672.23	4665.79	4669.43	5702.0
2023-02-07 23:00:00	ES	Futures	4669.43	4670.83	4667.75	4669.71	3421.0
2023-02-07 00:00:00	NQ	Futures	14259.98	14277.05	14259.41	14267.66	2592.0
2023-02-07 01:00:00	NQ	Futures	14267.38	14274.77	14260.55	14265.67	1852.0
2023-02-07 02:00:00	NQ	Futures	14265.67	14283.02	14252.01	14256.85	7161.0
2023-02-07 03:00:00	NQ	Futures	14257.14	14260.55	14196.82	14242.91	14768.0
2023-02-07 04:00:00	NQ	Futures	14242.06	14308.34	14241.77	14293.84	10602.0
2023-02-07 05:00:00	NQ	Futures	14293.27	14302.94	14258.84	14260.55	5840.0
2023-02-07 06:00:00	NQ	Futures	14260.83	14276.77	14251.73	14272.5	7259.0
2023-02-07 07:00:00	NQ	Futures	14273.07	14299.81	14273.07	14293.84	7987.0
2023-02-07 08:00:00	NQ	Futures	14293.84	14295.54	14228.69	14246.61	19176.0
2023-02-07 09:00:00	NQ	Futures	14246.89	14286.44	14211.9	14222.14	73911.0
2023-02-07 10:00:00	NQ	Futures	14221.86	14267.66	14198.53	14241.77	64035.0
2023-02-07 11:00:00	NQ	Futures	14242.06	14332.53	14242.06	14306.07	48729.0
2023-02-07 12:00:00	NQ	Futures	14306.64	14541.63	14265.67	14500.09	99931.0
2023-02-07 13:00:00	NQ	Futures	14500.38	14525.7	14178.33	14240.63	154592.0
2023-02-07 14:00:00	NQ	Futures	14240.35	14465.95	14236.37	14449.45	86780.0
2023-02-07 15:00:00	NQ	Futures	14450.31	14587.15	14407.06	14534.52	86765.0
2023-02-07 16:00:00	NQ	Futures	14534.23	14535.66	14476.76	14497.82	17880.0
2023-02-07 18:00:00	NQ	Futures	14505.78	14538.78	14503.51	14508.91	5529.0
2023-02-07 19:00:00	NQ	Futures	14509.77	14525.98	14496.96	14524.28	4139.0
2023-02-07 20:00:00	NQ	Futures	14524.84	14538.78	14510.9	14521.15	3678.0
2023-02-07 21:00:00	NQ	Futures	14521.71	14530.53	14517.16	14528.54	2296.0
2023-02-07 22:00:00	NQ	Futures	14528.83	14562.97	14525.41	14547.6	4199.0
2023-02-07 23:00:00	NQ	Futures	14547.89	14557.56	14543.62	14551.87	1961.0
2023-02-07 00:00:00	YM	Futures	37810.9	37836.5	37808.6	37828.7	856.0
2023-02-07 01:00:00	YM	Futures	37828.7	37851.0	37810.9	37815.3	1174.0
2023-02-07 02:00:00	YM	Futures	37815.3	37826.5	37794.2	37799.7	1228.0
2023-02-07 03:00:00	YM	Futures	37799.7	37823.1	37705.0	37773.0	3909.0

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

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