PREVIEW / futures_1hour / 2019-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-31.parquet
  size:    16 KB
  rows:    343

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-03-31 18:00:00	ES	Futures	3084.6	3094.63	3084.6	3091.38	16516.0
2019-03-31 19:00:00	ES	Futures	3091.38	3094.36	3090.02	3093.28	9447.0
2019-03-31 20:00:00	ES	Futures	3093.28	3098.7	3093.01	3095.99	21726.0
2019-03-31 21:00:00	ES	Futures	3095.72	3098.97	3094.9	3097.34	11808.0
2019-03-31 22:00:00	ES	Futures	3097.34	3101.41	3096.26	3099.51	12038.0
2019-03-31 23:00:00	ES	Futures	3099.51	3099.78	3097.89	3098.7	4053.0
2019-03-31 18:00:00	NQ	Futures	8653.16	8681.69	8651.41	8675.29	7154.0
2019-03-31 19:00:00	NQ	Futures	8675.29	8684.89	8674.7	8683.15	4587.0
2019-03-31 20:00:00	NQ	Futures	8682.86	8702.65	8682.27	8693.92	8575.0
2019-03-31 21:00:00	NQ	Futures	8693.92	8706.44	8691.88	8701.2	5804.0
2019-03-31 22:00:00	NQ	Futures	8700.91	8720.12	8697.12	8714.88	8118.0
2019-03-31 23:00:00	NQ	Futures	8715.47	8716.63	8710.22	8712.55	2371.0
2019-03-31 18:00:00	YM	Futures	28253.2	28371.8	28253.2	28343.5	2727.0
2019-03-31 19:00:00	YM	Futures	28341.3	28365.3	28318.5	28358.7	2263.0
2019-03-31 20:00:00	YM	Futures	28357.7	28400.1	28353.3	28376.1	3442.0
2019-03-31 21:00:00	YM	Futures	28376.1	28408.8	28369.6	28389.2	2514.0
2019-03-31 22:00:00	YM	Futures	28391.4	28426.2	28381.6	28403.3	2281.0
2019-03-31 23:00:00	YM	Futures	28404.4	28409.9	28387.0	28393.6	1071.0
2019-03-31 18:00:00	CL	Futures	53.97	54.15	53.87	54.09	3785.0
2019-03-31 19:00:00	CL	Futures	54.09	54.13	54.04	54.08	2257.0
2019-03-31 20:00:00	CL	Futures	54.08	54.19	54.07	54.15	4167.0
2019-03-31 21:00:00	CL	Futures	54.15	54.22	54.11	54.16	6282.0
2019-03-31 22:00:00	CL	Futures	54.17	54.22	54.14	54.19	3637.0
2019-03-31 23:00:00	CL	Futures	54.2	54.22	54.17	54.22	2551.0
2019-03-31 18:00:00	GC	Futures	1664.7	1665.6	1663.8	1664.3	2464.0
2019-03-31 19:00:00	GC	Futures	1664.3	1664.4	1663.1	1663.6	3205.0
2019-03-31 20:00:00	GC	Futures	1663.5	1663.6	1661.6	1663.4	4470.0
2019-03-31 21:00:00	GC	Futures	1663.4	1666.1	1663.4	1664.0	8856.0
2019-03-31 22:00:00	GC	Futures	1664.0	1665.7	1663.4	1665.2	4948.0
2019-03-31 23:00:00	GC	Futures	1665.2	1666.2	1665.1	1665.7	3742.0
2019-03-31 18:00:00	ZN	Futures	124.820649	124.836358	124.69498	124.757815	23881.0
2019-03-31 19:00:00	ZN	Futures	124.742106	124.789232	124.710689	124.757815	8421.0
2019-03-31 20:00:00	ZN	Futures	124.757815	124.757815	124.632146	124.663563	43534.0
2019-03-31 21:00:00	ZN	Futures	124.647855	124.69498	124.616437	124.616437	23161.0
2019-03-31 22:00:00	ZN	Futures	124.616437	124.663563	124.616437	124.632146	8016.0
2019-03-31 23:00:00	ZN	Futures	124.647855	124.69498	124.632146	124.663563	10376.0

> showing 36 of 343 rows — these rows as CSV

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