PREVIEW / futures_1hour / 2018-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-28.parquet
  size:    55 KB
  rows:    1,689

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-06-28 00:00:00	ES	Futures	2955.71	2957.35	2955.44	2956.53	4131.0
2018-06-28 01:00:00	ES	Futures	2956.8	2957.89	2951.08	2951.9	6687.0
2018-06-28 02:00:00	ES	Futures	2951.9	2955.44	2949.45	2950.81	14863.0
2018-06-28 03:00:00	ES	Futures	2950.81	2958.98	2948.9	2957.89	30224.0
2018-06-28 04:00:00	ES	Futures	2957.62	2961.44	2951.35	2954.08	27219.0
2018-06-28 05:00:00	ES	Futures	2954.08	2955.17	2947.54	2952.99	26165.0
2018-06-28 06:00:00	ES	Futures	2952.99	2960.35	2951.08	2954.08	25113.0
2018-06-28 07:00:00	ES	Futures	2954.35	2954.62	2947.81	2950.81	31502.0
2018-06-28 08:00:00	ES	Futures	2950.54	2950.81	2935.28	2937.19	108474.0
2018-06-28 09:00:00	ES	Futures	2937.19	2950.54	2936.37	2946.18	277836.0
2018-06-28 10:00:00	ES	Futures	2946.18	2952.17	2935.55	2951.35	287326.0
2018-06-28 11:00:00	ES	Futures	2951.35	2957.89	2944.0	2954.08	178454.0
2018-06-28 12:00:00	ES	Futures	2953.81	2955.44	2942.91	2951.63	111565.0
2018-06-28 13:00:00	ES	Futures	2951.63	2957.62	2950.54	2956.53	98480.0
2018-06-28 14:00:00	ES	Futures	2956.53	2967.7	2955.17	2967.7	111914.0
2018-06-28 15:00:00	ES	Futures	2967.43	2971.24	2960.62	2962.53	206117.0
2018-06-28 16:00:00	ES	Futures	2962.8	2966.07	2960.62	2964.98	52849.0
2018-06-28 18:00:00	ES	Futures	2964.43	2966.61	2961.71	2962.53	5541.0
2018-06-28 19:00:00	ES	Futures	2962.53	2966.07	2961.71	2966.07	2277.0
2018-06-28 20:00:00	ES	Futures	2966.07	2968.25	2961.16	2963.89	11672.0
2018-06-28 21:00:00	ES	Futures	2963.62	2966.61	2960.89	2963.62	9017.0
2018-06-28 22:00:00	ES	Futures	2963.89	2975.6	2962.8	2975.33	18324.0
2018-06-28 23:00:00	ES	Futures	2975.06	2975.88	2972.33	2974.79	7901.0
2018-06-28 00:00:00	NQ	Futures	8263.73	8272.56	8263.73	8268.73	1583.0
2018-06-28 01:00:00	NQ	Futures	8269.62	8274.33	8248.12	8249.01	3746.0
2018-06-28 02:00:00	NQ	Futures	8248.71	8261.08	8241.65	8246.95	5892.0
2018-06-28 03:00:00	NQ	Futures	8247.24	8281.69	8239.59	8274.92	10829.0
2018-06-28 04:00:00	NQ	Futures	8274.33	8290.52	8251.36	8263.43	8868.0
2018-06-28 05:00:00	NQ	Futures	8263.73	8268.14	8243.41	8259.31	6363.0
2018-06-28 06:00:00	NQ	Futures	8259.31	8277.57	8251.36	8259.61	6300.0
2018-06-28 07:00:00	NQ	Futures	8259.9	8263.43	8241.06	8252.84	13369.0
2018-06-28 08:00:00	NQ	Futures	8252.54	8252.54	8191.89	8203.96	30852.0
2018-06-28 09:00:00	NQ	Futures	8203.96	8272.56	8203.67	8257.84	80702.0
2018-06-28 10:00:00	NQ	Futures	8258.13	8274.62	8206.61	8273.15	84419.0
2018-06-28 11:00:00	NQ	Futures	8273.15	8292.88	8250.19	8278.45	58914.0
2018-06-28 12:00:00	NQ	Futures	8278.16	8283.45	8240.18	8267.26	35189.0
2018-06-28 13:00:00	NQ	Futures	8267.26	8282.87	8262.85	8277.86	29395.0
2018-06-28 14:00:00	NQ	Futures	8277.86	8323.2	8273.74	8323.2	31675.0
2018-06-28 15:00:00	NQ	Futures	8322.91	8333.8	8299.06	8305.54	43329.0
2018-06-28 16:00:00	NQ	Futures	8305.54	8319.08	8303.77	8310.84	8013.0
2018-06-28 18:00:00	NQ	Futures	8308.77	8318.78	8303.77	8305.54	1501.0
2018-06-28 19:00:00	NQ	Futures	8305.24	8315.84	8302.89	8315.84	1152.0
2018-06-28 20:00:00	NQ	Futures	8315.84	8324.38	8299.94	8306.71	4345.0
2018-06-28 21:00:00	NQ	Futures	8306.42	8318.49	8296.7	8310.25	3566.0
2018-06-28 22:00:00	NQ	Futures	8309.95	8355.0	8305.54	8352.94	6069.0
2018-06-28 23:00:00	NQ	Futures	8352.64	8355.29	8345.87	8351.76	3152.0
2018-06-28 00:00:00	YM	Futures	26305.5	26328.3	26301.2	26320.7	1375.0
2018-06-28 01:00:00	YM	Futures	26321.8	26334.9	26268.5	26276.2	2496.0
2018-06-28 02:00:00	YM	Futures	26274.0	26301.2	26231.6	26243.5	3643.0
2018-06-28 03:00:00	YM	Futures	26244.6	26324.0	26227.2	26317.5	6839.0

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

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