PREVIEW / futures_1hour / 2015-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-19.parquet
  size:    52 KB
  rows:    1,561

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-19 00:00:00	ES	Futures	2213.57	2214.36	2213.31	2214.1	2570.0
2015-03-19 01:00:00	ES	Futures	2214.1	2215.16	2213.57	2214.63	3155.0
2015-03-19 02:00:00	ES	Futures	2214.89	2217.0	2214.36	2215.95	4601.0
2015-03-19 03:00:00	ES	Futures	2215.95	2216.48	2211.99	2213.04	18494.0
2015-03-19 04:00:00	ES	Futures	2213.31	2215.42	2204.33	2205.65	49031.0
2015-03-19 05:00:00	ES	Futures	2205.38	2207.76	2204.06	2206.7	20704.0
2015-03-19 06:00:00	ES	Futures	2206.44	2209.87	2206.44	2209.35	21710.0
2015-03-19 07:00:00	ES	Futures	2209.35	2209.61	2206.97	2207.76	16748.0
2015-03-19 08:00:00	ES	Futures	2207.5	2208.02	2201.95	2203.8	42088.0
2015-03-19 09:00:00	ES	Futures	2203.8	2205.12	2198.78	2203.8	165261.0
2015-03-19 10:00:00	ES	Futures	2203.8	2207.5	2198.78	2201.16	179553.0
2015-03-19 11:00:00	ES	Futures	2200.89	2202.74	2193.76	2196.93	173308.0
2015-03-19 12:00:00	ES	Futures	2196.67	2198.25	2194.03	2195.08	115003.0
2015-03-19 13:00:00	ES	Futures	2194.82	2201.69	2194.03	2197.2	82665.0
2015-03-19 14:00:00	ES	Futures	2196.93	2201.95	2196.67	2200.63	100631.0
2015-03-19 15:00:00	ES	Futures	2200.63	2202.21	2196.4	2198.52	187431.0
2015-03-19 16:00:00	ES	Futures	2198.25	2200.1	2197.46	2197.72	78114.0
2015-03-19 17:00:00	ES	Futures	2197.99	2197.99	2196.93	2197.2	1773.0
2015-03-19 18:00:00	ES	Futures	2196.93	2197.2	2195.08	2195.08	4248.0
2015-03-19 19:00:00	ES	Futures	2195.35	2198.25	2195.08	2197.72	3311.0
2015-03-19 20:00:00	ES	Futures	2197.99	2198.52	2197.2	2197.46	2446.0
2015-03-19 21:00:00	ES	Futures	2197.72	2201.69	2197.46	2200.89	6276.0
2015-03-19 22:00:00	ES	Futures	2200.89	2203.27	2200.89	2201.69	3912.0
2015-03-19 23:00:00	ES	Futures	2201.42	2202.21	2201.16	2201.42	2374.0
2015-03-19 00:00:00	NQ	Futures	5208.45	5210.22	5207.87	5209.04	234.0
2015-03-19 01:00:00	NQ	Futures	5208.75	5211.98	5208.45	5211.1	391.0
2015-03-19 02:00:00	NQ	Futures	5211.1	5216.1	5210.81	5214.63	794.0
2015-03-19 03:00:00	NQ	Futures	5214.92	5215.8	5206.69	5210.51	2893.0
2015-03-19 04:00:00	NQ	Futures	5210.81	5214.33	5191.4	5194.04	6651.0
2015-03-19 05:00:00	NQ	Futures	5193.75	5197.87	5190.81	5196.4	3226.0
2015-03-19 06:00:00	NQ	Futures	5196.1	5202.28	5195.22	5200.51	3218.0
2015-03-19 07:00:00	NQ	Futures	5200.51	5202.28	5197.28	5199.34	2609.0
2015-03-19 08:00:00	NQ	Futures	5199.04	5200.22	5190.52	5194.93	5367.0
2015-03-19 09:00:00	NQ	Futures	5194.93	5208.16	5190.81	5205.22	29688.0
2015-03-19 10:00:00	NQ	Futures	5205.22	5213.75	5197.28	5204.92	28848.0
2015-03-19 11:00:00	NQ	Futures	5205.22	5209.04	5195.22	5203.45	23747.0
2015-03-19 12:00:00	NQ	Futures	5203.45	5206.1	5191.4	5192.28	18388.0
2015-03-19 13:00:00	NQ	Futures	5192.28	5209.34	5189.05	5198.75	17318.0
2015-03-19 14:00:00	NQ	Futures	5199.04	5209.04	5197.57	5207.57	16058.0
2015-03-19 15:00:00	NQ	Futures	5207.87	5209.92	5197.28	5199.04	35480.0
2015-03-19 16:00:00	NQ	Futures	5199.04	5204.92	5198.75	5199.93	6749.0
2015-03-19 17:00:00	NQ	Futures	5199.93	5199.93	5197.87	5199.04	243.0
2015-03-19 18:00:00	NQ	Futures	5197.57	5198.75	5194.04	5194.93	638.0
2015-03-19 19:00:00	NQ	Futures	5195.22	5200.22	5194.93	5199.93	684.0
2015-03-19 20:00:00	NQ	Futures	5199.63	5200.51	5198.46	5199.34	354.0
2015-03-19 21:00:00	NQ	Futures	5199.04	5208.16	5198.75	5207.28	1004.0
2015-03-19 22:00:00	NQ	Futures	5207.28	5212.86	5206.98	5209.63	1078.0
2015-03-19 23:00:00	NQ	Futures	5209.63	5211.1	5207.57	5209.63	530.0
2015-03-19 00:00:00	YM	Futures	18891.7	18897.0	18889.6	18894.9	180.0
2015-03-19 01:00:00	YM	Futures	18892.8	18902.2	18889.6	18894.9	376.0

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

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