PREVIEW / futures_1hour / 2020-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-03.parquet
  size:    66 KB
  rows:    1,954

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-11-03 00:00:00	ES	Futures	3710.69	3719.09	3710.41	3714.89	3896.0
2020-11-03 01:00:00	ES	Futures	3714.89	3720.78	3711.81	3717.41	6131.0
2020-11-03 02:00:00	ES	Futures	3717.13	3723.86	3713.49	3718.81	10532.0
2020-11-03 03:00:00	ES	Futures	3718.81	3741.22	3715.17	3738.7	33958.0
2020-11-03 04:00:00	ES	Futures	3738.42	3752.99	3733.38	3750.47	29530.0
2020-11-03 05:00:00	ES	Futures	3750.19	3752.43	3741.78	3742.9	18617.0
2020-11-03 06:00:00	ES	Futures	3742.9	3749.91	3739.26	3746.26	20858.0
2020-11-03 07:00:00	ES	Futures	3745.98	3747.94	3739.82	3740.66	17848.0
2020-11-03 08:00:00	ES	Futures	3740.94	3745.7	3735.06	3738.42	35941.0
2020-11-03 09:00:00	ES	Futures	3738.42	3759.43	3732.54	3757.47	156450.0
2020-11-03 10:00:00	ES	Futures	3757.47	3787.72	3755.79	3785.48	263174.0
2020-11-03 11:00:00	ES	Futures	3785.76	3789.96	3773.43	3774.83	148325.0
2020-11-03 12:00:00	ES	Futures	3774.55	3778.47	3765.59	3767.27	116972.0
2020-11-03 13:00:00	ES	Futures	3767.55	3771.75	3751.03	3753.27	173653.0
2020-11-03 14:00:00	ES	Futures	3752.99	3772.87	3751.87	3767.83	185114.0
2020-11-03 15:00:00	ES	Futures	3767.83	3788.28	3757.19	3763.35	293728.0
2020-11-03 16:00:00	ES	Futures	3763.63	3765.59	3749.34	3764.47	73071.0
2020-11-03 18:00:00	ES	Futures	3767.55	3803.68	3759.99	3791.08	38795.0
2020-11-03 19:00:00	ES	Futures	3791.08	3805.92	3737.86	3740.66	91478.0
2020-11-03 20:00:00	ES	Futures	3740.66	3781.28	3740.38	3768.11	70947.0
2020-11-03 21:00:00	ES	Futures	3768.39	3785.48	3729.18	3781.56	95702.0
2020-11-03 22:00:00	ES	Futures	3781.56	3845.42	3779.88	3819.09	118432.0
2020-11-03 23:00:00	ES	Futures	3819.37	3835.05	3779.32	3798.64	70560.0
2020-11-03 00:00:00	NQ	Futures	12817.96	12846.33	12817.38	12832.44	2793.0
2020-11-03 01:00:00	NQ	Futures	12833.59	12861.96	12818.54	12848.94	3718.0
2020-11-03 02:00:00	NQ	Futures	12847.78	12873.25	12835.04	12852.7	4303.0
2020-11-03 03:00:00	NQ	Futures	12851.25	12929.99	12836.49	12918.12	10301.0
2020-11-03 04:00:00	NQ	Futures	12917.83	12940.41	12901.04	12926.8	6990.0
2020-11-03 05:00:00	NQ	Futures	12926.8	12946.78	12899.01	12901.33	5425.0
2020-11-03 06:00:00	NQ	Futures	12902.2	12918.41	12860.52	12888.01	8894.0
2020-11-03 07:00:00	NQ	Futures	12888.59	12907.7	12876.15	12883.67	6178.0
2020-11-03 08:00:00	NQ	Futures	12883.96	12920.72	12866.59	12891.49	13943.0
2020-11-03 09:00:00	NQ	Futures	12889.75	12969.07	12853.86	12966.75	55790.0
2020-11-03 10:00:00	NQ	Futures	12967.04	13125.09	12963.86	13121.91	87529.0
2020-11-03 11:00:00	NQ	Futures	13122.2	13138.41	13068.06	13078.49	53133.0
2020-11-03 12:00:00	NQ	Futures	13078.49	13114.96	13054.46	13079.93	38395.0
2020-11-03 13:00:00	NQ	Futures	13080.22	13102.8	12987.3	12997.43	46742.0
2020-11-03 14:00:00	NQ	Futures	12996.86	13066.33	12992.51	13054.17	54743.0
2020-11-03 15:00:00	NQ	Futures	13053.59	13125.09	13009.59	13034.2	64411.0
2020-11-03 16:00:00	NQ	Futures	13033.62	13035.07	12984.12	13023.2	16305.0
2020-11-03 18:00:00	NQ	Futures	13042.3	13137.54	13020.3	13103.67	12175.0
2020-11-03 19:00:00	NQ	Futures	13104.25	13135.8	13003.22	13013.64	25308.0
2020-11-03 20:00:00	NQ	Futures	13013.35	13228.14	13009.3	13189.06	23646.0
2020-11-03 21:00:00	NQ	Futures	13191.96	13302.82	13099.62	13295.3	25940.0
2020-11-03 22:00:00	NQ	Futures	13297.9	13626.45	13296.46	13472.45	43388.0
2020-11-03 23:00:00	NQ	Futures	13472.45	13502.56	13286.61	13364.77	23924.0
2020-11-03 00:00:00	YM	Futures	29796.4	29868.3	29796.4	29821.9	1433.0
2020-11-03 01:00:00	YM	Futures	29828.5	29862.8	29806.4	29823.0	1736.0
2020-11-03 02:00:00	YM	Futures	29823.0	29883.8	29787.6	29849.5	3167.0
2020-11-03 03:00:00	YM	Futures	29847.3	30031.9	29814.1	30002.1	7616.0

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

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