PREVIEW / futures_1hour / 2015-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-01.parquet
  size:    38 KB
  rows:    1,068

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-05-01 00:00:00	ES	Futures	2200.89	2201.16	2200.1	2200.63	1599.0
2015-05-01 01:00:00	ES	Futures	2200.63	2202.21	2199.84	2202.21	2888.0
2015-05-01 02:00:00	ES	Futures	2202.21	2204.86	2201.95	2203.8	8162.0
2015-05-01 03:00:00	ES	Futures	2204.06	2204.33	2201.16	2201.95	4989.0
2015-05-01 04:00:00	ES	Futures	2201.95	2202.48	2201.69	2201.69	1847.0
2015-05-01 05:00:00	ES	Futures	2201.69	2203.01	2201.69	2202.48	2703.0
2015-05-01 06:00:00	ES	Futures	2202.74	2203.53	2201.95	2202.48	3236.0
2015-05-01 07:00:00	ES	Futures	2202.48	2205.91	2201.95	2203.8	10736.0
2015-05-01 08:00:00	ES	Futures	2204.06	2204.59	2203.01	2204.33	17978.0
2015-05-01 09:00:00	ES	Futures	2204.33	2211.72	2204.06	2207.76	170783.0
2015-05-01 10:00:00	ES	Futures	2207.76	2213.84	2205.91	2208.82	166543.0
2015-05-01 11:00:00	ES	Futures	2208.82	2214.1	2205.12	2208.55	113619.0
2015-05-01 12:00:00	ES	Futures	2208.82	2212.25	2205.91	2211.99	64942.0
2015-05-01 13:00:00	ES	Futures	2212.25	2218.33	2210.4	2217.0	88231.0
2015-05-01 14:00:00	ES	Futures	2217.0	2220.7	2216.21	2217.53	78998.0
2015-05-01 15:00:00	ES	Futures	2217.8	2221.23	2215.16	2220.17	171884.0
2015-05-01 16:00:00	ES	Futures	2219.91	2220.7	2218.59	2220.44	87186.0
2015-05-01 17:00:00	ES	Futures	2220.17	2221.23	2220.17	2220.97	1459.0
2015-05-01 00:00:00	NQ	Futures	5190.52	5191.1	5189.05	5189.63	225.0
2015-05-01 01:00:00	NQ	Futures	5189.63	5191.69	5187.28	5191.4	733.0
2015-05-01 02:00:00	NQ	Futures	5191.4	5196.69	5190.81	5196.1	972.0
2015-05-01 03:00:00	NQ	Futures	5196.1	5196.69	5186.99	5189.93	998.0
2015-05-01 04:00:00	NQ	Futures	5189.63	5191.69	5189.05	5190.52	384.0
2015-05-01 05:00:00	NQ	Futures	5190.52	5194.63	5190.52	5194.04	643.0
2015-05-01 06:00:00	NQ	Futures	5193.75	5197.28	5193.46	5194.93	691.0
2015-05-01 07:00:00	NQ	Futures	5195.22	5203.75	5193.75	5199.93	2452.0
2015-05-01 08:00:00	NQ	Futures	5199.93	5201.4	5193.16	5197.57	4186.0
2015-05-01 09:00:00	NQ	Futures	5197.57	5229.92	5196.98	5216.39	42226.0
2015-05-01 10:00:00	NQ	Futures	5216.1	5237.57	5214.04	5222.86	37242.0
2015-05-01 11:00:00	NQ	Futures	5222.57	5234.62	5211.1	5219.04	24923.0
2015-05-01 12:00:00	NQ	Futures	5219.33	5231.68	5212.86	5231.39	13084.0
2015-05-01 13:00:00	NQ	Futures	5231.39	5246.39	5224.92	5243.15	16094.0
2015-05-01 14:00:00	NQ	Futures	5242.56	5256.09	5242.27	5248.45	13992.0
2015-05-01 15:00:00	NQ	Futures	5248.45	5258.74	5242.56	5256.97	26022.0
2015-05-01 16:00:00	NQ	Futures	5256.97	5257.27	5252.86	5256.09	8338.0
2015-05-01 17:00:00	NQ	Futures	5255.8	5257.56	5255.5	5256.39	269.0
2015-05-01 00:00:00	YM	Futures	18656.8	18658.9	18651.6	18654.7	393.0
2015-05-01 01:00:00	YM	Futures	18655.8	18665.2	18649.5	18665.2	734.0
2015-05-01 02:00:00	YM	Futures	18665.2	18695.6	18665.2	18694.6	1677.0
2015-05-01 03:00:00	YM	Futures	18696.7	18696.7	18674.7	18679.9	1212.0
2015-05-01 04:00:00	YM	Futures	18678.8	18684.1	18674.7	18679.9	582.0
2015-05-01 05:00:00	YM	Futures	18678.8	18690.4	18677.8	18688.3	491.0
2015-05-01 06:00:00	YM	Futures	18689.3	18699.8	18686.2	18692.5	1592.0
2015-05-01 07:00:00	YM	Futures	18692.5	18728.1	18689.3	18709.3	2497.0
2015-05-01 08:00:00	YM	Futures	18708.2	18719.7	18706.1	18716.6	2843.0
2015-05-01 09:00:00	YM	Futures	18717.6	18780.6	18716.6	18729.2	19793.0
2015-05-01 10:00:00	YM	Futures	18726.0	18796.3	18722.9	18744.9	19191.0
2015-05-01 11:00:00	YM	Futures	18744.9	18791.1	18715.6	18742.8	12731.0
2015-05-01 12:00:00	YM	Futures	18742.8	18764.8	18716.6	18762.7	7068.0
2015-05-01 13:00:00	YM	Futures	18763.8	18805.7	18746.0	18795.3	9954.0

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

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