PREVIEW / futures_1hour / 2016-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-18.parquet
  size:    40 KB
  rows:    1,191

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-01-18 00:00:00	ES	Futures	2019.08	2023.65	2017.47	2020.15	10373.0
2016-01-18 01:00:00	ES	Futures	2020.15	2021.77	2014.51	2019.35	6962.0
2016-01-18 02:00:00	ES	Futures	2019.35	2023.65	2009.41	2011.02	17836.0
2016-01-18 03:00:00	ES	Futures	2011.02	2031.44	2010.75	2027.68	56553.0
2016-01-18 04:00:00	ES	Futures	2027.68	2028.75	2008.33	2017.2	39676.0
2016-01-18 05:00:00	ES	Futures	2017.47	2027.41	2013.17	2026.87	29146.0
2016-01-18 06:00:00	ES	Futures	2027.14	2027.14	2017.74	2022.84	21703.0
2016-01-18 07:00:00	ES	Futures	2023.11	2023.65	2017.74	2019.62	15111.0
2016-01-18 08:00:00	ES	Futures	2019.89	2019.89	2010.48	2010.75	29152.0
2016-01-18 09:00:00	ES	Futures	2010.48	2012.09	2006.45	2010.75	53048.0
2016-01-18 10:00:00	ES	Futures	2010.75	2013.97	2009.14	2012.09	29833.0
2016-01-18 11:00:00	ES	Futures	2012.09	2014.51	2010.75	2014.24	19704.0
2016-01-18 12:00:00	ES	Futures	2014.24	2014.24	2009.94	2013.17	8263.0
2016-01-18 18:00:00	ES	Futures	2012.36	2016.66	2010.48	2014.51	6449.0
2016-01-18 19:00:00	ES	Futures	2014.24	2022.04	2012.36	2021.23	13545.0
2016-01-18 20:00:00	ES	Futures	2021.23	2029.83	2019.08	2027.68	17703.0
2016-01-18 21:00:00	ES	Futures	2027.41	2032.25	2018.54	2022.04	31656.0
2016-01-18 22:00:00	ES	Futures	2022.04	2029.83	2020.96	2029.83	12861.0
2016-01-18 23:00:00	ES	Futures	2029.56	2034.4	2028.48	2028.75	10336.0
2016-01-18 00:00:00	NQ	Futures	4931.44	4944.2	4929.95	4934.7	2479.0
2016-01-18 01:00:00	NQ	Futures	4934.41	4940.05	4919.86	4933.51	1756.0
2016-01-18 02:00:00	NQ	Futures	4933.51	4944.2	4905.9	4911.24	3344.0
2016-01-18 03:00:00	NQ	Futures	4911.24	4961.72	4910.65	4951.63	8774.0
2016-01-18 04:00:00	NQ	Futures	4952.22	4954.6	4904.41	4926.09	7706.0
2016-01-18 05:00:00	NQ	Futures	4925.79	4948.95	4913.03	4946.88	6057.0
2016-01-18 06:00:00	NQ	Futures	4947.17	4947.17	4924.31	4936.19	3877.0
2016-01-18 07:00:00	NQ	Futures	4936.48	4943.02	4926.98	4935.0	3533.0
2016-01-18 08:00:00	NQ	Futures	4935.0	4935.0	4912.14	4912.73	2942.0
2016-01-18 09:00:00	NQ	Futures	4912.43	4915.7	4900.55	4904.41	8547.0
2016-01-18 10:00:00	NQ	Futures	4904.12	4916.59	4904.12	4912.14	6051.0
2016-01-18 11:00:00	NQ	Futures	4912.43	4915.4	4905.6	4913.32	2795.0
2016-01-18 12:00:00	NQ	Futures	4913.32	4913.92	4901.74	4908.57	1245.0
2016-01-18 18:00:00	NQ	Futures	4909.46	4921.93	4905.9	4914.81	908.0
2016-01-18 19:00:00	NQ	Futures	4914.21	4937.37	4910.06	4934.11	3190.0
2016-01-18 20:00:00	NQ	Futures	4933.51	4950.44	4926.98	4947.47	3859.0
2016-01-18 21:00:00	NQ	Futures	4947.17	4960.54	4921.64	4931.14	5937.0
2016-01-18 22:00:00	NQ	Futures	4930.25	4953.11	4927.87	4951.63	2166.0
2016-01-18 23:00:00	NQ	Futures	4951.33	4961.13	4948.95	4949.85	1741.0
2016-01-18 00:00:00	YM	Futures	16983.8	17029.5	16976.3	16996.5	2590.0
2016-01-18 01:00:00	YM	Futures	16994.4	17007.2	16956.1	16994.4	1780.0
2016-01-18 02:00:00	YM	Futures	16995.5	17022.1	16913.5	16918.8	3308.0
2016-01-18 03:00:00	YM	Futures	16918.8	17082.7	16918.8	17055.1	11590.0
2016-01-18 04:00:00	YM	Futures	17051.9	17063.6	16905.0	16966.7	7480.0
2016-01-18 05:00:00	YM	Futures	16966.7	17034.8	16930.5	17027.4	4974.0
2016-01-18 06:00:00	YM	Futures	17028.5	17029.5	16962.5	16993.3	3603.0
2016-01-18 07:00:00	YM	Futures	16999.7	17004.0	16959.3	16984.8	2869.0
2016-01-18 08:00:00	YM	Futures	16985.9	16986.9	16919.9	16920.9	3633.0
2016-01-18 09:00:00	YM	Futures	16920.9	16930.5	16891.1	16919.9	7791.0
2016-01-18 10:00:00	YM	Futures	16919.9	16949.7	16911.4	16935.8	4913.0
2016-01-18 11:00:00	YM	Futures	16934.8	16943.3	16912.4	16941.2	2919.0

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

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