PREVIEW / futures_1hour / 2018-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-07.parquet
  size:    59 KB
  rows:    1,729

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-07 00:00:00	ES	Futures	2928.44	2928.44	2914.77	2915.32	11341.0
2018-02-07 01:00:00	ES	Futures	2915.32	2924.06	2910.67	2922.15	14682.0
2018-02-07 02:00:00	ES	Futures	2922.15	2930.08	2916.41	2919.69	22165.0
2018-02-07 03:00:00	ES	Futures	2919.42	2923.79	2908.76	2920.78	37707.0
2018-02-07 04:00:00	ES	Futures	2920.78	2924.61	2913.95	2918.05	23628.0
2018-02-07 05:00:00	ES	Futures	2918.32	2924.06	2914.77	2914.77	20217.0
2018-02-07 06:00:00	ES	Futures	2914.77	2935.27	2913.68	2933.08	27773.0
2018-02-07 07:00:00	ES	Futures	2933.36	2938.0	2928.71	2933.36	33150.0
2018-02-07 08:00:00	ES	Futures	2933.36	2938.28	2926.25	2931.72	45984.0
2018-02-07 09:00:00	ES	Futures	2931.44	2959.05	2929.26	2955.77	303849.0
2018-02-07 10:00:00	ES	Futures	2955.77	2969.71	2951.12	2967.25	297399.0
2018-02-07 11:00:00	ES	Futures	2967.25	2981.19	2963.15	2972.72	255415.0
2018-02-07 12:00:00	ES	Futures	2972.72	2974.9	2955.77	2957.14	163793.0
2018-02-07 13:00:00	ES	Futures	2957.14	2962.6	2936.09	2951.67	336907.0
2018-02-07 14:00:00	ES	Futures	2951.67	2956.04	2932.54	2944.02	186308.0
2018-02-07 15:00:00	ES	Futures	2944.02	2962.88	2928.71	2928.98	368406.0
2018-02-07 16:00:00	ES	Futures	2928.98	2930.62	2911.49	2917.5	159457.0
2018-02-07 18:00:00	ES	Futures	2913.4	2917.5	2892.08	2894.27	37026.0
2018-02-07 19:00:00	ES	Futures	2894.27	2917.78	2894.0	2910.67	29559.0
2018-02-07 20:00:00	ES	Futures	2910.4	2916.68	2903.02	2911.22	18775.0
2018-02-07 21:00:00	ES	Futures	2911.22	2915.32	2901.1	2912.31	13976.0
2018-02-07 22:00:00	ES	Futures	2912.58	2914.5	2904.66	2906.3	6133.0
2018-02-07 23:00:00	ES	Futures	2906.3	2915.59	2906.3	2914.22	5966.0
2018-02-07 00:00:00	NQ	Futures	7847.88	7847.88	7807.25	7808.73	3927.0
2018-02-07 01:00:00	NQ	Futures	7810.22	7830.09	7788.57	7828.31	4376.0
2018-02-07 02:00:00	NQ	Futures	7828.31	7853.82	7819.41	7833.94	6021.0
2018-02-07 03:00:00	NQ	Futures	7832.46	7842.55	7798.65	7829.2	6791.0
2018-02-07 04:00:00	NQ	Futures	7830.09	7838.69	7810.22	7829.5	5634.0
2018-02-07 05:00:00	NQ	Futures	7829.79	7847.59	7809.03	7817.04	5305.0
2018-02-07 06:00:00	NQ	Futures	7816.15	7860.93	7815.26	7859.15	7712.0
2018-02-07 07:00:00	NQ	Futures	7859.15	7879.03	7855.3	7869.83	11321.0
2018-02-07 08:00:00	NQ	Futures	7869.83	7886.44	7857.08	7871.91	21741.0
2018-02-07 09:00:00	NQ	Futures	7871.61	7911.06	7857.97	7903.05	78239.0
2018-02-07 10:00:00	NQ	Futures	7902.75	7941.31	7889.41	7936.27	81032.0
2018-02-07 11:00:00	NQ	Futures	7936.57	7969.78	7919.36	7939.53	57382.0
2018-02-07 12:00:00	NQ	Futures	7939.83	7942.79	7865.98	7874.87	59957.0
2018-02-07 13:00:00	NQ	Futures	7874.87	7892.67	7809.92	7878.73	77143.0
2018-02-07 14:00:00	NQ	Futures	7879.03	7890.59	7809.03	7840.17	48732.0
2018-02-07 15:00:00	NQ	Futures	7841.06	7896.53	7805.77	7805.77	53095.0
2018-02-07 16:00:00	NQ	Futures	7805.47	7813.48	7749.41	7765.13	17588.0
2018-02-07 18:00:00	NQ	Futures	7761.28	7774.03	7699.88	7709.67	7047.0
2018-02-07 19:00:00	NQ	Futures	7710.56	7779.37	7710.26	7768.4	10091.0
2018-02-07 20:00:00	NQ	Futures	7768.69	7779.96	7745.86	7774.33	7352.0
2018-02-07 21:00:00	NQ	Futures	7773.14	7787.68	7744.67	7777.89	5563.0
2018-02-07 22:00:00	NQ	Futures	7777.0	7783.82	7752.38	7759.5	2872.0
2018-02-07 23:00:00	NQ	Futures	7760.09	7783.52	7758.31	7778.48	1516.0
2018-02-07 00:00:00	YM	Futures	26840.5	26841.6	26711.2	26715.5	2966.0
2018-02-07 01:00:00	YM	Futures	26713.3	26776.4	26661.2	26766.6	5119.0
2018-02-07 02:00:00	YM	Futures	26761.2	26843.8	26710.1	26734.0	5006.0
2018-02-07 03:00:00	YM	Futures	26730.7	26753.6	26631.8	26728.6	12071.0

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

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