PREVIEW / futures_1hour / 2017-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-25.parquet
  size:    53 KB
  rows:    1,628

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
2017-10-25 00:00:00	ES	Futures	2806.44	2806.71	2805.07	2805.07	2747.0
2017-10-25 01:00:00	ES	Futures	2805.34	2805.34	2801.79	2804.25	15170.0
2017-10-25 02:00:00	ES	Futures	2804.25	2805.62	2803.98	2805.07	7036.0
2017-10-25 03:00:00	ES	Futures	2804.8	2807.53	2803.7	2806.44	19336.0
2017-10-25 04:00:00	ES	Futures	2806.44	2806.71	2803.98	2805.34	15521.0
2017-10-25 05:00:00	ES	Futures	2805.62	2807.26	2803.7	2805.89	12858.0
2017-10-25 06:00:00	ES	Futures	2805.89	2807.26	2805.07	2807.26	12334.0
2017-10-25 07:00:00	ES	Futures	2806.98	2808.08	2803.7	2804.8	27241.0
2017-10-25 08:00:00	ES	Futures	2804.52	2806.71	2804.25	2805.62	23466.0
2017-10-25 09:00:00	ES	Futures	2805.34	2806.71	2800.42	2800.97	172187.0
2017-10-25 10:00:00	ES	Futures	2800.97	2803.43	2792.76	2795.22	295127.0
2017-10-25 11:00:00	ES	Futures	2795.22	2795.22	2786.19	2789.2	400019.0
2017-10-25 12:00:00	ES	Futures	2788.93	2789.2	2781.0	2788.11	299899.0
2017-10-25 13:00:00	ES	Futures	2788.11	2793.85	2786.19	2793.31	155255.0
2017-10-25 14:00:00	ES	Futures	2793.31	2797.14	2791.67	2793.85	153974.0
2017-10-25 15:00:00	ES	Futures	2793.85	2798.5	2791.12	2795.5	315517.0
2017-10-25 16:00:00	ES	Futures	2795.5	2800.97	2795.5	2800.69	127998.0
2017-10-25 18:00:00	ES	Futures	2800.69	2800.97	2799.05	2799.6	5650.0
2017-10-25 19:00:00	ES	Futures	2799.6	2799.6	2798.23	2799.05	3939.0
2017-10-25 20:00:00	ES	Futures	2798.78	2801.24	2798.5	2799.87	8403.0
2017-10-25 21:00:00	ES	Futures	2799.87	2800.42	2798.5	2799.6	6130.0
2017-10-25 22:00:00	ES	Futures	2799.33	2800.69	2799.05	2800.42	3717.0
2017-10-25 23:00:00	ES	Futures	2800.15	2800.69	2799.6	2799.87	5073.0
2017-10-25 00:00:00	NQ	Futures	7228.11	7228.71	7221.57	7221.87	910.0
2017-10-25 01:00:00	NQ	Futures	7221.87	7223.35	7210.27	7217.11	3381.0
2017-10-25 02:00:00	NQ	Futures	7216.81	7222.46	7216.81	7220.38	1338.0
2017-10-25 03:00:00	NQ	Futures	7220.68	7225.14	7215.62	7223.06	2323.0
2017-10-25 04:00:00	NQ	Futures	7223.06	7223.95	7215.03	7219.49	1736.0
2017-10-25 05:00:00	NQ	Futures	7219.49	7223.35	7213.24	7219.78	1618.0
2017-10-25 06:00:00	NQ	Futures	7220.08	7224.84	7217.11	7224.25	1778.0
2017-10-25 07:00:00	NQ	Futures	7224.84	7227.52	7216.51	7218.3	3174.0
2017-10-25 08:00:00	NQ	Futures	7218.3	7223.95	7214.13	7218.0	5733.0
2017-10-25 09:00:00	NQ	Futures	7218.3	7242.09	7212.94	7217.4	56206.0
2017-10-25 10:00:00	NQ	Futures	7217.7	7229.3	7204.02	7212.94	60800.0
2017-10-25 11:00:00	NQ	Futures	7212.65	7212.94	7157.03	7173.09	95273.0
2017-10-25 12:00:00	NQ	Futures	7172.79	7185.58	7151.08	7183.2	66457.0
2017-10-25 13:00:00	NQ	Futures	7182.9	7196.88	7177.55	7193.61	35630.0
2017-10-25 14:00:00	NQ	Futures	7193.31	7204.91	7188.85	7195.4	31902.0
2017-10-25 15:00:00	NQ	Futures	7195.1	7209.08	7190.04	7204.02	49284.0
2017-10-25 16:00:00	NQ	Futures	7204.02	7217.11	7203.72	7217.11	11932.0
2017-10-25 18:00:00	NQ	Futures	7215.32	7216.51	7209.37	7210.86	1117.0
2017-10-25 19:00:00	NQ	Futures	7210.86	7211.46	7206.7	7209.37	842.0
2017-10-25 20:00:00	NQ	Futures	7209.08	7217.11	7208.18	7212.35	1564.0
2017-10-25 21:00:00	NQ	Futures	7212.65	7214.43	7208.48	7212.65	1374.0
2017-10-25 22:00:00	NQ	Futures	7212.65	7218.3	7212.05	7218.3	1193.0
2017-10-25 23:00:00	NQ	Futures	7218.3	7218.59	7215.03	7216.51	610.0
2017-10-25 00:00:00	YM	Futures	25451.8	25454.0	25440.9	25440.9	567.0
2017-10-25 01:00:00	YM	Futures	25442.0	25443.1	25415.9	25432.2	2841.0
2017-10-25 02:00:00	YM	Futures	25432.2	25446.4	25432.2	25440.9	1503.0
2017-10-25 03:00:00	YM	Futures	25442.0	25458.3	25431.1	25450.7	2087.0

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

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