PREVIEW / futures_1hour / 2018-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-21.parquet
  size:    56 KB
  rows:    1,696

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-21 00:00:00	ES	Futures	2961.24	2964.79	2960.42	2964.52	4434.0
2018-02-21 01:00:00	ES	Futures	2964.79	2969.44	2964.52	2968.34	6744.0
2018-02-21 02:00:00	ES	Futures	2968.34	2972.44	2966.7	2966.98	11450.0
2018-02-21 03:00:00	ES	Futures	2967.25	2969.71	2960.14	2962.88	17759.0
2018-02-21 04:00:00	ES	Futures	2962.6	2966.43	2959.05	2963.7	13262.0
2018-02-21 05:00:00	ES	Futures	2963.7	2965.61	2960.96	2963.7	9967.0
2018-02-21 06:00:00	ES	Futures	2963.7	2965.88	2960.69	2965.61	8464.0
2018-02-21 07:00:00	ES	Futures	2965.61	2967.52	2965.06	2966.98	14331.0
2018-02-21 08:00:00	ES	Futures	2966.98	2971.62	2965.61	2969.71	15250.0
2018-02-21 09:00:00	ES	Futures	2969.71	2986.38	2968.34	2981.74	149861.0
2018-02-21 10:00:00	ES	Futures	2981.74	2989.94	2978.18	2988.84	152726.0
2018-02-21 11:00:00	ES	Futures	2988.84	2992.67	2983.92	2986.66	95073.0
2018-02-21 12:00:00	ES	Futures	2986.66	2989.12	2980.92	2988.84	82875.0
2018-02-21 13:00:00	ES	Futures	2989.12	2990.76	2984.74	2988.57	46234.0
2018-02-21 14:00:00	ES	Futures	2988.84	3004.15	2983.38	2988.3	276835.0
2018-02-21 15:00:00	ES	Futures	2988.3	2988.57	2952.22	2952.22	494512.0
2018-02-21 16:00:00	ES	Futures	2951.94	2953.58	2944.84	2950.3	112161.0
2018-02-21 18:00:00	ES	Futures	2950.3	2951.4	2941.01	2942.38	20200.0
2018-02-21 19:00:00	ES	Futures	2942.38	2948.12	2941.56	2944.02	9645.0
2018-02-21 20:00:00	ES	Futures	2944.02	2945.38	2932.26	2937.73	24589.0
2018-02-21 21:00:00	ES	Futures	2937.46	2941.01	2934.72	2938.0	12411.0
2018-02-21 22:00:00	ES	Futures	2938.0	2939.64	2936.09	2936.91	6372.0
2018-02-21 23:00:00	ES	Futures	2936.91	2939.92	2936.09	2939.64	3547.0
2018-02-21 00:00:00	NQ	Futures	8048.09	8058.47	8041.86	8058.17	2417.0
2018-02-21 01:00:00	NQ	Futures	8057.87	8076.85	8055.5	8071.81	2464.0
2018-02-21 02:00:00	NQ	Futures	8072.11	8082.79	8065.58	8066.77	4145.0
2018-02-21 03:00:00	NQ	Futures	8067.07	8074.78	8047.79	8053.72	3840.0
2018-02-21 04:00:00	NQ	Futures	8053.72	8066.18	8044.53	8054.02	3539.0
2018-02-21 05:00:00	NQ	Futures	8053.42	8061.14	8045.12	8057.58	2388.0
2018-02-21 06:00:00	NQ	Futures	8057.87	8066.77	8048.09	8064.69	2473.0
2018-02-21 07:00:00	NQ	Futures	8065.29	8076.56	8063.8	8070.92	4372.0
2018-02-21 08:00:00	NQ	Futures	8070.63	8087.24	8065.88	8082.79	5920.0
2018-02-21 09:00:00	NQ	Futures	8082.79	8106.22	8074.78	8094.65	48003.0
2018-02-21 10:00:00	NQ	Futures	8094.65	8122.23	8083.08	8118.08	56491.0
2018-02-21 11:00:00	NQ	Futures	8118.08	8141.81	8106.22	8120.45	37423.0
2018-02-21 12:00:00	NQ	Futures	8120.16	8125.79	8100.58	8116.3	31217.0
2018-02-21 13:00:00	NQ	Futures	8116.3	8126.09	8110.07	8120.45	13505.0
2018-02-21 14:00:00	NQ	Futures	8120.45	8168.8	8109.18	8124.61	71320.0
2018-02-21 15:00:00	NQ	Futures	8124.9	8126.09	8022.87	8023.47	106145.0
2018-02-21 16:00:00	NQ	Futures	8022.87	8026.43	7997.66	8013.98	18080.0
2018-02-21 18:00:00	NQ	Futures	8015.76	8022.87	7968.89	7974.83	7160.0
2018-02-21 19:00:00	NQ	Futures	7975.42	7994.7	7972.45	7979.57	6839.0
2018-02-21 20:00:00	NQ	Futures	7980.17	7984.02	7942.5	7963.85	11877.0
2018-02-21 21:00:00	NQ	Futures	7963.56	7974.23	7960.29	7970.08	6623.0
2018-02-21 22:00:00	NQ	Futures	7970.38	7977.5	7965.04	7970.67	3627.0
2018-02-21 23:00:00	NQ	Futures	7970.67	7979.57	7968.6	7976.61	1686.0
2018-02-21 00:00:00	YM	Futures	27059.0	27091.6	27045.9	27089.4	2493.0
2018-02-21 01:00:00	YM	Futures	27089.4	27118.7	27077.4	27110.1	2199.0
2018-02-21 02:00:00	YM	Futures	27111.1	27143.7	27092.7	27094.8	2821.0
2018-02-21 03:00:00	YM	Futures	27097.0	27127.4	27037.2	27065.5	5113.0

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

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