PREVIEW / futures_1hour / 2023-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-01.parquet
  size:    66 KB
  rows:    2,034

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-06-01 00:00:00	ES	Futures	4651.77	4655.1	4650.94	4651.77	3806.0
2023-06-01 01:00:00	ES	Futures	4651.77	4655.1	4651.77	4652.88	4404.0
2023-06-01 02:00:00	ES	Futures	4652.88	4656.49	4650.38	4654.82	8204.0
2023-06-01 03:00:00	ES	Futures	4655.1	4660.09	4652.05	4655.1	21129.0
2023-06-01 04:00:00	ES	Futures	4655.1	4660.65	4650.11	4659.54	16179.0
2023-06-01 05:00:00	ES	Futures	4659.26	4659.81	4655.38	4658.98	9303.0
2023-06-01 06:00:00	ES	Futures	4658.98	4663.42	4657.04	4657.32	15258.0
2023-06-01 07:00:00	ES	Futures	4657.32	4662.59	4654.82	4656.21	19625.0
2023-06-01 08:00:00	ES	Futures	4656.21	4658.43	4645.95	4649.27	54951.0
2023-06-01 09:00:00	ES	Futures	4649.0	4652.6	4635.13	4639.57	264242.0
2023-06-01 10:00:00	ES	Futures	4639.84	4668.13	4639.29	4663.97	325554.0
2023-06-01 11:00:00	ES	Futures	4663.97	4683.11	4661.48	4682.56	196955.0
2023-06-01 12:00:00	ES	Futures	4682.83	4691.43	4682.56	4689.77	131845.0
2023-06-01 13:00:00	ES	Futures	4689.77	4694.21	4685.05	4694.21	114303.0
2023-06-01 14:00:00	ES	Futures	4694.21	4698.92	4690.32	4698.09	116077.0
2023-06-01 15:00:00	ES	Futures	4698.37	4703.64	4680.62	4691.43	324044.0
2023-06-01 16:00:00	ES	Futures	4691.16	4695.59	4689.21	4694.76	97466.0
2023-06-01 18:00:00	ES	Futures	4694.76	4695.87	4693.65	4695.32	2946.0
2023-06-01 19:00:00	ES	Futures	4695.32	4695.32	4692.54	4693.1	3485.0
2023-06-01 20:00:00	ES	Futures	4693.1	4694.21	4691.99	4692.26	5935.0
2023-06-01 21:00:00	ES	Futures	4692.54	4695.04	4691.71	4693.37	6330.0
2023-06-01 22:00:00	ES	Futures	4693.65	4695.87	4692.54	4694.21	4296.0
2023-06-01 23:00:00	ES	Futures	4694.21	4701.14	4693.93	4698.64	5937.0
2023-06-01 00:00:00	NQ	Futures	16082.31	16097.23	16079.21	16087.38	1866.0
2023-06-01 01:00:00	NQ	Futures	16088.22	16105.4	16087.38	16095.54	2466.0
2023-06-01 02:00:00	NQ	Futures	16095.82	16112.43	16086.81	16101.74	3822.0
2023-06-01 03:00:00	NQ	Futures	16102.3	16133.83	16082.87	16101.74	9034.0
2023-06-01 04:00:00	NQ	Futures	16102.02	16121.73	16080.06	16115.81	6912.0
2023-06-01 05:00:00	NQ	Futures	16115.53	16117.5	16094.42	16109.34	3765.0
2023-06-01 06:00:00	NQ	Futures	16110.46	16139.18	16101.74	16121.44	6090.0
2023-06-01 07:00:00	NQ	Futures	16120.88	16145.94	16109.34	16115.53	7268.0
2023-06-01 08:00:00	NQ	Futures	16115.25	16128.2	16074.42	16100.61	20244.0
2023-06-01 09:00:00	NQ	Futures	16100.89	16131.58	16050.77	16113.56	103171.0
2023-06-01 10:00:00	NQ	Futures	16116.38	16199.43	16074.14	16168.75	103163.0
2023-06-01 11:00:00	NQ	Futures	16168.75	16243.92	16154.67	16242.51	64197.0
2023-06-01 12:00:00	NQ	Futures	16243.08	16292.07	16243.08	16287.0	49799.0
2023-06-01 13:00:00	NQ	Futures	16287.84	16315.43	16268.41	16314.59	41298.0
2023-06-01 14:00:00	NQ	Futures	16315.43	16344.43	16301.36	16334.02	43209.0
2023-06-01 15:00:00	NQ	Futures	16334.58	16361.89	16255.18	16299.95	90853.0
2023-06-01 16:00:00	NQ	Futures	16299.95	16330.07	16295.44	16326.41	20411.0
2023-06-01 18:00:00	NQ	Futures	16323.32	16325.85	16316.28	16321.63	1851.0
2023-06-01 19:00:00	NQ	Futures	16321.35	16321.35	16306.42	16311.21	2103.0
2023-06-01 20:00:00	NQ	Futures	16311.49	16315.15	16305.86	16308.11	2774.0
2023-06-01 21:00:00	NQ	Futures	16307.55	16324.16	16299.67	16316.84	3684.0
2023-06-01 22:00:00	NQ	Futures	16317.69	16327.82	16314.31	16321.63	2468.0
2023-06-01 23:00:00	NQ	Futures	16320.78	16345.84	16316.84	16338.52	3878.0
2023-06-01 00:00:00	YM	Futures	36435.4	36455.3	36428.8	36434.3	622.0
2023-06-01 01:00:00	YM	Futures	36435.4	36452.0	36431.0	36433.2	660.0
2023-06-01 02:00:00	YM	Futures	36431.0	36463.0	36418.8	36449.8	1103.0
2023-06-01 03:00:00	YM	Futures	36450.9	36490.7	36436.5	36449.8	2928.0

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

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