PREVIEW / futures_1hour / 2016-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-01.parquet
  size:    46 KB
  rows:    1,360

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
2016-04-01 00:00:00	ES	Futures	2210.87	2211.95	2208.71	2210.33	8568.0
2016-04-01 01:00:00	ES	Futures	2210.33	2211.41	2208.98	2210.6	4961.0
2016-04-01 02:00:00	ES	Futures	2210.6	2211.41	2208.71	2210.06	14814.0
2016-04-01 03:00:00	ES	Futures	2210.06	2210.06	2205.47	2207.09	46598.0
2016-04-01 04:00:00	ES	Futures	2207.09	2213.3	2206.01	2211.14	29566.0
2016-04-01 05:00:00	ES	Futures	2211.41	2213.03	2207.09	2208.17	25070.0
2016-04-01 06:00:00	ES	Futures	2208.17	2210.06	2204.39	2206.82	31772.0
2016-04-01 07:00:00	ES	Futures	2206.82	2208.71	2204.39	2206.28	31481.0
2016-04-01 08:00:00	ES	Futures	2206.28	2209.79	2201.15	2201.96	126744.0
2016-04-01 09:00:00	ES	Futures	2201.96	2203.85	2197.91	2203.58	276030.0
2016-04-01 10:00:00	ES	Futures	2203.85	2218.43	2202.5	2218.43	371971.0
2016-04-01 11:00:00	ES	Futures	2218.43	2221.67	2216.27	2217.62	220439.0
2016-04-01 12:00:00	ES	Futures	2217.89	2219.24	2214.38	2217.62	121496.0
2016-04-01 13:00:00	ES	Futures	2217.62	2224.91	2217.08	2223.29	130234.0
2016-04-01 14:00:00	ES	Futures	2223.56	2227.6	2222.48	2225.72	141633.0
2016-04-01 15:00:00	ES	Futures	2225.98	2232.19	2225.45	2229.49	307084.0
2016-04-01 16:00:00	ES	Futures	2229.49	2230.84	2228.41	2229.76	99249.0
2016-04-01 00:00:00	NQ	Futures	5309.42	5312.1	5303.76	5307.63	1283.0
2016-04-01 01:00:00	NQ	Futures	5307.33	5310.61	5304.66	5308.52	991.0
2016-04-01 02:00:00	NQ	Futures	5308.23	5311.8	5304.06	5307.63	1355.0
2016-04-01 03:00:00	NQ	Futures	5307.63	5307.63	5293.95	5298.11	5148.0
2016-04-01 04:00:00	NQ	Futures	5298.11	5315.67	5296.62	5311.5	3585.0
2016-04-01 05:00:00	NQ	Futures	5311.8	5316.26	5301.98	5304.95	2207.0
2016-04-01 06:00:00	NQ	Futures	5304.36	5310.01	5297.22	5301.68	2832.0
2016-04-01 07:00:00	NQ	Futures	5302.28	5308.23	5299.9	5305.85	3115.0
2016-04-01 08:00:00	NQ	Futures	5305.55	5316.56	5290.97	5293.05	13611.0
2016-04-01 09:00:00	NQ	Futures	5293.05	5311.5	5285.91	5309.42	39559.0
2016-04-01 10:00:00	NQ	Futures	5310.31	5352.26	5306.74	5350.77	45808.0
2016-04-01 11:00:00	NQ	Futures	5350.77	5363.57	5347.8	5352.56	28677.0
2016-04-01 12:00:00	NQ	Futures	5352.56	5357.32	5342.44	5354.64	16134.0
2016-04-01 13:00:00	NQ	Futures	5354.64	5369.82	5353.15	5364.76	15704.0
2016-04-01 14:00:00	NQ	Futures	5365.06	5376.06	5362.08	5371.01	16402.0
2016-04-01 15:00:00	NQ	Futures	5371.3	5384.99	5369.82	5382.61	29107.0
2016-04-01 16:00:00	NQ	Futures	5382.31	5390.64	5381.72	5389.75	12015.0
2016-04-01 00:00:00	YM	Futures	18800.3	18814.2	18774.6	18797.1	5881.0
2016-04-01 01:00:00	YM	Futures	18798.2	18807.8	18786.4	18798.2	1416.0
2016-04-01 02:00:00	YM	Futures	18797.1	18808.9	18785.3	18799.3	1449.0
2016-04-01 03:00:00	YM	Futures	18799.3	18799.3	18755.4	18770.4	5269.0
2016-04-01 04:00:00	YM	Futures	18769.3	18819.6	18762.9	18804.6	3274.0
2016-04-01 05:00:00	YM	Futures	18805.7	18816.4	18774.6	18782.1	2134.0
2016-04-01 06:00:00	YM	Futures	18783.2	18796.0	18754.3	18770.4	2587.0
2016-04-01 07:00:00	YM	Futures	18771.4	18787.5	18755.4	18768.2	2417.0
2016-04-01 08:00:00	YM	Futures	18767.1	18793.9	18717.9	18725.4	12920.0
2016-04-01 09:00:00	YM	Futures	18724.3	18743.6	18697.6	18739.3	21592.0
2016-04-01 10:00:00	YM	Futures	18740.4	18883.8	18729.7	18875.3	30839.0
2016-04-01 11:00:00	YM	Futures	18875.3	18891.3	18857.1	18866.7	13789.0
2016-04-01 12:00:00	YM	Futures	18865.6	18877.4	18839.9	18859.2	7833.0
2016-04-01 13:00:00	YM	Futures	18859.2	18917.0	18853.8	18909.5	9748.0
2016-04-01 14:00:00	YM	Futures	18909.5	18937.3	18893.5	18920.2	10716.0
2016-04-01 15:00:00	YM	Futures	18921.3	18959.8	18917.0	18942.7	16452.0

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

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