PREVIEW / futures_1hour / 2022-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-02.parquet
  size:    68 KB
  rows:    2,010

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
2022-05-02 00:00:00	ES	Futures	4703.97	4707.66	4699.44	4705.96	6145.0
2022-05-02 01:00:00	ES	Futures	4705.96	4710.49	4690.94	4692.35	10753.0
2022-05-02 02:00:00	ES	Futures	4692.07	4710.78	4691.79	4709.08	9509.0
2022-05-02 03:00:00	ES	Futures	4709.36	4714.46	4675.91	4687.53	25431.0
2022-05-02 04:00:00	ES	Futures	4687.25	4707.94	4684.42	4690.09	18349.0
2022-05-02 05:00:00	ES	Futures	4689.8	4705.11	4689.52	4698.02	12083.0
2022-05-02 06:00:00	ES	Futures	4698.02	4704.54	4692.35	4694.62	13525.0
2022-05-02 07:00:00	ES	Futures	4694.9	4698.3	4661.17	4663.73	24421.0
2022-05-02 08:00:00	ES	Futures	4664.01	4676.2	4660.61	4667.41	37874.0
2022-05-02 09:00:00	ES	Futures	4667.13	4694.05	4646.15	4681.02	287601.0
2022-05-02 10:00:00	ES	Futures	4681.3	4722.96	4659.47	4683.0	354494.0
2022-05-02 11:00:00	ES	Futures	4683.0	4684.98	4652.95	4674.78	247483.0
2022-05-02 12:00:00	ES	Futures	4674.78	4684.42	4639.63	4643.6	184493.0
2022-05-02 13:00:00	ES	Futures	4643.88	4656.07	4620.08	4628.3	192770.0
2022-05-02 14:00:00	ES	Futures	4628.01	4641.62	4598.53	4614.41	218789.0
2022-05-02 15:00:00	ES	Futures	4614.12	4708.79	4613.27	4706.81	452128.0
2022-05-02 16:00:00	ES	Futures	4706.81	4712.19	4696.89	4700.86	69274.0
2022-05-02 18:00:00	ES	Futures	4700.01	4701.99	4695.75	4697.17	4524.0
2022-05-02 19:00:00	ES	Futures	4697.17	4704.54	4697.17	4703.41	3908.0
2022-05-02 20:00:00	ES	Futures	4703.12	4717.58	4700.86	4714.46	9639.0
2022-05-02 21:00:00	ES	Futures	4714.46	4720.13	4705.96	4717.58	9014.0
2022-05-02 22:00:00	ES	Futures	4717.3	4734.59	4717.01	4730.05	12184.0
2022-05-02 23:00:00	ES	Futures	4729.77	4732.32	4720.98	4722.11	5364.0
2022-05-02 00:00:00	NQ	Futures	15016.07	15028.54	14994.61	15016.94	3829.0
2022-05-02 01:00:00	NQ	Futures	15018.68	15033.47	14965.9	14971.12	6594.0
2022-05-02 02:00:00	NQ	Futures	14971.12	15038.98	14967.06	15033.47	5882.0
2022-05-02 03:00:00	NQ	Futures	15033.76	15055.79	14936.03	14969.96	14567.0
2022-05-02 04:00:00	NQ	Futures	14970.54	15031.73	14931.11	14949.66	13803.0
2022-05-02 05:00:00	NQ	Futures	14951.11	14999.83	14948.79	14972.57	7335.0
2022-05-02 06:00:00	NQ	Futures	14973.44	15007.37	14958.94	14971.7	6226.0
2022-05-02 07:00:00	NQ	Futures	14971.7	14985.62	14807.29	14827.58	15327.0
2022-05-02 08:00:00	NQ	Futures	14828.45	14878.62	14816.85	14841.79	19024.0
2022-05-02 09:00:00	NQ	Futures	14841.21	15047.68	14780.32	14995.19	114605.0
2022-05-02 10:00:00	NQ	Futures	14995.19	15132.64	14857.45	14971.7	119585.0
2022-05-02 11:00:00	NQ	Futures	14971.7	15005.92	14872.24	14969.38	71823.0
2022-05-02 12:00:00	NQ	Futures	14969.09	15027.09	14846.14	14859.19	57156.0
2022-05-02 13:00:00	NQ	Futures	14859.48	14896.02	14775.68	14828.16	52768.0
2022-05-02 14:00:00	NQ	Futures	14827.29	14886.45	14742.04	14811.35	62443.0
2022-05-02 15:00:00	NQ	Futures	14811.06	15173.81	14807.29	15160.19	110727.0
2022-05-02 16:00:00	NQ	Futures	15160.48	15176.71	15104.22	15138.15	23332.0
2022-05-02 18:00:00	NQ	Futures	15138.73	15142.79	15111.76	15118.72	2993.0
2022-05-02 19:00:00	NQ	Futures	15118.72	15150.04	15118.43	15143.95	2676.0
2022-05-02 20:00:00	NQ	Futures	15143.95	15218.47	15131.77	15200.78	5324.0
2022-05-02 21:00:00	NQ	Futures	15200.2	15217.02	15161.93	15213.54	5059.0
2022-05-02 22:00:00	NQ	Futures	15213.83	15277.63	15212.96	15259.07	6677.0
2022-05-02 23:00:00	NQ	Futures	15259.07	15264.87	15220.21	15224.27	3436.0
2022-05-02 00:00:00	YM	Futures	37248.1	37278.6	37222.2	37274.1	1139.0
2022-05-02 01:00:00	YM	Futures	37274.1	37304.5	37168.1	37178.2	1998.0
2022-05-02 02:00:00	YM	Futures	37179.4	37306.8	37176.0	37292.1	2131.0
2022-05-02 03:00:00	YM	Futures	37292.1	37333.8	37036.2	37123.0	4672.0

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

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