PREVIEW / futures_1hour / 2022-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-11-07.parquet
  size:    70 KB
  rows:    2,107

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-11-07 00:00:00	ES	Futures	4254.34	4264.2	4252.08	4253.77	9769.0
2022-11-07 01:00:00	ES	Futures	4253.49	4259.69	4253.21	4257.44	5932.0
2022-11-07 02:00:00	ES	Futures	4257.72	4258.85	4239.12	4239.96	15605.0
2022-11-07 03:00:00	ES	Futures	4240.24	4272.94	4236.86	4271.25	30144.0
2022-11-07 04:00:00	ES	Futures	4271.25	4279.14	4269.0	4269.28	28760.0
2022-11-07 05:00:00	ES	Futures	4269.56	4284.78	4269.28	4283.94	18032.0
2022-11-07 06:00:00	ES	Futures	4283.94	4290.42	4281.96	4284.22	16537.0
2022-11-07 07:00:00	ES	Futures	4283.94	4290.42	4275.76	4279.14	28748.0
2022-11-07 08:00:00	ES	Futures	4279.71	4285.63	4267.59	4274.07	58967.0
2022-11-07 09:00:00	ES	Futures	4273.79	4284.22	4252.36	4259.13	193879.0
2022-11-07 10:00:00	ES	Futures	4259.13	4284.78	4258.0	4276.04	223814.0
2022-11-07 11:00:00	ES	Futures	4276.33	4282.25	4259.98	4260.26	149496.0
2022-11-07 12:00:00	ES	Futures	4260.26	4273.22	4255.18	4269.28	107537.0
2022-11-07 13:00:00	ES	Futures	4269.28	4280.55	4268.71	4279.43	92006.0
2022-11-07 14:00:00	ES	Futures	4279.43	4303.11	4279.43	4295.78	139181.0
2022-11-07 15:00:00	ES	Futures	4295.78	4309.31	4295.49	4302.82	201809.0
2022-11-07 16:00:00	ES	Futures	4302.82	4303.39	4296.62	4298.6	41368.0
2022-11-07 18:00:00	ES	Futures	4299.16	4303.67	4295.21	4303.11	5999.0
2022-11-07 19:00:00	ES	Futures	4303.39	4316.07	4302.54	4312.41	15282.0
2022-11-07 20:00:00	ES	Futures	4312.41	4312.41	4304.23	4307.33	10638.0
2022-11-07 21:00:00	ES	Futures	4307.62	4307.62	4298.88	4298.88	7349.0
2022-11-07 22:00:00	ES	Futures	4299.16	4305.36	4298.88	4303.11	4417.0
2022-11-07 23:00:00	ES	Futures	4303.11	4305.08	4295.78	4298.88	6021.0
2022-11-07 00:00:00	NQ	Futures	12486.03	12518.21	12474.54	12480.0	4096.0
2022-11-07 01:00:00	NQ	Futures	12478.85	12501.84	12477.41	12494.65	2875.0
2022-11-07 02:00:00	NQ	Futures	12495.52	12498.96	12429.72	12436.04	7183.0
2022-11-07 03:00:00	NQ	Futures	12437.19	12567.35	12427.42	12557.29	15252.0
2022-11-07 04:00:00	NQ	Futures	12557.0	12578.27	12526.55	12528.56	11911.0
2022-11-07 05:00:00	NQ	Futures	12529.13	12589.76	12529.13	12584.01	7769.0
2022-11-07 06:00:00	NQ	Futures	12584.3	12610.16	12576.83	12579.41	8476.0
2022-11-07 07:00:00	NQ	Futures	12578.84	12599.24	12549.53	12564.19	11408.0
2022-11-07 08:00:00	NQ	Futures	12564.76	12588.32	12534.59	12557.58	24036.0
2022-11-07 09:00:00	NQ	Futures	12557.0	12606.42	12466.78	12508.45	79966.0
2022-11-07 10:00:00	NQ	Futures	12509.02	12598.95	12487.18	12557.87	83862.0
2022-11-07 11:00:00	NQ	Futures	12559.01	12585.16	12489.19	12489.77	57536.0
2022-11-07 12:00:00	NQ	Futures	12490.06	12538.9	12470.23	12525.68	38180.0
2022-11-07 13:00:00	NQ	Futures	12526.26	12574.24	12524.25	12564.76	31436.0
2022-11-07 14:00:00	NQ	Futures	12564.76	12670.78	12564.76	12639.75	54368.0
2022-11-07 15:00:00	NQ	Futures	12639.75	12686.59	12637.74	12659.0	55543.0
2022-11-07 16:00:00	NQ	Futures	12658.72	12675.96	12646.36	12658.43	13959.0
2022-11-07 18:00:00	NQ	Futures	12660.73	12673.08	12647.22	12670.78	2858.0
2022-11-07 19:00:00	NQ	Futures	12671.07	12715.32	12667.91	12705.55	6699.0
2022-11-07 20:00:00	NQ	Futures	12705.84	12705.84	12677.97	12690.61	4433.0
2022-11-07 21:00:00	NQ	Futures	12689.17	12690.32	12659.29	12660.15	3484.0
2022-11-07 22:00:00	NQ	Futures	12660.44	12679.4	12657.57	12669.35	2655.0
2022-11-07 23:00:00	NQ	Futures	12669.92	12676.82	12638.03	12648.66	3823.0
2022-11-07 00:00:00	YM	Futures	36349.1	36414.2	36323.3	36348.0	1461.0
2022-11-07 01:00:00	YM	Futures	36344.7	36386.2	36344.7	36370.5	819.0
2022-11-07 02:00:00	YM	Futures	36371.6	36380.6	36231.3	36242.5	2717.0
2022-11-07 03:00:00	YM	Futures	36243.7	36470.3	36215.6	36461.4	5579.0

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

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