PREVIEW / futures_1hour / 2018-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-26.parquet
  size:    50 KB
  rows:    1,440

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-10-26 00:00:00	ES	Futures	2893.79	2904.4	2891.34	2902.22	22993.0
2018-10-26 01:00:00	ES	Futures	2902.22	2907.66	2894.61	2898.96	24447.0
2018-10-26 02:00:00	ES	Futures	2898.96	2913.1	2898.96	2910.38	27086.0
2018-10-26 03:00:00	ES	Futures	2910.38	2912.28	2896.51	2901.4	49013.0
2018-10-26 04:00:00	ES	Futures	2901.13	2902.22	2892.43	2896.51	36745.0
2018-10-26 05:00:00	ES	Futures	2896.24	2896.24	2878.83	2885.9	76026.0
2018-10-26 06:00:00	ES	Futures	2885.9	2892.43	2883.45	2888.35	43160.0
2018-10-26 07:00:00	ES	Futures	2888.62	2897.6	2888.35	2891.07	45823.0
2018-10-26 08:00:00	ES	Futures	2890.8	2902.76	2885.36	2901.95	84679.0
2018-10-26 09:00:00	ES	Futures	2901.68	2907.39	2889.44	2897.05	335545.0
2018-10-26 10:00:00	ES	Futures	2896.78	2896.78	2858.43	2860.33	567853.0
2018-10-26 11:00:00	ES	Futures	2860.06	2901.4	2858.7	2891.34	388341.0
2018-10-26 12:00:00	ES	Futures	2891.34	2924.52	2890.53	2915.82	313629.0
2018-10-26 13:00:00	ES	Futures	2915.82	2929.69	2898.41	2913.1	276421.0
2018-10-26 14:00:00	ES	Futures	2913.1	2916.36	2878.56	2882.37	255029.0
2018-10-26 15:00:00	ES	Futures	2882.09	2907.93	2873.39	2891.07	596789.0
2018-10-26 16:00:00	ES	Futures	2891.07	2905.76	2888.08	2896.51	130071.0
2018-10-26 00:00:00	NQ	Futures	7998.68	8029.18	7983.13	8023.02	8371.0
2018-10-26 01:00:00	NQ	Futures	8022.44	8052.06	8003.96	8020.68	9202.0
2018-10-26 02:00:00	NQ	Futures	8020.97	8071.42	8020.97	8063.5	9004.0
2018-10-26 03:00:00	NQ	Futures	8063.5	8067.02	8015.1	8027.42	15248.0
2018-10-26 04:00:00	NQ	Futures	8027.13	8038.27	7994.57	8010.12	13914.0
2018-10-26 05:00:00	NQ	Futures	8010.12	8010.41	7901.0	7919.19	30192.0
2018-10-26 06:00:00	NQ	Futures	7918.9	7964.07	7903.06	7934.44	16080.0
2018-10-26 07:00:00	NQ	Futures	7934.73	7976.97	7934.73	7957.61	14859.0
2018-10-26 08:00:00	NQ	Futures	7957.91	7993.69	7929.45	7991.05	26855.0
2018-10-26 09:00:00	NQ	Futures	7991.05	8089.9	7945.88	8053.53	130155.0
2018-10-26 10:00:00	NQ	Futures	8053.82	8054.11	7920.07	7927.4	155519.0
2018-10-26 11:00:00	NQ	Futures	7928.28	8068.49	7921.54	8051.47	123570.0
2018-10-26 12:00:00	NQ	Futures	8051.47	8172.91	8048.54	8143.87	107890.0
2018-10-26 13:00:00	NQ	Futures	8143.57	8196.96	8069.07	8113.66	90305.0
2018-10-26 14:00:00	NQ	Futures	8113.66	8124.8	8000.73	8013.93	94355.0
2018-10-26 15:00:00	NQ	Futures	8013.64	8085.5	7985.18	8046.19	137240.0
2018-10-26 16:00:00	NQ	Futures	8046.78	8089.6	8032.7	8058.51	25905.0
2018-10-26 00:00:00	YM	Futures	26783.6	26865.1	26764.1	26833.6	5829.0
2018-10-26 01:00:00	YM	Futures	26834.7	26886.8	26766.2	26822.7	6410.0
2018-10-26 02:00:00	YM	Futures	26823.8	26931.4	26823.8	26902.0	4527.0
2018-10-26 03:00:00	YM	Futures	26903.1	26919.4	26794.5	26827.1	10257.0
2018-10-26 04:00:00	YM	Futures	26827.1	26843.4	26763.0	26806.4	7860.0
2018-10-26 05:00:00	YM	Futures	26805.3	26805.3	26695.6	26761.9	14018.0
2018-10-26 06:00:00	YM	Futures	26759.7	26811.9	26741.2	26765.1	4930.0
2018-10-26 07:00:00	YM	Futures	26767.3	26837.9	26761.9	26791.2	6653.0
2018-10-26 08:00:00	YM	Futures	26790.1	26880.3	26751.0	26865.1	10172.0
2018-10-26 09:00:00	YM	Futures	26865.1	26911.8	26777.1	26820.6	41792.0
2018-10-26 10:00:00	YM	Futures	26819.5	26821.6	26527.2	26544.6	70023.0
2018-10-26 11:00:00	YM	Futures	26543.5	26827.1	26528.3	26731.5	47882.0
2018-10-26 12:00:00	YM	Futures	26728.2	26992.2	26722.8	26931.4	34700.0
2018-10-26 13:00:00	YM	Futures	26930.3	27037.9	26810.8	26958.5	35200.0
2018-10-26 14:00:00	YM	Futures	26959.6	26991.1	26693.4	26727.1	32272.0
2018-10-26 15:00:00	YM	Futures	26726.0	26929.2	26634.8	26789.0	59284.0

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

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