PREVIEW / futures_1hour / 2022-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-07.parquet
  size:    68 KB
  rows:    2,033

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-09-07 00:00:00	ES	Futures	4410.54	4417.05	4406.29	4414.5	5052.0
2022-09-07 01:00:00	ES	Futures	4414.79	4422.15	4413.37	4416.77	9028.0
2022-09-07 02:00:00	ES	Futures	4416.77	4428.1	4411.1	4422.43	15109.0
2022-09-07 03:00:00	ES	Futures	4422.15	4434.9	4411.95	4433.2	24312.0
2022-09-07 04:00:00	ES	Futures	4432.92	4445.38	4430.65	4440.85	20320.0
2022-09-07 05:00:00	ES	Futures	4440.85	4441.13	4432.35	4439.71	13283.0
2022-09-07 06:00:00	ES	Futures	4439.71	4440.56	4432.63	4436.03	11052.0
2022-09-07 07:00:00	ES	Futures	4436.31	4439.15	4420.73	4427.53	34419.0
2022-09-07 08:00:00	ES	Futures	4427.82	4430.37	4414.79	4423.28	45379.0
2022-09-07 09:00:00	ES	Futures	4423.0	4453.03	4419.89	4441.7	219886.0
2022-09-07 10:00:00	ES	Futures	4441.7	4460.39	4430.65	4453.88	302749.0
2022-09-07 11:00:00	ES	Futures	4453.88	4473.14	4448.78	4466.91	189806.0
2022-09-07 12:00:00	ES	Futures	4467.19	4480.22	4454.16	4475.41	172495.0
2022-09-07 13:00:00	ES	Futures	4475.41	4496.93	4473.71	4495.52	168417.0
2022-09-07 14:00:00	ES	Futures	4495.52	4511.95	4492.12	4510.53	207079.0
2022-09-07 15:00:00	ES	Futures	4510.53	4519.6	4506.0	4510.25	277387.0
2022-09-07 16:00:00	ES	Futures	4510.25	4511.67	4504.87	4507.98	57160.0
2022-09-07 18:00:00	ES	Futures	4509.68	4515.35	4508.27	4511.1	5916.0
2022-09-07 19:00:00	ES	Futures	4510.82	4513.08	4506.0	4506.57	6866.0
2022-09-07 20:00:00	ES	Futures	4506.57	4515.35	4504.87	4512.23	12865.0
2022-09-07 21:00:00	ES	Futures	4511.95	4517.33	4511.38	4512.23	9895.0
2022-09-07 22:00:00	ES	Futures	4511.95	4513.93	4507.13	4507.7	7841.0
2022-09-07 23:00:00	ES	Futures	4507.7	4513.36	4507.7	4510.25	5725.0
2022-09-07 00:00:00	NQ	Futures	13838.35	13869.59	13824.76	13862.94	3623.0
2022-09-07 01:00:00	NQ	Futures	13862.94	13896.49	13857.15	13871.33	5955.0
2022-09-07 02:00:00	NQ	Futures	13871.04	13914.42	13849.34	13888.39	8564.0
2022-09-07 03:00:00	NQ	Futures	13886.95	13940.17	13851.08	13930.91	14820.0
2022-09-07 04:00:00	NQ	Futures	13931.2	13973.43	13919.63	13954.92	12550.0
2022-09-07 05:00:00	NQ	Futures	13955.21	13956.07	13923.1	13947.97	8650.0
2022-09-07 06:00:00	NQ	Futures	13947.69	13954.05	13922.52	13930.62	6981.0
2022-09-07 07:00:00	NQ	Futures	13931.2	13937.85	13859.76	13893.31	15448.0
2022-09-07 08:00:00	NQ	Futures	13894.18	13910.08	13857.15	13897.36	18871.0
2022-09-07 09:00:00	NQ	Futures	13897.07	14031.85	13889.84	13974.3	85387.0
2022-09-07 10:00:00	NQ	Futures	13974.87	14010.45	13917.6	13971.69	108567.0
2022-09-07 11:00:00	NQ	Futures	13971.4	14070.9	13952.31	14050.65	72661.0
2022-09-07 12:00:00	NQ	Futures	14051.52	14084.78	14000.33	14066.27	56578.0
2022-09-07 13:00:00	NQ	Futures	14065.41	14134.24	14054.99	14127.3	54695.0
2022-09-07 14:00:00	NQ	Futures	14127.59	14207.42	14121.81	14197.88	63946.0
2022-09-07 15:00:00	NQ	Futures	14197.88	14237.79	14181.1	14186.6	79679.0
2022-09-07 16:00:00	NQ	Futures	14186.6	14197.01	14170.69	14188.33	16131.0
2022-09-07 18:00:00	NQ	Futures	14193.25	14226.51	14187.75	14198.74	3682.0
2022-09-07 19:00:00	NQ	Futures	14198.46	14209.16	14178.5	14182.26	4165.0
2022-09-07 20:00:00	NQ	Futures	14182.26	14214.36	14172.42	14205.11	6698.0
2022-09-07 21:00:00	NQ	Futures	14205.69	14224.78	14201.06	14203.66	4849.0
2022-09-07 22:00:00	NQ	Futures	14203.37	14209.16	14182.84	14186.89	2794.0
2022-09-07 23:00:00	NQ	Futures	14186.89	14207.13	14185.15	14193.83	3209.0
2022-09-07 00:00:00	YM	Futures	35014.8	35054.2	34984.3	35033.9	733.0
2022-09-07 01:00:00	YM	Futures	35036.2	35081.3	35027.2	35048.6	1220.0
2022-09-07 02:00:00	YM	Futures	35049.7	35128.7	35012.5	35090.4	2191.0
2022-09-07 03:00:00	YM	Futures	35094.9	35180.6	35018.1	35160.3	3298.0

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

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