PREVIEW / futures_1hour / 2015-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-17.parquet
  size:    53 KB
  rows:    1,592

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-12-17 00:00:00	ES	Futures	2210.94	2212.55	2210.13	2210.94	3265.0
2015-12-17 01:00:00	ES	Futures	2210.94	2213.09	2210.13	2212.55	2737.0
2015-12-17 02:00:00	ES	Futures	2212.82	2217.12	2211.21	2215.51	11135.0
2015-12-17 03:00:00	ES	Futures	2215.51	2221.42	2213.62	2220.88	30273.0
2015-12-17 04:00:00	ES	Futures	2220.88	2224.64	2218.73	2224.37	24278.0
2015-12-17 05:00:00	ES	Futures	2224.37	2226.52	2222.76	2225.72	25752.0
2015-12-17 06:00:00	ES	Futures	2225.72	2227.87	2223.84	2225.45	22123.0
2015-12-17 07:00:00	ES	Futures	2225.18	2227.06	2222.49	2222.76	22208.0
2015-12-17 08:00:00	ES	Futures	2223.03	2224.1	2220.07	2223.57	32481.0
2015-12-17 09:00:00	ES	Futures	2223.84	2225.45	2209.59	2214.97	216756.0
2015-12-17 10:00:00	ES	Futures	2214.97	2215.24	2196.16	2200.19	378404.0
2015-12-17 11:00:00	ES	Futures	2200.46	2202.61	2190.78	2198.04	261618.0
2015-12-17 12:00:00	ES	Futures	2197.77	2200.73	2190.25	2195.35	140146.0
2015-12-17 13:00:00	ES	Futures	2195.08	2203.95	2194.28	2202.61	128430.0
2015-12-17 14:00:00	ES	Futures	2202.61	2203.95	2193.47	2196.7	130011.0
2015-12-17 15:00:00	ES	Futures	2196.7	2199.92	2183.53	2184.07	281283.0
2015-12-17 16:00:00	ES	Futures	2184.07	2184.87	2174.12	2174.39	158147.0
2015-12-17 18:00:00	ES	Futures	2175.47	2177.08	2173.59	2175.47	9440.0
2015-12-17 19:00:00	ES	Futures	2175.47	2178.69	2166.33	2167.41	25359.0
2015-12-17 20:00:00	ES	Futures	2167.41	2173.32	2166.6	2172.24	12660.0
2015-12-17 21:00:00	ES	Futures	2172.24	2175.74	2171.98	2174.12	7035.0
2015-12-17 22:00:00	ES	Futures	2174.39	2181.38	2172.24	2174.39	19415.0
2015-12-17 23:00:00	ES	Futures	2174.66	2176.27	2164.99	2169.83	24354.0
2015-12-17 00:00:00	NQ	Futures	5517.28	5520.84	5515.2	5516.98	503.0
2015-12-17 01:00:00	NQ	Futures	5517.58	5522.03	5515.2	5521.14	275.0
2015-12-17 02:00:00	NQ	Futures	5521.74	5533.32	5516.98	5529.46	1953.0
2015-12-17 03:00:00	NQ	Futures	5529.16	5545.79	5524.7	5545.79	3981.0
2015-12-17 04:00:00	NQ	Futures	5545.79	5554.69	5539.85	5554.4	4137.0
2015-12-17 05:00:00	NQ	Futures	5554.69	5559.74	5549.65	5556.18	2731.0
2015-12-17 06:00:00	NQ	Futures	5556.77	5562.41	5552.91	5556.77	2351.0
2015-12-17 07:00:00	NQ	Futures	5557.07	5561.82	5554.4	5554.99	3301.0
2015-12-17 08:00:00	NQ	Futures	5554.99	5559.45	5549.94	5559.45	5093.0
2015-12-17 09:00:00	NQ	Futures	5559.15	5563.01	5527.08	5540.74	41912.0
2015-12-17 10:00:00	NQ	Futures	5540.44	5543.41	5489.96	5500.95	62166.0
2015-12-17 11:00:00	NQ	Futures	5501.25	5508.08	5473.04	5497.39	41350.0
2015-12-17 12:00:00	NQ	Futures	5497.09	5505.4	5476.01	5490.26	21680.0
2015-12-17 13:00:00	NQ	Futures	5489.96	5513.72	5486.7	5508.67	19110.0
2015-12-17 14:00:00	NQ	Futures	5508.97	5511.94	5480.46	5488.78	21345.0
2015-12-17 15:00:00	NQ	Futures	5488.48	5493.82	5451.96	5453.44	42218.0
2015-12-17 16:00:00	NQ	Futures	5453.44	5454.93	5421.67	5425.23	19843.0
2015-12-17 18:00:00	NQ	Futures	5427.31	5431.17	5422.86	5428.5	1260.0
2015-12-17 19:00:00	NQ	Futures	5428.8	5436.22	5400.59	5404.15	3908.0
2015-12-17 20:00:00	NQ	Futures	5405.04	5419.89	5403.56	5418.11	1992.0
2015-12-17 21:00:00	NQ	Futures	5418.4	5426.72	5417.81	5423.15	1419.0
2015-12-17 22:00:00	NQ	Futures	5423.75	5443.05	5420.48	5427.01	4366.0
2015-12-17 23:00:00	NQ	Futures	5427.31	5430.28	5405.34	5417.51	3439.0
2015-12-17 00:00:00	YM	Futures	18749.7	18759.3	18741.2	18748.7	493.0
2015-12-17 01:00:00	YM	Futures	18749.7	18763.6	18741.2	18762.5	663.0
2015-12-17 02:00:00	YM	Futures	18760.4	18796.6	18749.7	18785.9	2046.0
2015-12-17 03:00:00	YM	Futures	18783.8	18834.9	18768.9	18829.6	4233.0

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

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