PREVIEW / futures_1hour / 2021-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-01.parquet
  size:    62 KB
  rows:    1,957

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
2021-06-01 00:00:00	ES	Futures	4722.53	4726.19	4721.69	4725.9	3617.0
2021-06-01 01:00:00	ES	Futures	4725.62	4727.03	4723.94	4725.34	5655.0
2021-06-01 02:00:00	ES	Futures	4725.06	4729.56	4722.53	4727.87	11003.0
2021-06-01 03:00:00	ES	Futures	4727.87	4741.08	4727.87	4740.51	25977.0
2021-06-01 04:00:00	ES	Futures	4740.51	4742.76	4736.3	4742.2	20496.0
2021-06-01 05:00:00	ES	Futures	4741.92	4745.29	4740.8	4742.76	17602.0
2021-06-01 06:00:00	ES	Futures	4743.04	4745.85	4742.48	4744.45	10815.0
2021-06-01 07:00:00	ES	Futures	4744.45	4752.03	4744.17	4748.38	25597.0
2021-06-01 08:00:00	ES	Futures	4748.66	4749.51	4744.73	4747.26	25034.0
2021-06-01 09:00:00	ES	Futures	4747.26	4754.0	4734.61	4738.27	187803.0
2021-06-01 10:00:00	ES	Futures	4738.27	4740.8	4717.47	4721.69	281752.0
2021-06-01 11:00:00	ES	Futures	4721.41	4728.99	4718.32	4727.03	108893.0
2021-06-01 12:00:00	ES	Futures	4727.03	4727.87	4719.72	4721.69	77101.0
2021-06-01 13:00:00	ES	Futures	4721.69	4721.69	4714.67	4718.88	82261.0
2021-06-01 14:00:00	ES	Futures	4718.88	4727.87	4717.47	4727.03	80395.0
2021-06-01 15:00:00	ES	Futures	4727.31	4727.59	4717.19	4719.44	177471.0
2021-06-01 16:00:00	ES	Futures	4719.44	4722.53	4717.47	4718.6	43036.0
2021-06-01 18:00:00	ES	Futures	4718.6	4718.88	4710.45	4711.29	8880.0
2021-06-01 19:00:00	ES	Futures	4711.01	4715.79	4709.89	4715.51	5325.0
2021-06-01 20:00:00	ES	Futures	4715.79	4721.97	4712.42	4721.13	10468.0
2021-06-01 21:00:00	ES	Futures	4721.13	4721.97	4718.04	4719.16	6688.0
2021-06-01 22:00:00	ES	Futures	4719.16	4722.81	4716.91	4718.6	5700.0
2021-06-01 23:00:00	ES	Futures	4718.6	4721.69	4718.04	4719.16	3286.0
2021-06-01 00:00:00	NQ	Futures	15850.16	15860.0	15844.66	15857.68	1553.0
2021-06-01 01:00:00	NQ	Futures	15857.68	15862.6	15850.45	15853.92	1675.0
2021-06-01 02:00:00	NQ	Futures	15853.34	15881.13	15849.29	15872.16	4643.0
2021-06-01 03:00:00	NQ	Futures	15872.16	15884.9	15859.71	15883.45	7769.0
2021-06-01 04:00:00	NQ	Futures	15884.03	15906.61	15876.5	15904.29	6948.0
2021-06-01 05:00:00	NQ	Futures	15904.58	15919.92	15901.69	15908.34	5951.0
2021-06-01 06:00:00	NQ	Futures	15908.63	15917.9	15904.29	15906.03	3266.0
2021-06-01 07:00:00	NQ	Futures	15906.03	15930.06	15898.5	15910.66	7158.0
2021-06-01 08:00:00	NQ	Futures	15910.66	15921.66	15898.79	15911.53	7801.0
2021-06-01 09:00:00	NQ	Futures	15911.82	15948.87	15870.71	15890.69	59643.0
2021-06-01 10:00:00	NQ	Futures	15890.4	15901.4	15739.57	15765.33	98178.0
2021-06-01 11:00:00	NQ	Futures	15765.62	15825.84	15749.7	15817.15	42259.0
2021-06-01 12:00:00	NQ	Futures	15817.44	15835.97	15793.99	15823.23	29115.0
2021-06-01 13:00:00	NQ	Futures	15822.94	15823.23	15790.23	15818.31	29071.0
2021-06-01 14:00:00	NQ	Futures	15818.02	15856.53	15809.92	15851.6	25836.0
2021-06-01 15:00:00	NQ	Futures	15851.89	15853.34	15800.36	15807.6	40175.0
2021-06-01 16:00:00	NQ	Futures	15807.31	15813.97	15797.76	15803.55	7582.0
2021-06-01 18:00:00	NQ	Futures	15810.21	15810.21	15775.18	15777.78	3538.0
2021-06-01 19:00:00	NQ	Futures	15777.49	15791.1	15774.31	15788.78	2548.0
2021-06-01 20:00:00	NQ	Futures	15788.78	15815.13	15778.36	15809.05	5173.0
2021-06-01 21:00:00	NQ	Futures	15807.89	15816.0	15792.55	15802.39	3178.0
2021-06-01 22:00:00	NQ	Futures	15802.1	15815.71	15793.7	15800.07	2275.0
2021-06-01 23:00:00	NQ	Futures	15800.36	15810.5	15791.68	15797.47	1730.0
2021-06-01 00:00:00	YM	Futures	38443.4	38474.6	38435.6	38472.4	801.0
2021-06-01 01:00:00	YM	Futures	38471.3	38481.3	38455.7	38471.3	1175.0
2021-06-01 02:00:00	YM	Futures	38470.2	38491.3	38443.4	38480.2	1846.0
2021-06-01 03:00:00	YM	Futures	38480.2	38626.1	38480.2	38623.9	6087.0

> showing 50 of 1,957 rows — these rows as CSV

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