PREVIEW / futures_1hour / 2015-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-16.parquet
  size:    46 KB
  rows:    1,313

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-01-16 00:00:00	ES	Futures	2081.27	2083.37	2077.32	2078.9	8812.0
2015-01-16 01:00:00	ES	Futures	2078.9	2084.16	2078.11	2081.79	9388.0
2015-01-16 02:00:00	ES	Futures	2081.79	2088.9	2081.79	2084.69	17440.0
2015-01-16 03:00:00	ES	Futures	2084.69	2093.37	2083.64	2087.06	40385.0
2015-01-16 04:00:00	ES	Futures	2087.06	2087.32	2077.06	2082.32	27290.0
2015-01-16 05:00:00	ES	Futures	2082.32	2086.27	2078.37	2083.64	23063.0
2015-01-16 06:00:00	ES	Futures	2083.64	2092.58	2083.37	2090.22	24977.0
2015-01-16 07:00:00	ES	Futures	2089.95	2090.48	2080.22	2081.27	31960.0
2015-01-16 08:00:00	ES	Futures	2081.27	2092.58	2081.27	2088.37	62929.0
2015-01-16 09:00:00	ES	Futures	2088.64	2099.43	2086.0	2089.69	288783.0
2015-01-16 10:00:00	ES	Futures	2089.69	2104.95	2085.48	2103.37	406670.0
2015-01-16 11:00:00	ES	Futures	2103.37	2106.0	2097.58	2099.95	243073.0
2015-01-16 12:00:00	ES	Futures	2099.69	2111.79	2099.16	2108.37	175136.0
2015-01-16 13:00:00	ES	Futures	2108.37	2109.16	2102.06	2108.9	135961.0
2015-01-16 14:00:00	ES	Futures	2108.9	2109.95	2104.69	2108.9	104083.0
2015-01-16 15:00:00	ES	Futures	2108.64	2120.21	2106.27	2117.58	238375.0
2015-01-16 16:00:00	ES	Futures	2117.06	2119.95	2116.53	2118.9	99297.0
2015-01-16 17:00:00	ES	Futures	2118.9	2120.21	2118.64	2119.95	1820.0
2015-01-16 00:00:00	NQ	Futures	4759.22	4765.39	4753.05	4757.16	2750.0
2015-01-16 01:00:00	NQ	Futures	4756.87	4770.67	4755.7	4765.09	1391.0
2015-01-16 02:00:00	NQ	Futures	4765.09	4781.83	4764.51	4771.26	2072.0
2015-01-16 03:00:00	NQ	Futures	4771.26	4791.53	4767.74	4773.02	7645.0
2015-01-16 04:00:00	NQ	Futures	4773.32	4773.9	4751.0	4760.98	4700.0
2015-01-16 05:00:00	NQ	Futures	4760.69	4768.62	4749.82	4762.74	4488.0
2015-01-16 06:00:00	NQ	Futures	4763.04	4779.48	4760.69	4775.67	5084.0
2015-01-16 07:00:00	NQ	Futures	4775.37	4775.37	4759.22	4764.21	6517.0
2015-01-16 08:00:00	NQ	Futures	4763.92	4792.99	4763.92	4784.77	15691.0
2015-01-16 09:00:00	NQ	Futures	4784.77	4822.66	4781.83	4792.7	64625.0
2015-01-16 10:00:00	NQ	Futures	4792.7	4830.29	4783.01	4822.36	74748.0
2015-01-16 11:00:00	NQ	Futures	4822.36	4831.47	4804.74	4809.73	41666.0
2015-01-16 12:00:00	NQ	Futures	4809.73	4840.87	4807.09	4830.88	25595.0
2015-01-16 13:00:00	NQ	Futures	4831.17	4834.11	4816.2	4832.64	19515.0
2015-01-16 14:00:00	NQ	Futures	4832.94	4836.17	4824.71	4834.99	17102.0
2015-01-16 15:00:00	NQ	Futures	4834.99	4860.25	4829.12	4853.79	37309.0
2015-01-16 16:00:00	NQ	Futures	4853.79	4860.54	4851.73	4859.37	11414.0
2015-01-16 17:00:00	NQ	Futures	4859.37	4861.72	4858.49	4861.72	139.0
2015-01-16 00:00:00	YM	Futures	17938.0	17957.8	17912.9	17922.3	1827.0
2015-01-16 01:00:00	YM	Futures	17922.3	17967.2	17919.2	17945.3	1841.0
2015-01-16 02:00:00	YM	Futures	17945.3	18005.8	17945.3	17972.4	2787.0
2015-01-16 03:00:00	YM	Futures	17972.4	18035.1	17959.9	17990.2	7971.0
2015-01-16 04:00:00	YM	Futures	17989.1	17992.3	17906.7	17942.2	3495.0
2015-01-16 05:00:00	YM	Futures	17943.2	17981.8	17912.9	17961.0	3668.0
2015-01-16 06:00:00	YM	Futures	17957.8	18030.9	17954.7	18007.9	4192.0
2015-01-16 07:00:00	YM	Futures	18006.9	18007.9	17912.9	17922.3	4884.0
2015-01-16 08:00:00	YM	Futures	17922.3	18015.2	17922.3	17982.9	6848.0
2015-01-16 09:00:00	YM	Futures	17982.9	18060.1	17949.5	17959.9	33795.0
2015-01-16 10:00:00	YM	Futures	17959.9	18090.4	17923.4	18080.0	44794.0
2015-01-16 11:00:00	YM	Futures	18078.9	18099.8	18026.7	18042.4	22287.0
2015-01-16 12:00:00	YM	Futures	18043.4	18141.5	18034.0	18119.6	18843.0
2015-01-16 13:00:00	YM	Futures	18119.6	18125.9	18060.1	18113.4	12636.0

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

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