PREVIEW / futures_1hour / 2016-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-24.parquet
  size:    15 KB
  rows:    280

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-07-24 18:00:00	ES	Futures	2351.46	2351.73	2350.1	2351.19	3618.0
2016-07-24 19:00:00	ES	Futures	2351.19	2351.73	2350.64	2350.92	2241.0
2016-07-24 20:00:00	ES	Futures	2351.19	2353.9	2350.64	2353.36	7723.0
2016-07-24 21:00:00	ES	Futures	2353.08	2356.61	2350.64	2351.19	12851.0
2016-07-24 22:00:00	ES	Futures	2351.46	2351.46	2349.56	2351.19	5210.0
2016-07-24 23:00:00	ES	Futures	2351.19	2351.19	2349.29	2349.83	2254.0
2016-07-24 18:00:00	NQ	Futures	5554.79	5555.68	5551.51	5554.19	333.0
2016-07-24 19:00:00	NQ	Futures	5554.19	5555.09	5553.0	5553.0	278.0
2016-07-24 20:00:00	NQ	Futures	5553.0	5561.05	5552.1	5559.56	935.0
2016-07-24 21:00:00	NQ	Futures	5559.26	5567.01	5550.02	5551.51	1829.0
2016-07-24 22:00:00	NQ	Futures	5551.81	5552.4	5547.34	5551.21	917.0
2016-07-24 23:00:00	NQ	Futures	5550.32	5550.32	5544.95	5546.74	689.0
2016-07-24 18:00:00	YM	Futures	19896.9	19896.9	19884.0	19894.7	914.0
2016-07-24 19:00:00	YM	Futures	19893.6	19899.0	19892.6	19892.6	323.0
2016-07-24 20:00:00	YM	Futures	19893.6	19919.5	19892.6	19915.2	1390.0
2016-07-24 21:00:00	YM	Futures	19915.2	19938.9	19887.2	19892.6	2549.0
2016-07-24 22:00:00	YM	Futures	19892.6	19900.1	19880.7	19894.7	976.0
2016-07-24 23:00:00	YM	Futures	19896.9	19896.9	19879.7	19885.0	561.0
2016-07-24 18:00:00	CL	Futures	45.58	45.64	45.41	45.52	2296.0
2016-07-24 19:00:00	CL	Futures	45.51	45.67	45.51	45.62	2462.0
2016-07-24 20:00:00	CL	Futures	45.62	45.76	45.61	45.71	2791.0
2016-07-24 21:00:00	CL	Futures	45.71	45.76	45.51	45.54	3726.0
2016-07-24 22:00:00	CL	Futures	45.54	45.6	45.46	45.48	2723.0
2016-07-24 23:00:00	CL	Futures	45.48	45.54	45.45	45.51	2000.0
2016-07-24 18:00:00	GC	Futures	1800.0	1800.2	1796.4	1798.5	1511.0
2016-07-24 19:00:00	GC	Futures	1798.7	1800.4	1797.6	1800.4	1325.0
2016-07-24 20:00:00	GC	Futures	1800.4	1801.0	1789.7	1790.0	8623.0
2016-07-24 21:00:00	GC	Futures	1789.8	1794.7	1787.0	1791.7	11470.0
2016-07-24 22:00:00	GC	Futures	1791.7	1792.3	1790.9	1792.1	2550.0
2016-07-24 23:00:00	GC	Futures	1792.0	1793.4	1790.9	1792.0	2891.0
2016-07-24 18:00:00	ZN	Futures	128.660002	128.675217	128.629572	128.660002	2359.0
2016-07-24 19:00:00	ZN	Futures	128.644787	128.660002	128.583926	128.614356	3031.0
2016-07-24 20:00:00	ZN	Futures	128.629572	128.644787	128.523065	128.53828	12705.0
2016-07-24 21:00:00	ZN	Futures	128.53828	128.553495	128.477419	128.553495	10007.0
2016-07-24 22:00:00	ZN	Futures	128.53828	128.568711	128.523065	128.523065	4426.0
2016-07-24 23:00:00	ZN	Futures	128.523065	128.568711	128.523065	128.568711	4280.0

> showing 36 of 280 rows — these rows as CSV

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