PREVIEW / futures_1hour / 2019-12-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-25.parquet
  size:    14 KB
  rows:    282

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-12-25 18:00:00	ES	Futures	3498.5	3499.3	3497.9	3498.5	3755.0
2019-12-25 19:00:00	ES	Futures	3498.2	3502.3	3498.2	3501.5	6604.0
2019-12-25 20:00:00	ES	Futures	3501.2	3501.7	3500.4	3500.7	2078.0
2019-12-25 21:00:00	ES	Futures	3500.7	3501.7	3500.7	3501.7	1497.0
2019-12-25 22:00:00	ES	Futures	3501.7	3501.7	3500.9	3501.5	1562.0
2019-12-25 23:00:00	ES	Futures	3501.5	3501.5	3500.7	3500.7	1016.0
2019-12-25 18:00:00	NQ	Futures	10098.22	10101.4	10096.77	10098.51	1310.0
2019-12-25 19:00:00	NQ	Futures	10098.22	10109.21	10097.06	10106.9	2952.0
2019-12-25 20:00:00	NQ	Futures	10106.61	10108.05	10104.58	10105.16	1039.0
2019-12-25 21:00:00	NQ	Futures	10105.16	10108.63	10104.58	10107.47	961.0
2019-12-25 22:00:00	NQ	Futures	10107.47	10107.76	10101.98	10106.03	1348.0
2019-12-25 23:00:00	NQ	Futures	10106.32	10106.32	10103.71	10105.16	544.0
2019-12-25 18:00:00	YM	Futures	31048.8	31060.7	31040.0	31047.7	840.0
2019-12-25 19:00:00	YM	Futures	31047.7	31076.0	31042.2	31069.4	1673.0
2019-12-25 20:00:00	YM	Futures	31068.4	31071.6	31062.9	31062.9	580.0
2019-12-25 21:00:00	YM	Futures	31064.0	31076.0	31062.9	31072.7	512.0
2019-12-25 22:00:00	YM	Futures	31071.6	31077.1	31068.4	31073.8	603.0
2019-12-25 23:00:00	YM	Futures	31073.8	31074.9	31069.4	31071.6	352.0
2019-12-25 18:00:00	CL	Futures	54.23	54.53	54.2	54.22	4442.0
2019-12-25 19:00:00	CL	Futures	54.21	54.31	54.21	54.27	1629.0
2019-12-25 20:00:00	CL	Futures	54.27	54.34	54.25	54.34	4423.0
2019-12-25 21:00:00	CL	Futures	54.34	54.39	54.33	54.37	3408.0
2019-12-25 22:00:00	CL	Futures	54.38	54.39	54.36	54.37	1301.0
2019-12-25 23:00:00	CL	Futures	54.37	54.39	54.36	54.36	1081.0
2019-12-25 18:00:00	GC	Futures	1896.2	1897.3	1893.9	1896.3	3348.0
2019-12-25 19:00:00	GC	Futures	1896.4	1896.8	1894.1	1894.8	3034.0
2019-12-25 20:00:00	GC	Futures	1894.8	1898.5	1894.4	1898.4	5899.0
2019-12-25 21:00:00	GC	Futures	1898.4	1901.7	1898.4	1900.9	9682.0
2019-12-25 22:00:00	GC	Futures	1901.1	1902.0	1900.8	1901.2	3514.0
2019-12-25 23:00:00	GC	Futures	1901.2	1901.3	1899.9	1900.7	2528.0
2019-12-25 18:00:00	ZN	Futures	128.512676	128.543963	128.497032	128.512676	4087.0
2019-12-25 19:00:00	ZN	Futures	128.497032	128.512676	128.434457	128.450101	3838.0
2019-12-25 20:00:00	ZN	Futures	128.434457	128.465745	128.434457	128.450101	1921.0
2019-12-25 21:00:00	ZN	Futures	128.450101	128.465745	128.434457	128.434457	2327.0
2019-12-25 22:00:00	ZN	Futures	128.450101	128.497032	128.450101	128.465745	2636.0
2019-12-25 23:00:00	ZN	Futures	128.481388	128.481388	128.465745	128.481388	605.0

> showing 36 of 282 rows — these rows as CSV

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