PREVIEW / futures_1hour / 2020-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-26.parquet
  size:    59 KB
  rows:    1,839

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-08-26 00:00:00	ES	Futures	3845.46	3845.74	3844.62	3845.18	1657.0
2020-08-26 01:00:00	ES	Futures	3845.18	3847.42	3844.07	3844.62	4528.0
2020-08-26 02:00:00	ES	Futures	3844.62	3846.02	3840.72	3842.67	8977.0
2020-08-26 03:00:00	ES	Futures	3842.39	3847.98	3838.76	3845.74	20242.0
2020-08-26 04:00:00	ES	Futures	3845.46	3850.77	3842.67	3847.42	13983.0
2020-08-26 05:00:00	ES	Futures	3847.42	3849.09	3843.79	3844.9	9838.0
2020-08-26 06:00:00	ES	Futures	3844.9	3847.42	3844.62	3847.42	7920.0
2020-08-26 07:00:00	ES	Futures	3847.42	3848.81	3844.9	3845.74	7932.0
2020-08-26 08:00:00	ES	Futures	3845.46	3848.53	3844.62	3846.58	20283.0
2020-08-26 09:00:00	ES	Futures	3846.58	3852.44	3843.51	3849.09	120913.0
2020-08-26 10:00:00	ES	Futures	3849.09	3856.63	3846.3	3855.52	122176.0
2020-08-26 11:00:00	ES	Futures	3855.24	3864.73	3853.56	3863.89	107906.0
2020-08-26 12:00:00	ES	Futures	3863.89	3875.34	3862.78	3870.87	159845.0
2020-08-26 13:00:00	ES	Futures	3870.87	3875.62	3870.59	3875.62	90715.0
2020-08-26 14:00:00	ES	Futures	3875.62	3884.84	3868.08	3870.04	200883.0
2020-08-26 15:00:00	ES	Futures	3870.04	3884.28	3867.24	3881.48	248720.0
2020-08-26 16:00:00	ES	Futures	3881.48	3890.98	3877.85	3887.07	65173.0
2020-08-26 18:00:00	ES	Futures	3886.51	3887.63	3880.37	3882.04	7927.0
2020-08-26 19:00:00	ES	Futures	3882.32	3885.67	3881.48	3884.0	4594.0
2020-08-26 20:00:00	ES	Futures	3884.0	3885.67	3880.65	3883.72	8038.0
2020-08-26 21:00:00	ES	Futures	3883.72	3887.63	3878.13	3878.69	11807.0
2020-08-26 22:00:00	ES	Futures	3878.97	3880.37	3876.18	3877.85	6745.0
2020-08-26 23:00:00	ES	Futures	3877.85	3883.16	3877.02	3881.76	5532.0
2020-08-26 00:00:00	NQ	Futures	13582.14	13582.72	13576.64	13579.25	903.0
2020-08-26 01:00:00	NQ	Futures	13578.67	13591.39	13575.2	13578.09	2379.0
2020-08-26 02:00:00	NQ	Futures	13578.38	13586.48	13568.26	13575.2	3528.0
2020-08-26 03:00:00	NQ	Futures	13575.49	13589.08	13564.5	13579.82	7625.0
2020-08-26 04:00:00	NQ	Futures	13580.69	13610.48	13573.75	13603.25	7660.0
2020-08-26 05:00:00	NQ	Futures	13604.12	13614.24	13593.7	13599.78	3964.0
2020-08-26 06:00:00	NQ	Futures	13599.49	13620.02	13596.31	13617.71	3659.0
2020-08-26 07:00:00	NQ	Futures	13617.71	13630.72	13608.16	13611.63	5824.0
2020-08-26 08:00:00	NQ	Futures	13611.92	13615.1	13573.75	13592.84	14642.0
2020-08-26 09:00:00	NQ	Futures	13593.13	13645.47	13592.55	13633.03	62056.0
2020-08-26 10:00:00	NQ	Futures	13633.32	13698.97	13615.68	13693.18	68092.0
2020-08-26 11:00:00	NQ	Futures	13693.18	13762.01	13689.42	13754.49	66929.0
2020-08-26 12:00:00	NQ	Futures	13754.78	13823.02	13740.61	13768.37	79779.0
2020-08-26 13:00:00	NQ	Futures	13768.37	13820.42	13768.08	13818.97	48113.0
2020-08-26 14:00:00	NQ	Futures	13818.97	13842.98	13727.88	13748.13	77679.0
2020-08-26 15:00:00	NQ	Futures	13748.42	13851.07	13733.09	13839.8	82568.0
2020-08-26 16:00:00	NQ	Futures	13839.8	13882.3	13830.54	13863.22	15074.0
2020-08-26 18:00:00	NQ	Futures	13862.64	13862.64	13835.46	13839.8	3427.0
2020-08-26 19:00:00	NQ	Futures	13839.8	13849.05	13830.54	13842.98	3301.0
2020-08-26 20:00:00	NQ	Futures	13842.4	13849.63	13829.39	13845.29	3896.0
2020-08-26 21:00:00	NQ	Futures	13845.58	13858.01	13823.02	13825.63	5308.0
2020-08-26 22:00:00	NQ	Futures	13825.63	13832.86	13805.09	13815.5	4971.0
2020-08-26 23:00:00	NQ	Futures	13815.79	13847.6	13809.14	13839.22	3256.0
2020-08-26 00:00:00	YM	Futures	31009.2	31013.6	30999.3	31008.1	614.0
2020-08-26 01:00:00	YM	Futures	31007.0	31031.2	30992.7	30998.2	1170.0
2020-08-26 02:00:00	YM	Futures	30997.1	31009.2	30959.7	30978.4	2067.0
2020-08-26 03:00:00	YM	Futures	30976.2	31033.4	30936.5	31010.3	4810.0

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

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