PREVIEW / futures_1hour / 2022-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-10-24.parquet
  size:    69 KB
  rows:    2,101

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-10-24 00:00:00	ES	Futures	4247.01	4268.43	4243.34	4261.67	14347.0
2022-10-24 01:00:00	ES	Futures	4261.39	4262.79	4241.93	4245.88	13154.0
2022-10-24 02:00:00	ES	Futures	4245.6	4258.57	4241.93	4246.73	21127.0
2022-10-24 03:00:00	ES	Futures	4246.73	4262.79	4225.3	4233.76	42147.0
2022-10-24 04:00:00	ES	Futures	4233.76	4236.86	4213.18	4227.28	34268.0
2022-10-24 05:00:00	ES	Futures	4227.28	4248.42	4218.82	4246.16	22045.0
2022-10-24 06:00:00	ES	Futures	4246.45	4264.2	4239.96	4263.08	32260.0
2022-10-24 07:00:00	ES	Futures	4263.08	4287.6	4254.34	4275.2	46770.0
2022-10-24 08:00:00	ES	Futures	4275.2	4279.14	4257.72	4276.61	62667.0
2022-10-24 09:00:00	ES	Futures	4276.61	4294.65	4252.93	4282.53	295237.0
2022-10-24 10:00:00	ES	Futures	4282.25	4283.09	4230.38	4270.41	380090.0
2022-10-24 11:00:00	ES	Futures	4270.12	4288.45	4256.88	4287.04	229833.0
2022-10-24 12:00:00	ES	Futures	4287.32	4293.8	4279.71	4282.53	151407.0
2022-10-24 13:00:00	ES	Futures	4282.81	4283.94	4270.41	4276.61	138045.0
2022-10-24 14:00:00	ES	Futures	4276.61	4303.11	4275.2	4301.41	135908.0
2022-10-24 15:00:00	ES	Futures	4301.7	4309.59	4287.6	4295.49	240252.0
2022-10-24 16:00:00	ES	Futures	4295.49	4296.34	4288.45	4290.98	49693.0
2022-10-24 18:00:00	ES	Futures	4288.45	4300.29	4288.45	4300.29	7554.0
2022-10-24 19:00:00	ES	Futures	4300.29	4302.82	4293.8	4295.78	7334.0
2022-10-24 20:00:00	ES	Futures	4295.78	4303.67	4288.73	4299.44	12219.0
2022-10-24 21:00:00	ES	Futures	4299.44	4300.85	4279.71	4289.01	24808.0
2022-10-24 22:00:00	ES	Futures	4289.01	4290.42	4283.09	4290.14	10184.0
2022-10-24 23:00:00	ES	Futures	4290.14	4300.29	4287.88	4296.06	10029.0
2022-10-24 00:00:00	NQ	Futures	13075.34	13143.15	13061.83	13123.32	7740.0
2022-10-24 01:00:00	NQ	Futures	13122.17	13129.07	13054.36	13070.45	7870.0
2022-10-24 02:00:00	NQ	Futures	13069.59	13116.43	13056.09	13073.62	10537.0
2022-10-24 03:00:00	NQ	Futures	13073.9	13122.75	12986.27	13019.6	25263.0
2022-10-24 04:00:00	NQ	Futures	13020.17	13029.65	12942.02	12985.41	21580.0
2022-10-24 05:00:00	NQ	Futures	12984.54	13052.64	12957.82	13045.17	12858.0
2022-10-24 06:00:00	NQ	Futures	13045.46	13090.28	13015.29	13084.25	16759.0
2022-10-24 07:00:00	NQ	Futures	13084.53	13159.81	13056.95	13117.29	21267.0
2022-10-24 08:00:00	NQ	Futures	13116.71	13132.52	13049.77	13107.52	27491.0
2022-10-24 09:00:00	NQ	Futures	13106.95	13131.94	12987.7	13058.67	104260.0
2022-10-24 10:00:00	NQ	Futures	13058.39	13060.69	12881.11	13048.04	114250.0
2022-10-24 11:00:00	NQ	Futures	13047.18	13125.62	13010.69	13122.46	67959.0
2022-10-24 12:00:00	NQ	Futures	13123.32	13164.98	13094.02	13134.53	52036.0
2022-10-24 13:00:00	NQ	Futures	13134.82	13137.69	13071.6	13096.6	42228.0
2022-10-24 14:00:00	NQ	Futures	13096.89	13195.44	13091.72	13192.86	38464.0
2022-10-24 15:00:00	NQ	Futures	13192.57	13235.09	13164.98	13193.43	63196.0
2022-10-24 16:00:00	NQ	Futures	13193.43	13202.05	13163.84	13170.16	13204.0
2022-10-24 18:00:00	NQ	Futures	13163.84	13199.75	13163.55	13198.89	3594.0
2022-10-24 19:00:00	NQ	Futures	13198.6	13208.37	13180.5	13188.83	3995.0
2022-10-24 20:00:00	NQ	Futures	13188.83	13221.3	13161.25	13206.07	6125.0
2022-10-24 21:00:00	NQ	Futures	13205.5	13210.96	13136.83	13162.69	9846.0
2022-10-24 22:00:00	NQ	Futures	13163.26	13172.46	13145.45	13171.59	4383.0
2022-10-24 23:00:00	NQ	Futures	13171.88	13212.97	13165.85	13196.59	5345.0
2022-10-24 00:00:00	YM	Futures	34929.5	35076.5	34904.8	35040.6	2730.0
2022-10-24 01:00:00	YM	Futures	35039.5	35046.2	34893.6	34918.3	1934.0
2022-10-24 02:00:00	YM	Futures	34917.2	35013.7	34893.6	34934.0	3203.0
2022-10-24 03:00:00	YM	Futures	34931.8	35058.6	34783.6	34849.8	6386.0

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

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