PREVIEW / futures_1hour / 2020-12-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	4137.58	4138.43	4135.34	4137.86	3618.0
2020-12-16 01:00:00	ES	Futures	4137.58	4139.83	4135.62	4139.27	2472.0
2020-12-16 02:00:00	ES	Futures	4139.27	4142.07	4137.86	4138.71	4696.0
2020-12-16 03:00:00	ES	Futures	4138.43	4152.46	4138.15	4149.37	21300.0
2020-12-16 04:00:00	ES	Futures	4149.37	4150.21	4147.13	4149.65	11927.0
2020-12-16 05:00:00	ES	Futures	4149.37	4154.7	4148.53	4153.58	8847.0
2020-12-16 06:00:00	ES	Futures	4153.86	4154.42	4151.62	4153.02	9404.0
2020-12-16 07:00:00	ES	Futures	4153.02	4153.02	4149.37	4149.93	13161.0
2020-12-16 08:00:00	ES	Futures	4149.93	4155.83	4141.23	4146.0	44590.0
2020-12-16 09:00:00	ES	Futures	4146.0	4146.57	4132.81	4140.39	129503.0
2020-12-16 10:00:00	ES	Futures	4140.39	4148.25	4138.15	4142.92	130949.0
2020-12-16 11:00:00	ES	Futures	4142.92	4149.65	4141.23	4147.97	103448.0
2020-12-16 12:00:00	ES	Futures	4147.69	4148.81	4138.43	4145.72	73329.0
2020-12-16 13:00:00	ES	Futures	4145.44	4146.0	4140.95	4143.76	70868.0
2020-12-16 14:00:00	ES	Futures	4143.76	4154.42	4134.78	4153.58	183853.0
2020-12-16 15:00:00	ES	Futures	4153.3	4158.91	4145.16	4147.97	254375.0
2020-12-16 16:00:00	ES	Futures	4147.97	4149.93	4144.6	4146.85	44156.0
2020-12-16 18:00:00	ES	Futures	4150.49	4150.78	4146.57	4149.09	5564.0
2020-12-16 19:00:00	ES	Futures	4149.37	4150.21	4144.88	4149.37	7340.0
2020-12-16 20:00:00	ES	Futures	4149.37	4152.18	4147.41	4149.09	5657.0
2020-12-16 21:00:00	ES	Futures	4149.37	4152.46	4147.97	4151.9	3778.0
2020-12-16 22:00:00	ES	Futures	4152.18	4155.55	4151.62	4153.02	4101.0
2020-12-16 23:00:00	ES	Futures	4153.3	4157.79	4153.02	4157.23	6003.0
2020-12-16 00:00:00	NQ	Futures	14600.48	14607.14	14590.93	14606.56	1892.0
2020-12-16 01:00:00	NQ	Futures	14606.27	14614.38	14599.91	14608.3	1543.0
2020-12-16 02:00:00	NQ	Futures	14608.3	14613.8	14600.2	14602.22	2107.0
2020-12-16 03:00:00	NQ	Futures	14602.22	14644.48	14599.33	14636.09	8129.0
2020-12-16 04:00:00	NQ	Futures	14636.66	14640.14	14628.56	14632.03	3606.0
2020-12-16 05:00:00	NQ	Futures	14632.03	14637.82	14624.22	14631.45	2492.0
2020-12-16 06:00:00	NQ	Futures	14631.45	14631.45	14611.48	14619.3	3408.0
2020-12-16 07:00:00	NQ	Futures	14619.01	14619.59	14604.25	14608.01	4534.0
2020-12-16 08:00:00	NQ	Futures	14608.88	14624.8	14588.33	14617.85	11759.0
2020-12-16 09:00:00	NQ	Futures	14618.14	14618.72	14555.04	14588.91	51906.0
2020-12-16 10:00:00	NQ	Futures	14589.2	14627.98	14557.94	14614.09	54603.0
2020-12-16 11:00:00	NQ	Futures	14613.8	14653.74	14602.51	14649.98	35720.0
2020-12-16 12:00:00	NQ	Futures	14649.69	14656.63	14619.59	14640.72	24170.0
2020-12-16 13:00:00	NQ	Futures	14640.14	14649.4	14618.43	14640.14	17726.0
2020-12-16 14:00:00	NQ	Futures	14640.72	14684.71	14599.33	14680.37	47858.0
2020-12-16 15:00:00	NQ	Futures	14680.66	14708.73	14665.03	14671.97	53692.0
2020-12-16 16:00:00	NQ	Futures	14671.4	14691.08	14664.16	14675.45	12897.0
2020-12-16 18:00:00	NQ	Futures	14681.53	14693.97	14678.34	14684.13	2741.0
2020-12-16 19:00:00	NQ	Futures	14683.84	14689.05	14674.29	14681.53	2801.0
2020-12-16 20:00:00	NQ	Futures	14681.24	14688.76	14675.74	14679.21	2422.0
2020-12-16 21:00:00	NQ	Futures	14679.21	14684.71	14670.82	14684.42	2045.0
2020-12-16 22:00:00	NQ	Futures	14683.55	14705.26	14682.39	14694.55	2888.0
2020-12-16 23:00:00	NQ	Futures	14694.55	14716.26	14693.68	14710.18	5286.0
2020-12-16 00:00:00	YM	Futures	33374.6	33381.2	33351.3	33369.0	697.0
2020-12-16 01:00:00	YM	Futures	33367.9	33390.1	33352.4	33386.8	918.0
2020-12-16 02:00:00	YM	Futures	33386.8	33410.1	33370.1	33381.2	1018.0
2020-12-16 03:00:00	YM	Futures	33380.1	33491.0	33375.7	33473.3	5672.0

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

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