PREVIEW / futures_1hour / 2018-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-30.parquet
  size:    47 KB
  rows:    1,390

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-11-30 00:00:00	ES	Futures	2983.28	2983.55	2980.01	2981.1	5016.0
2018-11-30 01:00:00	ES	Futures	2980.83	2983.28	2980.56	2981.37	2104.0
2018-11-30 02:00:00	ES	Futures	2981.37	2982.19	2979.47	2981.37	5536.0
2018-11-30 03:00:00	ES	Futures	2981.64	2981.92	2975.93	2976.2	16991.0
2018-11-30 04:00:00	ES	Futures	2976.48	2977.56	2974.03	2975.12	11637.0
2018-11-30 05:00:00	ES	Futures	2975.12	2976.48	2972.12	2972.67	13135.0
2018-11-30 06:00:00	ES	Futures	2972.67	2973.21	2969.4	2971.04	10283.0
2018-11-30 07:00:00	ES	Futures	2970.76	2973.21	2969.13	2972.4	12388.0
2018-11-30 08:00:00	ES	Futures	2972.4	2981.92	2969.68	2979.74	49372.0
2018-11-30 09:00:00	ES	Futures	2979.47	2982.46	2973.76	2981.92	136893.0
2018-11-30 10:00:00	ES	Futures	2981.92	2990.35	2979.2	2984.64	173302.0
2018-11-30 11:00:00	ES	Futures	2984.64	2987.08	2976.48	2985.45	143230.0
2018-11-30 12:00:00	ES	Futures	2985.18	2986.27	2980.01	2980.28	77379.0
2018-11-30 13:00:00	ES	Futures	2980.56	2994.16	2978.11	2992.52	119232.0
2018-11-30 14:00:00	ES	Futures	2992.8	2996.06	2990.08	2993.34	101301.0
2018-11-30 15:00:00	ES	Futures	2993.34	3004.49	2992.52	2999.05	368254.0
2018-11-30 16:00:00	ES	Futures	2998.78	3008.03	2995.79	3007.21	123350.0
2018-11-30 00:00:00	NQ	Futures	8108.96	8110.14	8100.16	8103.39	2389.0
2018-11-30 01:00:00	NQ	Futures	8102.8	8109.26	8101.04	8103.1	1152.0
2018-11-30 02:00:00	NQ	Futures	8102.8	8106.62	8098.11	8103.98	1907.0
2018-11-30 03:00:00	NQ	Futures	8104.27	8105.44	8082.27	8087.26	6464.0
2018-11-30 04:00:00	NQ	Futures	8087.26	8092.24	8079.92	8082.56	3859.0
2018-11-30 05:00:00	NQ	Futures	8082.56	8089.31	8073.77	8074.94	4463.0
2018-11-30 06:00:00	NQ	Futures	8074.65	8076.99	8065.26	8070.25	4202.0
2018-11-30 07:00:00	NQ	Futures	8069.95	8079.63	8062.03	8077.87	6690.0
2018-11-30 08:00:00	NQ	Futures	8077.28	8116.0	8066.43	8109.26	18041.0
2018-11-30 09:00:00	NQ	Futures	8109.55	8111.9	8063.21	8091.07	57557.0
2018-11-30 10:00:00	NQ	Futures	8090.48	8133.6	8074.35	8110.43	61937.0
2018-11-30 11:00:00	NQ	Futures	8110.14	8118.35	8087.26	8111.6	65030.0
2018-11-30 12:00:00	NQ	Futures	8111.9	8112.78	8086.08	8087.55	46753.0
2018-11-30 13:00:00	NQ	Futures	8087.26	8127.15	8076.7	8121.28	46043.0
2018-11-30 14:00:00	NQ	Futures	8121.28	8124.8	8105.15	8114.83	51116.0
2018-11-30 15:00:00	NQ	Futures	8114.83	8156.77	8113.95	8154.72	67228.0
2018-11-30 16:00:00	NQ	Futures	8154.72	8174.37	8145.63	8173.2	19793.0
2018-11-30 00:00:00	YM	Futures	27578.9	27583.3	27546.3	27559.4	2162.0
2018-11-30 01:00:00	YM	Futures	27560.5	27580.0	27554.0	27567.0	826.0
2018-11-30 02:00:00	YM	Futures	27565.9	27574.6	27549.6	27567.0	1346.0
2018-11-30 03:00:00	YM	Futures	27568.1	27571.3	27513.8	27521.4	4249.0
2018-11-30 04:00:00	YM	Futures	27520.3	27532.2	27497.5	27508.3	2202.0
2018-11-30 05:00:00	YM	Futures	27507.2	27517.0	27462.7	27471.4	3740.0
2018-11-30 06:00:00	YM	Futures	27471.4	27474.6	27423.6	27437.7	3374.0
2018-11-30 07:00:00	YM	Futures	27436.6	27449.6	27405.1	27444.2	4272.0
2018-11-30 08:00:00	YM	Futures	27444.2	27527.9	27421.4	27505.1	9259.0
2018-11-30 09:00:00	YM	Futures	27504.0	27539.8	27467.0	27525.7	19364.0
2018-11-30 10:00:00	YM	Futures	27526.8	27587.6	27504.0	27539.8	20816.0
2018-11-30 11:00:00	YM	Futures	27538.7	27547.4	27450.7	27526.8	18298.0
2018-11-30 12:00:00	YM	Futures	27526.8	27547.4	27492.0	27495.3	10998.0
2018-11-30 13:00:00	YM	Futures	27496.4	27628.9	27477.9	27614.8	14573.0
2018-11-30 14:00:00	YM	Futures	27615.9	27669.1	27601.8	27651.7	12641.0
2018-11-30 15:00:00	YM	Futures	27651.7	27778.9	27642.0	27737.6	25153.0

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

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