PREVIEW / futures_1hour / 2021-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-07.parquet
  size:    64 KB
  rows:    1,956

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-07-07 00:00:00	ES	Futures	4880.1	4881.23	4877.57	4878.13	3062.0
2021-07-07 01:00:00	ES	Futures	4877.85	4879.82	4876.44	4879.26	5531.0
2021-07-07 02:00:00	ES	Futures	4879.26	4882.07	4878.41	4881.51	7071.0
2021-07-07 03:00:00	ES	Futures	4881.51	4889.68	4881.23	4887.14	25990.0
2021-07-07 04:00:00	ES	Futures	4886.86	4891.36	4884.04	4885.73	16945.0
2021-07-07 05:00:00	ES	Futures	4886.01	4891.65	4885.17	4888.83	11027.0
2021-07-07 06:00:00	ES	Futures	4888.83	4891.08	4885.17	4890.8	12602.0
2021-07-07 07:00:00	ES	Futures	4890.52	4892.77	4889.11	4891.36	16654.0
2021-07-07 08:00:00	ES	Futures	4891.36	4894.46	4884.04	4886.01	28039.0
2021-07-07 09:00:00	ES	Futures	4885.73	4896.71	4885.45	4891.36	132249.0
2021-07-07 10:00:00	ES	Futures	4891.65	4892.49	4866.02	4878.98	243118.0
2021-07-07 11:00:00	ES	Futures	4879.26	4896.15	4874.75	4891.93	157697.0
2021-07-07 12:00:00	ES	Futures	4891.93	4899.53	4891.65	4894.74	87898.0
2021-07-07 13:00:00	ES	Futures	4895.03	4897.0	4889.96	4893.05	60294.0
2021-07-07 14:00:00	ES	Futures	4893.34	4903.19	4891.36	4899.53	152572.0
2021-07-07 15:00:00	ES	Futures	4899.81	4902.63	4895.31	4899.25	152425.0
2021-07-07 16:00:00	ES	Futures	4899.25	4902.06	4896.71	4901.5	33926.0
2021-07-07 18:00:00	ES	Futures	4902.06	4902.06	4900.09	4901.5	2633.0
2021-07-07 19:00:00	ES	Futures	4901.5	4901.78	4899.25	4900.09	2723.0
2021-07-07 20:00:00	ES	Futures	4900.09	4901.78	4895.87	4897.28	6365.0
2021-07-07 21:00:00	ES	Futures	4897.28	4897.28	4891.08	4891.08	8896.0
2021-07-07 22:00:00	ES	Futures	4891.36	4893.05	4886.01	4889.96	9504.0
2021-07-07 23:00:00	ES	Futures	4889.96	4891.08	4887.7	4889.68	5306.0
2021-07-07 00:00:00	NQ	Futures	17136.38	17140.44	17130.88	17135.52	1789.0
2021-07-07 01:00:00	NQ	Futures	17134.94	17136.96	17121.9	17129.14	3061.0
2021-07-07 02:00:00	NQ	Futures	17130.3	17134.94	17116.69	17128.27	2895.0
2021-07-07 03:00:00	NQ	Futures	17128.27	17198.09	17127.4	17196.06	14165.0
2021-07-07 04:00:00	NQ	Futures	17195.77	17218.07	17176.07	17188.24	11843.0
2021-07-07 05:00:00	NQ	Futures	17187.95	17205.91	17182.73	17192.87	5216.0
2021-07-07 06:00:00	NQ	Futures	17192.58	17214.31	17182.44	17202.43	5777.0
2021-07-07 07:00:00	NQ	Futures	17201.85	17227.05	17199.82	17216.92	7824.0
2021-07-07 08:00:00	NQ	Futures	17217.21	17232.56	17206.49	17221.26	10427.0
2021-07-07 09:00:00	NQ	Futures	17220.97	17246.17	17169.41	17190.55	74618.0
2021-07-07 10:00:00	NQ	Futures	17190.84	17202.72	17063.67	17121.03	100937.0
2021-07-07 11:00:00	NQ	Futures	17121.03	17182.73	17077.58	17164.48	66880.0
2021-07-07 12:00:00	NQ	Futures	17164.77	17180.71	17131.46	17148.84	32141.0
2021-07-07 13:00:00	NQ	Futures	17148.84	17154.92	17115.24	17140.73	26439.0
2021-07-07 14:00:00	NQ	Futures	17141.89	17181.29	17130.3	17166.51	43148.0
2021-07-07 15:00:00	NQ	Futures	17166.51	17174.91	17139.28	17151.74	37563.0
2021-07-07 16:00:00	NQ	Futures	17151.74	17162.75	17142.18	17161.01	6818.0
2021-07-07 18:00:00	NQ	Futures	17163.04	17164.77	17154.06	17162.46	1510.0
2021-07-07 19:00:00	NQ	Futures	17162.46	17166.22	17156.08	17161.3	1327.0
2021-07-07 20:00:00	NQ	Futures	17161.88	17174.62	17152.03	17157.53	2976.0
2021-07-07 21:00:00	NQ	Futures	17157.82	17163.32	17134.65	17136.67	3957.0
2021-07-07 22:00:00	NQ	Futures	17136.96	17141.6	17116.98	17131.75	4143.0
2021-07-07 23:00:00	NQ	Futures	17131.75	17136.38	17125.38	17133.49	2741.0
2021-07-07 00:00:00	YM	Futures	38475.9	38487.1	38448.0	38451.3	737.0
2021-07-07 01:00:00	YM	Futures	38451.3	38479.3	38443.5	38473.7	1156.0
2021-07-07 02:00:00	YM	Futures	38473.7	38497.2	38465.9	38497.2	1763.0
2021-07-07 03:00:00	YM	Futures	38496.0	38559.7	38492.7	38507.2	4782.0

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

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