PREVIEW / futures_1hour / 2018-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-16.parquet
  size:    49 KB
  rows:    1,428

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-16 00:00:00	ES	Futures	2970.49	2971.85	2965.05	2967.5	5890.0
2018-11-16 01:00:00	ES	Futures	2967.23	2968.04	2964.24	2967.77	3336.0
2018-11-16 02:00:00	ES	Futures	2967.77	2968.32	2963.15	2967.5	9888.0
2018-11-16 03:00:00	ES	Futures	2967.5	2972.4	2965.32	2966.14	23947.0
2018-11-16 04:00:00	ES	Futures	2966.14	2967.77	2962.33	2966.14	14072.0
2018-11-16 05:00:00	ES	Futures	2966.41	2966.68	2959.61	2960.97	14765.0
2018-11-16 06:00:00	ES	Futures	2960.97	2961.79	2955.8	2960.43	16538.0
2018-11-16 07:00:00	ES	Futures	2960.43	2962.06	2951.45	2956.89	30603.0
2018-11-16 08:00:00	ES	Futures	2956.89	2961.24	2947.1	2961.24	67597.0
2018-11-16 09:00:00	ES	Futures	2961.24	2969.4	2952.0	2968.04	269536.0
2018-11-16 10:00:00	ES	Futures	2968.04	2981.64	2963.42	2974.03	250689.0
2018-11-16 11:00:00	ES	Futures	2974.3	2976.2	2961.24	2964.51	174192.0
2018-11-16 12:00:00	ES	Futures	2964.51	2990.62	2960.7	2981.1	259714.0
2018-11-16 13:00:00	ES	Futures	2981.1	2982.73	2964.24	2970.22	169007.0
2018-11-16 14:00:00	ES	Futures	2970.22	2981.64	2968.04	2980.56	132495.0
2018-11-16 15:00:00	ES	Futures	2980.28	2986.54	2975.93	2978.92	238661.0
2018-11-16 16:00:00	ES	Futures	2978.65	2986.54	2978.38	2983.55	74290.0
2018-11-16 00:00:00	NQ	Futures	8071.13	8075.53	8047.66	8056.46	4050.0
2018-11-16 01:00:00	NQ	Futures	8056.75	8057.93	8043.26	8057.34	2779.0
2018-11-16 02:00:00	NQ	Futures	8057.63	8057.93	8040.33	8049.42	5670.0
2018-11-16 03:00:00	NQ	Futures	8050.01	8070.83	8044.43	8047.37	10264.0
2018-11-16 04:00:00	NQ	Futures	8047.07	8051.18	8028.3	8045.02	7379.0
2018-11-16 05:00:00	NQ	Futures	8045.02	8046.19	8016.86	8024.2	6775.0
2018-11-16 06:00:00	NQ	Futures	8024.2	8025.95	8002.2	8020.09	8951.0
2018-11-16 07:00:00	NQ	Futures	8020.38	8034.17	8002.78	8026.54	12002.0
2018-11-16 08:00:00	NQ	Futures	8026.83	8031.23	7985.48	8030.35	25698.0
2018-11-16 09:00:00	NQ	Futures	8030.35	8066.73	7986.94	8057.93	101231.0
2018-11-16 10:00:00	NQ	Futures	8057.63	8098.4	8036.22	8064.97	107966.0
2018-11-16 11:00:00	NQ	Futures	8065.26	8071.42	8006.01	8019.21	72981.0
2018-11-16 12:00:00	NQ	Futures	8019.21	8113.07	8002.2	8073.77	87420.0
2018-11-16 13:00:00	NQ	Futures	8073.47	8080.22	8020.09	8037.1	61779.0
2018-11-16 14:00:00	NQ	Futures	8037.39	8094.88	8031.53	8092.24	67368.0
2018-11-16 15:00:00	NQ	Futures	8092.24	8108.08	8065.85	8070.83	60836.0
2018-11-16 16:00:00	NQ	Futures	8070.54	8098.7	8065.85	8092.24	15478.0
2018-11-16 00:00:00	YM	Futures	27479.0	27492.0	27423.6	27449.6	2110.0
2018-11-16 01:00:00	YM	Futures	27448.6	27452.9	27421.4	27451.8	1339.0
2018-11-16 02:00:00	YM	Futures	27450.7	27467.0	27411.6	27460.5	3239.0
2018-11-16 03:00:00	YM	Futures	27461.6	27494.2	27436.6	27445.3	6186.0
2018-11-16 04:00:00	YM	Futures	27445.3	27465.9	27416.0	27450.7	4200.0
2018-11-16 05:00:00	YM	Futures	27452.9	27455.1	27387.7	27400.8	3749.0
2018-11-16 06:00:00	YM	Futures	27399.7	27401.8	27355.1	27388.8	4547.0
2018-11-16 07:00:00	YM	Futures	27387.7	27398.6	27313.8	27349.7	5881.0
2018-11-16 08:00:00	YM	Futures	27351.9	27381.2	27267.1	27379.0	10421.0
2018-11-16 09:00:00	YM	Futures	27379.0	27484.4	27316.0	27471.4	30092.0
2018-11-16 10:00:00	YM	Futures	27471.4	27603.9	27438.8	27546.3	33002.0
2018-11-16 11:00:00	YM	Futures	27547.4	27568.1	27437.7	27474.6	21288.0
2018-11-16 12:00:00	YM	Futures	27473.6	27711.5	27439.9	27653.9	30679.0
2018-11-16 13:00:00	YM	Futures	27652.8	27665.9	27474.6	27540.9	22653.0
2018-11-16 14:00:00	YM	Futures	27540.9	27640.9	27531.1	27613.7	20226.0
2018-11-16 15:00:00	YM	Futures	27612.6	27664.8	27577.9	27610.5	21907.0

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

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