PREVIEW / futures_1hour / 2018-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-25.parquet
  size:    56 KB
  rows:    1,735

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-10-25 00:00:00	ES	Futures	2907.93	2907.93	2904.12	2904.12	6315.0
2018-10-25 01:00:00	ES	Futures	2904.12	2909.02	2897.87	2902.22	15409.0
2018-10-25 02:00:00	ES	Futures	2902.49	2912.01	2902.22	2906.84	22909.0
2018-10-25 03:00:00	ES	Futures	2906.84	2917.45	2899.77	2916.91	52228.0
2018-10-25 04:00:00	ES	Futures	2916.64	2919.63	2913.37	2918.54	35876.0
2018-10-25 05:00:00	ES	Futures	2918.81	2929.42	2917.18	2928.88	45446.0
2018-10-25 06:00:00	ES	Futures	2929.15	2929.15	2917.45	2922.35	35311.0
2018-10-25 07:00:00	ES	Futures	2922.35	2924.52	2914.73	2916.64	42712.0
2018-10-25 08:00:00	ES	Futures	2916.64	2923.71	2910.92	2913.92	69494.0
2018-10-25 09:00:00	ES	Futures	2913.64	2924.52	2902.22	2922.35	366240.0
2018-10-25 10:00:00	ES	Futures	2922.35	2937.31	2919.08	2928.6	388282.0
2018-10-25 11:00:00	ES	Futures	2928.33	2944.65	2920.72	2937.31	273927.0
2018-10-25 12:00:00	ES	Futures	2937.31	2941.39	2928.6	2938.94	139781.0
2018-10-25 13:00:00	ES	Futures	2938.94	2946.28	2929.69	2941.12	132078.0
2018-10-25 14:00:00	ES	Futures	2941.12	2963.15	2938.12	2957.71	202245.0
2018-10-25 15:00:00	ES	Futures	2957.71	2963.42	2938.67	2944.92	361077.0
2018-10-25 16:00:00	ES	Futures	2944.92	2947.92	2913.37	2917.45	165421.0
2018-10-25 18:00:00	ES	Futures	2913.64	2916.09	2902.49	2915.28	28874.0
2018-10-25 19:00:00	ES	Futures	2915.28	2916.64	2910.65	2912.28	9442.0
2018-10-25 20:00:00	ES	Futures	2912.01	2913.37	2902.22	2909.56	21538.0
2018-10-25 21:00:00	ES	Futures	2909.84	2912.28	2905.48	2911.2	12166.0
2018-10-25 22:00:00	ES	Futures	2911.2	2912.56	2898.68	2899.23	18852.0
2018-10-25 23:00:00	ES	Futures	2899.5	2902.76	2890.8	2893.79	28427.0
2018-10-25 00:00:00	NQ	Futures	8059.39	8059.39	8037.1	8038.86	3490.0
2018-10-25 01:00:00	NQ	Futures	8038.57	8067.31	8018.62	8050.01	7956.0
2018-10-25 02:00:00	NQ	Futures	8050.01	8085.2	8049.71	8063.5	7024.0
2018-10-25 03:00:00	NQ	Futures	8063.79	8106.32	8033.87	8102.51	16701.0
2018-10-25 04:00:00	NQ	Futures	8101.63	8123.34	8096.94	8117.76	15265.0
2018-10-25 05:00:00	NQ	Futures	8117.76	8173.49	8114.54	8173.2	18977.0
2018-10-25 06:00:00	NQ	Futures	8173.2	8173.49	8125.39	8135.07	14935.0
2018-10-25 07:00:00	NQ	Futures	8134.77	8135.07	8101.92	8111.31	14675.0
2018-10-25 08:00:00	NQ	Futures	8111.02	8141.81	8084.03	8091.66	22036.0
2018-10-25 09:00:00	NQ	Futures	8091.66	8164.4	8063.5	8156.48	105105.0
2018-10-25 10:00:00	NQ	Futures	8156.19	8210.16	8136.83	8175.25	115943.0
2018-10-25 11:00:00	NQ	Futures	8174.96	8226.0	8151.79	8204.58	83642.0
2018-10-25 12:00:00	NQ	Futures	8204.58	8216.61	8166.45	8195.78	54820.0
2018-10-25 13:00:00	NQ	Futures	8196.08	8228.64	8171.73	8218.37	40726.0
2018-10-25 14:00:00	NQ	Futures	8218.08	8301.67	8205.46	8280.84	71112.0
2018-10-25 15:00:00	NQ	Futures	8280.84	8299.03	8239.19	8248.58	98520.0
2018-10-25 16:00:00	NQ	Futures	8248.58	8248.58	8081.1	8083.74	53418.0
2018-10-25 18:00:00	NQ	Futures	8074.35	8095.47	8028.3	8094.0	11461.0
2018-10-25 19:00:00	NQ	Futures	8094.0	8094.88	8069.07	8077.87	5112.0
2018-10-25 20:00:00	NQ	Futures	8078.75	8080.51	8047.37	8060.27	7587.0
2018-10-25 21:00:00	NQ	Futures	8060.27	8074.06	8050.01	8072.89	5603.0
2018-10-25 22:00:00	NQ	Futures	8072.89	8078.46	8032.99	8036.22	6606.0
2018-10-25 23:00:00	NQ	Futures	8036.22	8047.66	7994.28	7998.09	10723.0
2018-10-25 00:00:00	YM	Futures	26810.8	26817.3	26781.4	26786.9	2169.0
2018-10-25 01:00:00	YM	Futures	26788.0	26831.4	26736.9	26761.9	6196.0
2018-10-25 02:00:00	YM	Futures	26761.9	26848.8	26761.9	26804.3	4873.0
2018-10-25 03:00:00	YM	Futures	26803.2	26909.7	26753.2	26897.7	9098.0

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

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