PREVIEW / futures_1hour / 2020-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-22.parquet
  size:    62 KB
  rows:    1,892

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-22 00:00:00	ES	Futures	4124.67	4126.92	4113.73	4117.38	14649.0
2020-12-22 01:00:00	ES	Futures	4117.66	4120.18	4113.17	4115.41	8289.0
2020-12-22 02:00:00	ES	Futures	4115.69	4129.16	4115.13	4124.39	11665.0
2020-12-22 03:00:00	ES	Futures	4124.11	4140.95	4120.46	4138.99	17970.0
2020-12-22 04:00:00	ES	Futures	4138.99	4146.57	4137.3	4137.86	18369.0
2020-12-22 05:00:00	ES	Futures	4138.15	4142.07	4134.78	4142.07	10975.0
2020-12-22 06:00:00	ES	Futures	4142.07	4146.0	4140.11	4142.64	8898.0
2020-12-22 07:00:00	ES	Futures	4142.64	4148.25	4142.07	4146.0	11916.0
2020-12-22 08:00:00	ES	Futures	4146.0	4148.25	4142.07	4142.07	19398.0
2020-12-22 09:00:00	ES	Futures	4142.36	4143.76	4128.88	4135.62	139904.0
2020-12-22 10:00:00	ES	Futures	4135.62	4141.51	4126.92	4134.5	176807.0
2020-12-22 11:00:00	ES	Futures	4134.5	4138.43	4115.41	4126.64	160883.0
2020-12-22 12:00:00	ES	Futures	4126.64	4133.37	4125.23	4131.69	119338.0
2020-12-22 13:00:00	ES	Futures	4131.69	4140.67	4130.85	4137.58	62067.0
2020-12-22 14:00:00	ES	Futures	4137.86	4139.27	4128.88	4133.09	72470.0
2020-12-22 15:00:00	ES	Futures	4132.81	4134.22	4121.87	4129.44	163804.0
2020-12-22 16:00:00	ES	Futures	4129.16	4130.57	4124.95	4125.52	27896.0
2020-12-22 18:00:00	ES	Futures	4124.95	4135.34	4124.67	4135.06	5424.0
2020-12-22 19:00:00	ES	Futures	4134.78	4136.74	4098.85	4107.27	31612.0
2020-12-22 20:00:00	ES	Futures	4107.27	4114.29	4102.22	4110.08	29743.0
2020-12-22 21:00:00	ES	Futures	4110.08	4111.2	4103.34	4110.08	14749.0
2020-12-22 22:00:00	ES	Futures	4109.8	4121.59	4108.39	4120.74	7810.0
2020-12-22 23:00:00	ES	Futures	4120.74	4126.36	4119.9	4122.15	6365.0
2020-12-22 00:00:00	NQ	Futures	14688.76	14690.21	14642.74	14654.9	8912.0
2020-12-22 01:00:00	NQ	Futures	14655.19	14663.0	14633.19	14639.85	4853.0
2020-12-22 02:00:00	NQ	Futures	14640.43	14698.31	14637.82	14681.24	7304.0
2020-12-22 03:00:00	NQ	Futures	14680.66	14722.34	14672.84	14714.23	8397.0
2020-12-22 04:00:00	NQ	Futures	14714.52	14750.12	14709.31	14727.84	8235.0
2020-12-22 05:00:00	NQ	Futures	14728.13	14743.18	14724.07	14737.68	3962.0
2020-12-22 06:00:00	NQ	Futures	14737.68	14748.67	14728.41	14734.49	4001.0
2020-12-22 07:00:00	NQ	Futures	14734.49	14769.22	14732.76	14757.94	7350.0
2020-12-22 08:00:00	NQ	Futures	14758.23	14772.7	14751.86	14752.15	7705.0
2020-12-22 09:00:00	NQ	Futures	14752.44	14766.04	14678.34	14760.25	65465.0
2020-12-22 10:00:00	NQ	Futures	14760.54	14761.12	14680.66	14704.68	81026.0
2020-12-22 11:00:00	NQ	Futures	14704.68	14708.15	14579.94	14651.14	81770.0
2020-12-22 12:00:00	NQ	Futures	14651.14	14686.74	14648.24	14676.32	39440.0
2020-12-22 13:00:00	NQ	Futures	14676.61	14720.02	14675.45	14706.42	27563.0
2020-12-22 14:00:00	NQ	Futures	14706.71	14722.92	14682.39	14700.34	26444.0
2020-12-22 15:00:00	NQ	Futures	14700.05	14719.73	14671.4	14718.86	41684.0
2020-12-22 16:00:00	NQ	Futures	14719.15	14721.47	14708.73	14711.63	7132.0
2020-12-22 18:00:00	NQ	Futures	14708.73	14730.15	14704.68	14727.26	2675.0
2020-12-22 19:00:00	NQ	Futures	14727.26	14730.44	14622.19	14650.27	11489.0
2020-12-22 20:00:00	NQ	Futures	14649.98	14684.71	14639.56	14658.66	11741.0
2020-12-22 21:00:00	NQ	Futures	14658.95	14671.97	14644.48	14667.05	7692.0
2020-12-22 22:00:00	NQ	Futures	14665.61	14699.76	14660.11	14695.13	3959.0
2020-12-22 23:00:00	NQ	Futures	14695.42	14709.02	14691.66	14694.84	2796.0
2020-12-22 00:00:00	YM	Futures	33265.9	33296.9	33191.6	33229.3	3814.0
2020-12-22 01:00:00	YM	Futures	33228.2	33243.7	33189.3	33199.3	2516.0
2020-12-22 02:00:00	YM	Futures	33199.3	33328.0	33191.6	33278.1	4287.0
2020-12-22 03:00:00	YM	Futures	33278.1	33403.4	33243.7	33380.1	6029.0

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

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