PREVIEW / futures_1hour / 2015-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-25.parquet
  size:    29 KB
  rows:    836

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-05-25 00:00:00	ES	Futures	2245.27	2246.06	2245.0	2245.53	985.0
2015-05-25 01:00:00	ES	Futures	2245.53	2245.79	2244.47	2245.0	1336.0
2015-05-25 02:00:00	ES	Futures	2245.0	2245.79	2244.74	2245.27	858.0
2015-05-25 03:00:00	ES	Futures	2245.27	2245.53	2242.89	2242.89	2095.0
2015-05-25 04:00:00	ES	Futures	2242.89	2243.68	2241.83	2242.1	1508.0
2015-05-25 05:00:00	ES	Futures	2241.83	2241.83	2238.13	2238.13	3941.0
2015-05-25 06:00:00	ES	Futures	2238.13	2239.45	2238.13	2238.4	1487.0
2015-05-25 07:00:00	ES	Futures	2238.13	2240.25	2238.13	2239.98	1438.0
2015-05-25 08:00:00	ES	Futures	2240.25	2241.3	2239.98	2240.78	1513.0
2015-05-25 09:00:00	ES	Futures	2240.78	2242.62	2240.78	2242.36	2859.0
2015-05-25 10:00:00	ES	Futures	2242.36	2244.21	2242.36	2243.94	3008.0
2015-05-25 11:00:00	ES	Futures	2243.94	2245.79	2243.68	2244.47	3715.0
2015-05-25 12:00:00	ES	Futures	2244.74	2244.74	2242.1	2242.1	2963.0
2015-05-25 18:00:00	ES	Futures	2242.89	2243.15	2239.98	2241.04	2662.0
2015-05-25 19:00:00	ES	Futures	2241.3	2242.36	2240.51	2242.36	849.0
2015-05-25 20:00:00	ES	Futures	2242.36	2242.36	2238.66	2240.78	5767.0
2015-05-25 21:00:00	ES	Futures	2240.78	2241.04	2239.19	2239.45	2143.0
2015-05-25 22:00:00	ES	Futures	2239.45	2240.51	2239.19	2240.51	2257.0
2015-05-25 23:00:00	ES	Futures	2240.78	2241.57	2239.72	2241.04	2492.0
2015-05-25 00:00:00	NQ	Futures	5324.9	5327.84	5324.61	5325.49	114.0
2015-05-25 01:00:00	NQ	Futures	5326.67	5326.96	5323.14	5323.73	186.0
2015-05-25 02:00:00	NQ	Futures	5324.02	5325.49	5323.73	5325.2	148.0
2015-05-25 03:00:00	NQ	Futures	5325.49	5326.37	5319.02	5319.32	405.0
2015-05-25 04:00:00	NQ	Futures	5319.32	5323.14	5319.02	5321.37	423.0
2015-05-25 05:00:00	NQ	Futures	5320.49	5321.96	5314.02	5314.32	545.0
2015-05-25 06:00:00	NQ	Futures	5313.73	5316.96	5313.73	5315.2	312.0
2015-05-25 07:00:00	NQ	Futures	5315.2	5319.02	5314.9	5318.14	301.0
2015-05-25 08:00:00	NQ	Futures	5318.43	5320.49	5317.26	5318.14	280.0
2015-05-25 09:00:00	NQ	Futures	5318.73	5326.08	5318.14	5326.08	671.0
2015-05-25 10:00:00	NQ	Futures	5325.78	5330.78	5325.78	5329.61	1028.0
2015-05-25 11:00:00	NQ	Futures	5329.61	5338.43	5329.31	5332.55	1253.0
2015-05-25 12:00:00	NQ	Futures	5332.55	5333.14	5321.67	5323.73	1264.0
2015-05-25 18:00:00	NQ	Futures	5324.02	5324.9	5317.84	5321.08	421.0
2015-05-25 19:00:00	NQ	Futures	5320.79	5324.02	5318.73	5323.43	124.0
2015-05-25 20:00:00	NQ	Futures	5323.14	5323.14	5315.2	5319.61	637.0
2015-05-25 21:00:00	NQ	Futures	5319.61	5320.2	5316.37	5316.67	294.0
2015-05-25 22:00:00	NQ	Futures	5316.37	5319.02	5315.79	5318.73	212.0
2015-05-25 23:00:00	NQ	Futures	5318.73	5321.67	5316.96	5319.9	472.0
2015-05-25 00:00:00	YM	Futures	19120.3	19125.6	19119.3	19121.4	131.0
2015-05-25 01:00:00	YM	Futures	19121.4	19124.5	19113.0	19117.2	205.0
2015-05-25 02:00:00	YM	Futures	19118.2	19125.6	19115.1	19120.3	163.0
2015-05-25 03:00:00	YM	Futures	19120.3	19123.5	19102.5	19103.6	410.0
2015-05-25 04:00:00	YM	Futures	19103.6	19109.9	19097.3	19098.3	258.0
2015-05-25 05:00:00	YM	Futures	19097.3	19097.3	19066.9	19067.9	833.0
2015-05-25 06:00:00	YM	Futures	19069.0	19080.5	19065.8	19072.1	568.0
2015-05-25 07:00:00	YM	Futures	19073.1	19095.2	19071.1	19091.0	1018.0
2015-05-25 08:00:00	YM	Futures	19092.0	19098.3	19087.8	19093.1	546.0
2015-05-25 09:00:00	YM	Futures	19094.1	19110.9	19093.1	19107.8	845.0
2015-05-25 10:00:00	YM	Futures	19109.9	19131.9	19109.9	19124.5	966.0
2015-05-25 11:00:00	YM	Futures	19126.6	19142.4	19126.6	19130.8	1123.0

> showing 50 of 836 rows — these rows as CSV

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