PREVIEW / futures_1hour / 2015-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-09.parquet
  size:    45 KB
  rows:    1,309

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
2015-10-09 00:00:00	ES	Futures	2149.71	2151.85	2149.18	2151.05	6618.0
2015-10-09 01:00:00	ES	Futures	2150.78	2151.85	2148.91	2149.98	5899.0
2015-10-09 02:00:00	ES	Futures	2149.71	2151.85	2148.64	2149.18	11528.0
2015-10-09 03:00:00	ES	Futures	2148.91	2149.44	2139.28	2140.35	30833.0
2015-10-09 04:00:00	ES	Futures	2140.35	2144.36	2139.28	2143.82	16880.0
2015-10-09 05:00:00	ES	Futures	2143.82	2147.84	2143.29	2145.7	12413.0
2015-10-09 06:00:00	ES	Futures	2145.7	2151.05	2144.36	2149.71	18977.0
2015-10-09 07:00:00	ES	Futures	2149.71	2151.05	2147.3	2151.05	22167.0
2015-10-09 08:00:00	ES	Futures	2151.05	2155.6	2149.71	2151.85	59388.0
2015-10-09 09:00:00	ES	Futures	2152.12	2153.72	2146.5	2151.05	202208.0
2015-10-09 10:00:00	ES	Futures	2150.78	2152.92	2143.29	2152.65	242502.0
2015-10-09 11:00:00	ES	Futures	2152.39	2153.72	2145.43	2148.11	150359.0
2015-10-09 12:00:00	ES	Futures	2148.11	2149.98	2141.42	2143.29	118213.0
2015-10-09 13:00:00	ES	Futures	2143.29	2145.43	2139.28	2142.75	102173.0
2015-10-09 14:00:00	ES	Futures	2142.75	2146.5	2140.61	2146.23	98415.0
2015-10-09 15:00:00	ES	Futures	2146.23	2149.44	2143.29	2147.84	189416.0
2015-10-09 16:00:00	ES	Futures	2148.11	2149.18	2146.5	2147.57	55972.0
2015-10-09 00:00:00	NQ	Futures	5161.91	5168.14	5160.43	5165.76	1421.0
2015-10-09 01:00:00	NQ	Futures	5165.47	5168.14	5161.02	5163.98	1277.0
2015-10-09 02:00:00	NQ	Futures	5163.39	5167.25	5156.57	5157.16	2220.0
2015-10-09 03:00:00	NQ	Futures	5157.46	5158.35	5129.29	5132.26	5317.0
2015-10-09 04:00:00	NQ	Futures	5131.96	5141.45	5128.7	5140.26	2621.0
2015-10-09 05:00:00	NQ	Futures	5139.67	5150.35	5137.6	5143.53	1995.0
2015-10-09 06:00:00	NQ	Futures	5143.82	5157.76	5141.15	5152.42	2321.0
2015-10-09 07:00:00	NQ	Futures	5152.42	5155.39	5146.49	5154.79	3116.0
2015-10-09 08:00:00	NQ	Futures	5154.79	5166.36	5151.83	5158.35	9501.0
2015-10-09 09:00:00	NQ	Futures	5158.65	5166.36	5136.71	5155.68	33509.0
2015-10-09 10:00:00	NQ	Futures	5155.98	5179.7	5138.78	5178.51	42587.0
2015-10-09 11:00:00	NQ	Futures	5177.92	5181.77	5157.76	5168.73	25165.0
2015-10-09 12:00:00	NQ	Futures	5168.73	5174.36	5150.05	5157.76	17645.0
2015-10-09 13:00:00	NQ	Futures	5157.76	5164.28	5146.49	5153.9	16278.0
2015-10-09 14:00:00	NQ	Futures	5154.2	5169.02	5150.94	5167.25	12000.0
2015-10-09 15:00:00	NQ	Futures	5167.54	5174.36	5160.72	5171.4	19525.0
2015-10-09 16:00:00	NQ	Futures	5171.4	5172.29	5164.87	5166.06	4922.0
2015-10-09 00:00:00	YM	Futures	17989.3	18011.5	17987.2	18004.1	1068.0
2015-10-09 01:00:00	YM	Futures	18003.1	18008.4	17986.1	17995.7	1325.0
2015-10-09 02:00:00	YM	Futures	17994.6	18004.1	17984.0	17985.1	1221.0
2015-10-09 03:00:00	YM	Futures	17987.2	17989.3	17912.0	17920.4	4770.0
2015-10-09 04:00:00	YM	Futures	17919.4	17950.1	17914.1	17945.9	3499.0
2015-10-09 05:00:00	YM	Futures	17945.9	17981.9	17940.6	17961.8	2214.0
2015-10-09 06:00:00	YM	Futures	17961.8	18004.1	17952.2	17989.3	2360.0
2015-10-09 07:00:00	YM	Futures	17989.3	18005.2	17973.4	18001.0	3055.0
2015-10-09 08:00:00	YM	Futures	18001.0	18034.8	17993.5	18012.6	7007.0
2015-10-09 09:00:00	YM	Futures	18012.6	18024.3	17962.8	18001.0	18709.0
2015-10-09 10:00:00	YM	Futures	18002.0	18016.8	17943.8	18012.6	19942.0
2015-10-09 11:00:00	YM	Futures	18012.6	18021.1	17964.9	17986.1	11498.0
2015-10-09 12:00:00	YM	Futures	17986.1	17998.8	17944.8	17961.8	8566.0
2015-10-09 13:00:00	YM	Futures	17961.8	17974.5	17931.0	17948.0	8549.0
2015-10-09 14:00:00	YM	Futures	17948.0	17977.6	17932.1	17976.6	7164.0
2015-10-09 15:00:00	YM	Futures	17977.6	18009.4	17954.3	17998.8	10975.0

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

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