PREVIEW / futures_1hour / 2016-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-25.parquet
  size:    52 KB
  rows:    1,604

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
2016-04-25 00:00:00	ES	Futures	2249.74	2249.74	2247.58	2248.12	2580.0
2016-04-25 01:00:00	ES	Futures	2248.39	2251.36	2247.85	2250.82	3209.0
2016-04-25 02:00:00	ES	Futures	2250.55	2252.17	2248.93	2250.55	8396.0
2016-04-25 03:00:00	ES	Futures	2250.55	2252.44	2241.91	2242.45	41951.0
2016-04-25 04:00:00	ES	Futures	2242.45	2244.07	2239.75	2242.72	35697.0
2016-04-25 05:00:00	ES	Futures	2242.72	2251.9	2242.18	2251.63	30040.0
2016-04-25 06:00:00	ES	Futures	2251.63	2252.44	2249.47	2250.55	22474.0
2016-04-25 07:00:00	ES	Futures	2250.28	2251.36	2247.85	2248.66	22584.0
2016-04-25 08:00:00	ES	Futures	2248.93	2249.74	2245.15	2247.04	29713.0
2016-04-25 09:00:00	ES	Futures	2247.31	2248.66	2241.1	2243.26	160519.0
2016-04-25 10:00:00	ES	Futures	2243.26	2244.88	2237.59	2238.4	214051.0
2016-04-25 11:00:00	ES	Futures	2238.4	2242.18	2236.51	2239.48	135516.0
2016-04-25 12:00:00	ES	Futures	2239.48	2246.23	2238.67	2244.88	109126.0
2016-04-25 13:00:00	ES	Futures	2245.15	2247.04	2243.53	2244.34	90070.0
2016-04-25 14:00:00	ES	Futures	2244.34	2245.96	2241.37	2244.61	100013.0
2016-04-25 15:00:00	ES	Futures	2244.61	2248.66	2241.37	2248.39	164782.0
2016-04-25 16:00:00	ES	Futures	2248.66	2251.09	2247.85	2250.82	64961.0
2016-04-25 18:00:00	ES	Futures	2250.82	2251.36	2249.74	2250.01	2745.0
2016-04-25 19:00:00	ES	Futures	2250.28	2250.82	2249.74	2249.74	1405.0
2016-04-25 20:00:00	ES	Futures	2249.74	2250.55	2248.93	2250.01	4257.0
2016-04-25 21:00:00	ES	Futures	2250.01	2254.6	2249.74	2253.79	8967.0
2016-04-25 22:00:00	ES	Futures	2253.79	2253.79	2248.12	2248.93	8292.0
2016-04-25 23:00:00	ES	Futures	2248.66	2249.47	2247.85	2248.93	3477.0
2016-04-25 00:00:00	NQ	Futures	5305.55	5305.85	5301.09	5302.28	586.0
2016-04-25 01:00:00	NQ	Futures	5302.87	5311.8	5301.98	5311.5	726.0
2016-04-25 02:00:00	NQ	Futures	5311.2	5318.05	5307.04	5313.58	1349.0
2016-04-25 03:00:00	NQ	Futures	5313.88	5318.34	5288.59	5288.89	4613.0
2016-04-25 04:00:00	NQ	Futures	5289.19	5291.57	5279.37	5288.0	3013.0
2016-04-25 05:00:00	NQ	Futures	5287.4	5313.29	5286.51	5313.29	2023.0
2016-04-25 06:00:00	NQ	Futures	5313.58	5314.77	5307.63	5308.82	1814.0
2016-04-25 07:00:00	NQ	Futures	5308.82	5311.2	5300.49	5302.87	1985.0
2016-04-25 08:00:00	NQ	Futures	5303.17	5306.44	5295.14	5301.38	3705.0
2016-04-25 09:00:00	NQ	Futures	5301.98	5316.56	5293.65	5305.55	29752.0
2016-04-25 10:00:00	NQ	Futures	5304.95	5312.39	5290.38	5293.65	28881.0
2016-04-25 11:00:00	NQ	Futures	5293.65	5303.17	5290.08	5295.43	18703.0
2016-04-25 12:00:00	NQ	Futures	5295.43	5314.48	5294.84	5309.72	15222.0
2016-04-25 13:00:00	NQ	Futures	5309.72	5314.48	5305.25	5310.01	12896.0
2016-04-25 14:00:00	NQ	Futures	5310.31	5314.48	5299.9	5312.1	14406.0
2016-04-25 15:00:00	NQ	Futures	5312.39	5316.86	5300.19	5315.67	22387.0
2016-04-25 16:00:00	NQ	Futures	5315.96	5324.89	5315.37	5324.59	6337.0
2016-04-25 18:00:00	NQ	Futures	5322.51	5326.67	5322.51	5323.7	462.0
2016-04-25 19:00:00	NQ	Futures	5323.4	5325.48	5321.02	5321.62	297.0
2016-04-25 20:00:00	NQ	Futures	5321.32	5323.4	5319.83	5322.51	557.0
2016-04-25 21:00:00	NQ	Futures	5323.4	5336.49	5323.4	5334.11	1948.0
2016-04-25 22:00:00	NQ	Futures	5333.52	5333.82	5318.34	5320.13	1299.0
2016-04-25 23:00:00	NQ	Futures	5319.53	5321.62	5317.15	5319.53	335.0
2016-04-25 00:00:00	YM	Futures	19153.6	19154.6	19140.7	19142.9	449.0
2016-04-25 01:00:00	YM	Futures	19145.0	19169.6	19141.8	19165.3	568.0
2016-04-25 02:00:00	YM	Futures	19164.3	19176.0	19150.3	19167.5	1133.0
2016-04-25 03:00:00	YM	Futures	19165.3	19180.3	19092.5	19097.9	5011.0

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

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