PREVIEW / futures_1hour / 2018-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-31.parquet
  size:    57 KB
  rows:    1,713

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-31 00:00:00	ES	Futures	3097.08	3097.9	3089.97	3089.97	10412.0
2018-01-31 01:00:00	ES	Futures	3090.25	3093.25	3088.88	3092.71	5420.0
2018-01-31 02:00:00	ES	Futures	3092.43	3098.17	3091.89	3097.08	15227.0
2018-01-31 03:00:00	ES	Futures	3097.35	3101.45	3095.99	3099.27	20331.0
2018-01-31 04:00:00	ES	Futures	3099.27	3100.09	3094.89	3097.63	14928.0
2018-01-31 05:00:00	ES	Futures	3097.63	3097.9	3092.43	3096.53	17224.0
2018-01-31 06:00:00	ES	Futures	3096.26	3099.27	3094.62	3097.63	15898.0
2018-01-31 07:00:00	ES	Futures	3097.35	3103.91	3096.81	3103.64	27959.0
2018-01-31 08:00:00	ES	Futures	3103.91	3103.91	3098.45	3099.27	36538.0
2018-01-31 09:00:00	ES	Futures	3099.27	3104.73	3095.71	3098.99	172531.0
2018-01-31 10:00:00	ES	Futures	3099.27	3102.0	3090.25	3093.25	198930.0
2018-01-31 11:00:00	ES	Futures	3092.98	3093.8	3088.88	3089.43	163397.0
2018-01-31 12:00:00	ES	Futures	3089.15	3094.07	3088.33	3092.98	79909.0
2018-01-31 13:00:00	ES	Futures	3093.25	3096.53	3092.16	3093.25	99808.0
2018-01-31 14:00:00	ES	Futures	3093.25	3098.99	3075.49	3082.32	258274.0
2018-01-31 15:00:00	ES	Futures	3082.32	3095.99	3075.49	3089.43	385404.0
2018-01-31 16:00:00	ES	Futures	3089.43	3093.8	3088.88	3089.97	145138.0
2018-01-31 18:00:00	ES	Futures	3092.71	3099.27	3092.43	3096.53	22889.0
2018-01-31 19:00:00	ES	Futures	3096.53	3098.72	3095.17	3096.26	12790.0
2018-01-31 20:00:00	ES	Futures	3096.26	3102.0	3096.26	3100.91	12244.0
2018-01-31 21:00:00	ES	Futures	3101.18	3101.73	3099.27	3099.81	5700.0
2018-01-31 22:00:00	ES	Futures	3099.54	3102.0	3099.27	3100.36	4315.0
2018-01-31 23:00:00	ES	Futures	3100.63	3101.18	3098.72	3100.91	4352.0
2018-01-31 00:00:00	NQ	Futures	8265.19	8267.56	8237.02	8241.46	3781.0
2018-01-31 01:00:00	NQ	Futures	8241.17	8253.03	8237.02	8250.07	2098.0
2018-01-31 02:00:00	NQ	Futures	8250.36	8266.08	8247.69	8264.01	2508.0
2018-01-31 03:00:00	NQ	Futures	8264.01	8272.01	8258.07	8264.9	4550.0
2018-01-31 04:00:00	NQ	Futures	8264.6	8265.49	8250.96	8257.48	4002.0
2018-01-31 05:00:00	NQ	Futures	8258.07	8259.85	8246.8	8256.29	2975.0
2018-01-31 06:00:00	NQ	Futures	8256.29	8264.6	8249.18	8259.26	3088.0
2018-01-31 07:00:00	NQ	Futures	8258.96	8275.57	8257.18	8275.28	5062.0
2018-01-31 08:00:00	NQ	Futures	8275.28	8281.5	8269.05	8276.17	10628.0
2018-01-31 09:00:00	NQ	Futures	8276.46	8293.96	8269.05	8281.5	45447.0
2018-01-31 10:00:00	NQ	Futures	8281.5	8289.22	8259.56	8266.38	55552.0
2018-01-31 11:00:00	NQ	Futures	8266.68	8270.23	8242.06	8243.24	39997.0
2018-01-31 12:00:00	NQ	Futures	8243.54	8267.27	8239.39	8262.52	22741.0
2018-01-31 13:00:00	NQ	Futures	8262.82	8275.87	8259.56	8263.41	22860.0
2018-01-31 14:00:00	NQ	Futures	8263.41	8280.02	8223.08	8237.02	64828.0
2018-01-31 15:00:00	NQ	Futures	8236.72	8270.23	8212.69	8260.74	76951.0
2018-01-31 16:00:00	NQ	Futures	8260.74	8266.08	8211.51	8219.81	26379.0
2018-01-31 18:00:00	NQ	Futures	8272.61	8285.36	8261.63	8269.64	7314.0
2018-01-31 19:00:00	NQ	Futures	8269.05	8283.58	8268.16	8277.06	3250.0
2018-01-31 20:00:00	NQ	Futures	8277.06	8289.51	8276.46	8287.44	2618.0
2018-01-31 21:00:00	NQ	Futures	8287.44	8290.11	8280.91	8282.39	2104.0
2018-01-31 22:00:00	NQ	Futures	8282.1	8289.81	8279.73	8286.55	1433.0
2018-01-31 23:00:00	NQ	Futures	8286.55	8288.33	8284.17	8288.03	1044.0
2018-01-31 00:00:00	YM	Futures	28410.0	28417.6	28339.3	28346.9	3415.0
2018-01-31 01:00:00	YM	Futures	28343.7	28370.8	28324.1	28361.1	1936.0
2018-01-31 02:00:00	YM	Futures	28360.0	28396.9	28356.7	28387.1	1895.0
2018-01-31 03:00:00	YM	Futures	28387.1	28441.5	28377.4	28411.0	4840.0

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

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