PREVIEW / futures_1hour / 2022-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-12-20.parquet
  size:    67 KB
  rows:    2,031

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-12-20 00:00:00	ES	Futures	4265.4	4269.03	4253.93	4264.28	15840.0
2022-12-20 01:00:00	ES	Futures	4264.28	4272.39	4261.48	4269.59	11885.0
2022-12-20 02:00:00	ES	Futures	4269.87	4277.7	4267.08	4270.99	15873.0
2022-12-20 03:00:00	ES	Futures	4270.71	4298.67	4264.28	4296.71	32045.0
2022-12-20 04:00:00	ES	Futures	4296.71	4301.75	4289.44	4298.39	22428.0
2022-12-20 05:00:00	ES	Futures	4298.11	4300.63	4289.44	4296.43	14051.0
2022-12-20 06:00:00	ES	Futures	4296.15	4304.26	4294.48	4297.55	16484.0
2022-12-20 07:00:00	ES	Futures	4297.27	4304.82	4287.21	4287.49	21419.0
2022-12-20 08:00:00	ES	Futures	4287.77	4298.67	4286.09	4291.12	29581.0
2022-12-20 09:00:00	ES	Futures	4290.84	4302.59	4274.9	4299.51	198666.0
2022-12-20 10:00:00	ES	Futures	4299.79	4323.56	4298.95	4313.77	229999.0
2022-12-20 11:00:00	ES	Futures	4313.77	4316.57	4286.09	4305.94	190021.0
2022-12-20 12:00:00	ES	Futures	4306.22	4314.05	4299.23	4312.09	119399.0
2022-12-20 13:00:00	ES	Futures	4312.09	4324.39	4305.1	4313.49	106449.0
2022-12-20 14:00:00	ES	Futures	4313.49	4321.88	4304.26	4307.06	117885.0
2022-12-20 15:00:00	ES	Futures	4307.34	4316.85	4300.07	4305.1	191047.0
2022-12-20 16:00:00	ES	Futures	4305.1	4311.25	4302.59	4309.86	42142.0
2022-12-20 18:00:00	ES	Futures	4314.05	4322.44	4312.09	4319.92	12019.0
2022-12-20 19:00:00	ES	Futures	4319.64	4324.12	4313.49	4322.16	10561.0
2022-12-20 20:00:00	ES	Futures	4321.88	4335.02	4320.48	4331.11	16215.0
2022-12-20 21:00:00	ES	Futures	4331.11	4333.62	4327.19	4328.03	6531.0
2022-12-20 22:00:00	ES	Futures	4328.03	4329.99	4324.95	4327.47	5493.0
2022-12-20 23:00:00	ES	Futures	4327.75	4328.31	4317.68	4319.36	5649.0
2022-12-20 00:00:00	NQ	Futures	12606.79	12617.88	12567.24	12601.38	8389.0
2022-12-20 01:00:00	NQ	Futures	12600.81	12632.67	12592.85	12623.57	5502.0
2022-12-20 02:00:00	NQ	Futures	12623.29	12649.18	12610.2	12626.13	8268.0
2022-12-20 03:00:00	NQ	Futures	12624.99	12712.05	12601.38	12704.08	16512.0
2022-12-20 04:00:00	NQ	Futures	12703.23	12722.29	12680.75	12706.07	12148.0
2022-12-20 05:00:00	NQ	Futures	12706.64	12717.17	12682.75	12701.52	7504.0
2022-12-20 06:00:00	NQ	Futures	12701.24	12731.39	12696.69	12706.93	7509.0
2022-12-20 07:00:00	NQ	Futures	12707.78	12721.72	12656.0	12657.43	11133.0
2022-12-20 08:00:00	NQ	Futures	12657.99	12700.67	12657.71	12674.49	16297.0
2022-12-20 09:00:00	NQ	Futures	12674.49	12720.01	12593.7	12709.77	93649.0
2022-12-20 10:00:00	NQ	Futures	12709.49	12798.82	12697.82	12736.23	100999.0
2022-12-20 11:00:00	NQ	Futures	12737.08	12759.84	12633.53	12718.02	79443.0
2022-12-20 12:00:00	NQ	Futures	12718.31	12758.14	12692.42	12737.94	51818.0
2022-12-20 13:00:00	NQ	Futures	12738.79	12777.2	12704.08	12732.82	44588.0
2022-12-20 14:00:00	NQ	Futures	12733.39	12764.68	12706.07	12718.88	38759.0
2022-12-20 15:00:00	NQ	Futures	12719.16	12753.02	12698.11	12717.45	54675.0
2022-12-20 16:00:00	NQ	Futures	12717.74	12740.21	12712.9	12737.37	11305.0
2022-12-20 18:00:00	NQ	Futures	12752.73	12784.31	12750.45	12771.79	6862.0
2022-12-20 19:00:00	NQ	Futures	12771.79	12782.89	12749.6	12774.92	5029.0
2022-12-20 20:00:00	NQ	Futures	12774.35	12817.88	12769.52	12803.37	6603.0
2022-12-20 21:00:00	NQ	Futures	12803.66	12810.48	12791.71	12795.97	3020.0
2022-12-20 22:00:00	NQ	Futures	12795.69	12797.68	12781.46	12789.72	3067.0
2022-12-20 23:00:00	NQ	Futures	12790.0	12791.71	12752.45	12757.57	3740.0
2022-12-20 00:00:00	YM	Futures	36490.6	36519.5	36418.1	36493.9	2545.0
2022-12-20 01:00:00	YM	Futures	36495.0	36561.9	36473.9	36542.9	1671.0
2022-12-20 02:00:00	YM	Futures	36542.9	36609.8	36525.1	36548.5	2516.0
2022-12-20 03:00:00	YM	Futures	36545.2	36766.9	36497.3	36747.9	4303.0

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

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