PREVIEW / futures_1hour / 2018-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-15.parquet
  size:    56 KB
  rows:    1,692

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-05-15 00:00:00	ES	Futures	2977.43	2978.25	2976.34	2976.61	2168.0
2018-05-15 01:00:00	ES	Futures	2976.88	2977.15	2972.51	2973.61	5462.0
2018-05-15 02:00:00	ES	Futures	2973.61	2973.61	2969.79	2972.79	11763.0
2018-05-15 03:00:00	ES	Futures	2972.79	2976.61	2972.24	2976.06	10799.0
2018-05-15 04:00:00	ES	Futures	2976.34	2976.88	2972.51	2974.15	10889.0
2018-05-15 05:00:00	ES	Futures	2973.88	2978.52	2973.61	2977.7	8864.0
2018-05-15 06:00:00	ES	Futures	2977.43	2978.79	2976.61	2976.88	8563.0
2018-05-15 07:00:00	ES	Futures	2976.88	2977.97	2971.7	2973.61	24073.0
2018-05-15 08:00:00	ES	Futures	2973.33	2974.97	2960.78	2963.78	72437.0
2018-05-15 09:00:00	ES	Futures	2963.78	2966.24	2950.95	2951.77	251638.0
2018-05-15 10:00:00	ES	Futures	2951.5	2964.33	2950.95	2957.78	213729.0
2018-05-15 11:00:00	ES	Futures	2957.78	2962.14	2953.96	2954.78	112491.0
2018-05-15 12:00:00	ES	Futures	2954.78	2962.96	2950.68	2958.6	136863.0
2018-05-15 13:00:00	ES	Futures	2958.32	2959.14	2948.5	2949.04	108524.0
2018-05-15 14:00:00	ES	Futures	2948.77	2960.51	2948.5	2953.14	168620.0
2018-05-15 15:00:00	ES	Futures	2953.14	2959.69	2947.95	2959.14	244528.0
2018-05-15 16:00:00	ES	Futures	2958.87	2960.78	2956.41	2958.32	68139.0
2018-05-15 18:00:00	ES	Futures	2959.69	2959.69	2953.96	2954.78	6201.0
2018-05-15 19:00:00	ES	Futures	2954.78	2955.05	2952.32	2954.78	3714.0
2018-05-15 20:00:00	ES	Futures	2954.78	2958.05	2954.5	2956.69	4706.0
2018-05-15 21:00:00	ES	Futures	2956.69	2959.41	2956.14	2956.96	5209.0
2018-05-15 22:00:00	ES	Futures	2957.23	2958.32	2955.32	2955.87	3304.0
2018-05-15 23:00:00	ES	Futures	2956.14	2959.69	2955.87	2959.69	3793.0
2018-05-15 00:00:00	NQ	Futures	8232.05	8236.78	8231.46	8234.41	900.0
2018-05-15 01:00:00	NQ	Futures	8234.12	8234.41	8219.64	8223.18	1512.0
2018-05-15 02:00:00	NQ	Futures	8222.89	8223.18	8211.07	8218.75	2839.0
2018-05-15 03:00:00	NQ	Futures	8218.45	8228.21	8217.27	8224.96	3172.0
2018-05-15 04:00:00	NQ	Futures	8225.84	8227.32	8216.38	8222.0	2974.0
2018-05-15 05:00:00	NQ	Futures	8222.0	8232.93	8220.23	8229.68	2089.0
2018-05-15 06:00:00	NQ	Futures	8229.39	8234.71	8226.14	8226.73	1818.0
2018-05-15 07:00:00	NQ	Futures	8226.73	8230.57	8205.75	8210.47	6648.0
2018-05-15 08:00:00	NQ	Futures	8210.18	8217.86	8161.42	8169.39	22741.0
2018-05-15 09:00:00	NQ	Futures	8169.69	8177.08	8109.99	8113.24	86208.0
2018-05-15 10:00:00	NQ	Futures	8113.24	8166.44	8109.4	8130.98	71437.0
2018-05-15 11:00:00	NQ	Futures	8130.98	8146.05	8116.79	8125.66	47099.0
2018-05-15 12:00:00	NQ	Futures	8125.36	8149.0	8111.47	8135.11	39115.0
2018-05-15 13:00:00	NQ	Futures	8134.82	8139.55	8104.38	8107.04	34288.0
2018-05-15 14:00:00	NQ	Futures	8106.74	8145.75	8102.6	8126.54	38637.0
2018-05-15 15:00:00	NQ	Futures	8126.25	8150.19	8110.29	8147.23	42527.0
2018-05-15 16:00:00	NQ	Futures	8146.93	8153.14	8143.39	8146.64	7588.0
2018-05-15 18:00:00	NQ	Futures	8151.37	8151.37	8133.93	8135.7	1515.0
2018-05-15 19:00:00	NQ	Futures	8136.0	8137.18	8127.72	8136.3	1413.0
2018-05-15 20:00:00	NQ	Futures	8136.59	8147.23	8136.3	8142.21	1736.0
2018-05-15 21:00:00	NQ	Futures	8142.21	8149.59	8138.07	8141.32	4124.0
2018-05-15 22:00:00	NQ	Futures	8141.02	8145.16	8135.41	8138.66	1899.0
2018-05-15 23:00:00	NQ	Futures	8140.14	8152.25	8137.77	8150.19	1670.0
2018-05-15 00:00:00	YM	Futures	26992.0	27001.8	26987.7	26992.0	565.0
2018-05-15 01:00:00	YM	Futures	26990.9	26995.3	26946.4	26958.4	1481.0
2018-05-15 02:00:00	YM	Futures	26957.3	26957.3	26921.4	26942.1	2594.0
2018-05-15 03:00:00	YM	Futures	26942.1	26973.6	26938.8	26964.9	2354.0

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

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