PREVIEW / futures_1hour / 2017-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-01.parquet
  size:    45 KB
  rows:    1,338

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-09-01 00:00:00	ES	Futures	2701.41	2702.23	2701.14	2701.96	1902.0
2017-09-01 01:00:00	ES	Futures	2702.23	2702.23	2701.41	2701.96	2965.0
2017-09-01 02:00:00	ES	Futures	2701.69	2703.6	2701.69	2703.6	4684.0
2017-09-01 03:00:00	ES	Futures	2703.6	2704.69	2702.51	2704.69	16337.0
2017-09-01 04:00:00	ES	Futures	2704.69	2705.24	2701.69	2703.05	14787.0
2017-09-01 05:00:00	ES	Futures	2702.78	2703.6	2701.96	2703.33	11497.0
2017-09-01 06:00:00	ES	Futures	2703.33	2705.79	2702.78	2705.51	13994.0
2017-09-01 07:00:00	ES	Futures	2705.51	2708.25	2705.51	2707.7	24192.0
2017-09-01 08:00:00	ES	Futures	2707.7	2709.34	2705.24	2706.61	62176.0
2017-09-01 09:00:00	ES	Futures	2706.61	2708.79	2703.87	2705.79	156538.0
2017-09-01 10:00:00	ES	Futures	2706.06	2709.34	2703.87	2708.79	142447.0
2017-09-01 11:00:00	ES	Futures	2708.52	2709.61	2705.51	2708.52	118791.0
2017-09-01 12:00:00	ES	Futures	2708.52	2710.98	2707.97	2710.71	70444.0
2017-09-01 13:00:00	ES	Futures	2710.71	2711.25	2709.07	2709.34	57048.0
2017-09-01 14:00:00	ES	Futures	2709.61	2710.43	2708.52	2709.34	47471.0
2017-09-01 15:00:00	ES	Futures	2709.34	2710.16	2706.06	2706.06	155305.0
2017-09-01 16:00:00	ES	Futures	2706.33	2706.61	2704.42	2704.69	83629.0
2017-09-01 00:00:00	NQ	Futures	7143.35	7144.84	7142.75	7144.24	347.0
2017-09-01 01:00:00	NQ	Futures	7144.24	7144.54	7141.56	7142.75	580.0
2017-09-01 02:00:00	NQ	Futures	7142.75	7145.73	7142.16	7145.14	1113.0
2017-09-01 03:00:00	NQ	Futures	7145.14	7150.2	7139.18	7145.14	5168.0
2017-09-01 04:00:00	NQ	Futures	7145.14	7146.92	7138.29	7141.56	2265.0
2017-09-01 05:00:00	NQ	Futures	7141.27	7142.75	7136.8	7139.78	2201.0
2017-09-01 06:00:00	NQ	Futures	7139.48	7149.9	7139.18	7148.71	2923.0
2017-09-01 07:00:00	NQ	Futures	7148.71	7157.64	7147.22	7156.75	3907.0
2017-09-01 08:00:00	NQ	Futures	7156.75	7169.55	7148.41	7152.58	14328.0
2017-09-01 09:00:00	NQ	Futures	7152.58	7162.11	7125.49	7129.06	47137.0
2017-09-01 10:00:00	NQ	Futures	7129.36	7140.37	7114.17	7137.1	49298.0
2017-09-01 11:00:00	NQ	Futures	7137.1	7141.86	7129.65	7140.67	20819.0
2017-09-01 12:00:00	NQ	Futures	7140.37	7144.54	7137.99	7141.56	11910.0
2017-09-01 13:00:00	NQ	Futures	7141.56	7143.95	7128.16	7134.12	19044.0
2017-09-01 14:00:00	NQ	Futures	7134.12	7139.48	7131.14	7135.31	14871.0
2017-09-01 15:00:00	NQ	Futures	7135.61	7142.16	7132.04	7132.63	20133.0
2017-09-01 16:00:00	NQ	Futures	7132.63	7135.61	7129.95	7129.95	6917.0
2017-09-01 00:00:00	YM	Futures	23917.2	23921.6	23913.9	23921.6	312.0
2017-09-01 01:00:00	YM	Futures	23921.6	23922.7	23913.9	23917.2	690.0
2017-09-01 02:00:00	YM	Futures	23917.2	23933.5	23916.1	23932.5	1094.0
2017-09-01 03:00:00	YM	Futures	23932.5	23942.2	23925.9	23942.2	2433.0
2017-09-01 04:00:00	YM	Futures	23942.2	23944.4	23917.2	23927.0	1885.0
2017-09-01 05:00:00	YM	Futures	23928.1	23934.6	23920.5	23929.2	933.0
2017-09-01 06:00:00	YM	Futures	23928.1	23953.1	23924.8	23953.1	2113.0
2017-09-01 07:00:00	YM	Futures	23953.1	23973.8	23951.0	23962.9	3057.0
2017-09-01 08:00:00	YM	Futures	23962.9	23970.5	23941.2	23953.1	6390.0
2017-09-01 09:00:00	YM	Futures	23953.1	23967.3	23919.4	23940.1	16778.0
2017-09-01 10:00:00	YM	Futures	23941.2	23960.8	23931.4	23955.3	12080.0
2017-09-01 11:00:00	YM	Futures	23954.2	23965.1	23923.7	23946.6	8354.0
2017-09-01 12:00:00	YM	Futures	23946.6	23986.9	23945.5	23976.0	6585.0
2017-09-01 13:00:00	YM	Futures	23977.1	23981.4	23960.8	23961.8	5121.0
2017-09-01 14:00:00	YM	Futures	23961.8	23968.4	23952.0	23956.4	3307.0
2017-09-01 15:00:00	YM	Futures	23957.5	23961.8	23925.9	23929.2	7841.0

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

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