PREVIEW / futures_1hour / 2015-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-28.parquet
  size:    52 KB
  rows:    1,591

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-10-28 00:00:00	ES	Futures	2207.24	2208.85	2206.97	2208.04	2253.0
2015-10-28 01:00:00	ES	Futures	2208.04	2208.31	2207.24	2208.04	2140.0
2015-10-28 02:00:00	ES	Futures	2208.04	2209.38	2207.24	2207.77	2012.0
2015-10-28 03:00:00	ES	Futures	2208.04	2209.11	2206.97	2206.97	5792.0
2015-10-28 04:00:00	ES	Futures	2206.97	2210.18	2205.9	2209.38	21195.0
2015-10-28 05:00:00	ES	Futures	2209.38	2211.79	2208.58	2210.99	11825.0
2015-10-28 06:00:00	ES	Futures	2210.99	2211.25	2209.11	2209.38	8095.0
2015-10-28 07:00:00	ES	Futures	2209.65	2210.72	2208.85	2209.11	11941.0
2015-10-28 08:00:00	ES	Futures	2209.38	2210.45	2207.24	2207.51	21244.0
2015-10-28 09:00:00	ES	Futures	2207.77	2212.59	2205.1	2212.32	203739.0
2015-10-28 10:00:00	ES	Futures	2212.59	2219.82	2211.52	2219.28	247482.0
2015-10-28 11:00:00	ES	Futures	2219.28	2221.69	2216.87	2221.15	175206.0
2015-10-28 12:00:00	ES	Futures	2221.15	2221.96	2217.14	2218.21	97895.0
2015-10-28 13:00:00	ES	Futures	2218.21	2225.17	2217.41	2223.83	96941.0
2015-10-28 14:00:00	ES	Futures	2223.56	2224.36	2200.02	2213.66	514724.0
2015-10-28 15:00:00	ES	Futures	2213.39	2229.98	2211.79	2229.98	347560.0
2015-10-28 16:00:00	ES	Futures	2229.72	2231.86	2227.31	2227.84	85864.0
2015-10-28 17:00:00	ES	Futures	2227.84	2227.84	2227.84	2227.84	22.0
2015-10-28 18:00:00	ES	Futures	2227.31	2227.84	2226.51	2226.77	4810.0
2015-10-28 19:00:00	ES	Futures	2226.77	2227.31	2226.24	2227.31	3871.0
2015-10-28 20:00:00	ES	Futures	2227.31	2228.38	2226.51	2226.77	5704.0
2015-10-28 21:00:00	ES	Futures	2226.77	2228.11	2225.97	2226.51	6353.0
2015-10-28 22:00:00	ES	Futures	2226.51	2227.31	2225.17	2225.43	6081.0
2015-10-28 23:00:00	ES	Futures	2225.43	2226.24	2224.1	2224.1	4870.0
2015-10-28 00:00:00	NQ	Futures	5499.02	5501.09	5498.13	5498.72	316.0
2015-10-28 01:00:00	NQ	Futures	5498.72	5500.2	5496.94	5498.72	251.0
2015-10-28 02:00:00	NQ	Futures	5499.02	5504.06	5498.72	5501.39	630.0
2015-10-28 03:00:00	NQ	Futures	5501.39	5504.06	5499.02	5499.32	1278.0
2015-10-28 04:00:00	NQ	Futures	5499.02	5511.18	5497.24	5508.51	3319.0
2015-10-28 05:00:00	NQ	Futures	5508.51	5514.44	5506.43	5512.66	1693.0
2015-10-28 06:00:00	NQ	Futures	5512.06	5513.25	5508.8	5509.4	1492.0
2015-10-28 07:00:00	NQ	Futures	5509.69	5512.95	5506.73	5507.91	2417.0
2015-10-28 08:00:00	NQ	Futures	5507.62	5509.1	5498.72	5499.61	4204.0
2015-10-28 09:00:00	NQ	Futures	5499.61	5504.95	5480.93	5496.65	36242.0
2015-10-28 10:00:00	NQ	Futures	5496.35	5500.8	5475.3	5500.5	38984.0
2015-10-28 11:00:00	NQ	Futures	5500.2	5510.88	5496.94	5510.29	24079.0
2015-10-28 12:00:00	NQ	Futures	5510.29	5515.92	5503.76	5506.13	15513.0
2015-10-28 13:00:00	NQ	Futures	5506.13	5520.66	5502.87	5518.29	12756.0
2015-10-28 14:00:00	NQ	Futures	5517.99	5519.18	5456.03	5489.53	87146.0
2015-10-28 15:00:00	NQ	Futures	5489.53	5538.45	5484.79	5537.27	55745.0
2015-10-28 16:00:00	NQ	Futures	5537.86	5548.24	5534.6	5535.49	9304.0
2015-10-28 18:00:00	NQ	Futures	5531.63	5534.0	5529.56	5531.63	756.0
2015-10-28 19:00:00	NQ	Futures	5531.63	5533.71	5530.45	5532.82	377.0
2015-10-28 20:00:00	NQ	Futures	5533.71	5536.67	5532.52	5534.3	1012.0
2015-10-28 21:00:00	NQ	Futures	5534.3	5535.78	5528.08	5529.85	1044.0
2015-10-28 22:00:00	NQ	Futures	5529.85	5531.63	5523.03	5523.92	1184.0
2015-10-28 23:00:00	NQ	Futures	5523.33	5525.11	5519.48	5519.48	1045.0
2015-10-28 00:00:00	YM	Futures	18552.8	18564.5	18551.8	18559.2	219.0
2015-10-28 01:00:00	YM	Futures	18557.1	18562.4	18552.8	18558.1	241.0
2015-10-28 02:00:00	YM	Futures	18559.2	18567.7	18553.9	18557.1	360.0

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

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