PREVIEW / futures_1hour / 2015-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-29.parquet
  size:    51 KB
  rows:    1,554

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
2015-07-29 00:00:00	ES	Futures	2220.24	2221.31	2219.98	2220.78	1210.0
2015-07-29 01:00:00	ES	Futures	2220.78	2221.84	2219.98	2221.58	2246.0
2015-07-29 02:00:00	ES	Futures	2221.31	2227.7	2220.78	2226.63	12119.0
2015-07-29 03:00:00	ES	Futures	2226.63	2227.97	2223.71	2225.84	20640.0
2015-07-29 04:00:00	ES	Futures	2225.57	2226.63	2221.84	2226.37	24787.0
2015-07-29 05:00:00	ES	Futures	2226.37	2229.3	2225.04	2228.23	18241.0
2015-07-29 06:00:00	ES	Futures	2228.23	2228.76	2225.84	2227.43	15300.0
2015-07-29 07:00:00	ES	Futures	2227.43	2229.83	2226.9	2228.23	22063.0
2015-07-29 08:00:00	ES	Futures	2228.23	2228.5	2222.11	2222.37	31591.0
2015-07-29 09:00:00	ES	Futures	2222.64	2227.7	2222.37	2225.84	150711.0
2015-07-29 10:00:00	ES	Futures	2225.84	2232.49	2223.71	2230.89	190718.0
2015-07-29 11:00:00	ES	Futures	2230.63	2235.15	2229.03	2234.62	150812.0
2015-07-29 12:00:00	ES	Futures	2234.62	2234.89	2230.89	2232.23	92243.0
2015-07-29 13:00:00	ES	Futures	2232.23	2233.29	2231.16	2231.43	66134.0
2015-07-29 14:00:00	ES	Futures	2231.69	2241.01	2227.17	2239.15	245581.0
2015-07-29 15:00:00	ES	Futures	2239.15	2240.21	2235.15	2237.82	247094.0
2015-07-29 16:00:00	ES	Futures	2237.55	2238.62	2236.22	2236.49	81556.0
2015-07-29 17:00:00	ES	Futures	2236.49	2237.55	2236.22	2237.55	1369.0
2015-07-29 18:00:00	ES	Futures	2235.95	2235.95	2233.82	2234.09	4747.0
2015-07-29 19:00:00	ES	Futures	2234.36	2235.15	2234.09	2234.89	1676.0
2015-07-29 20:00:00	ES	Futures	2234.89	2235.95	2234.36	2235.42	2835.0
2015-07-29 21:00:00	ES	Futures	2235.42	2235.69	2234.09	2234.62	2805.0
2015-07-29 22:00:00	ES	Futures	2234.62	2235.95	2234.36	2234.89	3227.0
2015-07-29 23:00:00	ES	Futures	2234.89	2234.89	2233.29	2234.09	2656.0
2015-07-29 00:00:00	NQ	Futures	5383.07	5384.55	5381.89	5383.96	314.0
2015-07-29 01:00:00	NQ	Futures	5384.25	5386.92	5381.59	5386.62	390.0
2015-07-29 02:00:00	NQ	Futures	5385.73	5401.41	5384.25	5399.64	1925.0
2015-07-29 03:00:00	NQ	Futures	5399.93	5406.14	5392.24	5397.27	2985.0
2015-07-29 04:00:00	NQ	Futures	5396.97	5401.71	5389.58	5399.93	3221.0
2015-07-29 05:00:00	NQ	Futures	5400.52	5406.73	5397.57	5403.78	2275.0
2015-07-29 06:00:00	NQ	Futures	5403.48	5405.26	5398.16	5402.59	2152.0
2015-07-29 07:00:00	NQ	Futures	5402.89	5410.28	5401.11	5405.85	3059.0
2015-07-29 08:00:00	NQ	Futures	5405.85	5406.73	5390.47	5390.47	5258.0
2015-07-29 09:00:00	NQ	Futures	5391.06	5405.26	5382.48	5386.03	30679.0
2015-07-29 10:00:00	NQ	Futures	5386.33	5402.3	5376.27	5396.38	33722.0
2015-07-29 11:00:00	NQ	Futures	5396.09	5403.78	5389.87	5401.71	21591.0
2015-07-29 12:00:00	NQ	Futures	5401.71	5402.89	5389.87	5396.09	12907.0
2015-07-29 13:00:00	NQ	Futures	5395.49	5398.45	5388.69	5390.47	9164.0
2015-07-29 14:00:00	NQ	Futures	5391.95	5418.27	5381.89	5412.65	44410.0
2015-07-29 15:00:00	NQ	Futures	5412.65	5416.79	5403.48	5407.62	33472.0
2015-07-29 16:00:00	NQ	Futures	5407.33	5409.99	5394.31	5401.71	10160.0
2015-07-29 17:00:00	NQ	Futures	5401.11	5407.62	5400.52	5406.44	404.0
2015-07-29 18:00:00	NQ	Futures	5398.45	5399.93	5394.31	5394.31	746.0
2015-07-29 19:00:00	NQ	Futures	5395.2	5396.97	5394.31	5396.97	231.0
2015-07-29 20:00:00	NQ	Futures	5396.68	5398.45	5395.2	5396.97	329.0
2015-07-29 21:00:00	NQ	Futures	5397.86	5398.45	5395.2	5397.57	650.0
2015-07-29 22:00:00	NQ	Futures	5397.57	5401.41	5397.27	5398.75	532.0
2015-07-29 23:00:00	NQ	Futures	5398.45	5399.04	5394.61	5396.38	326.0
2015-07-29 00:00:00	YM	Futures	18464.0	18471.4	18464.0	18468.2	171.0
2015-07-29 01:00:00	YM	Futures	18469.3	18474.5	18460.8	18474.5	299.0

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

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