PREVIEW / futures_1hour / 2018-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-23.parquet
  size:    46 KB
  rows:    1,359

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-23 00:00:00	ES	Futures	2971.35	2974.63	2970.8	2972.99	4469.0
2018-02-23 01:00:00	ES	Futures	2972.99	2982.28	2972.17	2979.0	11931.0
2018-02-23 02:00:00	ES	Futures	2979.0	2982.01	2976.27	2977.64	10238.0
2018-02-23 03:00:00	ES	Futures	2977.36	2977.64	2968.62	2971.08	18503.0
2018-02-23 04:00:00	ES	Futures	2970.8	2975.72	2969.44	2973.26	11267.0
2018-02-23 05:00:00	ES	Futures	2973.26	2974.08	2966.16	2968.89	13426.0
2018-02-23 06:00:00	ES	Futures	2968.62	2974.63	2968.07	2974.36	11723.0
2018-02-23 07:00:00	ES	Futures	2974.36	2977.64	2973.26	2973.54	16268.0
2018-02-23 08:00:00	ES	Futures	2973.81	2977.91	2970.8	2971.9	28293.0
2018-02-23 09:00:00	ES	Futures	2971.9	2976.82	2967.52	2972.44	135383.0
2018-02-23 10:00:00	ES	Futures	2972.72	2976.27	2965.88	2973.54	162921.0
2018-02-23 11:00:00	ES	Futures	2973.54	2983.92	2972.72	2982.83	131353.0
2018-02-23 12:00:00	ES	Futures	2983.1	2984.47	2976.54	2980.1	82133.0
2018-02-23 13:00:00	ES	Futures	2979.82	2982.83	2975.45	2982.28	60245.0
2018-02-23 14:00:00	ES	Futures	2982.28	2991.85	2977.91	2990.48	109660.0
2018-02-23 15:00:00	ES	Futures	2990.48	3003.87	2990.21	3003.87	245526.0
2018-02-23 16:00:00	ES	Futures	3003.6	3006.88	3001.14	3002.24	105676.0
2018-02-23 00:00:00	NQ	Futures	8065.88	8075.67	8065.29	8072.11	2188.0
2018-02-23 01:00:00	NQ	Futures	8072.11	8100.29	8070.03	8089.9	4057.0
2018-02-23 02:00:00	NQ	Futures	8089.31	8099.1	8081.01	8086.64	3136.0
2018-02-23 03:00:00	NQ	Futures	8086.64	8087.24	8067.07	8074.78	4075.0
2018-02-23 04:00:00	NQ	Futures	8075.67	8088.13	8070.03	8081.3	2463.0
2018-02-23 05:00:00	NQ	Futures	8080.71	8082.19	8062.03	8072.11	2859.0
2018-02-23 06:00:00	NQ	Futures	8071.81	8088.72	8070.03	8087.83	3953.0
2018-02-23 07:00:00	NQ	Futures	8087.83	8095.84	8086.05	8088.72	6772.0
2018-02-23 08:00:00	NQ	Futures	8089.02	8106.22	8089.02	8090.79	12059.0
2018-02-23 09:00:00	NQ	Futures	8090.79	8097.91	8069.74	8083.38	54382.0
2018-02-23 10:00:00	NQ	Futures	8083.68	8091.09	8056.98	8087.83	51351.0
2018-02-23 11:00:00	NQ	Futures	8088.13	8117.19	8086.35	8114.52	45408.0
2018-02-23 12:00:00	NQ	Futures	8114.52	8120.75	8104.73	8116.01	30872.0
2018-02-23 13:00:00	NQ	Futures	8116.01	8125.79	8101.18	8124.31	25657.0
2018-02-23 14:00:00	NQ	Futures	8124.9	8163.16	8116.3	8158.12	37556.0
2018-02-23 15:00:00	NQ	Futures	8158.12	8188.37	8157.53	8187.78	51939.0
2018-02-23 16:00:00	NQ	Futures	8187.78	8202.31	8175.03	8188.97	13148.0
2018-02-23 00:00:00	YM	Futures	27261.1	27294.8	27257.9	27281.8	2992.0
2018-02-23 01:00:00	YM	Futures	27281.8	27391.6	27277.4	27361.1	5061.0
2018-02-23 02:00:00	YM	Futures	27358.9	27387.2	27341.6	27347.0	3564.0
2018-02-23 03:00:00	YM	Futures	27347.0	27347.0	27267.7	27292.6	4881.0
2018-02-23 04:00:00	YM	Futures	27291.6	27347.0	27265.5	27314.4	3803.0
2018-02-23 05:00:00	YM	Futures	27312.2	27323.1	27235.0	27262.2	3811.0
2018-02-23 06:00:00	YM	Futures	27260.0	27320.9	27257.9	27316.6	3623.0
2018-02-23 07:00:00	YM	Futures	27317.6	27338.3	27288.3	27289.4	5718.0
2018-02-23 08:00:00	YM	Futures	27289.4	27324.2	27254.6	27265.5	6638.0
2018-02-23 09:00:00	YM	Futures	27265.5	27331.8	27231.8	27269.8	24279.0
2018-02-23 10:00:00	YM	Futures	27268.7	27291.6	27176.4	27252.4	27568.0
2018-02-23 11:00:00	YM	Futures	27252.4	27326.3	27244.8	27312.2	22634.0
2018-02-23 12:00:00	YM	Futures	27312.2	27320.9	27243.7	27266.6	13225.0
2018-02-23 13:00:00	YM	Futures	27265.5	27298.1	27225.3	27286.1	10852.0
2018-02-23 14:00:00	YM	Futures	27286.1	27382.9	27243.7	27366.6	16206.0
2018-02-23 15:00:00	YM	Futures	27366.6	27494.8	27362.2	27493.7	25010.0

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

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