PREVIEW / futures_1hour / 2018-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-21.parquet
  size:    52 KB
  rows:    1,622

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-21 00:00:00	ES	Futures	2979.61	2980.43	2979.06	2979.34	1953.0
2018-05-21 01:00:00	ES	Futures	2979.34	2980.16	2978.79	2979.34	2358.0
2018-05-21 02:00:00	ES	Futures	2979.61	2979.61	2975.79	2976.34	6288.0
2018-05-21 03:00:00	ES	Futures	2976.34	2978.25	2973.88	2977.43	9768.0
2018-05-21 04:00:00	ES	Futures	2977.43	2979.06	2976.34	2978.52	8359.0
2018-05-21 05:00:00	ES	Futures	2978.79	2979.88	2978.25	2978.79	6562.0
2018-05-21 06:00:00	ES	Futures	2979.06	2980.16	2977.7	2978.52	5131.0
2018-05-21 07:00:00	ES	Futures	2978.52	2979.34	2977.7	2977.7	4117.0
2018-05-21 08:00:00	ES	Futures	2977.7	2979.88	2976.06	2978.52	14072.0
2018-05-21 09:00:00	ES	Futures	2978.52	2987.8	2977.43	2982.61	142825.0
2018-05-21 10:00:00	ES	Futures	2982.61	2990.25	2981.52	2988.07	127346.0
2018-05-21 11:00:00	ES	Futures	2987.8	2988.89	2974.97	2980.43	150965.0
2018-05-21 12:00:00	ES	Futures	2980.7	2986.16	2979.34	2983.43	70322.0
2018-05-21 13:00:00	ES	Futures	2983.43	2986.98	2983.16	2985.89	44095.0
2018-05-21 14:00:00	ES	Futures	2985.89	2986.16	2977.97	2982.61	75595.0
2018-05-21 15:00:00	ES	Futures	2982.34	2983.98	2978.25	2983.16	138831.0
2018-05-21 16:00:00	ES	Futures	2982.88	2983.98	2981.52	2982.88	51580.0
2018-05-21 18:00:00	ES	Futures	2981.52	2982.88	2980.7	2982.61	2882.0
2018-05-21 19:00:00	ES	Futures	2982.61	2982.61	2980.97	2981.79	1284.0
2018-05-21 20:00:00	ES	Futures	2981.52	2982.61	2980.7	2981.79	3029.0
2018-05-21 21:00:00	ES	Futures	2981.52	2983.43	2981.52	2982.88	2697.0
2018-05-21 22:00:00	ES	Futures	2982.88	2983.43	2982.07	2982.61	2090.0
2018-05-21 23:00:00	ES	Futures	2982.61	2985.34	2982.34	2984.52	4098.0
2018-05-21 00:00:00	NQ	Futures	8192.74	8195.4	8189.79	8190.38	775.0
2018-05-21 01:00:00	NQ	Futures	8190.08	8191.26	8184.17	8184.47	1176.0
2018-05-21 02:00:00	NQ	Futures	8184.76	8185.06	8169.39	8171.46	2886.0
2018-05-21 03:00:00	NQ	Futures	8171.17	8172.35	8155.21	8171.76	4726.0
2018-05-21 04:00:00	NQ	Futures	8171.76	8184.17	8169.69	8182.4	3018.0
2018-05-21 05:00:00	NQ	Futures	8182.4	8189.79	8177.67	8179.44	2921.0
2018-05-21 06:00:00	NQ	Futures	8179.44	8185.65	8175.31	8180.63	1286.0
2018-05-21 07:00:00	NQ	Futures	8180.03	8183.58	8177.08	8178.85	1776.0
2018-05-21 08:00:00	NQ	Futures	8178.85	8192.74	8174.42	8188.01	5136.0
2018-05-21 09:00:00	NQ	Futures	8188.31	8224.07	8182.69	8211.66	46454.0
2018-05-21 10:00:00	NQ	Futures	8211.95	8218.16	8195.99	8204.27	39671.0
2018-05-21 11:00:00	NQ	Futures	8203.68	8209.0	8134.82	8162.6	58810.0
2018-05-21 12:00:00	NQ	Futures	8162.89	8180.33	8157.57	8173.83	25811.0
2018-05-21 13:00:00	NQ	Futures	8173.83	8188.6	8170.87	8176.49	20069.0
2018-05-21 14:00:00	NQ	Futures	8176.19	8176.78	8136.59	8156.1	27315.0
2018-05-21 15:00:00	NQ	Futures	8155.8	8174.12	8148.41	8171.46	31598.0
2018-05-21 16:00:00	NQ	Futures	8171.46	8178.26	8168.21	8173.24	6082.0
2018-05-21 18:00:00	NQ	Futures	8173.24	8175.6	8167.33	8171.76	886.0
2018-05-21 19:00:00	NQ	Futures	8171.76	8172.35	8167.03	8169.69	756.0
2018-05-21 20:00:00	NQ	Futures	8169.99	8172.65	8167.03	8169.1	1093.0
2018-05-21 21:00:00	NQ	Futures	8169.39	8175.31	8169.1	8172.35	864.0
2018-05-21 22:00:00	NQ	Futures	8172.65	8174.12	8168.51	8170.58	1583.0
2018-05-21 23:00:00	NQ	Futures	8170.87	8180.63	8170.87	8177.08	1296.0
2018-05-21 00:00:00	YM	Futures	27073.5	27081.1	27072.4	27075.6	971.0
2018-05-21 01:00:00	YM	Futures	27074.6	27093.0	27073.5	27083.2	1427.0
2018-05-21 02:00:00	YM	Futures	27085.4	27095.2	27057.2	27074.6	3456.0
2018-05-21 03:00:00	YM	Futures	27074.6	27107.1	27058.3	27093.0	3731.0

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

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