PREVIEW / futures_1hour / 2015-07-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	2249.8	2250.86	2249.27	2250.6	1302.0
2015-07-23 01:00:00	ES	Futures	2250.33	2250.6	2249.8	2250.06	1598.0
2015-07-23 02:00:00	ES	Futures	2249.8	2251.13	2249.27	2250.86	5937.0
2015-07-23 03:00:00	ES	Futures	2250.86	2251.13	2248.2	2249.27	16627.0
2015-07-23 04:00:00	ES	Futures	2249.0	2249.27	2246.34	2247.93	14852.0
2015-07-23 05:00:00	ES	Futures	2247.93	2249.0	2247.4	2249.0	6774.0
2015-07-23 06:00:00	ES	Futures	2248.73	2249.53	2247.4	2247.93	7245.0
2015-07-23 07:00:00	ES	Futures	2248.2	2249.0	2245.27	2247.4	20485.0
2015-07-23 08:00:00	ES	Futures	2247.14	2247.4	2244.74	2244.74	18661.0
2015-07-23 09:00:00	ES	Futures	2245.01	2247.67	2241.01	2242.61	149556.0
2015-07-23 10:00:00	ES	Futures	2242.61	2247.4	2241.01	2245.27	163446.0
2015-07-23 11:00:00	ES	Futures	2245.54	2246.07	2234.62	2235.69	180798.0
2015-07-23 12:00:00	ES	Futures	2235.42	2235.95	2231.43	2233.82	184138.0
2015-07-23 13:00:00	ES	Futures	2233.56	2238.08	2231.43	2237.28	125750.0
2015-07-23 14:00:00	ES	Futures	2237.55	2237.82	2230.89	2231.96	157014.0
2015-07-23 15:00:00	ES	Futures	2231.69	2232.76	2227.43	2231.96	265461.0
2015-07-23 16:00:00	ES	Futures	2231.96	2237.82	2231.43	2237.55	94509.0
2015-07-23 17:00:00	ES	Futures	2237.82	2238.35	2237.28	2238.08	2237.0
2015-07-23 18:00:00	ES	Futures	2237.55	2238.35	2236.75	2237.02	2951.0
2015-07-23 19:00:00	ES	Futures	2237.28	2237.28	2235.15	2235.95	2670.0
2015-07-23 20:00:00	ES	Futures	2236.49	2237.82	2236.22	2237.28	3550.0
2015-07-23 21:00:00	ES	Futures	2237.28	2237.82	2234.89	2235.15	4209.0
2015-07-23 22:00:00	ES	Futures	2235.15	2235.95	2234.62	2234.89	2765.0
2015-07-23 23:00:00	ES	Futures	2234.89	2234.89	2233.56	2234.09	3439.0
2015-07-23 00:00:00	NQ	Futures	5480.68	5483.05	5479.2	5483.05	312.0
2015-07-23 01:00:00	NQ	Futures	5482.46	5483.05	5480.39	5481.27	308.0
2015-07-23 02:00:00	NQ	Futures	5480.68	5483.64	5478.91	5481.27	746.0
2015-07-23 03:00:00	NQ	Futures	5481.57	5482.75	5475.95	5478.32	2248.0
2015-07-23 04:00:00	NQ	Futures	5478.32	5478.61	5469.74	5474.17	1983.0
2015-07-23 05:00:00	NQ	Futures	5474.17	5476.25	5472.7	5476.25	873.0
2015-07-23 06:00:00	NQ	Futures	5476.25	5479.79	5473.58	5475.95	1218.0
2015-07-23 07:00:00	NQ	Futures	5475.65	5477.72	5468.55	5471.81	2577.0
2015-07-23 08:00:00	NQ	Futures	5471.81	5472.1	5461.75	5462.05	3547.0
2015-07-23 09:00:00	NQ	Futures	5462.05	5473.29	5454.06	5462.05	28393.0
2015-07-23 10:00:00	NQ	Futures	5462.05	5481.27	5458.5	5478.91	25040.0
2015-07-23 11:00:00	NQ	Futures	5479.2	5481.87	5451.1	5453.77	22761.0
2015-07-23 12:00:00	NQ	Futures	5453.77	5454.95	5441.34	5447.55	23053.0
2015-07-23 13:00:00	NQ	Futures	5447.26	5458.79	5438.09	5455.54	16747.0
2015-07-23 14:00:00	NQ	Futures	5456.13	5457.02	5436.91	5438.98	22302.0
2015-07-23 15:00:00	NQ	Futures	5438.68	5439.27	5423.89	5437.79	35004.0
2015-07-23 16:00:00	NQ	Futures	5437.79	5481.27	5436.91	5481.27	16473.0
2015-07-23 17:00:00	NQ	Futures	5480.98	5483.05	5479.5	5482.16	490.0
2015-07-23 18:00:00	NQ	Futures	5482.16	5482.75	5478.02	5479.5	1000.0
2015-07-23 19:00:00	NQ	Futures	5479.2	5479.2	5473.58	5475.06	661.0
2015-07-23 20:00:00	NQ	Futures	5475.65	5480.39	5475.65	5477.72	696.0
2015-07-23 21:00:00	NQ	Futures	5478.02	5479.79	5471.81	5472.4	893.0
2015-07-23 22:00:00	NQ	Futures	5472.7	5474.47	5470.33	5471.22	472.0
2015-07-23 23:00:00	NQ	Futures	5470.92	5471.51	5466.78	5468.55	824.0
2015-07-23 00:00:00	YM	Futures	18767.4	18774.8	18761.1	18772.7	401.0
2015-07-23 01:00:00	YM	Futures	18772.7	18776.9	18767.4	18767.4	408.0

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

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