PREVIEW / futures_1hour / 2018-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-20.parquet
  size:    53 KB
  rows:    1,646

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-03-20 00:00:00	ES	Futures	2971.97	2976.88	2971.42	2974.15	5967.0
2018-03-20 01:00:00	ES	Futures	2973.88	2977.15	2973.33	2977.15	4764.0
2018-03-20 02:00:00	ES	Futures	2976.88	2978.52	2974.97	2976.61	7597.0
2018-03-20 03:00:00	ES	Futures	2976.61	2977.15	2972.51	2972.51	9978.0
2018-03-20 04:00:00	ES	Futures	2972.51	2974.15	2969.79	2973.06	12823.0
2018-03-20 05:00:00	ES	Futures	2973.06	2973.06	2965.15	2968.42	17195.0
2018-03-20 06:00:00	ES	Futures	2968.42	2975.52	2967.06	2974.15	14895.0
2018-03-20 07:00:00	ES	Futures	2973.88	2979.06	2973.61	2978.79	19926.0
2018-03-20 08:00:00	ES	Futures	2978.52	2979.06	2973.61	2974.42	19589.0
2018-03-20 09:00:00	ES	Futures	2974.42	2977.7	2968.42	2969.51	160014.0
2018-03-20 10:00:00	ES	Futures	2969.51	2977.43	2965.15	2973.33	164592.0
2018-03-20 11:00:00	ES	Futures	2973.33	2974.7	2962.14	2966.51	124435.0
2018-03-20 12:00:00	ES	Futures	2966.78	2973.06	2964.87	2968.15	100317.0
2018-03-20 13:00:00	ES	Futures	2968.15	2970.06	2962.14	2963.51	64994.0
2018-03-20 14:00:00	ES	Futures	2963.78	2974.42	2961.33	2973.06	101127.0
2018-03-20 15:00:00	ES	Futures	2973.06	2976.61	2967.6	2969.79	156695.0
2018-03-20 16:00:00	ES	Futures	2969.79	2974.15	2968.42	2973.33	54242.0
2018-03-20 17:00:00	ES	Futures	2973.33	2973.33	2973.33	2973.33	2.0
2018-03-20 18:00:00	ES	Futures	2972.79	2975.24	2970.06	2970.6	5769.0
2018-03-20 19:00:00	ES	Futures	2970.6	2972.24	2970.33	2971.7	2311.0
2018-03-20 20:00:00	ES	Futures	2971.7	2972.51	2970.33	2970.6	2900.0
2018-03-20 21:00:00	ES	Futures	2970.6	2975.79	2970.33	2974.42	5353.0
2018-03-20 22:00:00	ES	Futures	2974.42	2976.06	2974.42	2975.52	2072.0
2018-03-20 23:00:00	ES	Futures	2975.52	2976.34	2974.7	2975.52	1797.0
2018-03-20 00:00:00	NQ	Futures	8141.02	8161.12	8138.96	8150.78	2283.0
2018-03-20 01:00:00	NQ	Futures	8150.78	8163.19	8146.34	8162.3	2031.0
2018-03-20 02:00:00	NQ	Futures	8162.3	8167.33	8155.5	8159.94	2713.0
2018-03-20 03:00:00	NQ	Futures	8159.94	8166.14	8151.37	8151.37	3444.0
2018-03-20 04:00:00	NQ	Futures	8151.37	8156.1	8144.87	8154.03	4653.0
2018-03-20 05:00:00	NQ	Futures	8153.73	8154.32	8127.13	8139.25	6724.0
2018-03-20 06:00:00	NQ	Futures	8139.55	8168.51	8136.59	8163.78	6124.0
2018-03-20 07:00:00	NQ	Futures	8163.48	8189.49	8162.89	8185.35	9957.0
2018-03-20 08:00:00	NQ	Futures	8185.06	8188.01	8169.99	8173.24	7691.0
2018-03-20 09:00:00	NQ	Futures	8173.24	8178.56	8135.41	8153.14	64639.0
2018-03-20 10:00:00	NQ	Futures	8152.85	8176.49	8129.5	8168.21	62967.0
2018-03-20 11:00:00	NQ	Futures	8167.92	8172.35	8112.95	8130.38	54105.0
2018-03-20 12:00:00	NQ	Futures	8130.98	8172.65	8123.59	8152.25	43834.0
2018-03-20 13:00:00	NQ	Futures	8152.25	8156.69	8126.54	8133.04	25479.0
2018-03-20 14:00:00	NQ	Futures	8133.34	8169.99	8126.54	8167.92	30686.0
2018-03-20 15:00:00	NQ	Futures	8167.92	8182.69	8154.32	8163.48	41197.0
2018-03-20 16:00:00	NQ	Futures	8163.19	8178.56	8160.82	8177.67	8909.0
2018-03-20 18:00:00	NQ	Futures	8171.46	8181.51	8163.19	8165.85	1361.0
2018-03-20 19:00:00	NQ	Futures	8164.96	8172.35	8164.67	8171.76	1128.0
2018-03-20 20:00:00	NQ	Futures	8172.05	8175.6	8166.44	8168.8	1209.0
2018-03-20 21:00:00	NQ	Futures	8168.21	8179.15	8168.21	8174.42	1934.0
2018-03-20 22:00:00	NQ	Futures	8174.71	8181.22	8174.42	8178.85	1035.0
2018-03-20 23:00:00	NQ	Futures	8178.85	8182.4	8177.37	8180.33	1033.0
2018-03-20 00:00:00	YM	Futures	26785.7	26834.5	26782.4	26810.7	2009.0
2018-03-20 01:00:00	YM	Futures	26809.6	26851.9	26807.4	26848.7	2454.0
2018-03-20 02:00:00	YM	Futures	26848.7	26871.5	26834.5	26840.0	3492.0

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

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