PREVIEW / futures_1hour / 2019-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-06.parquet
  size:    54 KB
  rows:    1,752

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
2019-02-06 00:00:00	ES	Futures	2968.42	2969.23	2967.33	2968.15	3535.0
2019-02-06 01:00:00	ES	Futures	2967.88	2969.51	2967.33	2968.15	2460.0
2019-02-06 02:00:00	ES	Futures	2968.15	2968.69	2961.9	2962.44	10708.0
2019-02-06 03:00:00	ES	Futures	2962.44	2964.07	2960.81	2961.63	15961.0
2019-02-06 04:00:00	ES	Futures	2961.63	2962.44	2959.73	2961.9	12689.0
2019-02-06 05:00:00	ES	Futures	2961.9	2962.99	2960.81	2962.72	9388.0
2019-02-06 06:00:00	ES	Futures	2962.72	2965.7	2962.44	2963.53	12335.0
2019-02-06 07:00:00	ES	Futures	2963.53	2966.52	2963.26	2964.07	12060.0
2019-02-06 08:00:00	ES	Futures	2964.07	2969.23	2964.07	2968.15	24002.0
2019-02-06 09:00:00	ES	Futures	2967.88	2972.76	2965.16	2967.06	186424.0
2019-02-06 10:00:00	ES	Futures	2966.79	2971.14	2957.28	2969.78	251378.0
2019-02-06 11:00:00	ES	Futures	2969.78	2971.68	2961.9	2965.43	149732.0
2019-02-06 12:00:00	ES	Futures	2965.7	2967.6	2962.17	2966.25	81053.0
2019-02-06 13:00:00	ES	Futures	2966.25	2969.78	2965.98	2966.52	72583.0
2019-02-06 14:00:00	ES	Futures	2966.52	2966.79	2960.54	2964.89	86238.0
2019-02-06 15:00:00	ES	Futures	2964.89	2967.88	2963.53	2966.79	134776.0
2019-02-06 16:00:00	ES	Futures	2966.79	2968.42	2962.99	2963.26	43133.0
2019-02-06 18:00:00	ES	Futures	2962.44	2964.89	2961.9	2964.07	4873.0
2019-02-06 19:00:00	ES	Futures	2964.35	2964.89	2960.81	2962.17	7456.0
2019-02-06 20:00:00	ES	Futures	2962.17	2962.17	2957.28	2960.0	9792.0
2019-02-06 21:00:00	ES	Futures	2960.0	2961.36	2958.91	2960.0	3994.0
2019-02-06 22:00:00	ES	Futures	2960.27	2960.81	2958.91	2959.46	2789.0
2019-02-06 23:00:00	ES	Futures	2959.46	2960.81	2958.1	2958.64	2413.0
2019-02-06 00:00:00	NQ	Futures	8200.29	8201.46	8195.33	8195.91	1376.0
2019-02-06 01:00:00	NQ	Futures	8195.91	8199.71	8193.57	8198.54	1262.0
2019-02-06 02:00:00	NQ	Futures	8197.96	8200.88	8183.05	8184.22	4462.0
2019-02-06 03:00:00	NQ	Futures	8184.81	8190.65	8181.89	8183.64	4565.0
2019-02-06 04:00:00	NQ	Futures	8183.64	8186.56	8171.07	8178.67	5265.0
2019-02-06 05:00:00	NQ	Futures	8178.38	8184.81	8175.46	8181.59	3629.0
2019-02-06 06:00:00	NQ	Futures	8181.3	8190.94	8181.01	8185.68	4583.0
2019-02-06 07:00:00	NQ	Futures	8185.39	8200.0	8184.22	8192.4	5656.0
2019-02-06 08:00:00	NQ	Futures	8192.4	8213.73	8192.4	8209.64	7860.0
2019-02-06 09:00:00	NQ	Futures	8209.64	8226.59	8194.16	8203.51	67008.0
2019-02-06 10:00:00	NQ	Futures	8203.22	8210.81	8148.87	8202.92	85066.0
2019-02-06 11:00:00	NQ	Futures	8202.92	8209.94	8177.5	8184.81	50716.0
2019-02-06 12:00:00	NQ	Futures	8184.81	8190.36	8169.61	8182.76	30102.0
2019-02-06 13:00:00	NQ	Futures	8182.47	8197.66	8179.26	8181.59	21806.0
2019-02-06 14:00:00	NQ	Futures	8181.3	8183.64	8162.6	8180.72	26131.0
2019-02-06 15:00:00	NQ	Futures	8180.72	8192.7	8177.21	8184.81	30217.0
2019-02-06 16:00:00	NQ	Futures	8184.81	8190.94	8167.57	8168.15	8009.0
2019-02-06 18:00:00	NQ	Futures	8167.28	8174.87	8165.52	8172.83	1720.0
2019-02-06 19:00:00	NQ	Futures	8173.12	8175.17	8159.68	8163.77	3984.0
2019-02-06 20:00:00	NQ	Futures	8164.35	8164.94	8150.62	8159.09	3955.0
2019-02-06 21:00:00	NQ	Futures	8159.09	8163.77	8155.88	8158.8	2070.0
2019-02-06 22:00:00	NQ	Futures	8158.22	8160.85	8155.88	8158.22	1416.0
2019-02-06 23:00:00	NQ	Futures	8158.22	8162.89	8155.0	8156.47	1277.0
2019-02-06 00:00:00	YM	Futures	27497.7	27505.3	27489.0	27493.4	962.0
2019-02-06 01:00:00	YM	Futures	27492.3	27508.6	27489.0	27501.0	878.0
2019-02-06 02:00:00	YM	Futures	27501.0	27505.3	27436.9	27444.5	3105.0
2019-02-06 03:00:00	YM	Futures	27444.5	27459.7	27433.6	27440.2	3320.0

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

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