PREVIEW / futures_1hour / 2016-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-05.parquet
  size:    14 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
2016-06-05 18:00:00	ES	Futures	2265.13	2267.02	2264.59	2265.94	4832.0
2016-06-05 19:00:00	ES	Futures	2266.21	2266.21	2261.35	2262.7	10248.0
2016-06-05 20:00:00	ES	Futures	2262.43	2264.05	2261.62	2262.7	6780.0
2016-06-05 21:00:00	ES	Futures	2262.7	2264.59	2262.16	2263.51	5809.0
2016-06-05 22:00:00	ES	Futures	2263.78	2264.05	2262.97	2263.51	2588.0
2016-06-05 23:00:00	ES	Futures	2263.51	2265.13	2263.51	2264.86	3964.0
2016-06-05 18:00:00	NQ	Futures	5368.63	5370.71	5366.25	5368.92	1072.0
2016-06-05 19:00:00	NQ	Futures	5368.63	5369.22	5360.3	5362.97	1291.0
2016-06-05 20:00:00	NQ	Futures	5362.97	5367.44	5361.78	5363.87	634.0
2016-06-05 21:00:00	NQ	Futures	5363.87	5368.92	5362.97	5365.65	786.0
2016-06-05 22:00:00	NQ	Futures	5366.54	5367.14	5363.57	5364.76	413.0
2016-06-05 23:00:00	NQ	Futures	5365.06	5370.71	5365.06	5370.41	476.0
2016-06-05 18:00:00	YM	Futures	19061.5	19069.0	19054.0	19065.8	567.0
2016-06-05 19:00:00	YM	Futures	19065.8	19065.8	19030.5	19034.7	1697.0
2016-06-05 20:00:00	YM	Futures	19034.7	19048.7	19031.5	19039.0	968.0
2016-06-05 21:00:00	YM	Futures	19038.0	19052.9	19035.8	19047.6	816.0
2016-06-05 22:00:00	YM	Futures	19046.5	19049.7	19040.1	19044.4	482.0
2016-06-05 23:00:00	YM	Futures	19044.4	19058.3	19043.3	19055.1	546.0
2016-06-05 18:00:00	CL	Futures	51.86	51.95	51.78	51.85	1133.0
2016-06-05 19:00:00	CL	Futures	51.84	51.84	51.68	51.73	1876.0
2016-06-05 20:00:00	CL	Futures	51.74	51.99	51.74	51.97	3373.0
2016-06-05 21:00:00	CL	Futures	51.98	52.16	51.9	52.05	6182.0
2016-06-05 22:00:00	CL	Futures	52.06	52.08	52.01	52.05	1117.0
2016-06-05 23:00:00	CL	Futures	52.06	52.08	52.04	52.08	942.0
2016-06-05 18:00:00	GC	Futures	1695.0	1699.7	1693.9	1698.1	4691.0
2016-06-05 19:00:00	GC	Futures	1698.4	1702.2	1698.1	1702.0	3506.0
2016-06-05 20:00:00	GC	Futures	1702.2	1702.9	1698.1	1698.2	7197.0
2016-06-05 21:00:00	GC	Futures	1698.2	1698.2	1693.3	1693.7	9831.0
2016-06-05 22:00:00	GC	Futures	1693.6	1695.8	1692.8	1692.8	4334.0
2016-06-05 23:00:00	GC	Futures	1692.9	1694.3	1692.0	1693.2	3743.0
2016-06-05 18:00:00	ZN	Futures	127.564505	127.564505	127.51886	127.51886	40.0
2016-06-05 19:00:00	ZN	Futures	127.564505	127.564505	127.564505	127.564505	1.0
2016-06-05 20:00:00	ZN	Futures	127.51886	127.51886	127.427568	127.427568	305.0
2016-06-05 21:00:00	ZN	Futures	127.381923	127.412353	127.381923	127.412353	33.0
2016-06-05 22:00:00	ZN	Futures	127.412353	127.412353	127.412353	127.412353	1.0
2016-06-05 23:00:00	ZN	Futures	127.412353	127.442784	127.412353	127.442784	251.0

> showing 36 of 281 rows — these rows as CSV

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