PREVIEW / futures_1hour / 2015-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-12.parquet
  size:    53 KB
  rows:    1,580

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-02-12 00:00:00	ES	Futures	2172.06	2173.63	2169.95	2173.63	4898.0
2015-02-12 01:00:00	ES	Futures	2173.9	2174.42	2170.74	2174.16	3247.0
2015-02-12 02:00:00	ES	Futures	2174.16	2175.48	2170.74	2172.32	7802.0
2015-02-12 03:00:00	ES	Futures	2172.32	2176.79	2170.21	2174.69	29733.0
2015-02-12 04:00:00	ES	Futures	2174.69	2182.58	2174.16	2181.79	30758.0
2015-02-12 05:00:00	ES	Futures	2182.06	2187.06	2180.74	2185.74	20119.0
2015-02-12 06:00:00	ES	Futures	2185.74	2186.79	2182.32	2184.95	12470.0
2015-02-12 07:00:00	ES	Futures	2184.95	2186.0	2183.63	2185.21	9837.0
2015-02-12 08:00:00	ES	Futures	2184.95	2187.06	2179.69	2182.06	48226.0
2015-02-12 09:00:00	ES	Futures	2182.32	2187.84	2180.48	2186.27	216810.0
2015-02-12 10:00:00	ES	Futures	2186.53	2189.42	2183.63	2185.74	215318.0
2015-02-12 11:00:00	ES	Futures	2185.74	2188.11	2182.58	2187.06	200514.0
2015-02-12 12:00:00	ES	Futures	2187.06	2190.74	2186.53	2188.63	105458.0
2015-02-12 13:00:00	ES	Futures	2188.63	2192.05	2188.63	2191.79	103612.0
2015-02-12 14:00:00	ES	Futures	2191.79	2193.63	2189.42	2193.11	93733.0
2015-02-12 15:00:00	ES	Futures	2193.37	2195.21	2191.27	2193.63	183319.0
2015-02-12 16:00:00	ES	Futures	2193.63	2194.16	2191.79	2192.58	72063.0
2015-02-12 17:00:00	ES	Futures	2192.58	2192.58	2192.05	2192.32	2073.0
2015-02-12 18:00:00	ES	Futures	2192.58	2192.58	2191.27	2192.05	5779.0
2015-02-12 19:00:00	ES	Futures	2192.32	2192.58	2191.53	2192.32	3749.0
2015-02-12 20:00:00	ES	Futures	2192.05	2192.32	2191.0	2191.27	3699.0
2015-02-12 21:00:00	ES	Futures	2191.27	2192.05	2191.27	2191.53	2351.0
2015-02-12 22:00:00	ES	Futures	2191.53	2193.9	2191.53	2192.58	3339.0
2015-02-12 23:00:00	ES	Futures	2192.32	2194.16	2192.05	2193.9	2630.0
2015-02-12 00:00:00	NQ	Futures	5048.8	5053.2	5044.39	5052.62	774.0
2015-02-12 01:00:00	NQ	Futures	5052.62	5054.96	5047.04	5054.96	613.0
2015-02-12 02:00:00	NQ	Futures	5054.96	5057.02	5045.57	5049.09	1456.0
2015-02-12 03:00:00	NQ	Futures	5049.09	5061.43	5045.27	5054.67	6303.0
2015-02-12 04:00:00	NQ	Futures	5054.96	5072.59	5054.38	5070.53	6331.0
2015-02-12 05:00:00	NQ	Futures	5070.24	5079.34	5067.01	5079.05	3959.0
2015-02-12 06:00:00	NQ	Futures	5078.75	5081.4	5071.12	5075.23	2729.0
2015-02-12 07:00:00	NQ	Futures	5075.52	5077.58	5071.7	5073.17	1921.0
2015-02-12 08:00:00	NQ	Futures	5073.17	5079.34	5070.24	5075.23	8015.0
2015-02-12 09:00:00	NQ	Futures	5075.23	5086.1	5069.06	5082.28	41796.0
2015-02-12 10:00:00	NQ	Futures	5082.28	5087.86	5077.29	5082.28	28699.0
2015-02-12 11:00:00	NQ	Futures	5082.28	5087.56	5074.35	5085.21	26069.0
2015-02-12 12:00:00	NQ	Futures	5085.21	5095.2	5084.04	5091.68	16004.0
2015-02-12 13:00:00	NQ	Futures	5091.09	5100.49	5087.56	5099.02	16439.0
2015-02-12 14:00:00	NQ	Futures	5099.02	5100.49	5091.68	5098.72	14951.0
2015-02-12 15:00:00	NQ	Futures	5098.43	5104.89	5094.91	5102.84	26696.0
2015-02-12 16:00:00	NQ	Futures	5102.84	5106.07	5099.61	5102.25	7686.0
2015-02-12 17:00:00	NQ	Futures	5101.95	5102.54	5101.07	5101.66	209.0
2015-02-12 18:00:00	NQ	Futures	5101.66	5102.84	5099.61	5100.78	594.0
2015-02-12 19:00:00	NQ	Futures	5101.07	5101.66	5099.61	5101.37	314.0
2015-02-12 20:00:00	NQ	Futures	5101.37	5101.66	5099.31	5100.78	421.0
2015-02-12 21:00:00	NQ	Futures	5100.78	5103.42	5100.49	5102.54	412.0
2015-02-12 22:00:00	NQ	Futures	5102.54	5106.95	5101.95	5103.72	576.0
2015-02-12 23:00:00	NQ	Futures	5103.72	5107.24	5103.13	5106.36	397.0
2015-02-12 00:00:00	YM	Futures	18602.9	18617.6	18587.3	18615.5	570.0
2015-02-12 01:00:00	YM	Futures	18616.5	18619.6	18593.5	18618.6	496.0

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

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