PREVIEW / futures_1hour / 2017-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-07.parquet
  size:    45 KB
  rows:    1,317

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-07-07 00:00:00	ES	Futures	2634.72	2634.72	2633.62	2633.9	3365.0
2017-07-07 01:00:00	ES	Futures	2633.9	2635.26	2633.9	2634.99	3166.0
2017-07-07 02:00:00	ES	Futures	2634.99	2636.36	2634.72	2636.36	9933.0
2017-07-07 03:00:00	ES	Futures	2636.36	2636.9	2632.26	2633.9	20028.0
2017-07-07 04:00:00	ES	Futures	2633.62	2635.81	2633.08	2633.35	15423.0
2017-07-07 05:00:00	ES	Futures	2633.35	2635.26	2632.8	2633.08	8541.0
2017-07-07 06:00:00	ES	Futures	2633.08	2635.54	2633.08	2633.9	8870.0
2017-07-07 07:00:00	ES	Futures	2634.17	2634.44	2633.08	2633.62	11017.0
2017-07-07 08:00:00	ES	Futures	2633.62	2643.19	2633.35	2638.27	89692.0
2017-07-07 09:00:00	ES	Futures	2638.54	2643.46	2636.9	2642.64	171710.0
2017-07-07 10:00:00	ES	Futures	2642.37	2643.46	2637.72	2640.46	194069.0
2017-07-07 11:00:00	ES	Futures	2640.46	2648.66	2639.64	2647.56	163554.0
2017-07-07 12:00:00	ES	Futures	2647.56	2650.57	2647.29	2649.48	92369.0
2017-07-07 13:00:00	ES	Futures	2649.75	2651.39	2649.2	2650.3	68290.0
2017-07-07 14:00:00	ES	Futures	2650.57	2651.12	2648.38	2648.93	65810.0
2017-07-07 15:00:00	ES	Futures	2648.66	2651.12	2647.56	2648.93	217356.0
2017-07-07 16:00:00	ES	Futures	2648.93	2649.75	2647.84	2649.48	77390.0
2017-07-07 00:00:00	NQ	Futures	6679.45	6679.45	6672.61	6673.5	821.0
2017-07-07 01:00:00	NQ	Futures	6674.09	6679.16	6674.09	6676.77	738.0
2017-07-07 02:00:00	NQ	Futures	6676.48	6683.03	6674.69	6678.56	1193.0
2017-07-07 03:00:00	NQ	Futures	6678.56	6681.54	6659.5	6665.46	3412.0
2017-07-07 04:00:00	NQ	Futures	6666.35	6679.16	6663.97	6673.5	2211.0
2017-07-07 05:00:00	NQ	Futures	6672.9	6677.37	6664.27	6667.84	1418.0
2017-07-07 06:00:00	NQ	Futures	6667.54	6681.84	6667.54	6673.8	2060.0
2017-07-07 07:00:00	NQ	Futures	6673.8	6680.05	6669.63	6671.12	2696.0
2017-07-07 08:00:00	NQ	Futures	6670.82	6711.91	6669.63	6689.28	21123.0
2017-07-07 09:00:00	NQ	Futures	6689.58	6724.41	6684.22	6722.03	49448.0
2017-07-07 10:00:00	NQ	Futures	6721.44	6727.99	6704.17	6715.48	40187.0
2017-07-07 11:00:00	NQ	Futures	6715.18	6744.07	6712.21	6738.71	37324.0
2017-07-07 12:00:00	NQ	Futures	6738.41	6748.23	6736.62	6744.66	15613.0
2017-07-07 13:00:00	NQ	Futures	6744.96	6760.74	6743.17	6756.87	21986.0
2017-07-07 14:00:00	NQ	Futures	6756.87	6757.76	6740.79	6746.15	19524.0
2017-07-07 15:00:00	NQ	Futures	6746.15	6748.23	6735.43	6739.9	32171.0
2017-07-07 16:00:00	NQ	Futures	6739.6	6742.87	6732.75	6737.81	8477.0
2017-07-07 00:00:00	YM	Futures	23167.2	23167.2	23157.5	23159.6	635.0
2017-07-07 01:00:00	YM	Futures	23160.7	23170.5	23160.7	23166.2	812.0
2017-07-07 02:00:00	YM	Futures	23166.2	23178.1	23166.2	23176.0	1321.0
2017-07-07 03:00:00	YM	Futures	23178.1	23180.3	23150.9	23164.0	2561.0
2017-07-07 04:00:00	YM	Futures	23162.9	23168.3	23147.7	23148.7	2392.0
2017-07-07 05:00:00	YM	Futures	23148.7	23167.2	23147.7	23150.9	1604.0
2017-07-07 06:00:00	YM	Futures	23152.0	23166.2	23150.9	23157.5	1044.0
2017-07-07 07:00:00	YM	Futures	23156.4	23159.6	23145.5	23152.0	1608.0
2017-07-07 08:00:00	YM	Futures	23152.0	23232.6	23148.7	23205.3	10467.0
2017-07-07 09:00:00	YM	Futures	23206.4	23238.0	23189.0	23224.9	15780.0
2017-07-07 10:00:00	YM	Futures	23224.9	23230.4	23189.0	23210.8	14344.0
2017-07-07 11:00:00	YM	Futures	23210.8	23254.3	23202.1	23247.8	14191.0
2017-07-07 12:00:00	YM	Futures	23247.8	23268.5	23242.4	23252.1	9689.0
2017-07-07 13:00:00	YM	Futures	23252.1	23265.2	23246.7	23263.0	5505.0
2017-07-07 14:00:00	YM	Futures	23263.0	23266.3	23246.7	23248.9	5099.0
2017-07-07 15:00:00	YM	Futures	23247.8	23264.1	23236.9	23253.2	10413.0

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

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