PREVIEW / futures_1hour / 2016-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-04.parquet
  size:    54 KB
  rows:    1,638

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
2016-05-04 00:00:00	ES	Futures	2217.89	2219.24	2217.08	2217.35	2212.0
2016-05-04 01:00:00	ES	Futures	2217.35	2220.05	2217.08	2219.24	3104.0
2016-05-04 02:00:00	ES	Futures	2219.51	2221.94	2215.73	2216.27	13096.0
2016-05-04 03:00:00	ES	Futures	2216.0	2223.83	2215.73	2221.94	36857.0
2016-05-04 04:00:00	ES	Futures	2221.94	2222.48	2213.3	2213.3	30640.0
2016-05-04 05:00:00	ES	Futures	2213.57	2213.84	2204.12	2204.12	50396.0
2016-05-04 06:00:00	ES	Futures	2204.12	2207.09	2203.85	2205.47	32398.0
2016-05-04 07:00:00	ES	Futures	2205.74	2208.98	2205.47	2208.17	25766.0
2016-05-04 08:00:00	ES	Futures	2208.17	2210.06	2204.66	2204.93	57686.0
2016-05-04 09:00:00	ES	Futures	2204.93	2213.03	2204.66	2211.95	210312.0
2016-05-04 10:00:00	ES	Futures	2211.95	2217.62	2207.63	2209.52	305467.0
2016-05-04 11:00:00	ES	Futures	2209.25	2211.68	2204.12	2207.36	181176.0
2016-05-04 12:00:00	ES	Futures	2207.36	2211.41	2204.66	2204.93	110265.0
2016-05-04 13:00:00	ES	Futures	2204.93	2208.98	2204.12	2204.93	132324.0
2016-05-04 14:00:00	ES	Futures	2204.93	2209.52	2201.96	2207.09	148871.0
2016-05-04 15:00:00	ES	Futures	2207.09	2212.22	2204.93	2208.44	129187.0
2016-05-04 16:00:00	ES	Futures	2207.9	2210.87	2207.9	2210.33	46609.0
2016-05-04 18:00:00	ES	Futures	2210.06	2212.76	2209.79	2211.68	3794.0
2016-05-04 19:00:00	ES	Futures	2211.68	2213.03	2211.68	2211.95	2469.0
2016-05-04 20:00:00	ES	Futures	2211.95	2214.38	2211.95	2214.11	4010.0
2016-05-04 21:00:00	ES	Futures	2214.11	2217.62	2213.84	2217.62	8950.0
2016-05-04 22:00:00	ES	Futures	2217.62	2218.7	2217.08	2217.35	7383.0
2016-05-04 23:00:00	ES	Futures	2217.08	2218.7	2217.08	2217.89	2927.0
2016-05-04 00:00:00	NQ	Futures	5150.83	5154.7	5148.75	5149.35	476.0
2016-05-04 01:00:00	NQ	Futures	5149.94	5156.49	5148.75	5155.3	625.0
2016-05-04 02:00:00	NQ	Futures	5155.3	5161.25	5145.48	5147.26	1677.0
2016-05-04 03:00:00	NQ	Futures	5146.67	5163.93	5145.78	5158.87	4228.0
2016-05-04 04:00:00	NQ	Futures	5159.17	5161.55	5137.45	5138.04	3097.0
2016-05-04 05:00:00	NQ	Futures	5137.74	5139.53	5116.62	5117.21	6392.0
2016-05-04 06:00:00	NQ	Futures	5117.21	5124.95	5116.92	5121.68	3429.0
2016-05-04 07:00:00	NQ	Futures	5121.68	5124.65	5119.89	5123.46	3932.0
2016-05-04 08:00:00	NQ	Futures	5123.76	5127.03	5116.62	5118.11	7685.0
2016-05-04 09:00:00	NQ	Futures	5117.81	5135.36	5117.51	5133.88	38235.0
2016-05-04 10:00:00	NQ	Futures	5134.17	5142.5	5122.87	5130.6	47700.0
2016-05-04 11:00:00	NQ	Futures	5130.9	5137.74	5113.64	5123.46	24821.0
2016-05-04 12:00:00	NQ	Futures	5123.46	5135.96	5115.13	5115.73	18250.0
2016-05-04 13:00:00	NQ	Futures	5115.73	5127.63	5110.37	5119.0	20091.0
2016-05-04 14:00:00	NQ	Futures	5119.3	5129.11	5108.29	5120.78	19833.0
2016-05-04 15:00:00	NQ	Futures	5121.08	5131.2	5114.54	5120.78	19164.0
2016-05-04 16:00:00	NQ	Futures	5120.78	5130.3	5120.19	5128.22	5003.0
2016-05-04 18:00:00	NQ	Futures	5127.33	5134.47	5127.33	5132.09	590.0
2016-05-04 19:00:00	NQ	Futures	5132.39	5134.77	5132.39	5132.98	495.0
2016-05-04 20:00:00	NQ	Futures	5132.98	5138.34	5132.98	5137.74	660.0
2016-05-04 21:00:00	NQ	Futures	5137.74	5147.56	5137.74	5147.56	1249.0
2016-05-04 22:00:00	NQ	Futures	5147.86	5150.83	5145.78	5146.67	1053.0
2016-05-04 23:00:00	NQ	Futures	5147.26	5149.94	5145.48	5148.75	613.0
2016-05-04 00:00:00	YM	Futures	18893.5	18903.1	18887.0	18889.2	694.0
2016-05-04 01:00:00	YM	Futures	18889.2	18910.6	18886.0	18907.4	884.0
2016-05-04 02:00:00	YM	Futures	18907.4	18924.5	18878.5	18881.7	2003.0
2016-05-04 03:00:00	YM	Futures	18880.6	18938.4	18879.5	18923.4	4887.0

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

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