PREVIEW / futures_1hour / 2015-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-20.parquet
  size:    51 KB
  rows:    1,553

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-04-20 00:00:00	ES	Futures	2201.42	2201.95	2200.89	2200.89	2243.0
2015-04-20 01:00:00	ES	Futures	2200.89	2201.42	2199.57	2199.84	5945.0
2015-04-20 02:00:00	ES	Futures	2199.57	2201.95	2199.04	2201.69	10482.0
2015-04-20 03:00:00	ES	Futures	2201.69	2207.76	2201.42	2205.65	36192.0
2015-04-20 04:00:00	ES	Futures	2205.65	2206.7	2203.27	2204.06	19876.0
2015-04-20 05:00:00	ES	Futures	2203.8	2205.65	2203.27	2204.33	10406.0
2015-04-20 06:00:00	ES	Futures	2204.06	2206.97	2203.53	2205.65	11992.0
2015-04-20 07:00:00	ES	Futures	2205.65	2206.18	2200.89	2202.48	15666.0
2015-04-20 08:00:00	ES	Futures	2202.48	2205.65	2201.95	2204.86	18196.0
2015-04-20 09:00:00	ES	Futures	2204.86	2212.25	2201.95	2210.93	208017.0
2015-04-20 10:00:00	ES	Futures	2211.19	2214.36	2208.02	2213.84	155723.0
2015-04-20 11:00:00	ES	Futures	2213.84	2215.95	2213.04	2214.89	129130.0
2015-04-20 12:00:00	ES	Futures	2214.89	2215.16	2212.78	2213.57	53221.0
2015-04-20 13:00:00	ES	Futures	2213.57	2215.16	2211.46	2211.99	59239.0
2015-04-20 14:00:00	ES	Futures	2211.99	2212.78	2210.14	2212.78	74233.0
2015-04-20 15:00:00	ES	Futures	2212.78	2215.42	2210.93	2211.72	178065.0
2015-04-20 16:00:00	ES	Futures	2211.46	2211.99	2208.02	2208.55	77234.0
2015-04-20 17:00:00	ES	Futures	2208.55	2208.82	2207.23	2207.5	3615.0
2015-04-20 18:00:00	ES	Futures	2207.5	2209.87	2207.23	2209.08	3978.0
2015-04-20 19:00:00	ES	Futures	2209.08	2210.67	2209.08	2210.4	1900.0
2015-04-20 20:00:00	ES	Futures	2210.4	2212.78	2210.14	2211.99	6199.0
2015-04-20 21:00:00	ES	Futures	2211.72	2213.57	2211.46	2212.78	4178.0
2015-04-20 22:00:00	ES	Futures	2213.04	2213.57	2211.99	2213.04	2723.0
2015-04-20 23:00:00	ES	Futures	2213.04	2214.89	2212.78	2214.36	3284.0
2015-04-20 00:00:00	NQ	Futures	5127.88	5128.17	5126.7	5127.0	376.0
2015-04-20 01:00:00	NQ	Futures	5126.7	5127.59	5124.06	5124.35	677.0
2015-04-20 02:00:00	NQ	Futures	5124.35	5128.47	5122.59	5127.88	1174.0
2015-04-20 03:00:00	NQ	Futures	5127.59	5148.17	5127.0	5139.94	6322.0
2015-04-20 04:00:00	NQ	Futures	5139.64	5142.29	5133.76	5135.23	3107.0
2015-04-20 05:00:00	NQ	Futures	5134.94	5139.35	5134.35	5136.11	1750.0
2015-04-20 06:00:00	NQ	Futures	5136.11	5143.47	5134.64	5139.64	2428.0
2015-04-20 07:00:00	NQ	Futures	5139.94	5141.7	5128.17	5131.11	3678.0
2015-04-20 08:00:00	NQ	Futures	5131.41	5138.17	5129.06	5136.41	4573.0
2015-04-20 09:00:00	NQ	Futures	5136.7	5164.05	5132.0	5163.76	52672.0
2015-04-20 10:00:00	NQ	Futures	5164.05	5178.16	5156.99	5175.81	37774.0
2015-04-20 11:00:00	NQ	Futures	5176.11	5184.34	5175.52	5183.75	24238.0
2015-04-20 12:00:00	NQ	Futures	5184.05	5184.05	5177.28	5180.22	9114.0
2015-04-20 13:00:00	NQ	Futures	5180.22	5187.57	5177.87	5184.93	11877.0
2015-04-20 14:00:00	NQ	Futures	5185.22	5188.16	5179.34	5186.99	13163.0
2015-04-20 15:00:00	NQ	Futures	5186.99	5195.51	5184.63	5186.69	31420.0
2015-04-20 16:00:00	NQ	Futures	5186.4	5189.63	5181.69	5183.46	6664.0
2015-04-20 17:00:00	NQ	Futures	5183.46	5183.46	5179.05	5179.34	286.0
2015-04-20 18:00:00	NQ	Futures	5178.75	5185.52	5178.75	5183.75	683.0
2015-04-20 19:00:00	NQ	Futures	5183.46	5186.69	5183.46	5186.1	446.0
2015-04-20 20:00:00	NQ	Futures	5186.1	5192.28	5185.81	5189.63	1228.0
2015-04-20 21:00:00	NQ	Futures	5189.34	5193.75	5189.34	5192.87	670.0
2015-04-20 22:00:00	NQ	Futures	5193.16	5194.34	5191.1	5192.57	425.0
2015-04-20 23:00:00	NQ	Futures	5192.57	5197.57	5192.57	5196.69	832.0
2015-04-20 00:00:00	YM	Futures	18703.0	18706.1	18697.7	18698.8	338.0
2015-04-20 01:00:00	YM	Futures	18698.8	18701.9	18679.9	18680.9	1186.0

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

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