PREVIEW / futures_1hour / 2017-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-25.parquet
  size:    14 KB
  rows:    284

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
2017-06-25 18:00:00	ES	Futures	2659.04	2659.86	2656.86	2659.04	6720.0
2017-06-25 19:00:00	ES	Futures	2659.04	2659.59	2658.5	2659.59	1602.0
2017-06-25 20:00:00	ES	Futures	2659.59	2661.23	2658.77	2660.41	6298.0
2017-06-25 21:00:00	ES	Futures	2660.68	2663.69	2660.41	2662.6	5513.0
2017-06-25 22:00:00	ES	Futures	2662.87	2664.24	2662.6	2663.42	4810.0
2017-06-25 23:00:00	ES	Futures	2663.42	2664.51	2662.87	2663.69	3792.0
2017-06-25 18:00:00	NQ	Futures	6911.4	6916.46	6902.17	6912.89	1440.0
2017-06-25 19:00:00	NQ	Futures	6912.59	6912.59	6910.21	6912.0	258.0
2017-06-25 20:00:00	NQ	Futures	6912.59	6919.14	6910.51	6916.17	1328.0
2017-06-25 21:00:00	NQ	Futures	6916.46	6927.78	6914.97	6923.61	1874.0
2017-06-25 22:00:00	NQ	Futures	6923.31	6929.56	6922.72	6927.78	1429.0
2017-06-25 23:00:00	NQ	Futures	6927.48	6930.46	6926.29	6928.08	860.0
2017-06-25 18:00:00	YM	Futures	23206.4	23218.4	23193.4	23209.7	1001.0
2017-06-25 19:00:00	YM	Futures	23209.7	23216.2	23208.6	23216.2	249.0
2017-06-25 20:00:00	YM	Futures	23216.2	23233.6	23211.9	23227.1	1159.0
2017-06-25 21:00:00	YM	Futures	23226.0	23251.1	23224.9	23246.7	1270.0
2017-06-25 22:00:00	YM	Futures	23245.6	23257.6	23244.5	23251.1	848.0
2017-06-25 23:00:00	YM	Futures	23252.1	23257.6	23250.0	23253.2	558.0
2017-06-25 18:00:00	CL	Futures	39.3	39.42	39.26	39.34	4107.0
2017-06-25 19:00:00	CL	Futures	39.34	39.38	39.32	39.37	1473.0
2017-06-25 20:00:00	CL	Futures	39.37	39.38	39.32	39.37	1987.0
2017-06-25 21:00:00	CL	Futures	39.36	39.6	39.36	39.58	10969.0
2017-06-25 22:00:00	CL	Futures	39.59	39.7	39.53	39.57	9155.0
2017-06-25 23:00:00	CL	Futures	39.56	39.67	39.55	39.63	3556.0
2017-06-25 18:00:00	GC	Futures	1684.3	1685.5	1683.9	1684.2	1665.0
2017-06-25 19:00:00	GC	Futures	1684.2	1685.4	1684.2	1684.4	1166.0
2017-06-25 20:00:00	GC	Futures	1684.4	1684.6	1682.0	1682.7	3874.0
2017-06-25 21:00:00	GC	Futures	1682.6	1682.7	1680.7	1682.4	3456.0
2017-06-25 22:00:00	GC	Futures	1682.4	1682.7	1682.0	1682.0	2481.0
2017-06-25 23:00:00	GC	Futures	1682.0	1682.2	1680.7	1681.2	2832.0
2017-06-25 18:00:00	ZN	Futures	125.965752	125.981282	125.934692	125.981282	3298.0
2017-06-25 19:00:00	ZN	Futures	125.981282	125.996812	125.965752	125.981282	2336.0
2017-06-25 20:00:00	ZN	Futures	125.965752	125.981282	125.903631	125.950222	13144.0
2017-06-25 21:00:00	ZN	Futures	125.950222	125.950222	125.903631	125.919161	7467.0
2017-06-25 22:00:00	ZN	Futures	125.919161	125.919161	125.903631	125.919161	653.0
2017-06-25 23:00:00	ZN	Futures	125.919161	125.919161	125.903631	125.919161	2678.0

> showing 36 of 284 rows — these rows as CSV

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