PREVIEW / futures_1hour / 2019-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-12.parquet
  size:    17 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-05-12 18:00:00	ES	Futures	3099.78	3111.44	3097.34	3104.66	27400.0
2019-05-12 19:00:00	ES	Futures	3104.66	3107.37	3097.89	3098.16	17410.0
2019-05-12 20:00:00	ES	Futures	3098.43	3101.14	3093.28	3099.51	29974.0
2019-05-12 21:00:00	ES	Futures	3099.51	3102.77	3097.89	3101.68	11302.0
2019-05-12 22:00:00	ES	Futures	3101.41	3101.95	3096.53	3099.51	9488.0
2019-05-12 23:00:00	ES	Futures	3099.78	3100.33	3098.16	3098.7	4386.0
2019-05-12 18:00:00	NQ	Futures	8774.57	8794.66	8759.72	8777.19	10121.0
2019-05-12 19:00:00	NQ	Futures	8777.77	8790.0	8755.64	8755.94	7510.0
2019-05-12 20:00:00	NQ	Futures	8755.94	8764.38	8742.25	8758.85	11285.0
2019-05-12 21:00:00	NQ	Futures	8759.43	8773.41	8753.9	8768.75	7297.0
2019-05-12 22:00:00	NQ	Futures	8768.75	8771.37	8752.15	8762.05	5610.0
2019-05-12 23:00:00	NQ	Futures	8762.34	8764.67	8755.64	8758.85	2212.0
2019-05-12 18:00:00	YM	Futures	28022.7	28081.4	27941.1	28028.1	7077.0
2019-05-12 19:00:00	YM	Futures	28027.0	28046.6	27966.1	27972.6	2927.0
2019-05-12 20:00:00	YM	Futures	27973.7	27990.0	27925.9	27974.8	7169.0
2019-05-12 21:00:00	YM	Futures	27974.8	28007.4	27961.7	27997.6	4104.0
2019-05-12 22:00:00	YM	Futures	27995.5	28002.0	27956.3	27981.3	3151.0
2019-05-12 23:00:00	YM	Futures	27982.4	27986.8	27965.0	27972.6	1656.0
2019-05-12 18:00:00	CL	Futures	55.12	55.27	54.77	54.86	10237.0
2019-05-12 19:00:00	CL	Futures	54.86	54.9	54.78	54.82	3296.0
2019-05-12 20:00:00	CL	Futures	54.82	54.92	54.72	54.85	7582.0
2019-05-12 21:00:00	CL	Futures	54.86	55.14	54.8	55.04	11265.0
2019-05-12 22:00:00	CL	Futures	55.03	55.12	54.99	55.08	6954.0
2019-05-12 23:00:00	CL	Futures	55.09	55.17	55.04	55.09	5209.0
2019-05-12 18:00:00	GC	Futures	1653.2	1653.9	1652.0	1653.2	2583.0
2019-05-12 19:00:00	GC	Futures	1653.1	1654.0	1652.6	1652.9	1855.0
2019-05-12 20:00:00	GC	Futures	1652.9	1654.4	1652.7	1653.0	3904.0
2019-05-12 21:00:00	GC	Futures	1653.0	1653.2	1649.8	1649.9	7482.0
2019-05-12 22:00:00	GC	Futures	1649.9	1650.3	1648.2	1649.1	8769.0
2019-05-12 23:00:00	GC	Futures	1649.1	1649.3	1647.9	1648.2	2793.0
2019-05-12 18:00:00	ZN	Futures	124.757815	124.820649	124.663563	124.773523	25916.0
2019-05-12 19:00:00	ZN	Futures	124.757815	124.836358	124.757815	124.820649	14076.0
2019-05-12 20:00:00	ZN	Futures	124.820649	124.883484	124.789232	124.789232	34912.0
2019-05-12 21:00:00	ZN	Futures	124.804941	124.804941	124.757815	124.757815	14289.0
2019-05-12 22:00:00	ZN	Futures	124.757815	124.820649	124.757815	124.804941	16352.0
2019-05-12 23:00:00	ZN	Futures	124.804941	124.804941	124.773523	124.804941	4834.0

> showing 36 of 367 rows — these rows as CSV

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