PREVIEW / futures_1hour / 2020-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-02.parquet
  size:    62 KB
  rows:    1,833

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
2020-04-02 00:00:00	ES	Futures	2724.39	2730.42	2716.7	2721.92	8810.0
2020-04-02 01:00:00	ES	Futures	2721.92	2725.76	2708.19	2724.66	11997.0
2020-04-02 02:00:00	ES	Futures	2724.39	2734.26	2724.39	2733.17	18184.0
2020-04-02 03:00:00	ES	Futures	2733.44	2739.75	2728.23	2735.64	33572.0
2020-04-02 04:00:00	ES	Futures	2735.36	2746.34	2734.26	2735.91	27617.0
2020-04-02 05:00:00	ES	Futures	2735.91	2738.65	2727.13	2729.05	23033.0
2020-04-02 06:00:00	ES	Futures	2728.78	2737.28	2722.46	2734.26	21255.0
2020-04-02 07:00:00	ES	Futures	2734.26	2740.85	2724.66	2739.48	32864.0
2020-04-02 08:00:00	ES	Futures	2739.48	2742.5	2687.61	2697.49	113931.0
2020-04-02 09:00:00	ES	Futures	2697.77	2716.7	2661.54	2701.06	264502.0
2020-04-02 10:00:00	ES	Futures	2701.06	2769.39	2696.94	2749.08	324245.0
2020-04-02 11:00:00	ES	Futures	2748.81	2754.3	2724.93	2748.81	198662.0
2020-04-02 12:00:00	ES	Futures	2748.81	2761.43	2742.77	2751.28	140466.0
2020-04-02 13:00:00	ES	Futures	2751.55	2759.24	2712.86	2721.37	182996.0
2020-04-02 14:00:00	ES	Futures	2721.37	2733.72	2695.85	2732.89	175978.0
2020-04-02 15:00:00	ES	Futures	2732.89	2765.0	2722.46	2761.71	325862.0
2020-04-02 16:00:00	ES	Futures	2761.43	2771.58	2758.96	2761.98	83836.0
2020-04-02 18:00:00	ES	Futures	2759.24	2770.49	2751.83	2764.18	12001.0
2020-04-02 19:00:00	ES	Futures	2763.9	2766.65	2743.05	2749.36	10580.0
2020-04-02 20:00:00	ES	Futures	2749.08	2757.04	2735.91	2741.12	21650.0
2020-04-02 21:00:00	ES	Futures	2741.12	2749.36	2733.72	2747.71	14662.0
2020-04-02 22:00:00	ES	Futures	2747.71	2747.98	2734.54	2741.4	7346.0
2020-04-02 23:00:00	ES	Futures	2741.4	2741.95	2732.07	2734.54	6465.0
2020-04-02 00:00:00	NQ	Futures	8598.64	8620.06	8577.22	8596.07	3631.0
2020-04-02 01:00:00	NQ	Futures	8595.78	8608.92	8558.94	8604.35	5287.0
2020-04-02 02:00:00	NQ	Futures	8604.07	8636.34	8602.35	8632.92	4853.0
2020-04-02 03:00:00	NQ	Futures	8632.63	8664.91	8621.21	8646.06	8048.0
2020-04-02 04:00:00	NQ	Futures	8645.77	8679.48	8640.34	8643.77	7385.0
2020-04-02 05:00:00	NQ	Futures	8643.49	8652.05	8590.64	8597.21	7881.0
2020-04-02 06:00:00	NQ	Futures	8597.5	8624.63	8575.79	8607.78	7312.0
2020-04-02 07:00:00	NQ	Futures	8608.35	8644.34	8580.64	8637.49	8399.0
2020-04-02 08:00:00	NQ	Futures	8636.63	8656.63	8490.95	8511.52	25205.0
2020-04-02 09:00:00	NQ	Futures	8512.38	8592.93	8427.54	8536.08	55890.0
2020-04-02 10:00:00	NQ	Futures	8534.66	8703.76	8523.23	8644.06	68954.0
2020-04-02 11:00:00	NQ	Futures	8643.2	8692.33	8606.92	8678.62	40090.0
2020-04-02 12:00:00	NQ	Futures	8678.33	8705.47	8642.91	8671.19	26260.0
2020-04-02 13:00:00	NQ	Futures	8672.62	8695.19	8559.79	8588.36	32292.0
2020-04-02 14:00:00	NQ	Futures	8589.21	8620.06	8507.81	8617.78	43484.0
2020-04-02 15:00:00	NQ	Futures	8617.21	8712.61	8592.07	8704.33	50810.0
2020-04-02 16:00:00	NQ	Futures	8703.47	8747.74	8696.9	8708.61	13669.0
2020-04-02 18:00:00	NQ	Futures	8709.75	8742.32	8690.9	8722.61	3393.0
2020-04-02 19:00:00	NQ	Futures	8721.47	8728.61	8656.34	8674.05	3378.0
2020-04-02 20:00:00	NQ	Futures	8673.48	8695.76	8643.49	8662.62	5383.0
2020-04-02 21:00:00	NQ	Futures	8660.05	8683.19	8635.2	8679.76	3479.0
2020-04-02 22:00:00	NQ	Futures	8680.33	8681.48	8641.2	8664.34	2144.0
2020-04-02 23:00:00	NQ	Futures	8665.77	8666.34	8628.92	8638.06	1653.0
2020-04-02 00:00:00	YM	Futures	23034.5	23079.4	22966.6	23008.2	2502.0
2020-04-02 01:00:00	YM	Futures	23011.5	23043.3	22889.9	23031.2	3771.0
2020-04-02 02:00:00	YM	Futures	23033.4	23126.5	23031.2	23112.3	4547.0
2020-04-02 03:00:00	YM	Futures	23114.5	23175.8	23075.1	23138.6	6605.0

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

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