PREVIEW / futures_1hour / 2018-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-29.parquet
  size:    59 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-05-29 00:00:00	ES	Futures	2968.97	2968.97	2966.78	2967.6	2574.0
2018-05-29 01:00:00	ES	Futures	2967.6	2968.97	2963.51	2967.6	6398.0
2018-05-29 02:00:00	ES	Futures	2967.88	2969.24	2955.59	2958.05	19728.0
2018-05-29 03:00:00	ES	Futures	2958.32	2961.05	2951.23	2952.32	30256.0
2018-05-29 04:00:00	ES	Futures	2952.32	2953.96	2936.76	2944.68	58371.0
2018-05-29 05:00:00	ES	Futures	2944.4	2949.04	2942.22	2948.77	28621.0
2018-05-29 06:00:00	ES	Futures	2948.77	2950.95	2942.77	2943.86	25393.0
2018-05-29 07:00:00	ES	Futures	2943.59	2949.86	2940.31	2948.23	26333.0
2018-05-29 08:00:00	ES	Futures	2947.95	2953.41	2946.59	2952.87	34003.0
2018-05-29 09:00:00	ES	Futures	2952.87	2956.69	2944.13	2954.78	213935.0
2018-05-29 10:00:00	ES	Futures	2955.05	2957.78	2948.5	2948.77	172896.0
2018-05-29 11:00:00	ES	Futures	2949.04	2950.41	2932.12	2932.94	225951.0
2018-05-29 12:00:00	ES	Futures	2932.94	2938.13	2921.75	2937.04	247548.0
2018-05-29 13:00:00	ES	Futures	2936.76	2937.31	2925.85	2929.67	131178.0
2018-05-29 14:00:00	ES	Futures	2929.39	2932.12	2920.39	2920.93	196488.0
2018-05-29 15:00:00	ES	Futures	2921.21	2937.86	2920.12	2934.85	290286.0
2018-05-29 16:00:00	ES	Futures	2934.85	2940.31	2934.03	2939.49	72834.0
2018-05-29 18:00:00	ES	Futures	2940.04	2940.86	2936.76	2937.04	6360.0
2018-05-29 19:00:00	ES	Futures	2937.04	2938.67	2933.22	2934.31	7976.0
2018-05-29 20:00:00	ES	Futures	2934.03	2936.76	2932.67	2935.4	9762.0
2018-05-29 21:00:00	ES	Futures	2935.4	2942.49	2934.03	2937.86	12712.0
2018-05-29 22:00:00	ES	Futures	2937.58	2937.86	2931.85	2934.85	8890.0
2018-05-29 23:00:00	ES	Futures	2934.58	2941.4	2933.49	2940.04	8644.0
2018-05-29 00:00:00	NQ	Futures	8247.12	8247.71	8242.98	8245.35	697.0
2018-05-29 01:00:00	NQ	Futures	8245.64	8246.82	8231.75	8242.39	2366.0
2018-05-29 02:00:00	NQ	Futures	8242.69	8246.23	8198.06	8213.72	7976.0
2018-05-29 03:00:00	NQ	Futures	8213.72	8223.77	8189.2	8194.52	8992.0
2018-05-29 04:00:00	NQ	Futures	8194.52	8198.65	8150.78	8167.92	12871.0
2018-05-29 05:00:00	NQ	Futures	8167.03	8188.01	8162.89	8187.72	5922.0
2018-05-29 06:00:00	NQ	Futures	8188.01	8201.31	8173.83	8179.74	5958.0
2018-05-29 07:00:00	NQ	Futures	8180.03	8188.6	8163.48	8182.99	4737.0
2018-05-29 08:00:00	NQ	Futures	8182.4	8206.93	8174.71	8203.09	8642.0
2018-05-29 09:00:00	NQ	Futures	8203.38	8232.93	8175.01	8227.32	61025.0
2018-05-29 10:00:00	NQ	Futures	8227.61	8241.5	8202.79	8219.34	57997.0
2018-05-29 11:00:00	NQ	Futures	8219.64	8223.77	8167.03	8172.94	55996.0
2018-05-29 12:00:00	NQ	Futures	8172.94	8198.95	8145.46	8196.29	56266.0
2018-05-29 13:00:00	NQ	Futures	8195.7	8196.58	8166.44	8178.26	31840.0
2018-05-29 14:00:00	NQ	Futures	8177.97	8191.56	8152.85	8156.69	47355.0
2018-05-29 15:00:00	NQ	Futures	8156.98	8204.56	8148.71	8194.81	53225.0
2018-05-29 16:00:00	NQ	Futures	8194.81	8214.02	8193.63	8213.43	8714.0
2018-05-29 18:00:00	NQ	Futures	8213.43	8215.79	8200.43	8200.43	1466.0
2018-05-29 19:00:00	NQ	Futures	8200.43	8204.86	8192.45	8195.7	1884.0
2018-05-29 20:00:00	NQ	Futures	8195.7	8201.02	8189.49	8197.17	2336.0
2018-05-29 21:00:00	NQ	Futures	8197.17	8215.2	8189.49	8199.24	2780.0
2018-05-29 22:00:00	NQ	Futures	8199.54	8199.54	8178.56	8188.9	2579.0
2018-05-29 23:00:00	NQ	Futures	8189.2	8210.47	8184.17	8206.04	2299.0
2018-05-29 00:00:00	YM	Futures	26862.8	26866.0	26854.1	26859.5	711.0
2018-05-29 01:00:00	YM	Futures	26861.7	26874.7	26826.9	26861.7	1769.0
2018-05-29 02:00:00	YM	Futures	26862.8	26872.6	26748.8	26775.9	6069.0
2018-05-29 03:00:00	YM	Futures	26775.9	26796.5	26703.1	26724.9	7562.0

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

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