PREVIEW / futures_1hour / 2019-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-04.parquet
  size:    54 KB
  rows:    1,746

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
2019-02-04 00:00:00	ES	Futures	2938.54	2939.09	2936.64	2938.0	3540.0
2019-02-04 01:00:00	ES	Futures	2938.0	2939.09	2936.92	2938.27	2706.0
2019-02-04 02:00:00	ES	Futures	2938.54	2938.82	2934.74	2936.1	5996.0
2019-02-04 03:00:00	ES	Futures	2936.1	2939.36	2933.66	2935.29	15738.0
2019-02-04 04:00:00	ES	Futures	2935.01	2941.26	2935.01	2940.17	9194.0
2019-02-04 05:00:00	ES	Futures	2939.9	2942.89	2938.54	2939.09	9942.0
2019-02-04 06:00:00	ES	Futures	2939.09	2940.72	2937.46	2938.27	7204.0
2019-02-04 07:00:00	ES	Futures	2938.0	2941.53	2937.73	2940.99	10544.0
2019-02-04 08:00:00	ES	Futures	2940.72	2941.26	2935.29	2936.92	19604.0
2019-02-04 09:00:00	ES	Futures	2937.19	2940.45	2932.57	2936.92	142942.0
2019-02-04 10:00:00	ES	Futures	2936.64	2939.63	2929.85	2938.54	203555.0
2019-02-04 11:00:00	ES	Futures	2938.54	2947.24	2938.27	2946.42	115189.0
2019-02-04 12:00:00	ES	Futures	2946.69	2948.05	2945.06	2946.96	59495.0
2019-02-04 13:00:00	ES	Futures	2946.96	2952.4	2946.42	2951.85	60866.0
2019-02-04 14:00:00	ES	Futures	2952.12	2953.75	2949.95	2952.12	71954.0
2019-02-04 15:00:00	ES	Futures	2952.12	2959.19	2949.95	2958.91	143067.0
2019-02-04 16:00:00	ES	Futures	2958.91	2960.27	2955.38	2955.93	75285.0
2019-02-04 18:00:00	ES	Futures	2954.3	2957.01	2953.21	2954.3	9343.0
2019-02-04 19:00:00	ES	Futures	2954.57	2957.01	2950.77	2951.85	10885.0
2019-02-04 20:00:00	ES	Futures	2951.85	2953.21	2951.31	2952.94	3636.0
2019-02-04 21:00:00	ES	Futures	2952.94	2954.03	2952.12	2953.75	2608.0
2019-02-04 22:00:00	ES	Futures	2953.75	2953.75	2951.58	2952.67	3769.0
2019-02-04 23:00:00	ES	Futures	2952.67	2954.57	2952.67	2953.75	3408.0
2019-02-04 00:00:00	NQ	Futures	8046.02	8046.6	8036.96	8041.63	1915.0
2019-02-04 01:00:00	NQ	Futures	8041.93	8047.48	8038.13	8045.14	1361.0
2019-02-04 02:00:00	NQ	Futures	8045.14	8046.02	8027.9	8033.75	3161.0
2019-02-04 03:00:00	NQ	Futures	8034.04	8046.02	8023.52	8030.82	5118.0
2019-02-04 04:00:00	NQ	Futures	8030.82	8050.69	8030.24	8046.31	2996.0
2019-02-04 05:00:00	NQ	Futures	8045.73	8055.66	8039.88	8040.76	2629.0
2019-02-04 06:00:00	NQ	Futures	8040.47	8045.43	8037.84	8041.05	2127.0
2019-02-04 07:00:00	NQ	Futures	8040.76	8049.23	8039.01	8048.06	6473.0
2019-02-04 08:00:00	NQ	Futures	8047.48	8048.94	8028.19	8034.91	6902.0
2019-02-04 09:00:00	NQ	Futures	8034.62	8076.99	8032.58	8070.85	58627.0
2019-02-04 10:00:00	NQ	Futures	8070.85	8106.5	8055.95	8098.03	69518.0
2019-02-04 11:00:00	NQ	Futures	8098.32	8121.99	8098.32	8116.73	48373.0
2019-02-04 12:00:00	NQ	Futures	8116.73	8119.94	8109.42	8115.27	21428.0
2019-02-04 13:00:00	NQ	Futures	8115.56	8127.83	8110.59	8125.79	20383.0
2019-02-04 14:00:00	NQ	Futures	8126.08	8131.92	8117.31	8125.2	20548.0
2019-02-04 15:00:00	NQ	Futures	8124.91	8138.35	8112.34	8138.06	36854.0
2019-02-04 16:00:00	NQ	Futures	8137.77	8161.43	8104.75	8117.31	23232.0
2019-02-04 18:00:00	NQ	Futures	8108.25	8114.39	8101.83	8107.96	2385.0
2019-02-04 19:00:00	NQ	Futures	8108.25	8115.85	8097.44	8100.95	3593.0
2019-02-04 20:00:00	NQ	Futures	8100.66	8104.75	8098.32	8100.95	2239.0
2019-02-04 21:00:00	NQ	Futures	8101.24	8104.75	8099.49	8104.16	988.0
2019-02-04 22:00:00	NQ	Futures	8104.16	8109.71	8100.07	8105.62	1670.0
2019-02-04 23:00:00	NQ	Futures	8105.92	8112.05	8103.87	8108.25	1346.0
2019-02-04 00:00:00	YM	Futures	27152.4	27155.7	27135.1	27145.9	1175.0
2019-02-04 01:00:00	YM	Futures	27145.9	27156.8	27134.0	27148.1	852.0
2019-02-04 02:00:00	YM	Futures	27149.2	27150.3	27114.4	27123.1	1922.0
2019-02-04 03:00:00	YM	Futures	27124.2	27151.4	27107.9	27121.0	4238.0

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

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