PREVIEW / futures_1hour / 2021-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-26.parquet
  size:    49 KB
  rows:    1,353

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-11-26 00:00:00	ES	Futures	5252.82	5255.64	5249.15	5253.67	12636.0
2021-11-26 01:00:00	ES	Futures	5253.67	5254.79	5231.37	5236.45	27306.0
2021-11-26 02:00:00	ES	Futures	5237.02	5237.58	5213.87	5215.85	58424.0
2021-11-26 03:00:00	ES	Futures	5215.85	5224.32	5189.32	5220.08	92870.0
2021-11-26 04:00:00	ES	Futures	5220.36	5221.78	5194.4	5204.28	53041.0
2021-11-26 05:00:00	ES	Futures	5204.28	5218.39	5198.07	5208.23	35343.0
2021-11-26 06:00:00	ES	Futures	5208.23	5220.36	5205.13	5209.36	39621.0
2021-11-26 07:00:00	ES	Futures	5209.64	5224.32	5209.08	5215.85	48011.0
2021-11-26 08:00:00	ES	Futures	5216.13	5222.34	5209.92	5215.57	60379.0
2021-11-26 09:00:00	ES	Futures	5215.57	5241.53	5204.28	5214.16	269839.0
2021-11-26 10:00:00	ES	Futures	5213.87	5214.16	5185.94	5199.48	326952.0
2021-11-26 11:00:00	ES	Futures	5199.48	5199.76	5175.78	5184.81	290586.0
2021-11-26 12:00:00	ES	Futures	5184.81	5213.87	5171.54	5186.78	365023.0
2021-11-26 13:00:00	ES	Futures	5186.78	5193.84	5167.03	5169.0	72311.0
2021-11-26 00:00:00	NQ	Futures	18881.3	18904.77	18860.43	18891.44	5944.0
2021-11-26 01:00:00	NQ	Futures	18893.47	18905.35	18823.04	18836.96	13753.0
2021-11-26 02:00:00	NQ	Futures	18838.4	18839.85	18784.21	18794.06	21119.0
2021-11-26 03:00:00	NQ	Futures	18793.48	18812.9	18719.58	18798.12	26615.0
2021-11-26 04:00:00	NQ	Futures	18798.99	18802.18	18690.89	18730.88	20073.0
2021-11-26 05:00:00	NQ	Futures	18731.17	18772.62	18725.67	18752.91	11753.0
2021-11-26 06:00:00	NQ	Futures	18753.49	18808.26	18748.27	18773.2	14715.0
2021-11-26 07:00:00	NQ	Futures	18772.62	18845.94	18767.11	18777.83	17761.0
2021-11-26 08:00:00	NQ	Futures	18778.99	18807.1	18752.33	18770.88	17162.0
2021-11-26 09:00:00	NQ	Futures	18770.3	18904.77	18743.34	18814.64	96370.0
2021-11-26 10:00:00	NQ	Futures	18814.64	18824.78	18664.8	18688.28	111866.0
2021-11-26 11:00:00	NQ	Futures	18688.28	18688.86	18580.47	18637.85	88984.0
2021-11-26 12:00:00	NQ	Futures	18637.56	18707.41	18534.39	18593.22	92340.0
2021-11-26 13:00:00	NQ	Futures	18596.41	18628.0	18581.92	18598.73	10720.0
2021-11-26 00:00:00	YM	Futures	39577.0	39593.8	39542.3	39579.2	2851.0
2021-11-26 01:00:00	YM	Futures	39579.2	39592.7	39399.9	39436.9	7331.0
2021-11-26 02:00:00	YM	Futures	39441.4	39444.7	39222.8	39240.7	16570.0
2021-11-26 03:00:00	YM	Futures	39241.8	39309.1	39009.8	39273.2	26546.0
2021-11-26 04:00:00	YM	Futures	39275.5	39290.0	39090.5	39154.4	13162.0
2021-11-26 05:00:00	YM	Futures	39151.1	39271.0	39095.0	39169.0	6032.0
2021-11-26 06:00:00	YM	Futures	39164.5	39240.7	39129.8	39138.7	5561.0
2021-11-26 07:00:00	YM	Futures	39142.1	39245.2	39139.8	39198.1	6575.0
2021-11-26 08:00:00	YM	Futures	39201.5	39250.8	39128.6	39169.0	8908.0
2021-11-26 09:00:00	YM	Futures	39169.0	39340.5	39014.3	39080.4	42319.0
2021-11-26 10:00:00	YM	Futures	39081.6	39146.6	38941.4	39042.3	43190.0
2021-11-26 11:00:00	YM	Futures	39041.2	39053.5	38871.9	38960.5	27471.0
2021-11-26 12:00:00	YM	Futures	38961.6	39248.6	38954.9	39067.0	32857.0
2021-11-26 13:00:00	YM	Futures	39068.1	39108.5	38812.5	38817.0	6502.0
2021-11-26 00:00:00	CL	Futures	53.91	53.94	53.82	53.92	5254.0
2021-11-26 01:00:00	CL	Futures	53.92	53.92	53.55	53.67	9498.0
2021-11-26 02:00:00	CL	Futures	53.68	53.71	52.83	52.96	27591.0
2021-11-26 03:00:00	CL	Futures	52.96	52.97	51.98	52.4	38112.0
2021-11-26 04:00:00	CL	Futures	52.41	52.5	51.44	51.77	29684.0
2021-11-26 05:00:00	CL	Futures	51.76	52.24	51.74	51.88	19889.0
2021-11-26 06:00:00	CL	Futures	51.88	52.06	51.7	52.01	14217.0
2021-11-26 07:00:00	CL	Futures	52.01	52.6	51.85	52.21	26956.0

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

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