PREVIEW / futures_1hour / 2016-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-27.parquet
  size:    15 KB
  rows:    302

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-11-27 18:00:00	ES	Futures	2403.0	2403.55	2401.1	2402.19	11581.0
2016-11-27 19:00:00	ES	Futures	2402.19	2403.55	2399.74	2400.55	6807.0
2016-11-27 20:00:00	ES	Futures	2400.55	2401.91	2399.19	2400.28	9166.0
2016-11-27 21:00:00	ES	Futures	2400.01	2401.37	2399.19	2400.28	10903.0
2016-11-27 22:00:00	ES	Futures	2400.28	2402.19	2400.01	2401.91	3284.0
2016-11-27 23:00:00	ES	Futures	2401.91	2402.19	2401.37	2402.19	2303.0
2016-11-27 18:00:00	NQ	Futures	5804.7	5804.7	5797.84	5801.12	1255.0
2016-11-27 19:00:00	NQ	Futures	5801.72	5804.11	5795.75	5796.65	1218.0
2016-11-27 20:00:00	NQ	Futures	5796.95	5802.61	5795.45	5798.74	1392.0
2016-11-27 21:00:00	NQ	Futures	5798.74	5802.02	5796.65	5798.74	988.0
2016-11-27 22:00:00	NQ	Futures	5798.44	5804.7	5798.44	5804.11	479.0
2016-11-27 23:00:00	NQ	Futures	5804.4	5805.9	5802.02	5805.0	425.0
2016-11-27 18:00:00	YM	Futures	20669.6	20670.7	20645.8	20649.1	1877.0
2016-11-27 19:00:00	YM	Futures	20649.1	20657.7	20627.4	20633.9	2125.0
2016-11-27 20:00:00	YM	Futures	20632.8	20645.8	20622.0	20629.6	1814.0
2016-11-27 21:00:00	YM	Futures	20629.6	20635.0	20610.1	20623.1	2715.0
2016-11-27 22:00:00	YM	Futures	20622.0	20639.3	20622.0	20637.2	897.0
2016-11-27 23:00:00	YM	Futures	20637.2	20640.4	20632.8	20639.3	357.0
2016-11-27 18:00:00	CL	Futures	44.49	44.84	44.21	44.36	16656.0
2016-11-27 19:00:00	CL	Futures	44.36	44.56	44.32	44.43	5615.0
2016-11-27 20:00:00	CL	Futures	44.42	44.84	44.42	44.8	8105.0
2016-11-27 21:00:00	CL	Futures	44.8	45.19	44.7	45.12	10609.0
2016-11-27 22:00:00	CL	Futures	45.12	45.34	44.92	45.05	11825.0
2016-11-27 23:00:00	CL	Futures	45.05	45.15	44.84	45.15	7811.0
2016-11-27 18:00:00	GC	Futures	1598.6	1605.3	1598.6	1605.0	1276.0
2016-11-27 19:00:00	GC	Futures	1604.6	1614.2	1604.6	1613.1	3397.0
2016-11-27 20:00:00	GC	Futures	1613.1	1617.1	1612.0	1617.0	4798.0
2016-11-27 21:00:00	GC	Futures	1617.1	1619.7	1614.4	1615.4	4011.0
2016-11-27 22:00:00	GC	Futures	1615.5	1615.9	1611.6	1611.7	2310.0
2016-11-27 23:00:00	GC	Futures	1611.6	1615.0	1610.1	1613.9	1886.0
2016-11-27 18:00:00	ZN	Futures	122.957222	123.064501	122.911245	123.03385	16125.0
2016-11-27 19:00:00	ZN	Futures	123.049175	123.110478	122.957222	123.079826	15932.0
2016-11-27 20:00:00	ZN	Futures	123.079826	123.156454	123.049175	123.141129	16677.0
2016-11-27 21:00:00	ZN	Futures	123.156454	123.233082	123.156454	123.187105	26931.0
2016-11-27 22:00:00	ZN	Futures	123.187105	123.202431	123.156454	123.17178	9405.0
2016-11-27 23:00:00	ZN	Futures	123.17178	123.263733	123.156454	123.202431	16301.0

> showing 36 of 302 rows — these rows as CSV

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