PREVIEW / futures_1hour / 2018-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-07.parquet
  size:    54 KB
  rows:    1,660

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-03-07 00:00:00	ES	Futures	2947.84	2948.66	2938.55	2942.65	8719.0
2018-03-07 01:00:00	ES	Futures	2942.65	2946.48	2935.27	2944.84	11455.0
2018-03-07 02:00:00	ES	Futures	2945.11	2953.86	2941.83	2953.04	21501.0
2018-03-07 03:00:00	ES	Futures	2953.04	2956.86	2950.03	2951.12	22870.0
2018-03-07 04:00:00	ES	Futures	2951.12	2952.76	2945.93	2949.21	15814.0
2018-03-07 05:00:00	ES	Futures	2949.21	2956.86	2947.84	2949.76	17100.0
2018-03-07 06:00:00	ES	Futures	2950.03	2952.49	2945.38	2949.48	23269.0
2018-03-07 07:00:00	ES	Futures	2949.48	2959.32	2949.48	2957.41	28882.0
2018-03-07 08:00:00	ES	Futures	2957.41	2962.6	2953.86	2957.68	46993.0
2018-03-07 09:00:00	ES	Futures	2957.96	2970.26	2952.22	2962.06	212770.0
2018-03-07 10:00:00	ES	Futures	2962.06	2977.64	2961.24	2975.45	220775.0
2018-03-07 11:00:00	ES	Futures	2975.18	2976.27	2959.32	2959.87	139060.0
2018-03-07 12:00:00	ES	Futures	2959.6	2962.88	2952.76	2961.78	183670.0
2018-03-07 13:00:00	ES	Futures	2961.51	2968.07	2953.31	2965.06	129935.0
2018-03-07 14:00:00	ES	Futures	2965.06	2974.36	2962.33	2969.71	128895.0
2018-03-07 15:00:00	ES	Futures	2969.98	2985.02	2968.89	2980.37	217308.0
2018-03-07 16:00:00	ES	Futures	2980.64	2981.46	2975.18	2976.82	50310.0
2018-03-07 18:00:00	ES	Futures	2976.54	2977.36	2973.81	2976.27	6057.0
2018-03-07 19:00:00	ES	Futures	2976.27	2978.46	2973.81	2974.9	7209.0
2018-03-07 20:00:00	ES	Futures	2975.18	2980.64	2974.36	2979.0	7776.0
2018-03-07 21:00:00	ES	Futures	2979.0	2980.92	2977.09	2977.36	6457.0
2018-03-07 22:00:00	ES	Futures	2977.09	2981.74	2976.0	2979.28	5157.0
2018-03-07 23:00:00	ES	Futures	2979.55	2980.1	2977.36	2979.0	2732.0
2018-03-07 00:00:00	NQ	Futures	8115.71	8118.08	8093.76	8101.47	3303.0
2018-03-07 01:00:00	NQ	Futures	8101.77	8113.34	8084.57	8109.78	3878.0
2018-03-07 02:00:00	NQ	Futures	8109.78	8130.54	8100.88	8128.17	5259.0
2018-03-07 03:00:00	NQ	Futures	8127.28	8139.14	8116.89	8125.79	6373.0
2018-03-07 04:00:00	NQ	Futures	8125.5	8131.72	8109.48	8120.16	4649.0
2018-03-07 05:00:00	NQ	Futures	8119.86	8145.96	8116.6	8126.09	5867.0
2018-03-07 06:00:00	NQ	Futures	8125.79	8132.02	8115.41	8126.39	7973.0
2018-03-07 07:00:00	NQ	Futures	8126.39	8154.86	8125.79	8145.96	11159.0
2018-03-07 08:00:00	NQ	Futures	8145.96	8159.9	8139.14	8147.74	14273.0
2018-03-07 09:00:00	NQ	Futures	8147.74	8184.82	8132.32	8157.82	60221.0
2018-03-07 10:00:00	NQ	Futures	8158.12	8207.36	8149.82	8199.35	67391.0
2018-03-07 11:00:00	NQ	Futures	8199.05	8201.13	8148.63	8149.22	44405.0
2018-03-07 12:00:00	NQ	Futures	8149.22	8172.95	8126.98	8169.1	57107.0
2018-03-07 13:00:00	NQ	Futures	8168.5	8189.26	8144.18	8183.63	47226.0
2018-03-07 14:00:00	NQ	Futures	8183.93	8204.98	8173.25	8193.12	39963.0
2018-03-07 15:00:00	NQ	Futures	8193.42	8229.9	8189.86	8221.59	45809.0
2018-03-07 16:00:00	NQ	Futures	8221.59	8222.48	8210.32	8213.88	6834.0
2018-03-07 18:00:00	NQ	Futures	8212.99	8215.96	8202.02	8210.03	2296.0
2018-03-07 19:00:00	NQ	Futures	8210.32	8215.66	8202.91	8208.54	2521.0
2018-03-07 20:00:00	NQ	Futures	8208.54	8223.97	8206.47	8220.41	4933.0
2018-03-07 21:00:00	NQ	Futures	8219.81	8225.15	8212.99	8213.88	2637.0
2018-03-07 22:00:00	NQ	Futures	8213.88	8228.12	8210.62	8218.63	2784.0
2018-03-07 23:00:00	NQ	Futures	8219.81	8223.37	8211.51	8220.41	1642.0
2018-03-07 00:00:00	YM	Futures	26661.2	26671.0	26586.2	26626.4	3677.0
2018-03-07 01:00:00	YM	Futures	26626.4	26639.4	26542.7	26619.9	4229.0
2018-03-07 02:00:00	YM	Futures	26619.9	26691.6	26588.4	26682.9	7053.0
2018-03-07 03:00:00	YM	Futures	26681.8	26734.0	26649.2	26678.6	7824.0

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

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