PREVIEW / futures_1hour / 2017-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-18.parquet
  size:    54 KB
  rows:    1,632

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-04-18 00:00:00	ES	Futures	2560.44	2561.81	2560.44	2561.81	2908.0
2017-04-18 01:00:00	ES	Futures	2561.81	2562.08	2561.26	2561.53	3026.0
2017-04-18 02:00:00	ES	Futures	2561.81	2562.63	2561.26	2561.53	10471.0
2017-04-18 03:00:00	ES	Futures	2561.81	2562.35	2556.89	2557.98	29347.0
2017-04-18 04:00:00	ES	Futures	2557.71	2558.8	2555.8	2557.16	14032.0
2017-04-18 05:00:00	ES	Futures	2556.89	2557.44	2550.61	2551.7	32781.0
2017-04-18 06:00:00	ES	Futures	2551.7	2555.25	2551.16	2554.98	22852.0
2017-04-18 07:00:00	ES	Futures	2554.71	2558.53	2554.43	2556.35	28497.0
2017-04-18 08:00:00	ES	Futures	2556.07	2556.89	2553.61	2554.98	22673.0
2017-04-18 09:00:00	ES	Futures	2554.98	2561.26	2551.16	2560.99	183877.0
2017-04-18 10:00:00	ES	Futures	2561.26	2561.53	2553.07	2555.8	214792.0
2017-04-18 11:00:00	ES	Futures	2555.8	2557.71	2548.42	2548.42	193520.0
2017-04-18 12:00:00	ES	Futures	2548.7	2551.43	2545.97	2550.06	134340.0
2017-04-18 13:00:00	ES	Futures	2550.06	2554.71	2548.15	2553.89	92259.0
2017-04-18 14:00:00	ES	Futures	2553.89	2557.98	2553.34	2554.71	126795.0
2017-04-18 15:00:00	ES	Futures	2554.98	2557.98	2552.52	2554.71	192186.0
2017-04-18 16:00:00	ES	Futures	2554.43	2555.25	2553.07	2554.71	83896.0
2017-04-18 18:00:00	ES	Futures	2554.16	2554.71	2552.52	2553.61	4517.0
2017-04-18 19:00:00	ES	Futures	2553.89	2556.07	2553.89	2555.25	2862.0
2017-04-18 20:00:00	ES	Futures	2554.98	2557.71	2554.98	2556.89	7841.0
2017-04-18 21:00:00	ES	Futures	2556.62	2557.44	2555.25	2556.35	5668.0
2017-04-18 22:00:00	ES	Futures	2556.07	2556.62	2555.25	2555.8	3285.0
2017-04-18 23:00:00	ES	Futures	2555.8	2556.89	2555.53	2556.35	2616.0
2017-04-18 00:00:00	NQ	Futures	6437.14	6440.13	6437.14	6439.83	738.0
2017-04-18 01:00:00	NQ	Futures	6440.13	6441.92	6438.34	6439.53	1019.0
2017-04-18 02:00:00	NQ	Futures	6439.83	6442.21	6438.93	6439.53	1448.0
2017-04-18 03:00:00	NQ	Futures	6439.23	6441.32	6428.5	6430.29	3813.0
2017-04-18 04:00:00	NQ	Futures	6429.99	6432.08	6423.43	6427.31	2545.0
2017-04-18 05:00:00	NQ	Futures	6427.31	6427.9	6410.61	6414.78	4502.0
2017-04-18 06:00:00	NQ	Futures	6414.78	6419.55	6412.4	6418.36	4420.0
2017-04-18 07:00:00	NQ	Futures	6418.36	6425.82	6416.28	6423.13	5294.0
2017-04-18 08:00:00	NQ	Futures	6423.73	6424.62	6415.98	6419.85	3152.0
2017-04-18 09:00:00	NQ	Futures	6419.85	6445.19	6412.7	6444.9	38958.0
2017-04-18 10:00:00	NQ	Futures	6445.19	6446.09	6421.05	6427.6	38699.0
2017-04-18 11:00:00	NQ	Futures	6427.6	6435.95	6416.57	6416.87	32823.0
2017-04-18 12:00:00	NQ	Futures	6416.57	6420.75	6412.1	6417.17	23182.0
2017-04-18 13:00:00	NQ	Futures	6416.87	6424.92	6411.21	6423.43	19551.0
2017-04-18 14:00:00	NQ	Futures	6423.43	6432.67	6421.34	6426.11	22103.0
2017-04-18 15:00:00	NQ	Futures	6426.41	6435.65	6420.15	6427.9	29274.0
2017-04-18 16:00:00	NQ	Futures	6427.6	6430.59	6425.52	6429.99	6174.0
2017-04-18 18:00:00	NQ	Futures	6427.6	6431.48	6426.41	6429.99	724.0
2017-04-18 19:00:00	NQ	Futures	6429.99	6436.55	6429.99	6433.87	665.0
2017-04-18 20:00:00	NQ	Futures	6433.57	6439.53	6433.57	6437.14	1698.0
2017-04-18 21:00:00	NQ	Futures	6437.14	6438.64	6432.08	6434.76	1070.0
2017-04-18 22:00:00	NQ	Futures	6434.46	6436.25	6431.78	6433.27	771.0
2017-04-18 23:00:00	NQ	Futures	6433.27	6435.36	6432.37	6434.16	782.0
2017-04-18 00:00:00	YM	Futures	22343.3	22355.3	22343.3	22355.3	1048.0
2017-04-18 01:00:00	YM	Futures	22355.3	22362.9	22352.0	22357.5	934.0
2017-04-18 02:00:00	YM	Futures	22357.5	22369.4	22354.2	22362.9	2332.0
2017-04-18 03:00:00	YM	Futures	22362.9	22365.1	22314.0	22321.6	5121.0

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

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