PREVIEW / futures_1hour / 2015-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-12.parquet
  size:    52 KB
  rows:    1,555

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-12 00:00:00	ES	Futures	2141.53	2141.79	2139.69	2140.48	2220.0
2015-01-12 01:00:00	ES	Futures	2140.48	2141.79	2140.21	2141.53	993.0
2015-01-12 02:00:00	ES	Futures	2141.53	2144.69	2141.27	2144.42	5389.0
2015-01-12 03:00:00	ES	Futures	2144.69	2152.85	2144.42	2149.95	23315.0
2015-01-12 04:00:00	ES	Futures	2149.95	2153.9	2144.42	2153.11	20687.0
2015-01-12 05:00:00	ES	Futures	2153.11	2155.48	2152.06	2153.37	12087.0
2015-01-12 06:00:00	ES	Futures	2153.63	2156.0	2152.58	2155.48	13262.0
2015-01-12 07:00:00	ES	Futures	2155.21	2155.21	2151.0	2151.0	13643.0
2015-01-12 08:00:00	ES	Futures	2151.0	2152.32	2143.64	2146.0	41457.0
2015-01-12 09:00:00	ES	Futures	2146.27	2149.69	2122.85	2126.0	324009.0
2015-01-12 10:00:00	ES	Futures	2126.0	2133.9	2121.27	2133.9	300176.0
2015-01-12 11:00:00	ES	Futures	2133.64	2136.0	2127.58	2129.69	201185.0
2015-01-12 12:00:00	ES	Futures	2129.95	2134.69	2127.85	2128.64	105005.0
2015-01-12 13:00:00	ES	Futures	2128.9	2131.0	2125.21	2128.9	92407.0
2015-01-12 14:00:00	ES	Futures	2128.9	2131.53	2122.58	2126.79	144667.0
2015-01-12 15:00:00	ES	Futures	2126.79	2133.11	2121.79	2128.37	214574.0
2015-01-12 16:00:00	ES	Futures	2128.37	2131.53	2127.58	2130.21	70275.0
2015-01-12 17:00:00	ES	Futures	2130.21	2130.21	2129.95	2130.21	882.0
2015-01-12 18:00:00	ES	Futures	2130.21	2132.32	2129.95	2131.0	5093.0
2015-01-12 19:00:00	ES	Futures	2131.0	2131.27	2129.16	2129.16	4450.0
2015-01-12 20:00:00	ES	Futures	2129.16	2130.21	2128.9	2129.42	3485.0
2015-01-12 21:00:00	ES	Futures	2129.42	2132.06	2129.16	2130.21	5056.0
2015-01-12 22:00:00	ES	Futures	2130.21	2130.74	2128.64	2129.95	3273.0
2015-01-12 23:00:00	ES	Futures	2130.21	2133.37	2130.21	2131.27	4879.0
2015-01-12 00:00:00	NQ	Futures	4933.08	4933.67	4928.68	4930.44	311.0
2015-01-12 01:00:00	NQ	Futures	4930.44	4933.38	4929.85	4932.79	171.0
2015-01-12 02:00:00	NQ	Futures	4932.5	4942.78	4932.5	4941.01	901.0
2015-01-12 03:00:00	NQ	Futures	4941.01	4959.81	4940.72	4954.82	5289.0
2015-01-12 04:00:00	NQ	Futures	4954.82	4964.8	4940.43	4962.16	4878.0
2015-01-12 05:00:00	NQ	Futures	4962.16	4966.27	4959.22	4961.28	2378.0
2015-01-12 06:00:00	NQ	Futures	4961.57	4966.27	4959.52	4964.51	1920.0
2015-01-12 07:00:00	NQ	Futures	4964.21	4964.21	4954.23	4954.82	2717.0
2015-01-12 08:00:00	NQ	Futures	4954.82	4957.17	4940.13	4947.18	7982.0
2015-01-12 09:00:00	NQ	Futures	4947.47	4955.7	4887.86	4892.85	70190.0
2015-01-12 10:00:00	NQ	Futures	4893.14	4912.82	4877.87	4912.53	71072.0
2015-01-12 11:00:00	NQ	Futures	4912.53	4916.34	4891.97	4898.43	36488.0
2015-01-12 12:00:00	NQ	Futures	4898.72	4912.53	4893.44	4896.08	21215.0
2015-01-12 13:00:00	NQ	Futures	4896.08	4901.07	4884.33	4896.08	18190.0
2015-01-12 14:00:00	NQ	Futures	4896.37	4901.37	4878.46	4888.44	23613.0
2015-01-12 15:00:00	NQ	Futures	4888.44	4902.54	4876.4	4890.21	40599.0
2015-01-12 16:00:00	NQ	Futures	4890.5	4900.78	4888.74	4897.84	8007.0
2015-01-12 17:00:00	NQ	Futures	4898.14	4898.43	4897.25	4898.43	109.0
2015-01-12 18:00:00	NQ	Futures	4898.14	4902.83	4896.67	4900.19	645.0
2015-01-12 19:00:00	NQ	Futures	4899.9	4901.07	4895.2	4895.2	620.0
2015-01-12 20:00:00	NQ	Futures	4895.2	4898.43	4894.02	4897.55	416.0
2015-01-12 21:00:00	NQ	Futures	4897.25	4903.42	4897.25	4898.43	846.0
2015-01-12 22:00:00	NQ	Futures	4898.14	4900.78	4894.9	4898.43	657.0
2015-01-12 23:00:00	NQ	Futures	4898.72	4905.77	4898.43	4901.66	586.0
2015-01-12 00:00:00	YM	Futures	18414.0	18416.1	18397.3	18403.6	476.0
2015-01-12 01:00:00	YM	Futures	18403.6	18416.1	18402.5	18410.9	228.0

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

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