PREVIEW / futures_1hour / 2018-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-02.parquet
  size:    56 KB
  rows:    1,706

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-05-02 00:00:00	ES	Futures	2892.01	2894.46	2891.46	2892.01	3576.0
2018-05-02 01:00:00	ES	Futures	2892.01	2895.28	2892.01	2895.01	2600.0
2018-05-02 02:00:00	ES	Futures	2895.01	2896.37	2893.92	2895.01	7688.0
2018-05-02 03:00:00	ES	Futures	2895.28	2898.28	2893.92	2896.92	12585.0
2018-05-02 04:00:00	ES	Futures	2897.19	2900.19	2897.19	2899.65	9433.0
2018-05-02 05:00:00	ES	Futures	2899.38	2902.1	2899.1	2899.92	10410.0
2018-05-02 06:00:00	ES	Futures	2899.65	2900.19	2893.64	2898.28	13308.0
2018-05-02 07:00:00	ES	Futures	2898.01	2901.01	2895.28	2895.55	14242.0
2018-05-02 08:00:00	ES	Futures	2895.55	2898.01	2891.19	2893.1	26187.0
2018-05-02 09:00:00	ES	Futures	2893.1	2894.19	2884.64	2885.46	168019.0
2018-05-02 10:00:00	ES	Futures	2885.46	2892.01	2884.37	2889.0	201967.0
2018-05-02 11:00:00	ES	Futures	2889.28	2893.64	2882.18	2885.46	126854.0
2018-05-02 12:00:00	ES	Futures	2885.73	2890.91	2883.82	2889.55	80569.0
2018-05-02 13:00:00	ES	Futures	2889.28	2894.74	2889.28	2892.83	57666.0
2018-05-02 14:00:00	ES	Futures	2893.1	2902.1	2888.19	2889.82	194349.0
2018-05-02 15:00:00	ES	Futures	2890.1	2893.1	2869.9	2874.54	312250.0
2018-05-02 16:00:00	ES	Futures	2874.81	2875.09	2864.72	2866.35	86681.0
2018-05-02 18:00:00	ES	Futures	2867.44	2871.54	2865.53	2870.72	7547.0
2018-05-02 19:00:00	ES	Futures	2870.72	2870.99	2868.54	2869.08	4110.0
2018-05-02 20:00:00	ES	Futures	2869.36	2870.17	2866.63	2869.36	6135.0
2018-05-02 21:00:00	ES	Futures	2869.36	2870.17	2864.72	2868.54	8143.0
2018-05-02 22:00:00	ES	Futures	2868.26	2868.81	2865.53	2866.9	3621.0
2018-05-02 23:00:00	ES	Futures	2866.63	2870.72	2866.63	2870.17	2504.0
2018-05-02 00:00:00	NQ	Futures	7918.19	7940.65	7918.19	7930.31	2058.0
2018-05-02 01:00:00	NQ	Futures	7930.61	7937.4	7927.35	7937.11	871.0
2018-05-02 02:00:00	NQ	Futures	7936.81	7942.72	7932.67	7936.81	1760.0
2018-05-02 03:00:00	NQ	Futures	7937.4	7944.2	7930.61	7940.65	2832.0
2018-05-02 04:00:00	NQ	Futures	7940.65	7946.56	7934.74	7939.77	2741.0
2018-05-02 05:00:00	NQ	Futures	7939.47	7955.13	7938.58	7947.15	3074.0
2018-05-02 06:00:00	NQ	Futures	7947.45	7948.04	7923.51	7935.04	3930.0
2018-05-02 07:00:00	NQ	Futures	7934.74	7947.15	7927.35	7927.35	4037.0
2018-05-02 08:00:00	NQ	Futures	7927.95	7937.11	7908.74	7921.74	8512.0
2018-05-02 09:00:00	NQ	Futures	7922.03	7926.47	7879.18	7899.87	58901.0
2018-05-02 10:00:00	NQ	Futures	7900.46	7929.42	7892.78	7898.98	53716.0
2018-05-02 11:00:00	NQ	Futures	7899.28	7917.9	7859.97	7877.7	48418.0
2018-05-02 12:00:00	NQ	Futures	7877.41	7896.32	7869.43	7890.41	27928.0
2018-05-02 13:00:00	NQ	Futures	7890.12	7909.62	7890.12	7904.6	16479.0
2018-05-02 14:00:00	NQ	Futures	7904.3	7942.43	7889.53	7899.28	54139.0
2018-05-02 15:00:00	NQ	Futures	7898.98	7915.24	7846.97	7857.61	63316.0
2018-05-02 16:00:00	NQ	Futures	7857.02	7858.5	7831.9	7836.03	11576.0
2018-05-02 18:00:00	NQ	Futures	7838.4	7851.11	7834.26	7846.38	1680.0
2018-05-02 19:00:00	NQ	Futures	7846.97	7847.86	7839.58	7841.95	1439.0
2018-05-02 20:00:00	NQ	Futures	7841.95	7845.49	7834.56	7842.54	1406.0
2018-05-02 21:00:00	NQ	Futures	7841.95	7845.49	7828.94	7843.13	2610.0
2018-05-02 22:00:00	NQ	Futures	7843.13	7844.31	7833.08	7837.22	1464.0
2018-05-02 23:00:00	NQ	Futures	7837.22	7850.52	7836.33	7848.74	1311.0
2018-05-02 00:00:00	YM	Futures	26087.4	26113.4	26081.9	26091.7	999.0
2018-05-02 01:00:00	YM	Futures	26092.8	26122.1	26091.7	26119.9	1092.0
2018-05-02 02:00:00	YM	Futures	26119.9	26133.0	26101.5	26108.0	2200.0
2018-05-02 03:00:00	YM	Futures	26109.1	26127.5	26090.6	26114.5	3550.0

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

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