PREVIEW / futures_1hour / 2019-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-06.parquet
  size:    17 KB
  rows:    350

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-01-06 18:00:00	ES	Futures	2756.31	2757.94	2751.15	2757.4	15496.0
2019-01-06 19:00:00	ES	Futures	2757.4	2772.06	2755.77	2763.64	35276.0
2019-01-06 20:00:00	ES	Futures	2763.64	2766.63	2759.03	2760.39	17583.0
2019-01-06 21:00:00	ES	Futures	2760.66	2763.37	2757.67	2757.67	13296.0
2019-01-06 22:00:00	ES	Futures	2757.67	2759.57	2756.04	2759.03	10067.0
2019-01-06 23:00:00	ES	Futures	2759.03	2759.84	2756.58	2757.94	5902.0
2019-01-06 18:00:00	NQ	Futures	7539.95	7544.33	7526.51	7539.95	5741.0
2019-01-06 19:00:00	NQ	Futures	7540.24	7591.66	7534.98	7564.78	10689.0
2019-01-06 20:00:00	NQ	Futures	7565.07	7576.18	7546.08	7552.22	6761.0
2019-01-06 21:00:00	NQ	Futures	7552.22	7560.4	7542.28	7543.74	5586.0
2019-01-06 22:00:00	NQ	Futures	7544.04	7550.76	7539.07	7549.0	3381.0
2019-01-06 23:00:00	NQ	Futures	7549.3	7550.76	7539.07	7543.74	2332.0
2019-01-06 18:00:00	YM	Futures	25481.5	25502.2	25421.8	25495.7	2841.0
2019-01-06 19:00:00	YM	Futures	25496.7	25648.7	25482.6	25560.8	8419.0
2019-01-06 20:00:00	YM	Futures	25561.9	25589.0	25513.0	25531.5	3998.0
2019-01-06 21:00:00	YM	Futures	25530.4	25557.5	25504.3	25508.7	3127.0
2019-01-06 22:00:00	YM	Futures	25506.5	25526.1	25481.5	25523.9	2873.0
2019-01-06 23:00:00	YM	Futures	25523.9	25532.6	25494.6	25507.6	1928.0
2019-01-06 18:00:00	CL	Futures	44.09	44.42	43.91	44.36	6584.0
2019-01-06 19:00:00	CL	Futures	44.37	44.62	44.31	44.36	6791.0
2019-01-06 20:00:00	CL	Futures	44.36	44.36	44.12	44.25	9166.0
2019-01-06 21:00:00	CL	Futures	44.24	44.44	44.23	44.4	8387.0
2019-01-06 22:00:00	CL	Futures	44.4	44.54	44.24	44.43	8798.0
2019-01-06 23:00:00	CL	Futures	44.42	44.55	44.39	44.42	5052.0
2019-01-06 18:00:00	GC	Futures	1667.2	1668.9	1665.4	1665.7	2752.0
2019-01-06 19:00:00	GC	Futures	1665.7	1666.6	1663.5	1666.5	5058.0
2019-01-06 20:00:00	GC	Futures	1666.5	1673.2	1666.3	1671.5	10399.0
2019-01-06 21:00:00	GC	Futures	1671.5	1672.3	1670.6	1671.9	5092.0
2019-01-06 22:00:00	GC	Futures	1671.9	1672.5	1671.2	1671.4	3250.0
2019-01-06 23:00:00	GC	Futures	1671.4	1672.4	1671.0	1671.4	2611.0
2019-01-06 18:00:00	ZN	Futures	123.09228	123.139502	123.060798	123.10802	16762.0
2019-01-06 19:00:00	ZN	Futures	123.123761	123.155242	123.013576	123.060798	26351.0
2019-01-06 20:00:00	ZN	Futures	123.060798	123.139502	123.060798	123.10802	13527.0
2019-01-06 21:00:00	ZN	Futures	123.10802	123.139502	123.09228	123.10802	12290.0
2019-01-06 22:00:00	ZN	Futures	123.10802	123.139502	123.09228	123.10802	9118.0
2019-01-06 23:00:00	ZN	Futures	123.10802	123.123761	123.076539	123.09228	6690.0

> showing 36 of 350 rows — these rows as CSV

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