PREVIEW / futures_1hour / 2015-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-31.parquet
  size:    49 KB
  rows:    1,461

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-08-31 00:00:00	ES	Futures	2091.91	2094.04	2088.72	2093.78	8122.0
2015-08-31 01:00:00	ES	Futures	2093.78	2100.7	2091.38	2099.37	9687.0
2015-08-31 02:00:00	ES	Futures	2099.37	2101.76	2096.97	2099.9	12980.0
2015-08-31 03:00:00	ES	Futures	2099.63	2105.76	2095.91	2097.77	21466.0
2015-08-31 04:00:00	ES	Futures	2097.5	2098.57	2092.98	2095.37	16182.0
2015-08-31 05:00:00	ES	Futures	2095.37	2100.97	2094.58	2099.63	10863.0
2015-08-31 06:00:00	ES	Futures	2099.63	2104.69	2097.77	2101.23	23006.0
2015-08-31 07:00:00	ES	Futures	2101.23	2103.1	2099.63	2102.56	12003.0
2015-08-31 08:00:00	ES	Futures	2102.56	2105.23	2097.24	2099.1	27993.0
2015-08-31 09:00:00	ES	Futures	2099.1	2106.29	2094.31	2094.84	204598.0
2015-08-31 10:00:00	ES	Futures	2094.84	2105.23	2089.78	2099.9	234478.0
2015-08-31 11:00:00	ES	Futures	2099.9	2112.68	2094.58	2106.02	258736.0
2015-08-31 12:00:00	ES	Futures	2105.76	2110.28	2104.16	2106.02	125739.0
2015-08-31 13:00:00	ES	Futures	2106.02	2108.42	2099.63	2102.03	132317.0
2015-08-31 14:00:00	ES	Futures	2102.03	2104.69	2091.65	2093.78	164442.0
2015-08-31 15:00:00	ES	Futures	2093.51	2104.43	2093.24	2096.17	377057.0
2015-08-31 16:00:00	ES	Futures	2096.17	2096.71	2090.05	2093.24	122016.0
2015-08-31 17:00:00	ES	Futures	2093.24	2093.51	2092.45	2093.24	2040.0
2015-08-31 18:00:00	ES	Futures	2093.24	2094.04	2087.39	2089.25	7487.0
2015-08-31 19:00:00	ES	Futures	2089.25	2089.78	2080.46	2082.06	10263.0
2015-08-31 20:00:00	ES	Futures	2082.06	2083.93	2062.36	2067.42	48405.0
2015-08-31 21:00:00	ES	Futures	2067.42	2073.54	2059.16	2061.29	43224.0
2015-08-31 22:00:00	ES	Futures	2061.29	2063.96	2056.5	2062.36	33136.0
2015-08-31 23:00:00	ES	Futures	2062.09	2065.02	2059.7	2062.63	11576.0
2015-08-31 00:00:00	NQ	Futures	5083.14	5089.06	5074.56	5086.99	2219.0
2015-08-31 01:00:00	NQ	Futures	5086.99	5104.14	5080.18	5095.56	2276.0
2015-08-31 02:00:00	NQ	Futures	5095.56	5100.59	5087.87	5096.16	1412.0
2015-08-31 03:00:00	NQ	Futures	5096.75	5110.95	5081.07	5086.39	3564.0
2015-08-31 04:00:00	NQ	Futures	5085.8	5087.87	5071.01	5077.82	2405.0
2015-08-31 05:00:00	NQ	Futures	5076.34	5091.72	5074.56	5084.62	2263.0
2015-08-31 06:00:00	NQ	Futures	5084.92	5099.11	5081.37	5089.94	2250.0
2015-08-31 07:00:00	NQ	Futures	5089.94	5096.16	5085.8	5095.56	1291.0
2015-08-31 08:00:00	NQ	Futures	5095.56	5100.59	5080.48	5083.44	4299.0
2015-08-31 09:00:00	NQ	Futures	5083.14	5106.21	5072.2	5073.68	35300.0
2015-08-31 10:00:00	NQ	Futures	5073.68	5099.71	5053.56	5084.92	40426.0
2015-08-31 11:00:00	NQ	Futures	5085.21	5113.9	5066.87	5099.71	43887.0
2015-08-31 12:00:00	NQ	Futures	5099.71	5115.09	5096.16	5105.03	21310.0
2015-08-31 13:00:00	NQ	Futures	5105.03	5109.76	5080.18	5083.14	22468.0
2015-08-31 14:00:00	NQ	Futures	5083.73	5092.31	5038.48	5044.98	33848.0
2015-08-31 15:00:00	NQ	Futures	5044.98	5071.61	5043.8	5052.67	45539.0
2015-08-31 16:00:00	NQ	Futures	5052.67	5053.27	5041.43	5047.94	11567.0
2015-08-31 17:00:00	NQ	Futures	5047.94	5048.83	5045.58	5046.76	331.0
2015-08-31 18:00:00	NQ	Futures	5047.35	5049.72	5032.56	5037.59	844.0
2015-08-31 19:00:00	NQ	Futures	5037.89	5038.77	5014.22	5018.36	1309.0
2015-08-31 20:00:00	NQ	Futures	5017.18	5023.1	4970.45	4981.39	5974.0
2015-08-31 21:00:00	NQ	Futures	4981.09	5006.24	4960.98	4966.6	7950.0
2015-08-31 22:00:00	NQ	Futures	4966.6	4974.59	4953.59	4969.26	4793.0
2015-08-31 23:00:00	NQ	Futures	4968.37	4974.88	4960.09	4965.12	3088.0
2015-08-31 00:00:00	YM	Futures	17327.3	17349.4	17308.4	17345.2	1189.0
2015-08-31 01:00:00	YM	Futures	17343.1	17398.9	17324.2	17382.1	1840.0

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

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