PREVIEW / futures_1hour / 2017-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-30.parquet
  size:    51 KB
  rows:    1,592

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
2017-08-30 00:00:00	ES	Futures	2677.36	2677.63	2676.81	2677.36	2070.0
2017-08-30 01:00:00	ES	Futures	2677.36	2678.45	2677.08	2677.9	4373.0
2017-08-30 02:00:00	ES	Futures	2678.18	2683.37	2677.36	2682.82	20523.0
2017-08-30 03:00:00	ES	Futures	2682.55	2682.55	2679.82	2680.09	19226.0
2017-08-30 04:00:00	ES	Futures	2680.09	2680.36	2678.18	2678.45	12274.0
2017-08-30 05:00:00	ES	Futures	2678.72	2678.72	2675.99	2676.54	15339.0
2017-08-30 06:00:00	ES	Futures	2676.81	2678.18	2676.26	2677.63	11507.0
2017-08-30 07:00:00	ES	Futures	2677.63	2677.9	2674.9	2675.99	14244.0
2017-08-30 08:00:00	ES	Futures	2676.26	2676.81	2671.62	2671.89	43757.0
2017-08-30 09:00:00	ES	Futures	2671.89	2676.54	2670.8	2675.99	163618.0
2017-08-30 10:00:00	ES	Futures	2676.26	2680.36	2674.62	2680.09	148995.0
2017-08-30 11:00:00	ES	Futures	2679.82	2681.46	2678.45	2680.64	120915.0
2017-08-30 12:00:00	ES	Futures	2680.64	2683.92	2679.54	2683.64	67218.0
2017-08-30 13:00:00	ES	Futures	2683.92	2689.11	2683.64	2688.29	138800.0
2017-08-30 14:00:00	ES	Futures	2688.29	2689.38	2686.1	2688.56	101405.0
2017-08-30 15:00:00	ES	Futures	2688.29	2688.56	2682.0	2686.1	269729.0
2017-08-30 16:00:00	ES	Futures	2686.38	2686.92	2684.74	2684.74	85390.0
2017-08-30 18:00:00	ES	Futures	2684.46	2686.1	2683.92	2685.28	4391.0
2017-08-30 19:00:00	ES	Futures	2685.28	2687.2	2685.01	2686.92	2806.0
2017-08-30 20:00:00	ES	Futures	2686.92	2688.84	2686.65	2687.74	8324.0
2017-08-30 21:00:00	ES	Futures	2687.74	2688.56	2686.65	2686.92	6776.0
2017-08-30 22:00:00	ES	Futures	2686.92	2688.02	2686.1	2686.38	3700.0
2017-08-30 23:00:00	ES	Futures	2686.65	2687.2	2686.1	2687.2	2633.0
2017-08-30 00:00:00	NQ	Futures	6999.83	7002.51	6996.26	7000.73	883.0
2017-08-30 01:00:00	NQ	Futures	7001.03	7006.68	6999.83	7004.0	1307.0
2017-08-30 02:00:00	NQ	Futures	7005.19	7025.74	7003.11	7022.46	5907.0
2017-08-30 03:00:00	NQ	Futures	7022.46	7022.76	7012.94	7013.53	4300.0
2017-08-30 04:00:00	NQ	Futures	7013.53	7013.83	7004.0	7004.9	3925.0
2017-08-30 05:00:00	NQ	Futures	7004.6	7004.9	6998.05	6999.54	1919.0
2017-08-30 06:00:00	NQ	Futures	6999.83	7005.49	6996.26	7002.22	2216.0
2017-08-30 07:00:00	NQ	Futures	7002.51	7003.11	6993.88	6999.83	3178.0
2017-08-30 08:00:00	NQ	Futures	6999.54	7004.6	6982.27	6987.92	11281.0
2017-08-30 09:00:00	NQ	Futures	6987.63	7020.97	6984.05	7018.89	43954.0
2017-08-30 10:00:00	NQ	Futures	7018.59	7034.97	7010.55	7033.78	43413.0
2017-08-30 11:00:00	NQ	Futures	7033.78	7035.86	7026.93	7032.59	22670.0
2017-08-30 12:00:00	NQ	Futures	7032.59	7050.45	7029.61	7049.26	18526.0
2017-08-30 13:00:00	NQ	Futures	7049.26	7076.65	7047.77	7072.78	30693.0
2017-08-30 14:00:00	NQ	Futures	7072.78	7079.33	7067.13	7072.49	23503.0
2017-08-30 15:00:00	NQ	Futures	7072.49	7075.76	7056.11	7068.32	38375.0
2017-08-30 16:00:00	NQ	Futures	7068.32	7072.19	7066.53	7068.61	7705.0
2017-08-30 18:00:00	NQ	Futures	7070.1	7072.78	7065.64	7070.1	960.0
2017-08-30 19:00:00	NQ	Futures	7070.1	7077.55	7069.81	7077.25	1042.0
2017-08-30 20:00:00	NQ	Futures	7077.25	7086.48	7076.36	7081.72	2985.0
2017-08-30 21:00:00	NQ	Futures	7081.72	7084.69	7078.44	7079.63	1741.0
2017-08-30 22:00:00	NQ	Futures	7079.63	7083.2	7077.84	7078.74	1279.0
2017-08-30 23:00:00	NQ	Futures	7078.74	7081.12	7078.14	7081.12	807.0
2017-08-30 00:00:00	YM	Futures	23821.4	23828.0	23817.1	23823.6	1202.0
2017-08-30 01:00:00	YM	Futures	23824.7	23830.1	23822.5	23825.8	897.0
2017-08-30 02:00:00	YM	Futures	23826.9	23902.0	23823.6	23882.4	4632.0
2017-08-30 03:00:00	YM	Futures	23881.3	23882.4	23858.4	23860.6	2533.0

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

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