PREVIEW / futures_1hour / 2021-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-27.parquet
  size:    65 KB
  rows:    1,967

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-01-27 00:00:00	ES	Futures	4307.11	4311.32	4304.58	4311.04	9411.0
2021-01-27 01:00:00	ES	Futures	4311.04	4315.25	4307.11	4314.12	9956.0
2021-01-27 02:00:00	ES	Futures	4313.84	4314.97	4309.07	4311.88	9728.0
2021-01-27 03:00:00	ES	Futures	4311.88	4311.88	4303.46	4306.83	17686.0
2021-01-27 04:00:00	ES	Futures	4306.83	4313.28	4306.55	4308.79	12828.0
2021-01-27 05:00:00	ES	Futures	4308.51	4308.51	4299.81	4300.37	16582.0
2021-01-27 06:00:00	ES	Futures	4300.37	4300.93	4266.69	4278.48	66292.0
2021-01-27 07:00:00	ES	Futures	4278.76	4284.09	4256.59	4259.11	86599.0
2021-01-27 08:00:00	ES	Futures	4259.11	4274.83	4256.03	4270.06	76816.0
2021-01-27 09:00:00	ES	Futures	4270.06	4274.27	4220.66	4242.83	397395.0
2021-01-27 10:00:00	ES	Futures	4242.83	4269.78	4238.9	4267.81	311549.0
2021-01-27 11:00:00	ES	Futures	4267.81	4268.09	4226.84	4228.52	206690.0
2021-01-27 12:00:00	ES	Futures	4228.52	4256.31	4224.31	4255.18	168290.0
2021-01-27 13:00:00	ES	Futures	4254.9	4257.99	4236.66	4240.87	105772.0
2021-01-27 14:00:00	ES	Futures	4240.87	4249.85	4197.93	4203.26	330862.0
2021-01-27 15:00:00	ES	Futures	4203.26	4215.61	4179.96	4208.87	489335.0
2021-01-27 16:00:00	ES	Futures	4209.15	4217.57	4161.16	4191.75	135509.0
2021-01-27 18:00:00	ES	Futures	4193.44	4197.65	4157.79	4163.41	41542.0
2021-01-27 19:00:00	ES	Futures	4163.69	4186.42	4163.41	4183.61	33546.0
2021-01-27 20:00:00	ES	Futures	4183.33	4210.0	4181.93	4206.07	34578.0
2021-01-27 21:00:00	ES	Futures	4205.79	4209.15	4184.46	4195.68	23506.0
2021-01-27 22:00:00	ES	Futures	4195.4	4204.38	4184.74	4194.56	17955.0
2021-01-27 23:00:00	ES	Futures	4194.84	4198.21	4185.58	4187.82	11555.0
2021-01-27 00:00:00	NQ	Futures	15684.7	15707.57	15682.1	15702.65	3707.0
2021-01-27 01:00:00	NQ	Futures	15702.65	15713.94	15687.31	15693.1	3077.0
2021-01-27 02:00:00	NQ	Futures	15693.1	15696.57	15684.41	15693.1	2816.0
2021-01-27 03:00:00	NQ	Futures	15693.1	15693.1	15662.42	15674.28	7978.0
2021-01-27 04:00:00	NQ	Futures	15673.71	15706.41	15673.13	15687.02	5893.0
2021-01-27 05:00:00	NQ	Futures	15686.73	15691.94	15656.05	15658.65	6325.0
2021-01-27 06:00:00	NQ	Futures	15658.65	15658.65	15567.19	15573.85	18464.0
2021-01-27 07:00:00	NQ	Futures	15573.85	15608.0	15463.29	15463.29	31500.0
2021-01-27 08:00:00	NQ	Futures	15465.89	15511.33	15458.08	15506.7	23205.0
2021-01-27 09:00:00	NQ	Futures	15506.99	15517.41	15248.82	15375.3	123468.0
2021-01-27 10:00:00	NQ	Futures	15375.88	15494.26	15355.04	15472.55	103810.0
2021-01-27 11:00:00	NQ	Futures	15472.26	15473.13	15297.15	15302.07	77313.0
2021-01-27 12:00:00	NQ	Futures	15301.78	15430.29	15286.15	15419.0	69505.0
2021-01-27 13:00:00	NQ	Futures	15419.0	15434.63	15341.72	15361.12	42939.0
2021-01-27 14:00:00	NQ	Futures	15360.25	15401.93	15171.83	15189.19	87972.0
2021-01-27 15:00:00	NQ	Futures	15189.48	15223.35	15074.87	15189.19	108801.0
2021-01-27 16:00:00	NQ	Futures	15190.35	15234.06	14917.13	15122.04	39962.0
2021-01-27 18:00:00	NQ	Futures	15111.34	15113.36	14998.46	15025.66	14105.0
2021-01-27 19:00:00	NQ	Futures	15026.24	15082.97	15022.77	15067.63	9726.0
2021-01-27 20:00:00	NQ	Futures	15066.47	15200.77	15059.53	15175.88	12321.0
2021-01-27 21:00:00	NQ	Futures	15176.17	15192.09	15070.53	15120.6	10600.0
2021-01-27 22:00:00	NQ	Futures	15120.31	15151.28	15085.0	15126.1	7409.0
2021-01-27 23:00:00	NQ	Futures	15126.68	15137.96	15062.71	15070.24	6793.0
2021-01-27 00:00:00	YM	Futures	34120.0	34138.8	34091.1	34136.6	1514.0
2021-01-27 01:00:00	YM	Futures	34137.7	34174.3	34105.5	34164.3	1933.0
2021-01-27 02:00:00	YM	Futures	34162.1	34172.1	34123.3	34146.6	1883.0
2021-01-27 03:00:00	YM	Futures	34146.6	34146.6	34071.1	34108.9	4300.0

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

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