PREVIEW / futures_1hour / 2017-02-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-08.parquet
  size:    54 KB
  rows:    1,643

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-02-08 00:00:00	ES	Futures	2495.29	2496.93	2495.29	2496.38	2924.0
2017-02-08 01:00:00	ES	Futures	2496.38	2499.38	2496.11	2499.11	6119.0
2017-02-08 02:00:00	ES	Futures	2498.84	2499.93	2498.29	2498.56	6354.0
2017-02-08 03:00:00	ES	Futures	2498.29	2499.93	2494.74	2495.29	18395.0
2017-02-08 04:00:00	ES	Futures	2495.56	2499.38	2494.74	2499.38	10074.0
2017-02-08 05:00:00	ES	Futures	2499.11	2499.93	2496.93	2497.75	11313.0
2017-02-08 06:00:00	ES	Futures	2497.47	2498.29	2496.38	2497.2	7199.0
2017-02-08 07:00:00	ES	Futures	2496.93	2498.02	2493.65	2493.93	19792.0
2017-02-08 08:00:00	ES	Futures	2493.93	2494.74	2492.02	2493.65	31596.0
2017-02-08 09:00:00	ES	Futures	2493.93	2493.93	2488.74	2491.47	211627.0
2017-02-08 10:00:00	ES	Futures	2491.47	2497.2	2490.65	2496.38	252110.0
2017-02-08 11:00:00	ES	Futures	2496.38	2499.11	2494.47	2495.02	199749.0
2017-02-08 12:00:00	ES	Futures	2495.02	2497.75	2494.47	2495.56	100720.0
2017-02-08 13:00:00	ES	Futures	2495.56	2499.65	2495.56	2498.56	82306.0
2017-02-08 14:00:00	ES	Futures	2498.56	2499.65	2497.47	2498.56	57736.0
2017-02-08 15:00:00	ES	Futures	2498.56	2500.75	2496.93	2499.11	168224.0
2017-02-08 16:00:00	ES	Futures	2499.38	2499.93	2498.29	2499.11	67179.0
2017-02-08 18:00:00	ES	Futures	2499.11	2499.93	2498.56	2499.11	3189.0
2017-02-08 19:00:00	ES	Futures	2499.11	2499.11	2496.93	2497.47	4044.0
2017-02-08 20:00:00	ES	Futures	2497.75	2497.75	2496.11	2497.2	4558.0
2017-02-08 21:00:00	ES	Futures	2497.47	2498.29	2497.2	2497.47	1894.0
2017-02-08 22:00:00	ES	Futures	2497.2	2498.02	2496.93	2497.47	1394.0
2017-02-08 23:00:00	ES	Futures	2497.2	2499.38	2497.2	2499.11	2520.0
2017-02-08 00:00:00	NQ	Futures	6178.8	6183.87	6178.8	6182.38	836.0
2017-02-08 01:00:00	NQ	Futures	6182.68	6189.84	6181.78	6189.24	1792.0
2017-02-08 02:00:00	NQ	Futures	6189.24	6190.43	6185.36	6185.96	1645.0
2017-02-08 03:00:00	NQ	Futures	6185.96	6189.24	6179.1	6181.49	3046.0
2017-02-08 04:00:00	NQ	Futures	6181.49	6188.64	6179.4	6188.35	1959.0
2017-02-08 05:00:00	NQ	Futures	6188.05	6188.94	6182.68	6183.87	1419.0
2017-02-08 06:00:00	NQ	Futures	6183.87	6185.36	6180.89	6182.38	1240.0
2017-02-08 07:00:00	NQ	Futures	6182.38	6184.47	6176.71	6176.71	2353.0
2017-02-08 08:00:00	NQ	Futures	6177.01	6179.1	6173.73	6176.71	4062.0
2017-02-08 09:00:00	NQ	Futures	6176.71	6176.71	6161.5	6171.64	31215.0
2017-02-08 10:00:00	NQ	Futures	6171.64	6194.01	6169.55	6191.33	33265.0
2017-02-08 11:00:00	NQ	Futures	6191.33	6195.51	6185.66	6189.24	22304.0
2017-02-08 12:00:00	NQ	Futures	6189.24	6194.61	6184.17	6188.94	13340.0
2017-02-08 13:00:00	NQ	Futures	6188.94	6196.1	6188.64	6194.31	9913.0
2017-02-08 14:00:00	NQ	Futures	6194.31	6198.79	6192.82	6194.91	9120.0
2017-02-08 15:00:00	NQ	Futures	6195.21	6201.47	6191.03	6193.42	18846.0
2017-02-08 16:00:00	NQ	Futures	6193.42	6196.1	6191.93	6194.01	4277.0
2017-02-08 18:00:00	NQ	Futures	6192.82	6197.89	6192.52	6193.72	724.0
2017-02-08 19:00:00	NQ	Futures	6193.72	6193.72	6189.54	6191.93	1012.0
2017-02-08 20:00:00	NQ	Futures	6192.22	6193.42	6188.64	6192.52	866.0
2017-02-08 21:00:00	NQ	Futures	6192.82	6195.8	6192.22	6192.22	797.0
2017-02-08 22:00:00	NQ	Futures	6192.22	6193.72	6190.14	6191.93	417.0
2017-02-08 23:00:00	NQ	Futures	6191.93	6195.21	6191.93	6194.61	549.0
2017-02-08 00:00:00	YM	Futures	21715.9	21727.9	21715.9	21723.5	627.0
2017-02-08 01:00:00	YM	Futures	21724.6	21747.4	21722.4	21745.2	1345.0
2017-02-08 02:00:00	YM	Futures	21745.2	21750.6	21735.5	21738.7	1343.0
2017-02-08 03:00:00	YM	Futures	21739.8	21749.6	21714.8	21721.4	3664.0

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

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