PREVIEW / futures_1hour / 2017-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-16.parquet
  size:    53 KB
  rows:    1,657

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-16 00:00:00	ES	Futures	2812.18	2813.82	2811.64	2813.0	9179.0
2017-11-16 01:00:00	ES	Futures	2813.28	2815.19	2812.73	2814.37	9312.0
2017-11-16 02:00:00	ES	Futures	2814.64	2817.11	2813.82	2814.64	18652.0
2017-11-16 03:00:00	ES	Futures	2814.37	2815.74	2812.46	2814.64	31027.0
2017-11-16 04:00:00	ES	Futures	2814.92	2817.38	2814.37	2816.56	23275.0
2017-11-16 05:00:00	ES	Futures	2816.56	2818.47	2815.74	2816.29	20889.0
2017-11-16 06:00:00	ES	Futures	2816.29	2816.83	2814.92	2815.19	11418.0
2017-11-16 07:00:00	ES	Futures	2815.47	2817.38	2814.92	2816.29	20505.0
2017-11-16 08:00:00	ES	Futures	2816.01	2817.65	2814.64	2816.01	32416.0
2017-11-16 09:00:00	ES	Futures	2815.74	2820.66	2815.74	2817.93	212776.0
2017-11-16 10:00:00	ES	Futures	2817.93	2827.23	2817.93	2825.59	239210.0
2017-11-16 11:00:00	ES	Futures	2825.86	2827.78	2824.49	2827.5	122267.0
2017-11-16 12:00:00	ES	Futures	2827.5	2831.33	2827.23	2829.96	118815.0
2017-11-16 13:00:00	ES	Futures	2830.24	2831.88	2829.14	2830.78	89255.0
2017-11-16 14:00:00	ES	Futures	2830.78	2833.52	2829.96	2830.51	111663.0
2017-11-16 15:00:00	ES	Futures	2830.51	2830.78	2827.5	2828.32	272962.0
2017-11-16 16:00:00	ES	Futures	2828.32	2829.14	2826.68	2828.6	103420.0
2017-11-16 18:00:00	ES	Futures	2827.78	2829.69	2826.68	2828.87	10144.0
2017-11-16 19:00:00	ES	Futures	2828.87	2829.42	2826.13	2829.42	10463.0
2017-11-16 20:00:00	ES	Futures	2829.14	2829.42	2826.68	2827.23	7818.0
2017-11-16 21:00:00	ES	Futures	2827.23	2827.23	2823.67	2825.04	16983.0
2017-11-16 22:00:00	ES	Futures	2825.31	2826.95	2825.04	2825.04	6522.0
2017-11-16 23:00:00	ES	Futures	2824.77	2826.68	2824.49	2826.41	5866.0
2017-11-16 00:00:00	NQ	Futures	7475.86	7481.81	7475.26	7478.24	1971.0
2017-11-16 01:00:00	NQ	Futures	7478.24	7483.0	7476.16	7480.32	2007.0
2017-11-16 02:00:00	NQ	Futures	7480.02	7486.57	7479.13	7482.4	3700.0
2017-11-16 03:00:00	NQ	Futures	7482.4	7485.38	7472.59	7478.83	4451.0
2017-11-16 04:00:00	NQ	Futures	7479.13	7486.57	7476.16	7484.78	2809.0
2017-11-16 05:00:00	NQ	Futures	7484.19	7493.11	7483.3	7486.27	3325.0
2017-11-16 06:00:00	NQ	Futures	7485.67	7487.76	7480.92	7483.3	2672.0
2017-11-16 07:00:00	NQ	Futures	7483.3	7491.92	7482.4	7490.14	3741.0
2017-11-16 08:00:00	NQ	Futures	7490.43	7493.11	7481.81	7488.95	7628.0
2017-11-16 09:00:00	NQ	Futures	7488.65	7510.06	7486.86	7507.98	49293.0
2017-11-16 10:00:00	NQ	Futures	7507.68	7535.94	7507.39	7532.96	56728.0
2017-11-16 11:00:00	NQ	Futures	7533.26	7544.27	7533.26	7541.59	36418.0
2017-11-16 12:00:00	NQ	Futures	7541.29	7557.65	7540.99	7554.68	32248.0
2017-11-16 13:00:00	NQ	Futures	7554.68	7559.73	7550.81	7556.76	24535.0
2017-11-16 14:00:00	NQ	Futures	7556.76	7564.49	7554.68	7555.27	28855.0
2017-11-16 15:00:00	NQ	Futures	7555.57	7558.84	7546.64	7547.54	45462.0
2017-11-16 16:00:00	NQ	Futures	7547.24	7550.51	7543.08	7548.43	11705.0
2017-11-16 18:00:00	NQ	Futures	7545.75	7551.7	7544.56	7551.7	1778.0
2017-11-16 19:00:00	NQ	Futures	7551.4	7555.57	7546.05	7554.38	2579.0
2017-11-16 20:00:00	NQ	Futures	7554.08	7556.46	7548.13	7549.62	1937.0
2017-11-16 21:00:00	NQ	Futures	7549.92	7549.92	7537.42	7544.86	4209.0
2017-11-16 22:00:00	NQ	Futures	7544.86	7550.21	7544.27	7544.27	1800.0
2017-11-16 23:00:00	NQ	Futures	7543.97	7549.62	7543.08	7548.73	1219.0
2017-11-16 00:00:00	YM	Futures	25345.2	25356.1	25343.0	25349.6	1682.0
2017-11-16 01:00:00	YM	Futures	25349.6	25370.2	25347.4	25365.9	1802.0
2017-11-16 02:00:00	YM	Futures	25363.7	25383.3	25349.6	25353.9	3445.0
2017-11-16 03:00:00	YM	Futures	25353.9	25363.7	25338.7	25355.0	3058.0

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

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