PREVIEW / futures_1hour / 2015-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-23.parquet
  size:    51 KB
  rows:    1,561

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-04-23 00:00:00	ES	Futures	2217.27	2217.8	2217.0	2217.0	1223.0
2015-04-23 01:00:00	ES	Futures	2217.27	2218.33	2215.68	2217.8	3550.0
2015-04-23 02:00:00	ES	Futures	2217.8	2219.12	2213.57	2214.63	8499.0
2015-04-23 03:00:00	ES	Futures	2214.89	2217.53	2208.55	2208.82	41099.0
2015-04-23 04:00:00	ES	Futures	2209.08	2211.99	2205.38	2211.72	26455.0
2015-04-23 05:00:00	ES	Futures	2211.46	2216.48	2210.4	2214.89	20513.0
2015-04-23 06:00:00	ES	Futures	2215.16	2215.42	2211.19	2213.04	11889.0
2015-04-23 07:00:00	ES	Futures	2213.04	2214.36	2210.14	2212.51	17708.0
2015-04-23 08:00:00	ES	Futures	2212.25	2215.42	2211.46	2213.04	18406.0
2015-04-23 09:00:00	ES	Futures	2213.04	2219.91	2212.51	2219.12	149381.0
2015-04-23 10:00:00	ES	Futures	2219.12	2222.29	2214.63	2216.21	207067.0
2015-04-23 11:00:00	ES	Futures	2216.21	2228.1	2216.21	2226.25	191354.0
2015-04-23 12:00:00	ES	Futures	2226.25	2232.06	2224.66	2231.53	160238.0
2015-04-23 13:00:00	ES	Futures	2231.53	2232.06	2228.63	2230.47	84112.0
2015-04-23 14:00:00	ES	Futures	2230.47	2231.53	2228.1	2229.68	102464.0
2015-04-23 15:00:00	ES	Futures	2229.68	2233.91	2225.46	2225.98	208692.0
2015-04-23 16:00:00	ES	Futures	2225.98	2228.36	2224.93	2226.51	88174.0
2015-04-23 17:00:00	ES	Futures	2226.25	2227.57	2226.25	2227.57	2313.0
2015-04-23 18:00:00	ES	Futures	2226.51	2227.04	2223.08	2224.4	6887.0
2015-04-23 19:00:00	ES	Futures	2224.66	2225.98	2224.14	2225.72	1689.0
2015-04-23 20:00:00	ES	Futures	2225.72	2228.36	2225.19	2226.51	5578.0
2015-04-23 21:00:00	ES	Futures	2226.25	2227.04	2225.72	2226.51	2830.0
2015-04-23 22:00:00	ES	Futures	2226.51	2227.31	2225.98	2227.31	1699.0
2015-04-23 23:00:00	ES	Futures	2227.31	2228.36	2226.25	2226.78	2739.0
2015-04-23 00:00:00	NQ	Futures	5224.63	5226.1	5223.74	5223.74	311.0
2015-04-23 01:00:00	NQ	Futures	5223.74	5226.39	5220.8	5225.51	473.0
2015-04-23 02:00:00	NQ	Futures	5225.8	5228.16	5215.51	5217.86	1607.0
2015-04-23 03:00:00	NQ	Futures	5218.75	5224.63	5205.51	5206.98	6300.0
2015-04-23 04:00:00	NQ	Futures	5207.28	5214.92	5196.69	5214.33	5071.0
2015-04-23 05:00:00	NQ	Futures	5213.75	5223.74	5210.51	5220.22	4629.0
2015-04-23 06:00:00	NQ	Futures	5219.92	5221.39	5210.81	5216.98	3431.0
2015-04-23 07:00:00	NQ	Futures	5216.69	5219.04	5209.34	5215.8	4832.0
2015-04-23 08:00:00	NQ	Futures	5215.8	5223.16	5214.33	5216.39	4641.0
2015-04-23 09:00:00	NQ	Futures	5216.39	5239.92	5216.1	5238.45	29302.0
2015-04-23 10:00:00	NQ	Futures	5238.74	5247.56	5225.8	5225.8	33836.0
2015-04-23 11:00:00	NQ	Futures	5225.8	5253.74	5225.51	5249.33	27610.0
2015-04-23 12:00:00	NQ	Futures	5249.03	5265.21	5243.74	5264.91	23287.0
2015-04-23 13:00:00	NQ	Futures	5264.91	5266.68	5259.62	5263.74	13779.0
2015-04-23 14:00:00	NQ	Futures	5263.74	5274.91	5262.86	5269.32	30714.0
2015-04-23 15:00:00	NQ	Futures	5269.03	5281.09	5256.68	5257.27	37687.0
2015-04-23 16:00:00	NQ	Futures	5256.68	5289.61	5250.8	5284.91	22163.0
2015-04-23 17:00:00	NQ	Futures	5285.5	5289.91	5285.2	5288.73	585.0
2015-04-23 18:00:00	NQ	Futures	5284.32	5286.97	5281.09	5281.38	1381.0
2015-04-23 19:00:00	NQ	Futures	5281.68	5283.44	5280.79	5282.56	509.0
2015-04-23 20:00:00	NQ	Futures	5282.56	5287.85	5281.97	5285.79	1001.0
2015-04-23 21:00:00	NQ	Futures	5285.5	5289.03	5284.91	5289.03	863.0
2015-04-23 22:00:00	NQ	Futures	5289.03	5292.85	5288.44	5292.26	919.0
2015-04-23 23:00:00	NQ	Futures	5292.56	5294.61	5290.5	5292.56	919.0
2015-04-23 00:00:00	YM	Futures	18813.1	18818.3	18811.0	18811.0	432.0
2015-04-23 01:00:00	YM	Futures	18809.9	18817.3	18798.4	18814.1	1013.0

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

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