PREVIEW / futures_1hour / 2019-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-05.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-05 00:00:00	ES	Futures	2953.48	2953.75	2951.58	2952.12	2777.0
2019-02-05 01:00:00	ES	Futures	2952.4	2954.03	2951.58	2952.94	2771.0
2019-02-05 02:00:00	ES	Futures	2952.94	2954.84	2952.67	2953.48	4769.0
2019-02-05 03:00:00	ES	Futures	2953.48	2956.74	2951.85	2955.65	17696.0
2019-02-05 04:00:00	ES	Futures	2955.93	2960.54	2955.65	2959.46	16955.0
2019-02-05 05:00:00	ES	Futures	2959.46	2962.17	2958.37	2960.27	13416.0
2019-02-05 06:00:00	ES	Futures	2960.27	2963.8	2960.27	2961.9	15420.0
2019-02-05 07:00:00	ES	Futures	2961.9	2963.8	2960.0	2961.63	17839.0
2019-02-05 08:00:00	ES	Futures	2961.9	2963.8	2961.09	2962.44	23358.0
2019-02-05 09:00:00	ES	Futures	2962.72	2968.15	2961.36	2967.06	190894.0
2019-02-05 10:00:00	ES	Futures	2967.06	2972.49	2963.8	2972.22	188484.0
2019-02-05 11:00:00	ES	Futures	2972.22	2973.31	2964.89	2968.69	136815.0
2019-02-05 12:00:00	ES	Futures	2968.96	2969.51	2958.1	2959.46	120660.0
2019-02-05 13:00:00	ES	Futures	2959.46	2963.8	2957.28	2963.26	90418.0
2019-02-05 14:00:00	ES	Futures	2963.26	2970.59	2962.99	2970.05	113086.0
2019-02-05 15:00:00	ES	Futures	2970.32	2974.12	2968.42	2971.14	155631.0
2019-02-05 16:00:00	ES	Futures	2971.14	2971.68	2965.98	2966.79	53347.0
2019-02-05 18:00:00	ES	Futures	2966.52	2968.42	2965.98	2967.33	4884.0
2019-02-05 19:00:00	ES	Futures	2967.33	2969.51	2965.98	2967.6	7232.0
2019-02-05 20:00:00	ES	Futures	2967.6	2970.59	2965.43	2970.32	9175.0
2019-02-05 21:00:00	ES	Futures	2970.05	2971.14	2968.69	2968.96	6077.0
2019-02-05 22:00:00	ES	Futures	2968.69	2970.05	2968.15	2968.96	3014.0
2019-02-05 23:00:00	ES	Futures	2968.96	2968.96	2966.52	2968.42	4074.0
2019-02-05 00:00:00	NQ	Futures	8108.55	8109.42	8100.36	8103.87	1356.0
2019-02-05 01:00:00	NQ	Futures	8104.16	8107.96	8101.83	8103.29	1168.0
2019-02-05 02:00:00	NQ	Futures	8103.58	8109.42	8101.24	8105.04	2138.0
2019-02-05 03:00:00	NQ	Futures	8105.33	8113.51	8100.07	8109.71	4502.0
2019-02-05 04:00:00	NQ	Futures	8110.01	8125.2	8109.42	8118.48	4725.0
2019-02-05 05:00:00	NQ	Futures	8118.48	8127.25	8116.14	8121.69	3225.0
2019-02-05 06:00:00	NQ	Futures	8122.28	8133.09	8122.28	8127.83	4602.0
2019-02-05 07:00:00	NQ	Futures	8128.12	8138.64	8123.74	8133.67	6899.0
2019-02-05 08:00:00	NQ	Futures	8133.67	8143.32	8128.12	8142.44	7964.0
2019-02-05 09:00:00	NQ	Futures	8142.44	8197.96	8139.52	8186.56	65394.0
2019-02-05 10:00:00	NQ	Futures	8186.85	8214.9	8175.75	8209.64	64352.0
2019-02-05 11:00:00	NQ	Futures	8209.64	8214.32	8183.64	8202.63	42114.0
2019-02-05 12:00:00	NQ	Futures	8202.63	8205.85	8160.85	8166.11	37183.0
2019-02-05 13:00:00	NQ	Futures	8166.11	8188.02	8159.97	8186.56	28029.0
2019-02-05 14:00:00	NQ	Futures	8186.56	8209.06	8185.98	8207.6	31101.0
2019-02-05 15:00:00	NQ	Futures	8207.6	8220.75	8203.8	8210.81	40775.0
2019-02-05 16:00:00	NQ	Futures	8210.52	8211.69	8188.02	8195.91	8775.0
2019-02-05 18:00:00	NQ	Futures	8192.11	8202.05	8192.11	8197.66	2058.0
2019-02-05 19:00:00	NQ	Futures	8197.08	8203.8	8194.74	8199.12	2486.0
2019-02-05 20:00:00	NQ	Futures	8199.42	8206.43	8189.77	8205.85	4209.0
2019-02-05 21:00:00	NQ	Futures	8206.14	8209.64	8201.75	8202.34	3243.0
2019-02-05 22:00:00	NQ	Futures	8202.34	8206.72	8199.42	8201.46	1636.0
2019-02-05 23:00:00	NQ	Futures	8201.17	8203.51	8195.33	8200.0	1713.0
2019-02-05 00:00:00	YM	Futures	27325.1	27327.2	27308.8	27314.2	788.0
2019-02-05 01:00:00	YM	Futures	27315.3	27329.4	27312.0	27316.4	731.0
2019-02-05 02:00:00	YM	Futures	27317.5	27342.4	27315.3	27329.4	1663.0
2019-02-05 03:00:00	YM	Futures	27331.6	27366.3	27318.6	27354.4	4106.0

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

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