PREVIEW / futures_1hour / 2015-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-15.parquet
  size:    56 KB
  rows:    1,602

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-15 00:00:00	ES	Futures	2115.74	2124.95	2115.21	2123.9	10857.0
2015-01-15 01:00:00	ES	Futures	2123.9	2133.9	2123.9	2131.53	15543.0
2015-01-15 02:00:00	ES	Futures	2131.53	2132.58	2123.64	2126.0	20172.0
2015-01-15 03:00:00	ES	Futures	2126.0	2131.0	2125.21	2127.32	22388.0
2015-01-15 04:00:00	ES	Futures	2127.32	2127.32	2090.48	2105.21	74557.0
2015-01-15 05:00:00	ES	Futures	2105.21	2116.53	2097.06	2102.06	81483.0
2015-01-15 06:00:00	ES	Futures	2102.06	2103.9	2093.11	2099.95	42905.0
2015-01-15 07:00:00	ES	Futures	2100.21	2119.16	2097.32	2109.69	64313.0
2015-01-15 08:00:00	ES	Futures	2109.43	2124.16	2106.79	2119.16	83583.0
2015-01-15 09:00:00	ES	Futures	2119.16	2122.06	2096.53	2100.21	338732.0
2015-01-15 10:00:00	ES	Futures	2100.21	2116.53	2096.0	2104.16	372653.0
2015-01-15 11:00:00	ES	Futures	2104.16	2106.53	2095.48	2099.69	230446.0
2015-01-15 12:00:00	ES	Futures	2099.69	2102.85	2089.69	2093.9	179958.0
2015-01-15 13:00:00	ES	Futures	2093.64	2101.27	2091.0	2094.95	165023.0
2015-01-15 14:00:00	ES	Futures	2095.22	2103.37	2092.85	2101.27	144952.0
2015-01-15 15:00:00	ES	Futures	2101.53	2103.11	2089.16	2090.22	252069.0
2015-01-15 16:00:00	ES	Futures	2090.48	2097.85	2087.85	2088.11	117499.0
2015-01-15 17:00:00	ES	Futures	2087.85	2088.37	2082.32	2083.9	12040.0
2015-01-15 18:00:00	ES	Futures	2084.95	2087.85	2082.58	2083.64	13149.0
2015-01-15 19:00:00	ES	Futures	2083.37	2084.43	2076.0	2079.95	21930.0
2015-01-15 20:00:00	ES	Futures	2080.22	2083.37	2077.85	2078.37	7947.0
2015-01-15 21:00:00	ES	Futures	2078.37	2079.16	2073.9	2076.27	13371.0
2015-01-15 22:00:00	ES	Futures	2076.0	2080.48	2076.0	2077.85	6097.0
2015-01-15 23:00:00	ES	Futures	2077.85	2082.06	2076.27	2081.27	5358.0
2015-01-15 00:00:00	NQ	Futures	4877.28	4898.43	4876.7	4897.84	2696.0
2015-01-15 01:00:00	NQ	Futures	4898.72	4922.22	4898.72	4916.93	3181.0
2015-01-15 02:00:00	NQ	Futures	4916.93	4918.69	4895.79	4901.95	3369.0
2015-01-15 03:00:00	NQ	Futures	4902.25	4914.29	4900.48	4904.6	4033.0
2015-01-15 04:00:00	NQ	Futures	4904.3	4904.6	4806.21	4841.45	16284.0
2015-01-15 05:00:00	NQ	Futures	4842.63	4876.7	4824.42	4849.38	14022.0
2015-01-15 06:00:00	NQ	Futures	4848.8	4854.67	4824.42	4838.81	7321.0
2015-01-15 07:00:00	NQ	Futures	4839.1	4877.28	4835.58	4857.61	10969.0
2015-01-15 08:00:00	NQ	Futures	4856.73	4886.97	4851.73	4872.0	15819.0
2015-01-15 09:00:00	NQ	Futures	4872.0	4890.5	4818.25	4826.48	73531.0
2015-01-15 10:00:00	NQ	Futures	4825.3	4866.42	4813.55	4840.57	75384.0
2015-01-15 11:00:00	NQ	Futures	4840.87	4846.74	4816.2	4825.3	44315.0
2015-01-15 12:00:00	NQ	Futures	4825.59	4835.29	4796.23	4807.39	43151.0
2015-01-15 13:00:00	NQ	Futures	4807.68	4826.77	4802.39	4804.45	37834.0
2015-01-15 14:00:00	NQ	Futures	4804.74	4826.77	4800.04	4822.07	31966.0
2015-01-15 15:00:00	NQ	Futures	4822.07	4826.18	4790.35	4796.52	48151.0
2015-01-15 16:00:00	NQ	Futures	4796.52	4813.55	4791.82	4792.11	16845.0
2015-01-15 17:00:00	NQ	Futures	4792.41	4792.41	4776.55	4778.9	2115.0
2015-01-15 18:00:00	NQ	Futures	4784.18	4786.83	4775.67	4777.72	1818.0
2015-01-15 19:00:00	NQ	Futures	4777.43	4780.37	4760.69	4767.44	4639.0
2015-01-15 20:00:00	NQ	Futures	4768.03	4775.37	4763.04	4763.92	1206.0
2015-01-15 21:00:00	NQ	Futures	4763.63	4765.98	4753.05	4753.93	2911.0
2015-01-15 22:00:00	NQ	Futures	4754.23	4766.27	4753.05	4755.4	2685.0
2015-01-15 23:00:00	NQ	Futures	4755.4	4760.69	4747.77	4758.93	3311.0
2015-01-15 00:00:00	YM	Futures	18155.1	18229.2	18149.9	18221.9	2431.0
2015-01-15 01:00:00	YM	Futures	18223.0	18302.3	18223.0	18284.6	3602.0

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

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