PREVIEW / futures_1hour / 2019-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-31.parquet
  size:    51 KB
  rows:    1,487

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
2019-05-31 00:00:00	ES	Futures	3007.61	3007.88	3003.27	3004.36	7319.0
2019-05-31 01:00:00	ES	Futures	3004.36	3005.44	3000.29	3001.37	14790.0
2019-05-31 02:00:00	ES	Futures	3001.37	3002.73	2998.12	2998.39	17606.0
2019-05-31 03:00:00	ES	Futures	2998.12	3000.29	2991.34	2994.6	50270.0
2019-05-31 04:00:00	ES	Futures	2994.6	2999.2	2993.24	2993.78	32743.0
2019-05-31 05:00:00	ES	Futures	2993.78	2996.22	2987.0	2988.63	54057.0
2019-05-31 06:00:00	ES	Futures	2988.63	2991.88	2986.19	2991.88	35623.0
2019-05-31 07:00:00	ES	Futures	2991.61	2995.14	2989.99	2992.16	40894.0
2019-05-31 08:00:00	ES	Futures	2992.16	2995.68	2989.44	2994.05	43710.0
2019-05-31 09:00:00	ES	Futures	2994.32	2995.14	2983.21	2989.99	259581.0
2019-05-31 10:00:00	ES	Futures	2989.99	2997.58	2985.92	2994.6	250220.0
2019-05-31 11:00:00	ES	Futures	2994.6	3003.27	2993.24	2998.93	191927.0
2019-05-31 12:00:00	ES	Futures	2999.2	2999.48	2989.17	2991.07	122335.0
2019-05-31 13:00:00	ES	Futures	2991.07	2998.39	2989.72	2996.76	120251.0
2019-05-31 14:00:00	ES	Futures	2996.49	2997.85	2984.29	2991.34	208874.0
2019-05-31 15:00:00	ES	Futures	2991.34	2991.88	2982.67	2984.29	378948.0
2019-05-31 16:00:00	ES	Futures	2984.29	2986.46	2982.13	2984.84	108629.0
2019-05-31 00:00:00	NQ	Futures	8397.52	8398.4	8385.29	8387.91	2621.0
2019-05-31 01:00:00	NQ	Futures	8388.79	8392.28	8373.94	8380.05	4816.0
2019-05-31 02:00:00	NQ	Futures	8379.76	8382.67	8364.33	8364.62	6448.0
2019-05-31 03:00:00	NQ	Futures	8365.2	8371.61	8326.19	8334.63	20240.0
2019-05-31 04:00:00	NQ	Futures	8334.05	8350.94	8333.76	8337.54	11530.0
2019-05-31 05:00:00	NQ	Futures	8337.84	8346.86	8308.72	8316.0	17975.0
2019-05-31 06:00:00	NQ	Futures	8316.0	8331.43	8309.59	8329.39	10860.0
2019-05-31 07:00:00	NQ	Futures	8329.1	8342.79	8326.19	8335.22	11245.0
2019-05-31 08:00:00	NQ	Futures	8334.92	8348.9	8324.44	8341.33	14163.0
2019-05-31 09:00:00	NQ	Futures	8341.62	8351.52	8307.85	8327.35	72388.0
2019-05-31 10:00:00	NQ	Futures	8327.94	8363.75	8320.37	8357.63	73805.0
2019-05-31 11:00:00	NQ	Futures	8357.63	8372.77	8347.74	8356.47	48177.0
2019-05-31 12:00:00	NQ	Futures	8356.76	8359.38	8326.48	8335.51	38248.0
2019-05-31 13:00:00	NQ	Futures	8335.22	8361.13	8331.43	8355.89	28685.0
2019-05-31 14:00:00	NQ	Futures	8355.89	8359.38	8317.16	8331.72	43102.0
2019-05-31 15:00:00	NQ	Futures	8331.43	8333.76	8304.35	8305.23	58894.0
2019-05-31 16:00:00	NQ	Futures	8305.52	8316.87	8302.9	8312.51	15755.0
2019-05-31 00:00:00	YM	Futures	27227.6	27228.7	27190.6	27198.2	2235.0
2019-05-31 01:00:00	YM	Futures	27199.3	27208.0	27162.3	27171.0	3749.0
2019-05-31 02:00:00	YM	Futures	27171.0	27180.8	27140.6	27142.7	3774.0
2019-05-31 03:00:00	YM	Futures	27142.7	27161.2	27096.0	27123.2	8738.0
2019-05-31 04:00:00	YM	Futures	27124.2	27168.8	27121.0	27126.4	7131.0
2019-05-31 05:00:00	YM	Futures	27128.6	27146.0	27072.0	27082.9	9379.0
2019-05-31 06:00:00	YM	Futures	27082.9	27103.6	27059.0	27101.4	6870.0
2019-05-31 07:00:00	YM	Futures	27102.5	27127.5	27086.2	27104.7	5587.0
2019-05-31 08:00:00	YM	Futures	27102.5	27136.2	27079.6	27119.9	6502.0
2019-05-31 09:00:00	YM	Futures	27121.0	27126.4	27026.4	27077.5	30852.0
2019-05-31 10:00:00	YM	Futures	27075.3	27125.3	27042.7	27092.7	31153.0
2019-05-31 11:00:00	YM	Futures	27092.7	27180.8	27078.6	27138.4	26228.0
2019-05-31 12:00:00	YM	Futures	27137.3	27144.9	27059.0	27073.1	16566.0
2019-05-31 13:00:00	YM	Futures	27073.1	27136.2	27070.9	27119.9	16111.0
2019-05-31 14:00:00	YM	Futures	27119.9	27131.9	27003.5	27069.9	26192.0
2019-05-31 15:00:00	YM	Futures	27068.8	27074.2	26988.3	26993.7	29861.0

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

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