PREVIEW / futures_1hour / 2018-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-13.parquet
  size:    54 KB
  rows:    1,676

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-02-13 00:00:00	ES	Futures	2898.1	2898.64	2892.63	2893.45	7869.0
2018-02-13 01:00:00	ES	Futures	2893.72	2895.91	2892.08	2894.54	6071.0
2018-02-13 02:00:00	ES	Futures	2894.54	2896.18	2886.07	2887.98	21703.0
2018-02-13 03:00:00	ES	Futures	2887.98	2893.72	2882.24	2885.52	28493.0
2018-02-13 04:00:00	ES	Futures	2885.8	2890.99	2883.88	2886.07	17110.0
2018-02-13 05:00:00	ES	Futures	2886.07	2890.17	2883.61	2889.08	13048.0
2018-02-13 06:00:00	ES	Futures	2889.08	2889.35	2881.97	2888.26	14188.0
2018-02-13 07:00:00	ES	Futures	2888.26	2895.09	2887.16	2893.72	20565.0
2018-02-13 08:00:00	ES	Futures	2893.72	2895.91	2885.8	2886.89	36322.0
2018-02-13 09:00:00	ES	Futures	2886.89	2894.0	2880.06	2887.44	240977.0
2018-02-13 10:00:00	ES	Futures	2887.16	2900.28	2885.52	2897.0	219315.0
2018-02-13 11:00:00	ES	Futures	2897.0	2899.19	2889.08	2896.46	147098.0
2018-02-13 12:00:00	ES	Futures	2896.73	2900.01	2890.44	2892.36	78293.0
2018-02-13 13:00:00	ES	Futures	2892.36	2912.04	2892.08	2908.76	116087.0
2018-02-13 14:00:00	ES	Futures	2908.48	2915.32	2905.48	2912.31	113913.0
2018-02-13 15:00:00	ES	Futures	2912.04	2916.41	2906.84	2910.12	213478.0
2018-02-13 16:00:00	ES	Futures	2910.12	2913.68	2907.12	2912.31	67104.0
2018-02-13 18:00:00	ES	Futures	2910.94	2914.77	2910.12	2913.4	5696.0
2018-02-13 19:00:00	ES	Futures	2913.4	2915.59	2911.76	2913.95	6593.0
2018-02-13 20:00:00	ES	Futures	2913.68	2914.5	2909.58	2913.13	8902.0
2018-02-13 21:00:00	ES	Futures	2912.86	2913.95	2909.85	2910.94	5873.0
2018-02-13 22:00:00	ES	Futures	2910.94	2913.4	2909.3	2911.49	4136.0
2018-02-13 23:00:00	ES	Futures	2911.49	2914.5	2910.4	2913.95	4066.0
2018-02-13 00:00:00	NQ	Futures	7742.89	7744.67	7727.76	7730.43	5230.0
2018-02-13 01:00:00	NQ	Futures	7730.14	7734.29	7724.8	7731.62	2221.0
2018-02-13 02:00:00	NQ	Futures	7731.92	7743.78	7707.59	7713.53	5913.0
2018-02-13 03:00:00	NQ	Futures	7713.23	7732.81	7702.26	7706.41	4975.0
2018-02-13 04:00:00	NQ	Futures	7707.0	7727.76	7703.44	7712.64	2899.0
2018-02-13 05:00:00	NQ	Futures	7712.64	7725.98	7703.15	7713.23	2732.0
2018-02-13 06:00:00	NQ	Futures	7713.23	7713.23	7683.57	7703.44	4229.0
2018-02-13 07:00:00	NQ	Futures	7704.63	7727.47	7699.29	7720.05	4168.0
2018-02-13 08:00:00	NQ	Futures	7720.94	7728.95	7690.69	7690.69	12495.0
2018-02-13 09:00:00	NQ	Futures	7691.28	7728.65	7676.75	7712.64	55182.0
2018-02-13 10:00:00	NQ	Futures	7712.34	7758.31	7712.34	7745.86	68628.0
2018-02-13 11:00:00	NQ	Futures	7746.15	7749.71	7716.79	7739.92	52890.0
2018-02-13 12:00:00	NQ	Futures	7739.63	7749.71	7715.6	7723.61	26534.0
2018-02-13 13:00:00	NQ	Futures	7723.31	7779.37	7722.72	7769.29	32051.0
2018-02-13 14:00:00	NQ	Futures	7768.69	7790.64	7762.46	7782.04	26940.0
2018-02-13 15:00:00	NQ	Futures	7781.74	7795.68	7765.13	7777.29	41991.0
2018-02-13 16:00:00	NQ	Futures	7777.0	7790.94	7768.99	7784.41	8925.0
2018-02-13 18:00:00	NQ	Futures	7782.04	7789.75	7777.29	7786.49	1804.0
2018-02-13 19:00:00	NQ	Futures	7786.49	7795.09	7785.6	7790.34	3197.0
2018-02-13 20:00:00	NQ	Futures	7790.05	7792.72	7775.81	7786.79	3729.0
2018-02-13 21:00:00	NQ	Futures	7786.79	7790.05	7777.89	7780.56	2715.0
2018-02-13 22:00:00	NQ	Futures	7780.26	7788.27	7776.7	7781.45	2313.0
2018-02-13 23:00:00	NQ	Futures	7781.45	7784.12	7773.14	7782.63	2622.0
2018-02-13 00:00:00	YM	Futures	26656.8	26659.0	26605.7	26617.7	4821.0
2018-02-13 01:00:00	YM	Futures	26616.6	26636.2	26603.6	26625.3	2193.0
2018-02-13 02:00:00	YM	Futures	26624.2	26649.2	26544.9	26572.0	7005.0
2018-02-13 03:00:00	YM	Futures	26572.0	26621.0	26510.1	26537.3	8276.0

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

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