PREVIEW / futures_1hour / 2017-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-27.parquet
  size:    51 KB
  rows:    1,622

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
2017-11-27 00:00:00	ES	Futures	2842.55	2843.64	2842.27	2843.64	2168.0
2017-11-27 01:00:00	ES	Futures	2843.64	2843.92	2842.55	2843.92	2987.0
2017-11-27 02:00:00	ES	Futures	2843.92	2845.01	2843.37	2844.74	8123.0
2017-11-27 03:00:00	ES	Futures	2844.74	2847.75	2843.37	2847.47	31582.0
2017-11-27 04:00:00	ES	Futures	2847.47	2849.11	2846.92	2847.47	21152.0
2017-11-27 05:00:00	ES	Futures	2847.75	2848.84	2846.92	2848.29	13630.0
2017-11-27 06:00:00	ES	Futures	2848.57	2849.93	2848.29	2848.57	11886.0
2017-11-27 07:00:00	ES	Futures	2848.84	2848.84	2844.74	2845.56	22897.0
2017-11-27 08:00:00	ES	Futures	2845.28	2847.47	2844.74	2846.1	16050.0
2017-11-27 09:00:00	ES	Futures	2845.83	2851.03	2845.28	2849.11	123046.0
2017-11-27 10:00:00	ES	Futures	2849.11	2850.21	2847.75	2849.39	92590.0
2017-11-27 11:00:00	ES	Futures	2849.39	2849.66	2842.55	2846.1	130297.0
2017-11-27 12:00:00	ES	Futures	2846.1	2846.38	2844.46	2845.83	55522.0
2017-11-27 13:00:00	ES	Futures	2845.83	2847.47	2845.83	2847.47	62468.0
2017-11-27 14:00:00	ES	Futures	2847.2	2847.47	2845.83	2847.2	63677.0
2017-11-27 15:00:00	ES	Futures	2846.92	2847.2	2845.28	2845.56	122561.0
2017-11-27 16:00:00	ES	Futures	2845.28	2848.29	2845.28	2847.75	83264.0
2017-11-27 18:00:00	ES	Futures	2847.47	2847.47	2843.92	2844.74	10666.0
2017-11-27 19:00:00	ES	Futures	2844.74	2845.28	2842.27	2842.55	10999.0
2017-11-27 20:00:00	ES	Futures	2842.55	2845.28	2842.27	2845.01	8681.0
2017-11-27 21:00:00	ES	Futures	2845.28	2845.28	2843.64	2844.46	4148.0
2017-11-27 22:00:00	ES	Futures	2844.19	2844.19	2842.27	2842.82	5485.0
2017-11-27 23:00:00	ES	Futures	2842.82	2844.19	2842.55	2843.64	3484.0
2017-11-27 00:00:00	NQ	Futures	7618.92	7622.78	7618.62	7622.49	919.0
2017-11-27 01:00:00	NQ	Futures	7622.78	7623.97	7618.92	7622.78	1257.0
2017-11-27 02:00:00	NQ	Futures	7622.49	7627.54	7621.3	7627.54	1685.0
2017-11-27 03:00:00	NQ	Futures	7627.54	7634.38	7622.49	7634.38	3590.0
2017-11-27 04:00:00	NQ	Futures	7634.68	7638.84	7632.6	7635.27	3066.0
2017-11-27 05:00:00	NQ	Futures	7635.27	7638.84	7634.38	7637.36	1416.0
2017-11-27 06:00:00	NQ	Futures	7637.65	7642.41	7636.46	7638.55	2134.0
2017-11-27 07:00:00	NQ	Futures	7638.55	7639.14	7623.68	7623.97	4260.0
2017-11-27 08:00:00	NQ	Futures	7623.97	7629.03	7619.81	7624.57	5662.0
2017-11-27 09:00:00	NQ	Futures	7624.27	7637.36	7618.32	7631.11	35939.0
2017-11-27 10:00:00	NQ	Futures	7631.11	7643.01	7629.92	7636.46	27605.0
2017-11-27 11:00:00	NQ	Futures	7636.46	7637.95	7607.62	7622.19	43767.0
2017-11-27 12:00:00	NQ	Futures	7622.19	7625.76	7616.24	7621.3	15861.0
2017-11-27 13:00:00	NQ	Futures	7621.59	7630.81	7621.59	7629.33	10302.0
2017-11-27 14:00:00	NQ	Futures	7629.33	7630.22	7620.4	7627.24	11672.0
2017-11-27 15:00:00	NQ	Futures	7627.24	7628.43	7621.59	7624.57	15857.0
2017-11-27 16:00:00	NQ	Futures	7624.27	7632.0	7624.27	7631.11	5437.0
2017-11-27 18:00:00	NQ	Futures	7629.62	7629.92	7619.51	7622.19	2106.0
2017-11-27 19:00:00	NQ	Futures	7622.19	7624.57	7615.94	7616.84	2585.0
2017-11-27 20:00:00	NQ	Futures	7617.13	7623.68	7616.24	7623.38	1888.0
2017-11-27 21:00:00	NQ	Futures	7623.08	7624.87	7619.51	7622.19	1193.0
2017-11-27 22:00:00	NQ	Futures	7621.59	7621.59	7611.78	7612.37	2252.0
2017-11-27 23:00:00	NQ	Futures	7612.37	7618.32	7611.78	7617.13	1057.0
2017-11-27 00:00:00	YM	Futures	25543.2	25551.9	25543.2	25549.7	581.0
2017-11-27 01:00:00	YM	Futures	25550.8	25563.8	25542.1	25561.7	1397.0
2017-11-27 02:00:00	YM	Futures	25561.7	25571.5	25557.3	25570.4	2046.0
2017-11-27 03:00:00	YM	Futures	25570.4	25595.4	25557.3	25595.4	2764.0

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

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