PREVIEW / futures_1hour / 2018-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-06.parquet
  size:    60 KB
  rows:    1,732

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-06 00:00:00	ES	Futures	2788.77	2837.14	2781.39	2831.13	71999.0
2018-02-06 01:00:00	ES	Futures	2831.13	2838.24	2813.91	2824.85	38608.0
2018-02-06 02:00:00	ES	Futures	2824.3	2860.38	2821.57	2844.25	89847.0
2018-02-06 03:00:00	ES	Futures	2844.25	2887.98	2838.24	2885.25	109397.0
2018-02-06 04:00:00	ES	Futures	2884.98	2891.26	2861.74	2865.3	82248.0
2018-02-06 05:00:00	ES	Futures	2865.3	2871.31	2841.24	2867.76	80677.0
2018-02-06 06:00:00	ES	Futures	2868.03	2871.04	2818.29	2824.3	83469.0
2018-02-06 07:00:00	ES	Futures	2824.57	2860.65	2812.82	2846.16	127368.0
2018-02-06 08:00:00	ES	Futures	2845.89	2854.64	2813.09	2850.26	131976.0
2018-02-06 09:00:00	ES	Futures	2849.99	2930.08	2819.65	2909.03	691720.0
2018-02-06 10:00:00	ES	Futures	2909.03	2930.9	2859.56	2886.34	797072.0
2018-02-06 11:00:00	ES	Futures	2886.62	2890.99	2861.47	2879.78	341124.0
2018-02-06 12:00:00	ES	Futures	2879.78	2916.14	2879.51	2900.01	305747.0
2018-02-06 13:00:00	ES	Futures	2900.01	2901.65	2873.5	2875.96	239597.0
2018-02-06 14:00:00	ES	Futures	2875.96	2921.88	2868.58	2918.87	318765.0
2018-02-06 15:00:00	ES	Futures	2919.14	2951.67	2918.6	2946.2	561288.0
2018-02-06 16:00:00	ES	Futures	2946.48	2951.12	2932.81	2935.0	163436.0
2018-02-06 18:00:00	ES	Futures	2936.09	2949.21	2930.08	2938.28	26401.0
2018-02-06 19:00:00	ES	Futures	2938.55	2948.12	2933.63	2943.2	22494.0
2018-02-06 20:00:00	ES	Futures	2943.2	2943.74	2935.82	2938.55	14596.0
2018-02-06 21:00:00	ES	Futures	2938.55	2946.2	2931.17	2934.18	16136.0
2018-02-06 22:00:00	ES	Futures	2933.9	2938.55	2924.06	2930.9	14694.0
2018-02-06 23:00:00	ES	Futures	2930.62	2931.72	2924.61	2928.44	6235.0
2018-02-06 00:00:00	NQ	Futures	7489.3	7637.01	7474.18	7623.96	14551.0
2018-02-06 01:00:00	NQ	Futures	7625.73	7634.34	7575.02	7593.41	7501.0
2018-02-06 02:00:00	NQ	Futures	7594.0	7681.79	7582.43	7638.49	16428.0
2018-02-06 03:00:00	NQ	Futures	7638.19	7726.87	7623.96	7717.98	17292.0
2018-02-06 04:00:00	NQ	Futures	7717.09	7757.72	7672.6	7684.16	14826.0
2018-02-06 05:00:00	NQ	Futures	7682.98	7698.4	7629.29	7677.64	12977.0
2018-02-06 06:00:00	NQ	Futures	7678.53	7679.42	7547.14	7559.3	21562.0
2018-02-06 07:00:00	NQ	Futures	7559.59	7645.01	7542.69	7613.57	19171.0
2018-02-06 08:00:00	NQ	Futures	7612.98	7645.9	7546.54	7643.83	34065.0
2018-02-06 09:00:00	NQ	Futures	7644.12	7829.79	7561.67	7766.91	129002.0
2018-02-06 10:00:00	NQ	Futures	7766.91	7829.79	7619.51	7705.82	116685.0
2018-02-06 11:00:00	NQ	Futures	7706.41	7737.85	7647.68	7709.37	51214.0
2018-02-06 12:00:00	NQ	Futures	7709.67	7823.86	7709.37	7785.6	57114.0
2018-02-06 13:00:00	NQ	Futures	7786.49	7799.54	7709.97	7717.98	43382.0
2018-02-06 14:00:00	NQ	Futures	7717.98	7841.95	7692.47	7834.24	60242.0
2018-02-06 15:00:00	NQ	Futures	7833.94	7920.55	7826.53	7908.69	91537.0
2018-02-06 16:00:00	NQ	Futures	7909.87	7922.03	7868.05	7872.5	18904.0
2018-02-06 18:00:00	NQ	Futures	7875.17	7916.1	7857.37	7878.14	5424.0
2018-02-06 19:00:00	NQ	Futures	7879.03	7902.46	7863.6	7901.27	7263.0
2018-02-06 20:00:00	NQ	Futures	7902.16	7906.02	7869.24	7884.66	6205.0
2018-02-06 21:00:00	NQ	Futures	7885.55	7903.94	7859.45	7861.82	4182.0
2018-02-06 22:00:00	NQ	Futures	7861.53	7880.81	7831.87	7854.41	5958.0
2018-02-06 23:00:00	NQ	Futures	7854.41	7856.78	7837.5	7848.18	2853.0
2018-02-06 00:00:00	YM	Futures	25290.6	25648.2	25197.1	25568.9	13984.0
2018-02-06 01:00:00	YM	Futures	25572.1	25641.7	25420.0	25535.2	7139.0
2018-02-06 02:00:00	YM	Futures	25544.9	25888.4	25535.2	25713.4	13424.0
2018-02-06 03:00:00	YM	Futures	25706.9	26192.7	25652.5	26173.2	18284.0

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

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