PREVIEW / futures_1hour / 2018-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-22.parquet
  size:    53 KB
  rows:    1,647

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
2018-01-22 00:00:00	ES	Futures	3069.2	3070.02	3068.93	3069.75	3327.0
2018-01-22 01:00:00	ES	Futures	3069.47	3070.29	3068.65	3069.2	2033.0
2018-01-22 02:00:00	ES	Futures	3069.2	3070.02	3067.83	3068.38	3760.0
2018-01-22 03:00:00	ES	Futures	3068.11	3071.11	3067.83	3069.47	13718.0
2018-01-22 04:00:00	ES	Futures	3069.2	3069.75	3067.56	3068.93	10211.0
2018-01-22 05:00:00	ES	Futures	3068.93	3069.75	3067.83	3069.47	5777.0
2018-01-22 06:00:00	ES	Futures	3069.47	3071.39	3069.47	3071.11	6886.0
2018-01-22 07:00:00	ES	Futures	3070.84	3072.75	3070.29	3072.75	8879.0
2018-01-22 08:00:00	ES	Futures	3072.48	3074.39	3070.02	3070.57	24366.0
2018-01-22 09:00:00	ES	Futures	3070.57	3078.49	3069.47	3077.13	117822.0
2018-01-22 10:00:00	ES	Futures	3077.13	3085.87	3076.31	3081.23	196933.0
2018-01-22 11:00:00	ES	Futures	3080.95	3086.42	3079.86	3086.15	126696.0
2018-01-22 12:00:00	ES	Futures	3085.87	3091.89	3084.78	3089.43	116803.0
2018-01-22 13:00:00	ES	Futures	3089.15	3091.34	3088.06	3090.25	62194.0
2018-01-22 14:00:00	ES	Futures	3090.25	3091.07	3086.15	3089.15	64647.0
2018-01-22 15:00:00	ES	Futures	3088.88	3100.09	3088.88	3099.54	185898.0
2018-01-22 16:00:00	ES	Futures	3099.81	3103.09	3098.99	3100.09	102244.0
2018-01-22 18:00:00	ES	Futures	3099.81	3100.63	3098.72	3099.54	6914.0
2018-01-22 19:00:00	ES	Futures	3099.54	3100.63	3098.45	3100.36	7101.0
2018-01-22 20:00:00	ES	Futures	3100.09	3103.09	3098.99	3102.0	10099.0
2018-01-22 21:00:00	ES	Futures	3101.73	3102.27	3100.09	3100.63	4216.0
2018-01-22 22:00:00	ES	Futures	3100.63	3102.0	3099.81	3101.45	4751.0
2018-01-22 23:00:00	ES	Futures	3101.73	3103.64	3101.18	3103.09	4987.0
2018-01-22 00:00:00	NQ	Futures	8112.45	8116.89	8110.96	8116.89	923.0
2018-01-22 01:00:00	NQ	Futures	8116.6	8118.67	8113.93	8116.89	1189.0
2018-01-22 02:00:00	NQ	Futures	8117.78	8118.67	8110.96	8112.45	1195.0
2018-01-22 03:00:00	NQ	Futures	8113.04	8124.01	8109.18	8118.08	2678.0
2018-01-22 04:00:00	NQ	Futures	8117.49	8117.49	8111.26	8112.74	1727.0
2018-01-22 05:00:00	NQ	Futures	8113.04	8116.01	8109.78	8115.71	1268.0
2018-01-22 06:00:00	NQ	Futures	8115.71	8120.75	8114.82	8118.08	1508.0
2018-01-22 07:00:00	NQ	Futures	8117.78	8122.53	8116.3	8121.34	1683.0
2018-01-22 08:00:00	NQ	Futures	8121.05	8126.68	8115.71	8117.19	6848.0
2018-01-22 09:00:00	NQ	Futures	8116.89	8136.17	8108.0	8132.32	42613.0
2018-01-22 10:00:00	NQ	Futures	8132.02	8171.47	8128.76	8159.31	54268.0
2018-01-22 11:00:00	NQ	Futures	8159.31	8178.29	8158.12	8176.81	24730.0
2018-01-22 12:00:00	NQ	Futures	8176.51	8190.75	8172.65	8183.33	24815.0
2018-01-22 13:00:00	NQ	Futures	8183.63	8189.56	8180.66	8186.3	16162.0
2018-01-22 14:00:00	NQ	Futures	8186.0	8187.48	8174.43	8178.88	15936.0
2018-01-22 15:00:00	NQ	Futures	8178.59	8207.95	8177.99	8207.06	32359.0
2018-01-22 16:00:00	NQ	Futures	8207.36	8234.94	8206.76	8223.67	16475.0
2018-01-22 18:00:00	NQ	Futures	8221.3	8225.45	8218.03	8222.48	1676.0
2018-01-22 19:00:00	NQ	Futures	8222.48	8231.08	8221.3	8229.3	1911.0
2018-01-22 20:00:00	NQ	Futures	8228.71	8231.68	8220.41	8231.38	2447.0
2018-01-22 21:00:00	NQ	Futures	8231.08	8231.68	8224.86	8228.41	1069.0
2018-01-22 22:00:00	NQ	Futures	8228.71	8233.16	8226.93	8232.27	1531.0
2018-01-22 23:00:00	NQ	Futures	8232.27	8242.06	8231.08	8239.68	2660.0
2018-01-22 00:00:00	YM	Futures	28271.9	28280.6	28267.6	28280.6	529.0
2018-01-22 01:00:00	YM	Futures	28280.6	28285.0	28269.8	28273.0	782.0
2018-01-22 02:00:00	YM	Futures	28274.1	28278.4	28254.5	28255.6	1107.0
2018-01-22 03:00:00	YM	Futures	28255.6	28266.5	28244.8	28252.4	2044.0

> showing 50 of 1,647 rows — these rows as CSV

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