PREVIEW / futures_1hour / 2018-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-29.parquet
  size:    54 KB
  rows:    1,716

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-11-29 00:00:00	ES	Futures	2979.74	2979.74	2975.12	2975.93	6599.0
2018-11-29 01:00:00	ES	Futures	2975.93	2976.75	2973.48	2975.93	6451.0
2018-11-29 02:00:00	ES	Futures	2975.93	2977.84	2974.03	2975.93	10054.0
2018-11-29 03:00:00	ES	Futures	2975.93	2979.74	2975.66	2977.56	20246.0
2018-11-29 04:00:00	ES	Futures	2977.56	2978.38	2972.94	2973.76	21118.0
2018-11-29 05:00:00	ES	Futures	2974.03	2976.75	2970.76	2971.85	15790.0
2018-11-29 06:00:00	ES	Futures	2971.58	2974.03	2968.86	2971.85	18303.0
2018-11-29 07:00:00	ES	Futures	2971.85	2977.02	2971.31	2972.4	24591.0
2018-11-29 08:00:00	ES	Futures	2972.67	2978.65	2971.58	2975.66	31816.0
2018-11-29 09:00:00	ES	Futures	2975.39	2980.01	2973.76	2975.93	179000.0
2018-11-29 10:00:00	ES	Futures	2975.93	2981.1	2962.88	2966.68	301852.0
2018-11-29 11:00:00	ES	Futures	2966.68	2980.01	2964.24	2979.2	214222.0
2018-11-29 12:00:00	ES	Futures	2979.2	2983.28	2973.76	2982.73	90209.0
2018-11-29 13:00:00	ES	Futures	2982.73	2984.91	2977.84	2981.64	60740.0
2018-11-29 14:00:00	ES	Futures	2981.92	2996.88	2978.92	2996.06	140939.0
2018-11-29 15:00:00	ES	Futures	2996.33	2996.88	2978.11	2979.74	220584.0
2018-11-29 16:00:00	ES	Futures	2979.74	2986.27	2978.92	2983.28	53970.0
2018-11-29 18:00:00	ES	Futures	2983.28	2983.55	2978.65	2981.64	7168.0
2018-11-29 19:00:00	ES	Futures	2981.37	2983.0	2979.2	2981.1	6532.0
2018-11-29 20:00:00	ES	Futures	2981.1	2981.64	2978.38	2980.83	6990.0
2018-11-29 21:00:00	ES	Futures	2980.83	2983.0	2979.2	2981.92	5670.0
2018-11-29 22:00:00	ES	Futures	2981.92	2984.36	2981.92	2983.0	4320.0
2018-11-29 23:00:00	ES	Futures	2983.28	2984.36	2982.73	2983.28	2385.0
2018-11-29 00:00:00	NQ	Futures	8106.62	8107.5	8086.96	8087.84	4000.0
2018-11-29 01:00:00	NQ	Futures	8088.43	8092.24	8081.68	8087.55	2751.0
2018-11-29 02:00:00	NQ	Futures	8087.84	8095.47	8082.56	8088.43	3721.0
2018-11-29 03:00:00	NQ	Futures	8088.72	8101.92	8084.62	8092.24	6749.0
2018-11-29 04:00:00	NQ	Futures	8092.54	8094.3	8072.3	8076.11	8141.0
2018-11-29 05:00:00	NQ	Futures	8076.11	8086.67	8063.21	8064.97	6259.0
2018-11-29 06:00:00	NQ	Futures	8065.26	8072.89	8055.58	8063.5	7001.0
2018-11-29 07:00:00	NQ	Futures	8062.91	8084.91	8061.74	8068.78	8909.0
2018-11-29 08:00:00	NQ	Futures	8069.07	8094.3	8066.14	8081.68	17995.0
2018-11-29 09:00:00	NQ	Futures	8081.39	8108.67	8066.14	8089.02	72304.0
2018-11-29 10:00:00	NQ	Futures	8088.14	8099.87	8028.59	8037.39	106497.0
2018-11-29 11:00:00	NQ	Futures	8037.39	8092.83	8032.11	8086.38	82923.0
2018-11-29 12:00:00	NQ	Futures	8086.08	8104.56	8066.43	8102.8	35614.0
2018-11-29 13:00:00	NQ	Futures	8102.8	8111.02	8080.51	8097.23	30833.0
2018-11-29 14:00:00	NQ	Futures	8097.23	8146.21	8087.55	8143.87	52450.0
2018-11-29 15:00:00	NQ	Futures	8144.16	8146.8	8089.31	8094.0	48032.0
2018-11-29 16:00:00	NQ	Futures	8094.0	8112.19	8087.84	8103.68	10219.0
2018-11-29 18:00:00	NQ	Futures	8098.11	8103.68	8088.43	8098.99	2465.0
2018-11-29 19:00:00	NQ	Futures	8098.99	8105.15	8094.0	8098.4	2939.0
2018-11-29 20:00:00	NQ	Futures	8097.82	8099.87	8089.02	8098.4	3471.0
2018-11-29 21:00:00	NQ	Futures	8098.99	8111.02	8094.59	8105.74	4169.0
2018-11-29 22:00:00	NQ	Futures	8106.32	8112.48	8103.98	8106.62	2103.0
2018-11-29 23:00:00	NQ	Futures	8106.32	8111.31	8105.44	8108.67	1164.0
2018-11-29 00:00:00	YM	Futures	27522.4	27523.5	27480.1	27489.8	2029.0
2018-11-29 01:00:00	YM	Futures	27490.9	27492.0	27455.1	27482.2	2720.0
2018-11-29 02:00:00	YM	Futures	27482.2	27507.2	27461.6	27487.7	3391.0
2018-11-29 03:00:00	YM	Futures	27486.6	27514.8	27471.4	27494.2	5407.0

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

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