PREVIEW / futures_1hour / 2018-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-30.parquet
  size:    56 KB
  rows:    1,710

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-30 00:00:00	ES	Futures	2890.25	2898.68	2887.81	2895.97	11470.0
2018-10-30 01:00:00	ES	Futures	2896.24	2898.41	2892.43	2892.97	7122.0
2018-10-30 02:00:00	ES	Futures	2892.7	2894.61	2886.99	2893.79	8886.0
2018-10-30 03:00:00	ES	Futures	2894.06	2896.24	2890.25	2890.8	15430.0
2018-10-30 04:00:00	ES	Futures	2890.8	2896.78	2887.26	2889.71	28124.0
2018-10-30 05:00:00	ES	Futures	2889.71	2889.71	2875.29	2886.72	35526.0
2018-10-30 06:00:00	ES	Futures	2886.45	2890.25	2882.37	2885.36	20800.0
2018-10-30 07:00:00	ES	Futures	2885.09	2889.98	2881.01	2888.89	21418.0
2018-10-30 08:00:00	ES	Futures	2889.17	2895.15	2879.37	2880.19	53544.0
2018-10-30 09:00:00	ES	Futures	2880.19	2910.65	2864.96	2906.84	377402.0
2018-10-30 10:00:00	ES	Futures	2907.12	2909.56	2879.37	2884.27	352408.0
2018-10-30 11:00:00	ES	Futures	2884.0	2909.02	2878.29	2894.88	269880.0
2018-10-30 12:00:00	ES	Futures	2894.88	2903.04	2884.54	2885.09	191822.0
2018-10-30 13:00:00	ES	Futures	2885.09	2893.79	2872.85	2891.89	223323.0
2018-10-30 14:00:00	ES	Futures	2891.89	2906.03	2878.83	2902.49	231965.0
2018-10-30 15:00:00	ES	Futures	2902.49	2922.89	2893.25	2919.36	385225.0
2018-10-30 16:00:00	ES	Futures	2919.08	2926.97	2917.18	2926.43	100709.0
2018-10-30 18:00:00	ES	Futures	2927.52	2928.6	2922.08	2922.89	10306.0
2018-10-30 19:00:00	ES	Futures	2922.89	2926.16	2922.08	2923.71	11753.0
2018-10-30 20:00:00	ES	Futures	2923.71	2924.25	2918.0	2922.62	18384.0
2018-10-30 21:00:00	ES	Futures	2922.35	2929.42	2921.26	2927.24	25301.0
2018-10-30 22:00:00	ES	Futures	2927.24	2927.24	2921.26	2921.8	14236.0
2018-10-30 23:00:00	ES	Futures	2922.08	2926.97	2921.26	2926.7	6613.0
2018-10-30 00:00:00	NQ	Futures	7934.73	7973.45	7926.23	7961.13	5567.0
2018-10-30 01:00:00	NQ	Futures	7960.55	7972.28	7948.23	7950.28	3640.0
2018-10-30 02:00:00	NQ	Futures	7951.16	7958.79	7934.15	7957.32	3968.0
2018-10-30 03:00:00	NQ	Futures	7957.91	7968.47	7949.4	7951.75	5429.0
2018-10-30 04:00:00	NQ	Futures	7952.33	7967.88	7938.84	7947.64	12869.0
2018-10-30 05:00:00	NQ	Futures	7947.93	7947.93	7881.94	7926.52	20353.0
2018-10-30 06:00:00	NQ	Futures	7926.23	7939.13	7910.98	7923.0	10813.0
2018-10-30 07:00:00	NQ	Futures	7922.42	7943.83	7901.0	7936.2	13843.0
2018-10-30 08:00:00	NQ	Futures	7936.79	7959.67	7886.34	7889.27	24799.0
2018-10-30 09:00:00	NQ	Futures	7890.15	7984.01	7815.06	7965.24	132331.0
2018-10-30 10:00:00	NQ	Futures	7964.36	7971.4	7854.95	7883.99	121079.0
2018-10-30 11:00:00	NQ	Futures	7884.28	7992.81	7867.27	7941.19	100570.0
2018-10-30 12:00:00	NQ	Futures	7942.07	7968.76	7899.83	7902.18	65866.0
2018-10-30 13:00:00	NQ	Futures	7902.76	7917.43	7834.13	7912.74	70713.0
2018-10-30 14:00:00	NQ	Futures	7912.44	7956.73	7862.29	7949.11	70547.0
2018-10-30 15:00:00	NQ	Futures	7948.52	8007.48	7920.95	7999.26	86532.0
2018-10-30 16:00:00	NQ	Futures	7998.97	8035.93	7928.87	8029.47	26273.0
2018-10-30 18:00:00	NQ	Futures	8045.02	8057.05	8013.34	8015.98	3755.0
2018-10-30 19:00:00	NQ	Futures	8014.81	8028.89	8011.88	8021.26	2475.0
2018-10-30 20:00:00	NQ	Futures	8020.68	8022.44	7997.8	8012.17	8714.0
2018-10-30 21:00:00	NQ	Futures	8012.17	8041.79	8008.36	8033.29	16676.0
2018-10-30 22:00:00	NQ	Futures	8032.99	8034.17	8007.77	8009.53	6510.0
2018-10-30 23:00:00	NQ	Futures	8009.24	8033.29	8005.42	8030.65	4203.0
2018-10-30 00:00:00	YM	Futures	26658.7	26734.7	26635.9	26703.2	2673.0
2018-10-30 01:00:00	YM	Futures	26702.1	26726.0	26671.7	26675.0	1859.0
2018-10-30 02:00:00	YM	Futures	26673.9	26700.0	26622.8	26696.7	2532.0
2018-10-30 03:00:00	YM	Futures	26697.8	26698.9	26642.4	26645.6	2943.0

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

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