PREVIEW / futures_1hour / 2016-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-06.parquet
  size:    45 KB
  rows:    1,338

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-06 00:00:00	ES	Futures	2204.66	2205.47	2204.12	2204.66	1826.0
2016-05-06 01:00:00	ES	Futures	2204.93	2206.01	2204.39	2204.93	3010.0
2016-05-06 02:00:00	ES	Futures	2204.93	2206.55	2203.31	2204.66	10604.0
2016-05-06 03:00:00	ES	Futures	2204.39	2207.9	2200.61	2206.01	36325.0
2016-05-06 04:00:00	ES	Futures	2205.74	2208.71	2204.93	2207.09	19991.0
2016-05-06 05:00:00	ES	Futures	2206.82	2207.09	2203.31	2203.58	14080.0
2016-05-06 06:00:00	ES	Futures	2203.85	2204.39	2200.34	2201.96	19747.0
2016-05-06 07:00:00	ES	Futures	2201.69	2202.77	2200.07	2202.23	22620.0
2016-05-06 08:00:00	ES	Futures	2202.23	2203.31	2192.78	2195.48	130970.0
2016-05-06 09:00:00	ES	Futures	2195.48	2210.33	2195.21	2204.66	324872.0
2016-05-06 10:00:00	ES	Futures	2204.66	2209.25	2196.29	2197.91	291108.0
2016-05-06 11:00:00	ES	Futures	2197.91	2205.47	2197.64	2200.88	188002.0
2016-05-06 12:00:00	ES	Futures	2200.88	2204.66	2200.07	2204.39	114496.0
2016-05-06 13:00:00	ES	Futures	2204.39	2212.22	2203.85	2211.95	144494.0
2016-05-06 14:00:00	ES	Futures	2212.22	2216.81	2211.41	2214.11	180210.0
2016-05-06 15:00:00	ES	Futures	2213.84	2216.27	2211.41	2216.0	180783.0
2016-05-06 16:00:00	ES	Futures	2216.0	2218.7	2215.73	2218.43	81837.0
2016-05-06 00:00:00	NQ	Futures	5108.29	5109.48	5105.91	5108.59	305.0
2016-05-06 01:00:00	NQ	Futures	5108.88	5112.16	5107.69	5110.07	412.0
2016-05-06 02:00:00	NQ	Futures	5110.37	5114.54	5107.39	5110.37	1495.0
2016-05-06 03:00:00	NQ	Futures	5110.07	5117.21	5098.17	5110.97	3851.0
2016-05-06 04:00:00	NQ	Futures	5110.67	5118.11	5108.59	5115.13	1889.0
2016-05-06 05:00:00	NQ	Futures	5114.54	5115.43	5107.1	5108.29	1674.0
2016-05-06 06:00:00	NQ	Futures	5108.59	5110.37	5099.66	5106.2	2137.0
2016-05-06 07:00:00	NQ	Futures	5106.2	5109.48	5102.04	5108.29	2330.0
2016-05-06 08:00:00	NQ	Futures	5107.99	5111.26	5083.0	5093.11	15592.0
2016-05-06 09:00:00	NQ	Futures	5093.11	5130.3	5091.03	5108.59	53513.0
2016-05-06 10:00:00	NQ	Futures	5108.59	5121.38	5088.65	5094.01	47363.0
2016-05-06 11:00:00	NQ	Futures	5093.71	5110.67	5092.52	5094.01	25567.0
2016-05-06 12:00:00	NQ	Futures	5094.01	5107.69	5090.14	5106.8	16687.0
2016-05-06 13:00:00	NQ	Futures	5106.8	5131.79	5106.5	5131.49	19341.0
2016-05-06 14:00:00	NQ	Futures	5131.79	5145.48	5130.01	5138.04	25735.0
2016-05-06 15:00:00	NQ	Futures	5138.04	5146.97	5134.47	5146.37	24569.0
2016-05-06 16:00:00	NQ	Futures	5146.07	5157.68	5145.48	5157.68	9433.0
2016-05-06 00:00:00	YM	Futures	18788.6	18791.8	18782.1	18788.6	394.0
2016-05-06 01:00:00	YM	Futures	18789.6	18798.2	18785.3	18791.8	611.0
2016-05-06 02:00:00	YM	Futures	18792.8	18801.4	18777.9	18787.5	1399.0
2016-05-06 03:00:00	YM	Futures	18787.5	18810.0	18753.2	18796.0	5165.0
2016-05-06 04:00:00	YM	Futures	18795.0	18814.2	18788.6	18805.7	1797.0
2016-05-06 05:00:00	YM	Futures	18804.6	18807.8	18780.0	18782.1	1565.0
2016-05-06 06:00:00	YM	Futures	18782.1	18788.6	18761.8	18774.6	1893.0
2016-05-06 07:00:00	YM	Futures	18773.6	18776.8	18757.5	18772.5	1629.0
2016-05-06 08:00:00	YM	Futures	18771.4	18783.2	18705.1	18722.2	12305.0
2016-05-06 09:00:00	YM	Futures	18721.1	18842.1	18720.0	18800.3	32649.0
2016-05-06 10:00:00	YM	Futures	18800.3	18844.2	18742.5	18758.6	25643.0
2016-05-06 11:00:00	YM	Futures	18758.6	18837.8	18756.4	18803.5	15509.0
2016-05-06 12:00:00	YM	Futures	18803.5	18828.2	18797.1	18824.9	9111.0
2016-05-06 13:00:00	YM	Futures	18826.0	18884.9	18824.9	18882.7	12405.0
2016-05-06 14:00:00	YM	Futures	18884.9	18921.3	18878.5	18896.7	14622.0
2016-05-06 15:00:00	YM	Futures	18897.7	18917.0	18882.7	18913.8	12672.0

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

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