PREVIEW / futures_1hour / 2019-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-26.parquet
  size:    15 KB
  rows:    298

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-05-26 18:00:00	ES	Futures	3069.96	3072.94	3068.06	3072.13	4679.0
2019-05-26 19:00:00	ES	Futures	3071.86	3074.3	3069.69	3069.69	3810.0
2019-05-26 20:00:00	ES	Futures	3069.42	3073.22	3064.54	3071.59	10681.0
2019-05-26 21:00:00	ES	Futures	3071.32	3071.59	3067.52	3069.96	9077.0
2019-05-26 22:00:00	ES	Futures	3069.96	3072.13	3067.79	3068.34	5609.0
2019-05-26 23:00:00	ES	Futures	3068.06	3068.88	3066.17	3068.61	4339.0
2019-05-26 18:00:00	NQ	Futures	8519.81	8523.59	8511.07	8517.48	2553.0
2019-05-26 19:00:00	NQ	Futures	8517.77	8527.09	8512.82	8513.4	2160.0
2019-05-26 20:00:00	NQ	Futures	8513.11	8522.14	8493.6	8517.77	5088.0
2019-05-26 21:00:00	NQ	Futures	8517.48	8519.52	8505.54	8512.24	4395.0
2019-05-26 22:00:00	NQ	Futures	8512.82	8521.56	8506.71	8508.16	2794.0
2019-05-26 23:00:00	NQ	Futures	8508.16	8510.49	8496.81	8505.25	3556.0
2019-05-26 18:00:00	YM	Futures	27854.1	27893.2	27842.1	27885.6	1893.0
2019-05-26 19:00:00	YM	Futures	27886.7	27908.5	27870.4	27871.5	1470.0
2019-05-26 20:00:00	YM	Futures	27869.3	27906.3	27825.8	27886.7	4289.0
2019-05-26 21:00:00	YM	Futures	27886.7	27886.7	27849.7	27873.6	4355.0
2019-05-26 22:00:00	YM	Futures	27873.6	27887.8	27851.9	27856.2	1953.0
2019-05-26 23:00:00	YM	Futures	27854.1	27867.1	27842.1	27864.9	1595.0
2019-05-26 18:00:00	CL	Futures	52.56	52.64	52.31	52.46	6105.0
2019-05-26 19:00:00	CL	Futures	52.45	52.56	52.39	52.4	2906.0
2019-05-26 20:00:00	CL	Futures	52.4	52.5	52.29	52.39	6420.0
2019-05-26 21:00:00	CL	Futures	52.39	52.39	52.19	52.23	11829.0
2019-05-26 22:00:00	CL	Futures	52.23	52.29	52.15	52.19	4907.0
2019-05-26 23:00:00	CL	Futures	52.19	52.19	52.07	52.1	5508.0
2019-05-26 18:00:00	GC	Futures	1648.1	1650.9	1648.1	1649.0	310.0
2019-05-26 19:00:00	GC	Futures	1648.9	1649.0	1648.4	1649.0	117.0
2019-05-26 20:00:00	GC	Futures	1648.8	1649.1	1647.7	1648.8	618.0
2019-05-26 21:00:00	GC	Futures	1648.9	1652.5	1648.9	1652.1	1707.0
2019-05-26 22:00:00	GC	Futures	1652.2	1652.2	1650.9	1651.4	585.0
2019-05-26 23:00:00	GC	Futures	1651.4	1652.0	1651.3	1651.7	359.0
2019-05-26 18:00:00	ZN	Futures	125.684623	125.71604	125.668914	125.668914	8000.0
2019-05-26 19:00:00	ZN	Futures	125.668914	125.684623	125.653206	125.668914	4974.0
2019-05-26 20:00:00	ZN	Futures	125.668914	125.700332	125.621789	125.637497	7105.0
2019-05-26 21:00:00	ZN	Futures	125.637497	125.653206	125.621789	125.621789	6452.0
2019-05-26 22:00:00	ZN	Futures	125.621789	125.637497	125.60608	125.621789	6114.0
2019-05-26 23:00:00	ZN	Futures	125.637497	125.637497	125.60608	125.60608	958.0

> showing 36 of 298 rows — these rows as CSV

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