PREVIEW / futures_1hour / 2018-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-20.parquet
  size:    55 KB
  rows:    1,681

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-20 00:00:00	ES	Futures	2986.38	2986.66	2982.28	2984.47	2819.0
2018-02-20 01:00:00	ES	Futures	2984.2	2985.56	2983.1	2984.2	2169.0
2018-02-20 02:00:00	ES	Futures	2984.2	2986.38	2978.18	2979.0	10002.0
2018-02-20 03:00:00	ES	Futures	2978.73	2982.83	2975.18	2979.0	14885.0
2018-02-20 04:00:00	ES	Futures	2979.0	2979.28	2965.61	2966.98	23617.0
2018-02-20 05:00:00	ES	Futures	2966.98	2971.62	2961.78	2971.62	24275.0
2018-02-20 06:00:00	ES	Futures	2971.62	2971.9	2964.79	2969.98	14884.0
2018-02-20 07:00:00	ES	Futures	2969.71	2973.54	2968.89	2972.99	16192.0
2018-02-20 08:00:00	ES	Futures	2972.99	2976.0	2969.16	2971.9	30884.0
2018-02-20 09:00:00	ES	Futures	2972.17	2987.2	2966.7	2977.64	173181.0
2018-02-20 10:00:00	ES	Futures	2977.91	2983.38	2971.35	2973.54	157430.0
2018-02-20 11:00:00	ES	Futures	2973.81	2991.85	2972.72	2991.03	125536.0
2018-02-20 12:00:00	ES	Futures	2991.3	2993.22	2987.48	2990.21	60565.0
2018-02-20 13:00:00	ES	Futures	2990.21	2991.03	2979.28	2986.11	93284.0
2018-02-20 14:00:00	ES	Futures	2985.84	2986.93	2971.35	2972.17	104974.0
2018-02-20 15:00:00	ES	Futures	2971.9	2975.45	2958.23	2968.62	267334.0
2018-02-20 16:00:00	ES	Futures	2968.62	2969.71	2965.06	2968.34	58473.0
2018-02-20 18:00:00	ES	Futures	2967.8	2973.26	2965.06	2972.72	7673.0
2018-02-20 19:00:00	ES	Futures	2972.72	2975.18	2970.53	2974.36	6124.0
2018-02-20 20:00:00	ES	Futures	2974.36	2974.63	2970.26	2972.44	8244.0
2018-02-20 21:00:00	ES	Futures	2972.72	2975.45	2972.17	2973.54	5864.0
2018-02-20 22:00:00	ES	Futures	2973.81	2975.18	2966.7	2967.25	6878.0
2018-02-20 23:00:00	ES	Futures	2967.25	2968.34	2958.78	2961.51	11723.0
2018-02-20 00:00:00	NQ	Futures	8050.46	8050.46	8039.19	8047.2	2071.0
2018-02-20 01:00:00	NQ	Futures	8047.2	8049.57	8041.86	8047.2	880.0
2018-02-20 02:00:00	NQ	Futures	8046.6	8052.53	8029.4	8031.18	2970.0
2018-02-20 03:00:00	NQ	Futures	8031.48	8043.34	8019.02	8027.03	4257.0
2018-02-20 04:00:00	NQ	Futures	8026.73	8027.62	7987.28	7990.55	6399.0
2018-02-20 05:00:00	NQ	Futures	7990.55	7996.77	7976.31	7996.18	6242.0
2018-02-20 06:00:00	NQ	Futures	7996.48	7997.37	7978.09	7993.51	4246.0
2018-02-20 07:00:00	NQ	Futures	7993.22	8003.6	7989.95	8000.04	4125.0
2018-02-20 08:00:00	NQ	Futures	7999.74	8011.9	7991.44	8003.3	9837.0
2018-02-20 09:00:00	NQ	Futures	8003.0	8064.69	7995.88	8045.12	58184.0
2018-02-20 10:00:00	NQ	Futures	8045.12	8080.71	8040.67	8059.36	61387.0
2018-02-20 11:00:00	NQ	Futures	8059.36	8113.63	8056.09	8111.56	44730.0
2018-02-20 12:00:00	NQ	Futures	8111.56	8119.27	8103.84	8114.52	26528.0
2018-02-20 13:00:00	NQ	Futures	8114.52	8118.38	8086.64	8113.93	30742.0
2018-02-20 14:00:00	NQ	Futures	8113.34	8116.3	8050.75	8055.8	35825.0
2018-02-20 15:00:00	NQ	Futures	8055.8	8064.69	8008.64	8048.68	72017.0
2018-02-20 16:00:00	NQ	Futures	8048.68	8063.21	8042.15	8057.87	10929.0
2018-02-20 18:00:00	NQ	Futures	8053.42	8071.22	8047.2	8070.63	2473.0
2018-02-20 19:00:00	NQ	Futures	8070.33	8077.15	8064.4	8072.11	2898.0
2018-02-20 20:00:00	NQ	Futures	8072.11	8074.78	8059.65	8069.14	5072.0
2018-02-20 21:00:00	NQ	Futures	8070.63	8085.16	8067.66	8080.71	3402.0
2018-02-20 22:00:00	NQ	Futures	8080.71	8085.16	8062.91	8064.99	3307.0
2018-02-20 23:00:00	NQ	Futures	8064.99	8067.96	8037.41	8048.09	6190.0
2018-02-20 00:00:00	YM	Futures	27372.0	27373.1	27336.1	27358.9	2174.0
2018-02-20 01:00:00	YM	Futures	27357.9	27375.3	27345.9	27361.1	982.0
2018-02-20 02:00:00	YM	Futures	27360.0	27383.9	27289.4	27298.1	3491.0
2018-02-20 03:00:00	YM	Futures	27297.0	27337.2	27251.3	27289.4	5667.0

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

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