PREVIEW / futures_1hour / 2015-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-10.parquet
  size:    51 KB
  rows:    1,585

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-11-10 00:00:00	ES	Futures	2223.29	2223.83	2221.42	2223.03	4113.0
2015-11-10 01:00:00	ES	Futures	2223.03	2224.63	2222.22	2222.76	3758.0
2015-11-10 02:00:00	ES	Futures	2222.76	2223.83	2220.35	2222.49	11331.0
2015-11-10 03:00:00	ES	Futures	2222.76	2223.29	2218.48	2220.08	19553.0
2015-11-10 04:00:00	ES	Futures	2219.82	2221.96	2212.86	2213.93	25083.0
2015-11-10 05:00:00	ES	Futures	2213.93	2215.27	2211.52	2212.59	14169.0
2015-11-10 06:00:00	ES	Futures	2212.59	2217.94	2212.32	2216.07	14300.0
2015-11-10 07:00:00	ES	Futures	2216.07	2216.87	2210.72	2213.13	28105.0
2015-11-10 08:00:00	ES	Futures	2212.86	2216.87	2212.86	2214.2	34206.0
2015-11-10 09:00:00	ES	Futures	2213.93	2220.89	2212.32	2219.01	256086.0
2015-11-10 10:00:00	ES	Futures	2219.28	2220.08	2209.65	2215.53	210323.0
2015-11-10 11:00:00	ES	Futures	2215.8	2217.94	2212.06	2216.07	133247.0
2015-11-10 12:00:00	ES	Futures	2216.34	2219.82	2213.93	2216.07	81624.0
2015-11-10 13:00:00	ES	Futures	2216.07	2220.89	2213.66	2219.55	83503.0
2015-11-10 14:00:00	ES	Futures	2219.82	2224.9	2217.14	2222.22	101917.0
2015-11-10 15:00:00	ES	Futures	2222.22	2224.1	2219.28	2223.83	172770.0
2015-11-10 16:00:00	ES	Futures	2223.56	2225.17	2222.22	2223.29	57291.0
2015-11-10 18:00:00	ES	Futures	2222.49	2223.29	2220.89	2221.42	2979.0
2015-11-10 19:00:00	ES	Futures	2221.69	2223.29	2221.15	2222.49	2821.0
2015-11-10 20:00:00	ES	Futures	2222.49	2223.83	2221.96	2223.56	5129.0
2015-11-10 21:00:00	ES	Futures	2223.56	2225.7	2221.42	2225.43	5944.0
2015-11-10 22:00:00	ES	Futures	2225.43	2226.77	2224.36	2225.7	5288.0
2015-11-10 23:00:00	ES	Futures	2225.43	2227.31	2225.17	2226.51	1885.0
2015-11-10 00:00:00	NQ	Futures	5526.3	5526.59	5520.66	5524.52	663.0
2015-11-10 01:00:00	NQ	Futures	5524.22	5528.67	5523.63	5524.22	498.0
2015-11-10 02:00:00	NQ	Futures	5524.52	5527.19	5519.77	5525.7	1662.0
2015-11-10 03:00:00	NQ	Futures	5525.41	5528.37	5513.55	5518.88	3326.0
2015-11-10 04:00:00	NQ	Futures	5518.59	5523.03	5498.43	5501.09	3370.0
2015-11-10 05:00:00	NQ	Futures	5501.39	5505.54	5493.68	5496.65	1741.0
2015-11-10 06:00:00	NQ	Futures	5496.35	5512.95	5495.46	5508.51	2090.0
2015-11-10 07:00:00	NQ	Futures	5508.8	5509.69	5484.49	5492.5	4669.0
2015-11-10 08:00:00	NQ	Futures	5492.2	5497.54	5489.53	5493.09	6010.0
2015-11-10 09:00:00	NQ	Futures	5493.39	5497.83	5472.63	5493.09	51193.0
2015-11-10 10:00:00	NQ	Futures	5492.5	5497.54	5470.26	5490.12	40241.0
2015-11-10 11:00:00	NQ	Futures	5490.42	5498.72	5483.01	5491.01	27019.0
2015-11-10 12:00:00	NQ	Futures	5491.01	5495.46	5482.71	5485.38	14008.0
2015-11-10 13:00:00	NQ	Futures	5485.38	5496.94	5477.38	5493.39	15431.0
2015-11-10 14:00:00	NQ	Futures	5493.39	5507.32	5484.49	5501.69	18291.0
2015-11-10 15:00:00	NQ	Futures	5501.69	5504.36	5488.05	5501.39	25517.0
2015-11-10 16:00:00	NQ	Futures	5501.39	5507.62	5498.72	5504.65	7298.0
2015-11-10 18:00:00	NQ	Futures	5503.17	5504.95	5499.32	5499.91	584.0
2015-11-10 19:00:00	NQ	Futures	5499.91	5505.25	5499.91	5502.28	809.0
2015-11-10 20:00:00	NQ	Futures	5501.98	5505.25	5500.2	5503.47	1092.0
2015-11-10 21:00:00	NQ	Futures	5503.47	5508.21	5498.43	5507.91	988.0
2015-11-10 22:00:00	NQ	Futures	5507.91	5510.58	5505.84	5509.99	1032.0
2015-11-10 23:00:00	NQ	Futures	5509.69	5512.95	5509.1	5511.18	380.0
2015-11-10 00:00:00	YM	Futures	18760.4	18763.6	18747.7	18757.3	702.0
2015-11-10 01:00:00	YM	Futures	18757.3	18768.9	18752.0	18752.0	540.0
2015-11-10 02:00:00	YM	Futures	18754.1	18762.6	18740.3	18756.2	1810.0
2015-11-10 03:00:00	YM	Futures	18755.1	18762.6	18719.1	18731.8	2612.0

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

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