PREVIEW / futures_1hour / 2016-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-24.parquet
  size:    55 KB
  rows:    1,620

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-02-24 00:00:00	ES	Futures	2054.55	2057.51	2054.01	2056.7	7495.0
2016-02-24 01:00:00	ES	Futures	2056.97	2061.27	2055.62	2058.85	6255.0
2016-02-24 02:00:00	ES	Futures	2059.12	2063.95	2058.85	2061.8	20660.0
2016-02-24 03:00:00	ES	Futures	2061.8	2062.61	2053.74	2058.04	44610.0
2016-02-24 04:00:00	ES	Futures	2057.77	2058.31	2046.49	2051.32	52491.0
2016-02-24 05:00:00	ES	Futures	2051.32	2051.86	2044.07	2045.41	39799.0
2016-02-24 06:00:00	ES	Futures	2045.68	2047.03	2041.38	2041.65	33131.0
2016-02-24 07:00:00	ES	Futures	2041.65	2043.8	2037.89	2041.92	49101.0
2016-02-24 08:00:00	ES	Futures	2041.92	2044.07	2038.7	2042.99	49326.0
2016-02-24 09:00:00	ES	Futures	2042.99	2043.26	2030.63	2033.05	279300.0
2016-02-24 10:00:00	ES	Futures	2033.05	2039.77	2027.95	2037.35	390081.0
2016-02-24 11:00:00	ES	Futures	2037.62	2047.03	2030.9	2045.95	273656.0
2016-02-24 12:00:00	ES	Futures	2045.95	2051.06	2041.65	2046.76	221789.0
2016-02-24 13:00:00	ES	Futures	2046.76	2052.67	2045.95	2048.91	166571.0
2016-02-24 14:00:00	ES	Futures	2048.91	2064.49	2047.83	2060.46	236418.0
2016-02-24 15:00:00	ES	Futures	2060.73	2073.63	2060.73	2070.13	298775.0
2016-02-24 16:00:00	ES	Futures	2069.87	2078.46	2069.6	2078.2	79033.0
2016-02-24 18:00:00	ES	Futures	2077.66	2081.42	2074.16	2080.61	16311.0
2016-02-24 19:00:00	ES	Futures	2080.88	2083.57	2077.93	2079.0	15914.0
2016-02-24 20:00:00	ES	Futures	2079.27	2079.54	2074.7	2076.58	12493.0
2016-02-24 21:00:00	ES	Futures	2076.31	2077.66	2074.16	2075.78	7317.0
2016-02-24 22:00:00	ES	Futures	2076.05	2076.58	2070.67	2071.75	11961.0
2016-02-24 23:00:00	ES	Futures	2071.75	2077.39	2070.94	2076.85	7886.0
2016-02-24 00:00:00	NQ	Futures	4925.2	4932.33	4923.72	4930.25	1191.0
2016-02-24 01:00:00	NQ	Futures	4931.14	4942.72	4927.28	4936.78	1133.0
2016-02-24 02:00:00	NQ	Futures	4937.08	4951.03	4936.78	4943.61	2698.0
2016-02-24 03:00:00	NQ	Futures	4943.91	4946.28	4921.04	4932.03	5574.0
2016-02-24 04:00:00	NQ	Futures	4931.73	4932.62	4900.85	4911.84	6306.0
2016-02-24 05:00:00	NQ	Futures	4911.24	4913.03	4893.13	4896.99	6369.0
2016-02-24 06:00:00	NQ	Futures	4897.59	4901.15	4879.77	4880.66	6182.0
2016-02-24 07:00:00	NQ	Futures	4880.96	4885.11	4871.16	4880.66	7392.0
2016-02-24 08:00:00	NQ	Futures	4880.96	4887.19	4875.32	4884.22	8390.0
2016-02-24 09:00:00	NQ	Futures	4884.22	4887.79	4856.91	4864.03	47990.0
2016-02-24 10:00:00	NQ	Futures	4864.03	4882.74	4851.56	4876.8	57597.0
2016-02-24 11:00:00	NQ	Futures	4877.1	4909.17	4861.36	4904.71	37617.0
2016-02-24 12:00:00	NQ	Futures	4904.71	4918.37	4896.99	4909.76	27497.0
2016-02-24 13:00:00	NQ	Futures	4910.06	4933.51	4909.76	4926.68	22574.0
2016-02-24 14:00:00	NQ	Futures	4927.28	4970.63	4924.61	4958.46	36170.0
2016-02-24 15:00:00	NQ	Futures	4958.46	4994.68	4958.16	4987.26	42718.0
2016-02-24 16:00:00	NQ	Futures	4987.26	5010.42	4986.37	5009.23	8931.0
2016-02-24 18:00:00	NQ	Futures	5005.67	5017.25	4999.14	5015.17	2166.0
2016-02-24 19:00:00	NQ	Futures	5014.87	5023.19	5009.83	5013.98	2457.0
2016-02-24 20:00:00	NQ	Futures	5013.69	5016.06	5003.29	5005.67	1872.0
2016-02-24 21:00:00	NQ	Futures	5006.56	5010.42	5002.4	5005.97	911.0
2016-02-24 22:00:00	NQ	Futures	5005.97	5007.15	4989.93	4992.01	2554.0
2016-02-24 23:00:00	NQ	Futures	4993.2	5009.23	4991.42	5007.45	1163.0
2016-02-24 00:00:00	YM	Futures	17409.5	17436.2	17407.4	17426.6	1159.0
2016-02-24 01:00:00	YM	Futures	17429.8	17461.7	17417.0	17445.7	1101.0
2016-02-24 02:00:00	YM	Futures	17446.8	17485.1	17446.8	17467.0	1978.0
2016-02-24 03:00:00	YM	Futures	17467.0	17473.4	17408.5	17441.5	7238.0

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

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