PREVIEW / futures_1hour / 2017-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-30.parquet
  size:    15 KB
  rows:    281

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-04-30 18:00:00	ES	Futures	2601.96	2601.96	2597.04	2598.41	8066.0
2017-04-30 19:00:00	ES	Futures	2598.68	2598.96	2598.14	2598.96	2134.0
2017-04-30 20:00:00	ES	Futures	2598.96	2600.32	2598.68	2599.5	3619.0
2017-04-30 21:00:00	ES	Futures	2599.77	2603.6	2598.68	2602.23	8040.0
2017-04-30 22:00:00	ES	Futures	2602.23	2603.05	2601.69	2601.96	2887.0
2017-04-30 23:00:00	ES	Futures	2601.96	2602.78	2601.69	2602.23	1560.0
2017-04-30 18:00:00	NQ	Futures	6655.68	6658.66	6646.74	6651.21	1482.0
2017-04-30 19:00:00	NQ	Futures	6651.51	6653.0	6650.61	6653.0	383.0
2017-04-30 20:00:00	NQ	Futures	6653.0	6657.77	6652.4	6655.98	868.0
2017-04-30 21:00:00	NQ	Futures	6655.98	6665.82	6653.89	6663.14	1799.0
2017-04-30 22:00:00	NQ	Futures	6662.84	6664.63	6661.94	6662.54	520.0
2017-04-30 23:00:00	NQ	Futures	6662.54	6664.03	6661.94	6662.84	368.0
2017-04-30 18:00:00	YM	Futures	22707.4	22707.4	22666.1	22675.9	1291.0
2017-04-30 19:00:00	YM	Futures	22674.8	22679.2	22668.3	22674.8	435.0
2017-04-30 20:00:00	YM	Futures	22674.8	22690.0	22673.7	22685.7	659.0
2017-04-30 21:00:00	YM	Futures	22684.6	22715.0	22678.1	22703.1	1171.0
2017-04-30 22:00:00	YM	Futures	22704.2	22707.4	22699.8	22700.9	418.0
2017-04-30 23:00:00	YM	Futures	22700.9	22707.4	22699.8	22705.2	211.0
2017-04-30 18:00:00	CL	Futures	45.33	45.41	45.3	45.32	2250.0
2017-04-30 19:00:00	CL	Futures	45.32	45.41	45.31	45.41	947.0
2017-04-30 20:00:00	CL	Futures	45.4	45.41	45.34	45.35	1058.0
2017-04-30 21:00:00	CL	Futures	45.34	45.41	45.33	45.38	1626.0
2017-04-30 22:00:00	CL	Futures	45.38	45.47	45.38	45.41	2188.0
2017-04-30 23:00:00	CL	Futures	45.41	45.41	45.37	45.39	1357.0
2017-04-30 18:00:00	GC	Futures	1704.4	1708.2	1703.8	1707.7	4138.0
2017-04-30 19:00:00	GC	Futures	1707.7	1708.2	1705.9	1707.1	3596.0
2017-04-30 20:00:00	GC	Futures	1707.1	1707.1	1702.2	1703.1	4669.0
2017-04-30 21:00:00	GC	Futures	1703.1	1703.6	1695.2	1698.3	15251.0
2017-04-30 22:00:00	GC	Futures	1698.3	1699.3	1698.3	1698.4	3184.0
2017-04-30 23:00:00	GC	Futures	1698.4	1698.7	1696.9	1697.6	1845.0
2017-04-30 18:00:00	ZN	Futures	124.709823	124.787321	124.694323	124.771821	16331.0
2017-04-30 19:00:00	ZN	Futures	124.756322	124.771821	124.725322	124.740822	2896.0
2017-04-30 20:00:00	ZN	Futures	124.740822	124.740822	124.632325	124.647824	12663.0
2017-04-30 21:00:00	ZN	Futures	124.647824	124.663324	124.492828	124.570326	27233.0
2017-04-30 22:00:00	ZN	Futures	124.554827	124.632325	124.554827	124.585826	10268.0
2017-04-30 23:00:00	ZN	Futures	124.585826	124.601326	124.554827	124.570326	4557.0

> showing 36 of 281 rows — these rows as CSV

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