PREVIEW / futures_1hour / 2020-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-23.parquet
  size:    61 KB
  rows:    1,846

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-12-23 00:00:00	ES	Futures	4122.15	4123.55	4118.22	4121.59	5924.0
2020-12-23 01:00:00	ES	Futures	4121.59	4127.2	4120.74	4126.64	6277.0
2020-12-23 02:00:00	ES	Futures	4126.64	4135.62	4125.52	4133.37	10606.0
2020-12-23 03:00:00	ES	Futures	4133.37	4140.11	4132.25	4137.86	13089.0
2020-12-23 04:00:00	ES	Futures	4137.86	4140.95	4136.46	4139.83	10829.0
2020-12-23 05:00:00	ES	Futures	4140.11	4143.48	4139.27	4142.07	10413.0
2020-12-23 06:00:00	ES	Futures	4142.07	4142.36	4137.58	4138.71	6883.0
2020-12-23 07:00:00	ES	Futures	4138.71	4138.71	4133.09	4135.9	8954.0
2020-12-23 08:00:00	ES	Futures	4135.9	4142.36	4134.22	4139.27	16229.0
2020-12-23 09:00:00	ES	Futures	4139.55	4151.06	4137.86	4148.53	161652.0
2020-12-23 10:00:00	ES	Futures	4148.25	4150.49	4140.67	4146.28	148536.0
2020-12-23 11:00:00	ES	Futures	4146.0	4150.21	4144.6	4149.65	81761.0
2020-12-23 12:00:00	ES	Futures	4149.65	4153.02	4148.25	4151.62	51853.0
2020-12-23 13:00:00	ES	Futures	4151.62	4155.83	4151.34	4153.02	57188.0
2020-12-23 14:00:00	ES	Futures	4152.74	4154.7	4147.13	4147.69	60387.0
2020-12-23 15:00:00	ES	Futures	4147.41	4150.21	4130.57	4132.53	185865.0
2020-12-23 16:00:00	ES	Futures	4132.53	4137.3	4125.23	4137.02	61162.0
2020-12-23 18:00:00	ES	Futures	4137.3	4138.71	4132.53	4136.18	7005.0
2020-12-23 19:00:00	ES	Futures	4136.18	4138.99	4133.09	4135.34	5648.0
2020-12-23 20:00:00	ES	Futures	4135.06	4141.51	4129.73	4139.83	9751.0
2020-12-23 21:00:00	ES	Futures	4139.83	4144.6	4138.99	4140.95	5196.0
2020-12-23 22:00:00	ES	Futures	4140.95	4142.36	4138.43	4140.39	2906.0
2020-12-23 23:00:00	ES	Futures	4140.11	4142.64	4137.58	4140.39	3312.0
2020-12-23 00:00:00	NQ	Futures	14693.97	14705.26	14687.6	14700.05	3527.0
2020-12-23 01:00:00	NQ	Futures	14699.18	14727.55	14696.87	14725.23	4518.0
2020-12-23 02:00:00	NQ	Futures	14726.1	14741.15	14721.18	14735.07	5299.0
2020-12-23 03:00:00	NQ	Futures	14735.36	14748.1	14728.99	14736.52	6059.0
2020-12-23 04:00:00	NQ	Futures	14736.52	14745.78	14731.89	14741.44	5093.0
2020-12-23 05:00:00	NQ	Futures	14742.02	14747.81	14737.97	14740.28	4590.0
2020-12-23 06:00:00	NQ	Futures	14740.28	14741.44	14720.6	14725.52	3710.0
2020-12-23 07:00:00	NQ	Futures	14725.23	14728.7	14710.76	14721.47	6635.0
2020-12-23 08:00:00	NQ	Futures	14721.47	14738.26	14713.65	14729.86	7463.0
2020-12-23 09:00:00	NQ	Futures	14729.57	14734.2	14644.48	14691.08	64591.0
2020-12-23 10:00:00	NQ	Futures	14691.08	14709.31	14666.77	14689.05	57047.0
2020-12-23 11:00:00	NQ	Futures	14689.34	14701.79	14662.71	14699.47	32556.0
2020-12-23 12:00:00	NQ	Futures	14699.18	14718.28	14683.84	14715.39	21344.0
2020-12-23 13:00:00	NQ	Futures	14715.1	14739.12	14711.63	14729.57	22426.0
2020-12-23 14:00:00	NQ	Futures	14729.57	14733.05	14703.23	14704.1	17740.0
2020-12-23 15:00:00	NQ	Futures	14704.39	14715.68	14637.53	14645.35	37021.0
2020-12-23 16:00:00	NQ	Futures	14644.77	14657.79	14614.67	14652.0	14521.0
2020-12-23 18:00:00	NQ	Futures	14657.79	14665.9	14639.27	14651.71	3526.0
2020-12-23 19:00:00	NQ	Futures	14651.43	14663.58	14640.72	14645.06	3449.0
2020-12-23 20:00:00	NQ	Futures	14644.77	14667.05	14623.93	14663.29	4919.0
2020-12-23 21:00:00	NQ	Futures	14662.71	14676.9	14660.11	14664.74	3190.0
2020-12-23 22:00:00	NQ	Futures	14665.03	14670.53	14656.92	14663.87	2237.0
2020-12-23 23:00:00	NQ	Futures	14663.87	14677.76	14660.11	14667.63	2462.0
2020-12-23 00:00:00	YM	Futures	33140.5	33148.3	33089.5	33118.3	1749.0
2020-12-23 01:00:00	YM	Futures	33117.2	33151.6	33109.5	33145.0	1580.0
2020-12-23 02:00:00	YM	Futures	33146.1	33210.4	33138.3	33192.7	3161.0
2020-12-23 03:00:00	YM	Futures	33193.8	33262.5	33181.6	33252.6	4009.0

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

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