PREVIEW / futures_1hour / 2019-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-28.parquet
  size:    48 KB
  rows:    1,466

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-06-28 00:00:00	ES	Futures	3175.64	3176.99	3175.1	3175.1	3361.0
2019-06-28 01:00:00	ES	Futures	3175.37	3176.45	3173.48	3175.1	5476.0
2019-06-28 02:00:00	ES	Futures	3175.1	3178.62	3173.75	3177.54	9748.0
2019-06-28 03:00:00	ES	Futures	3177.54	3180.78	3176.99	3179.97	15356.0
2019-06-28 04:00:00	ES	Futures	3179.97	3182.68	3177.54	3181.33	12987.0
2019-06-28 05:00:00	ES	Futures	3181.33	3183.22	3180.24	3182.41	14263.0
2019-06-28 06:00:00	ES	Futures	3182.68	3182.68	3179.16	3180.24	9242.0
2019-06-28 07:00:00	ES	Futures	3180.24	3181.06	3178.62	3180.51	8483.0
2019-06-28 08:00:00	ES	Futures	3180.51	3182.68	3179.43	3181.87	16882.0
2019-06-28 09:00:00	ES	Futures	3182.14	3184.57	3175.64	3177.81	137844.0
2019-06-28 10:00:00	ES	Futures	3178.08	3180.51	3175.91	3179.16	122991.0
2019-06-28 11:00:00	ES	Futures	3179.16	3183.22	3176.18	3181.33	99303.0
2019-06-28 12:00:00	ES	Futures	3181.33	3188.64	3181.33	3186.74	99218.0
2019-06-28 13:00:00	ES	Futures	3186.74	3186.74	3180.51	3181.33	72514.0
2019-06-28 14:00:00	ES	Futures	3181.33	3183.22	3178.62	3179.43	74806.0
2019-06-28 15:00:00	ES	Futures	3179.43	3192.7	3178.08	3187.01	336247.0
2019-06-28 16:00:00	ES	Futures	3187.01	3200.0	3185.66	3198.38	136070.0
2019-06-28 00:00:00	NQ	Futures	8915.79	8920.14	8911.72	8913.18	1416.0
2019-06-28 01:00:00	NQ	Futures	8912.6	8917.53	8906.5	8913.76	1927.0
2019-06-28 02:00:00	NQ	Futures	8913.18	8926.52	8909.11	8924.2	3404.0
2019-06-28 03:00:00	NQ	Futures	8924.2	8934.65	8922.46	8932.91	4634.0
2019-06-28 04:00:00	NQ	Futures	8932.91	8941.61	8924.78	8933.49	4790.0
2019-06-28 05:00:00	NQ	Futures	8934.07	8942.48	8929.71	8938.71	4181.0
2019-06-28 06:00:00	NQ	Futures	8938.71	8938.71	8927.68	8930.87	2811.0
2019-06-28 07:00:00	NQ	Futures	8930.87	8933.78	8923.33	8932.33	3074.0
2019-06-28 08:00:00	NQ	Futures	8932.03	8941.32	8928.55	8937.26	5010.0
2019-06-28 09:00:00	NQ	Futures	8937.26	8948.28	8894.61	8903.31	48695.0
2019-06-28 10:00:00	NQ	Futures	8903.31	8918.69	8895.19	8914.92	41158.0
2019-06-28 11:00:00	NQ	Futures	8914.63	8926.52	8904.18	8923.04	31868.0
2019-06-28 12:00:00	NQ	Futures	8922.75	8945.96	8922.46	8939.87	29001.0
2019-06-28 13:00:00	NQ	Futures	8939.87	8940.16	8903.89	8907.66	22653.0
2019-06-28 14:00:00	NQ	Futures	8907.95	8917.24	8902.15	8907.95	19165.0
2019-06-28 15:00:00	NQ	Futures	8907.95	8938.13	8900.7	8929.13	49220.0
2019-06-28 16:00:00	NQ	Futures	8929.13	8966.56	8925.65	8963.37	17518.0
2019-06-28 00:00:00	YM	Futures	28910.1	28921.0	28900.3	28901.4	879.0
2019-06-28 01:00:00	YM	Futures	28901.4	28910.1	28884.0	28896.0	1259.0
2019-06-28 02:00:00	YM	Futures	28894.9	28931.9	28886.2	28931.9	2548.0
2019-06-28 03:00:00	YM	Futures	28930.8	28960.1	28926.4	28947.1	3372.0
2019-06-28 04:00:00	YM	Futures	28946.0	28974.3	28923.2	28960.1	3401.0
2019-06-28 05:00:00	YM	Futures	28961.2	28975.4	28948.2	28964.5	2886.0
2019-06-28 06:00:00	YM	Futures	28964.5	28967.7	28929.7	28938.4	3191.0
2019-06-28 07:00:00	YM	Futures	28940.6	28951.4	28923.2	28947.1	2625.0
2019-06-28 08:00:00	YM	Futures	28946.0	28977.5	28946.0	28966.7	2805.0
2019-06-28 09:00:00	YM	Futures	28965.6	28968.8	28841.6	28873.1	21838.0
2019-06-28 10:00:00	YM	Futures	28874.2	28913.4	28861.2	28897.1	18394.0
2019-06-28 11:00:00	YM	Futures	28896.0	28928.6	28872.0	28916.6	12576.0
2019-06-28 12:00:00	YM	Futures	28915.5	28977.5	28914.5	28942.7	14353.0
2019-06-28 13:00:00	YM	Futures	28942.7	28943.8	28889.4	28899.2	10362.0
2019-06-28 14:00:00	YM	Futures	28899.2	28913.4	28864.4	28868.8	9614.0
2019-06-28 15:00:00	YM	Futures	28869.9	28969.9	28850.3	28915.5	27562.0

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

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