PREVIEW / futures_1hour / 2015-07-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	2243.67	2243.67	2242.88	2242.88	1863.0
2015-07-22 01:00:00	ES	Futures	2242.88	2243.41	2242.34	2242.34	2196.0
2015-07-22 02:00:00	ES	Futures	2242.34	2243.41	2241.28	2242.88	10451.0
2015-07-22 03:00:00	ES	Futures	2242.88	2244.74	2241.28	2244.47	19451.0
2015-07-22 04:00:00	ES	Futures	2244.47	2245.01	2243.67	2244.21	14923.0
2015-07-22 05:00:00	ES	Futures	2244.21	2245.01	2242.88	2242.88	8504.0
2015-07-22 06:00:00	ES	Futures	2243.14	2243.67	2242.61	2242.61	9615.0
2015-07-22 07:00:00	ES	Futures	2242.88	2243.94	2241.01	2241.01	14616.0
2015-07-22 08:00:00	ES	Futures	2241.28	2241.81	2239.41	2240.75	31577.0
2015-07-22 09:00:00	ES	Futures	2240.48	2247.93	2238.88	2247.4	258799.0
2015-07-22 10:00:00	ES	Futures	2247.4	2249.27	2242.34	2246.6	202300.0
2015-07-22 11:00:00	ES	Futures	2246.6	2246.87	2241.54	2243.67	122785.0
2015-07-22 12:00:00	ES	Futures	2243.41	2245.01	2240.48	2242.61	91371.0
2015-07-22 13:00:00	ES	Futures	2242.34	2244.47	2241.81	2243.41	65245.0
2015-07-22 14:00:00	ES	Futures	2243.41	2246.07	2242.34	2245.8	111207.0
2015-07-22 15:00:00	ES	Futures	2245.8	2246.07	2239.68	2244.47	180078.0
2015-07-22 16:00:00	ES	Futures	2244.21	2247.67	2242.61	2247.67	52445.0
2015-07-22 17:00:00	ES	Futures	2247.4	2247.67	2246.34	2247.14	2226.0
2015-07-22 18:00:00	ES	Futures	2246.34	2247.67	2246.07	2246.87	2607.0
2015-07-22 19:00:00	ES	Futures	2246.87	2247.93	2246.6	2247.67	1250.0
2015-07-22 20:00:00	ES	Futures	2247.4	2249.8	2247.4	2248.2	6130.0
2015-07-22 21:00:00	ES	Futures	2248.2	2250.86	2247.67	2249.8	5308.0
2015-07-22 22:00:00	ES	Futures	2250.06	2250.6	2248.73	2249.0	2395.0
2015-07-22 23:00:00	ES	Futures	2249.0	2249.8	2248.47	2249.8	1924.0
2015-07-22 00:00:00	NQ	Futures	5456.43	5456.72	5449.33	5452.58	785.0
2015-07-22 01:00:00	NQ	Futures	5452.58	5454.36	5450.22	5450.81	794.0
2015-07-22 02:00:00	NQ	Futures	5450.81	5457.61	5449.92	5456.72	1746.0
2015-07-22 03:00:00	NQ	Futures	5456.72	5458.79	5447.85	5458.5	3007.0
2015-07-22 04:00:00	NQ	Futures	5457.91	5465.6	5454.95	5463.82	2549.0
2015-07-22 05:00:00	NQ	Futures	5463.82	5466.19	5460.57	5460.86	1183.0
2015-07-22 06:00:00	NQ	Futures	5461.16	5464.41	5459.68	5459.98	2254.0
2015-07-22 07:00:00	NQ	Futures	5460.27	5460.86	5449.62	5449.92	3235.0
2015-07-22 08:00:00	NQ	Futures	5449.92	5450.51	5439.86	5441.93	6140.0
2015-07-22 09:00:00	NQ	Futures	5442.23	5480.39	5429.21	5478.91	66197.0
2015-07-22 10:00:00	NQ	Futures	5479.2	5485.71	5459.39	5473.58	38546.0
2015-07-22 11:00:00	NQ	Futures	5473.88	5474.47	5455.54	5461.46	18755.0
2015-07-22 12:00:00	NQ	Futures	5461.46	5464.71	5448.74	5458.79	14056.0
2015-07-22 13:00:00	NQ	Futures	5459.09	5466.19	5457.61	5462.93	10624.0
2015-07-22 14:00:00	NQ	Futures	5462.64	5470.92	5457.91	5469.44	20210.0
2015-07-22 15:00:00	NQ	Futures	5469.44	5470.33	5449.33	5460.86	27042.0
2015-07-22 16:00:00	NQ	Futures	5461.16	5468.85	5457.31	5468.85	7016.0
2015-07-22 17:00:00	NQ	Futures	5468.55	5469.74	5467.37	5469.74	285.0
2015-07-22 18:00:00	NQ	Futures	5468.26	5475.36	5466.48	5470.63	1117.0
2015-07-22 19:00:00	NQ	Futures	5470.63	5473.88	5469.74	5473.29	193.0
2015-07-22 20:00:00	NQ	Futures	5472.7	5477.43	5470.33	5472.4	744.0
2015-07-22 21:00:00	NQ	Futures	5472.7	5479.2	5471.22	5477.43	706.0
2015-07-22 22:00:00	NQ	Futures	5477.72	5479.5	5477.43	5478.32	670.0
2015-07-22 23:00:00	NQ	Futures	5478.02	5480.98	5477.72	5480.39	488.0
2015-07-22 00:00:00	YM	Futures	18748.4	18749.5	18740.0	18745.3	216.0
2015-07-22 01:00:00	YM	Futures	18746.3	18749.5	18741.1	18741.1	209.0

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

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