PREVIEW / futures_1hour / 2022-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-06.parquet
  size:    66 KB
  rows:    2,005

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-06 00:00:00	ES	Futures	4679.31	4683.57	4677.61	4682.43	6823.0
2022-06-06 01:00:00	ES	Futures	4682.15	4684.13	4677.33	4681.87	8988.0
2022-06-06 02:00:00	ES	Futures	4681.58	4687.25	4676.48	4685.83	13749.0
2022-06-06 03:00:00	ES	Futures	4686.12	4702.56	4684.42	4702.27	23198.0
2022-06-06 04:00:00	ES	Futures	4701.99	4712.48	4701.99	4711.06	21235.0
2022-06-06 05:00:00	ES	Futures	4711.06	4711.34	4698.59	4702.27	10857.0
2022-06-06 06:00:00	ES	Futures	4702.56	4708.23	4701.71	4707.09	8373.0
2022-06-06 07:00:00	ES	Futures	4706.81	4708.79	4698.3	4708.51	13170.0
2022-06-06 08:00:00	ES	Futures	4708.51	4715.31	4703.41	4707.94	23544.0
2022-06-06 09:00:00	ES	Futures	4708.23	4713.33	4692.35	4709.08	163707.0
2022-06-06 10:00:00	ES	Futures	4709.36	4725.8	4707.66	4719.85	187516.0
2022-06-06 11:00:00	ES	Futures	4720.13	4724.66	4681.87	4692.92	178172.0
2022-06-06 12:00:00	ES	Futures	4692.92	4693.77	4660.04	4677.9	154851.0
2022-06-06 13:00:00	ES	Futures	4677.9	4693.77	4665.43	4693.49	145013.0
2022-06-06 14:00:00	ES	Futures	4693.77	4693.77	4660.04	4671.38	161716.0
2022-06-06 15:00:00	ES	Futures	4671.66	4677.9	4656.64	4670.24	200617.0
2022-06-06 16:00:00	ES	Futures	4670.53	4673.93	4666.84	4671.94	34307.0
2022-06-06 18:00:00	ES	Futures	4673.36	4675.06	4664.86	4666.56	8938.0
2022-06-06 19:00:00	ES	Futures	4666.84	4675.63	4665.71	4672.51	6695.0
2022-06-06 20:00:00	ES	Futures	4672.51	4672.8	4654.37	4658.62	11694.0
2022-06-06 21:00:00	ES	Futures	4658.62	4664.01	4639.63	4650.69	19617.0
2022-06-06 22:00:00	ES	Futures	4650.4	4652.1	4641.9	4643.88	8597.0
2022-06-06 23:00:00	ES	Futures	4643.88	4653.8	4643.03	4650.12	9161.0
2022-06-06 00:00:00	NQ	Futures	14651.86	14672.74	14643.74	14667.81	3277.0
2022-06-06 01:00:00	NQ	Futures	14667.52	14672.16	14642.0	14659.4	3974.0
2022-06-06 02:00:00	NQ	Futures	14659.69	14686.95	14634.75	14679.12	6782.0
2022-06-06 03:00:00	NQ	Futures	14680.57	14746.97	14675.64	14744.36	10593.0
2022-06-06 04:00:00	NQ	Futures	14744.07	14790.18	14742.62	14784.67	10879.0
2022-06-06 05:00:00	NQ	Futures	14785.54	14788.15	14734.5	14746.1	5840.0
2022-06-06 06:00:00	NQ	Futures	14745.52	14783.22	14741.46	14774.81	5388.0
2022-06-06 07:00:00	NQ	Futures	14773.36	14780.9	14738.85	14775.1	7448.0
2022-06-06 08:00:00	NQ	Futures	14775.39	14807.29	14757.12	14778.29	14642.0
2022-06-06 09:00:00	NQ	Futures	14778.29	14829.9	14699.99	14787.86	77232.0
2022-06-06 10:00:00	NQ	Futures	14788.44	14858.32	14784.67	14823.81	73573.0
2022-06-06 11:00:00	NQ	Futures	14823.81	14839.18	14646.93	14690.43	68741.0
2022-06-06 12:00:00	NQ	Futures	14691.01	14693.91	14536.74	14620.54	55708.0
2022-06-06 13:00:00	NQ	Futures	14620.54	14706.08	14563.13	14704.34	42058.0
2022-06-06 14:00:00	NQ	Futures	14704.92	14711.59	14564.87	14602.85	46281.0
2022-06-06 15:00:00	NQ	Futures	14603.43	14635.04	14545.44	14615.03	58656.0
2022-06-06 16:00:00	NQ	Futures	14615.32	14625.47	14592.7	14622.57	11359.0
2022-06-06 18:00:00	NQ	Futures	14620.83	14631.56	14588.64	14595.6	4595.0
2022-06-06 19:00:00	NQ	Futures	14595.89	14629.53	14592.99	14618.22	3427.0
2022-06-06 20:00:00	NQ	Futures	14618.8	14621.7	14549.5	14565.74	6395.0
2022-06-06 21:00:00	NQ	Futures	14565.74	14583.42	14484.83	14530.36	11298.0
2022-06-06 22:00:00	NQ	Futures	14528.62	14534.42	14501.07	14513.25	4275.0
2022-06-06 23:00:00	NQ	Futures	14513.25	14550.37	14509.48	14533.55	4168.0
2022-06-06 00:00:00	YM	Futures	37210.9	37243.6	37205.3	37232.4	518.0
2022-06-06 01:00:00	YM	Futures	37231.2	37251.5	37209.8	37240.2	1089.0
2022-06-06 02:00:00	YM	Futures	37236.9	37270.7	37205.3	37254.9	1962.0
2022-06-06 03:00:00	YM	Futures	37257.2	37362.0	37245.9	37362.0	3826.0

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

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