PREVIEW / futures_1hour / 2016-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-28.parquet
  size:    54 KB
  rows:    1,625

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-28 00:00:00	ES	Futures	2022.57	2023.65	2018.0	2018.81	7708.0
2016-01-28 01:00:00	ES	Futures	2018.81	2022.3	2016.66	2019.62	8071.0
2016-01-28 02:00:00	ES	Futures	2019.62	2029.83	2018.81	2029.29	18915.0
2016-01-28 03:00:00	ES	Futures	2029.56	2037.62	2027.14	2032.25	45155.0
2016-01-28 04:00:00	ES	Futures	2032.25	2034.4	2027.14	2030.37	26730.0
2016-01-28 05:00:00	ES	Futures	2030.37	2030.9	2024.19	2026.07	26504.0
2016-01-28 06:00:00	ES	Futures	2026.33	2026.33	2012.63	2015.86	48294.0
2016-01-28 07:00:00	ES	Futures	2015.86	2022.84	2012.09	2022.04	41228.0
2016-01-28 08:00:00	ES	Futures	2022.04	2031.17	2014.51	2030.9	81117.0
2016-01-28 09:00:00	ES	Futures	2030.9	2044.88	2029.02	2032.52	367412.0
2016-01-28 10:00:00	ES	Futures	2032.52	2033.59	2005.38	2018.54	441202.0
2016-01-28 11:00:00	ES	Futures	2018.54	2028.22	2012.09	2012.09	256586.0
2016-01-28 12:00:00	ES	Futures	2012.09	2033.59	2011.56	2028.22	174237.0
2016-01-28 13:00:00	ES	Futures	2027.95	2031.17	2018.27	2022.04	164108.0
2016-01-28 14:00:00	ES	Futures	2022.04	2034.4	2021.5	2027.68	129002.0
2016-01-28 15:00:00	ES	Futures	2027.68	2032.78	2024.72	2026.87	201595.0
2016-01-28 16:00:00	ES	Futures	2026.87	2027.68	2018.81	2022.84	101233.0
2016-01-28 18:00:00	ES	Futures	2019.35	2023.11	2018.0	2022.04	8636.0
2016-01-28 19:00:00	ES	Futures	2022.04	2023.92	2018.81	2020.15	9816.0
2016-01-28 20:00:00	ES	Futures	2020.42	2025.8	2016.93	2024.19	13800.0
2016-01-28 21:00:00	ES	Futures	2024.45	2029.02	2022.57	2026.6	11305.0
2016-01-28 22:00:00	ES	Futures	2026.6	2045.41	2023.38	2035.47	72072.0
2016-01-28 23:00:00	ES	Futures	2035.74	2035.74	2020.42	2029.56	54937.0
2016-01-28 00:00:00	NQ	Futures	4939.16	4942.42	4925.5	4929.36	2034.0
2016-01-28 01:00:00	NQ	Futures	4928.47	4938.86	4925.2	4932.62	1529.0
2016-01-28 02:00:00	NQ	Futures	4931.73	4958.75	4929.36	4957.57	3351.0
2016-01-28 03:00:00	NQ	Futures	4957.57	4976.57	4951.92	4966.18	7153.0
2016-01-28 04:00:00	NQ	Futures	4966.77	4972.41	4952.81	4961.13	4110.0
2016-01-28 05:00:00	NQ	Futures	4961.43	4962.02	4941.23	4946.28	5555.0
2016-01-28 06:00:00	NQ	Futures	4946.28	4948.66	4912.43	4920.15	10645.0
2016-01-28 07:00:00	NQ	Futures	4920.15	4944.8	4913.03	4941.83	8216.0
2016-01-28 08:00:00	NQ	Futures	4940.94	4963.21	4921.04	4962.32	14298.0
2016-01-28 09:00:00	NQ	Futures	4962.02	4987.26	4944.8	4950.74	61281.0
2016-01-28 10:00:00	NQ	Futures	4951.03	4951.63	4877.69	4926.09	78647.0
2016-01-28 11:00:00	NQ	Futures	4926.09	4950.74	4907.09	4912.43	45316.0
2016-01-28 12:00:00	NQ	Futures	4912.73	4974.19	4911.54	4955.78	35309.0
2016-01-28 13:00:00	NQ	Futures	4955.49	4962.91	4927.58	4937.08	35149.0
2016-01-28 14:00:00	NQ	Futures	4936.78	4976.27	4935.59	4951.92	25217.0
2016-01-28 15:00:00	NQ	Futures	4951.33	4974.19	4946.58	4961.13	32557.0
2016-01-28 16:00:00	NQ	Futures	4961.72	4964.69	4908.87	4928.17	20365.0
2016-01-28 18:00:00	NQ	Futures	4911.24	4922.23	4906.2	4920.45	1945.0
2016-01-28 19:00:00	NQ	Futures	4919.86	4922.82	4910.95	4913.62	2171.0
2016-01-28 20:00:00	NQ	Futures	4914.21	4928.47	4904.12	4925.79	3331.0
2016-01-28 21:00:00	NQ	Futures	4926.39	4938.86	4922.53	4933.51	2242.0
2016-01-28 22:00:00	NQ	Futures	4933.51	4984.59	4925.2	4958.46	9880.0
2016-01-28 23:00:00	NQ	Futures	4958.16	4958.46	4913.03	4941.83	11829.0
2016-01-28 00:00:00	YM	Futures	16912.4	16922.0	16875.2	16881.6	2041.0
2016-01-28 01:00:00	YM	Futures	16881.6	16912.4	16863.5	16886.9	2241.0
2016-01-28 02:00:00	YM	Futures	16885.8	16966.7	16883.7	16963.5	3503.0
2016-01-28 03:00:00	YM	Futures	16963.5	17023.1	16946.5	16982.7	9044.0

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

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