PREVIEW / futures_1hour / 2019-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-30.parquet
  size:    18 KB
  rows:    367

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-30 18:00:00	ES	Futures	3215.98	3224.1	3214.35	3217.6	38669.0
2019-06-30 19:00:00	ES	Futures	3217.87	3218.68	3215.71	3217.6	9010.0
2019-06-30 20:00:00	ES	Futures	3217.33	3217.6	3208.4	3209.75	19935.0
2019-06-30 21:00:00	ES	Futures	3209.48	3214.08	3209.48	3213.81	14994.0
2019-06-30 22:00:00	ES	Futures	3213.81	3215.98	3213.54	3215.16	8272.0
2019-06-30 23:00:00	ES	Futures	3215.16	3215.71	3213.81	3215.43	4552.0
2019-06-30 18:00:00	NQ	Futures	9030.97	9080.88	9030.97	9054.18	13959.0
2019-06-30 19:00:00	NQ	Futures	9054.18	9059.7	9048.38	9055.35	2730.0
2019-06-30 20:00:00	NQ	Futures	9055.35	9056.22	9020.82	9026.91	7381.0
2019-06-30 21:00:00	NQ	Futures	9026.91	9042.0	9025.75	9036.2	8459.0
2019-06-30 22:00:00	NQ	Futures	9035.91	9042.58	9035.62	9041.13	3451.0
2019-06-30 23:00:00	NQ	Futures	9040.84	9046.06	9035.91	9045.19	1978.0
2019-06-30 18:00:00	YM	Futures	29162.4	29212.4	29135.2	29166.8	5979.0
2019-06-30 19:00:00	YM	Futures	29166.8	29173.3	29145.0	29158.1	1844.0
2019-06-30 20:00:00	YM	Futures	29158.1	29158.1	29087.4	29103.7	4669.0
2019-06-30 21:00:00	YM	Futures	29104.8	29137.4	29100.4	29132.0	3750.0
2019-06-30 22:00:00	YM	Futures	29132.0	29153.7	29132.0	29145.0	2013.0
2019-06-30 23:00:00	YM	Futures	29145.0	29155.9	29134.1	29152.6	1120.0
2019-06-30 18:00:00	CL	Futures	52.59	53.33	52.59	52.7	15553.0
2019-06-30 19:00:00	CL	Futures	52.7	52.84	52.65	52.84	4439.0
2019-06-30 20:00:00	CL	Futures	52.83	53.07	52.74	52.75	9348.0
2019-06-30 21:00:00	CL	Futures	52.74	52.98	52.73	52.97	15641.0
2019-06-30 22:00:00	CL	Futures	52.97	53.01	52.92	52.96	7362.0
2019-06-30 23:00:00	CL	Futures	52.95	53.16	52.93	53.13	5722.0
2019-06-30 18:00:00	GC	Futures	1792.1	1792.2	1773.1	1788.5	20467.0
2019-06-30 19:00:00	GC	Futures	1788.4	1790.8	1783.0	1783.5	11394.0
2019-06-30 20:00:00	GC	Futures	1783.4	1789.0	1782.0	1788.6	9795.0
2019-06-30 21:00:00	GC	Futures	1788.6	1790.1	1783.2	1784.6	18694.0
2019-06-30 22:00:00	GC	Futures	1784.6	1785.5	1781.1	1782.6	8601.0
2019-06-30 23:00:00	GC	Futures	1782.6	1783.9	1782.2	1783.2	3528.0
2019-06-30 18:00:00	ZN	Futures	128.387118	128.449999	128.308517	128.371398	40227.0
2019-06-30 19:00:00	ZN	Futures	128.387118	128.402839	128.339958	128.339958	12775.0
2019-06-30 20:00:00	ZN	Futures	128.339958	128.449999	128.339958	128.434279	35000.0
2019-06-30 21:00:00	ZN	Futures	128.434279	128.48144	128.355678	128.48144	40072.0
2019-06-30 22:00:00	ZN	Futures	128.465719	128.49716	128.449999	128.48144	10137.0
2019-06-30 23:00:00	ZN	Futures	128.48144	128.48144	128.449999	128.48144	5259.0

> showing 36 of 367 rows — these rows as CSV

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