PREVIEW / futures_1hour / 2017-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-02.parquet
  size:    15 KB
  rows:    294

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-07-02 18:00:00	ES	Futures	2648.11	2651.12	2647.56	2651.12	5131.0
2017-07-02 19:00:00	ES	Futures	2651.12	2653.85	2650.02	2650.84	4252.0
2017-07-02 20:00:00	ES	Futures	2650.84	2653.58	2649.75	2651.39	6369.0
2017-07-02 21:00:00	ES	Futures	2651.39	2654.12	2650.57	2653.03	7095.0
2017-07-02 22:00:00	ES	Futures	2653.3	2654.12	2652.48	2653.3	3524.0
2017-07-02 23:00:00	ES	Futures	2653.58	2653.58	2652.48	2653.58	1910.0
2017-07-02 18:00:00	NQ	Futures	6738.71	6748.83	6736.62	6748.23	1275.0
2017-07-02 19:00:00	NQ	Futures	6747.94	6757.46	6743.77	6746.75	1326.0
2017-07-02 20:00:00	NQ	Futures	6747.04	6752.7	6739.6	6744.36	1794.0
2017-07-02 21:00:00	NQ	Futures	6744.07	6752.7	6740.49	6750.02	1200.0
2017-07-02 22:00:00	NQ	Futures	6749.72	6752.1	6745.55	6748.83	1074.0
2017-07-02 23:00:00	NQ	Futures	6748.23	6750.32	6744.96	6750.02	1077.0
2017-07-02 18:00:00	YM	Futures	23191.2	23226.0	23191.2	23226.0	746.0
2017-07-02 19:00:00	YM	Futures	23224.9	23239.1	23217.3	23220.6	934.0
2017-07-02 20:00:00	YM	Futures	23221.7	23238.0	23213.0	23217.3	1144.0
2017-07-02 21:00:00	YM	Futures	23217.3	23235.8	23210.8	23227.1	1001.0
2017-07-02 22:00:00	YM	Futures	23228.2	23234.7	23222.8	23230.4	559.0
2017-07-02 23:00:00	YM	Futures	23230.4	23233.6	23224.9	23232.6	498.0
2017-07-02 18:00:00	CL	Futures	42.14	42.17	42.06	42.15	2857.0
2017-07-02 19:00:00	CL	Futures	42.14	42.23	42.14	42.14	2549.0
2017-07-02 20:00:00	CL	Futures	42.15	42.17	42.04	42.05	4276.0
2017-07-02 21:00:00	CL	Futures	42.05	42.09	42.02	42.06	3826.0
2017-07-02 22:00:00	CL	Futures	42.06	42.16	42.06	42.13	4202.0
2017-07-02 23:00:00	CL	Futures	42.12	42.14	42.04	42.08	3061.0
2017-07-02 18:00:00	GC	Futures	1662.4	1663.6	1661.9	1662.4	1518.0
2017-07-02 19:00:00	GC	Futures	1662.2	1662.4	1660.7	1662.2	2427.0
2017-07-02 20:00:00	GC	Futures	1662.2	1662.6	1660.1	1660.2	3024.0
2017-07-02 21:00:00	GC	Futures	1660.2	1660.5	1656.9	1657.4	11065.0
2017-07-02 22:00:00	GC	Futures	1657.4	1657.4	1656.2	1656.2	6343.0
2017-07-02 23:00:00	GC	Futures	1656.2	1657.3	1655.3	1656.6	4952.0
2017-07-02 18:00:00	ZN	Futures	124.754393	124.754393	124.661212	124.692273	9306.0
2017-07-02 19:00:00	ZN	Futures	124.692273	124.692273	124.645682	124.661212	11491.0
2017-07-02 20:00:00	ZN	Futures	124.676742	124.692273	124.630152	124.645682	15877.0
2017-07-02 21:00:00	ZN	Futures	124.661212	124.692273	124.630152	124.645682	10283.0
2017-07-02 22:00:00	ZN	Futures	124.645682	124.661212	124.583561	124.583561	15412.0
2017-07-02 23:00:00	ZN	Futures	124.599091	124.614621	124.568031	124.568031	12639.0

> showing 36 of 294 rows — these rows as CSV

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