PREVIEW / futures_1hour / 2018-02-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-16.parquet
  size:    47 KB
  rows:    1,384

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-16 00:00:00	ES	Futures	2991.03	2995.68	2989.12	2989.66	9297.0
2018-02-16 01:00:00	ES	Futures	2989.66	2994.04	2987.48	2992.4	5573.0
2018-02-16 02:00:00	ES	Futures	2992.4	2995.68	2990.48	2994.58	9655.0
2018-02-16 03:00:00	ES	Futures	2994.58	3001.96	2994.58	2998.96	28657.0
2018-02-16 04:00:00	ES	Futures	2998.96	3002.78	2998.41	3000.32	16074.0
2018-02-16 05:00:00	ES	Futures	3000.32	3003.06	2994.31	2995.4	23425.0
2018-02-16 06:00:00	ES	Futures	2995.4	2997.59	2991.58	2994.31	18571.0
2018-02-16 07:00:00	ES	Futures	2994.31	2997.32	2992.12	2995.68	20682.0
2018-02-16 08:00:00	ES	Futures	2995.68	2995.68	2985.56	2986.11	45442.0
2018-02-16 09:00:00	ES	Futures	2986.38	2991.03	2976.27	2983.38	256212.0
2018-02-16 10:00:00	ES	Futures	2983.38	2997.59	2980.1	2991.58	202773.0
2018-02-16 11:00:00	ES	Futures	2991.85	3004.97	2991.58	3003.33	148597.0
2018-02-16 12:00:00	ES	Futures	3003.6	3011.8	2997.04	3002.78	161234.0
2018-02-16 13:00:00	ES	Futures	3002.78	3005.79	2985.02	2993.22	209586.0
2018-02-16 14:00:00	ES	Futures	2993.22	2998.14	2980.37	2995.68	172970.0
2018-02-16 15:00:00	ES	Futures	2995.68	2999.78	2986.11	2987.48	232603.0
2018-02-16 16:00:00	ES	Futures	2987.48	2992.12	2986.11	2991.58	76001.0
2018-02-16 00:00:00	NQ	Futures	8098.21	8120.75	8096.13	8098.21	3422.0
2018-02-16 01:00:00	NQ	Futures	8097.32	8112.45	8092.57	8101.77	2449.0
2018-02-16 02:00:00	NQ	Futures	8102.07	8116.3	8095.24	8111.56	2410.0
2018-02-16 03:00:00	NQ	Futures	8111.56	8133.21	8110.37	8124.61	4682.0
2018-02-16 04:00:00	NQ	Futures	8124.31	8138.25	8122.53	8126.39	2474.0
2018-02-16 05:00:00	NQ	Futures	8126.09	8135.88	8108.0	8110.96	3551.0
2018-02-16 06:00:00	NQ	Futures	8111.56	8117.49	8099.4	8107.11	2682.0
2018-02-16 07:00:00	NQ	Futures	8106.81	8115.71	8102.07	8108.0	5156.0
2018-02-16 08:00:00	NQ	Futures	8108.0	8108.59	8067.96	8068.85	13471.0
2018-02-16 09:00:00	NQ	Futures	8069.14	8097.91	8041.56	8073.59	51441.0
2018-02-16 10:00:00	NQ	Futures	8074.19	8107.4	8052.53	8084.57	65744.0
2018-02-16 11:00:00	NQ	Futures	8084.86	8109.48	8079.82	8104.44	44619.0
2018-02-16 12:00:00	NQ	Futures	8104.44	8123.42	8081.6	8098.51	37888.0
2018-02-16 13:00:00	NQ	Futures	8098.21	8105.62	8037.11	8055.5	66425.0
2018-02-16 14:00:00	NQ	Futures	8055.8	8071.22	8022.28	8065.88	58614.0
2018-02-16 15:00:00	NQ	Futures	8065.88	8075.37	8036.52	8038.89	51116.0
2018-02-16 16:00:00	NQ	Futures	8039.48	8053.42	8037.7	8045.42	12276.0
2018-02-16 00:00:00	YM	Futures	27456.8	27516.5	27435.0	27448.1	3992.0
2018-02-16 01:00:00	YM	Futures	27447.0	27486.1	27417.6	27463.3	2408.0
2018-02-16 02:00:00	YM	Futures	27463.3	27497.0	27440.5	27486.1	2130.0
2018-02-16 03:00:00	YM	Futures	27485.0	27548.1	27479.6	27512.2	3758.0
2018-02-16 04:00:00	YM	Futures	27512.2	27545.9	27502.4	27516.5	2392.0
2018-02-16 05:00:00	YM	Futures	27516.5	27542.6	27454.6	27472.0	4132.0
2018-02-16 06:00:00	YM	Futures	27472.0	27493.7	27436.1	27456.8	3568.0
2018-02-16 07:00:00	YM	Futures	27456.8	27489.4	27437.2	27479.6	5509.0
2018-02-16 08:00:00	YM	Futures	27480.7	27481.8	27389.4	27394.8	9428.0
2018-02-16 09:00:00	YM	Futures	27394.8	27468.7	27294.8	27370.9	36835.0
2018-02-16 10:00:00	YM	Futures	27373.1	27498.1	27332.9	27454.6	34697.0
2018-02-16 11:00:00	YM	Futures	27454.6	27577.4	27453.5	27562.2	24799.0
2018-02-16 12:00:00	YM	Futures	27561.1	27632.8	27494.8	27533.9	22623.0
2018-02-16 13:00:00	YM	Futures	27532.8	27560.0	27347.0	27426.3	33904.0
2018-02-16 14:00:00	YM	Futures	27424.2	27478.5	27334.0	27467.6	27559.0
2018-02-16 15:00:00	YM	Futures	27467.6	27518.7	27391.6	27401.3	24480.0

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

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