PREVIEW / futures_1hour / 2019-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-22.parquet
  size:    58 KB
  rows:    1,823

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-08-22 00:00:00	ES	Futures	3168.6	3171.04	3168.6	3170.23	4575.0
2019-08-22 01:00:00	ES	Futures	3170.5	3171.04	3165.9	3168.06	8543.0
2019-08-22 02:00:00	ES	Futures	3168.33	3169.41	3164.54	3168.87	12170.0
2019-08-22 03:00:00	ES	Futures	3168.87	3178.62	3165.63	3175.1	41175.0
2019-08-22 04:00:00	ES	Futures	3175.1	3176.45	3164.54	3168.87	29858.0
2019-08-22 05:00:00	ES	Futures	3168.6	3169.41	3160.21	3163.19	33548.0
2019-08-22 06:00:00	ES	Futures	3163.19	3168.06	3162.92	3166.44	23076.0
2019-08-22 07:00:00	ES	Futures	3166.44	3177.54	3165.63	3175.91	35030.0
2019-08-22 08:00:00	ES	Futures	3175.91	3180.78	3174.56	3178.89	35086.0
2019-08-22 09:00:00	ES	Futures	3178.62	3183.22	3174.56	3178.35	175813.0
2019-08-22 10:00:00	ES	Futures	3178.35	3178.35	3144.78	3146.68	320058.0
2019-08-22 11:00:00	ES	Futures	3146.68	3161.02	3146.41	3156.42	172672.0
2019-08-22 12:00:00	ES	Futures	3156.69	3165.9	3155.88	3162.11	87487.0
2019-08-22 13:00:00	ES	Futures	3162.11	3171.04	3162.11	3168.87	74193.0
2019-08-22 14:00:00	ES	Futures	3168.87	3172.66	3165.08	3171.31	76068.0
2019-08-22 15:00:00	ES	Futures	3171.58	3175.64	3163.46	3165.35	175065.0
2019-08-22 16:00:00	ES	Futures	3165.35	3167.25	3161.56	3161.84	58933.0
2019-08-22 18:00:00	ES	Futures	3162.11	3166.17	3161.84	3163.73	4895.0
2019-08-22 19:00:00	ES	Futures	3163.73	3165.08	3160.48	3164.27	4802.0
2019-08-22 20:00:00	ES	Futures	3164.27	3170.77	3162.92	3170.23	12136.0
2019-08-22 21:00:00	ES	Futures	3170.23	3175.91	3167.79	3174.29	17970.0
2019-08-22 22:00:00	ES	Futures	3174.29	3175.37	3172.12	3174.83	6046.0
2019-08-22 23:00:00	ES	Futures	3175.1	3176.72	3174.02	3174.83	5075.0
2019-08-22 00:00:00	NQ	Futures	8976.14	8986.0	8975.56	8985.42	2519.0
2019-08-22 01:00:00	NQ	Futures	8985.42	8986.87	8966.56	8977.3	5033.0
2019-08-22 02:00:00	NQ	Futures	8977.59	8982.52	8965.69	8981.07	5837.0
2019-08-22 03:00:00	NQ	Futures	8981.07	9010.66	8969.46	9000.8	17190.0
2019-08-22 04:00:00	NQ	Futures	9000.8	9004.28	8962.21	8977.3	14572.0
2019-08-22 05:00:00	NQ	Futures	8976.72	8978.46	8944.51	8956.41	13655.0
2019-08-22 06:00:00	NQ	Futures	8956.41	8974.98	8954.96	8968.59	8414.0
2019-08-22 07:00:00	NQ	Futures	8968.3	9008.05	8966.27	9004.28	15296.0
2019-08-22 08:00:00	NQ	Futures	9004.28	9019.66	8996.16	9010.95	14880.0
2019-08-22 09:00:00	NQ	Futures	9010.95	9021.69	8993.84	9010.66	53235.0
2019-08-22 10:00:00	NQ	Futures	9010.95	9011.24	8883.0	8889.96	101258.0
2019-08-22 11:00:00	NQ	Futures	8889.96	8938.13	8887.35	8917.53	59104.0
2019-08-22 12:00:00	NQ	Futures	8917.53	8950.02	8916.08	8937.84	31765.0
2019-08-22 13:00:00	NQ	Futures	8937.84	8971.49	8937.55	8962.21	27321.0
2019-08-22 14:00:00	NQ	Futures	8962.21	8978.17	8950.31	8974.4	27369.0
2019-08-22 15:00:00	NQ	Futures	8974.4	8986.87	8948.57	8953.51	42598.0
2019-08-22 16:00:00	NQ	Futures	8953.51	8957.57	8941.03	8943.06	11552.0
2019-08-22 18:00:00	NQ	Futures	8943.06	8958.44	8942.77	8951.18	2100.0
2019-08-22 19:00:00	NQ	Futures	8951.18	8953.8	8939.58	8950.89	2643.0
2019-08-22 20:00:00	NQ	Futures	8951.18	8973.24	8945.67	8970.33	6388.0
2019-08-22 21:00:00	NQ	Futures	8970.62	8992.38	8965.11	8986.87	10129.0
2019-08-22 22:00:00	NQ	Futures	8987.16	8993.55	8981.07	8992.38	3745.0
2019-08-22 23:00:00	NQ	Futures	8991.8	8997.03	8988.9	8992.38	2815.0
2019-08-22 00:00:00	YM	Futures	28502.3	28524.0	28501.2	28519.7	772.0
2019-08-22 01:00:00	YM	Futures	28518.6	28524.0	28474.0	28495.8	1748.0
2019-08-22 02:00:00	YM	Futures	28496.9	28505.6	28463.1	28499.0	2128.0
2019-08-22 03:00:00	YM	Futures	28497.9	28587.1	28466.4	28559.9	6286.0

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

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