PREVIEW / futures_1hour / 2018-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-08.parquet
  size:    55 KB
  rows:    1,706

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-08 00:00:00	ES	Futures	2913.57	2914.93	2913.29	2913.84	1728.0
2018-05-08 01:00:00	ES	Futures	2914.11	2916.3	2913.57	2915.2	2923.0
2018-05-08 02:00:00	ES	Futures	2915.2	2916.3	2914.39	2916.3	5469.0
2018-05-08 03:00:00	ES	Futures	2916.3	2917.11	2912.47	2913.57	10252.0
2018-05-08 04:00:00	ES	Futures	2913.57	2913.57	2906.2	2908.38	16596.0
2018-05-08 05:00:00	ES	Futures	2908.65	2909.2	2903.47	2906.74	14285.0
2018-05-08 06:00:00	ES	Futures	2906.74	2909.47	2902.92	2904.29	11374.0
2018-05-08 07:00:00	ES	Futures	2904.01	2907.56	2902.1	2905.92	17507.0
2018-05-08 08:00:00	ES	Futures	2905.92	2911.93	2904.83	2911.38	22517.0
2018-05-08 09:00:00	ES	Futures	2911.38	2912.75	2903.2	2906.2	145251.0
2018-05-08 10:00:00	ES	Futures	2906.2	2914.11	2904.83	2909.75	145303.0
2018-05-08 11:00:00	ES	Futures	2909.47	2919.3	2905.38	2909.47	195542.0
2018-05-08 12:00:00	ES	Futures	2909.2	2910.84	2900.74	2903.74	102077.0
2018-05-08 13:00:00	ES	Futures	2903.47	2910.29	2902.65	2904.83	73318.0
2018-05-08 14:00:00	ES	Futures	2905.11	2914.11	2895.28	2902.1	220833.0
2018-05-08 15:00:00	ES	Futures	2902.1	2914.93	2899.38	2914.93	182425.0
2018-05-08 16:00:00	ES	Futures	2914.93	2915.75	2912.47	2914.93	47657.0
2018-05-08 18:00:00	ES	Futures	2914.39	2917.93	2914.11	2916.3	4251.0
2018-05-08 19:00:00	ES	Futures	2916.57	2916.84	2911.66	2912.47	3988.0
2018-05-08 20:00:00	ES	Futures	2912.2	2913.84	2910.84	2913.29	5424.0
2018-05-08 21:00:00	ES	Futures	2913.02	2914.39	2911.11	2913.02	6558.0
2018-05-08 22:00:00	ES	Futures	2913.02	2914.39	2911.66	2914.11	3620.0
2018-05-08 23:00:00	ES	Futures	2914.11	2914.93	2913.02	2913.84	4461.0
2018-05-08 00:00:00	NQ	Futures	8070.39	8075.12	8070.39	8072.46	791.0
2018-05-08 01:00:00	NQ	Futures	8072.76	8082.8	8070.69	8077.48	2053.0
2018-05-08 02:00:00	NQ	Futures	8077.48	8080.14	8070.98	8075.71	1891.0
2018-05-08 03:00:00	NQ	Futures	8075.71	8078.67	8065.37	8068.32	2736.0
2018-05-08 04:00:00	NQ	Futures	8068.32	8068.91	8046.45	8051.77	4973.0
2018-05-08 05:00:00	NQ	Futures	8052.36	8054.73	8039.07	8049.11	4403.0
2018-05-08 06:00:00	NQ	Futures	8049.11	8058.27	8033.15	8037.59	4187.0
2018-05-08 07:00:00	NQ	Futures	8037.59	8044.38	8027.84	8040.84	5852.0
2018-05-08 08:00:00	NQ	Futures	8040.84	8061.82	8037.29	8059.75	6535.0
2018-05-08 09:00:00	NQ	Futures	8059.46	8065.66	8017.79	8032.27	50910.0
2018-05-08 10:00:00	NQ	Futures	8032.27	8060.64	8029.31	8040.25	48666.0
2018-05-08 11:00:00	NQ	Futures	8040.84	8081.33	8031.09	8045.86	54042.0
2018-05-08 12:00:00	NQ	Futures	8045.27	8050.0	8015.42	8026.36	32753.0
2018-05-08 13:00:00	NQ	Futures	8025.77	8053.84	8022.81	8033.75	26013.0
2018-05-08 14:00:00	NQ	Futures	8033.45	8065.37	8004.19	8025.47	61861.0
2018-05-08 15:00:00	NQ	Futures	8025.18	8060.34	8016.9	8060.34	43663.0
2018-05-08 16:00:00	NQ	Futures	8060.34	8066.25	8053.55	8064.48	6362.0
2018-05-08 18:00:00	NQ	Futures	8064.48	8071.87	8062.71	8066.25	1508.0
2018-05-08 19:00:00	NQ	Futures	8065.96	8067.44	8053.25	8057.09	2058.0
2018-05-08 20:00:00	NQ	Futures	8056.21	8062.71	8053.55	8061.23	3298.0
2018-05-08 21:00:00	NQ	Futures	8061.23	8063.59	8053.84	8058.57	3443.0
2018-05-08 22:00:00	NQ	Futures	8059.16	8060.64	8055.62	8060.34	1145.0
2018-05-08 23:00:00	NQ	Futures	8060.05	8065.66	8058.57	8062.71	1171.0
2018-05-08 00:00:00	YM	Futures	26392.5	26404.5	26392.5	26400.1	707.0
2018-05-08 01:00:00	YM	Futures	26400.1	26421.9	26395.8	26413.2	1244.0
2018-05-08 02:00:00	YM	Futures	26413.2	26425.1	26405.6	26422.9	1348.0
2018-05-08 03:00:00	YM	Futures	26422.9	26428.4	26389.3	26395.8	3226.0

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

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