PREVIEW / futures_1hour / 2016-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-24.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-05-24 00:00:00	ES	Futures	2209.52	2209.79	2208.71	2209.25	1413.0
2016-05-24 01:00:00	ES	Futures	2209.25	2209.25	2205.74	2205.74	6589.0
2016-05-24 02:00:00	ES	Futures	2206.01	2206.82	2204.39	2205.74	14061.0
2016-05-24 03:00:00	ES	Futures	2206.01	2213.57	2204.39	2211.41	32094.0
2016-05-24 04:00:00	ES	Futures	2211.14	2214.65	2211.14	2213.3	22655.0
2016-05-24 05:00:00	ES	Futures	2213.03	2217.08	2212.22	2215.73	20761.0
2016-05-24 06:00:00	ES	Futures	2216.0	2217.08	2214.38	2215.73	15232.0
2016-05-24 07:00:00	ES	Futures	2216.0	2218.16	2215.73	2217.08	20046.0
2016-05-24 08:00:00	ES	Futures	2217.08	2222.48	2216.81	2221.13	49796.0
2016-05-24 09:00:00	ES	Futures	2220.86	2230.57	2220.05	2228.41	252888.0
2016-05-24 10:00:00	ES	Futures	2228.68	2237.59	2228.14	2236.24	315584.0
2016-05-24 11:00:00	ES	Futures	2235.97	2238.67	2234.89	2238.4	185966.0
2016-05-24 12:00:00	ES	Futures	2238.4	2239.21	2236.24	2239.21	101398.0
2016-05-24 13:00:00	ES	Futures	2239.21	2240.29	2235.97	2236.78	105859.0
2016-05-24 14:00:00	ES	Futures	2237.05	2239.75	2235.7	2238.13	104429.0
2016-05-24 15:00:00	ES	Futures	2238.13	2243.26	2238.13	2238.67	236159.0
2016-05-24 16:00:00	ES	Futures	2238.67	2241.91	2238.4	2240.83	82375.0
2016-05-24 18:00:00	ES	Futures	2240.83	2242.45	2239.21	2242.45	4420.0
2016-05-24 19:00:00	ES	Futures	2242.18	2245.69	2241.91	2244.34	9448.0
2016-05-24 20:00:00	ES	Futures	2244.34	2244.61	2241.91	2244.07	7906.0
2016-05-24 21:00:00	ES	Futures	2244.07	2244.61	2242.72	2244.07	6840.0
2016-05-24 22:00:00	ES	Futures	2244.07	2244.61	2242.99	2244.07	3109.0
2016-05-24 23:00:00	ES	Futures	2244.07	2245.69	2243.8	2245.42	4974.0
2016-05-24 00:00:00	NQ	Futures	5180.59	5181.18	5178.5	5179.99	427.0
2016-05-24 01:00:00	NQ	Futures	5179.69	5179.99	5172.55	5173.15	657.0
2016-05-24 02:00:00	NQ	Futures	5172.85	5174.34	5168.09	5172.26	1746.0
2016-05-24 03:00:00	NQ	Futures	5172.26	5191.6	5167.2	5185.35	4634.0
2016-05-24 04:00:00	NQ	Futures	5185.05	5195.46	5184.75	5191.3	2227.0
2016-05-24 05:00:00	NQ	Futures	5191.0	5201.12	5188.62	5197.84	2227.0
2016-05-24 06:00:00	NQ	Futures	5197.84	5201.71	5193.98	5197.84	1697.0
2016-05-24 07:00:00	NQ	Futures	5197.84	5204.09	5197.55	5202.31	1437.0
2016-05-24 08:00:00	NQ	Futures	5202.6	5215.4	5201.71	5212.72	5598.0
2016-05-24 09:00:00	NQ	Futures	5212.42	5243.37	5209.75	5237.71	39149.0
2016-05-24 10:00:00	NQ	Futures	5238.01	5269.55	5238.01	5268.06	46677.0
2016-05-24 11:00:00	NQ	Futures	5268.06	5279.37	5265.68	5279.07	27519.0
2016-05-24 12:00:00	NQ	Futures	5279.07	5281.45	5272.82	5281.15	15779.0
2016-05-24 13:00:00	NQ	Futures	5281.15	5283.83	5276.39	5281.15	17318.0
2016-05-24 14:00:00	NQ	Futures	5281.15	5288.89	5278.47	5284.43	17699.0
2016-05-24 15:00:00	NQ	Futures	5284.43	5294.54	5283.23	5288.0	37095.0
2016-05-24 16:00:00	NQ	Futures	5288.0	5293.35	5286.51	5290.97	6628.0
2016-05-24 18:00:00	NQ	Futures	5290.67	5295.14	5287.7	5295.14	730.0
2016-05-24 19:00:00	NQ	Futures	5295.14	5302.57	5294.84	5299.9	1125.0
2016-05-24 20:00:00	NQ	Futures	5299.9	5302.57	5293.65	5300.79	1245.0
2016-05-24 21:00:00	NQ	Futures	5300.49	5303.76	5298.11	5302.28	1250.0
2016-05-24 22:00:00	NQ	Futures	5302.87	5303.47	5300.19	5301.98	445.0
2016-05-24 23:00:00	NQ	Futures	5301.68	5307.33	5301.68	5305.85	834.0
2016-05-24 00:00:00	YM	Futures	18699.7	18700.8	18692.2	18696.5	291.0
2016-05-24 01:00:00	YM	Futures	18696.5	18696.5	18675.1	18677.2	1020.0
2016-05-24 02:00:00	YM	Futures	18676.2	18689.0	18663.3	18681.5	1897.0
2016-05-24 03:00:00	YM	Futures	18682.6	18744.7	18670.8	18728.6	6040.0

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

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