PREVIEW / futures_1hour / 2015-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-30.parquet
  size:    50 KB
  rows:    1,545

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-30 00:00:00	ES	Futures	2234.36	2235.42	2234.09	2235.42	1473.0
2015-07-30 01:00:00	ES	Futures	2235.42	2236.75	2234.62	2235.95	2197.0
2015-07-30 02:00:00	ES	Futures	2236.22	2237.28	2235.15	2235.95	5075.0
2015-07-30 03:00:00	ES	Futures	2236.22	2236.75	2232.49	2232.49	21876.0
2015-07-30 04:00:00	ES	Futures	2232.49	2234.89	2231.69	2234.89	17807.0
2015-07-30 05:00:00	ES	Futures	2234.89	2238.08	2233.82	2237.28	13410.0
2015-07-30 06:00:00	ES	Futures	2237.55	2240.21	2237.02	2238.35	15079.0
2015-07-30 07:00:00	ES	Futures	2238.35	2239.15	2235.95	2237.02	10392.0
2015-07-30 08:00:00	ES	Futures	2237.02	2237.28	2229.56	2231.43	54544.0
2015-07-30 09:00:00	ES	Futures	2231.43	2234.89	2223.44	2225.04	238397.0
2015-07-30 10:00:00	ES	Futures	2225.3	2233.02	2223.71	2227.43	208075.0
2015-07-30 11:00:00	ES	Futures	2227.43	2237.02	2225.57	2235.69	181958.0
2015-07-30 12:00:00	ES	Futures	2235.42	2238.62	2234.62	2238.62	84236.0
2015-07-30 13:00:00	ES	Futures	2238.35	2239.68	2235.15	2236.22	103709.0
2015-07-30 14:00:00	ES	Futures	2236.22	2239.41	2235.42	2239.15	69044.0
2015-07-30 15:00:00	ES	Futures	2238.88	2240.75	2238.08	2238.08	175898.0
2015-07-30 16:00:00	ES	Futures	2238.08	2241.01	2237.82	2239.95	60538.0
2015-07-30 17:00:00	ES	Futures	2239.95	2240.21	2238.62	2238.88	1686.0
2015-07-30 18:00:00	ES	Futures	2238.35	2238.88	2237.55	2238.62	2432.0
2015-07-30 19:00:00	ES	Futures	2238.62	2238.88	2237.82	2238.62	1661.0
2015-07-30 20:00:00	ES	Futures	2238.88	2239.41	2238.08	2239.15	2091.0
2015-07-30 21:00:00	ES	Futures	2239.15	2239.15	2238.35	2239.15	1919.0
2015-07-30 22:00:00	ES	Futures	2239.15	2239.95	2238.62	2239.41	2504.0
2015-07-30 23:00:00	ES	Futures	2239.68	2239.68	2238.08	2238.62	2968.0
2015-07-30 00:00:00	NQ	Futures	5396.97	5400.23	5396.68	5400.23	220.0
2015-07-30 01:00:00	NQ	Futures	5399.93	5403.48	5398.16	5402.0	322.0
2015-07-30 02:00:00	NQ	Futures	5402.59	5405.55	5399.93	5402.0	613.0
2015-07-30 03:00:00	NQ	Futures	5402.3	5404.37	5392.54	5392.83	2555.0
2015-07-30 04:00:00	NQ	Futures	5392.83	5400.52	5391.06	5400.23	1884.0
2015-07-30 05:00:00	NQ	Futures	5400.52	5409.99	5398.45	5408.51	2126.0
2015-07-30 06:00:00	NQ	Futures	5408.21	5416.2	5407.92	5410.58	2506.0
2015-07-30 07:00:00	NQ	Futures	5410.28	5412.06	5404.07	5406.73	1731.0
2015-07-30 08:00:00	NQ	Futures	5406.44	5406.73	5391.35	5395.49	7177.0
2015-07-30 09:00:00	NQ	Futures	5395.2	5402.59	5364.73	5365.92	43336.0
2015-07-30 10:00:00	NQ	Futures	5365.92	5392.24	5360.59	5381.0	39123.0
2015-07-30 11:00:00	NQ	Futures	5380.71	5416.5	5374.79	5415.61	34937.0
2015-07-30 12:00:00	NQ	Futures	5415.61	5433.06	5411.76	5432.76	19359.0
2015-07-30 13:00:00	NQ	Futures	5432.47	5439.86	5427.44	5429.21	18684.0
2015-07-30 14:00:00	NQ	Futures	5429.51	5438.68	5428.62	5435.43	13791.0
2015-07-30 15:00:00	NQ	Futures	5435.72	5441.05	5430.4	5430.69	23779.0
2015-07-30 16:00:00	NQ	Futures	5430.99	5438.68	5428.92	5436.61	6446.0
2015-07-30 17:00:00	NQ	Futures	5436.61	5436.91	5432.17	5432.47	356.0
2015-07-30 18:00:00	NQ	Futures	5429.81	5430.99	5428.33	5429.51	733.0
2015-07-30 19:00:00	NQ	Futures	5429.51	5430.1	5427.74	5430.1	321.0
2015-07-30 20:00:00	NQ	Futures	5430.1	5432.17	5427.44	5431.29	477.0
2015-07-30 21:00:00	NQ	Futures	5430.99	5431.29	5428.92	5430.69	365.0
2015-07-30 22:00:00	NQ	Futures	5430.99	5433.36	5429.21	5432.47	529.0
2015-07-30 23:00:00	NQ	Futures	5432.47	5432.76	5428.33	5429.51	419.0
2015-07-30 00:00:00	YM	Futures	18595.7	18608.3	18595.7	18607.3	236.0
2015-07-30 01:00:00	YM	Futures	18607.3	18614.6	18599.9	18612.5	460.0

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

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