PREVIEW / futures_1hour / 2018-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-16.parquet
  size:    53 KB
  rows:    1,662

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-04-16 00:00:00	ES	Futures	2908.38	2915.2	2908.38	2913.84	5133.0
2018-04-16 01:00:00	ES	Futures	2914.11	2914.11	2908.93	2911.38	5031.0
2018-04-16 02:00:00	ES	Futures	2911.66	2913.29	2907.84	2908.38	10183.0
2018-04-16 03:00:00	ES	Futures	2908.65	2911.38	2904.56	2910.29	15947.0
2018-04-16 04:00:00	ES	Futures	2910.29	2914.11	2910.02	2913.57	10589.0
2018-04-16 05:00:00	ES	Futures	2913.29	2919.57	2913.02	2918.48	12386.0
2018-04-16 06:00:00	ES	Futures	2918.48	2920.12	2916.02	2918.75	14334.0
2018-04-16 07:00:00	ES	Futures	2919.02	2919.57	2914.66	2916.57	15766.0
2018-04-16 08:00:00	ES	Futures	2916.57	2923.12	2915.2	2922.85	28780.0
2018-04-16 09:00:00	ES	Futures	2922.85	2924.21	2910.29	2913.84	158779.0
2018-04-16 10:00:00	ES	Futures	2914.11	2922.3	2913.57	2917.66	164244.0
2018-04-16 11:00:00	ES	Futures	2917.39	2921.48	2913.57	2920.39	121513.0
2018-04-16 12:00:00	ES	Futures	2920.12	2930.49	2919.3	2928.3	128940.0
2018-04-16 13:00:00	ES	Futures	2928.3	2933.22	2928.03	2931.85	97542.0
2018-04-16 14:00:00	ES	Futures	2931.85	2932.4	2924.21	2927.21	98365.0
2018-04-16 15:00:00	ES	Futures	2927.21	2929.94	2921.48	2923.39	171435.0
2018-04-16 16:00:00	ES	Futures	2923.39	2929.94	2923.39	2925.03	65679.0
2018-04-16 18:00:00	ES	Futures	2924.76	2928.3	2924.21	2928.03	5135.0
2018-04-16 19:00:00	ES	Futures	2928.03	2929.39	2925.85	2926.94	3682.0
2018-04-16 20:00:00	ES	Futures	2927.21	2934.58	2926.94	2931.85	10142.0
2018-04-16 21:00:00	ES	Futures	2931.85	2932.12	2926.67	2928.03	7842.0
2018-04-16 22:00:00	ES	Futures	2928.03	2934.03	2927.48	2934.03	6485.0
2018-04-16 23:00:00	ES	Futures	2933.76	2935.94	2933.49	2935.94	4224.0
2018-04-16 00:00:00	NQ	Futures	7869.13	7885.98	7869.13	7883.32	1749.0
2018-04-16 01:00:00	NQ	Futures	7883.32	7883.32	7870.61	7878.89	1716.0
2018-04-16 02:00:00	NQ	Futures	7878.89	7884.8	7860.86	7867.07	3070.0
2018-04-16 03:00:00	NQ	Futures	7867.36	7879.77	7851.99	7874.16	5542.0
2018-04-16 04:00:00	NQ	Futures	7873.57	7890.71	7872.68	7882.73	4066.0
2018-04-16 05:00:00	NQ	Futures	7882.43	7907.55	7880.96	7901.94	3575.0
2018-04-16 06:00:00	NQ	Futures	7902.53	7908.44	7892.48	7901.35	2888.0
2018-04-16 07:00:00	NQ	Futures	7901.64	7903.12	7886.57	7891.3	3598.0
2018-04-16 08:00:00	NQ	Futures	7891.3	7914.35	7886.57	7913.46	7624.0
2018-04-16 09:00:00	NQ	Futures	7913.46	7915.24	7854.95	7865.88	49208.0
2018-04-16 10:00:00	NQ	Futures	7865.59	7901.94	7865.59	7876.82	49786.0
2018-04-16 11:00:00	NQ	Futures	7877.11	7888.34	7848.45	7886.57	40543.0
2018-04-16 12:00:00	NQ	Futures	7886.57	7921.74	7886.28	7918.49	32639.0
2018-04-16 13:00:00	NQ	Futures	7919.08	7932.08	7917.31	7924.1	26515.0
2018-04-16 14:00:00	NQ	Futures	7923.51	7927.06	7901.94	7908.14	23459.0
2018-04-16 15:00:00	NQ	Futures	7908.74	7916.12	7888.34	7900.46	34173.0
2018-04-16 16:00:00	NQ	Futures	7900.17	7946.27	7899.28	7924.4	15487.0
2018-04-16 18:00:00	NQ	Futures	7925.29	7931.49	7918.49	7924.4	1603.0
2018-04-16 19:00:00	NQ	Futures	7924.99	7933.86	7922.03	7924.99	1524.0
2018-04-16 20:00:00	NQ	Futures	7925.58	7955.13	7924.4	7944.2	3438.0
2018-04-16 21:00:00	NQ	Futures	7944.5	7946.56	7927.95	7929.72	2530.0
2018-04-16 22:00:00	NQ	Futures	7929.42	7949.22	7928.83	7946.56	2753.0
2018-04-16 23:00:00	NQ	Futures	7946.56	7953.66	7943.31	7952.77	1681.0
2018-04-16 00:00:00	YM	Futures	26505.5	26569.6	26505.5	26566.3	2274.0
2018-04-16 01:00:00	YM	Futures	26567.4	26567.4	26515.3	26542.4	1648.0
2018-04-16 02:00:00	YM	Futures	26541.3	26564.1	26514.2	26517.4	2417.0
2018-04-16 03:00:00	YM	Futures	26519.6	26540.2	26478.3	26527.2	3883.0

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

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