PREVIEW / futures_1hour / 2016-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-29.parquet
  size:    47 KB
  rows:    1,347

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
2016-04-29 00:00:00	ES	Futures	2237.86	2238.4	2233.27	2234.89	4712.0
2016-04-29 01:00:00	ES	Futures	2235.16	2237.59	2234.89	2236.78	4078.0
2016-04-29 02:00:00	ES	Futures	2236.78	2241.37	2235.43	2239.21	18721.0
2016-04-29 03:00:00	ES	Futures	2239.48	2240.29	2233.27	2235.97	39688.0
2016-04-29 04:00:00	ES	Futures	2235.97	2237.59	2233.81	2235.43	16300.0
2016-04-29 05:00:00	ES	Futures	2235.43	2240.56	2235.43	2238.4	20353.0
2016-04-29 06:00:00	ES	Futures	2238.13	2239.48	2233.81	2235.16	19238.0
2016-04-29 07:00:00	ES	Futures	2234.89	2236.78	2233.81	2234.89	18241.0
2016-04-29 08:00:00	ES	Futures	2234.62	2238.67	2228.41	2230.03	68172.0
2016-04-29 09:00:00	ES	Futures	2230.03	2232.19	2220.86	2221.13	263926.0
2016-04-29 10:00:00	ES	Futures	2220.86	2228.14	2217.62	2219.51	383805.0
2016-04-29 11:00:00	ES	Futures	2219.51	2221.94	2209.52	2214.38	316932.0
2016-04-29 12:00:00	ES	Futures	2214.38	2219.78	2210.87	2216.0	179980.0
2016-04-29 13:00:00	ES	Futures	2216.0	2221.67	2211.95	2212.49	156718.0
2016-04-29 14:00:00	ES	Futures	2212.49	2215.73	2209.25	2211.41	190037.0
2016-04-29 15:00:00	ES	Futures	2211.41	2228.41	2211.14	2223.29	488172.0
2016-04-29 16:00:00	ES	Futures	2223.29	2227.06	2221.94	2224.91	160883.0
2016-04-29 00:00:00	NQ	Futures	5218.67	5219.86	5206.77	5210.64	909.0
2016-04-29 01:00:00	NQ	Futures	5210.64	5218.97	5210.64	5215.4	731.0
2016-04-29 02:00:00	NQ	Futures	5215.4	5222.54	5210.04	5216.29	2664.0
2016-04-29 03:00:00	NQ	Futures	5216.29	5218.97	5197.55	5204.39	6167.0
2016-04-29 04:00:00	NQ	Futures	5204.09	5209.15	5198.14	5204.09	1873.0
2016-04-29 05:00:00	NQ	Futures	5204.09	5218.08	5203.5	5211.53	1975.0
2016-04-29 06:00:00	NQ	Futures	5211.83	5214.21	5198.44	5202.6	3374.0
2016-04-29 07:00:00	NQ	Futures	5202.31	5204.98	5195.46	5198.44	4265.0
2016-04-29 08:00:00	NQ	Futures	5198.74	5204.39	5184.16	5190.7	9453.0
2016-04-29 09:00:00	NQ	Futures	5190.11	5193.38	5150.24	5154.7	68252.0
2016-04-29 10:00:00	NQ	Futures	5154.4	5168.09	5138.93	5144.59	74882.0
2016-04-29 11:00:00	NQ	Futures	5144.59	5150.24	5113.64	5130.01	57471.0
2016-04-29 12:00:00	NQ	Futures	5129.71	5151.13	5122.57	5143.1	28090.0
2016-04-29 13:00:00	NQ	Futures	5142.8	5163.93	5132.39	5132.98	27917.0
2016-04-29 14:00:00	NQ	Futures	5132.98	5140.42	5125.54	5130.9	29007.0
2016-04-29 15:00:00	NQ	Futures	5130.6	5163.33	5129.41	5154.4	46532.0
2016-04-29 16:00:00	NQ	Futures	5154.4	5162.74	5149.94	5160.06	12645.0
2016-04-29 00:00:00	YM	Futures	19014.4	19017.6	18980.2	18991.9	786.0
2016-04-29 01:00:00	YM	Futures	18994.1	19012.3	18993.0	19005.8	762.0
2016-04-29 02:00:00	YM	Futures	19005.8	19036.9	18994.1	19024.0	1865.0
2016-04-29 03:00:00	YM	Futures	19021.9	19032.6	18978.0	19000.5	4196.0
2016-04-29 04:00:00	YM	Futures	18999.4	19014.4	18984.4	19000.5	1952.0
2016-04-29 05:00:00	YM	Futures	19000.5	19034.7	18998.4	19018.7	2023.0
2016-04-29 06:00:00	YM	Futures	19018.7	19027.3	18986.6	18998.4	2366.0
2016-04-29 07:00:00	YM	Futures	18995.1	19008.0	18987.6	18994.1	1393.0
2016-04-29 08:00:00	YM	Futures	18995.1	19023.0	18929.8	18944.8	8214.0
2016-04-29 09:00:00	YM	Futures	18943.8	18957.7	18878.5	18881.7	26240.0
2016-04-29 10:00:00	YM	Futures	18880.6	18949.1	18854.9	18875.3	35200.0
2016-04-29 11:00:00	YM	Futures	18875.3	18894.5	18804.6	18849.6	28701.0
2016-04-29 12:00:00	YM	Futures	18848.5	18892.4	18824.9	18863.5	14634.0
2016-04-29 13:00:00	YM	Futures	18863.5	18918.1	18852.8	18858.1	16738.0
2016-04-29 14:00:00	YM	Futures	18858.1	18883.8	18823.9	18856.0	16696.0
2016-04-29 15:00:00	YM	Futures	18856.0	18983.4	18852.8	18941.6	31434.0

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

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