PREVIEW / futures_1hour / 2015-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-06.parquet
  size:    43 KB
  rows:    1,267

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-03-06 00:00:00	ES	Futures	2209.42	2209.69	2208.63	2208.63	2165.0
2015-03-06 01:00:00	ES	Futures	2208.63	2209.69	2208.11	2209.69	1790.0
2015-03-06 02:00:00	ES	Futures	2209.69	2210.21	2208.11	2209.16	4392.0
2015-03-06 03:00:00	ES	Futures	2209.16	2210.74	2208.63	2209.95	8207.0
2015-03-06 04:00:00	ES	Futures	2209.95	2210.74	2208.37	2209.42	8601.0
2015-03-06 05:00:00	ES	Futures	2209.42	2210.21	2208.9	2209.42	6858.0
2015-03-06 06:00:00	ES	Futures	2209.42	2209.95	2208.11	2208.63	5375.0
2015-03-06 07:00:00	ES	Futures	2208.63	2213.63	2208.37	2213.11	12135.0
2015-03-06 08:00:00	ES	Futures	2212.84	2214.16	2201.79	2202.84	123367.0
2015-03-06 09:00:00	ES	Futures	2202.84	2204.95	2195.74	2203.11	267646.0
2015-03-06 10:00:00	ES	Futures	2203.37	2204.42	2197.05	2198.11	200950.0
2015-03-06 11:00:00	ES	Futures	2198.11	2198.37	2185.48	2188.37	329298.0
2015-03-06 12:00:00	ES	Futures	2188.63	2190.21	2182.06	2184.69	185476.0
2015-03-06 13:00:00	ES	Futures	2184.42	2186.0	2179.16	2183.11	152851.0
2015-03-06 14:00:00	ES	Futures	2182.84	2186.0	2176.0	2177.32	163130.0
2015-03-06 15:00:00	ES	Futures	2177.06	2182.84	2174.16	2178.11	303932.0
2015-03-06 16:00:00	ES	Futures	2178.11	2180.74	2177.06	2180.48	92938.0
2015-03-06 17:00:00	ES	Futures	2180.48	2181.79	2180.48	2181.27	2236.0
2015-03-06 00:00:00	NQ	Futures	5227.65	5228.24	5226.19	5226.77	393.0
2015-03-06 01:00:00	NQ	Futures	5226.77	5228.83	5224.13	5228.83	359.0
2015-03-06 02:00:00	NQ	Futures	5228.83	5230.59	5226.19	5228.53	801.0
2015-03-06 03:00:00	NQ	Futures	5228.53	5232.06	5227.07	5229.71	1598.0
2015-03-06 04:00:00	NQ	Futures	5229.71	5231.77	5225.6	5228.53	1559.0
2015-03-06 05:00:00	NQ	Futures	5228.83	5230.88	5227.36	5228.53	1122.0
2015-03-06 06:00:00	NQ	Futures	5228.24	5230.3	5226.48	5228.24	968.0
2015-03-06 07:00:00	NQ	Futures	5227.95	5238.52	5227.95	5237.93	1536.0
2015-03-06 08:00:00	NQ	Futures	5237.93	5239.99	5218.55	5220.6	14953.0
2015-03-06 09:00:00	NQ	Futures	5220.6	5232.06	5208.86	5225.89	44489.0
2015-03-06 10:00:00	NQ	Futures	5225.89	5232.35	5215.61	5219.72	33438.0
2015-03-06 11:00:00	NQ	Futures	5219.72	5219.72	5178.61	5186.83	52393.0
2015-03-06 12:00:00	NQ	Futures	5186.83	5194.76	5172.44	5178.61	33566.0
2015-03-06 13:00:00	NQ	Futures	5178.31	5182.43	5168.33	5176.26	25173.0
2015-03-06 14:00:00	NQ	Futures	5176.26	5184.48	5162.75	5163.63	22779.0
2015-03-06 15:00:00	NQ	Futures	5163.34	5175.38	5156.29	5167.45	47203.0
2015-03-06 16:00:00	NQ	Futures	5167.74	5178.9	5166.27	5178.02	12169.0
2015-03-06 17:00:00	NQ	Futures	5178.61	5181.84	5178.31	5181.25	490.0
2015-03-06 00:00:00	YM	Futures	18905.7	18906.7	18902.5	18902.5	193.0
2015-03-06 01:00:00	YM	Futures	18902.5	18909.8	18896.3	18908.8	242.0
2015-03-06 02:00:00	YM	Futures	18909.8	18916.1	18899.4	18907.7	689.0
2015-03-06 03:00:00	YM	Futures	18908.8	18922.4	18905.7	18917.1	1692.0
2015-03-06 04:00:00	YM	Futures	18917.1	18921.3	18903.6	18913.0	1209.0
2015-03-06 05:00:00	YM	Futures	18911.9	18915.1	18902.5	18904.6	928.0
2015-03-06 06:00:00	YM	Futures	18905.7	18908.8	18896.3	18899.4	930.0
2015-03-06 07:00:00	YM	Futures	18897.3	18935.9	18897.3	18934.9	1802.0
2015-03-06 08:00:00	YM	Futures	18933.8	18951.6	18852.4	18862.9	16165.0
2015-03-06 09:00:00	YM	Futures	18861.8	18875.4	18771.0	18850.3	31724.0
2015-03-06 10:00:00	YM	Futures	18850.3	18856.6	18784.6	18791.9	17746.0
2015-03-06 11:00:00	YM	Futures	18792.9	18794.0	18699.0	18718.8	26175.0
2015-03-06 12:00:00	YM	Futures	18718.8	18732.4	18654.1	18668.7	18616.0
2015-03-06 13:00:00	YM	Futures	18668.7	18680.2	18624.9	18663.5	17068.0

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

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