PREVIEW / futures_1hour / 2016-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-18.parquet
  size:    45 KB
  rows:    1,326

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-18 00:00:00	ES	Futures	2193.32	2194.94	2193.05	2194.94	3405.0
2016-03-18 01:00:00	ES	Futures	2194.67	2195.48	2192.51	2194.4	6692.0
2016-03-18 02:00:00	ES	Futures	2194.4	2194.67	2190.89	2191.16	6287.0
2016-03-18 03:00:00	ES	Futures	2191.16	2196.56	2191.16	2193.59	16984.0
2016-03-18 04:00:00	ES	Futures	2193.59	2196.56	2189.0	2194.67	44808.0
2016-03-18 05:00:00	ES	Futures	2194.4	2198.45	2193.86	2195.21	24962.0
2016-03-18 06:00:00	ES	Futures	2195.21	2199.53	2194.94	2198.72	21136.0
2016-03-18 07:00:00	ES	Futures	2198.45	2199.26	2196.83	2197.1	16687.0
2016-03-18 08:00:00	ES	Futures	2197.1	2200.07	2196.56	2198.18	33177.0
2016-03-18 09:00:00	ES	Futures	2198.18	2201.69	2195.48	2200.88	308917.0
2016-03-18 10:00:00	ES	Futures	2200.61	2203.85	2198.72	2202.23	270056.0
2016-03-18 11:00:00	ES	Futures	2202.23	2206.01	2200.61	2203.04	223634.0
2016-03-18 12:00:00	ES	Futures	2202.77	2204.93	2201.15	2202.77	121300.0
2016-03-18 13:00:00	ES	Futures	2202.77	2203.31	2195.48	2198.99	145143.0
2016-03-18 14:00:00	ES	Futures	2199.26	2201.15	2197.91	2198.45	123410.0
2016-03-18 15:00:00	ES	Futures	2198.45	2204.93	2198.45	2202.23	235278.0
2016-03-18 16:00:00	ES	Futures	2201.96	2202.77	2199.26	2201.69	91935.0
2016-03-18 00:00:00	NQ	Futures	5230.87	5234.44	5229.68	5233.85	331.0
2016-03-18 01:00:00	NQ	Futures	5234.14	5235.93	5227.89	5233.25	592.0
2016-03-18 02:00:00	NQ	Futures	5233.25	5234.14	5223.13	5224.92	722.0
2016-03-18 03:00:00	NQ	Futures	5225.22	5239.2	5224.92	5231.17	1317.0
2016-03-18 04:00:00	NQ	Futures	5231.46	5235.93	5217.78	5230.57	4766.0
2016-03-18 05:00:00	NQ	Futures	5230.57	5240.99	5229.98	5231.46	2205.0
2016-03-18 06:00:00	NQ	Futures	5230.57	5240.99	5230.27	5238.61	2234.0
2016-03-18 07:00:00	NQ	Futures	5238.31	5243.37	5236.82	5236.82	2629.0
2016-03-18 08:00:00	NQ	Futures	5237.12	5242.47	5235.33	5237.71	3474.0
2016-03-18 09:00:00	NQ	Futures	5237.71	5244.85	5207.66	5214.8	50118.0
2016-03-18 10:00:00	NQ	Futures	5214.51	5233.85	5213.32	5231.76	37025.0
2016-03-18 11:00:00	NQ	Futures	5231.46	5249.32	5230.87	5239.8	29748.0
2016-03-18 12:00:00	NQ	Futures	5239.8	5247.53	5237.42	5244.85	15821.0
2016-03-18 13:00:00	NQ	Futures	5244.85	5246.04	5210.64	5221.65	25145.0
2016-03-18 14:00:00	NQ	Futures	5221.65	5232.06	5219.86	5226.41	16696.0
2016-03-18 15:00:00	NQ	Futures	5226.11	5242.47	5226.11	5236.82	24497.0
2016-03-18 16:00:00	NQ	Futures	5236.82	5238.31	5227.6	5232.95	7430.0
2016-03-18 00:00:00	YM	Futures	18619.4	18628.0	18614.1	18628.0	511.0
2016-03-18 01:00:00	YM	Futures	18629.1	18633.3	18608.7	18622.6	779.0
2016-03-18 02:00:00	YM	Futures	18624.8	18624.8	18595.9	18601.2	737.0
2016-03-18 03:00:00	YM	Futures	18601.2	18644.1	18601.2	18622.6	1999.0
2016-03-18 04:00:00	YM	Futures	18619.4	18639.8	18583.0	18625.9	4997.0
2016-03-18 05:00:00	YM	Futures	18626.9	18656.9	18623.7	18631.2	2814.0
2016-03-18 06:00:00	YM	Futures	18630.1	18664.4	18629.1	18656.9	2459.0
2016-03-18 07:00:00	YM	Futures	18656.9	18666.5	18643.0	18643.0	2097.0
2016-03-18 08:00:00	YM	Futures	18644.1	18665.5	18639.8	18656.9	3879.0
2016-03-18 09:00:00	YM	Futures	18656.9	18708.3	18637.6	18707.2	23990.0
2016-03-18 10:00:00	YM	Futures	18706.1	18731.8	18689.0	18709.3	20083.0
2016-03-18 11:00:00	YM	Futures	18708.3	18731.8	18702.9	18720.0	14118.0
2016-03-18 12:00:00	YM	Futures	18721.1	18735.0	18707.2	18716.8	7974.0
2016-03-18 13:00:00	YM	Futures	18715.8	18720.0	18671.9	18698.6	9185.0
2016-03-18 14:00:00	YM	Futures	18698.6	18722.2	18693.3	18702.9	7497.0
2016-03-18 15:00:00	YM	Futures	18702.9	18755.4	18702.9	18726.5	15256.0

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

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