PREVIEW / futures_1hour / 2015-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-15.parquet
  size:    44 KB
  rows:    1,287

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
2015-05-15 00:00:00	ES	Futures	2236.55	2237.34	2236.29	2236.29	1250.0
2015-05-15 01:00:00	ES	Futures	2236.55	2237.34	2235.49	2236.81	2532.0
2015-05-15 02:00:00	ES	Futures	2236.55	2242.62	2235.76	2241.04	19113.0
2015-05-15 03:00:00	ES	Futures	2241.04	2241.3	2237.87	2239.98	19019.0
2015-05-15 04:00:00	ES	Futures	2239.72	2242.36	2239.72	2241.83	15817.0
2015-05-15 05:00:00	ES	Futures	2241.83	2242.1	2240.78	2241.83	12746.0
2015-05-15 06:00:00	ES	Futures	2241.57	2242.36	2239.45	2239.98	12725.0
2015-05-15 07:00:00	ES	Futures	2240.25	2241.3	2238.93	2241.04	18507.0
2015-05-15 08:00:00	ES	Futures	2240.78	2241.3	2238.4	2239.19	19301.0
2015-05-15 09:00:00	ES	Futures	2239.19	2240.25	2235.23	2236.55	170299.0
2015-05-15 10:00:00	ES	Futures	2236.55	2237.87	2232.59	2237.08	234402.0
2015-05-15 11:00:00	ES	Futures	2236.81	2238.4	2233.12	2234.44	120396.0
2015-05-15 12:00:00	ES	Futures	2234.44	2236.29	2233.12	2235.49	70591.0
2015-05-15 13:00:00	ES	Futures	2235.49	2236.29	2234.17	2234.7	54066.0
2015-05-15 14:00:00	ES	Futures	2234.96	2238.13	2233.64	2237.34	62049.0
2015-05-15 15:00:00	ES	Futures	2237.34	2239.19	2236.29	2238.66	115883.0
2015-05-15 16:00:00	ES	Futures	2238.93	2239.98	2237.61	2239.98	52783.0
2015-05-15 17:00:00	ES	Futures	2239.98	2239.98	2238.93	2239.72	2216.0
2015-05-15 00:00:00	NQ	Futures	5284.32	5286.09	5283.44	5283.44	171.0
2015-05-15 01:00:00	NQ	Futures	5283.44	5284.91	5282.26	5284.62	275.0
2015-05-15 02:00:00	NQ	Futures	5284.32	5296.38	5282.26	5295.5	2272.0
2015-05-15 03:00:00	NQ	Futures	5295.5	5296.08	5287.26	5293.14	2928.0
2015-05-15 04:00:00	NQ	Futures	5292.85	5300.5	5292.85	5299.61	2378.0
2015-05-15 05:00:00	NQ	Futures	5299.32	5301.97	5298.14	5300.79	1816.0
2015-05-15 06:00:00	NQ	Futures	5300.79	5301.97	5295.79	5296.97	1901.0
2015-05-15 07:00:00	NQ	Futures	5296.97	5298.73	5294.32	5297.85	2173.0
2015-05-15 08:00:00	NQ	Futures	5297.55	5298.14	5290.79	5291.97	3665.0
2015-05-15 09:00:00	NQ	Futures	5292.26	5301.08	5278.15	5281.38	31158.0
2015-05-15 10:00:00	NQ	Futures	5281.38	5285.5	5269.91	5283.73	30656.0
2015-05-15 11:00:00	NQ	Futures	5284.03	5287.26	5270.5	5276.09	15062.0
2015-05-15 12:00:00	NQ	Futures	5276.38	5279.62	5271.97	5276.09	6993.0
2015-05-15 13:00:00	NQ	Futures	5276.38	5279.62	5271.38	5272.27	6727.0
2015-05-15 14:00:00	NQ	Futures	5272.27	5281.97	5266.97	5279.32	9748.0
2015-05-15 15:00:00	NQ	Futures	5279.62	5281.68	5274.32	5280.2	15274.0
2015-05-15 16:00:00	NQ	Futures	5280.5	5282.56	5276.68	5282.26	4405.0
2015-05-15 17:00:00	NQ	Futures	5282.56	5282.56	5279.91	5281.38	279.0
2015-05-15 00:00:00	YM	Futures	19087.8	19092.0	19082.6	19082.6	166.0
2015-05-15 01:00:00	YM	Futures	19084.7	19089.9	19078.4	19087.8	367.0
2015-05-15 02:00:00	YM	Futures	19085.7	19134.0	19079.4	19126.6	2845.0
2015-05-15 03:00:00	YM	Futures	19125.6	19127.7	19097.3	19111.9	4068.0
2015-05-15 04:00:00	YM	Futures	19111.9	19135.0	19110.9	19130.8	3223.0
2015-05-15 05:00:00	YM	Futures	19130.8	19138.2	19121.4	19130.8	2104.0
2015-05-15 06:00:00	YM	Futures	19130.8	19135.0	19109.9	19115.1	1926.0
2015-05-15 07:00:00	YM	Futures	19114.0	19124.5	19102.5	19122.4	2642.0
2015-05-15 08:00:00	YM	Futures	19121.4	19123.5	19097.3	19102.5	2439.0
2015-05-15 09:00:00	YM	Futures	19101.5	19125.6	19087.8	19097.3	14802.0
2015-05-15 10:00:00	YM	Futures	19094.1	19106.7	19061.6	19099.4	20365.0
2015-05-15 11:00:00	YM	Futures	19099.4	19116.1	19072.1	19082.6	9461.0
2015-05-15 12:00:00	YM	Futures	19082.6	19099.4	19075.2	19093.1	4784.0
2015-05-15 13:00:00	YM	Futures	19093.1	19103.6	19081.5	19085.7	3961.0

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

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