PREVIEW / futures_1hour / 2015-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-15.parquet
  size:    49 KB
  rows:    1,504

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-06-15 00:00:00	ES	Futures	2210.13	2210.93	2210.13	2210.66	451.0
2015-06-15 01:00:00	ES	Futures	2210.93	2213.59	2210.66	2213.06	2868.0
2015-06-15 02:00:00	ES	Futures	2213.06	2215.19	2210.13	2214.39	15268.0
2015-06-15 03:00:00	ES	Futures	2214.39	2216.78	2212.26	2212.26	17934.0
2015-06-15 04:00:00	ES	Futures	2212.26	2213.85	2211.72	2212.52	8215.0
2015-06-15 05:00:00	ES	Futures	2212.52	2214.12	2211.19	2211.19	9138.0
2015-06-15 06:00:00	ES	Futures	2211.46	2214.92	2210.13	2212.79	10601.0
2015-06-15 07:00:00	ES	Futures	2213.06	2213.32	2208.53	2209.86	21838.0
2015-06-15 08:00:00	ES	Futures	2209.86	2210.93	2206.4	2206.67	36381.0
2015-06-15 09:00:00	ES	Futures	2206.93	2208.0	2196.81	2200.28	265755.0
2015-06-15 10:00:00	ES	Futures	2200.54	2205.33	2199.21	2205.33	205764.0
2015-06-15 11:00:00	ES	Futures	2205.33	2213.59	2205.07	2209.86	184158.0
2015-06-15 12:00:00	ES	Futures	2209.86	2213.32	2208.8	2212.52	70099.0
2015-06-15 13:00:00	ES	Futures	2212.52	2214.65	2207.2	2209.59	107498.0
2015-06-15 14:00:00	ES	Futures	2209.59	2213.32	2208.0	2208.8	72674.0
2015-06-15 15:00:00	ES	Futures	2209.06	2212.79	2207.2	2210.66	154271.0
2015-06-15 16:00:00	ES	Futures	2210.66	2211.19	2208.53	2210.39	73427.0
2015-06-15 17:00:00	ES	Futures	2210.39	2210.39	2209.59	2209.59	1222.0
2015-06-15 18:00:00	ES	Futures	2210.13	2210.66	2207.73	2208.26	2874.0
2015-06-15 19:00:00	ES	Futures	2208.53	2208.8	2208.0	2208.26	1115.0
2015-06-15 20:00:00	ES	Futures	2208.53	2209.33	2207.46	2207.73	2660.0
2015-06-15 21:00:00	ES	Futures	2207.73	2209.06	2207.2	2208.0	2850.0
2015-06-15 22:00:00	ES	Futures	2208.0	2208.0	2206.4	2206.67	4878.0
2015-06-15 23:00:00	ES	Futures	2206.67	2207.73	2206.13	2207.2	1591.0
2015-06-15 00:00:00	NQ	Futures	5235.18	5237.54	5235.18	5236.95	94.0
2015-06-15 01:00:00	NQ	Futures	5237.25	5244.64	5236.95	5242.87	438.0
2015-06-15 02:00:00	NQ	Futures	5243.46	5247.01	5236.66	5246.42	1538.0
2015-06-15 03:00:00	NQ	Futures	5246.12	5249.97	5239.61	5240.5	2581.0
2015-06-15 04:00:00	NQ	Futures	5240.21	5243.46	5237.54	5239.61	1379.0
2015-06-15 05:00:00	NQ	Futures	5239.61	5245.23	5236.06	5236.95	1607.0
2015-06-15 06:00:00	NQ	Futures	5237.25	5245.83	5234.29	5241.68	1886.0
2015-06-15 07:00:00	NQ	Futures	5241.98	5242.57	5231.04	5236.06	3218.0
2015-06-15 08:00:00	NQ	Futures	5236.06	5236.36	5226.89	5228.08	4638.0
2015-06-15 09:00:00	NQ	Futures	5228.37	5230.15	5189.92	5197.91	40663.0
2015-06-15 10:00:00	NQ	Futures	5197.91	5213.29	5195.54	5210.33	28304.0
2015-06-15 11:00:00	NQ	Futures	5210.33	5231.63	5210.33	5224.82	27972.0
2015-06-15 12:00:00	NQ	Futures	5224.82	5233.99	5222.75	5232.22	11433.0
2015-06-15 13:00:00	NQ	Futures	5232.51	5242.57	5224.53	5231.33	18000.0
2015-06-15 14:00:00	NQ	Futures	5231.33	5242.57	5230.15	5232.81	11298.0
2015-06-15 15:00:00	NQ	Futures	5232.81	5241.39	5226.6	5235.47	19373.0
2015-06-15 16:00:00	NQ	Futures	5235.18	5240.8	5233.4	5237.84	6866.0
2015-06-15 17:00:00	NQ	Futures	5237.84	5238.43	5236.06	5236.06	125.0
2015-06-15 18:00:00	NQ	Futures	5238.73	5239.91	5232.22	5233.4	586.0
2015-06-15 19:00:00	NQ	Futures	5233.7	5234.88	5233.7	5234.29	126.0
2015-06-15 20:00:00	NQ	Futures	5234.59	5236.66	5231.33	5232.22	370.0
2015-06-15 21:00:00	NQ	Futures	5232.51	5234.29	5230.15	5231.63	376.0
2015-06-15 22:00:00	NQ	Futures	5231.92	5232.51	5226.89	5227.19	552.0
2015-06-15 23:00:00	NQ	Futures	5227.19	5229.85	5226.3	5228.97	275.0
2015-06-15 00:00:00	YM	Futures	18687.3	18691.5	18687.3	18691.5	71.0
2015-06-15 01:00:00	YM	Futures	18692.6	18715.8	18691.5	18712.6	653.0

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

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