PREVIEW / futures_1hour / 2018-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-09.parquet
  size:    54 KB
  rows:    1,702

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-05-09 00:00:00	ES	Futures	2913.84	2916.3	2913.57	2915.2	2789.0
2018-05-09 01:00:00	ES	Futures	2914.93	2916.84	2914.39	2916.57	3154.0
2018-05-09 02:00:00	ES	Futures	2916.57	2917.39	2913.84	2914.66	6455.0
2018-05-09 03:00:00	ES	Futures	2914.93	2925.57	2914.93	2924.76	20551.0
2018-05-09 04:00:00	ES	Futures	2924.76	2930.21	2922.3	2929.67	18210.0
2018-05-09 05:00:00	ES	Futures	2929.67	2930.49	2926.67	2929.94	13861.0
2018-05-09 06:00:00	ES	Futures	2929.94	2930.21	2925.3	2927.48	11247.0
2018-05-09 07:00:00	ES	Futures	2927.48	2928.85	2924.76	2925.3	15307.0
2018-05-09 08:00:00	ES	Futures	2925.3	2926.94	2923.66	2923.66	20136.0
2018-05-09 09:00:00	ES	Futures	2923.66	2927.21	2919.57	2922.57	147953.0
2018-05-09 10:00:00	ES	Futures	2922.85	2926.94	2916.84	2917.93	168209.0
2018-05-09 11:00:00	ES	Futures	2917.93	2924.48	2916.84	2923.94	103367.0
2018-05-09 12:00:00	ES	Futures	2923.94	2940.31	2923.66	2938.4	166734.0
2018-05-09 13:00:00	ES	Futures	2938.4	2945.22	2937.04	2944.95	118777.0
2018-05-09 14:00:00	ES	Futures	2944.95	2947.41	2939.77	2944.4	115413.0
2018-05-09 15:00:00	ES	Futures	2944.68	2946.32	2937.86	2943.31	177091.0
2018-05-09 16:00:00	ES	Futures	2943.04	2944.68	2942.22	2942.77	79834.0
2018-05-09 18:00:00	ES	Futures	2943.04	2945.22	2942.22	2943.31	3377.0
2018-05-09 19:00:00	ES	Futures	2943.31	2943.31	2939.49	2942.77	3323.0
2018-05-09 20:00:00	ES	Futures	2942.77	2944.68	2941.13	2943.04	5156.0
2018-05-09 21:00:00	ES	Futures	2943.04	2947.41	2942.22	2945.5	10679.0
2018-05-09 22:00:00	ES	Futures	2945.5	2950.14	2944.95	2947.68	6794.0
2018-05-09 23:00:00	ES	Futures	2947.41	2949.86	2947.41	2949.04	2104.0
2018-05-09 00:00:00	NQ	Futures	8062.71	8067.14	8062.71	8063.59	928.0
2018-05-09 01:00:00	NQ	Futures	8063.59	8067.73	8060.93	8066.85	910.0
2018-05-09 02:00:00	NQ	Futures	8066.85	8070.69	8056.5	8058.87	2149.0
2018-05-09 03:00:00	NQ	Futures	8058.87	8085.46	8058.57	8081.33	4575.0
2018-05-09 04:00:00	NQ	Futures	8081.62	8097.29	8072.46	8096.1	5101.0
2018-05-09 05:00:00	NQ	Futures	8095.81	8097.58	8086.35	8095.81	3283.0
2018-05-09 06:00:00	NQ	Futures	8095.81	8095.81	8080.44	8086.05	2448.0
2018-05-09 07:00:00	NQ	Futures	8085.46	8093.44	8081.33	8083.1	3821.0
2018-05-09 08:00:00	NQ	Futures	8082.8	8091.37	8077.78	8079.26	5913.0
2018-05-09 09:00:00	NQ	Futures	8078.96	8092.26	8061.23	8064.78	50943.0
2018-05-09 10:00:00	NQ	Futures	8065.37	8086.65	8049.41	8054.43	48552.0
2018-05-09 11:00:00	NQ	Futures	8054.73	8082.21	8048.23	8081.33	31836.0
2018-05-09 12:00:00	NQ	Futures	8081.62	8126.25	8079.85	8121.22	40839.0
2018-05-09 13:00:00	NQ	Futures	8121.22	8150.78	8116.2	8147.53	30361.0
2018-05-09 14:00:00	NQ	Futures	8147.53	8157.87	8136.89	8151.66	30480.0
2018-05-09 15:00:00	NQ	Futures	8151.66	8157.28	8138.66	8152.25	31472.0
2018-05-09 16:00:00	NQ	Futures	8151.96	8158.16	8149.59	8153.14	9565.0
2018-05-09 18:00:00	NQ	Futures	8151.96	8161.42	8150.19	8153.73	1352.0
2018-05-09 19:00:00	NQ	Futures	8153.14	8153.14	8143.39	8151.37	1163.0
2018-05-09 20:00:00	NQ	Futures	8151.66	8157.57	8147.53	8151.66	1703.0
2018-05-09 21:00:00	NQ	Futures	8152.25	8169.69	8149.89	8163.78	9231.0
2018-05-09 22:00:00	NQ	Futures	8163.78	8179.74	8163.19	8172.65	2210.0
2018-05-09 23:00:00	NQ	Futures	8173.24	8179.44	8173.24	8177.37	1056.0
2018-05-09 00:00:00	YM	Futures	26381.7	26408.8	26379.5	26396.9	668.0
2018-05-09 01:00:00	YM	Futures	26396.9	26412.1	26391.5	26406.7	742.0
2018-05-09 02:00:00	YM	Futures	26407.7	26414.3	26390.4	26404.5	1395.0
2018-05-09 03:00:00	YM	Futures	26404.5	26515.3	26400.1	26500.1	5524.0

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

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