PREVIEW / futures_1hour / 2018-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-25.parquet
  size:    52 KB
  rows:    1,668

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
2018-09-25 00:00:00	ES	Futures	3182.38	3182.65	3181.84	3182.65	984.0
2018-09-25 01:00:00	ES	Futures	3182.38	3182.92	3181.56	3182.92	2978.0
2018-09-25 02:00:00	ES	Futures	3182.65	3184.28	3181.84	3183.47	5154.0
2018-09-25 03:00:00	ES	Futures	3183.2	3185.92	3181.56	3183.47	14711.0
2018-09-25 04:00:00	ES	Futures	3183.74	3186.46	3183.47	3184.83	8363.0
2018-09-25 05:00:00	ES	Futures	3184.83	3187.82	3184.83	3187.0	10165.0
2018-09-25 06:00:00	ES	Futures	3187.0	3191.63	3186.73	3190.81	20035.0
2018-09-25 07:00:00	ES	Futures	3190.81	3192.44	3189.72	3190.27	15355.0
2018-09-25 08:00:00	ES	Futures	3190.27	3191.63	3186.73	3188.09	19985.0
2018-09-25 09:00:00	ES	Futures	3187.82	3188.36	3182.92	3183.2	134587.0
2018-09-25 10:00:00	ES	Futures	3183.2	3185.1	3178.57	3179.12	137098.0
2018-09-25 11:00:00	ES	Futures	3178.84	3185.92	3177.21	3184.28	101809.0
2018-09-25 12:00:00	ES	Futures	3184.56	3185.92	3181.56	3182.38	46748.0
2018-09-25 13:00:00	ES	Futures	3182.38	3182.38	3175.04	3178.57	144525.0
2018-09-25 14:00:00	ES	Futures	3178.3	3180.2	3176.4	3178.57	92239.0
2018-09-25 15:00:00	ES	Futures	3178.57	3180.75	3175.31	3177.76	189180.0
2018-09-25 16:00:00	ES	Futures	3177.48	3179.93	3177.21	3179.39	48727.0
2018-09-25 18:00:00	ES	Futures	3179.66	3180.48	3179.12	3179.66	2864.0
2018-09-25 19:00:00	ES	Futures	3179.93	3181.29	3179.66	3180.75	2144.0
2018-09-25 20:00:00	ES	Futures	3180.48	3181.84	3180.48	3181.56	3295.0
2018-09-25 21:00:00	ES	Futures	3181.29	3183.2	3181.29	3182.38	5362.0
2018-09-25 22:00:00	ES	Futures	3182.65	3184.83	3182.38	3184.56	5826.0
2018-09-25 23:00:00	ES	Futures	3184.83	3185.64	3184.01	3185.37	3864.0
2018-09-25 00:00:00	NQ	Futures	8896.22	8896.51	8893.28	8895.04	357.0
2018-09-25 01:00:00	NQ	Futures	8894.75	8895.04	8886.54	8892.11	1212.0
2018-09-25 02:00:00	NQ	Futures	8892.11	8898.56	8888.89	8892.11	1929.0
2018-09-25 03:00:00	NQ	Futures	8892.4	8900.91	8886.54	8892.11	4951.0
2018-09-25 04:00:00	NQ	Futures	8891.82	8900.62	8890.35	8895.92	2827.0
2018-09-25 05:00:00	NQ	Futures	8895.63	8905.31	8895.63	8900.32	3027.0
2018-09-25 06:00:00	NQ	Futures	8900.32	8915.28	8899.15	8913.52	5285.0
2018-09-25 07:00:00	NQ	Futures	8913.23	8920.56	8910.88	8912.06	5857.0
2018-09-25 08:00:00	NQ	Futures	8912.35	8919.1	8899.15	8904.43	6987.0
2018-09-25 09:00:00	NQ	Futures	8904.14	8906.78	8869.53	8889.18	66058.0
2018-09-25 10:00:00	NQ	Futures	8888.89	8895.92	8860.43	8861.61	56281.0
2018-09-25 11:00:00	NQ	Futures	8861.61	8909.12	8858.67	8904.14	42358.0
2018-09-25 12:00:00	NQ	Futures	8903.84	8908.54	8888.59	8894.16	19264.0
2018-09-25 13:00:00	NQ	Futures	8894.46	8904.43	8885.95	8900.32	34141.0
2018-09-25 14:00:00	NQ	Futures	8899.74	8905.02	8896.22	8901.2	19796.0
2018-09-25 15:00:00	NQ	Futures	8901.5	8912.94	8898.27	8906.19	29669.0
2018-09-25 16:00:00	NQ	Futures	8906.19	8915.58	8905.31	8914.99	6254.0
2018-09-25 18:00:00	NQ	Futures	8914.4	8917.63	8912.35	8914.99	1192.0
2018-09-25 19:00:00	NQ	Futures	8914.99	8923.79	8914.7	8921.44	1734.0
2018-09-25 20:00:00	NQ	Futures	8921.15	8926.14	8920.86	8923.79	1452.0
2018-09-25 21:00:00	NQ	Futures	8923.79	8933.76	8923.79	8929.36	2479.0
2018-09-25 22:00:00	NQ	Futures	8929.36	8943.73	8929.36	8941.39	2879.0
2018-09-25 23:00:00	NQ	Futures	8941.39	8945.79	8937.58	8944.32	2300.0
2018-09-25 00:00:00	YM	Futures	28903.4	28908.8	28899.1	28904.5	380.0
2018-09-25 01:00:00	YM	Futures	28904.5	28908.8	28894.7	28902.3	972.0
2018-09-25 02:00:00	YM	Futures	28902.3	28918.6	28894.7	28911.0	1501.0
2018-09-25 03:00:00	YM	Futures	28911.0	28934.9	28896.9	28911.0	3278.0

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

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