PREVIEW / futures_1hour / 2018-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-30.parquet
  size:    56 KB
  rows:    1,708

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-30 00:00:00	ES	Futures	3104.19	3105.55	3101.45	3102.27	12308.0
2018-01-30 01:00:00	ES	Futures	3102.27	3109.38	3102.27	3109.11	7341.0
2018-01-30 02:00:00	ES	Futures	3109.38	3110.2	3102.27	3104.19	17861.0
2018-01-30 03:00:00	ES	Futures	3104.46	3110.75	3104.19	3106.65	26429.0
2018-01-30 04:00:00	ES	Futures	3106.65	3111.02	3105.28	3111.02	16277.0
2018-01-30 05:00:00	ES	Futures	3110.75	3111.29	3106.1	3106.37	15221.0
2018-01-30 06:00:00	ES	Futures	3106.37	3108.56	3105.28	3105.83	13849.0
2018-01-30 07:00:00	ES	Futures	3105.83	3106.65	3100.36	3104.46	32927.0
2018-01-30 08:00:00	ES	Futures	3104.73	3108.01	3098.99	3099.27	57257.0
2018-01-30 09:00:00	ES	Futures	3099.27	3104.46	3089.43	3090.25	367359.0
2018-01-30 10:00:00	ES	Futures	3090.25	3099.81	3081.5	3098.45	371743.0
2018-01-30 11:00:00	ES	Futures	3098.45	3101.73	3089.43	3089.97	193889.0
2018-01-30 12:00:00	ES	Futures	3090.25	3093.25	3086.69	3089.43	129987.0
2018-01-30 13:00:00	ES	Futures	3089.43	3093.8	3083.69	3092.16	139289.0
2018-01-30 14:00:00	ES	Futures	3091.89	3096.53	3085.33	3086.69	170445.0
2018-01-30 15:00:00	ES	Futures	3086.97	3095.99	3085.33	3086.97	230986.0
2018-01-30 16:00:00	ES	Futures	3086.97	3091.61	3084.78	3086.69	115502.0
2018-01-30 18:00:00	ES	Futures	3086.69	3089.7	3085.87	3087.51	11719.0
2018-01-30 19:00:00	ES	Futures	3087.79	3091.89	3087.24	3087.51	13091.0
2018-01-30 20:00:00	ES	Futures	3087.24	3093.8	3087.24	3092.98	10088.0
2018-01-30 21:00:00	ES	Futures	3092.71	3094.35	3088.61	3093.25	13624.0
2018-01-30 22:00:00	ES	Futures	3093.25	3100.09	3092.71	3098.99	17895.0
2018-01-30 23:00:00	ES	Futures	3098.72	3098.99	3095.71	3097.08	6573.0
2018-01-30 00:00:00	NQ	Futures	8245.62	8247.1	8233.46	8238.2	3728.0
2018-01-30 01:00:00	NQ	Futures	8238.8	8257.18	8238.5	8256.0	2566.0
2018-01-30 02:00:00	NQ	Futures	8256.59	8265.49	8243.84	8250.96	4795.0
2018-01-30 03:00:00	NQ	Futures	8251.25	8267.56	8246.51	8256.89	7466.0
2018-01-30 04:00:00	NQ	Futures	8256.59	8266.38	8251.55	8265.79	4442.0
2018-01-30 05:00:00	NQ	Futures	8265.79	8267.27	8252.74	8254.81	3444.0
2018-01-30 06:00:00	NQ	Futures	8254.81	8263.41	8251.85	8254.22	2653.0
2018-01-30 07:00:00	NQ	Futures	8254.22	8265.19	8247.99	8257.48	8010.0
2018-01-30 08:00:00	NQ	Futures	8257.78	8262.52	8234.94	8236.42	12812.0
2018-01-30 09:00:00	NQ	Futures	8236.13	8245.02	8201.42	8208.54	88934.0
2018-01-30 10:00:00	NQ	Futures	8208.84	8252.74	8189.26	8250.07	103824.0
2018-01-30 11:00:00	NQ	Futures	8250.36	8268.16	8229.9	8232.86	66596.0
2018-01-30 12:00:00	NQ	Futures	8233.16	8243.84	8216.55	8225.75	37430.0
2018-01-30 13:00:00	NQ	Futures	8225.45	8242.95	8204.69	8236.72	41783.0
2018-01-30 14:00:00	NQ	Futures	8237.02	8250.36	8217.44	8221.3	43712.0
2018-01-30 15:00:00	NQ	Futures	8221.3	8251.85	8217.44	8234.94	47767.0
2018-01-30 16:00:00	NQ	Futures	8234.64	8245.62	8227.82	8233.16	10670.0
2018-01-30 18:00:00	NQ	Futures	8231.38	8244.73	8229.6	8234.94	2641.0
2018-01-30 19:00:00	NQ	Futures	8235.24	8246.21	8231.68	8232.57	2793.0
2018-01-30 20:00:00	NQ	Futures	8231.97	8253.03	8231.97	8252.14	2760.0
2018-01-30 21:00:00	NQ	Futures	8251.55	8256.0	8239.39	8254.22	3019.0
2018-01-30 22:00:00	NQ	Futures	8254.51	8275.87	8253.62	8266.68	5515.0
2018-01-30 23:00:00	NQ	Futures	8266.68	8268.45	8259.85	8264.6	2092.0
2018-01-30 00:00:00	YM	Futures	28512.1	28528.4	28488.2	28519.7	2449.0
2018-01-30 01:00:00	YM	Futures	28519.7	28584.9	28518.6	28580.6	2396.0
2018-01-30 02:00:00	YM	Futures	28582.8	28600.2	28491.5	28517.6	4005.0
2018-01-30 03:00:00	YM	Futures	28517.6	28594.7	28516.5	28554.5	5963.0

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

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