PREVIEW / futures_1hour / 2020-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-03.parquet
  size:    52 KB
  rows:    1,502

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-03 00:00:00	ES	Futures	2734.54	2734.54	2722.19	2726.31	7738.0
2020-04-03 01:00:00	ES	Futures	2726.03	2737.28	2715.88	2737.01	13280.0
2020-04-03 02:00:00	ES	Futures	2737.01	2742.5	2726.03	2739.48	16704.0
2020-04-03 03:00:00	ES	Futures	2739.48	2744.14	2724.39	2738.38	27191.0
2020-04-03 04:00:00	ES	Futures	2738.11	2742.77	2721.64	2729.87	17194.0
2020-04-03 05:00:00	ES	Futures	2729.87	2735.09	2718.07	2733.72	21471.0
2020-04-03 06:00:00	ES	Futures	2733.99	2738.93	2726.58	2736.19	17529.0
2020-04-03 07:00:00	ES	Futures	2736.19	2773.51	2731.79	2769.11	33996.0
2020-04-03 08:00:00	ES	Futures	2769.11	2772.13	2728.5	2754.3	92261.0
2020-04-03 09:00:00	ES	Futures	2754.3	2776.52	2744.97	2760.88	170275.0
2020-04-03 10:00:00	ES	Futures	2760.88	2771.04	2726.85	2736.46	198610.0
2020-04-03 11:00:00	ES	Futures	2736.73	2744.14	2711.76	2720.82	169894.0
2020-04-03 12:00:00	ES	Futures	2720.82	2724.66	2700.24	2714.23	146815.0
2020-04-03 13:00:00	ES	Futures	2713.96	2720.54	2692.83	2697.49	125495.0
2020-04-03 14:00:00	ES	Futures	2697.77	2716.15	2688.16	2715.06	163344.0
2020-04-03 15:00:00	ES	Futures	2715.06	2730.97	2694.75	2721.64	334008.0
2020-04-03 16:00:00	ES	Futures	2721.37	2730.97	2716.98	2722.46	71464.0
2020-04-03 00:00:00	NQ	Futures	8639.2	8639.2	8600.35	8612.07	2553.0
2020-04-03 01:00:00	NQ	Futures	8610.92	8640.06	8586.36	8638.06	4954.0
2020-04-03 02:00:00	NQ	Futures	8638.92	8655.2	8603.5	8642.34	4363.0
2020-04-03 03:00:00	NQ	Futures	8641.49	8659.48	8596.07	8638.06	6112.0
2020-04-03 04:00:00	NQ	Futures	8639.2	8655.48	8583.5	8609.78	5105.0
2020-04-03 05:00:00	NQ	Futures	8609.78	8626.06	8580.07	8624.92	6037.0
2020-04-03 06:00:00	NQ	Futures	8624.35	8642.34	8601.21	8628.06	5436.0
2020-04-03 07:00:00	NQ	Futures	8629.2	8740.03	8616.64	8725.75	9149.0
2020-04-03 08:00:00	NQ	Futures	8725.18	8733.75	8615.78	8679.76	16660.0
2020-04-03 09:00:00	NQ	Futures	8678.91	8752.31	8650.63	8707.47	36144.0
2020-04-03 10:00:00	NQ	Futures	8708.04	8738.89	8604.07	8625.2	49245.0
2020-04-03 11:00:00	NQ	Futures	8626.63	8645.49	8565.79	8592.36	35636.0
2020-04-03 12:00:00	NQ	Futures	8592.64	8604.07	8530.09	8565.79	29764.0
2020-04-03 13:00:00	NQ	Futures	8564.93	8586.64	8494.95	8508.66	26988.0
2020-04-03 14:00:00	NQ	Futures	8507.81	8566.65	8481.81	8561.79	32870.0
2020-04-03 15:00:00	NQ	Futures	8561.51	8605.21	8498.67	8585.79	45946.0
2020-04-03 16:00:00	NQ	Futures	8585.5	8617.78	8578.07	8594.36	9869.0
2020-04-03 00:00:00	YM	Futures	23049.9	23053.1	22956.8	22988.5	1267.0
2020-04-03 01:00:00	YM	Futures	22985.2	23084.9	22902.0	23082.7	3133.0
2020-04-03 02:00:00	YM	Futures	23083.8	23130.9	22983.0	23106.8	2247.0
2020-04-03 03:00:00	YM	Futures	23103.5	23144.1	22962.2	23093.7	3170.0
2020-04-03 04:00:00	YM	Futures	23090.4	23133.1	22954.6	23021.4	2400.0
2020-04-03 05:00:00	YM	Futures	23022.5	23059.7	22918.4	23045.5	2568.0
2020-04-03 06:00:00	YM	Futures	23043.3	23092.6	22979.8	23061.9	1949.0
2020-04-03 07:00:00	YM	Futures	23058.6	23364.2	23021.4	23332.5	4014.0
2020-04-03 08:00:00	YM	Futures	23336.8	23355.5	22985.2	23193.3	12560.0
2020-04-03 09:00:00	YM	Futures	23190.1	23356.6	23122.2	23235.0	21051.0
2020-04-03 10:00:00	YM	Futures	23238.3	23329.2	22959.0	23058.6	22475.0
2020-04-03 11:00:00	YM	Futures	23059.7	23128.7	22864.8	22948.0	17170.0
2020-04-03 12:00:00	YM	Futures	22949.1	22982.0	22788.1	22879.0	13784.0
2020-04-03 13:00:00	YM	Futures	22879.0	22932.7	22727.8	22783.7	10853.0
2020-04-03 14:00:00	YM	Futures	22780.4	22928.3	22716.9	22919.5	12081.0
2020-04-03 15:00:00	YM	Futures	22919.5	23045.5	22735.5	22933.8	24704.0

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

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