PREVIEW / futures_1hour / 2019-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-07.parquet
  size:    56 KB
  rows:    1,753

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
2019-03-07 00:00:00	ES	Futures	3005.63	3005.63	3004.0	3004.27	5338.0
2019-03-07 01:00:00	ES	Futures	3004.54	3005.35	3004.0	3004.27	4585.0
2019-03-07 02:00:00	ES	Futures	3004.27	3004.81	2999.92	3002.1	15869.0
2019-03-07 03:00:00	ES	Futures	3001.82	3003.73	3001.01	3003.18	20991.0
2019-03-07 04:00:00	ES	Futures	3003.18	3004.27	3002.37	3002.91	10589.0
2019-03-07 05:00:00	ES	Futures	3002.91	3004.81	3002.1	3004.54	9992.0
2019-03-07 06:00:00	ES	Futures	3004.54	3005.35	3002.1	3002.91	9125.0
2019-03-07 07:00:00	ES	Futures	3002.91	3012.69	3002.64	3012.42	25789.0
2019-03-07 08:00:00	ES	Futures	3012.42	3015.95	3007.26	3008.34	55493.0
2019-03-07 09:00:00	ES	Futures	3008.34	3011.06	2982.27	2988.24	286439.0
2019-03-07 10:00:00	ES	Futures	2988.24	2990.69	2978.47	2988.24	252382.0
2019-03-07 11:00:00	ES	Futures	2988.24	2995.03	2983.36	2990.96	171229.0
2019-03-07 12:00:00	ES	Futures	2990.69	2999.65	2986.07	2998.02	157710.0
2019-03-07 13:00:00	ES	Futures	2997.75	2998.57	2990.42	2990.96	85427.0
2019-03-07 14:00:00	ES	Futures	2991.23	2993.13	2977.11	2979.01	130039.0
2019-03-07 15:00:00	ES	Futures	2979.01	2987.43	2974.94	2986.34	226919.0
2019-03-07 16:00:00	ES	Futures	2986.34	2988.79	2986.07	2986.89	48233.0
2019-03-07 18:00:00	ES	Futures	2986.34	2988.79	2985.26	2988.79	5051.0
2019-03-07 19:00:00	ES	Futures	2988.52	2989.06	2982.27	2982.27	8575.0
2019-03-07 20:00:00	ES	Futures	2982.27	2985.53	2980.1	2985.26	9996.0
2019-03-07 21:00:00	ES	Futures	2985.26	2987.97	2983.08	2985.8	7467.0
2019-03-07 22:00:00	ES	Futures	2985.8	2986.62	2982.27	2982.81	7545.0
2019-03-07 23:00:00	ES	Futures	2982.81	2983.08	2979.01	2980.64	5477.0
2019-03-07 00:00:00	NQ	Futures	8297.59	8297.59	8292.04	8293.21	2086.0
2019-03-07 01:00:00	NQ	Futures	8293.21	8296.13	8290.29	8293.21	2036.0
2019-03-07 02:00:00	NQ	Futures	8293.5	8294.38	8277.72	8283.57	4451.0
2019-03-07 03:00:00	NQ	Futures	8283.86	8286.78	8278.6	8285.61	4359.0
2019-03-07 04:00:00	NQ	Futures	8285.91	8290.87	8282.98	8287.07	2739.0
2019-03-07 05:00:00	NQ	Futures	8286.78	8293.79	8286.2	8293.5	2300.0
2019-03-07 06:00:00	NQ	Futures	8293.79	8295.84	8284.15	8286.49	2737.0
2019-03-07 07:00:00	NQ	Futures	8286.49	8312.79	8284.15	8312.49	10498.0
2019-03-07 08:00:00	NQ	Futures	8312.49	8325.35	8300.51	8304.61	16566.0
2019-03-07 09:00:00	NQ	Futures	8304.61	8314.83	8225.13	8240.32	96919.0
2019-03-07 10:00:00	NQ	Futures	8240.03	8244.41	8210.52	8237.69	93738.0
2019-03-07 11:00:00	NQ	Futures	8237.69	8267.21	8226.88	8256.1	58881.0
2019-03-07 12:00:00	NQ	Futures	8255.52	8275.68	8239.15	8271.0	54253.0
2019-03-07 13:00:00	NQ	Futures	8271.0	8274.22	8236.53	8238.86	35372.0
2019-03-07 14:00:00	NQ	Futures	8238.28	8243.83	8188.9	8195.33	52129.0
2019-03-07 15:00:00	NQ	Futures	8195.62	8220.16	8185.1	8216.95	70259.0
2019-03-07 16:00:00	NQ	Futures	8216.95	8220.16	8211.1	8212.57	10231.0
2019-03-07 18:00:00	NQ	Futures	8211.1	8221.04	8209.35	8220.45	1302.0
2019-03-07 19:00:00	NQ	Futures	8220.16	8221.04	8202.63	8202.63	2275.0
2019-03-07 20:00:00	NQ	Futures	8202.34	8210.23	8193.57	8209.06	2202.0
2019-03-07 21:00:00	NQ	Futures	8208.77	8216.66	8203.51	8210.52	1302.0
2019-03-07 22:00:00	NQ	Futures	8210.52	8212.57	8199.42	8202.63	1623.0
2019-03-07 23:00:00	NQ	Futures	8202.92	8202.92	8190.65	8192.11	1690.0
2019-03-07 00:00:00	YM	Futures	27811.5	27811.5	27794.1	27797.4	2020.0
2019-03-07 01:00:00	YM	Futures	27797.4	27805.0	27787.6	27790.8	1477.0
2019-03-07 02:00:00	YM	Futures	27790.8	27795.2	27737.6	27761.5	5355.0
2019-03-07 03:00:00	YM	Futures	27762.6	27775.6	27749.6	27770.2	3675.0

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

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