PREVIEW / futures_1hour / 2019-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-04.parquet
  size:    61 KB
  rows:    1,841

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-09-04 00:00:00	ES	Futures	3155.88	3167.52	3155.61	3166.98	15592.0
2019-09-04 01:00:00	ES	Futures	3167.25	3169.41	3164.27	3167.79	16754.0
2019-09-04 02:00:00	ES	Futures	3168.06	3175.37	3166.44	3172.66	29489.0
2019-09-04 03:00:00	ES	Futures	3172.66	3179.43	3168.87	3178.08	37730.0
2019-09-04 04:00:00	ES	Futures	3177.81	3178.89	3173.48	3176.45	30573.0
2019-09-04 05:00:00	ES	Futures	3176.45	3178.08	3171.04	3172.12	29567.0
2019-09-04 06:00:00	ES	Futures	3172.12	3173.48	3168.87	3170.5	28462.0
2019-09-04 07:00:00	ES	Futures	3170.77	3174.56	3169.69	3174.02	24068.0
2019-09-04 08:00:00	ES	Futures	3174.02	3176.18	3172.93	3174.56	22080.0
2019-09-04 09:00:00	ES	Futures	3174.56	3176.45	3168.87	3170.5	160121.0
2019-09-04 10:00:00	ES	Futures	3170.5	3172.66	3163.46	3169.69	174176.0
2019-09-04 11:00:00	ES	Futures	3169.69	3176.72	3167.52	3175.64	103919.0
2019-09-04 12:00:00	ES	Futures	3175.91	3177.54	3173.2	3176.72	72325.0
2019-09-04 13:00:00	ES	Futures	3176.72	3177.54	3172.39	3172.93	62483.0
2019-09-04 14:00:00	ES	Futures	3172.93	3178.62	3171.58	3176.99	71621.0
2019-09-04 15:00:00	ES	Futures	3177.27	3182.41	3177.27	3181.6	168480.0
2019-09-04 16:00:00	ES	Futures	3181.33	3182.95	3180.24	3181.06	50318.0
2019-09-04 18:00:00	ES	Futures	3181.33	3182.95	3179.7	3181.87	10956.0
2019-09-04 19:00:00	ES	Futures	3181.87	3182.41	3180.24	3181.6	2191.0
2019-09-04 20:00:00	ES	Futures	3181.6	3189.18	3181.06	3188.09	20538.0
2019-09-04 21:00:00	ES	Futures	3187.82	3213.27	3185.12	3212.73	68333.0
2019-09-04 22:00:00	ES	Futures	3213.0	3217.87	3211.1	3212.19	35802.0
2019-09-04 23:00:00	ES	Futures	3212.19	3214.62	3212.19	3213.0	10908.0
2019-09-04 00:00:00	NQ	Futures	8880.1	8915.5	8878.94	8913.76	7380.0
2019-09-04 01:00:00	NQ	Futures	8914.34	8923.33	8907.08	8921.88	7920.0
2019-09-04 02:00:00	NQ	Futures	8921.88	8951.47	8916.66	8947.41	15253.0
2019-09-04 03:00:00	NQ	Futures	8947.12	8971.2	8930.29	8967.72	16333.0
2019-09-04 04:00:00	NQ	Futures	8967.14	8970.04	8952.64	8960.47	9583.0
2019-09-04 05:00:00	NQ	Futures	8960.18	8965.98	8935.81	8940.74	11059.0
2019-09-04 06:00:00	NQ	Futures	8941.03	8941.32	8922.17	8929.42	10391.0
2019-09-04 07:00:00	NQ	Futures	8929.42	8940.16	8921.88	8936.97	9803.0
2019-09-04 08:00:00	NQ	Futures	8936.97	8938.71	8923.04	8929.13	9800.0
2019-09-04 09:00:00	NQ	Futures	8928.55	8942.77	8913.76	8921.3	53891.0
2019-09-04 10:00:00	NQ	Futures	8921.3	8929.13	8896.35	8915.5	52909.0
2019-09-04 11:00:00	NQ	Futures	8915.5	8939.87	8912.6	8936.39	34464.0
2019-09-04 12:00:00	NQ	Futures	8936.39	8954.38	8924.78	8952.05	29123.0
2019-09-04 13:00:00	NQ	Futures	8951.76	8959.02	8941.61	8943.06	21659.0
2019-09-04 14:00:00	NQ	Futures	8943.35	8952.34	8936.97	8948.86	23685.0
2019-09-04 15:00:00	NQ	Futures	8949.15	8970.91	8948.86	8963.66	40877.0
2019-09-04 16:00:00	NQ	Futures	8963.66	8968.01	8956.99	8962.79	8655.0
2019-09-04 18:00:00	NQ	Futures	8961.92	8967.43	8956.41	8963.66	5254.0
2019-09-04 19:00:00	NQ	Futures	8963.95	8966.85	8958.73	8963.66	1325.0
2019-09-04 20:00:00	NQ	Futures	8963.66	8992.96	8961.34	8989.19	9479.0
2019-09-04 21:00:00	NQ	Futures	8988.9	9078.56	8976.14	9076.53	26027.0
2019-09-04 22:00:00	NQ	Futures	9077.11	9098.58	9072.17	9075.66	16470.0
2019-09-04 23:00:00	NQ	Futures	9075.66	9084.07	9075.08	9078.27	5999.0
2019-09-04 00:00:00	YM	Futures	28480.5	28589.3	28478.4	28586.0	4146.0
2019-09-04 01:00:00	YM	Futures	28587.1	28612.1	28559.9	28587.1	3753.0
2019-09-04 02:00:00	YM	Futures	28589.3	28651.3	28579.5	28632.8	7077.0
2019-09-04 03:00:00	YM	Futures	28631.7	28683.9	28602.3	28662.2	8388.0

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

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