PREVIEW / futures_1hour / 2016-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-18.parquet
  size:    53 KB
  rows:    1,593

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-04-18 00:00:00	ES	Futures	2227.6	2227.87	2226.79	2227.6	2253.0
2016-04-18 01:00:00	ES	Futures	2227.6	2227.6	2225.18	2226.52	6058.0
2016-04-18 02:00:00	ES	Futures	2226.52	2227.6	2223.02	2224.37	22692.0
2016-04-18 03:00:00	ES	Futures	2224.37	2232.73	2223.83	2231.38	44898.0
2016-04-18 04:00:00	ES	Futures	2231.38	2235.43	2229.49	2234.89	31057.0
2016-04-18 05:00:00	ES	Futures	2234.62	2237.05	2232.73	2235.7	24590.0
2016-04-18 06:00:00	ES	Futures	2235.97	2238.4	2233.0	2233.81	28467.0
2016-04-18 07:00:00	ES	Futures	2234.08	2234.89	2232.19	2233.27	18330.0
2016-04-18 08:00:00	ES	Futures	2233.27	2234.62	2230.57	2232.46	39172.0
2016-04-18 09:00:00	ES	Futures	2232.19	2240.02	2230.3	2239.21	194784.0
2016-04-18 10:00:00	ES	Futures	2238.94	2250.82	2238.94	2248.39	246701.0
2016-04-18 11:00:00	ES	Futures	2248.39	2250.55	2247.58	2248.93	117855.0
2016-04-18 12:00:00	ES	Futures	2248.93	2253.79	2248.66	2251.36	102971.0
2016-04-18 13:00:00	ES	Futures	2251.63	2252.71	2248.93	2252.17	85048.0
2016-04-18 14:00:00	ES	Futures	2252.17	2255.14	2249.74	2253.52	104977.0
2016-04-18 15:00:00	ES	Futures	2253.52	2255.68	2251.9	2255.41	173436.0
2016-04-18 16:00:00	ES	Futures	2255.14	2255.41	2252.17	2252.98	78373.0
2016-04-18 18:00:00	ES	Futures	2251.9	2253.25	2251.36	2252.98	4249.0
2016-04-18 19:00:00	ES	Futures	2253.25	2255.41	2252.98	2254.6	4116.0
2016-04-18 20:00:00	ES	Futures	2254.6	2254.87	2253.25	2254.6	6223.0
2016-04-18 21:00:00	ES	Futures	2254.6	2257.3	2254.06	2255.14	8627.0
2016-04-18 22:00:00	ES	Futures	2254.87	2255.41	2254.06	2255.41	3216.0
2016-04-18 23:00:00	ES	Futures	2255.41	2255.95	2253.79	2255.41	3983.0
2016-04-18 00:00:00	NQ	Futures	5364.46	5365.35	5363.27	5364.76	319.0
2016-04-18 01:00:00	NQ	Futures	5365.06	5365.65	5359.7	5362.97	863.0
2016-04-18 02:00:00	NQ	Futures	5362.38	5365.06	5356.72	5361.78	3394.0
2016-04-18 03:00:00	NQ	Futures	5361.78	5382.91	5357.91	5379.63	5044.0
2016-04-18 04:00:00	NQ	Futures	5379.63	5390.94	5373.09	5387.67	3346.0
2016-04-18 05:00:00	NQ	Futures	5387.67	5393.02	5381.42	5389.45	2141.0
2016-04-18 06:00:00	NQ	Futures	5389.45	5396.59	5385.29	5386.48	3154.0
2016-04-18 07:00:00	NQ	Futures	5386.78	5389.16	5381.12	5383.2	1938.0
2016-04-18 08:00:00	NQ	Futures	5383.5	5389.16	5378.44	5384.4	3254.0
2016-04-18 09:00:00	NQ	Futures	5384.1	5397.49	5378.44	5396.3	25803.0
2016-04-18 10:00:00	NQ	Futures	5396.3	5428.43	5396.0	5423.37	35301.0
2016-04-18 11:00:00	NQ	Futures	5423.37	5424.56	5401.95	5405.52	21082.0
2016-04-18 12:00:00	NQ	Futures	5405.82	5422.18	5405.22	5415.93	12607.0
2016-04-18 13:00:00	NQ	Futures	5415.93	5420.4	5407.3	5418.91	10141.0
2016-04-18 14:00:00	NQ	Futures	5418.61	5424.56	5413.26	5418.91	11796.0
2016-04-18 15:00:00	NQ	Futures	5418.91	5427.83	5414.15	5426.05	20029.0
2016-04-18 16:00:00	NQ	Futures	5426.35	5426.94	5407.3	5412.07	10477.0
2016-04-18 18:00:00	NQ	Futures	5409.69	5414.15	5408.2	5414.15	650.0
2016-04-18 19:00:00	NQ	Futures	5413.85	5420.99	5413.85	5418.61	540.0
2016-04-18 20:00:00	NQ	Futures	5418.02	5420.1	5416.23	5420.1	597.0
2016-04-18 21:00:00	NQ	Futures	5419.8	5425.16	5418.31	5419.5	1634.0
2016-04-18 22:00:00	NQ	Futures	5419.5	5420.69	5415.93	5420.1	623.0
2016-04-18 23:00:00	NQ	Futures	5420.1	5422.18	5414.45	5420.1	605.0
2016-04-18 00:00:00	YM	Futures	18963.0	18967.3	18960.9	18967.3	343.0
2016-04-18 01:00:00	YM	Futures	18967.3	18968.4	18952.3	18962.0	804.0
2016-04-18 02:00:00	YM	Futures	18959.8	18970.5	18938.4	18944.8	2871.0
2016-04-18 03:00:00	YM	Futures	18945.9	19002.6	18937.3	18993.0	5010.0

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

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