PREVIEW / futures_1hour / 2014-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-04.parquet
  size:    49 KB
  rows:    1,519

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
2014-12-04 00:00:00	ES	Futures	2172.76	2173.28	2171.45	2173.02	2479.0
2014-12-04 01:00:00	ES	Futures	2173.28	2173.28	2172.76	2173.02	1879.0
2014-12-04 02:00:00	ES	Futures	2173.28	2173.54	2172.5	2172.76	3760.0
2014-12-04 03:00:00	ES	Futures	2172.5	2173.02	2170.4	2171.71	12416.0
2014-12-04 04:00:00	ES	Futures	2171.45	2173.81	2171.45	2171.97	11590.0
2014-12-04 05:00:00	ES	Futures	2172.23	2174.59	2171.97	2173.81	11140.0
2014-12-04 06:00:00	ES	Futures	2173.81	2174.33	2172.76	2173.28	12567.0
2014-12-04 07:00:00	ES	Futures	2173.54	2174.33	2172.76	2173.28	11576.0
2014-12-04 08:00:00	ES	Futures	2173.28	2175.12	2163.33	2165.68	88179.0
2014-12-04 09:00:00	ES	Futures	2165.42	2171.19	2165.16	2167.78	191098.0
2014-12-04 10:00:00	ES	Futures	2168.04	2169.88	2159.92	2162.8	246035.0
2014-12-04 11:00:00	ES	Futures	2162.54	2167.52	2160.44	2167.26	169051.0
2014-12-04 12:00:00	ES	Futures	2167.52	2176.69	2166.99	2171.97	189757.0
2014-12-04 13:00:00	ES	Futures	2172.23	2173.81	2171.45	2172.5	79345.0
2014-12-04 14:00:00	ES	Futures	2172.23	2173.54	2168.83	2169.61	63122.0
2014-12-04 15:00:00	ES	Futures	2169.88	2171.19	2164.37	2170.4	166111.0
2014-12-04 16:00:00	ES	Futures	2170.14	2172.23	2168.57	2171.19	78144.0
2014-12-04 17:00:00	ES	Futures	2171.19	2171.45	2170.66	2170.92	1283.0
2014-12-04 18:00:00	ES	Futures	2170.92	2171.71	2170.4	2171.19	2388.0
2014-12-04 19:00:00	ES	Futures	2171.19	2171.45	2170.4	2170.92	2791.0
2014-12-04 20:00:00	ES	Futures	2171.19	2171.19	2170.4	2170.92	2714.0
2014-12-04 21:00:00	ES	Futures	2170.66	2170.92	2170.14	2170.66	2801.0
2014-12-04 22:00:00	ES	Futures	2170.66	2170.92	2170.14	2170.4	1902.0
2014-12-04 23:00:00	ES	Futures	2170.4	2171.45	2170.4	2171.19	1861.0
2014-12-04 00:00:00	NQ	Futures	5056.4	5058.45	5054.64	5058.45	621.0
2014-12-04 01:00:00	NQ	Futures	5058.74	5059.62	5058.45	5059.33	359.0
2014-12-04 02:00:00	NQ	Futures	5059.33	5059.92	5057.86	5057.86	418.0
2014-12-04 03:00:00	NQ	Futures	5057.57	5059.04	5052.59	5055.23	1482.0
2014-12-04 04:00:00	NQ	Futures	5055.23	5060.79	5054.64	5056.69	1221.0
2014-12-04 05:00:00	NQ	Futures	5056.4	5062.85	5056.4	5060.21	1160.0
2014-12-04 06:00:00	NQ	Futures	5060.5	5061.09	5058.45	5059.92	1583.0
2014-12-04 07:00:00	NQ	Futures	5059.92	5061.97	5059.04	5060.5	1801.0
2014-12-04 08:00:00	NQ	Futures	5060.21	5065.19	5033.84	5041.75	16142.0
2014-12-04 09:00:00	NQ	Futures	5042.04	5066.65	5041.16	5061.09	41629.0
2014-12-04 10:00:00	NQ	Futures	5061.09	5066.65	5040.28	5049.37	44131.0
2014-12-04 11:00:00	NQ	Futures	5049.37	5055.52	5031.79	5055.23	34149.0
2014-12-04 12:00:00	NQ	Futures	5054.93	5073.1	5052.88	5064.31	35990.0
2014-12-04 13:00:00	NQ	Futures	5064.31	5067.24	5059.92	5063.14	12744.0
2014-12-04 14:00:00	NQ	Futures	5063.14	5066.36	5054.64	5058.16	13498.0
2014-12-04 15:00:00	NQ	Futures	5058.16	5061.97	5043.51	5053.47	32364.0
2014-12-04 16:00:00	NQ	Futures	5053.18	5059.04	5050.83	5056.11	6631.0
2014-12-04 17:00:00	NQ	Futures	5056.11	5057.28	5055.23	5055.81	199.0
2014-12-04 18:00:00	NQ	Futures	5054.93	5056.4	5053.76	5054.93	442.0
2014-12-04 19:00:00	NQ	Futures	5054.93	5056.11	5053.76	5054.93	485.0
2014-12-04 20:00:00	NQ	Futures	5055.23	5056.11	5054.35	5055.23	356.0
2014-12-04 21:00:00	NQ	Futures	5055.52	5055.52	5054.06	5054.64	360.0
2014-12-04 22:00:00	NQ	Futures	5054.93	5054.93	5053.47	5053.47	277.0
2014-12-04 23:00:00	NQ	Futures	5053.76	5055.52	5053.76	5054.35	444.0
2014-12-04 00:00:00	YM	Futures	18617.0	18621.1	18602.4	18621.1	2144.0
2014-12-04 01:00:00	YM	Futures	18622.2	18626.3	18619.0	18624.2	533.0

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

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