PREVIEW / futures_1hour / 2018-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-02.parquet
  size:    50 KB
  rows:    1,444

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-11-02 00:00:00	ES	Futures	2971.31	2991.71	2969.95	2989.53	21541.0
2018-11-02 01:00:00	ES	Futures	2989.8	2999.05	2988.72	2997.96	26816.0
2018-11-02 02:00:00	ES	Futures	2997.69	3007.21	2996.33	3001.23	24869.0
2018-11-02 03:00:00	ES	Futures	3001.23	3007.48	2998.78	3005.04	27613.0
2018-11-02 04:00:00	ES	Futures	3004.76	3007.48	3000.68	3002.04	37635.0
2018-11-02 05:00:00	ES	Futures	3002.04	3003.13	2996.88	2997.42	25877.0
2018-11-02 06:00:00	ES	Futures	2997.15	3002.86	2996.06	3001.5	21031.0
2018-11-02 07:00:00	ES	Futures	3001.5	3009.66	2999.87	3006.12	38709.0
2018-11-02 08:00:00	ES	Futures	3006.4	3008.03	2993.07	2998.24	100613.0
2018-11-02 09:00:00	ES	Futures	2997.96	2999.87	2986.0	2989.8	263672.0
2018-11-02 10:00:00	ES	Futures	2989.8	2990.89	2961.24	2972.94	364813.0
2018-11-02 11:00:00	ES	Futures	2972.94	2973.76	2954.17	2962.88	273974.0
2018-11-02 12:00:00	ES	Futures	2962.6	2964.51	2938.94	2943.84	229148.0
2018-11-02 13:00:00	ES	Futures	2943.84	2956.62	2937.04	2951.45	178855.0
2018-11-02 14:00:00	ES	Futures	2951.72	2968.04	2941.93	2958.52	237178.0
2018-11-02 15:00:00	ES	Futures	2958.52	2964.78	2950.36	2961.24	282874.0
2018-11-02 16:00:00	ES	Futures	2961.24	2964.51	2960.7	2962.06	75573.0
2018-11-02 00:00:00	NQ	Futures	8228.93	8297.27	8222.48	8293.46	9412.0
2018-11-02 01:00:00	NQ	Futures	8293.46	8333.05	8290.82	8328.95	12650.0
2018-11-02 02:00:00	NQ	Futures	8328.36	8380.87	8325.43	8344.49	14747.0
2018-11-02 03:00:00	NQ	Futures	8345.67	8364.15	8331.3	8344.2	11653.0
2018-11-02 04:00:00	NQ	Futures	8343.91	8361.51	8325.43	8332.76	12790.0
2018-11-02 05:00:00	NQ	Futures	8333.05	8333.05	8306.95	8314.28	12643.0
2018-11-02 06:00:00	NQ	Futures	8313.7	8325.72	8307.83	8318.98	9499.0
2018-11-02 07:00:00	NQ	Futures	8319.27	8337.45	8309.59	8326.31	21025.0
2018-11-02 08:00:00	NQ	Futures	8326.6	8334.81	8278.79	8293.46	33416.0
2018-11-02 09:00:00	NQ	Futures	8293.16	8321.32	8241.83	8260.9	99065.0
2018-11-02 10:00:00	NQ	Futures	8261.78	8267.06	8157.36	8209.86	120402.0
2018-11-02 11:00:00	NQ	Futures	8209.86	8212.5	8150.61	8195.2	85721.0
2018-11-02 12:00:00	NQ	Futures	8195.2	8199.01	8114.24	8131.84	72618.0
2018-11-02 13:00:00	NQ	Futures	8132.13	8176.43	8108.67	8157.65	70695.0
2018-11-02 14:00:00	NQ	Futures	8157.95	8194.61	8114.83	8175.55	73147.0
2018-11-02 15:00:00	NQ	Futures	8175.84	8196.08	8147.09	8172.32	68661.0
2018-11-02 16:00:00	NQ	Futures	8172.61	8191.68	8167.63	8184.34	13765.0
2018-11-02 00:00:00	YM	Futures	27464.9	27649.6	27451.8	27635.4	5587.0
2018-11-02 01:00:00	YM	Futures	27636.5	27716.9	27624.6	27713.7	6653.0
2018-11-02 02:00:00	YM	Futures	27712.6	27779.9	27699.5	27740.8	6469.0
2018-11-02 03:00:00	YM	Futures	27740.8	27798.4	27722.4	27782.1	5784.0
2018-11-02 04:00:00	YM	Futures	27782.1	27800.6	27741.9	27757.1	7050.0
2018-11-02 05:00:00	YM	Futures	27756.0	27772.3	27728.9	27737.6	5053.0
2018-11-02 06:00:00	YM	Futures	27735.4	27800.6	27721.3	27784.3	4345.0
2018-11-02 07:00:00	YM	Futures	27784.3	27906.0	27772.3	27884.3	10350.0
2018-11-02 08:00:00	YM	Futures	27884.3	27900.6	27689.8	27769.1	16157.0
2018-11-02 09:00:00	YM	Futures	27768.0	27786.5	27631.1	27676.7	33877.0
2018-11-02 10:00:00	YM	Futures	27675.6	27683.2	27406.2	27498.5	38174.0
2018-11-02 11:00:00	YM	Futures	27499.6	27513.8	27348.6	27433.4	32692.0
2018-11-02 12:00:00	YM	Futures	27433.4	27449.6	27235.6	27268.2	28112.0
2018-11-02 13:00:00	YM	Futures	27267.1	27357.3	27205.2	27299.7	25996.0
2018-11-02 14:00:00	YM	Futures	27300.8	27454.0	27200.8	27375.8	32061.0
2018-11-02 15:00:00	YM	Futures	27376.9	27432.3	27295.4	27405.1	27643.0

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

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