PREVIEW / futures_1hour / 2017-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-27.parquet
  size:    15 KB
  rows:    289

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-08-27 18:00:00	ES	Futures	2669.98	2671.34	2665.06	2670.25	9314.0
2017-08-27 19:00:00	ES	Futures	2670.52	2670.8	2669.16	2669.98	3162.0
2017-08-27 20:00:00	ES	Futures	2669.7	2673.26	2665.06	2666.97	14438.0
2017-08-27 21:00:00	ES	Futures	2666.97	2667.79	2665.33	2666.15	6671.0
2017-08-27 22:00:00	ES	Futures	2666.42	2667.79	2666.15	2667.24	3762.0
2017-08-27 23:00:00	ES	Futures	2667.24	2668.06	2666.97	2666.97	2229.0
2017-08-27 18:00:00	NQ	Futures	6931.35	6937.01	6914.38	6934.03	2317.0
2017-08-27 19:00:00	NQ	Futures	6934.33	6936.12	6929.56	6931.95	810.0
2017-08-27 20:00:00	NQ	Futures	6931.95	6942.96	6916.76	6925.4	3877.0
2017-08-27 21:00:00	NQ	Futures	6925.1	6927.78	6917.65	6920.63	1714.0
2017-08-27 22:00:00	NQ	Futures	6920.33	6928.37	6920.33	6926.29	1659.0
2017-08-27 23:00:00	NQ	Futures	6926.29	6930.76	6923.91	6928.37	911.0
2017-08-27 18:00:00	YM	Futures	23731.1	23752.9	23702.8	23738.7	1719.0
2017-08-27 19:00:00	YM	Futures	23737.6	23742.0	23731.1	23735.4	685.0
2017-08-27 20:00:00	YM	Futures	23735.4	23757.2	23694.1	23709.3	2846.0
2017-08-27 21:00:00	YM	Futures	23709.3	23718.0	23697.3	23703.9	1225.0
2017-08-27 22:00:00	YM	Futures	23703.9	23716.9	23702.8	23712.6	914.0
2017-08-27 23:00:00	YM	Futures	23712.6	23718.0	23707.1	23709.3	636.0
2017-08-27 18:00:00	CL	Futures	43.31	43.59	43.27	43.32	7838.0
2017-08-27 19:00:00	CL	Futures	43.31	43.35	43.12	43.14	6408.0
2017-08-27 20:00:00	CL	Futures	43.15	43.2	43.06	43.15	7673.0
2017-08-27 21:00:00	CL	Futures	43.16	43.17	43.11	43.13	4900.0
2017-08-27 22:00:00	CL	Futures	43.13	43.17	43.1	43.16	3611.0
2017-08-27 23:00:00	CL	Futures	43.16	43.16	43.12	43.12	2170.0
2017-08-27 18:00:00	GC	Futures	1728.6	1729.9	1727.8	1729.1	2256.0
2017-08-27 19:00:00	GC	Futures	1729.0	1731.7	1728.7	1728.9	5786.0
2017-08-27 20:00:00	GC	Futures	1729.0	1730.9	1727.9	1730.1	6793.0
2017-08-27 21:00:00	GC	Futures	1730.2	1731.5	1729.8	1731.4	5362.0
2017-08-27 22:00:00	GC	Futures	1731.4	1731.9	1730.9	1731.0	3294.0
2017-08-27 23:00:00	GC	Futures	1731.0	1731.4	1730.7	1730.9	1785.0
2017-08-27 18:00:00	ZN	Futures	126.105524	126.121054	126.058933	126.058933	3555.0
2017-08-27 19:00:00	ZN	Futures	126.058933	126.105524	126.043403	126.058933	6753.0
2017-08-27 20:00:00	ZN	Futures	126.058933	126.105524	126.027873	126.089994	11793.0
2017-08-27 21:00:00	ZN	Futures	126.089994	126.105524	126.058933	126.074464	4013.0
2017-08-27 22:00:00	ZN	Futures	126.074464	126.089994	126.058933	126.058933	2916.0
2017-08-27 23:00:00	ZN	Futures	126.058933	126.074464	126.043403	126.074464	3138.0

> showing 36 of 289 rows — these rows as CSV

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