PREVIEW / futures_1hour / 2016-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-11.parquet
  size:    44 KB
  rows:    1,293

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-03-11 00:00:00	ES	Futures	2152.09	2153.43	2149.94	2151.82	4292.0
2016-03-11 01:00:00	ES	Futures	2151.82	2153.17	2149.67	2152.9	3154.0
2016-03-11 02:00:00	ES	Futures	2152.9	2159.08	2152.09	2156.39	18729.0
2016-03-11 03:00:00	ES	Futures	2156.39	2162.03	2153.97	2156.93	28423.0
2016-03-11 04:00:00	ES	Futures	2156.93	2160.15	2154.24	2157.46	13906.0
2016-03-11 05:00:00	ES	Futures	2157.46	2162.03	2157.2	2160.96	15160.0
2016-03-11 06:00:00	ES	Futures	2160.96	2162.03	2156.93	2157.73	11110.0
2016-03-11 07:00:00	ES	Futures	2157.46	2158.81	2156.12	2157.46	12457.0
2016-03-11 08:00:00	ES	Futures	2157.2	2159.61	2154.51	2156.39	23184.0
2016-03-11 09:00:00	ES	Futures	2156.39	2161.23	2155.32	2159.35	98318.0
2016-03-11 10:00:00	ES	Futures	2159.35	2165.53	2155.58	2162.57	108054.0
2016-03-11 11:00:00	ES	Futures	2162.57	2168.75	2162.03	2167.41	75432.0
2016-03-11 12:00:00	ES	Futures	2167.41	2170.09	2166.33	2166.6	42762.0
2016-03-11 13:00:00	ES	Futures	2166.6	2168.21	2162.84	2167.14	38701.0
2016-03-11 14:00:00	ES	Futures	2167.14	2168.48	2164.18	2166.06	35379.0
2016-03-11 15:00:00	ES	Futures	2166.06	2173.59	2165.53	2172.78	98253.0
2016-03-11 16:00:00	ES	Futures	2172.51	2173.05	2170.09	2172.24	36265.0
2016-03-11 00:00:00	NQ	Futures	5132.46	5134.83	5125.03	5129.79	449.0
2016-03-11 01:00:00	NQ	Futures	5130.97	5136.32	5125.63	5135.13	661.0
2016-03-11 02:00:00	NQ	Futures	5135.13	5152.06	5133.05	5144.63	1948.0
2016-03-11 03:00:00	NQ	Futures	5144.93	5162.45	5139.29	5149.38	3193.0
2016-03-11 04:00:00	NQ	Futures	5148.49	5155.32	5140.48	5147.9	1696.0
2016-03-11 05:00:00	NQ	Futures	5148.49	5158.29	5147.6	5155.03	1363.0
2016-03-11 06:00:00	NQ	Futures	5154.43	5157.7	5144.93	5145.52	945.0
2016-03-11 07:00:00	NQ	Futures	5145.23	5148.49	5142.26	5145.52	1897.0
2016-03-11 08:00:00	NQ	Futures	5145.23	5151.16	5138.1	5143.74	3542.0
2016-03-11 09:00:00	NQ	Futures	5143.74	5154.73	5133.94	5148.2	18804.0
2016-03-11 10:00:00	NQ	Futures	5148.2	5161.85	5129.49	5155.32	18447.0
2016-03-11 11:00:00	NQ	Futures	5154.73	5158.89	5152.95	5155.62	14799.0
2016-03-11 12:00:00	NQ	Futures	5155.62	5160.96	5152.95	5155.03	5411.0
2016-03-11 13:00:00	NQ	Futures	5155.03	5162.45	5146.71	5160.67	4415.0
2016-03-11 14:00:00	NQ	Futures	5160.96	5165.12	5154.43	5160.37	4720.0
2016-03-11 15:00:00	NQ	Futures	5160.67	5179.97	5159.78	5178.78	13755.0
2016-03-11 16:00:00	NQ	Futures	5179.37	5179.37	5168.39	5174.92	4051.0
2016-03-11 00:00:00	YM	Futures	18196.6	18204.1	18175.2	18188.1	765.0
2016-03-11 01:00:00	YM	Futures	18190.2	18202.0	18175.2	18197.7	557.0
2016-03-11 02:00:00	YM	Futures	18197.7	18249.1	18194.5	18229.8	2149.0
2016-03-11 03:00:00	YM	Futures	18232.0	18275.8	18209.5	18238.4	5832.0
2016-03-11 04:00:00	YM	Futures	18240.5	18258.7	18221.2	18244.8	2565.0
2016-03-11 05:00:00	YM	Futures	18245.9	18274.8	18240.5	18264.1	2333.0
2016-03-11 06:00:00	YM	Futures	18264.1	18275.8	18237.3	18238.4	1503.0
2016-03-11 07:00:00	YM	Futures	18238.4	18252.3	18233.0	18240.5	1613.0
2016-03-11 08:00:00	YM	Futures	18240.5	18258.7	18220.2	18233.0	2811.0
2016-03-11 09:00:00	YM	Futures	18234.1	18297.2	18232.0	18280.1	16849.0
2016-03-11 10:00:00	YM	Futures	18281.2	18310.1	18243.7	18283.3	14917.0
2016-03-11 11:00:00	YM	Futures	18282.3	18335.8	18278.0	18327.2	10463.0
2016-03-11 12:00:00	YM	Futures	18327.2	18335.8	18303.7	18306.9	5757.0
2016-03-11 13:00:00	YM	Futures	18304.7	18315.4	18274.8	18307.9	5578.0
2016-03-11 14:00:00	YM	Futures	18306.9	18314.4	18273.7	18283.3	5425.0
2016-03-11 15:00:00	YM	Futures	18283.3	18330.4	18278.0	18322.9	11482.0

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

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