PREVIEW / futures_1hour / 2020-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-14.parquet
  size:    60 KB
  rows:    1,878

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-14 00:00:00	ES	Futures	4123.83	4124.11	4117.66	4118.22	5990.0
2020-12-14 01:00:00	ES	Futures	4118.22	4122.99	4117.1	4120.18	4092.0
2020-12-14 02:00:00	ES	Futures	4120.46	4128.6	4119.9	4125.23	10475.0
2020-12-14 03:00:00	ES	Futures	4124.95	4127.76	4120.18	4123.83	13914.0
2020-12-14 04:00:00	ES	Futures	4123.55	4127.76	4122.99	4126.08	6961.0
2020-12-14 05:00:00	ES	Futures	4126.08	4129.73	4124.67	4127.76	10049.0
2020-12-14 06:00:00	ES	Futures	4127.76	4135.34	4126.64	4134.5	14211.0
2020-12-14 07:00:00	ES	Futures	4134.5	4136.74	4131.97	4136.46	12427.0
2020-12-14 08:00:00	ES	Futures	4136.46	4137.02	4128.6	4131.69	25728.0
2020-12-14 09:00:00	ES	Futures	4131.97	4141.51	4127.2	4140.11	132522.0
2020-12-14 10:00:00	ES	Futures	4140.39	4144.32	4123.55	4123.83	207259.0
2020-12-14 11:00:00	ES	Futures	4123.83	4128.88	4113.17	4120.46	195543.0
2020-12-14 12:00:00	ES	Futures	4120.74	4121.87	4107.55	4110.64	110784.0
2020-12-14 13:00:00	ES	Futures	4110.64	4114.29	4103.9	4110.36	126267.0
2020-12-14 14:00:00	ES	Futures	4110.36	4112.89	4097.17	4108.11	132517.0
2020-12-14 15:00:00	ES	Futures	4108.11	4108.96	4083.7	4085.1	263865.0
2020-12-14 16:00:00	ES	Futures	4085.1	4092.68	4084.54	4091.55	53109.0
2020-12-14 18:00:00	ES	Futures	4094.36	4097.73	4089.03	4094.36	9392.0
2020-12-14 19:00:00	ES	Futures	4094.36	4097.73	4091.84	4096.61	10902.0
2020-12-14 20:00:00	ES	Futures	4096.89	4098.85	4088.75	4091.84	9545.0
2020-12-14 21:00:00	ES	Futures	4091.84	4093.24	4084.26	4091.84	8118.0
2020-12-14 22:00:00	ES	Futures	4091.55	4092.68	4086.78	4089.31	4185.0
2020-12-14 23:00:00	ES	Futures	4089.31	4090.99	4085.94	4086.5	4001.0
2020-12-14 00:00:00	NQ	Futures	14379.94	14381.09	14342.02	14346.07	1382.0
2020-12-14 01:00:00	NQ	Futures	14346.07	14364.02	14344.05	14358.52	952.0
2020-12-14 02:00:00	NQ	Futures	14359.1	14397.88	14359.1	14389.78	2766.0
2020-12-14 03:00:00	NQ	Futures	14389.49	14390.07	14356.49	14370.67	2823.0
2020-12-14 04:00:00	NQ	Futures	14370.39	14380.8	14363.73	14380.23	1673.0
2020-12-14 05:00:00	NQ	Futures	14380.23	14387.17	14370.39	14379.94	1542.0
2020-12-14 06:00:00	NQ	Futures	14380.52	14417.85	14378.78	14409.17	3058.0
2020-12-14 07:00:00	NQ	Futures	14409.46	14417.27	14403.67	14415.54	3421.0
2020-12-14 08:00:00	NQ	Futures	14416.12	14417.85	14362.86	14386.88	9483.0
2020-12-14 09:00:00	NQ	Futures	14386.59	14495.42	14380.52	14494.26	49441.0
2020-12-14 10:00:00	NQ	Futures	14494.26	14524.36	14476.9	14478.92	55233.0
2020-12-14 11:00:00	NQ	Futures	14478.34	14528.99	14469.66	14515.1	43354.0
2020-12-14 12:00:00	NQ	Futures	14515.1	14519.15	14456.06	14471.11	30332.0
2020-12-14 13:00:00	NQ	Futures	14471.11	14496.0	14434.06	14491.66	33688.0
2020-12-14 14:00:00	NQ	Futures	14491.37	14501.79	14452.01	14493.1	31076.0
2020-12-14 15:00:00	NQ	Futures	14493.1	14503.52	14415.25	14423.93	52772.0
2020-12-14 16:00:00	NQ	Futures	14423.64	14453.45	14419.3	14439.27	8034.0
2020-12-14 18:00:00	NQ	Futures	14439.85	14457.22	14429.72	14448.82	2028.0
2020-12-14 19:00:00	NQ	Futures	14449.98	14458.37	14438.98	14449.4	1567.0
2020-12-14 20:00:00	NQ	Futures	14450.56	14456.06	14423.64	14437.24	1865.0
2020-12-14 21:00:00	NQ	Futures	14436.09	14443.32	14382.54	14421.9	3264.0
2020-12-14 22:00:00	NQ	Futures	14419.88	14426.54	14407.43	14416.69	1348.0
2020-12-14 23:00:00	NQ	Futures	14416.69	14426.82	14403.96	14405.12	1341.0
2020-12-14 00:00:00	YM	Futures	33410.1	33413.4	33365.7	33380.1	1024.0
2020-12-14 01:00:00	YM	Futures	33381.2	33422.3	33369.0	33401.2	897.0
2020-12-14 02:00:00	YM	Futures	33401.2	33467.7	33386.8	33425.6	2247.0
2020-12-14 03:00:00	YM	Futures	33422.3	33468.9	33405.6	33426.7	3089.0

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

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