PREVIEW / futures_1hour / 2021-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-23.parquet
  size:    64 KB
  rows:    1,943

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
2021-03-23 00:00:00	ES	Futures	4410.94	4413.19	4406.72	4407.0	5473.0
2021-03-23 01:00:00	ES	Futures	4406.72	4409.25	4404.48	4405.6	8466.0
2021-03-23 02:00:00	ES	Futures	4405.88	4408.69	4403.35	4407.0	8921.0
2021-03-23 03:00:00	ES	Futures	4407.0	4410.94	4406.16	4408.69	10271.0
2021-03-23 04:00:00	ES	Futures	4408.97	4408.97	4398.01	4405.32	27663.0
2021-03-23 05:00:00	ES	Futures	4405.6	4407.28	4395.48	4396.61	19142.0
2021-03-23 06:00:00	ES	Futures	4396.89	4401.1	4392.39	4399.98	23527.0
2021-03-23 07:00:00	ES	Futures	4399.98	4405.88	4396.89	4400.26	21745.0
2021-03-23 08:00:00	ES	Futures	4400.26	4407.57	4399.14	4406.44	27500.0
2021-03-23 09:00:00	ES	Futures	4406.44	4414.87	4404.76	4414.59	167750.0
2021-03-23 10:00:00	ES	Futures	4414.87	4421.05	4401.38	4414.03	249244.0
2021-03-23 11:00:00	ES	Futures	4413.75	4426.39	4412.06	4419.37	191389.0
2021-03-23 12:00:00	ES	Futures	4419.65	4425.27	4410.09	4420.77	177186.0
2021-03-23 13:00:00	ES	Futures	4420.77	4424.7	4405.88	4408.41	137189.0
2021-03-23 14:00:00	ES	Futures	4408.69	4412.9	4392.67	4393.24	206308.0
2021-03-23 15:00:00	ES	Futures	4393.24	4398.57	4372.44	4382.0	455509.0
2021-03-23 16:00:00	ES	Futures	4382.0	4389.86	4381.72	4387.34	54013.0
2021-03-23 18:00:00	ES	Futures	4389.58	4390.15	4381.72	4385.65	7205.0
2021-03-23 19:00:00	ES	Futures	4385.37	4385.37	4378.35	4381.72	7844.0
2021-03-23 20:00:00	ES	Futures	4382.0	4387.34	4380.87	4383.4	11342.0
2021-03-23 21:00:00	ES	Futures	4383.4	4388.18	4377.5	4378.06	11908.0
2021-03-23 22:00:00	ES	Futures	4378.06	4382.28	4374.41	4380.31	13129.0
2021-03-23 23:00:00	ES	Futures	4380.59	4387.34	4376.94	4385.37	9764.0
2021-03-23 00:00:00	NQ	Futures	15090.81	15099.78	15072.86	15074.02	3166.0
2021-03-23 01:00:00	NQ	Futures	15073.73	15087.63	15058.39	15064.18	4434.0
2021-03-23 02:00:00	NQ	Futures	15064.18	15093.13	15056.65	15087.92	4732.0
2021-03-23 03:00:00	NQ	Futures	15087.63	15120.63	15084.73	15107.31	7289.0
2021-03-23 04:00:00	NQ	Futures	15108.76	15119.76	15063.6	15114.84	10987.0
2021-03-23 05:00:00	NQ	Futures	15114.84	15130.18	15071.7	15092.26	8806.0
2021-03-23 06:00:00	NQ	Futures	15092.55	15126.13	15074.02	15113.97	9470.0
2021-03-23 07:00:00	NQ	Futures	15114.84	15160.0	15111.94	15143.79	9579.0
2021-03-23 08:00:00	NQ	Futures	15144.08	15187.5	15133.37	15177.95	14091.0
2021-03-23 09:00:00	NQ	Futures	15178.53	15193.58	15112.23	15145.24	73419.0
2021-03-23 10:00:00	NQ	Futures	15144.08	15209.5	15112.81	15198.21	90370.0
2021-03-23 11:00:00	NQ	Futures	15197.63	15252.93	15168.11	15185.48	69528.0
2021-03-23 12:00:00	NQ	Futures	15186.05	15213.85	15139.45	15192.42	58688.0
2021-03-23 13:00:00	NQ	Futures	15192.42	15226.29	15133.94	15147.26	46157.0
2021-03-23 14:00:00	NQ	Futures	15146.97	15197.34	15102.97	15103.84	55086.0
2021-03-23 15:00:00	NQ	Futures	15103.84	15125.26	15029.44	15059.54	91191.0
2021-03-23 16:00:00	NQ	Futures	15059.54	15098.92	15058.68	15088.78	9561.0
2021-03-23 18:00:00	NQ	Futures	15111.94	15114.26	15083.57	15094.28	3097.0
2021-03-23 19:00:00	NQ	Futures	15094.86	15096.02	15072.57	15087.05	3662.0
2021-03-23 20:00:00	NQ	Futures	15087.92	15121.5	15087.63	15109.05	5186.0
2021-03-23 21:00:00	NQ	Futures	15109.34	15138.87	15098.05	15099.49	6815.0
2021-03-23 22:00:00	NQ	Futures	15099.21	15111.36	15078.36	15100.36	6780.0
2021-03-23 23:00:00	NQ	Futures	15100.36	15136.26	15087.63	15122.65	5490.0
2021-03-23 00:00:00	YM	Futures	36291.5	36308.3	36260.4	36260.4	997.0
2021-03-23 01:00:00	YM	Futures	36260.4	36273.7	36244.8	36254.8	1582.0
2021-03-23 02:00:00	YM	Futures	36253.7	36269.3	36230.3	36259.2	1821.0
2021-03-23 03:00:00	YM	Futures	36258.1	36287.1	36247.0	36270.4	2182.0

> showing 50 of 1,943 rows — these rows as CSV

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