PREVIEW / futures_1hour / 2016-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-20.parquet
  size:    54 KB
  rows:    1,622

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-20 00:00:00	ES	Futures	2254.6	2255.68	2253.79	2255.14	3060.0
2016-04-20 01:00:00	ES	Futures	2255.41	2255.41	2252.71	2253.79	9080.0
2016-04-20 02:00:00	ES	Futures	2253.79	2255.95	2252.71	2255.41	14142.0
2016-04-20 03:00:00	ES	Futures	2255.14	2257.03	2252.44	2255.14	34755.0
2016-04-20 04:00:00	ES	Futures	2255.14	2257.84	2253.25	2253.79	22186.0
2016-04-20 05:00:00	ES	Futures	2254.06	2258.92	2254.06	2258.38	18172.0
2016-04-20 06:00:00	ES	Futures	2258.38	2261.62	2256.49	2261.35	26501.0
2016-04-20 07:00:00	ES	Futures	2261.35	2265.67	2261.08	2263.78	37964.0
2016-04-20 08:00:00	ES	Futures	2264.05	2264.86	2262.97	2264.32	28258.0
2016-04-20 09:00:00	ES	Futures	2264.05	2264.86	2259.73	2263.24	178983.0
2016-04-20 10:00:00	ES	Futures	2263.24	2263.78	2256.49	2261.89	231692.0
2016-04-20 11:00:00	ES	Futures	2261.89	2268.37	2260.81	2265.94	196928.0
2016-04-20 12:00:00	ES	Futures	2266.21	2268.64	2264.59	2267.56	93878.0
2016-04-20 13:00:00	ES	Futures	2267.56	2270.8	2265.4	2269.45	111986.0
2016-04-20 14:00:00	ES	Futures	2269.45	2272.69	2268.64	2272.42	104421.0
2016-04-20 15:00:00	ES	Futures	2272.15	2273.5	2263.24	2264.05	240607.0
2016-04-20 16:00:00	ES	Futures	2264.05	2266.21	2263.24	2265.4	69425.0
2016-04-20 18:00:00	ES	Futures	2265.4	2266.21	2264.59	2265.94	2559.0
2016-04-20 19:00:00	ES	Futures	2265.67	2266.21	2264.86	2265.4	2075.0
2016-04-20 20:00:00	ES	Futures	2265.4	2265.67	2262.7	2263.24	9328.0
2016-04-20 21:00:00	ES	Futures	2262.97	2265.67	2262.16	2265.4	8624.0
2016-04-20 22:00:00	ES	Futures	2265.4	2268.37	2264.59	2268.1	8282.0
2016-04-20 23:00:00	ES	Futures	2268.1	2272.15	2268.1	2271.34	11995.0
2016-04-20 00:00:00	NQ	Futures	5371.9	5375.47	5371.3	5375.47	446.0
2016-04-20 01:00:00	NQ	Futures	5374.87	5375.17	5366.84	5370.71	1204.0
2016-04-20 02:00:00	NQ	Futures	5369.82	5376.96	5366.84	5375.47	1291.0
2016-04-20 03:00:00	NQ	Futures	5374.87	5380.82	5366.25	5374.28	3538.0
2016-04-20 04:00:00	NQ	Futures	5374.87	5383.2	5369.52	5371.01	3138.0
2016-04-20 05:00:00	NQ	Futures	5371.6	5387.07	5371.01	5385.88	1842.0
2016-04-20 06:00:00	NQ	Futures	5386.18	5393.02	5378.44	5391.54	2519.0
2016-04-20 07:00:00	NQ	Futures	5391.54	5400.76	5390.05	5395.11	3179.0
2016-04-20 08:00:00	NQ	Futures	5395.4	5398.97	5392.73	5396.59	2656.0
2016-04-20 09:00:00	NQ	Futures	5396.59	5408.2	5373.98	5401.65	36789.0
2016-04-20 10:00:00	NQ	Futures	5401.65	5405.82	5380.82	5396.89	32801.0
2016-04-20 11:00:00	NQ	Futures	5396.89	5419.5	5393.32	5411.47	26440.0
2016-04-20 12:00:00	NQ	Futures	5411.77	5417.72	5406.41	5410.88	13052.0
2016-04-20 13:00:00	NQ	Futures	5410.88	5416.53	5404.33	5411.77	13077.0
2016-04-20 14:00:00	NQ	Futures	5412.07	5422.18	5409.39	5415.04	14059.0
2016-04-20 15:00:00	NQ	Futures	5415.34	5419.21	5393.92	5396.3	25650.0
2016-04-20 16:00:00	NQ	Futures	5396.3	5401.35	5391.54	5396.89	6308.0
2016-04-20 18:00:00	NQ	Futures	5395.11	5398.38	5392.43	5396.59	574.0
2016-04-20 19:00:00	NQ	Futures	5396.89	5398.68	5395.7	5397.78	414.0
2016-04-20 20:00:00	NQ	Futures	5398.08	5398.08	5387.07	5388.86	1336.0
2016-04-20 21:00:00	NQ	Futures	5388.86	5395.11	5386.48	5394.51	1085.0
2016-04-20 22:00:00	NQ	Futures	5394.21	5404.33	5392.43	5404.03	1750.0
2016-04-20 23:00:00	NQ	Futures	5404.33	5414.45	5404.03	5413.26	1320.0
2016-04-20 00:00:00	YM	Futures	19175.0	19185.7	19169.6	19181.4	956.0
2016-04-20 01:00:00	YM	Futures	19180.3	19191.0	19152.5	19177.1	6281.0
2016-04-20 02:00:00	YM	Futures	19176.0	19185.7	19163.2	19180.3	1657.0
2016-04-20 03:00:00	YM	Futures	19178.2	19197.4	19162.1	19184.6	4211.0

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

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