PREVIEW / futures_1hour / 2014-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-27.parquet
  size:    13 KB
  rows:    260

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-07-27 18:00:00	ES	Futures	2054.42	2056.24	2050.77	2051.29	8365.0
2014-07-27 19:00:00	ES	Futures	2051.29	2052.34	2049.99	2051.55	3024.0
2014-07-27 20:00:00	ES	Futures	2051.81	2053.38	2051.55	2051.55	4044.0
2014-07-27 21:00:00	ES	Futures	2051.81	2053.64	2051.55	2053.38	4825.0
2014-07-27 22:00:00	ES	Futures	2053.12	2053.64	2052.86	2053.12	2764.0
2014-07-27 23:00:00	ES	Futures	2053.12	2053.64	2052.07	2052.34	1932.0
2014-07-27 18:00:00	NQ	Futures	4618.5	4624.64	4611.5	4612.08	963.0
2014-07-27 19:00:00	NQ	Futures	4612.08	4614.42	4609.74	4613.25	317.0
2014-07-27 20:00:00	NQ	Futures	4613.25	4617.92	4613.25	4614.42	640.0
2014-07-27 21:00:00	NQ	Futures	4614.42	4619.09	4614.42	4617.92	682.0
2014-07-27 22:00:00	NQ	Futures	4618.21	4620.26	4617.92	4618.5	411.0
2014-07-27 23:00:00	NQ	Futures	4618.5	4619.67	4616.17	4616.75	296.0
2014-07-27 18:00:00	YM	Futures	17475.9	17481.1	17440.7	17440.7	900.0
2014-07-27 19:00:00	YM	Futures	17442.8	17450.0	17433.5	17446.9	264.0
2014-07-27 20:00:00	YM	Futures	17445.9	17459.4	17445.9	17445.9	726.0
2014-07-27 21:00:00	YM	Futures	17446.9	17462.5	17446.9	17461.4	861.0
2014-07-27 22:00:00	YM	Futures	17461.4	17465.6	17458.3	17460.4	532.0
2014-07-27 23:00:00	YM	Futures	17460.4	17461.4	17453.2	17454.2	236.0
2014-07-27 18:00:00	CL	Futures	166.49	166.74	166.29	166.33	820.0
2014-07-27 19:00:00	CL	Futures	166.33	166.34	166.18	166.26	386.0
2014-07-27 20:00:00	CL	Futures	166.26	166.28	166.16	166.18	368.0
2014-07-27 21:00:00	CL	Futures	166.18	166.23	165.89	165.9	1166.0
2014-07-27 22:00:00	CL	Futures	165.9	166.16	165.89	166.07	734.0
2014-07-27 23:00:00	CL	Futures	166.05	166.12	165.89	165.92	840.0
2014-07-27 18:00:00	GC	Futures	1792.2	1793.5	1788.7	1792.8	222.0
2014-07-27 19:00:00	GC	Futures	1792.8	1793.7	1790.9	1790.9	100.0
2014-07-27 20:00:00	GC	Futures	1790.6	1791.3	1789.2	1789.8	192.0
2014-07-27 21:00:00	GC	Futures	1789.4	1790.7	1787.4	1787.4	256.0
2014-07-27 22:00:00	GC	Futures	1787.4	1788.0	1784.2	1787.2	861.0
2014-07-27 23:00:00	GC	Futures	1786.9	1790.2	1785.7	1790.2	194.0
2014-07-27 18:00:00	ZN	Futures	118.158592	118.173327	118.143857	118.173327	4524.0
2014-07-27 19:00:00	ZN	Futures	118.173327	118.173327	118.143857	118.173327	1142.0
2014-07-27 20:00:00	ZN	Futures	118.158592	118.173327	118.099653	118.129123	4701.0
2014-07-27 21:00:00	ZN	Futures	118.129123	118.143857	118.099653	118.114388	3277.0
2014-07-27 22:00:00	ZN	Futures	118.114388	118.114388	118.084918	118.099653	2480.0
2014-07-27 23:00:00	ZN	Futures	118.099653	118.114388	118.099653	118.114388	1480.0

> showing 36 of 260 rows — these rows as CSV

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