PREVIEW / futures_1hour / 2017-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-04.parquet
  size:    44 KB
  rows:    1,321

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
2017-08-04 00:00:00	ES	Futures	2701.14	2702.23	2700.87	2701.69	1994.0
2017-08-04 01:00:00	ES	Futures	2701.69	2702.23	2701.14	2701.96	2400.0
2017-08-04 02:00:00	ES	Futures	2701.69	2702.51	2701.14	2701.96	7930.0
2017-08-04 03:00:00	ES	Futures	2701.96	2703.87	2701.41	2703.6	23881.0
2017-08-04 04:00:00	ES	Futures	2703.6	2704.42	2703.05	2703.6	13054.0
2017-08-04 05:00:00	ES	Futures	2703.6	2705.24	2703.33	2704.15	11041.0
2017-08-04 06:00:00	ES	Futures	2704.15	2705.24	2703.6	2704.42	8022.0
2017-08-04 07:00:00	ES	Futures	2704.42	2706.61	2704.42	2706.33	16395.0
2017-08-04 08:00:00	ES	Futures	2706.33	2708.25	2704.69	2705.24	58020.0
2017-08-04 09:00:00	ES	Futures	2705.51	2709.07	2702.51	2702.78	177738.0
2017-08-04 10:00:00	ES	Futures	2702.78	2706.61	2699.77	2703.87	221781.0
2017-08-04 11:00:00	ES	Futures	2703.87	2705.51	2701.96	2704.97	106500.0
2017-08-04 12:00:00	ES	Futures	2704.69	2705.24	2702.51	2703.87	55924.0
2017-08-04 13:00:00	ES	Futures	2703.87	2704.97	2703.05	2704.69	54380.0
2017-08-04 14:00:00	ES	Futures	2704.42	2705.24	2701.69	2702.51	51879.0
2017-08-04 15:00:00	ES	Futures	2702.51	2705.24	2701.96	2704.69	152031.0
2017-08-04 16:00:00	ES	Futures	2704.42	2704.97	2702.23	2702.23	70625.0
2017-08-04 00:00:00	NQ	Futures	7014.13	7018.59	7014.13	7015.91	412.0
2017-08-04 01:00:00	NQ	Futures	7016.21	7017.7	7015.61	7016.51	407.0
2017-08-04 02:00:00	NQ	Futures	7016.51	7021.27	7015.02	7016.51	1032.0
2017-08-04 03:00:00	NQ	Futures	7016.51	7020.97	7012.04	7020.08	2039.0
2017-08-04 04:00:00	NQ	Futures	7020.08	7024.55	7018.59	7022.17	1011.0
2017-08-04 05:00:00	NQ	Futures	7022.17	7027.23	7020.08	7023.36	1080.0
2017-08-04 06:00:00	NQ	Futures	7023.06	7026.93	7021.87	7021.87	3961.0
2017-08-04 07:00:00	NQ	Futures	7021.87	7028.72	7021.57	7026.33	1884.0
2017-08-04 08:00:00	NQ	Futures	7026.63	7034.67	7014.42	7017.1	13323.0
2017-08-04 09:00:00	NQ	Futures	7017.1	7041.22	7007.58	7009.06	53344.0
2017-08-04 10:00:00	NQ	Futures	7009.06	7032.59	6996.26	7024.55	60368.0
2017-08-04 11:00:00	NQ	Futures	7024.55	7037.65	7020.68	7029.61	25427.0
2017-08-04 12:00:00	NQ	Futures	7029.31	7030.5	7009.06	7018.29	18955.0
2017-08-04 13:00:00	NQ	Futures	7018.29	7023.06	7012.34	7020.38	17206.0
2017-08-04 14:00:00	NQ	Futures	7020.38	7022.17	7011.45	7015.02	13843.0
2017-08-04 15:00:00	NQ	Futures	7015.02	7026.04	7011.45	7024.55	26652.0
2017-08-04 16:00:00	NQ	Futures	7024.25	7029.31	7020.68	7023.36	7736.0
2017-08-04 00:00:00	YM	Futures	23921.6	23945.5	23918.3	23942.2	1762.0
2017-08-04 01:00:00	YM	Futures	23943.3	23943.3	23913.9	23933.5	2418.0
2017-08-04 02:00:00	YM	Futures	23932.5	23939.0	23916.1	23930.3	2082.0
2017-08-04 03:00:00	YM	Futures	23930.3	23964.0	23916.1	23954.2	6338.0
2017-08-04 04:00:00	YM	Futures	23953.1	23959.7	23930.3	23946.6	5535.0
2017-08-04 05:00:00	YM	Futures	23946.6	23966.2	23941.2	23949.9	2823.0
2017-08-04 06:00:00	YM	Futures	23949.9	23966.2	23946.6	23962.9	2131.0
2017-08-04 07:00:00	YM	Futures	23962.9	23991.2	23961.8	23982.5	3398.0
2017-08-04 08:00:00	YM	Futures	23983.6	23996.7	23965.1	23976.0	6340.0
2017-08-04 09:00:00	YM	Futures	23976.0	23983.6	23930.3	23935.7	15146.0
2017-08-04 10:00:00	YM	Futures	23935.7	23960.8	23912.9	23935.7	18769.0
2017-08-04 11:00:00	YM	Futures	23936.8	23960.8	23924.8	23953.1	8327.0
2017-08-04 12:00:00	YM	Futures	23953.1	23958.6	23940.1	23954.2	4605.0
2017-08-04 13:00:00	YM	Futures	23954.2	23968.4	23949.9	23964.0	4296.0
2017-08-04 14:00:00	YM	Futures	23962.9	23968.4	23948.8	23959.7	3849.0
2017-08-04 15:00:00	YM	Futures	23958.6	23978.2	23952.0	23974.9	6480.0

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

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