PREVIEW / futures_1hour / 2022-11-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	4329.89	4330.17	4315.51	4319.74	14480.0
2022-11-09 01:00:00	ES	Futures	4320.02	4320.58	4312.97	4314.38	12001.0
2022-11-09 02:00:00	ES	Futures	4314.38	4326.78	4313.25	4323.4	11379.0
2022-11-09 03:00:00	ES	Futures	4323.4	4335.52	4322.56	4325.38	21506.0
2022-11-09 04:00:00	ES	Futures	4325.38	4325.94	4301.7	4305.92	23153.0
2022-11-09 05:00:00	ES	Futures	4305.64	4316.92	4298.31	4315.23	27072.0
2022-11-09 06:00:00	ES	Futures	4315.23	4324.25	4313.25	4318.33	19419.0
2022-11-09 07:00:00	ES	Futures	4318.05	4322.27	4306.49	4321.15	21035.0
2022-11-09 08:00:00	ES	Futures	4321.15	4324.53	4297.19	4300.85	53867.0
2022-11-09 09:00:00	ES	Futures	4300.85	4307.9	4279.14	4286.19	208047.0
2022-11-09 10:00:00	ES	Futures	4286.19	4313.82	4271.53	4280.84	311056.0
2022-11-09 11:00:00	ES	Futures	4280.84	4303.95	4279.99	4290.42	180194.0
2022-11-09 12:00:00	ES	Futures	4290.14	4292.96	4276.61	4283.94	113092.0
2022-11-09 13:00:00	ES	Futures	4284.22	4287.04	4249.26	4256.88	213718.0
2022-11-09 14:00:00	ES	Futures	4256.88	4265.05	4239.12	4242.22	177110.0
2022-11-09 15:00:00	ES	Futures	4242.22	4257.44	4228.4	4234.61	287268.0
2022-11-09 16:00:00	ES	Futures	4234.89	4239.12	4232.35	4235.45	53887.0
2022-11-09 18:00:00	ES	Futures	4236.3	4240.53	4232.07	4236.86	7199.0
2022-11-09 19:00:00	ES	Futures	4236.86	4245.04	4235.45	4242.22	9990.0
2022-11-09 20:00:00	ES	Futures	4241.93	4247.85	4241.37	4242.78	12063.0
2022-11-09 21:00:00	ES	Futures	4242.78	4244.19	4236.3	4240.24	9299.0
2022-11-09 22:00:00	ES	Futures	4240.53	4244.19	4238.55	4241.37	5512.0
2022-11-09 23:00:00	ES	Futures	4241.37	4245.32	4239.96	4244.47	5121.0
2022-11-09 00:00:00	NQ	Futures	12790.6	12795.2	12743.77	12756.41	4981.0
2022-11-09 01:00:00	NQ	Futures	12757.56	12760.72	12732.85	12737.73	5103.0
2022-11-09 02:00:00	NQ	Futures	12738.59	12789.74	12734.0	12778.24	7126.0
2022-11-09 03:00:00	NQ	Futures	12778.53	12819.91	12760.14	12769.62	10974.0
2022-11-09 04:00:00	NQ	Futures	12769.91	12771.92	12680.84	12696.64	13049.0
2022-11-09 05:00:00	NQ	Futures	12696.36	12734.28	12665.04	12725.38	12435.0
2022-11-09 06:00:00	NQ	Futures	12725.38	12766.75	12717.04	12743.48	10402.0
2022-11-09 07:00:00	NQ	Futures	12743.48	12755.26	12694.63	12747.5	12697.0
2022-11-09 08:00:00	NQ	Futures	12746.64	12758.42	12654.12	12668.49	29314.0
2022-11-09 09:00:00	NQ	Futures	12668.2	12702.39	12598.09	12615.62	90155.0
2022-11-09 10:00:00	NQ	Futures	12615.91	12698.65	12556.72	12587.46	114238.0
2022-11-09 11:00:00	NQ	Futures	12587.75	12675.96	12584.87	12621.08	57849.0
2022-11-09 12:00:00	NQ	Futures	12621.65	12632.57	12573.96	12594.93	41142.0
2022-11-09 13:00:00	NQ	Futures	12595.5	12613.61	12476.55	12502.12	67046.0
2022-11-09 14:00:00	NQ	Futures	12502.7	12535.45	12453.57	12464.77	50418.0
2022-11-09 15:00:00	NQ	Futures	12464.77	12523.1	12438.05	12448.11	73002.0
2022-11-09 16:00:00	NQ	Futures	12448.68	12473.1	12443.8	12461.61	16508.0
2022-11-09 18:00:00	NQ	Futures	12459.6	12476.55	12452.42	12464.2	3809.0
2022-11-09 19:00:00	NQ	Futures	12463.05	12500.69	12457.3	12492.35	5529.0
2022-11-09 20:00:00	NQ	Futures	12492.35	12508.45	12482.59	12489.77	4866.0
2022-11-09 21:00:00	NQ	Futures	12488.91	12494.94	12467.07	12483.45	3499.0
2022-11-09 22:00:00	NQ	Futures	12483.45	12497.24	12475.69	12483.74	2424.0
2022-11-09 23:00:00	NQ	Futures	12484.31	12504.14	12479.71	12501.84	2802.0
2022-11-09 00:00:00	YM	Futures	37222.2	37223.4	37139.2	37169.5	1959.0
2022-11-09 01:00:00	YM	Futures	37171.7	37175.1	37116.8	37131.3	1703.0
2022-11-09 02:00:00	YM	Futures	37132.5	37202.0	37126.9	37179.6	1997.0
2022-11-09 03:00:00	YM	Futures	37180.7	37272.7	37175.1	37214.4	3661.0

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

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