PREVIEW / futures_1hour / 2016-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-17.parquet
  size:    53 KB
  rows:    1,613

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
2016-05-17 00:00:00	ES	Futures	2227.33	2228.14	2227.06	2227.87	2098.0
2016-05-17 01:00:00	ES	Futures	2227.6	2229.76	2227.06	2229.49	4073.0
2016-05-17 02:00:00	ES	Futures	2229.49	2231.92	2229.22	2231.38	12999.0
2016-05-17 03:00:00	ES	Futures	2231.38	2234.89	2229.22	2232.73	34459.0
2016-05-17 04:00:00	ES	Futures	2232.73	2233.27	2229.76	2230.03	15881.0
2016-05-17 05:00:00	ES	Futures	2230.3	2230.3	2225.72	2229.22	19184.0
2016-05-17 06:00:00	ES	Futures	2229.22	2230.84	2226.25	2226.52	17354.0
2016-05-17 07:00:00	ES	Futures	2226.52	2227.6	2224.64	2227.06	25369.0
2016-05-17 08:00:00	ES	Futures	2227.06	2227.06	2221.13	2222.75	50850.0
2016-05-17 09:00:00	ES	Futures	2222.75	2227.6	2217.62	2221.4	274761.0
2016-05-17 10:00:00	ES	Futures	2221.67	2224.64	2216.27	2224.1	285386.0
2016-05-17 11:00:00	ES	Futures	2223.83	2225.18	2219.24	2223.83	152610.0
2016-05-17 12:00:00	ES	Futures	2224.1	2224.1	2215.19	2216.54	117345.0
2016-05-17 13:00:00	ES	Futures	2216.27	2219.24	2210.87	2210.87	117521.0
2016-05-17 14:00:00	ES	Futures	2210.87	2211.68	2200.88	2206.28	303482.0
2016-05-17 15:00:00	ES	Futures	2206.28	2209.25	2199.53	2206.82	408758.0
2016-05-17 16:00:00	ES	Futures	2207.09	2208.71	2205.74	2207.9	101585.0
2016-05-17 18:00:00	ES	Futures	2207.09	2208.98	2205.74	2207.9	4855.0
2016-05-17 19:00:00	ES	Futures	2207.9	2208.71	2206.82	2207.63	3294.0
2016-05-17 20:00:00	ES	Futures	2207.63	2209.52	2204.39	2207.09	11349.0
2016-05-17 21:00:00	ES	Futures	2207.09	2209.25	2205.2	2208.98	9467.0
2016-05-17 22:00:00	ES	Futures	2208.98	2210.33	2207.9	2208.44	6204.0
2016-05-17 23:00:00	ES	Futures	2208.17	2208.71	2204.93	2206.28	5956.0
2016-05-17 00:00:00	NQ	Futures	5209.45	5212.42	5209.15	5210.34	473.0
2016-05-17 01:00:00	NQ	Futures	5210.64	5215.1	5208.85	5214.51	458.0
2016-05-17 02:00:00	NQ	Futures	5214.8	5220.75	5213.32	5219.86	1498.0
2016-05-17 03:00:00	NQ	Futures	5219.56	5229.08	5213.32	5224.92	4767.0
2016-05-17 04:00:00	NQ	Futures	5225.51	5226.7	5215.7	5218.67	2282.0
2016-05-17 05:00:00	NQ	Futures	5218.97	5218.97	5207.07	5216.89	2016.0
2016-05-17 06:00:00	NQ	Futures	5216.59	5221.35	5208.85	5210.64	2248.0
2016-05-17 07:00:00	NQ	Futures	5210.64	5213.02	5204.09	5210.04	3063.0
2016-05-17 08:00:00	NQ	Futures	5210.04	5210.04	5196.65	5199.63	4284.0
2016-05-17 09:00:00	NQ	Futures	5199.63	5218.37	5185.94	5196.06	37366.0
2016-05-17 10:00:00	NQ	Futures	5196.06	5196.06	5171.36	5188.92	39413.0
2016-05-17 11:00:00	NQ	Futures	5188.62	5197.55	5180.59	5192.79	21104.0
2016-05-17 12:00:00	NQ	Futures	5193.08	5195.17	5172.55	5176.72	16865.0
2016-05-17 13:00:00	NQ	Futures	5176.72	5182.67	5160.36	5160.65	16154.0
2016-05-17 14:00:00	NQ	Futures	5160.65	5162.44	5135.07	5144.59	45666.0
2016-05-17 15:00:00	NQ	Futures	5144.59	5150.83	5127.03	5141.31	41107.0
2016-05-17 16:00:00	NQ	Futures	5141.61	5143.99	5137.15	5143.4	7645.0
2016-05-17 18:00:00	NQ	Futures	5142.5	5146.07	5138.64	5143.1	697.0
2016-05-17 19:00:00	NQ	Futures	5143.69	5145.48	5141.91	5142.8	503.0
2016-05-17 20:00:00	NQ	Futures	5143.4	5149.94	5137.45	5143.69	1637.0
2016-05-17 21:00:00	NQ	Futures	5144.29	5150.83	5140.12	5148.45	1795.0
2016-05-17 22:00:00	NQ	Futures	5149.05	5152.32	5144.88	5144.88	1028.0
2016-05-17 23:00:00	NQ	Futures	5145.18	5146.97	5139.53	5141.31	671.0
2016-05-17 00:00:00	YM	Futures	18907.4	18915.9	18905.2	18909.5	507.0
2016-05-17 01:00:00	YM	Futures	18910.6	18925.6	18904.2	18925.6	587.0
2016-05-17 02:00:00	YM	Futures	18926.6	18947.0	18921.3	18944.8	2253.0
2016-05-17 03:00:00	YM	Futures	18943.8	18967.3	18923.4	18952.3	4508.0

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

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