PREVIEW / futures_1hour / 2018-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-28.parquet
  size:    40 KB
  rows:    1,172

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
2018-05-28 00:00:00	ES	Futures	2978.79	2980.16	2978.52	2979.06	1122.0
2018-05-28 01:00:00	ES	Futures	2979.34	2981.25	2977.7	2981.25	2939.0
2018-05-28 02:00:00	ES	Futures	2980.97	2982.07	2978.52	2980.7	5306.0
2018-05-28 03:00:00	ES	Futures	2980.43	2981.79	2977.97	2978.52	5735.0
2018-05-28 04:00:00	ES	Futures	2978.52	2979.34	2977.7	2977.7	3475.0
2018-05-28 05:00:00	ES	Futures	2977.7	2978.25	2973.88	2973.88	4733.0
2018-05-28 06:00:00	ES	Futures	2973.88	2974.15	2969.79	2973.61	7952.0
2018-05-28 07:00:00	ES	Futures	2973.61	2974.97	2971.42	2973.06	4536.0
2018-05-28 08:00:00	ES	Futures	2973.06	2974.15	2967.33	2968.69	8592.0
2018-05-28 09:00:00	ES	Futures	2968.69	2970.6	2968.15	2970.06	6956.0
2018-05-28 10:00:00	ES	Futures	2969.79	2973.06	2969.24	2972.51	7628.0
2018-05-28 11:00:00	ES	Futures	2972.24	2974.42	2967.88	2968.97	10449.0
2018-05-28 12:00:00	ES	Futures	2968.97	2973.33	2968.69	2972.79	4498.0
2018-05-28 18:00:00	ES	Futures	2970.6	2973.88	2970.33	2972.51	7117.0
2018-05-28 19:00:00	ES	Futures	2972.51	2973.06	2970.6	2971.7	2848.0
2018-05-28 20:00:00	ES	Futures	2971.7	2972.51	2970.06	2970.6	3724.0
2018-05-28 21:00:00	ES	Futures	2970.6	2970.6	2966.51	2968.69	7835.0
2018-05-28 22:00:00	ES	Futures	2968.97	2969.24	2967.33	2968.69	3142.0
2018-05-28 23:00:00	ES	Futures	2968.69	2968.97	2967.06	2968.69	3110.0
2018-05-28 00:00:00	NQ	Futures	8269.58	8273.72	8269.58	8271.35	332.0
2018-05-28 01:00:00	NQ	Futures	8272.54	8278.15	8267.81	8277.26	799.0
2018-05-28 02:00:00	NQ	Futures	8277.26	8283.17	8270.76	8273.42	1937.0
2018-05-28 03:00:00	NQ	Futures	8273.72	8276.67	8263.97	8265.15	1990.0
2018-05-28 04:00:00	NQ	Futures	8264.85	8267.22	8260.71	8261.6	1458.0
2018-05-28 05:00:00	NQ	Futures	8262.19	8262.78	8251.85	8252.74	1870.0
2018-05-28 06:00:00	NQ	Futures	8252.74	8258.05	8242.1	8256.58	2700.0
2018-05-28 07:00:00	NQ	Futures	8256.28	8260.12	8248.3	8257.46	1789.0
2018-05-28 08:00:00	NQ	Futures	8257.46	8259.83	8239.14	8241.8	2947.0
2018-05-28 09:00:00	NQ	Futures	8241.8	8254.51	8240.91	8253.03	4552.0
2018-05-28 10:00:00	NQ	Futures	8252.74	8270.17	8250.37	8266.92	5454.0
2018-05-28 11:00:00	NQ	Futures	8267.22	8272.83	8255.39	8258.05	5549.0
2018-05-28 12:00:00	NQ	Futures	8257.76	8272.54	8257.17	8266.03	2885.0
2018-05-28 18:00:00	NQ	Futures	8262.49	8268.4	8252.44	8267.81	1521.0
2018-05-28 19:00:00	NQ	Futures	8266.63	8268.99	8258.94	8261.31	1038.0
2018-05-28 20:00:00	NQ	Futures	8260.71	8262.49	8251.26	8253.62	1812.0
2018-05-28 21:00:00	NQ	Futures	8253.33	8253.33	8239.73	8246.82	2872.0
2018-05-28 22:00:00	NQ	Futures	8246.53	8248.01	8240.62	8246.82	1682.0
2018-05-28 23:00:00	NQ	Futures	8247.42	8248.3	8241.21	8246.82	913.0
2018-05-28 00:00:00	YM	Futures	26948.6	26959.4	26946.4	26955.1	418.0
2018-05-28 01:00:00	YM	Futures	26955.1	26966.0	26942.1	26962.7	774.0
2018-05-28 02:00:00	YM	Futures	26964.9	26973.6	26939.9	26954.0	1863.0
2018-05-28 03:00:00	YM	Futures	26952.9	26973.6	26949.7	26955.1	2066.0
2018-05-28 04:00:00	YM	Futures	26955.1	26958.4	26941.0	26942.1	974.0
2018-05-28 05:00:00	YM	Futures	26941.0	26948.6	26905.1	26905.1	1414.0
2018-05-28 06:00:00	YM	Futures	26906.2	26907.3	26859.5	26901.9	3061.0
2018-05-28 07:00:00	YM	Futures	26901.9	26913.8	26881.2	26892.1	1600.0
2018-05-28 08:00:00	YM	Futures	26892.1	26906.2	26836.7	26846.5	3339.0
2018-05-28 09:00:00	YM	Futures	26846.5	26862.8	26830.2	26856.3	3628.0
2018-05-28 10:00:00	YM	Futures	26855.2	26895.4	26850.8	26885.6	2868.0
2018-05-28 11:00:00	YM	Futures	26884.5	26898.6	26844.3	26862.8	3604.0

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

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