PREVIEW / futures_1hour / 2013-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-01.parquet
  size:    13 KB
  rows:    219

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
2013-09-01 18:00:00	ES	Futures	1695.98	1697.79	1694.69	1697.54	19792.0
2013-09-01 19:00:00	ES	Futures	1697.28	1697.54	1695.73	1696.24	3695.0
2013-09-01 20:00:00	ES	Futures	1695.98	1699.34	1695.47	1698.31	10705.0
2013-09-01 21:00:00	ES	Futures	1698.31	1698.57	1697.54	1698.57	5479.0
2013-09-01 22:00:00	ES	Futures	1698.31	1698.57	1695.98	1696.76	4389.0
2013-09-01 23:00:00	ES	Futures	1696.5	1699.09	1696.5	1698.57	3010.0
2013-09-01 18:00:00	NQ	Futures	3610.57	3625.77	3610.57	3621.09	3347.0
2013-09-01 19:00:00	NQ	Futures	3621.09	3621.39	3619.34	3620.22	712.0
2013-09-01 20:00:00	NQ	Futures	3620.22	3622.56	3619.34	3620.51	1120.0
2013-09-01 21:00:00	NQ	Futures	3620.8	3621.97	3619.05	3621.68	1697.0
2013-09-01 22:00:00	NQ	Futures	3621.39	3621.68	3617.0	3618.46	717.0
2013-09-01 23:00:00	NQ	Futures	3618.46	3622.56	3618.17	3621.39	324.0
2013-09-01 18:00:00	YM	Futures	15082.9	15109.3	15081.9	15106.2	1460.0
2013-09-01 19:00:00	YM	Futures	15103.2	15104.2	15086.9	15089.0	438.0
2013-09-01 20:00:00	YM	Futures	15089.0	15112.3	15084.9	15108.3	819.0
2013-09-01 21:00:00	YM	Futures	15109.3	15109.3	15099.1	15107.2	716.0
2013-09-01 22:00:00	YM	Futures	15107.2	15107.2	15090.0	15094.0	614.0
2013-09-01 23:00:00	YM	Futures	15094.0	15113.3	15093.0	15108.3	452.0
2013-09-01 18:00:00	CL	Futures	169.03	169.16	164.52	166.92	6068.0
2013-09-01 19:00:00	CL	Futures	166.87	167.64	166.6	167.27	2417.0
2013-09-01 20:00:00	CL	Futures	167.23	167.5	167.09	167.25	1217.0
2013-09-01 21:00:00	CL	Futures	167.27	168.31	167.27	167.74	2969.0
2013-09-01 22:00:00	CL	Futures	167.69	167.9	167.19	167.34	1695.0
2013-09-01 23:00:00	CL	Futures	167.33	167.69	167.19	167.49	709.0
2013-09-01 18:00:00	GC	Futures	1910.9	1910.9	1882.9	1894.9	7839.0
2013-09-01 19:00:00	GC	Futures	1894.8	1895.8	1889.5	1891.9	1054.0
2013-09-01 20:00:00	GC	Futures	1891.9	1900.0	1890.8	1899.2	2828.0
2013-09-01 21:00:00	GC	Futures	1898.9	1907.8	1898.9	1905.8	5767.0
2013-09-01 22:00:00	GC	Futures	1905.6	1907.3	1903.7	1905.5	1460.0
2013-09-01 23:00:00	GC	Futures	1905.4	1907.3	1904.7	1905.9	2172.0
2013-09-01 18:00:00	ZN	Futures	113.207913	113.207913	112.995649	113.123008	2559.0
2013-09-01 19:00:00	ZN	Futures	113.123008	113.123008	113.094706	113.108857	107.0
2013-09-01 20:00:00	ZN	Futures	113.123008	113.123008	113.094706	113.094706	794.0
2013-09-01 21:00:00	ZN	Futures	113.123008	113.137159	113.108857	113.108857	144.0
2013-09-01 22:00:00	ZN	Futures	113.123008	113.123008	113.094706	113.108857	326.0
2013-09-01 23:00:00	ZN	Futures	113.108857	113.108857	113.094706	113.108857	250.0

> showing 36 of 219 rows — these rows as CSV

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