PREVIEW / futures_1hour / 2016-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-19.parquet
  size:    15 KB
  rows:    297

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-06-19 18:00:00	ES	Futures	2246.51	2255.19	2245.69	2254.1	27110.0
2016-06-19 19:00:00	ES	Futures	2253.83	2254.1	2251.66	2252.47	6800.0
2016-06-19 20:00:00	ES	Futures	2252.2	2257.63	2252.2	2255.73	17253.0
2016-06-19 21:00:00	ES	Futures	2256.0	2258.17	2255.19	2255.73	11044.0
2016-06-19 22:00:00	ES	Futures	2255.73	2257.9	2255.19	2257.08	7933.0
2016-06-19 23:00:00	ES	Futures	2257.08	2260.34	2256.81	2260.07	10543.0
2016-06-19 18:00:00	NQ	Futures	5225.44	5245.41	5225.44	5242.73	3532.0
2016-06-19 19:00:00	NQ	Futures	5242.73	5243.03	5237.66	5238.55	757.0
2016-06-19 20:00:00	NQ	Futures	5238.85	5251.37	5238.85	5249.28	1862.0
2016-06-19 21:00:00	NQ	Futures	5249.28	5255.25	5247.5	5248.39	1229.0
2016-06-19 22:00:00	NQ	Futures	5248.69	5252.86	5246.01	5250.77	721.0
2016-06-19 23:00:00	NQ	Futures	5250.18	5260.31	5250.18	5259.72	1123.0
2016-06-19 18:00:00	YM	Futures	18983.2	19056.4	18983.2	19047.8	4051.0
2016-06-19 19:00:00	YM	Futures	19048.8	19048.8	19031.6	19037.0	977.0
2016-06-19 20:00:00	YM	Futures	19037.0	19080.0	19037.0	19066.0	2601.0
2016-06-19 21:00:00	YM	Futures	19066.0	19085.4	19060.7	19063.9	1894.0
2016-06-19 22:00:00	YM	Futures	19063.9	19076.8	19057.4	19072.5	1029.0
2016-06-19 23:00:00	YM	Futures	19072.5	19099.4	19070.4	19096.2	1522.0
2016-06-19 18:00:00	CL	Futures	51.39	51.39	51.01	51.18	3387.0
2016-06-19 19:00:00	CL	Futures	51.17	51.22	51.09	51.16	1754.0
2016-06-19 20:00:00	CL	Futures	51.17	51.24	51.08	51.11	1999.0
2016-06-19 21:00:00	CL	Futures	51.12	51.49	51.11	51.41	4526.0
2016-06-19 22:00:00	CL	Futures	51.41	51.48	51.28	51.33	2333.0
2016-06-19 23:00:00	CL	Futures	51.32	51.5	51.32	51.48	1736.0
2016-06-19 18:00:00	GC	Futures	1759.6	1764.8	1745.0	1759.3	10137.0
2016-06-19 19:00:00	GC	Futures	1759.7	1762.7	1757.6	1758.8	4013.0
2016-06-19 20:00:00	GC	Futures	1758.7	1761.8	1752.5	1753.6	7604.0
2016-06-19 21:00:00	GC	Futures	1753.8	1756.2	1752.1	1752.8	7891.0
2016-06-19 22:00:00	GC	Futures	1752.8	1754.8	1748.3	1749.1	7660.0
2016-06-19 23:00:00	GC	Futures	1749.0	1752.8	1747.5	1751.0	4942.0
2016-06-19 18:00:00	ZN	Futures	128.020962	128.142684	127.975317	128.112254	22327.0
2016-06-19 19:00:00	ZN	Futures	128.112254	128.157899	128.051393	128.081823	10027.0
2016-06-19 20:00:00	ZN	Futures	128.066608	128.127469	128.020962	128.081823	14489.0
2016-06-19 21:00:00	ZN	Futures	128.081823	128.173115	128.051393	128.157899	13620.0
2016-06-19 22:00:00	ZN	Futures	128.157899	128.173115	128.066608	128.127469	10096.0
2016-06-19 23:00:00	ZN	Futures	128.112254	128.142684	128.066608	128.112254	7596.0

> showing 36 of 297 rows — these rows as CSV

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