PREVIEW / futures_1hour / 2017-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-18.parquet
  size:    51 KB
  rows:    1,627

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-18 00:00:00	ES	Futures	2798.78	2799.05	2798.5	2798.5	1684.0
2017-10-18 01:00:00	ES	Futures	2798.78	2799.33	2798.5	2798.5	3371.0
2017-10-18 02:00:00	ES	Futures	2798.78	2798.78	2797.96	2798.5	4661.0
2017-10-18 03:00:00	ES	Futures	2798.5	2799.05	2797.68	2798.5	7855.0
2017-10-18 04:00:00	ES	Futures	2798.23	2799.05	2798.23	2798.78	8514.0
2017-10-18 05:00:00	ES	Futures	2798.5	2801.79	2798.23	2801.24	20655.0
2017-10-18 06:00:00	ES	Futures	2801.24	2802.33	2799.6	2802.06	13927.0
2017-10-18 07:00:00	ES	Futures	2802.06	2802.61	2801.51	2801.79	10341.0
2017-10-18 08:00:00	ES	Futures	2801.79	2803.16	2801.24	2802.06	17941.0
2017-10-18 09:00:00	ES	Futures	2802.06	2803.7	2799.87	2800.69	104995.0
2017-10-18 10:00:00	ES	Futures	2800.97	2801.79	2798.23	2800.69	102447.0
2017-10-18 11:00:00	ES	Futures	2800.69	2800.97	2798.23	2799.87	71593.0
2017-10-18 12:00:00	ES	Futures	2799.6	2802.06	2799.33	2801.24	49182.0
2017-10-18 13:00:00	ES	Futures	2801.51	2803.16	2801.51	2802.61	61710.0
2017-10-18 14:00:00	ES	Futures	2802.61	2803.43	2801.51	2801.51	34753.0
2017-10-18 15:00:00	ES	Futures	2801.79	2803.16	2799.33	2800.69	152026.0
2017-10-18 16:00:00	ES	Futures	2800.42	2802.06	2800.15	2801.24	51920.0
2017-10-18 18:00:00	ES	Futures	2801.24	2801.51	2800.15	2801.24	3496.0
2017-10-18 19:00:00	ES	Futures	2800.97	2801.51	2800.69	2801.24	1876.0
2017-10-18 20:00:00	ES	Futures	2801.24	2801.79	2800.69	2800.97	4806.0
2017-10-18 21:00:00	ES	Futures	2800.97	2801.24	2800.69	2801.24	1726.0
2017-10-18 22:00:00	ES	Futures	2801.24	2802.06	2800.97	2801.51	3883.0
2017-10-18 23:00:00	ES	Futures	2801.51	2801.51	2800.15	2800.15	3329.0
2017-10-18 00:00:00	NQ	Futures	7288.19	7289.68	7287.89	7287.89	345.0
2017-10-18 01:00:00	NQ	Futures	7288.19	7289.97	7287.3	7287.89	775.0
2017-10-18 02:00:00	NQ	Futures	7287.89	7288.19	7285.22	7286.7	678.0
2017-10-18 03:00:00	NQ	Futures	7286.7	7287.6	7284.62	7285.51	895.0
2017-10-18 04:00:00	NQ	Futures	7285.51	7287.0	7284.92	7286.11	763.0
2017-10-18 05:00:00	NQ	Futures	7285.81	7294.44	7284.62	7292.65	2648.0
2017-10-18 06:00:00	NQ	Futures	7292.35	7292.65	7286.7	7291.76	2165.0
2017-10-18 07:00:00	NQ	Futures	7291.46	7293.25	7289.68	7289.68	2122.0
2017-10-18 08:00:00	NQ	Futures	7289.38	7294.44	7288.19	7291.46	3391.0
2017-10-18 09:00:00	NQ	Futures	7290.87	7295.92	7272.43	7276.0	35005.0
2017-10-18 10:00:00	NQ	Futures	7276.0	7286.41	7266.48	7281.65	37824.0
2017-10-18 11:00:00	NQ	Futures	7281.35	7283.13	7273.32	7276.0	18838.0
2017-10-18 12:00:00	NQ	Futures	7275.7	7289.68	7274.81	7286.11	14937.0
2017-10-18 13:00:00	NQ	Futures	7286.11	7289.38	7283.43	7287.6	11040.0
2017-10-18 14:00:00	NQ	Futures	7287.6	7289.68	7281.94	7284.32	10486.0
2017-10-18 15:00:00	NQ	Futures	7284.32	7288.49	7272.43	7276.89	27064.0
2017-10-18 16:00:00	NQ	Futures	7277.19	7281.35	7276.0	7279.86	5646.0
2017-10-18 18:00:00	NQ	Futures	7282.24	7282.24	7278.08	7281.05	890.0
2017-10-18 19:00:00	NQ	Futures	7281.35	7282.84	7276.29	7277.48	1354.0
2017-10-18 20:00:00	NQ	Futures	7277.48	7277.78	7274.21	7276.0	1191.0
2017-10-18 21:00:00	NQ	Futures	7275.7	7277.78	7275.4	7276.89	695.0
2017-10-18 22:00:00	NQ	Futures	7276.89	7279.27	7276.89	7277.19	839.0
2017-10-18 23:00:00	NQ	Futures	7277.48	7277.78	7274.81	7274.81	622.0
2017-10-18 00:00:00	YM	Futures	24997.2	24999.3	24989.5	24990.6	490.0
2017-10-18 01:00:00	YM	Futures	24991.7	24998.2	24989.5	24991.7	862.0
2017-10-18 02:00:00	YM	Futures	24991.7	24996.1	24987.4	24993.9	1056.0
2017-10-18 03:00:00	YM	Futures	24993.9	25004.8	24990.6	24998.2	1739.0

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

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