PREVIEW / futures_1hour / 2019-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-09.parquet
  size:    17 KB
  rows:    344

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
2019-06-09 18:00:00	ES	Futures	3137.47	3142.62	3132.32	3133.94	32197.0
2019-06-09 19:00:00	ES	Futures	3134.21	3135.84	3130.69	3131.23	10852.0
2019-06-09 20:00:00	ES	Futures	3130.96	3133.13	3124.72	3125.54	17049.0
2019-06-09 21:00:00	ES	Futures	3125.27	3127.98	3123.64	3127.98	18126.0
2019-06-09 22:00:00	ES	Futures	3127.98	3129.6	3125.54	3125.81	11066.0
2019-06-09 23:00:00	ES	Futures	3125.81	3127.16	3124.18	3126.35	8062.0
2019-06-09 18:00:00	NQ	Futures	8698.58	8716.92	8686.93	8695.38	8117.0
2019-06-09 19:00:00	NQ	Futures	8695.08	8698.58	8682.56	8683.73	3094.0
2019-06-09 20:00:00	NQ	Futures	8683.44	8690.72	8660.44	8662.77	5613.0
2019-06-09 21:00:00	NQ	Futures	8662.77	8675.87	8654.61	8675.87	6358.0
2019-06-09 22:00:00	NQ	Futures	8675.87	8680.82	8661.02	8661.89	3912.0
2019-06-09 23:00:00	NQ	Futures	8662.18	8666.84	8657.82	8666.84	2549.0
2019-06-09 18:00:00	YM	Futures	28442.5	28593.7	28404.4	28417.5	7379.0
2019-06-09 19:00:00	YM	Futures	28416.4	28436.0	28396.8	28397.9	2389.0
2019-06-09 20:00:00	YM	Futures	28396.8	28417.5	28340.3	28345.7	4206.0
2019-06-09 21:00:00	YM	Futures	28345.7	28377.2	28331.6	28376.1	3943.0
2019-06-09 22:00:00	YM	Futures	28377.2	28384.9	28352.2	28355.5	2044.0
2019-06-09 23:00:00	YM	Futures	28356.6	28365.3	28333.7	28353.3	1623.0
2019-06-09 18:00:00	CL	Futures	48.36	48.9	48.35	48.66	9348.0
2019-06-09 19:00:00	CL	Futures	48.65	48.7	48.5	48.54	4299.0
2019-06-09 20:00:00	CL	Futures	48.53	48.62	48.44	48.45	6773.0
2019-06-09 21:00:00	CL	Futures	48.45	48.45	48.14	48.26	20697.0
2019-06-09 22:00:00	CL	Futures	48.26	48.44	48.26	48.39	9143.0
2019-06-09 23:00:00	CL	Futures	48.39	48.44	48.37	48.41	3869.0
2019-06-09 18:00:00	GC	Futures	1714.6	1714.6	1709.7	1711.5	7066.0
2019-06-09 19:00:00	GC	Futures	1711.4	1712.8	1711.1	1711.7	4248.0
2019-06-09 20:00:00	GC	Futures	1711.7	1715.2	1711.7	1712.3	7785.0
2019-06-09 21:00:00	GC	Futures	1712.3	1712.3	1703.7	1705.5	18869.0
2019-06-09 22:00:00	GC	Futures	1705.6	1706.3	1703.9	1705.1	6768.0
2019-06-09 23:00:00	GC	Futures	1705.1	1705.5	1704.2	1704.7	3130.0
2019-06-09 18:00:00	ZN	Futures	127.553946	127.648268	127.491065	127.616827	44139.0
2019-06-09 19:00:00	ZN	Futures	127.632547	127.679708	127.601107	127.648268	13185.0
2019-06-09 20:00:00	ZN	Futures	127.648268	127.742589	127.616827	127.726869	25265.0
2019-06-09 21:00:00	ZN	Futures	127.726869	127.742589	127.648268	127.695428	16442.0
2019-06-09 22:00:00	ZN	Futures	127.695428	127.711148	127.679708	127.711148	4771.0
2019-06-09 23:00:00	ZN	Futures	127.711148	127.742589	127.695428	127.695428	8250.0

> showing 36 of 344 rows — these rows as CSV

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