PREVIEW / futures_1hour / 2017-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-25.parquet
  size:    43 KB
  rows:    1,298

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
2017-08-25 00:00:00	ES	Futures	2669.98	2670.25	2669.16	2669.43	2060.0
2017-08-25 01:00:00	ES	Futures	2669.43	2671.07	2669.16	2670.25	2738.0
2017-08-25 02:00:00	ES	Futures	2670.25	2671.07	2668.88	2669.7	5704.0
2017-08-25 03:00:00	ES	Futures	2669.98	2670.8	2665.06	2669.98	28746.0
2017-08-25 04:00:00	ES	Futures	2669.7	2670.8	2668.88	2669.16	12657.0
2017-08-25 05:00:00	ES	Futures	2668.88	2673.53	2667.52	2672.98	18854.0
2017-08-25 06:00:00	ES	Futures	2672.98	2675.72	2672.44	2675.44	21374.0
2017-08-25 07:00:00	ES	Futures	2675.72	2677.63	2674.35	2676.81	23200.0
2017-08-25 08:00:00	ES	Futures	2676.81	2676.81	2674.08	2675.99	21082.0
2017-08-25 09:00:00	ES	Futures	2675.72	2680.36	2673.8	2678.72	141355.0
2017-08-25 10:00:00	ES	Futures	2678.72	2682.55	2673.53	2674.35	199390.0
2017-08-25 11:00:00	ES	Futures	2674.35	2674.62	2668.88	2671.34	180887.0
2017-08-25 12:00:00	ES	Futures	2671.34	2674.35	2670.8	2673.53	60934.0
2017-08-25 13:00:00	ES	Futures	2673.8	2675.99	2673.26	2674.35	50413.0
2017-08-25 14:00:00	ES	Futures	2674.35	2676.26	2674.08	2675.72	43462.0
2017-08-25 15:00:00	ES	Futures	2675.72	2678.18	2669.43	2670.52	246710.0
2017-08-25 16:00:00	ES	Futures	2670.52	2671.89	2669.98	2670.25	81896.0
2017-08-25 00:00:00	NQ	Futures	6960.53	6962.91	6956.36	6956.36	539.0
2017-08-25 01:00:00	NQ	Futures	6956.66	6965.29	6956.66	6962.91	1131.0
2017-08-25 02:00:00	NQ	Futures	6962.62	6964.7	6958.15	6961.42	845.0
2017-08-25 03:00:00	NQ	Futures	6962.02	6963.81	6945.94	6961.13	3431.0
2017-08-25 04:00:00	NQ	Futures	6961.13	6964.4	6958.45	6959.64	1637.0
2017-08-25 05:00:00	NQ	Futures	6959.34	6972.74	6953.09	6972.14	3850.0
2017-08-25 06:00:00	NQ	Futures	6971.85	6982.56	6971.25	6978.69	7162.0
2017-08-25 07:00:00	NQ	Futures	6978.69	6988.52	6975.42	6985.24	8039.0
2017-08-25 08:00:00	NQ	Futures	6984.95	6985.84	6973.63	6979.88	8374.0
2017-08-25 09:00:00	NQ	Futures	6979.88	6988.52	6961.72	6980.48	42986.0
2017-08-25 10:00:00	NQ	Futures	6980.48	6995.96	6950.41	6950.71	58163.0
2017-08-25 11:00:00	NQ	Futures	6951.0	6952.19	6927.48	6941.77	59547.0
2017-08-25 12:00:00	NQ	Futures	6942.07	6947.73	6936.41	6942.96	25269.0
2017-08-25 13:00:00	NQ	Futures	6942.96	6953.68	6939.39	6942.96	15617.0
2017-08-25 14:00:00	NQ	Futures	6943.26	6953.09	6942.37	6951.9	10511.0
2017-08-25 15:00:00	NQ	Futures	6951.9	6960.23	6933.73	6936.41	36572.0
2017-08-25 16:00:00	NQ	Futures	6936.41	6941.18	6934.92	6937.9	6751.0
2017-08-25 00:00:00	YM	Futures	23721.3	23725.6	23716.9	23716.9	425.0
2017-08-25 01:00:00	YM	Futures	23716.9	23731.1	23716.9	23725.6	599.0
2017-08-25 02:00:00	YM	Futures	23724.6	23730.0	23714.8	23720.2	860.0
2017-08-25 03:00:00	YM	Futures	23721.3	23726.7	23682.1	23718.0	3388.0
2017-08-25 04:00:00	YM	Futures	23716.9	23726.7	23710.4	23711.5	1630.0
2017-08-25 05:00:00	YM	Futures	23710.4	23740.9	23699.5	23736.5	1894.0
2017-08-25 06:00:00	YM	Futures	23736.5	23761.6	23735.4	23759.4	2559.0
2017-08-25 07:00:00	YM	Futures	23759.4	23774.6	23751.8	23768.1	2201.0
2017-08-25 08:00:00	YM	Futures	23767.0	23768.1	23751.8	23762.6	2801.0
2017-08-25 09:00:00	YM	Futures	23761.6	23811.6	23752.9	23801.8	16190.0
2017-08-25 10:00:00	YM	Futures	23802.9	23830.1	23755.0	23763.7	24324.0
2017-08-25 11:00:00	YM	Futures	23763.7	23763.7	23728.9	23737.6	17990.0
2017-08-25 12:00:00	YM	Futures	23736.5	23762.6	23734.3	23759.4	6025.0
2017-08-25 13:00:00	YM	Futures	23760.5	23773.5	23756.1	23764.8	4376.0
2017-08-25 14:00:00	YM	Futures	23763.7	23782.2	23762.6	23772.4	5821.0
2017-08-25 15:00:00	YM	Futures	23772.4	23789.9	23728.9	23733.3	16360.0

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

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