PREVIEW / futures_1hour / 2018-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-09.parquet
  size:    54 KB
  rows:    1,671

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-01-09 00:00:00	ES	Futures	3000.6	3001.14	3000.05	3000.6	2489.0
2018-01-09 01:00:00	ES	Futures	3000.6	3001.96	3000.6	3001.96	1362.0
2018-01-09 02:00:00	ES	Futures	3001.69	3002.51	3001.42	3002.51	3529.0
2018-01-09 03:00:00	ES	Futures	3002.24	3004.97	3002.24	3004.42	13345.0
2018-01-09 04:00:00	ES	Futures	3004.42	3005.51	3004.15	3004.42	9384.0
2018-01-09 05:00:00	ES	Futures	3004.69	3005.51	3004.15	3004.42	10730.0
2018-01-09 06:00:00	ES	Futures	3004.69	3004.69	3002.78	3004.15	10157.0
2018-01-09 07:00:00	ES	Futures	3003.87	3005.51	3003.87	3005.51	10765.0
2018-01-09 08:00:00	ES	Futures	3005.24	3009.07	3004.69	3008.25	25992.0
2018-01-09 09:00:00	ES	Futures	3008.52	3010.43	3004.42	3006.06	160193.0
2018-01-09 10:00:00	ES	Futures	3006.06	3010.71	3004.42	3007.7	156986.0
2018-01-09 11:00:00	ES	Futures	3007.7	3015.9	3007.43	3013.99	162115.0
2018-01-09 12:00:00	ES	Futures	3013.99	3015.63	3012.07	3014.26	66738.0
2018-01-09 13:00:00	ES	Futures	3014.26	3017.27	3014.26	3017.27	54317.0
2018-01-09 14:00:00	ES	Futures	3017.27	3017.54	3012.62	3014.26	78324.0
2018-01-09 15:00:00	ES	Futures	3014.26	3015.35	3007.7	3009.89	232003.0
2018-01-09 16:00:00	ES	Futures	3009.61	3010.16	3006.33	3006.88	79756.0
2018-01-09 18:00:00	ES	Futures	3006.33	3008.79	3005.79	3008.25	8033.0
2018-01-09 19:00:00	ES	Futures	3008.25	3008.79	3006.61	3006.61	5115.0
2018-01-09 20:00:00	ES	Futures	3006.88	3007.43	3005.24	3005.51	7432.0
2018-01-09 21:00:00	ES	Futures	3005.79	3007.7	3005.51	3006.61	4870.0
2018-01-09 22:00:00	ES	Futures	3006.88	3008.79	3006.33	3008.25	4624.0
2018-01-09 23:00:00	ES	Futures	3008.52	3008.79	3007.43	3007.7	3062.0
2018-01-09 00:00:00	NQ	Futures	7930.34	7931.82	7929.15	7930.63	623.0
2018-01-09 01:00:00	NQ	Futures	7930.63	7934.49	7929.45	7934.49	506.0
2018-01-09 02:00:00	NQ	Futures	7934.49	7936.86	7933.9	7936.27	1025.0
2018-01-09 03:00:00	NQ	Futures	7936.57	7941.31	7935.68	7939.83	2255.0
2018-01-09 04:00:00	NQ	Futures	7940.12	7945.76	7940.12	7943.09	1899.0
2018-01-09 05:00:00	NQ	Futures	7943.09	7947.54	7940.12	7943.39	1683.0
2018-01-09 06:00:00	NQ	Futures	7943.39	7944.57	7937.46	7941.01	1564.0
2018-01-09 07:00:00	NQ	Futures	7941.01	7946.65	7939.83	7946.06	2092.0
2018-01-09 08:00:00	NQ	Futures	7946.06	7955.55	7943.39	7952.58	6113.0
2018-01-09 09:00:00	NQ	Futures	7952.58	7955.55	7909.87	7917.58	68282.0
2018-01-09 10:00:00	NQ	Futures	7917.58	7935.68	7911.95	7928.56	51512.0
2018-01-09 11:00:00	NQ	Futures	7928.56	7950.21	7928.56	7941.31	35710.0
2018-01-09 12:00:00	NQ	Futures	7941.61	7949.32	7930.93	7947.84	19227.0
2018-01-09 13:00:00	NQ	Futures	7947.84	7957.33	7947.24	7949.91	15396.0
2018-01-09 14:00:00	NQ	Futures	7949.91	7951.1	7941.01	7946.65	15977.0
2018-01-09 15:00:00	NQ	Futures	7946.35	7949.02	7930.93	7935.97	31313.0
2018-01-09 16:00:00	NQ	Futures	7935.68	7936.86	7925.0	7925.89	7205.0
2018-01-09 18:00:00	NQ	Futures	7924.7	7933.01	7922.92	7930.04	1374.0
2018-01-09 19:00:00	NQ	Futures	7930.34	7932.12	7922.33	7923.52	1581.0
2018-01-09 20:00:00	NQ	Futures	7923.81	7930.93	7922.63	7924.11	1998.0
2018-01-09 21:00:00	NQ	Futures	7924.7	7929.74	7920.25	7922.63	1605.0
2018-01-09 22:00:00	NQ	Futures	7922.63	7931.52	7918.77	7928.26	2015.0
2018-01-09 23:00:00	NQ	Futures	7928.26	7931.23	7927.07	7928.85	742.0
2018-01-09 00:00:00	YM	Futures	27443.7	27454.6	27443.7	27448.1	694.0
2018-01-09 01:00:00	YM	Futures	27449.2	27463.3	27448.1	27462.2	808.0
2018-01-09 02:00:00	YM	Futures	27462.2	27468.7	27455.7	27461.1	778.0
2018-01-09 03:00:00	YM	Futures	27463.3	27487.2	27463.3	27482.9	1737.0

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

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