PREVIEW / futures_1hour / 2017-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-26.parquet
  size:    51 KB
  rows:    1,598

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-06-26 00:00:00	ES	Futures	2663.69	2664.24	2662.87	2663.14	1256.0
2017-06-26 01:00:00	ES	Futures	2663.14	2664.51	2662.6	2663.96	2656.0
2017-06-26 02:00:00	ES	Futures	2663.69	2665.6	2663.69	2665.33	8618.0
2017-06-26 03:00:00	ES	Futures	2665.06	2669.16	2665.06	2667.52	24740.0
2017-06-26 04:00:00	ES	Futures	2667.52	2669.16	2666.7	2668.34	13470.0
2017-06-26 05:00:00	ES	Futures	2668.34	2668.88	2667.24	2668.06	8630.0
2017-06-26 06:00:00	ES	Futures	2668.06	2668.88	2667.79	2668.61	6202.0
2017-06-26 07:00:00	ES	Futures	2668.34	2669.7	2668.34	2669.43	11675.0
2017-06-26 08:00:00	ES	Futures	2669.43	2670.52	2668.88	2669.43	19746.0
2017-06-26 09:00:00	ES	Futures	2669.7	2675.99	2668.88	2675.44	180022.0
2017-06-26 10:00:00	ES	Futures	2675.72	2675.72	2663.14	2665.6	299980.0
2017-06-26 11:00:00	ES	Futures	2665.88	2668.34	2661.23	2667.79	215135.0
2017-06-26 12:00:00	ES	Futures	2668.06	2669.43	2665.88	2668.34	68565.0
2017-06-26 13:00:00	ES	Futures	2668.61	2668.88	2665.88	2666.7	53512.0
2017-06-26 14:00:00	ES	Futures	2666.97	2667.79	2664.78	2667.24	73372.0
2017-06-26 15:00:00	ES	Futures	2667.52	2668.34	2662.6	2663.69	183462.0
2017-06-26 16:00:00	ES	Futures	2663.69	2663.96	2662.32	2663.14	57180.0
2017-06-26 18:00:00	ES	Futures	2663.14	2664.78	2661.5	2663.69	4156.0
2017-06-26 19:00:00	ES	Futures	2663.69	2664.78	2663.42	2663.69	1780.0
2017-06-26 20:00:00	ES	Futures	2663.96	2664.51	2662.32	2663.14	4469.0
2017-06-26 21:00:00	ES	Futures	2662.87	2664.24	2662.6	2663.69	2953.0
2017-06-26 22:00:00	ES	Futures	2663.69	2664.78	2663.42	2663.69	2465.0
2017-06-26 23:00:00	ES	Futures	2663.69	2664.24	2662.87	2664.24	2321.0
2017-06-26 00:00:00	NQ	Futures	6928.08	6929.56	6926.88	6928.08	353.0
2017-06-26 01:00:00	NQ	Futures	6928.37	6933.73	6926.88	6932.24	819.0
2017-06-26 02:00:00	NQ	Futures	6932.54	6937.31	6932.24	6935.52	1440.0
2017-06-26 03:00:00	NQ	Futures	6935.22	6948.32	6934.92	6939.39	3662.0
2017-06-26 04:00:00	NQ	Futures	6939.39	6945.64	6935.22	6941.47	1811.0
2017-06-26 05:00:00	NQ	Futures	6941.47	6946.54	6938.2	6942.07	1420.0
2017-06-26 06:00:00	NQ	Futures	6942.07	6946.83	6941.18	6946.54	2982.0
2017-06-26 07:00:00	NQ	Futures	6946.54	6957.85	6944.75	6954.87	4726.0
2017-06-26 08:00:00	NQ	Futures	6954.87	6959.94	6952.19	6954.58	4005.0
2017-06-26 09:00:00	NQ	Futures	6954.28	6969.76	6951.3	6958.15	35352.0
2017-06-26 10:00:00	NQ	Futures	6958.45	6959.34	6892.64	6902.17	76870.0
2017-06-26 11:00:00	NQ	Futures	6902.47	6904.85	6869.72	6898.3	57368.0
2017-06-26 12:00:00	NQ	Futures	6898.3	6915.27	6892.94	6910.81	23058.0
2017-06-26 13:00:00	NQ	Futures	6911.1	6911.4	6897.11	6904.55	16318.0
2017-06-26 14:00:00	NQ	Futures	6904.55	6905.45	6886.99	6895.03	25437.0
2017-06-26 15:00:00	NQ	Futures	6895.03	6900.39	6880.14	6884.31	39005.0
2017-06-26 16:00:00	NQ	Futures	6884.31	6886.09	6876.86	6884.01	5509.0
2017-06-26 18:00:00	NQ	Futures	6884.9	6885.5	6876.86	6883.12	870.0
2017-06-26 19:00:00	NQ	Futures	6883.12	6887.28	6882.82	6884.01	373.0
2017-06-26 20:00:00	NQ	Futures	6884.6	6886.09	6878.65	6879.24	933.0
2017-06-26 21:00:00	NQ	Futures	6879.84	6887.58	6878.05	6885.2	1025.0
2017-06-26 22:00:00	NQ	Futures	6884.9	6888.77	6884.31	6886.69	521.0
2017-06-26 23:00:00	NQ	Futures	6886.69	6887.88	6884.31	6887.88	516.0
2017-06-26 00:00:00	YM	Futures	23253.2	23256.5	23246.7	23246.7	328.0
2017-06-26 01:00:00	YM	Futures	23246.7	23253.2	23244.5	23250.0	405.0
2017-06-26 02:00:00	YM	Futures	23251.1	23266.3	23251.1	23264.1	1567.0
2017-06-26 03:00:00	YM	Futures	23264.1	23300.0	23264.1	23291.3	3993.0

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

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