PREVIEW / futures_1hour / 2015-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-21.parquet
  size:    51 KB
  rows:    1,554

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-07-21 00:00:00	ES	Futures	2259.65	2260.71	2259.38	2260.45	873.0
2015-07-21 01:00:00	ES	Futures	2260.71	2262.58	2260.45	2262.05	3080.0
2015-07-21 02:00:00	ES	Futures	2262.05	2262.31	2260.71	2261.51	3741.0
2015-07-21 03:00:00	ES	Futures	2261.51	2263.11	2259.38	2260.45	13852.0
2015-07-21 04:00:00	ES	Futures	2260.18	2260.98	2258.32	2258.85	7508.0
2015-07-21 05:00:00	ES	Futures	2258.85	2259.92	2258.32	2259.12	4388.0
2015-07-21 06:00:00	ES	Futures	2259.12	2260.71	2259.12	2259.92	4021.0
2015-07-21 07:00:00	ES	Futures	2260.18	2260.71	2258.58	2258.85	9766.0
2015-07-21 08:00:00	ES	Futures	2258.85	2259.65	2256.45	2256.45	14072.0
2015-07-21 09:00:00	ES	Futures	2256.45	2259.12	2255.12	2259.12	131642.0
2015-07-21 10:00:00	ES	Futures	2259.12	2259.65	2250.86	2252.46	186370.0
2015-07-21 11:00:00	ES	Futures	2252.46	2253.26	2248.47	2250.06	182810.0
2015-07-21 12:00:00	ES	Futures	2250.33	2251.93	2247.67	2249.27	105986.0
2015-07-21 13:00:00	ES	Futures	2249.0	2249.27	2246.07	2247.4	92105.0
2015-07-21 14:00:00	ES	Futures	2247.4	2250.6	2245.01	2247.4	148388.0
2015-07-21 15:00:00	ES	Futures	2247.14	2251.4	2245.8	2249.0	190064.0
2015-07-21 16:00:00	ES	Futures	2248.73	2252.99	2243.94	2245.27	88735.0
2015-07-21 17:00:00	ES	Futures	2245.27	2245.54	2243.67	2243.94	2766.0
2015-07-21 18:00:00	ES	Futures	2244.74	2246.07	2243.67	2243.67	9468.0
2015-07-21 19:00:00	ES	Futures	2243.67	2244.47	2243.67	2244.21	2109.0
2015-07-21 20:00:00	ES	Futures	2244.21	2244.47	2243.67	2244.21	2858.0
2015-07-21 21:00:00	ES	Futures	2244.21	2244.21	2242.34	2243.14	5252.0
2015-07-21 22:00:00	ES	Futures	2243.14	2243.67	2242.34	2242.88	2564.0
2015-07-21 23:00:00	ES	Futures	2242.88	2243.67	2242.61	2243.67	1534.0
2015-07-21 00:00:00	NQ	Futures	5530.37	5534.22	5529.78	5534.22	369.0
2015-07-21 01:00:00	NQ	Futures	5534.52	5540.14	5533.63	5538.36	812.0
2015-07-21 02:00:00	NQ	Futures	5537.47	5537.77	5533.04	5537.77	829.0
2015-07-21 03:00:00	NQ	Futures	5537.47	5540.73	5532.15	5534.22	1698.0
2015-07-21 04:00:00	NQ	Futures	5533.63	5535.7	5529.19	5530.08	1254.0
2015-07-21 05:00:00	NQ	Futures	5529.78	5533.04	5528.3	5531.56	997.0
2015-07-21 06:00:00	NQ	Futures	5531.56	5535.7	5531.56	5534.22	687.0
2015-07-21 07:00:00	NQ	Futures	5534.52	5536.59	5532.45	5532.74	2896.0
2015-07-21 08:00:00	NQ	Futures	5533.04	5534.81	5526.23	5526.83	3051.0
2015-07-21 09:00:00	NQ	Futures	5526.53	5532.74	5513.81	5532.45	29946.0
2015-07-21 10:00:00	NQ	Futures	5532.74	5535.4	5506.12	5513.51	37694.0
2015-07-21 11:00:00	NQ	Futures	5513.22	5522.98	5507.01	5520.61	24200.0
2015-07-21 12:00:00	NQ	Futures	5520.61	5530.08	5515.88	5519.73	15675.0
2015-07-21 13:00:00	NQ	Futures	5519.73	5522.39	5510.26	5520.02	15045.0
2015-07-21 14:00:00	NQ	Futures	5520.02	5525.94	5509.67	5520.91	24359.0
2015-07-21 15:00:00	NQ	Futures	5520.91	5528.6	5515.88	5520.32	29373.0
2015-07-21 16:00:00	NQ	Futures	5520.02	5529.19	5459.68	5467.08	25968.0
2015-07-21 17:00:00	NQ	Futures	5466.78	5466.78	5456.13	5461.46	1668.0
2015-07-21 18:00:00	NQ	Futures	5463.82	5469.15	5459.98	5460.27	2540.0
2015-07-21 19:00:00	NQ	Futures	5460.27	5462.05	5459.09	5460.27	721.0
2015-07-21 20:00:00	NQ	Futures	5460.57	5461.46	5459.98	5460.86	521.0
2015-07-21 21:00:00	NQ	Futures	5461.16	5461.75	5454.95	5455.84	1054.0
2015-07-21 22:00:00	NQ	Futures	5455.84	5457.91	5454.65	5454.95	470.0
2015-07-21 23:00:00	NQ	Futures	5454.95	5456.43	5454.65	5456.43	367.0
2015-07-21 00:00:00	YM	Futures	18952.8	18961.2	18952.8	18960.2	121.0
2015-07-21 01:00:00	YM	Futures	18960.2	18974.9	18960.2	18969.7	486.0

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

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