PREVIEW / futures_1hour / 2015-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-01.parquet
  size:    51 KB
  rows:    1,596

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-12-01 00:00:00	ES	Futures	2238.81	2239.35	2238.01	2238.55	5228.0
2015-12-01 01:00:00	ES	Futures	2238.55	2239.62	2237.48	2237.74	4659.0
2015-12-01 02:00:00	ES	Futures	2237.74	2238.55	2236.41	2236.94	7934.0
2015-12-01 03:00:00	ES	Futures	2236.94	2237.74	2233.19	2234.0	21330.0
2015-12-01 04:00:00	ES	Futures	2234.26	2234.53	2231.86	2232.93	12502.0
2015-12-01 05:00:00	ES	Futures	2233.19	2234.26	2229.98	2234.26	12117.0
2015-12-01 06:00:00	ES	Futures	2234.26	2236.94	2233.73	2234.53	12623.0
2015-12-01 07:00:00	ES	Futures	2234.26	2236.14	2233.19	2235.34	15492.0
2015-12-01 08:00:00	ES	Futures	2235.07	2236.14	2232.39	2233.46	20189.0
2015-12-01 09:00:00	ES	Futures	2233.19	2244.7	2232.93	2243.09	197178.0
2015-12-01 10:00:00	ES	Futures	2242.83	2243.36	2230.79	2239.35	299673.0
2015-12-01 11:00:00	ES	Futures	2239.08	2240.15	2234.53	2237.48	179479.0
2015-12-01 12:00:00	ES	Futures	2237.21	2241.76	2236.94	2241.22	130767.0
2015-12-01 13:00:00	ES	Futures	2240.95	2241.22	2235.07	2236.67	100626.0
2015-12-01 14:00:00	ES	Futures	2236.67	2242.56	2236.41	2240.69	93301.0
2015-12-01 15:00:00	ES	Futures	2240.95	2249.25	2240.69	2248.45	218038.0
2015-12-01 16:00:00	ES	Futures	2248.18	2248.71	2246.84	2246.84	69572.0
2015-12-01 18:00:00	ES	Futures	2247.11	2247.64	2245.5	2245.5	4499.0
2015-12-01 19:00:00	ES	Futures	2245.5	2247.11	2245.5	2246.84	2848.0
2015-12-01 20:00:00	ES	Futures	2246.84	2247.38	2246.04	2247.11	3221.0
2015-12-01 21:00:00	ES	Futures	2246.84	2248.45	2246.31	2246.57	4359.0
2015-12-01 22:00:00	ES	Futures	2246.57	2247.91	2246.31	2247.11	2172.0
2015-12-01 23:00:00	ES	Futures	2247.11	2248.71	2247.11	2248.18	1784.0
2015-12-01 00:00:00	NQ	Futures	5566.62	5568.4	5566.03	5567.21	432.0
2015-12-01 01:00:00	NQ	Futures	5566.62	5568.99	5564.54	5566.03	422.0
2015-12-01 02:00:00	NQ	Futures	5566.03	5568.1	5563.36	5563.95	882.0
2015-12-01 03:00:00	NQ	Futures	5564.25	5566.32	5556.24	5559.8	2513.0
2015-12-01 04:00:00	NQ	Futures	5559.8	5560.69	5551.5	5553.57	2056.0
2015-12-01 05:00:00	NQ	Futures	5553.87	5558.91	5546.16	5558.32	1714.0
2015-12-01 06:00:00	NQ	Futures	5558.32	5565.43	5557.43	5559.21	2142.0
2015-12-01 07:00:00	NQ	Futures	5558.91	5561.28	5554.17	5559.8	1803.0
2015-12-01 08:00:00	NQ	Futures	5559.8	5560.39	5555.35	5557.72	3705.0
2015-12-01 09:00:00	NQ	Futures	5557.72	5585.3	5552.09	5585.3	31626.0
2015-12-01 10:00:00	NQ	Futures	5584.11	5585.0	5553.28	5576.11	47638.0
2015-12-01 11:00:00	NQ	Futures	5576.4	5579.66	5562.76	5570.77	29103.0
2015-12-01 12:00:00	NQ	Futures	5570.47	5581.44	5570.18	5579.07	24340.0
2015-12-01 13:00:00	NQ	Futures	5578.78	5579.66	5559.21	5564.25	21253.0
2015-12-01 14:00:00	NQ	Futures	5564.25	5579.07	5563.06	5575.81	13206.0
2015-12-01 15:00:00	NQ	Futures	5575.81	5593.6	5575.22	5591.82	29185.0
2015-12-01 16:00:00	NQ	Futures	5591.82	5593.9	5590.34	5592.12	6134.0
2015-12-01 18:00:00	NQ	Futures	5591.82	5593.01	5588.56	5588.86	746.0
2015-12-01 19:00:00	NQ	Futures	5589.15	5592.71	5589.15	5591.82	557.0
2015-12-01 20:00:00	NQ	Futures	5592.12	5595.08	5591.23	5594.19	622.0
2015-12-01 21:00:00	NQ	Futures	5593.9	5597.16	5592.41	5592.71	820.0
2015-12-01 22:00:00	NQ	Futures	5593.01	5595.68	5592.41	5593.9	257.0
2015-12-01 23:00:00	NQ	Futures	5593.9	5597.16	5593.9	5596.56	294.0
2015-12-01 00:00:00	YM	Futures	18869.5	18874.8	18866.4	18870.6	489.0
2015-12-01 01:00:00	YM	Futures	18872.7	18874.8	18858.9	18861.1	348.0
2015-12-01 02:00:00	YM	Futures	18861.1	18866.4	18856.8	18858.9	938.0
2015-12-01 03:00:00	YM	Futures	18858.9	18867.4	18832.5	18836.7	2879.0

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

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