PREVIEW / futures_1hour / 2016-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-18.parquet
  size:    53 KB
  rows:    1,582

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-18 00:00:00	ES	Futures	2071.21	2076.05	2070.13	2070.94	10861.0
2016-02-18 01:00:00	ES	Futures	2070.67	2072.02	2068.79	2068.79	4832.0
2016-02-18 02:00:00	ES	Futures	2068.79	2073.36	2067.45	2072.55	17462.0
2016-02-18 03:00:00	ES	Futures	2072.55	2072.82	2060.19	2061.8	48002.0
2016-02-18 04:00:00	ES	Futures	2062.07	2068.79	2061.54	2066.1	23733.0
2016-02-18 05:00:00	ES	Futures	2065.84	2072.55	2064.76	2071.75	21353.0
2016-02-18 06:00:00	ES	Futures	2071.75	2078.2	2071.48	2073.9	33794.0
2016-02-18 07:00:00	ES	Futures	2074.16	2076.05	2070.13	2072.82	32726.0
2016-02-18 08:00:00	ES	Futures	2072.55	2074.43	2070.4	2073.09	32930.0
2016-02-18 09:00:00	ES	Futures	2073.09	2073.63	2062.07	2065.3	216628.0
2016-02-18 10:00:00	ES	Futures	2065.3	2067.98	2059.12	2059.12	223898.0
2016-02-18 11:00:00	ES	Futures	2059.65	2065.03	2055.36	2064.76	269697.0
2016-02-18 12:00:00	ES	Futures	2064.76	2066.37	2061.27	2061.27	110773.0
2016-02-18 13:00:00	ES	Futures	2061.54	2064.22	2054.55	2057.77	116713.0
2016-02-18 14:00:00	ES	Futures	2058.04	2066.1	2057.51	2063.69	138261.0
2016-02-18 15:00:00	ES	Futures	2063.95	2064.76	2054.28	2057.77	211915.0
2016-02-18 16:00:00	ES	Futures	2058.04	2062.07	2057.24	2061.8	59130.0
2016-02-18 18:00:00	ES	Futures	2061.0	2061.54	2058.85	2060.19	4350.0
2016-02-18 19:00:00	ES	Futures	2060.46	2061.27	2056.97	2056.97	10744.0
2016-02-18 20:00:00	ES	Futures	2056.97	2061.8	2056.7	2058.58	10108.0
2016-02-18 21:00:00	ES	Futures	2058.31	2059.65	2056.97	2058.58	4575.0
2016-02-18 22:00:00	ES	Futures	2058.85	2059.12	2056.7	2057.24	5337.0
2016-02-18 23:00:00	ES	Futures	2057.24	2058.85	2056.43	2058.58	4957.0
2016-02-18 00:00:00	NQ	Futures	4999.73	5009.23	4994.68	4996.76	2115.0
2016-02-18 01:00:00	NQ	Futures	4996.17	4999.73	4990.53	4990.53	1106.0
2016-02-18 02:00:00	NQ	Futures	4990.23	5003.59	4986.07	5001.21	1942.0
2016-02-18 03:00:00	NQ	Futures	5002.11	5002.4	4967.36	4972.71	5462.0
2016-02-18 04:00:00	NQ	Futures	4972.71	4993.2	4970.33	4985.48	4041.0
2016-02-18 05:00:00	NQ	Futures	4986.07	5004.78	4983.1	5003.0	2560.0
2016-02-18 06:00:00	NQ	Futures	5003.29	5021.11	5002.4	5010.72	4873.0
2016-02-18 07:00:00	NQ	Futures	5011.31	5017.55	5001.21	5008.04	3993.0
2016-02-18 08:00:00	NQ	Futures	5007.75	5011.01	5001.51	5007.45	3478.0
2016-02-18 09:00:00	NQ	Futures	5007.45	5008.64	4970.63	4975.98	37253.0
2016-02-18 10:00:00	NQ	Futures	4975.38	4980.43	4948.06	4954.0	41092.0
2016-02-18 11:00:00	NQ	Futures	4953.71	4969.44	4941.23	4967.96	40598.0
2016-02-18 12:00:00	NQ	Futures	4967.96	4969.44	4952.22	4953.11	16959.0
2016-02-18 13:00:00	NQ	Futures	4953.11	4960.24	4933.22	4939.45	17548.0
2016-02-18 14:00:00	NQ	Futures	4939.16	4961.43	4938.56	4952.81	22292.0
2016-02-18 15:00:00	NQ	Futures	4953.11	4955.49	4921.93	4929.65	34704.0
2016-02-18 16:00:00	NQ	Futures	4929.65	4941.23	4927.87	4941.23	6002.0
2016-02-18 18:00:00	NQ	Futures	4936.48	4940.34	4932.62	4937.37	860.0
2016-02-18 19:00:00	NQ	Futures	4937.97	4940.05	4927.28	4927.58	1232.0
2016-02-18 20:00:00	NQ	Futures	4927.87	4938.86	4926.09	4930.84	1223.0
2016-02-18 21:00:00	NQ	Futures	4930.84	4933.51	4926.68	4930.84	467.0
2016-02-18 22:00:00	NQ	Futures	4931.14	4932.33	4926.39	4927.28	638.0
2016-02-18 23:00:00	NQ	Futures	4927.28	4930.84	4924.9	4930.54	502.0
2016-02-18 00:00:00	YM	Futures	17509.6	17545.8	17501.1	17506.4	2421.0
2016-02-18 01:00:00	YM	Futures	17505.3	17513.9	17488.3	17489.4	780.0
2016-02-18 02:00:00	YM	Futures	17488.3	17520.2	17474.5	17516.0	1894.0
2016-02-18 03:00:00	YM	Futures	17516.0	17516.0	17428.7	17441.5	6370.0

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

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