PREVIEW / futures_1hour / 2015-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-29.parquet
  size:    53 KB
  rows:    1,581

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-01-29 00:00:00	ES	Futures	2100.74	2101.27	2092.32	2094.95	11429.0
2015-01-29 01:00:00	ES	Futures	2095.22	2098.9	2094.69	2098.37	3171.0
2015-01-29 02:00:00	ES	Futures	2098.64	2104.16	2097.58	2102.32	14591.0
2015-01-29 03:00:00	ES	Futures	2102.32	2104.43	2096.53	2097.85	28048.0
2015-01-29 04:00:00	ES	Futures	2097.85	2102.58	2096.27	2100.21	20389.0
2015-01-29 05:00:00	ES	Futures	2100.21	2105.74	2099.69	2102.85	20004.0
2015-01-29 06:00:00	ES	Futures	2102.58	2108.37	2100.74	2107.32	21282.0
2015-01-29 07:00:00	ES	Futures	2107.32	2108.11	2101.53	2102.06	28597.0
2015-01-29 08:00:00	ES	Futures	2102.06	2104.69	2096.79	2103.11	63740.0
2015-01-29 09:00:00	ES	Futures	2103.37	2106.53	2089.95	2098.64	347678.0
2015-01-29 10:00:00	ES	Futures	2098.64	2102.58	2086.27	2092.06	397964.0
2015-01-29 11:00:00	ES	Futures	2092.06	2102.58	2087.85	2098.64	257270.0
2015-01-29 12:00:00	ES	Futures	2098.64	2104.43	2095.22	2099.95	160504.0
2015-01-29 13:00:00	ES	Futures	2099.95	2113.37	2096.79	2109.43	177793.0
2015-01-29 14:00:00	ES	Futures	2109.16	2115.74	2107.06	2112.32	149189.0
2015-01-29 15:00:00	ES	Futures	2112.58	2124.95	2111.27	2121.53	286463.0
2015-01-29 16:00:00	ES	Futures	2121.79	2126.27	2118.64	2124.95	91095.0
2015-01-29 17:00:00	ES	Futures	2124.95	2125.74	2124.95	2125.21	1923.0
2015-01-29 18:00:00	ES	Futures	2125.48	2126.79	2123.37	2123.9	8500.0
2015-01-29 19:00:00	ES	Futures	2123.9	2124.16	2121.27	2121.79	4667.0
2015-01-29 20:00:00	ES	Futures	2121.53	2122.58	2119.16	2119.43	4906.0
2015-01-29 21:00:00	ES	Futures	2119.69	2121.0	2118.64	2118.9	2689.0
2015-01-29 22:00:00	ES	Futures	2118.9	2120.74	2118.37	2118.64	3088.0
2015-01-29 23:00:00	ES	Futures	2118.9	2119.43	2117.58	2119.16	3124.0
2015-01-29 00:00:00	NQ	Futures	4849.68	4851.44	4829.71	4838.52	1733.0
2015-01-29 01:00:00	NQ	Futures	4837.64	4846.45	4837.34	4844.68	492.0
2015-01-29 02:00:00	NQ	Futures	4845.27	4857.9	4842.63	4854.08	1350.0
2015-01-29 03:00:00	NQ	Futures	4853.79	4859.37	4841.45	4846.15	4100.0
2015-01-29 04:00:00	NQ	Futures	4846.45	4854.67	4841.45	4849.38	3243.0
2015-01-29 05:00:00	NQ	Futures	4849.38	4859.66	4847.62	4852.32	2719.0
2015-01-29 06:00:00	NQ	Futures	4852.61	4864.95	4849.09	4861.42	3540.0
2015-01-29 07:00:00	NQ	Futures	4861.42	4863.19	4850.26	4851.73	5580.0
2015-01-29 08:00:00	NQ	Futures	4852.03	4858.49	4839.1	4852.91	10010.0
2015-01-29 09:00:00	NQ	Futures	4853.2	4861.13	4811.5	4836.17	60058.0
2015-01-29 10:00:00	NQ	Futures	4836.17	4848.21	4816.78	4831.17	63991.0
2015-01-29 11:00:00	NQ	Futures	4831.17	4850.26	4819.72	4840.28	42296.0
2015-01-29 12:00:00	NQ	Futures	4840.28	4853.49	4830.88	4842.04	26686.0
2015-01-29 13:00:00	NQ	Futures	4842.04	4875.52	4834.11	4867.0	31231.0
2015-01-29 14:00:00	NQ	Futures	4867.0	4886.68	4862.89	4881.39	28111.0
2015-01-29 15:00:00	NQ	Futures	4881.69	4913.11	4878.16	4904.01	52060.0
2015-01-29 16:00:00	NQ	Futures	4904.01	4931.03	4900.48	4928.97	15932.0
2015-01-29 17:00:00	NQ	Futures	4929.56	4933.67	4928.39	4931.32	511.0
2015-01-29 18:00:00	NQ	Futures	4938.08	4943.36	4933.97	4935.43	1720.0
2015-01-29 19:00:00	NQ	Futures	4935.14	4935.43	4928.09	4930.44	916.0
2015-01-29 20:00:00	NQ	Futures	4930.44	4932.5	4923.39	4923.69	1208.0
2015-01-29 21:00:00	NQ	Futures	4923.69	4925.45	4920.16	4922.22	632.0
2015-01-29 22:00:00	NQ	Futures	4922.22	4928.68	4921.63	4922.51	427.0
2015-01-29 23:00:00	NQ	Futures	4922.8	4923.69	4917.52	4922.51	404.0
2015-01-29 00:00:00	YM	Futures	17906.7	17910.8	17832.6	17854.5	2488.0
2015-01-29 01:00:00	YM	Futures	17857.6	17885.8	17851.3	17883.7	748.0

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

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