PREVIEW / futures_1hour / 2016-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-20.parquet
  size:    43 KB
  rows:    1,320

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-05-20 00:00:00	ES	Futures	2207.09	2208.98	2206.82	2207.9	3712.0
2016-05-20 01:00:00	ES	Futures	2207.9	2209.52	2207.63	2209.25	4502.0
2016-05-20 02:00:00	ES	Futures	2209.25	2211.14	2205.2	2205.47	16307.0
2016-05-20 03:00:00	ES	Futures	2205.47	2209.79	2205.2	2207.36	30705.0
2016-05-20 04:00:00	ES	Futures	2207.36	2210.06	2207.09	2208.98	17677.0
2016-05-20 05:00:00	ES	Futures	2208.98	2208.98	2203.85	2207.09	25391.0
2016-05-20 06:00:00	ES	Futures	2207.09	2207.36	2205.2	2205.74	9454.0
2016-05-20 07:00:00	ES	Futures	2206.01	2207.9	2205.2	2207.63	16974.0
2016-05-20 08:00:00	ES	Futures	2207.63	2209.25	2205.74	2208.17	31211.0
2016-05-20 09:00:00	ES	Futures	2208.17	2216.54	2206.01	2215.19	339061.0
2016-05-20 10:00:00	ES	Futures	2215.19	2218.16	2213.03	2214.65	250755.0
2016-05-20 11:00:00	ES	Futures	2214.65	2219.78	2214.11	2216.81	158142.0
2016-05-20 12:00:00	ES	Futures	2216.54	2217.89	2215.19	2216.27	95419.0
2016-05-20 13:00:00	ES	Futures	2216.0	2217.35	2210.87	2212.49	111571.0
2016-05-20 14:00:00	ES	Futures	2212.22	2216.54	2211.68	2213.03	125554.0
2016-05-20 15:00:00	ES	Futures	2212.76	2213.3	2208.17	2212.76	214991.0
2016-05-20 16:00:00	ES	Futures	2212.76	2214.38	2212.49	2213.84	74250.0
2016-05-20 00:00:00	NQ	Futures	5156.49	5161.84	5156.49	5159.76	791.0
2016-05-20 01:00:00	NQ	Futures	5159.76	5163.33	5159.17	5163.03	612.0
2016-05-20 02:00:00	NQ	Futures	5163.03	5166.9	5153.81	5153.81	2220.0
2016-05-20 03:00:00	NQ	Futures	5153.51	5166.01	5153.21	5159.46	3883.0
2016-05-20 04:00:00	NQ	Futures	5159.46	5166.01	5159.17	5162.14	1705.0
2016-05-20 05:00:00	NQ	Futures	5161.55	5161.84	5148.16	5155.59	2865.0
2016-05-20 06:00:00	NQ	Futures	5155.89	5156.78	5151.13	5152.02	1210.0
2016-05-20 07:00:00	NQ	Futures	5152.02	5157.08	5150.24	5156.19	2883.0
2016-05-20 08:00:00	NQ	Futures	5156.19	5163.93	5153.21	5162.74	4315.0
2016-05-20 09:00:00	NQ	Futures	5162.74	5188.92	5151.43	5188.92	53926.0
2016-05-20 10:00:00	NQ	Futures	5188.62	5202.31	5185.65	5195.76	47307.0
2016-05-20 11:00:00	NQ	Futures	5195.76	5211.53	5194.87	5204.69	28765.0
2016-05-20 12:00:00	NQ	Futures	5204.98	5208.26	5199.93	5202.9	15466.0
2016-05-20 13:00:00	NQ	Futures	5202.9	5204.98	5187.43	5191.89	16495.0
2016-05-20 14:00:00	NQ	Futures	5191.89	5200.22	5189.81	5191.89	14969.0
2016-05-20 15:00:00	NQ	Futures	5191.89	5192.79	5180.59	5189.81	27730.0
2016-05-20 16:00:00	NQ	Futures	5189.51	5193.68	5187.43	5193.68	6734.0
2016-05-20 00:00:00	YM	Futures	18691.1	18709.3	18691.1	18699.7	714.0
2016-05-20 01:00:00	YM	Futures	18699.7	18713.6	18696.5	18711.5	611.0
2016-05-20 02:00:00	YM	Futures	18710.4	18722.2	18682.6	18682.6	2563.0
2016-05-20 03:00:00	YM	Futures	18682.6	18720.0	18681.5	18698.6	3955.0
2016-05-20 04:00:00	YM	Futures	18699.7	18719.0	18697.6	18708.3	2035.0
2016-05-20 05:00:00	YM	Futures	18707.2	18707.2	18666.5	18691.1	3769.0
2016-05-20 06:00:00	YM	Futures	18691.1	18695.4	18678.3	18680.4	1305.0
2016-05-20 07:00:00	YM	Futures	18681.5	18694.4	18676.2	18691.1	1752.0
2016-05-20 08:00:00	YM	Futures	18691.1	18704.0	18679.4	18696.5	2477.0
2016-05-20 09:00:00	YM	Futures	18695.4	18773.6	18668.7	18760.7	26230.0
2016-05-20 10:00:00	YM	Futures	18760.7	18780.0	18735.0	18744.7	19164.0
2016-05-20 11:00:00	YM	Futures	18744.7	18782.1	18740.4	18754.3	12270.0
2016-05-20 12:00:00	YM	Futures	18755.4	18758.6	18738.2	18746.8	7030.0
2016-05-20 13:00:00	YM	Futures	18745.7	18749.0	18695.4	18705.1	9948.0
2016-05-20 14:00:00	YM	Futures	18705.1	18735.0	18700.8	18710.4	9214.0
2016-05-20 15:00:00	YM	Futures	18711.5	18712.6	18673.0	18700.8	14100.0

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

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