PREVIEW / futures_1hour / 2022-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-01.parquet
  size:    67 KB
  rows:    2,041

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-06-01 00:00:00	ES	Futures	4700.57	4702.84	4692.07	4701.71	6939.0
2022-06-01 01:00:00	ES	Futures	4701.42	4706.52	4682.43	4686.97	12938.0
2022-06-01 02:00:00	ES	Futures	4686.97	4698.59	4683.57	4698.02	14334.0
2022-06-01 03:00:00	ES	Futures	4698.02	4704.54	4689.8	4694.34	20315.0
2022-06-01 04:00:00	ES	Futures	4694.34	4696.04	4677.61	4686.4	17242.0
2022-06-01 05:00:00	ES	Futures	4686.68	4695.75	4685.83	4688.67	8711.0
2022-06-01 06:00:00	ES	Futures	4688.67	4690.37	4679.03	4683.0	11396.0
2022-06-01 07:00:00	ES	Futures	4682.43	4698.87	4682.43	4698.59	17584.0
2022-06-01 08:00:00	ES	Futures	4698.59	4708.79	4696.32	4702.27	28741.0
2022-06-01 09:00:00	ES	Futures	4702.27	4722.11	4696.04	4705.67	184084.0
2022-06-01 10:00:00	ES	Futures	4705.96	4710.78	4640.77	4659.76	323382.0
2022-06-01 11:00:00	ES	Futures	4659.47	4660.04	4620.93	4624.04	233928.0
2022-06-01 12:00:00	ES	Futures	4624.04	4634.81	4616.11	4628.3	186252.0
2022-06-01 13:00:00	ES	Futures	4628.3	4655.79	4625.74	4648.99	159052.0
2022-06-01 14:00:00	ES	Futures	4649.27	4677.33	4647.57	4664.01	237138.0
2022-06-01 15:00:00	ES	Futures	4664.01	4679.88	4645.58	4646.72	269791.0
2022-06-01 16:00:00	ES	Futures	4646.44	4650.97	4641.05	4645.02	65099.0
2022-06-01 18:00:00	ES	Futures	4645.87	4647.85	4636.8	4637.65	6969.0
2022-06-01 19:00:00	ES	Futures	4637.65	4641.05	4632.26	4634.25	6963.0
2022-06-01 20:00:00	ES	Futures	4634.25	4656.07	4629.71	4652.95	16197.0
2022-06-01 21:00:00	ES	Futures	4653.24	4657.49	4648.42	4648.99	10059.0
2022-06-01 22:00:00	ES	Futures	4648.99	4654.66	4643.32	4647.0	9448.0
2022-06-01 23:00:00	ES	Futures	4647.0	4650.4	4644.17	4647.85	5356.0
2022-06-01 00:00:00	NQ	Futures	14709.85	14717.1	14668.68	14706.08	3904.0
2022-06-01 01:00:00	NQ	Futures	14707.24	14725.8	14633.59	14651.57	7709.0
2022-06-01 02:00:00	NQ	Futures	14651.86	14695.36	14639.39	14688.98	6833.0
2022-06-01 03:00:00	NQ	Futures	14688.98	14711.3	14653.31	14664.91	10453.0
2022-06-01 04:00:00	NQ	Futures	14664.62	14672.16	14593.28	14637.65	11224.0
2022-06-01 05:00:00	NQ	Futures	14639.1	14677.96	14636.49	14647.8	5875.0
2022-06-01 06:00:00	NQ	Futures	14647.51	14659.69	14621.12	14637.94	6937.0
2022-06-01 07:00:00	NQ	Futures	14636.78	14713.33	14635.62	14711.59	9237.0
2022-06-01 08:00:00	NQ	Futures	14711.88	14751.03	14702.31	14718.84	16009.0
2022-06-01 09:00:00	NQ	Futures	14718.84	14873.98	14711.59	14853.39	83539.0
2022-06-01 10:00:00	NQ	Futures	14853.68	14869.63	14565.45	14664.62	121102.0
2022-06-01 11:00:00	NQ	Futures	14664.04	14665.2	14498.75	14508.9	84166.0
2022-06-01 12:00:00	NQ	Futures	14509.19	14529.49	14446.27	14496.43	67944.0
2022-06-01 13:00:00	NQ	Futures	14496.72	14577.63	14486.28	14554.72	54345.0
2022-06-01 14:00:00	NQ	Futures	14555.59	14684.05	14545.44	14627.5	65827.0
2022-06-01 15:00:00	NQ	Futures	14627.5	14689.56	14549.5	14556.75	77179.0
2022-06-01 16:00:00	NQ	Futures	14555.88	14571.25	14528.04	14554.43	18081.0
2022-06-01 18:00:00	NQ	Futures	14556.46	14561.97	14523.11	14529.49	3914.0
2022-06-01 19:00:00	NQ	Futures	14528.91	14541.38	14501.65	14509.19	4103.0
2022-06-01 20:00:00	NQ	Futures	14509.77	14598.79	14491.79	14586.9	8618.0
2022-06-01 21:00:00	NQ	Futures	14588.35	14603.43	14560.52	14562.84	5667.0
2022-06-01 22:00:00	NQ	Futures	14562.55	14588.06	14542.25	14558.49	4927.0
2022-06-01 23:00:00	NQ	Futures	14558.78	14572.41	14545.15	14566.9	2883.0
2022-06-01 00:00:00	YM	Futures	37362.0	37375.5	37309.0	37368.8	1129.0
2022-06-01 01:00:00	YM	Futures	37368.8	37404.8	37239.1	37268.4	2335.0
2022-06-01 02:00:00	YM	Futures	37270.7	37364.3	37248.1	37355.2	2697.0
2022-06-01 03:00:00	YM	Futures	37353.0	37408.2	37302.2	37334.9	2984.0

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

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