PREVIEW / futures_1hour / 2015-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-01.parquet
  size:    50 KB
  rows:    1,530

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-06-01 00:00:00	ES	Futures	2228.63	2229.68	2228.36	2229.15	1414.0
2015-06-01 01:00:00	ES	Futures	2229.42	2231.27	2228.63	2231.27	3781.0
2015-06-01 02:00:00	ES	Futures	2231.27	2231.53	2229.15	2229.95	9697.0
2015-06-01 03:00:00	ES	Futures	2229.95	2233.38	2229.15	2232.32	20309.0
2015-06-01 04:00:00	ES	Futures	2232.06	2232.32	2225.98	2228.63	25213.0
2015-06-01 05:00:00	ES	Futures	2228.89	2229.15	2222.82	2224.14	23286.0
2015-06-01 06:00:00	ES	Futures	2224.4	2229.95	2223.34	2223.34	20033.0
2015-06-01 07:00:00	ES	Futures	2223.61	2235.23	2223.34	2232.85	35081.0
2015-06-01 08:00:00	ES	Futures	2233.12	2233.12	2229.68	2231.27	31811.0
2015-06-01 09:00:00	ES	Futures	2231.27	2234.7	2222.29	2226.25	184446.0
2015-06-01 10:00:00	ES	Futures	2226.25	2230.74	2218.85	2226.25	318246.0
2015-06-01 11:00:00	ES	Futures	2225.98	2229.15	2223.08	2224.4	123964.0
2015-06-01 12:00:00	ES	Futures	2224.66	2233.91	2224.14	2233.64	109156.0
2015-06-01 13:00:00	ES	Futures	2233.64	2234.7	2231.8	2234.17	76448.0
2015-06-01 14:00:00	ES	Futures	2234.17	2237.34	2233.12	2235.49	87004.0
2015-06-01 15:00:00	ES	Futures	2235.23	2236.29	2227.83	2228.63	175330.0
2015-06-01 16:00:00	ES	Futures	2228.89	2230.47	2227.83	2229.95	62923.0
2015-06-01 17:00:00	ES	Futures	2230.21	2230.74	2229.68	2230.74	1287.0
2015-06-01 18:00:00	ES	Futures	2230.21	2231.27	2229.42	2229.68	1828.0
2015-06-01 19:00:00	ES	Futures	2229.68	2230.74	2229.68	2230.21	697.0
2015-06-01 20:00:00	ES	Futures	2230.21	2231.27	2229.42	2230.74	2762.0
2015-06-01 21:00:00	ES	Futures	2231.0	2232.06	2230.74	2231.53	5424.0
2015-06-01 22:00:00	ES	Futures	2231.8	2231.8	2227.31	2228.63	8094.0
2015-06-01 23:00:00	ES	Futures	2228.63	2229.15	2227.31	2227.83	1953.0
2015-06-01 00:00:00	NQ	Futures	5318.73	5320.79	5317.84	5319.61	289.0
2015-06-01 01:00:00	NQ	Futures	5319.9	5324.02	5317.84	5323.43	670.0
2015-06-01 02:00:00	NQ	Futures	5323.43	5324.61	5317.84	5320.2	1462.0
2015-06-01 03:00:00	NQ	Futures	5319.9	5330.49	5316.96	5326.67	3437.0
2015-06-01 04:00:00	NQ	Futures	5326.37	5326.96	5309.02	5316.37	4448.0
2015-06-01 05:00:00	NQ	Futures	5316.67	5318.43	5300.79	5305.79	3254.0
2015-06-01 06:00:00	NQ	Futures	5305.79	5322.26	5302.55	5306.08	3913.0
2015-06-01 07:00:00	NQ	Futures	5306.08	5338.14	5305.79	5335.78	7064.0
2015-06-01 08:00:00	NQ	Futures	5335.19	5335.49	5328.14	5330.78	7678.0
2015-06-01 09:00:00	NQ	Futures	5330.78	5335.49	5288.73	5297.55	35756.0
2015-06-01 10:00:00	NQ	Futures	5298.14	5309.91	5276.68	5304.32	53787.0
2015-06-01 11:00:00	NQ	Futures	5304.61	5316.08	5300.5	5303.14	24047.0
2015-06-01 12:00:00	NQ	Futures	5302.85	5331.37	5302.26	5329.9	21196.0
2015-06-01 13:00:00	NQ	Futures	5330.2	5333.14	5324.31	5331.37	11079.0
2015-06-01 14:00:00	NQ	Futures	5331.37	5335.19	5326.67	5331.67	10386.0
2015-06-01 15:00:00	NQ	Futures	5331.67	5334.31	5314.61	5319.02	20102.0
2015-06-01 16:00:00	NQ	Futures	5319.02	5323.73	5317.26	5322.84	4573.0
2015-06-01 17:00:00	NQ	Futures	5322.55	5324.02	5322.26	5323.43	155.0
2015-06-01 18:00:00	NQ	Futures	5323.43	5324.61	5320.49	5321.67	286.0
2015-06-01 19:00:00	NQ	Futures	5321.96	5324.31	5321.96	5323.43	164.0
2015-06-01 20:00:00	NQ	Futures	5323.43	5326.08	5321.37	5325.49	369.0
2015-06-01 21:00:00	NQ	Futures	5325.78	5328.14	5324.9	5325.49	810.0
2015-06-01 22:00:00	NQ	Futures	5325.2	5325.2	5316.37	5319.61	1086.0
2015-06-01 23:00:00	NQ	Futures	5319.02	5320.49	5316.08	5317.55	272.0
2015-06-01 00:00:00	YM	Futures	18922.1	18927.4	18917.9	18927.4	326.0
2015-06-01 01:00:00	YM	Futures	18926.3	18944.2	18922.1	18942.1	762.0

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

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