PREVIEW / futures_1hour / 2016-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-10.parquet
  size:    53 KB
  rows:    1,536

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-10 00:00:00	ES	Futures	2139.73	2140.54	2137.58	2138.12	3460.0
2016-03-10 01:00:00	ES	Futures	2138.39	2140.27	2137.31	2137.85	3936.0
2016-03-10 02:00:00	ES	Futures	2137.85	2139.46	2134.89	2138.92	11244.0
2016-03-10 03:00:00	ES	Futures	2138.92	2145.64	2135.97	2143.22	32816.0
2016-03-10 04:00:00	ES	Futures	2143.22	2144.84	2138.66	2138.66	18587.0
2016-03-10 05:00:00	ES	Futures	2138.66	2142.42	2138.66	2141.07	11905.0
2016-03-10 06:00:00	ES	Futures	2141.07	2145.91	2140.0	2143.76	15195.0
2016-03-10 07:00:00	ES	Futures	2143.49	2160.69	2143.49	2158.27	124939.0
2016-03-10 08:00:00	ES	Futures	2158.27	2159.35	2147.52	2151.02	132953.0
2016-03-10 09:00:00	ES	Futures	2151.02	2153.17	2138.66	2151.82	389654.0
2016-03-10 10:00:00	ES	Futures	2151.82	2154.78	2132.21	2133.28	376598.0
2016-03-10 11:00:00	ES	Futures	2133.28	2135.43	2121.46	2127.64	361592.0
2016-03-10 12:00:00	ES	Futures	2127.64	2131.4	2115.28	2120.11	208976.0
2016-03-10 13:00:00	ES	Futures	2120.11	2125.49	2114.47	2122.26	128838.0
2016-03-10 14:00:00	ES	Futures	2122.26	2135.43	2118.5	2131.67	163796.0
2016-03-10 15:00:00	ES	Futures	2131.94	2141.34	2129.52	2137.85	232199.0
2016-03-10 16:00:00	ES	Futures	2137.85	2140.8	2136.77	2138.66	47577.0
2016-03-10 18:00:00	ES	Futures	2137.31	2141.61	2136.24	2137.85	4679.0
2016-03-10 19:00:00	ES	Futures	2137.85	2139.73	2137.31	2138.39	4599.0
2016-03-10 20:00:00	ES	Futures	2138.66	2148.6	2137.31	2145.37	8686.0
2016-03-10 21:00:00	ES	Futures	2145.37	2146.18	2141.61	2143.76	3474.0
2016-03-10 22:00:00	ES	Futures	2143.49	2151.02	2143.22	2150.75	7477.0
2016-03-10 23:00:00	ES	Futures	2150.75	2153.7	2149.94	2152.09	6835.0
2016-03-10 00:00:00	NQ	Futures	5102.17	5104.25	5095.34	5096.53	815.0
2016-03-10 01:00:00	NQ	Futures	5096.23	5103.95	5095.04	5095.94	773.0
2016-03-10 02:00:00	NQ	Futures	5096.23	5099.8	5087.62	5098.61	2065.0
2016-03-10 03:00:00	NQ	Futures	5098.31	5118.8	5090.59	5112.56	5543.0
2016-03-10 04:00:00	NQ	Futures	5112.27	5115.53	5098.01	5098.01	2385.0
2016-03-10 05:00:00	NQ	Futures	5098.01	5109.0	5097.42	5105.44	1372.0
2016-03-10 06:00:00	NQ	Futures	5105.14	5117.61	5101.87	5111.08	1670.0
2016-03-10 07:00:00	NQ	Futures	5111.67	5163.64	5111.38	5158.29	16233.0
2016-03-10 08:00:00	NQ	Futures	5158.29	5160.07	5131.57	5139.29	20072.0
2016-03-10 09:00:00	NQ	Futures	5138.69	5146.41	5106.33	5144.63	61252.0
2016-03-10 10:00:00	NQ	Futures	5144.34	5148.49	5083.76	5086.14	62664.0
2016-03-10 11:00:00	NQ	Futures	5086.14	5091.78	5055.85	5073.67	50937.0
2016-03-10 12:00:00	NQ	Futures	5073.67	5085.25	5031.5	5042.78	36909.0
2016-03-10 13:00:00	NQ	Futures	5042.78	5051.99	5023.78	5040.11	22438.0
2016-03-10 14:00:00	NQ	Futures	5040.11	5088.22	5033.28	5078.71	27328.0
2016-03-10 15:00:00	NQ	Futures	5078.42	5104.55	5070.7	5091.48	36014.0
2016-03-10 16:00:00	NQ	Futures	5091.48	5100.09	5087.32	5092.08	4609.0
2016-03-10 18:00:00	NQ	Futures	5092.08	5098.01	5086.43	5089.7	526.0
2016-03-10 19:00:00	NQ	Futures	5089.4	5094.75	5088.51	5092.97	335.0
2016-03-10 20:00:00	NQ	Futures	5093.56	5114.05	5089.4	5109.3	947.0
2016-03-10 21:00:00	NQ	Futures	5109.3	5111.67	5098.61	5104.55	515.0
2016-03-10 22:00:00	NQ	Futures	5104.84	5128.0	5104.84	5127.71	1068.0
2016-03-10 23:00:00	NQ	Futures	5127.71	5135.72	5124.14	5132.46	767.0
2016-03-10 00:00:00	YM	Futures	18117.4	18127.1	18107.8	18107.8	14.0
2016-03-10 01:00:00	YM	Futures	18108.9	18122.8	18100.3	18100.3	36.0
2016-03-10 02:00:00	YM	Futures	18097.1	18111.0	18080.0	18107.8	82.0
2016-03-10 03:00:00	YM	Futures	18094.9	18156.0	18083.2	18135.6	125.0

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

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