PREVIEW / futures_1hour / 2018-02-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-15.parquet
  size:    56 KB
  rows:    1,690

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
2018-02-15 00:00:00	ES	Futures	2961.24	2961.51	2957.68	2959.6	3120.0
2018-02-15 01:00:00	ES	Futures	2959.87	2960.42	2957.96	2958.78	3595.0
2018-02-15 02:00:00	ES	Futures	2958.5	2964.79	2958.23	2962.88	19967.0
2018-02-15 03:00:00	ES	Futures	2963.15	2970.26	2960.42	2968.07	36281.0
2018-02-15 04:00:00	ES	Futures	2968.07	2973.26	2966.7	2971.62	17002.0
2018-02-15 05:00:00	ES	Futures	2971.9	2972.99	2968.34	2969.44	15429.0
2018-02-15 06:00:00	ES	Futures	2969.44	2969.44	2960.96	2963.7	25429.0
2018-02-15 07:00:00	ES	Futures	2963.42	2966.43	2957.41	2960.14	29919.0
2018-02-15 08:00:00	ES	Futures	2960.14	2967.25	2956.32	2965.06	46448.0
2018-02-15 09:00:00	ES	Futures	2965.34	2971.35	2959.87	2968.89	193023.0
2018-02-15 10:00:00	ES	Futures	2968.89	2969.98	2943.47	2944.02	245657.0
2018-02-15 11:00:00	ES	Futures	2944.29	2963.42	2939.37	2960.42	215915.0
2018-02-15 12:00:00	ES	Futures	2960.42	2966.98	2956.86	2966.7	115273.0
2018-02-15 13:00:00	ES	Futures	2966.7	2974.9	2965.34	2971.35	136735.0
2018-02-15 14:00:00	ES	Futures	2971.35	2979.55	2970.53	2976.82	120772.0
2018-02-15 15:00:00	ES	Futures	2976.54	2986.66	2973.26	2986.66	231020.0
2018-02-15 16:00:00	ES	Futures	2986.66	2992.12	2982.83	2989.66	97193.0
2018-02-15 18:00:00	ES	Futures	2989.12	2992.94	2988.57	2992.12	8145.0
2018-02-15 19:00:00	ES	Futures	2991.85	2992.4	2990.21	2991.85	4670.0
2018-02-15 20:00:00	ES	Futures	2991.58	2993.22	2989.12	2990.48	6939.0
2018-02-15 21:00:00	ES	Futures	2990.76	2991.58	2989.94	2990.48	2651.0
2018-02-15 22:00:00	ES	Futures	2990.48	2991.03	2989.94	2990.48	3641.0
2018-02-15 23:00:00	ES	Futures	2990.76	2991.03	2989.66	2991.03	2525.0
2018-02-15 00:00:00	NQ	Futures	7981.65	7982.54	7972.16	7978.68	2217.0
2018-02-15 01:00:00	NQ	Futures	7978.39	7978.98	7971.86	7973.05	1503.0
2018-02-15 02:00:00	NQ	Futures	7973.05	7995.59	7967.41	7982.83	4912.0
2018-02-15 03:00:00	NQ	Futures	7983.13	7994.99	7973.94	7987.58	4013.0
2018-02-15 04:00:00	NQ	Futures	7986.99	7996.18	7982.83	7990.55	2853.0
2018-02-15 05:00:00	NQ	Futures	7991.14	7995.59	7988.17	7990.55	3212.0
2018-02-15 06:00:00	NQ	Futures	7991.14	7991.44	7974.23	7981.94	4095.0
2018-02-15 07:00:00	NQ	Futures	7982.24	7992.03	7965.04	7974.83	7099.0
2018-02-15 08:00:00	NQ	Futures	7974.53	7986.99	7958.22	7978.98	14478.0
2018-02-15 09:00:00	NQ	Futures	7979.57	8013.38	7951.99	8010.71	62642.0
2018-02-15 10:00:00	NQ	Futures	8011.6	8012.79	7924.7	7927.07	86578.0
2018-02-15 11:00:00	NQ	Futures	7927.37	8001.52	7912.84	7994.7	71109.0
2018-02-15 12:00:00	NQ	Futures	7994.4	8020.8	7982.83	8019.61	34821.0
2018-02-15 13:00:00	NQ	Futures	8020.5	8048.09	8013.98	8030.29	41299.0
2018-02-15 14:00:00	NQ	Futures	8030.29	8055.2	8024.06	8045.42	30774.0
2018-02-15 15:00:00	NQ	Futures	8045.71	8070.03	8040.37	8069.74	46164.0
2018-02-15 16:00:00	NQ	Futures	8069.74	8099.99	8063.21	8091.98	13584.0
2018-02-15 18:00:00	NQ	Futures	8086.64	8100.88	8085.46	8095.24	1886.0
2018-02-15 19:00:00	NQ	Futures	8094.95	8102.07	8091.98	8100.58	2725.0
2018-02-15 20:00:00	NQ	Futures	8100.58	8107.4	8093.17	8098.21	4344.0
2018-02-15 21:00:00	NQ	Futures	8098.21	8101.47	8094.06	8097.32	1681.0
2018-02-15 22:00:00	NQ	Futures	8097.32	8099.1	8095.24	8097.02	1091.0
2018-02-15 23:00:00	NQ	Futures	8097.02	8098.8	8094.95	8098.8	1131.0
2018-02-15 00:00:00	YM	Futures	27136.1	27139.4	27107.9	27129.6	1476.0
2018-02-15 01:00:00	YM	Futures	27131.8	27138.3	27112.2	27129.6	1358.0
2018-02-15 02:00:00	YM	Futures	27129.6	27200.3	27127.4	27172.0	6110.0
2018-02-15 03:00:00	YM	Futures	27173.1	27253.5	27154.6	27243.7	7295.0

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

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