PREVIEW / futures_1hour / 2015-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-27.parquet
  size:    50 KB
  rows:    1,549

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-27 00:00:00	ES	Futures	2203.23	2203.49	2201.35	2202.42	3042.0
2015-10-27 01:00:00	ES	Futures	2202.42	2204.56	2202.16	2203.49	4172.0
2015-10-27 02:00:00	ES	Futures	2203.49	2206.97	2203.49	2205.63	4312.0
2015-10-27 03:00:00	ES	Futures	2205.9	2206.97	2204.56	2205.63	6078.0
2015-10-27 04:00:00	ES	Futures	2205.9	2206.44	2201.89	2204.83	15490.0
2015-10-27 05:00:00	ES	Futures	2204.56	2206.97	2203.76	2206.44	12239.0
2015-10-27 06:00:00	ES	Futures	2206.44	2206.7	2204.3	2205.37	7769.0
2015-10-27 07:00:00	ES	Futures	2205.63	2206.17	2204.03	2205.37	11816.0
2015-10-27 08:00:00	ES	Futures	2205.37	2205.9	2200.82	2202.16	31588.0
2015-10-27 09:00:00	ES	Futures	2202.42	2205.9	2198.94	2205.1	161254.0
2015-10-27 10:00:00	ES	Futures	2204.83	2205.37	2198.14	2204.3	184431.0
2015-10-27 11:00:00	ES	Futures	2204.03	2208.85	2199.21	2200.55	181897.0
2015-10-27 12:00:00	ES	Futures	2200.28	2202.16	2198.41	2199.21	117396.0
2015-10-27 13:00:00	ES	Futures	2199.48	2199.48	2195.47	2197.87	119601.0
2015-10-27 14:00:00	ES	Futures	2197.61	2201.62	2197.34	2198.68	106257.0
2015-10-27 15:00:00	ES	Futures	2198.68	2204.3	2198.41	2204.3	173147.0
2015-10-27 16:00:00	ES	Futures	2204.3	2209.92	2202.16	2208.85	73727.0
2015-10-27 18:00:00	ES	Futures	2206.97	2207.24	2205.1	2205.37	4747.0
2015-10-27 19:00:00	ES	Futures	2205.1	2206.17	2204.3	2205.63	2837.0
2015-10-27 20:00:00	ES	Futures	2205.37	2207.24	2205.1	2206.17	4986.0
2015-10-27 21:00:00	ES	Futures	2206.17	2210.72	2205.1	2209.92	8720.0
2015-10-27 22:00:00	ES	Futures	2210.18	2210.45	2207.51	2207.77	6651.0
2015-10-27 23:00:00	ES	Futures	2207.77	2208.04	2206.44	2207.51	4047.0
2015-10-27 00:00:00	NQ	Futures	5461.07	5462.55	5456.92	5459.59	580.0
2015-10-27 01:00:00	NQ	Futures	5459.88	5466.7	5459.88	5464.92	999.0
2015-10-27 02:00:00	NQ	Futures	5464.33	5472.63	5464.33	5469.07	844.0
2015-10-27 03:00:00	NQ	Futures	5469.37	5471.74	5465.81	5467.59	1468.0
2015-10-27 04:00:00	NQ	Futures	5467.89	5469.37	5458.99	5464.33	2462.0
2015-10-27 05:00:00	NQ	Futures	5464.63	5470.26	5462.55	5469.67	1657.0
2015-10-27 06:00:00	NQ	Futures	5469.67	5472.33	5464.92	5468.18	1790.0
2015-10-27 07:00:00	NQ	Futures	5468.18	5476.49	5464.03	5475.89	2676.0
2015-10-27 08:00:00	NQ	Futures	5475.3	5476.49	5465.81	5469.96	4674.0
2015-10-27 09:00:00	NQ	Futures	5470.26	5489.83	5463.74	5485.08	29964.0
2015-10-27 10:00:00	NQ	Futures	5484.79	5485.68	5467.29	5484.19	31653.0
2015-10-27 11:00:00	NQ	Futures	5484.19	5499.91	5481.53	5484.19	30047.0
2015-10-27 12:00:00	NQ	Futures	5484.79	5487.16	5474.71	5479.45	17157.0
2015-10-27 13:00:00	NQ	Futures	5479.45	5483.3	5470.56	5478.86	15538.0
2015-10-27 14:00:00	NQ	Futures	5478.86	5489.23	5478.26	5480.04	18152.0
2015-10-27 15:00:00	NQ	Futures	5480.34	5494.28	5479.45	5492.79	28196.0
2015-10-27 16:00:00	NQ	Futures	5492.79	5516.81	5471.74	5504.65	17423.0
2015-10-27 18:00:00	NQ	Futures	5497.24	5497.24	5485.97	5490.42	3032.0
2015-10-27 19:00:00	NQ	Futures	5489.83	5492.2	5487.75	5492.2	644.0
2015-10-27 20:00:00	NQ	Futures	5492.2	5498.13	5491.61	5494.87	831.0
2015-10-27 21:00:00	NQ	Futures	5494.57	5505.25	5493.09	5505.25	1340.0
2015-10-27 22:00:00	NQ	Futures	5504.95	5505.84	5499.91	5500.2	938.0
2015-10-27 23:00:00	NQ	Futures	5500.2	5501.69	5497.24	5499.32	338.0
2015-10-27 00:00:00	YM	Futures	18536.9	18539.1	18521.0	18527.4	577.0
2015-10-27 01:00:00	YM	Futures	18528.5	18547.5	18528.5	18538.0	807.0
2015-10-27 02:00:00	YM	Futures	18538.0	18567.7	18538.0	18558.1	692.0
2015-10-27 03:00:00	YM	Futures	18558.1	18566.6	18546.5	18554.9	750.0

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

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