PREVIEW / futures_1hour / 2016-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-17.parquet
  size:    54 KB
  rows:    1,633

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-03-17 00:00:00	ES	Futures	2185.49	2186.03	2180.36	2180.9	6775.0
2016-03-17 01:00:00	ES	Futures	2180.9	2182.79	2180.36	2182.25	6742.0
2016-03-17 02:00:00	ES	Futures	2182.25	2184.14	2180.9	2182.25	4692.0
2016-03-17 03:00:00	ES	Futures	2182.52	2188.73	2182.52	2186.84	18347.0
2016-03-17 04:00:00	ES	Futures	2186.84	2189.27	2184.68	2186.84	36399.0
2016-03-17 05:00:00	ES	Futures	2186.84	2187.11	2174.15	2176.04	44489.0
2016-03-17 06:00:00	ES	Futures	2176.31	2176.85	2166.05	2170.91	76145.0
2016-03-17 07:00:00	ES	Futures	2170.64	2172.8	2168.75	2169.56	37736.0
2016-03-17 08:00:00	ES	Futures	2169.29	2175.23	2168.21	2173.07	71426.0
2016-03-17 09:00:00	ES	Futures	2173.07	2180.63	2172.26	2175.77	210243.0
2016-03-17 10:00:00	ES	Futures	2175.77	2184.95	2172.8	2184.68	241712.0
2016-03-17 11:00:00	ES	Futures	2184.68	2187.65	2183.06	2186.84	184501.0
2016-03-17 12:00:00	ES	Futures	2186.84	2193.32	2184.95	2191.43	182187.0
2016-03-17 13:00:00	ES	Futures	2191.7	2196.02	2188.73	2195.75	148380.0
2016-03-17 14:00:00	ES	Futures	2195.75	2199.53	2193.86	2194.13	168991.0
2016-03-17 15:00:00	ES	Futures	2194.13	2199.26	2193.05	2193.59	241260.0
2016-03-17 16:00:00	ES	Futures	2193.32	2195.75	2191.97	2193.86	88771.0
2016-03-17 18:00:00	ES	Futures	2193.59	2195.21	2193.05	2194.94	4258.0
2016-03-17 19:00:00	ES	Futures	2194.94	2196.83	2193.32	2196.02	4997.0
2016-03-17 20:00:00	ES	Futures	2195.75	2196.83	2192.24	2192.51	10415.0
2016-03-17 21:00:00	ES	Futures	2192.78	2193.86	2190.89	2191.97	8471.0
2016-03-17 22:00:00	ES	Futures	2191.97	2193.86	2191.16	2192.78	4890.0
2016-03-17 23:00:00	ES	Futures	2193.05	2194.13	2192.51	2193.32	3021.0
2016-03-17 00:00:00	NQ	Futures	5242.18	5243.07	5228.79	5230.27	954.0
2016-03-17 01:00:00	NQ	Futures	5229.68	5234.14	5227.6	5232.06	743.0
2016-03-17 02:00:00	NQ	Futures	5232.36	5236.23	5228.79	5232.06	412.0
2016-03-17 03:00:00	NQ	Futures	5232.65	5247.23	5232.36	5243.37	1869.0
2016-03-17 04:00:00	NQ	Futures	5243.37	5251.7	5238.31	5244.56	3874.0
2016-03-17 05:00:00	NQ	Futures	5244.26	5244.85	5207.36	5213.91	4902.0
2016-03-17 06:00:00	NQ	Futures	5213.61	5215.1	5188.62	5201.12	8354.0
2016-03-17 07:00:00	NQ	Futures	5200.82	5204.09	5193.08	5194.87	5738.0
2016-03-17 08:00:00	NQ	Futures	5194.87	5207.96	5191.89	5203.79	8469.0
2016-03-17 09:00:00	NQ	Futures	5204.09	5229.98	5202.01	5206.17	33864.0
2016-03-17 10:00:00	NQ	Futures	5206.47	5220.46	5196.65	5219.56	33459.0
2016-03-17 11:00:00	NQ	Futures	5219.56	5221.94	5211.83	5217.48	23896.0
2016-03-17 12:00:00	NQ	Futures	5217.48	5237.12	5212.42	5228.79	20654.0
2016-03-17 13:00:00	NQ	Futures	5229.08	5235.93	5219.27	5231.46	21769.0
2016-03-17 14:00:00	NQ	Futures	5231.17	5240.09	5217.78	5218.37	25773.0
2016-03-17 15:00:00	NQ	Futures	5218.37	5239.5	5218.37	5227.3	28206.0
2016-03-17 16:00:00	NQ	Futures	5227.3	5234.74	5227.0	5231.76	6222.0
2016-03-17 18:00:00	NQ	Futures	5231.17	5234.44	5229.38	5234.14	479.0
2016-03-17 19:00:00	NQ	Futures	5233.85	5237.71	5229.68	5234.74	787.0
2016-03-17 20:00:00	NQ	Futures	5235.33	5237.42	5225.81	5226.41	918.0
2016-03-17 21:00:00	NQ	Futures	5226.41	5231.46	5222.24	5227.0	948.0
2016-03-17 22:00:00	NQ	Futures	5226.41	5232.06	5224.03	5228.49	398.0
2016-03-17 23:00:00	NQ	Futures	5228.79	5232.95	5227.6	5230.27	308.0
2016-03-17 00:00:00	YM	Futures	18508.1	18511.3	18471.7	18474.9	1225.0
2016-03-17 01:00:00	YM	Futures	18473.9	18483.5	18467.4	18478.1	1044.0
2016-03-17 02:00:00	YM	Futures	18479.2	18492.1	18468.5	18477.1	591.0
2016-03-17 03:00:00	YM	Futures	18479.2	18519.9	18479.2	18509.2	1819.0

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

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