PREVIEW / futures_1hour / 2017-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-28.parquet
  size:    45 KB
  rows:    1,322

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-07-28 00:00:00	ES	Futures	2693.48	2694.85	2692.66	2694.58	3198.0
2017-07-28 01:00:00	ES	Futures	2694.85	2694.85	2693.21	2694.03	5315.0
2017-07-28 02:00:00	ES	Futures	2694.3	2696.49	2693.76	2696.22	8840.0
2017-07-28 03:00:00	ES	Futures	2696.22	2697.58	2694.03	2697.31	24395.0
2017-07-28 04:00:00	ES	Futures	2697.31	2697.58	2694.58	2695.4	15187.0
2017-07-28 05:00:00	ES	Futures	2695.12	2695.4	2692.66	2693.76	21225.0
2017-07-28 06:00:00	ES	Futures	2693.76	2694.58	2691.3	2694.3	28362.0
2017-07-28 07:00:00	ES	Futures	2694.3	2697.04	2694.03	2695.94	23352.0
2017-07-28 08:00:00	ES	Futures	2695.94	2697.86	2695.12	2697.04	30332.0
2017-07-28 09:00:00	ES	Futures	2697.04	2699.5	2694.58	2694.85	171920.0
2017-07-28 10:00:00	ES	Futures	2695.12	2696.76	2691.84	2694.03	167439.0
2017-07-28 11:00:00	ES	Futures	2694.03	2697.58	2691.3	2697.31	157265.0
2017-07-28 12:00:00	ES	Futures	2697.31	2698.4	2696.49	2697.04	59624.0
2017-07-28 13:00:00	ES	Futures	2697.31	2698.4	2695.94	2697.04	61775.0
2017-07-28 14:00:00	ES	Futures	2696.76	2699.5	2696.22	2698.95	57545.0
2017-07-28 15:00:00	ES	Futures	2699.22	2701.41	2697.31	2699.5	170375.0
2017-07-28 16:00:00	ES	Futures	2699.77	2702.23	2699.5	2701.41	85707.0
2017-07-28 00:00:00	NQ	Futures	6994.77	6998.05	6992.39	6997.75	967.0
2017-07-28 01:00:00	NQ	Futures	6998.05	6998.94	6981.37	6985.54	2453.0
2017-07-28 02:00:00	NQ	Futures	6985.84	6989.41	6979.88	6987.92	3258.0
2017-07-28 03:00:00	NQ	Futures	6987.63	6988.22	6980.78	6983.46	3056.0
2017-07-28 04:00:00	NQ	Futures	6983.76	6984.65	6973.33	6977.2	3759.0
2017-07-28 05:00:00	NQ	Futures	6977.5	6979.88	6968.87	6973.63	4258.0
2017-07-28 06:00:00	NQ	Futures	6973.93	6982.86	6967.38	6981.67	3869.0
2017-07-28 07:00:00	NQ	Futures	6981.67	7001.32	6979.88	6995.07	5794.0
2017-07-28 08:00:00	NQ	Futures	6995.67	7004.3	6980.18	7004.3	12142.0
2017-07-28 09:00:00	NQ	Futures	7004.0	7033.18	6989.11	7013.23	69217.0
2017-07-28 10:00:00	NQ	Futures	7012.94	7027.23	7004.6	7009.96	58692.0
2017-07-28 11:00:00	NQ	Futures	7009.96	7031.99	7006.98	7031.69	41287.0
2017-07-28 12:00:00	NQ	Futures	7031.69	7048.67	7029.31	7044.2	31123.0
2017-07-28 13:00:00	NQ	Futures	7043.6	7045.69	7034.97	7038.54	20453.0
2017-07-28 14:00:00	NQ	Futures	7038.84	7044.79	7035.86	7040.92	19463.0
2017-07-28 15:00:00	NQ	Futures	7041.22	7043.01	7028.72	7036.76	35252.0
2017-07-28 16:00:00	NQ	Futures	7036.46	7043.9	7035.86	7042.41	5843.0
2017-07-28 00:00:00	YM	Futures	23615.7	23629.9	23612.4	23627.7	701.0
2017-07-28 01:00:00	YM	Futures	23627.7	23628.8	23615.7	23619.0	928.0
2017-07-28 02:00:00	YM	Futures	23619.0	23649.4	23616.8	23646.2	2923.0
2017-07-28 03:00:00	YM	Futures	23645.1	23651.6	23630.9	23650.5	2836.0
2017-07-28 04:00:00	YM	Futures	23650.5	23651.6	23633.1	23635.3	1815.0
2017-07-28 05:00:00	YM	Futures	23636.4	23636.4	23621.1	23626.6	1957.0
2017-07-28 06:00:00	YM	Futures	23626.6	23637.5	23612.4	23633.1	2476.0
2017-07-28 07:00:00	YM	Futures	23633.1	23652.7	23628.8	23638.6	2626.0
2017-07-28 08:00:00	YM	Futures	23638.6	23645.1	23623.3	23628.8	3986.0
2017-07-28 09:00:00	YM	Futures	23629.9	23663.6	23621.1	23623.3	16077.0
2017-07-28 10:00:00	YM	Futures	23624.4	23668.0	23617.9	23650.5	15103.0
2017-07-28 11:00:00	YM	Futures	23651.6	23668.0	23630.9	23662.5	14045.0
2017-07-28 12:00:00	YM	Futures	23662.5	23674.5	23652.7	23657.1	6689.0
2017-07-28 13:00:00	YM	Futures	23656.0	23677.7	23651.6	23673.4	4898.0
2017-07-28 14:00:00	YM	Futures	23673.4	23682.1	23661.4	23678.8	5776.0
2017-07-28 15:00:00	YM	Futures	23679.9	23711.5	23678.8	23699.5	10550.0

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

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