PREVIEW / futures_1hour / 2020-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-04.parquet
  size:    60 KB
  rows:    1,831

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-04 00:00:00	ES	Futures	3670.94	3674.01	3670.1	3672.61	3971.0
2020-08-04 01:00:00	ES	Futures	3672.61	3676.8	3670.66	3675.96	7541.0
2020-08-04 02:00:00	ES	Futures	3675.96	3682.94	3669.54	3679.59	19822.0
2020-08-04 03:00:00	ES	Futures	3679.87	3683.5	3663.12	3663.67	44940.0
2020-08-04 04:00:00	ES	Futures	3663.67	3667.03	3656.41	3664.23	39781.0
2020-08-04 05:00:00	ES	Futures	3664.23	3668.14	3660.32	3663.95	20824.0
2020-08-04 06:00:00	ES	Futures	3663.95	3666.47	3660.32	3663.12	12760.0
2020-08-04 07:00:00	ES	Futures	3663.4	3667.03	3655.02	3656.41	24759.0
2020-08-04 08:00:00	ES	Futures	3656.14	3660.32	3653.62	3657.53	29100.0
2020-08-04 09:00:00	ES	Futures	3657.25	3671.49	3655.58	3670.1	129661.0
2020-08-04 10:00:00	ES	Futures	3669.82	3681.27	3668.7	3678.2	166114.0
2020-08-04 11:00:00	ES	Futures	3678.2	3681.27	3675.68	3678.47	107110.0
2020-08-04 12:00:00	ES	Futures	3678.75	3679.87	3670.94	3673.17	68429.0
2020-08-04 13:00:00	ES	Futures	3672.89	3678.75	3670.1	3677.64	62491.0
2020-08-04 14:00:00	ES	Futures	3677.92	3679.31	3662.28	3674.29	134782.0
2020-08-04 15:00:00	ES	Futures	3674.01	3686.57	3672.33	3686.01	163101.0
2020-08-04 16:00:00	ES	Futures	3685.74	3686.57	3681.55	3685.18	50107.0
2020-08-04 18:00:00	ES	Futures	3686.85	3686.85	3683.5	3685.74	6717.0
2020-08-04 19:00:00	ES	Futures	3686.01	3686.29	3684.62	3684.9	3103.0
2020-08-04 20:00:00	ES	Futures	3684.62	3686.29	3679.03	3681.83	17741.0
2020-08-04 21:00:00	ES	Futures	3681.83	3682.66	3677.08	3680.43	12368.0
2020-08-04 22:00:00	ES	Futures	3680.15	3686.29	3679.59	3685.74	9206.0
2020-08-04 23:00:00	ES	Futures	3685.74	3690.48	3685.18	3688.25	9008.0
2020-08-04 00:00:00	NQ	Futures	12780.82	12792.1	12775.33	12786.9	1498.0
2020-08-04 01:00:00	NQ	Futures	12787.19	12797.31	12780.82	12791.81	2428.0
2020-08-04 02:00:00	NQ	Futures	12791.52	12827.96	12771.28	12817.26	8316.0
2020-08-04 03:00:00	NQ	Futures	12817.26	12830.27	12736.87	12740.63	14374.0
2020-08-04 04:00:00	NQ	Futures	12740.05	12749.59	12708.24	12732.82	13208.0
2020-08-04 05:00:00	NQ	Futures	12733.11	12745.83	12724.43	12729.06	5944.0
2020-08-04 06:00:00	NQ	Futures	12730.22	12743.52	12721.54	12738.31	4778.0
2020-08-04 07:00:00	NQ	Futures	12738.31	12756.53	12715.76	12718.94	9629.0
2020-08-04 08:00:00	NQ	Futures	12719.81	12735.42	12704.19	12727.61	14030.0
2020-08-04 09:00:00	NQ	Futures	12727.04	12800.49	12720.67	12793.55	56176.0
2020-08-04 10:00:00	NQ	Futures	12793.26	12818.71	12778.22	12781.4	56184.0
2020-08-04 11:00:00	NQ	Futures	12781.98	12790.95	12743.81	12774.75	47056.0
2020-08-04 12:00:00	NQ	Futures	12774.46	12778.22	12732.82	12754.51	28433.0
2020-08-04 13:00:00	NQ	Futures	12755.09	12797.02	12738.89	12790.08	25275.0
2020-08-04 14:00:00	NQ	Futures	12790.37	12797.6	12709.98	12754.51	39256.0
2020-08-04 15:00:00	NQ	Futures	12754.51	12821.6	12744.97	12821.6	39565.0
2020-08-04 16:00:00	NQ	Futures	12821.02	12833.45	12805.4	12814.66	11658.0
2020-08-04 18:00:00	NQ	Futures	12816.97	12818.42	12801.36	12815.24	2248.0
2020-08-04 19:00:00	NQ	Futures	12815.24	12820.44	12808.58	12808.58	1322.0
2020-08-04 20:00:00	NQ	Futures	12808.58	12818.71	12791.52	12807.14	5110.0
2020-08-04 21:00:00	NQ	Futures	12807.43	12808.58	12788.34	12798.46	4774.0
2020-08-04 22:00:00	NQ	Futures	12797.6	12828.25	12794.99	12825.07	4025.0
2020-08-04 23:00:00	NQ	Futures	12824.78	12842.42	12819.57	12837.21	3817.0
2020-08-04 00:00:00	YM	Futures	29243.0	29268.3	29235.3	29258.4	686.0
2020-08-04 01:00:00	YM	Futures	29260.6	29298.0	29240.8	29298.0	1340.0
2020-08-04 02:00:00	YM	Futures	29295.8	29364.1	29241.9	29337.7	4634.0
2020-08-04 03:00:00	YM	Futures	29335.5	29376.2	29200.0	29206.6	8100.0

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

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