PREVIEW / futures_1hour / 2019-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-02.parquet
  size:    58 KB
  rows:    1,736

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
2019-01-02 00:00:00	ES	Futures	2699.82	2702.54	2690.86	2691.95	9350.0
2019-01-02 01:00:00	ES	Futures	2691.95	2700.37	2691.67	2696.29	6402.0
2019-01-02 02:00:00	ES	Futures	2696.29	2698.74	2688.96	2690.32	14217.0
2019-01-02 03:00:00	ES	Futures	2690.05	2690.59	2663.97	2669.4	51247.0
2019-01-02 04:00:00	ES	Futures	2669.68	2682.98	2668.32	2681.08	28660.0
2019-01-02 05:00:00	ES	Futures	2681.35	2684.61	2676.19	2678.1	18981.0
2019-01-02 06:00:00	ES	Futures	2678.37	2685.43	2676.47	2682.98	21146.0
2019-01-02 07:00:00	ES	Futures	2682.98	2691.95	2680.54	2681.08	23544.0
2019-01-02 08:00:00	ES	Futures	2680.81	2684.07	2674.02	2677.28	38230.0
2019-01-02 09:00:00	ES	Futures	2677.28	2696.02	2677.01	2693.58	226167.0
2019-01-02 10:00:00	ES	Futures	2693.58	2715.3	2687.33	2712.04	292474.0
2019-01-02 11:00:00	ES	Futures	2712.04	2729.7	2709.06	2712.32	256143.0
2019-01-02 12:00:00	ES	Futures	2712.59	2728.34	2709.87	2726.44	171291.0
2019-01-02 13:00:00	ES	Futures	2726.17	2738.12	2726.17	2737.3	136623.0
2019-01-02 14:00:00	ES	Futures	2737.57	2737.57	2721.55	2722.91	130815.0
2019-01-02 15:00:00	ES	Futures	2722.91	2730.24	2710.69	2727.8	316563.0
2019-01-02 16:00:00	ES	Futures	2727.52	2729.15	2703.08	2704.98	93737.0
2019-01-02 18:00:00	ES	Futures	2696.56	2698.19	2684.07	2688.42	34624.0
2019-01-02 19:00:00	ES	Futures	2688.69	2694.93	2688.14	2688.69	12407.0
2019-01-02 20:00:00	ES	Futures	2688.96	2699.28	2687.33	2697.65	14253.0
2019-01-02 21:00:00	ES	Futures	2697.65	2699.82	2690.86	2691.67	11043.0
2019-01-02 22:00:00	ES	Futures	2691.67	2693.58	2689.23	2692.22	7880.0
2019-01-02 23:00:00	ES	Futures	2692.22	2693.85	2689.23	2691.67	5164.0
2019-01-02 00:00:00	NQ	Futures	7335.71	7347.69	7309.7	7315.25	4243.0
2019-01-02 01:00:00	NQ	Futures	7315.54	7336.29	7314.08	7325.48	3887.0
2019-01-02 02:00:00	NQ	Futures	7324.89	7334.83	7301.23	7306.78	6849.0
2019-01-02 03:00:00	NQ	Futures	7306.49	7307.66	7192.53	7214.74	24518.0
2019-01-02 04:00:00	NQ	Futures	7215.32	7247.76	7212.69	7240.45	13503.0
2019-01-02 05:00:00	NQ	Futures	7241.33	7263.53	7223.21	7230.23	11610.0
2019-01-02 06:00:00	NQ	Futures	7230.23	7251.55	7225.26	7243.67	8774.0
2019-01-02 07:00:00	NQ	Futures	7243.67	7275.51	7240.45	7242.2	13075.0
2019-01-02 08:00:00	NQ	Futures	7242.2	7260.61	7230.23	7238.41	14469.0
2019-01-02 09:00:00	NQ	Futures	7237.82	7328.11	7236.36	7319.05	86383.0
2019-01-02 10:00:00	NQ	Futures	7318.76	7405.83	7295.09	7392.97	102075.0
2019-01-02 11:00:00	NQ	Futures	7393.27	7442.65	7383.33	7389.47	84439.0
2019-01-02 12:00:00	NQ	Futures	7390.05	7454.33	7383.62	7447.91	59552.0
2019-01-02 13:00:00	NQ	Futures	7447.32	7490.86	7447.32	7487.64	43988.0
2019-01-02 14:00:00	NQ	Futures	7488.23	7488.52	7442.65	7447.61	37228.0
2019-01-02 15:00:00	NQ	Futures	7447.32	7459.01	7398.53	7448.78	74747.0
2019-01-02 16:00:00	NQ	Futures	7448.78	7454.63	7305.32	7317.88	25662.0
2019-01-02 18:00:00	NQ	Futures	7296.26	7297.72	7254.48	7267.92	10843.0
2019-01-02 19:00:00	NQ	Futures	7268.21	7288.08	7266.16	7275.81	5167.0
2019-01-02 20:00:00	NQ	Futures	7275.22	7306.49	7271.13	7302.1	5705.0
2019-01-02 21:00:00	NQ	Futures	7302.4	7309.41	7281.94	7285.16	5837.0
2019-01-02 22:00:00	NQ	Futures	7284.57	7288.37	7270.26	7284.28	4429.0
2019-01-02 23:00:00	NQ	Futures	7283.99	7290.12	7273.76	7284.86	3454.0
2019-01-02 00:00:00	YM	Futures	25075.5	25101.5	24994.1	25007.1	3123.0
2019-01-02 01:00:00	YM	Futures	25009.3	25083.1	25004.9	25041.8	2623.0
2019-01-02 02:00:00	YM	Futures	25041.8	25070.1	24981.0	24988.6	5296.0
2019-01-02 03:00:00	YM	Futures	24987.5	24991.9	24738.9	24798.6	16406.0

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

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