PREVIEW / futures_1hour / 2017-10-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	2806.98	2807.53	2806.44	2806.71	3633.0
2017-10-24 01:00:00	ES	Futures	2806.71	2807.81	2805.62	2807.26	6497.0
2017-10-24 02:00:00	ES	Futures	2807.26	2807.81	2805.62	2806.44	8675.0
2017-10-24 03:00:00	ES	Futures	2806.44	2808.35	2806.16	2806.98	19409.0
2017-10-24 04:00:00	ES	Futures	2806.98	2807.26	2803.98	2806.44	19318.0
2017-10-24 05:00:00	ES	Futures	2806.44	2807.81	2806.16	2807.53	10721.0
2017-10-24 06:00:00	ES	Futures	2807.53	2809.45	2806.98	2807.81	13036.0
2017-10-24 07:00:00	ES	Futures	2807.81	2810.81	2807.53	2809.17	30383.0
2017-10-24 08:00:00	ES	Futures	2808.9	2811.09	2808.63	2809.99	32858.0
2017-10-24 09:00:00	ES	Futures	2809.99	2811.36	2804.8	2805.07	168986.0
2017-10-24 10:00:00	ES	Futures	2805.34	2809.17	2804.8	2808.35	112990.0
2017-10-24 11:00:00	ES	Futures	2808.63	2811.09	2808.35	2809.99	85175.0
2017-10-24 12:00:00	ES	Futures	2809.72	2810.81	2809.17	2809.72	45411.0
2017-10-24 13:00:00	ES	Futures	2809.72	2811.09	2808.63	2810.54	56512.0
2017-10-24 14:00:00	ES	Futures	2810.54	2812.46	2808.63	2809.45	78471.0
2017-10-24 15:00:00	ES	Futures	2809.72	2810.54	2805.89	2809.45	245329.0
2017-10-24 16:00:00	ES	Futures	2809.45	2809.72	2806.16	2806.71	63895.0
2017-10-24 18:00:00	ES	Futures	2806.44	2806.71	2805.07	2805.62	5110.0
2017-10-24 19:00:00	ES	Futures	2805.62	2806.44	2804.8	2806.44	3526.0
2017-10-24 20:00:00	ES	Futures	2806.16	2806.98	2803.98	2804.25	6575.0
2017-10-24 21:00:00	ES	Futures	2804.25	2806.16	2804.25	2805.34	5671.0
2017-10-24 22:00:00	ES	Futures	2805.07	2806.16	2805.07	2806.16	2656.0
2017-10-24 23:00:00	ES	Futures	2806.16	2807.53	2806.16	2806.44	3482.0
2017-10-24 00:00:00	NQ	Futures	7222.76	7226.62	7222.76	7223.65	949.0
2017-10-24 01:00:00	NQ	Futures	7223.65	7227.81	7220.38	7225.44	1387.0
2017-10-24 02:00:00	NQ	Futures	7225.44	7226.92	7217.7	7220.68	1758.0
2017-10-24 03:00:00	NQ	Futures	7220.68	7226.92	7218.3	7220.68	2721.0
2017-10-24 04:00:00	NQ	Futures	7220.38	7222.76	7213.54	7220.08	2862.0
2017-10-24 05:00:00	NQ	Futures	7220.38	7225.14	7218.89	7220.08	1945.0
2017-10-24 06:00:00	NQ	Futures	7220.08	7227.81	7218.89	7221.57	2205.0
2017-10-24 07:00:00	NQ	Futures	7221.87	7227.81	7221.27	7223.95	3449.0
2017-10-24 08:00:00	NQ	Futures	7224.25	7236.74	7222.46	7232.87	6246.0
2017-10-24 09:00:00	NQ	Futures	7232.57	7236.44	7205.81	7211.16	55363.0
2017-10-24 10:00:00	NQ	Futures	7211.46	7237.33	7210.27	7232.87	40743.0
2017-10-24 11:00:00	NQ	Futures	7232.87	7243.87	7232.28	7239.12	22165.0
2017-10-24 12:00:00	NQ	Futures	7239.12	7241.79	7234.06	7234.95	11904.0
2017-10-24 13:00:00	NQ	Futures	7235.25	7248.04	7231.98	7242.69	16263.0
2017-10-24 14:00:00	NQ	Futures	7242.69	7247.15	7233.76	7236.14	14116.0
2017-10-24 15:00:00	NQ	Futures	7236.14	7239.71	7225.44	7234.06	34732.0
2017-10-24 16:00:00	NQ	Futures	7233.76	7236.74	7224.25	7226.03	5843.0
2017-10-24 18:00:00	NQ	Futures	7225.44	7228.11	7222.16	7226.62	1184.0
2017-10-24 19:00:00	NQ	Futures	7226.03	7229.0	7223.06	7228.41	700.0
2017-10-24 20:00:00	NQ	Futures	7228.11	7229.0	7220.38	7221.57	1258.0
2017-10-24 21:00:00	NQ	Futures	7221.57	7227.22	7221.27	7225.14	1222.0
2017-10-24 22:00:00	NQ	Futures	7224.54	7228.41	7224.25	7227.22	693.0
2017-10-24 23:00:00	NQ	Futures	7227.22	7231.98	7226.92	7227.81	710.0
2017-10-24 00:00:00	YM	Futures	25301.7	25306.1	25298.4	25302.8	653.0
2017-10-24 01:00:00	YM	Futures	25302.8	25311.5	25295.2	25307.2	1200.0
2017-10-24 02:00:00	YM	Futures	25306.1	25311.5	25290.8	25298.4	1663.0
2017-10-24 03:00:00	YM	Futures	25297.4	25315.9	25297.4	25306.1	2296.0

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

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