PREVIEW / futures_1hour / 2016-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-15.parquet
  size:    44 KB
  rows:    1,303

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-15 00:00:00	ES	Futures	2241.64	2242.99	2241.37	2242.99	1753.0
2016-04-15 01:00:00	ES	Futures	2242.99	2243.53	2242.45	2242.99	2628.0
2016-04-15 02:00:00	ES	Futures	2242.99	2243.53	2240.83	2241.1	9653.0
2016-04-15 03:00:00	ES	Futures	2241.1	2242.18	2238.94	2239.75	25920.0
2016-04-15 04:00:00	ES	Futures	2239.75	2240.02	2237.86	2238.67	16584.0
2016-04-15 05:00:00	ES	Futures	2238.94	2240.56	2238.67	2239.75	14413.0
2016-04-15 06:00:00	ES	Futures	2240.02	2240.02	2237.32	2238.13	13367.0
2016-04-15 07:00:00	ES	Futures	2238.13	2239.21	2237.05	2237.59	16645.0
2016-04-15 08:00:00	ES	Futures	2237.59	2240.02	2236.78	2239.21	33474.0
2016-04-15 09:00:00	ES	Futures	2239.21	2242.99	2238.13	2240.83	185496.0
2016-04-15 10:00:00	ES	Futures	2240.83	2242.18	2236.78	2239.75	187797.0
2016-04-15 11:00:00	ES	Futures	2239.75	2242.45	2239.48	2240.83	99139.0
2016-04-15 12:00:00	ES	Futures	2240.56	2241.64	2238.4	2238.4	83772.0
2016-04-15 13:00:00	ES	Futures	2238.67	2239.21	2235.16	2236.51	104309.0
2016-04-15 14:00:00	ES	Futures	2236.78	2240.29	2234.89	2240.02	97571.0
2016-04-15 15:00:00	ES	Futures	2240.29	2240.83	2237.86	2239.21	189663.0
2016-04-15 16:00:00	ES	Futures	2239.21	2241.37	2238.13	2240.56	85634.0
2016-04-15 00:00:00	NQ	Futures	5408.49	5413.55	5408.2	5412.36	471.0
2016-04-15 01:00:00	NQ	Futures	5412.07	5414.74	5411.17	5412.66	386.0
2016-04-15 02:00:00	NQ	Futures	5412.36	5414.45	5407.01	5407.9	1000.0
2016-04-15 03:00:00	NQ	Futures	5407.9	5411.17	5403.14	5406.11	2219.0
2016-04-15 04:00:00	NQ	Futures	5405.82	5406.41	5398.97	5403.14	1237.0
2016-04-15 05:00:00	NQ	Futures	5403.14	5407.3	5400.76	5405.22	768.0
2016-04-15 06:00:00	NQ	Futures	5405.22	5405.52	5397.19	5398.97	1494.0
2016-04-15 07:00:00	NQ	Futures	5399.27	5401.95	5397.19	5398.08	1700.0
2016-04-15 08:00:00	NQ	Futures	5398.08	5403.44	5396.59	5401.06	3649.0
2016-04-15 09:00:00	NQ	Futures	5401.35	5412.36	5395.11	5405.52	29699.0
2016-04-15 10:00:00	NQ	Futures	5405.52	5415.04	5395.4	5409.69	27770.0
2016-04-15 11:00:00	NQ	Futures	5409.69	5417.72	5408.49	5409.09	15946.0
2016-04-15 12:00:00	NQ	Futures	5408.79	5412.07	5404.03	5404.33	11784.0
2016-04-15 13:00:00	NQ	Futures	5404.33	5406.11	5383.8	5390.94	24095.0
2016-04-15 14:00:00	NQ	Futures	5390.94	5401.06	5382.91	5400.76	14938.0
2016-04-15 15:00:00	NQ	Futures	5400.76	5403.73	5394.81	5397.19	25057.0
2016-04-15 16:00:00	NQ	Futures	5397.19	5403.14	5395.11	5401.65	5898.0
2016-04-15 00:00:00	YM	Futures	19091.5	19106.5	19090.4	19106.5	238.0
2016-04-15 01:00:00	YM	Futures	19105.4	19111.8	19101.1	19108.6	482.0
2016-04-15 02:00:00	YM	Futures	19105.4	19108.6	19089.3	19093.6	864.0
2016-04-15 03:00:00	YM	Futures	19094.7	19107.5	19080.8	19090.4	3835.0
2016-04-15 04:00:00	YM	Futures	19090.4	19090.4	19070.1	19079.7	1468.0
2016-04-15 05:00:00	YM	Futures	19079.7	19093.6	19077.6	19087.2	1001.0
2016-04-15 06:00:00	YM	Futures	19088.3	19089.3	19065.8	19072.2	1113.0
2016-04-15 07:00:00	YM	Futures	19071.1	19078.6	19061.5	19064.7	1492.0
2016-04-15 08:00:00	YM	Futures	19065.8	19082.9	19059.4	19076.5	2838.0
2016-04-15 09:00:00	YM	Futures	19077.6	19109.7	19071.1	19094.7	15176.0
2016-04-15 10:00:00	YM	Futures	19093.6	19103.2	19061.5	19089.3	16055.0
2016-04-15 11:00:00	YM	Futures	19089.3	19103.2	19082.9	19086.1	8061.0
2016-04-15 12:00:00	YM	Futures	19086.1	19091.5	19066.9	19067.9	6818.0
2016-04-15 13:00:00	YM	Futures	19066.9	19072.2	19043.3	19048.7	8800.0
2016-04-15 14:00:00	YM	Futures	19048.7	19075.4	19031.5	19074.3	8314.0
2016-04-15 15:00:00	YM	Futures	19073.3	19079.7	19054.0	19061.5	10641.0

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

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