PREVIEW / futures_1hour / 2016-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-30.parquet
  size:    56 KB
  rows:    1,647

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-06-30 00:00:00	ES	Futures	2241.36	2242.44	2240.27	2240.54	4410.0
2016-06-30 01:00:00	ES	Futures	2240.81	2241.08	2235.39	2237.29	15303.0
2016-06-30 02:00:00	ES	Futures	2237.29	2237.29	2233.76	2236.2	17528.0
2016-06-30 03:00:00	ES	Futures	2236.2	2244.07	2230.78	2242.71	56991.0
2016-06-30 04:00:00	ES	Futures	2242.71	2245.97	2240.54	2242.98	36993.0
2016-06-30 05:00:00	ES	Futures	2242.98	2248.95	2241.63	2248.14	31906.0
2016-06-30 06:00:00	ES	Futures	2247.86	2249.49	2245.97	2246.51	23785.0
2016-06-30 07:00:00	ES	Futures	2246.51	2246.78	2239.73	2240.54	31641.0
2016-06-30 08:00:00	ES	Futures	2240.54	2243.25	2237.29	2242.71	45816.0
2016-06-30 09:00:00	ES	Futures	2242.71	2244.34	2235.66	2237.02	221940.0
2016-06-30 10:00:00	ES	Futures	2236.75	2247.86	2235.66	2247.86	293005.0
2016-06-30 11:00:00	ES	Futures	2247.59	2254.1	2245.69	2251.93	276211.0
2016-06-30 12:00:00	ES	Futures	2251.66	2261.97	2251.12	2260.88	252848.0
2016-06-30 13:00:00	ES	Futures	2261.15	2262.24	2257.63	2260.34	149716.0
2016-06-30 14:00:00	ES	Futures	2260.34	2265.76	2259.53	2264.68	204763.0
2016-06-30 15:00:00	ES	Futures	2264.68	2268.47	2260.07	2268.2	402293.0
2016-06-30 16:00:00	ES	Futures	2267.93	2268.2	2263.05	2263.32	169376.0
2016-06-30 18:00:00	ES	Futures	2263.32	2265.49	2262.24	2262.78	9604.0
2016-06-30 19:00:00	ES	Futures	2262.78	2263.59	2261.69	2262.51	5815.0
2016-06-30 20:00:00	ES	Futures	2262.51	2264.95	2261.97	2264.68	8399.0
2016-06-30 21:00:00	ES	Futures	2264.41	2265.49	2263.86	2264.41	8504.0
2016-06-30 22:00:00	ES	Futures	2264.41	2264.95	2263.86	2264.95	2762.0
2016-06-30 23:00:00	ES	Futures	2264.95	2265.49	2264.41	2264.95	3990.0
2016-06-30 00:00:00	NQ	Futures	5198.32	5201.6	5197.42	5198.32	536.0
2016-06-30 01:00:00	NQ	Futures	5198.32	5199.21	5186.99	5189.67	1901.0
2016-06-30 02:00:00	NQ	Futures	5189.38	5189.38	5180.73	5188.18	1808.0
2016-06-30 03:00:00	NQ	Futures	5188.48	5204.58	5172.39	5201.89	5341.0
2016-06-30 04:00:00	NQ	Futures	5202.19	5212.33	5197.13	5203.38	3625.0
2016-06-30 05:00:00	NQ	Futures	5203.38	5215.31	5198.32	5212.92	2279.0
2016-06-30 06:00:00	NQ	Futures	5212.33	5216.5	5207.26	5209.64	2049.0
2016-06-30 07:00:00	NQ	Futures	5209.94	5211.73	5196.83	5198.02	2869.0
2016-06-30 08:00:00	NQ	Futures	5198.02	5202.19	5188.48	5201.3	4941.0
2016-06-30 09:00:00	NQ	Futures	5201.6	5211.43	5187.59	5191.16	29840.0
2016-06-30 10:00:00	NQ	Futures	5190.87	5214.71	5184.61	5214.11	35683.0
2016-06-30 11:00:00	NQ	Futures	5214.11	5232.59	5208.75	5227.23	35058.0
2016-06-30 12:00:00	NQ	Futures	5227.23	5244.52	5223.35	5241.53	29562.0
2016-06-30 13:00:00	NQ	Futures	5241.83	5244.52	5232.0	5239.45	14120.0
2016-06-30 14:00:00	NQ	Futures	5239.15	5252.26	5238.26	5250.77	21519.0
2016-06-30 15:00:00	NQ	Futures	5250.77	5258.23	5241.24	5257.63	32299.0
2016-06-30 16:00:00	NQ	Futures	5257.03	5257.93	5246.01	5246.3	10486.0
2016-06-30 18:00:00	NQ	Futures	5242.13	5249.88	5242.13	5242.73	639.0
2016-06-30 19:00:00	NQ	Futures	5242.13	5244.52	5240.64	5240.94	448.0
2016-06-30 20:00:00	NQ	Futures	5241.83	5248.39	5240.64	5246.01	708.0
2016-06-30 21:00:00	NQ	Futures	5246.01	5248.99	5244.22	5244.52	631.0
2016-06-30 22:00:00	NQ	Futures	5244.52	5246.9	5244.22	5246.9	194.0
2016-06-30 23:00:00	NQ	Futures	5247.2	5248.09	5245.71	5246.9	293.0
2016-06-30 00:00:00	YM	Futures	18972.4	18977.8	18964.9	18964.9	515.0
2016-06-30 01:00:00	YM	Futures	18966.0	18968.1	18926.1	18940.1	2736.0
2016-06-30 02:00:00	YM	Futures	18939.1	18940.1	18913.2	18934.8	1711.0
2016-06-30 03:00:00	YM	Futures	18933.7	18998.2	18894.9	18988.6	7603.0

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

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