PREVIEW / futures_1hour / 2015-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-19.parquet
  size:    38 KB
  rows:    1,125

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-19 00:00:00	ES	Futures	2118.9	2119.69	2116.0	2117.58	2068.0
2015-01-19 01:00:00	ES	Futures	2117.58	2118.9	2113.9	2113.9	3033.0
2015-01-19 02:00:00	ES	Futures	2113.9	2116.79	2112.58	2115.74	6748.0
2015-01-19 03:00:00	ES	Futures	2115.48	2116.53	2110.48	2112.58	16620.0
2015-01-19 04:00:00	ES	Futures	2112.58	2114.43	2109.95	2110.48	9223.0
2015-01-19 05:00:00	ES	Futures	2110.21	2112.58	2108.37	2109.16	6327.0
2015-01-19 06:00:00	ES	Futures	2109.16	2113.9	2108.9	2110.21	5200.0
2015-01-19 07:00:00	ES	Futures	2110.21	2113.9	2110.21	2112.58	3515.0
2015-01-19 08:00:00	ES	Futures	2112.32	2117.58	2111.53	2117.32	9099.0
2015-01-19 09:00:00	ES	Futures	2117.06	2125.74	2116.79	2123.37	27445.0
2015-01-19 10:00:00	ES	Futures	2123.64	2124.16	2119.16	2120.21	15965.0
2015-01-19 11:00:00	ES	Futures	2120.48	2121.0	2114.95	2117.06	14929.0
2015-01-19 12:00:00	ES	Futures	2117.32	2117.58	2112.32	2114.16	7766.0
2015-01-19 18:00:00	ES	Futures	2114.69	2116.27	2112.85	2115.74	3952.0
2015-01-19 19:00:00	ES	Futures	2115.48	2119.43	2114.43	2116.79	6156.0
2015-01-19 20:00:00	ES	Futures	2116.79	2122.85	2115.21	2122.06	7221.0
2015-01-19 21:00:00	ES	Futures	2122.06	2124.42	2118.37	2119.95	6730.0
2015-01-19 22:00:00	ES	Futures	2119.95	2122.85	2118.11	2121.27	4996.0
2015-01-19 23:00:00	ES	Futures	2121.0	2122.85	2119.43	2121.27	2866.0
2015-01-19 00:00:00	NQ	Futures	4854.96	4855.84	4848.8	4852.61	299.0
2015-01-19 01:00:00	NQ	Futures	4852.61	4855.26	4844.1	4844.39	370.0
2015-01-19 02:00:00	NQ	Futures	4844.1	4850.85	4841.75	4846.74	993.0
2015-01-19 03:00:00	NQ	Futures	4847.03	4853.79	4835.87	4843.8	3791.0
2015-01-19 04:00:00	NQ	Futures	4843.8	4845.86	4837.34	4838.81	2204.0
2015-01-19 05:00:00	NQ	Futures	4838.81	4846.15	4831.76	4835.29	2030.0
2015-01-19 06:00:00	NQ	Futures	4834.99	4849.38	4834.7	4837.64	1347.0
2015-01-19 07:00:00	NQ	Futures	4838.22	4848.8	4838.22	4846.45	660.0
2015-01-19 08:00:00	NQ	Futures	4846.15	4856.73	4843.8	4856.14	1923.0
2015-01-19 09:00:00	NQ	Futures	4855.84	4873.47	4855.55	4871.41	6532.0
2015-01-19 10:00:00	NQ	Futures	4871.7	4872.88	4861.13	4863.77	2699.0
2015-01-19 11:00:00	NQ	Futures	4863.77	4866.42	4850.85	4857.02	5107.0
2015-01-19 12:00:00	NQ	Futures	4857.31	4857.9	4842.63	4848.5	2011.0
2015-01-19 18:00:00	NQ	Futures	4849.09	4851.73	4844.1	4849.68	469.0
2015-01-19 19:00:00	NQ	Futures	4850.56	4860.84	4849.97	4855.26	1647.0
2015-01-19 20:00:00	NQ	Futures	4854.67	4868.18	4851.14	4866.71	1335.0
2015-01-19 21:00:00	NQ	Futures	4866.12	4874.64	4857.9	4862.89	1745.0
2015-01-19 22:00:00	NQ	Futures	4862.89	4869.65	4857.9	4867.3	1970.0
2015-01-19 23:00:00	NQ	Futures	4866.71	4872.88	4862.01	4869.35	1915.0
2015-01-19 00:00:00	YM	Futures	18194.8	18199.0	18169.7	18182.3	412.0
2015-01-19 01:00:00	YM	Futures	18183.3	18194.8	18153.0	18153.0	487.0
2015-01-19 02:00:00	YM	Futures	18153.0	18178.1	18139.5	18168.7	1561.0
2015-01-19 03:00:00	YM	Futures	18169.7	18180.2	18123.8	18147.8	4315.0
2015-01-19 04:00:00	YM	Futures	18147.8	18160.3	18116.5	18118.6	1786.0
2015-01-19 05:00:00	YM	Futures	18119.6	18143.6	18106.1	18114.4	1459.0
2015-01-19 06:00:00	YM	Futures	18114.4	18150.9	18113.4	18119.6	1085.0
2015-01-19 07:00:00	YM	Futures	18120.7	18157.2	18120.7	18149.9	885.0
2015-01-19 08:00:00	YM	Futures	18149.9	18187.5	18136.3	18182.3	1925.0
2015-01-19 09:00:00	YM	Futures	18182.3	18254.3	18182.3	18235.5	4318.0
2015-01-19 10:00:00	YM	Futures	18237.6	18241.8	18196.9	18202.1	3059.0
2015-01-19 11:00:00	YM	Futures	18203.1	18210.4	18153.0	18172.9	2701.0

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

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