PREVIEW / futures_1hour / 2015-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-09.parquet
  size:    51 KB
  rows:    1,555

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-09 00:00:00	ES	Futures	2197.46	2197.99	2196.67	2197.99	1313.0
2015-06-09 01:00:00	ES	Futures	2197.99	2197.99	2195.61	2196.4	3013.0
2015-06-09 02:00:00	ES	Futures	2196.4	2197.99	2195.35	2197.46	11357.0
2015-06-09 03:00:00	ES	Futures	2197.46	2199.57	2195.08	2197.72	23451.0
2015-06-09 04:00:00	ES	Futures	2197.46	2198.78	2193.76	2194.55	19161.0
2015-06-09 05:00:00	ES	Futures	2194.55	2194.55	2185.57	2186.63	47973.0
2015-06-09 06:00:00	ES	Futures	2186.63	2193.5	2185.57	2192.71	40193.0
2015-06-09 07:00:00	ES	Futures	2192.97	2194.29	2191.12	2193.23	38108.0
2015-06-09 08:00:00	ES	Futures	2193.5	2194.55	2191.12	2193.76	44819.0
2015-06-09 09:00:00	ES	Futures	2193.76	2199.57	2189.8	2190.33	216621.0
2015-06-09 10:00:00	ES	Futures	2190.59	2197.2	2187.69	2196.67	267405.0
2015-06-09 11:00:00	ES	Futures	2196.67	2200.37	2195.08	2198.25	134707.0
2015-06-09 12:00:00	ES	Futures	2197.99	2200.1	2196.14	2199.84	71356.0
2015-06-09 13:00:00	ES	Futures	2199.84	2202.48	2197.46	2197.99	81395.0
2015-06-09 14:00:00	ES	Futures	2197.99	2201.69	2197.46	2198.52	72785.0
2015-06-09 15:00:00	ES	Futures	2198.52	2199.31	2193.5	2195.35	189517.0
2015-06-09 16:00:00	ES	Futures	2195.08	2199.31	2193.76	2198.52	66166.0
2015-06-09 17:00:00	ES	Futures	2198.25	2198.52	2197.46	2197.72	906.0
2015-06-09 18:00:00	ES	Futures	2198.25	2198.78	2197.72	2198.52	2817.0
2015-06-09 19:00:00	ES	Futures	2198.78	2199.31	2198.25	2199.31	1318.0
2015-06-09 20:00:00	ES	Futures	2199.31	2201.16	2198.25	2200.63	5854.0
2015-06-09 21:00:00	ES	Futures	2200.63	2201.42	2199.84	2201.16	2445.0
2015-06-09 22:00:00	ES	Futures	2200.89	2201.16	2200.37	2200.63	2023.0
2015-06-09 23:00:00	ES	Futures	2200.89	2202.48	2200.63	2201.69	2722.0
2015-06-09 00:00:00	NQ	Futures	5218.16	5219.33	5216.98	5219.04	406.0
2015-06-09 01:00:00	NQ	Futures	5219.33	5219.33	5213.75	5215.8	685.0
2015-06-09 02:00:00	NQ	Futures	5216.1	5218.75	5213.45	5216.98	948.0
2015-06-09 03:00:00	NQ	Futures	5216.98	5221.39	5211.1	5216.39	3505.0
2015-06-09 04:00:00	NQ	Futures	5215.8	5218.75	5203.16	5204.04	3440.0
2015-06-09 05:00:00	NQ	Futures	5204.04	5204.04	5179.93	5183.75	7813.0
2015-06-09 06:00:00	NQ	Futures	5183.16	5201.1	5182.28	5199.63	5529.0
2015-06-09 07:00:00	NQ	Futures	5199.63	5203.16	5195.81	5198.75	12039.0
2015-06-09 08:00:00	NQ	Futures	5199.34	5200.81	5192.57	5198.16	17058.0
2015-06-09 09:00:00	NQ	Futures	5198.16	5209.04	5176.11	5179.64	41531.0
2015-06-09 10:00:00	NQ	Futures	5179.34	5195.22	5164.05	5193.46	43251.0
2015-06-09 11:00:00	NQ	Futures	5193.46	5207.87	5191.1	5200.51	21089.0
2015-06-09 12:00:00	NQ	Futures	5200.51	5211.98	5191.99	5211.69	10980.0
2015-06-09 13:00:00	NQ	Futures	5211.39	5220.22	5207.87	5209.63	12904.0
2015-06-09 14:00:00	NQ	Futures	5209.92	5221.98	5208.16	5213.75	11389.0
2015-06-09 15:00:00	NQ	Futures	5213.16	5214.63	5198.75	5204.04	19455.0
2015-06-09 16:00:00	NQ	Futures	5204.04	5215.8	5201.1	5213.16	5909.0
2015-06-09 17:00:00	NQ	Futures	5212.86	5213.16	5210.81	5210.81	136.0
2015-06-09 18:00:00	NQ	Futures	5212.57	5214.92	5211.39	5213.16	580.0
2015-06-09 19:00:00	NQ	Futures	5213.45	5214.63	5211.98	5214.33	109.0
2015-06-09 20:00:00	NQ	Futures	5214.63	5218.75	5213.16	5217.57	398.0
2015-06-09 21:00:00	NQ	Futures	5217.86	5219.92	5216.39	5219.33	333.0
2015-06-09 22:00:00	NQ	Futures	5219.33	5219.63	5217.57	5218.16	144.0
2015-06-09 23:00:00	NQ	Futures	5218.16	5221.39	5218.16	5220.51	318.0
2015-06-09 00:00:00	YM	Futures	18641.1	18649.5	18640.0	18649.5	383.0
2015-06-09 01:00:00	YM	Futures	18649.5	18649.5	18631.7	18639.0	657.0

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

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