PREVIEW / futures_1hour / 2014-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-13.parquet
  size:    48 KB
  rows:    1,554

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
2014-05-13 00:00:00	ES	Futures	1967.53	1968.83	1967.27	1968.31	2544.0
2014-05-13 01:00:00	ES	Futures	1968.57	1968.57	1967.27	1967.53	3407.0
2014-05-13 02:00:00	ES	Futures	1967.27	1968.57	1966.75	1968.57	9723.0
2014-05-13 03:00:00	ES	Futures	1968.57	1969.09	1967.01	1969.09	16854.0
2014-05-13 04:00:00	ES	Futures	1969.09	1969.87	1968.31	1969.87	14037.0
2014-05-13 05:00:00	ES	Futures	1969.87	1969.87	1967.01	1967.27	16407.0
2014-05-13 06:00:00	ES	Futures	1967.01	1969.87	1967.01	1968.57	20185.0
2014-05-13 07:00:00	ES	Futures	1968.57	1970.13	1968.31	1969.35	18437.0
2014-05-13 08:00:00	ES	Futures	1969.09	1969.87	1965.97	1967.27	51152.0
2014-05-13 09:00:00	ES	Futures	1967.27	1970.64	1965.97	1967.53	204039.0
2014-05-13 10:00:00	ES	Futures	1967.53	1971.94	1967.27	1969.61	176612.0
2014-05-13 11:00:00	ES	Futures	1969.61	1970.38	1965.45	1966.49	152314.0
2014-05-13 12:00:00	ES	Futures	1966.49	1968.83	1965.71	1967.53	78705.0
2014-05-13 13:00:00	ES	Futures	1967.79	1968.31	1965.71	1967.01	58361.0
2014-05-13 14:00:00	ES	Futures	1967.01	1968.57	1966.49	1967.79	45543.0
2014-05-13 15:00:00	ES	Futures	1968.05	1968.31	1965.19	1967.01	124201.0
2014-05-13 16:00:00	ES	Futures	1967.01	1968.31	1967.01	1968.05	58432.0
2014-05-13 17:00:00	ES	Futures	1968.05	1968.31	1967.53	1968.31	2356.0
2014-05-13 18:00:00	ES	Futures	1968.05	1968.05	1967.01	1967.27	2681.0
2014-05-13 19:00:00	ES	Futures	1967.27	1968.05	1967.01	1967.27	1886.0
2014-05-13 20:00:00	ES	Futures	1967.27	1967.79	1967.01	1967.53	2056.0
2014-05-13 21:00:00	ES	Futures	1967.27	1968.57	1967.01	1968.05	3697.0
2014-05-13 22:00:00	ES	Futures	1968.05	1969.09	1967.79	1968.83	2112.0
2014-05-13 23:00:00	ES	Futures	1968.83	1970.13	1968.83	1969.87	3757.0
2014-05-13 00:00:00	NQ	Futures	4208.16	4212.53	4207.29	4212.24	589.0
2014-05-13 01:00:00	NQ	Futures	4212.24	4212.24	4207.58	4207.87	778.0
2014-05-13 02:00:00	NQ	Futures	4208.16	4210.2	4207.0	4209.91	1236.0
2014-05-13 03:00:00	NQ	Futures	4210.2	4211.07	4207.0	4211.07	2490.0
2014-05-13 04:00:00	NQ	Futures	4211.07	4212.53	4209.04	4212.53	2345.0
2014-05-13 05:00:00	NQ	Futures	4212.24	4212.24	4204.96	4205.54	3327.0
2014-05-13 06:00:00	NQ	Futures	4205.25	4212.24	4204.67	4209.62	3634.0
2014-05-13 07:00:00	NQ	Futures	4209.62	4214.28	4209.62	4213.4	3396.0
2014-05-13 08:00:00	NQ	Futures	4213.4	4213.99	4204.67	4207.0	7728.0
2014-05-13 09:00:00	NQ	Futures	4206.71	4217.77	4198.55	4204.96	44802.0
2014-05-13 10:00:00	NQ	Futures	4204.96	4221.85	4203.79	4215.44	43503.0
2014-05-13 11:00:00	NQ	Futures	4215.44	4216.9	4197.68	4203.79	35387.0
2014-05-13 12:00:00	NQ	Futures	4203.5	4209.62	4199.72	4206.71	18047.0
2014-05-13 13:00:00	NQ	Futures	4206.71	4210.49	4200.88	4204.67	14368.0
2014-05-13 14:00:00	NQ	Futures	4204.67	4212.82	4202.92	4210.49	11242.0
2014-05-13 15:00:00	NQ	Futures	4210.49	4211.07	4200.59	4205.83	21305.0
2014-05-13 16:00:00	NQ	Futures	4205.83	4206.41	4203.5	4205.25	3611.0
2014-05-13 17:00:00	NQ	Futures	4205.25	4205.54	4204.08	4205.54	133.0
2014-05-13 18:00:00	NQ	Futures	4205.83	4205.83	4202.05	4202.63	466.0
2014-05-13 19:00:00	NQ	Futures	4202.63	4204.08	4202.63	4202.63	282.0
2014-05-13 20:00:00	NQ	Futures	4202.63	4203.79	4202.34	4203.5	321.0
2014-05-13 21:00:00	NQ	Futures	4203.21	4205.25	4202.63	4204.67	302.0
2014-05-13 22:00:00	NQ	Futures	4204.38	4207.0	4203.21	4207.0	288.0
2014-05-13 23:00:00	NQ	Futures	4207.0	4209.62	4206.71	4209.04	478.0
2014-05-13 00:00:00	YM	Futures	17166.7	17179.1	17164.7	17176.0	844.0
2014-05-13 01:00:00	YM	Futures	17176.0	17177.0	17167.8	17169.8	576.0

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

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