PREVIEW / futures_1hour / 2018-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-12.parquet
  size:    55 KB
  rows:    1,690

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-12 00:00:00	ES	Futures	2880.6	2883.88	2878.69	2883.06	5646.0
2018-02-12 01:00:00	ES	Futures	2883.34	2884.16	2878.96	2881.7	6169.0
2018-02-12 02:00:00	ES	Futures	2881.7	2883.06	2878.69	2881.42	13266.0
2018-02-12 03:00:00	ES	Futures	2881.42	2896.46	2875.68	2894.54	39633.0
2018-02-12 04:00:00	ES	Futures	2894.54	2902.74	2893.18	2898.1	34439.0
2018-02-12 05:00:00	ES	Futures	2898.1	2898.37	2890.99	2895.64	17132.0
2018-02-12 06:00:00	ES	Futures	2895.64	2897.82	2890.44	2891.81	15136.0
2018-02-12 07:00:00	ES	Futures	2891.81	2899.46	2891.26	2894.54	27123.0
2018-02-12 08:00:00	ES	Futures	2894.54	2898.37	2886.62	2887.44	42859.0
2018-02-12 09:00:00	ES	Futures	2887.71	2901.92	2871.86	2884.16	313140.0
2018-02-12 10:00:00	ES	Futures	2884.16	2894.82	2864.48	2881.42	355877.0
2018-02-12 11:00:00	ES	Futures	2881.42	2899.74	2874.59	2899.19	203164.0
2018-02-12 12:00:00	ES	Futures	2899.46	2909.03	2895.36	2902.2	157492.0
2018-02-12 13:00:00	ES	Futures	2902.47	2916.41	2897.28	2913.13	139927.0
2018-02-12 14:00:00	ES	Futures	2913.13	2916.96	2904.38	2909.03	155540.0
2018-02-12 15:00:00	ES	Futures	2909.03	2920.78	2892.63	2901.65	384493.0
2018-02-12 16:00:00	ES	Futures	2901.38	2904.38	2892.63	2900.01	113359.0
2018-02-12 18:00:00	ES	Futures	2900.83	2905.48	2895.91	2899.46	11403.0
2018-02-12 19:00:00	ES	Futures	2899.46	2900.01	2892.9	2897.55	18118.0
2018-02-12 20:00:00	ES	Futures	2897.28	2904.66	2894.82	2903.29	12319.0
2018-02-12 21:00:00	ES	Futures	2903.56	2907.39	2902.2	2905.2	7709.0
2018-02-12 22:00:00	ES	Futures	2905.2	2906.57	2902.74	2904.11	3445.0
2018-02-12 23:00:00	ES	Futures	2904.11	2905.2	2890.99	2898.1	9565.0
2018-02-12 00:00:00	NQ	Futures	7645.01	7652.13	7640.56	7650.35	1237.0
2018-02-12 01:00:00	NQ	Futures	7651.24	7651.84	7638.49	7645.9	1191.0
2018-02-12 02:00:00	NQ	Futures	7646.5	7653.02	7637.6	7649.46	3764.0
2018-02-12 03:00:00	NQ	Futures	7648.28	7685.65	7629.29	7683.87	7155.0
2018-02-12 04:00:00	NQ	Futures	7684.16	7709.97	7678.53	7702.55	6764.0
2018-02-12 05:00:00	NQ	Futures	7702.85	7706.11	7685.35	7698.99	3662.0
2018-02-12 06:00:00	NQ	Futures	7699.29	7704.63	7680.31	7683.57	3065.0
2018-02-12 07:00:00	NQ	Futures	7683.57	7705.52	7681.79	7693.65	5227.0
2018-02-12 08:00:00	NQ	Futures	7694.25	7708.19	7668.74	7676.16	12759.0
2018-02-12 09:00:00	NQ	Futures	7675.86	7731.32	7639.38	7683.27	59528.0
2018-02-12 10:00:00	NQ	Futures	7683.57	7720.94	7622.47	7681.2	62596.0
2018-02-12 11:00:00	NQ	Futures	7681.79	7743.19	7666.07	7742.89	40155.0
2018-02-12 12:00:00	NQ	Futures	7742.89	7758.02	7718.87	7731.92	34343.0
2018-02-12 13:00:00	NQ	Futures	7732.21	7765.73	7708.48	7759.8	29654.0
2018-02-12 14:00:00	NQ	Futures	7759.8	7776.4	7735.18	7756.83	28493.0
2018-02-12 15:00:00	NQ	Futures	7758.31	7791.53	7719.76	7741.41	59749.0
2018-02-12 16:00:00	NQ	Futures	7741.7	7755.05	7725.69	7742.3	12955.0
2018-02-12 18:00:00	NQ	Futures	7746.75	7758.31	7731.03	7743.48	2322.0
2018-02-12 19:00:00	NQ	Futures	7744.67	7745.26	7717.98	7733.1	4897.0
2018-02-12 20:00:00	NQ	Futures	7732.81	7765.73	7726.28	7761.58	6118.0
2018-02-12 21:00:00	NQ	Futures	7761.58	7772.55	7757.72	7764.84	2656.0
2018-02-12 22:00:00	NQ	Futures	7766.02	7771.36	7756.83	7763.35	1386.0
2018-02-12 23:00:00	NQ	Futures	7763.35	7765.43	7727.76	7742.89	4101.0
2018-02-12 00:00:00	YM	Futures	26422.1	26460.1	26405.8	26454.7	1792.0
2018-02-12 01:00:00	YM	Futures	26454.7	26469.9	26428.6	26449.2	1810.0
2018-02-12 02:00:00	YM	Futures	26451.4	26468.8	26424.2	26441.6	3148.0
2018-02-12 03:00:00	YM	Futures	26441.6	26601.4	26381.8	26575.3	7835.0

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

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