PREVIEW / futures_1hour / 2015-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-13.parquet
  size:    42 KB
  rows:    1,239

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-03-13 00:00:00	ES	Futures	2175.74	2175.74	2174.16	2175.21	1130.0
2015-03-13 01:00:00	ES	Futures	2175.48	2177.32	2175.21	2177.06	1388.0
2015-03-13 02:00:00	ES	Futures	2176.79	2176.79	2174.69	2175.21	1545.0
2015-03-13 03:00:00	ES	Futures	2175.21	2177.06	2174.42	2176.79	5204.0
2015-03-13 04:00:00	ES	Futures	2176.79	2177.58	2174.16	2174.69	12405.0
2015-03-13 05:00:00	ES	Futures	2174.42	2175.74	2173.63	2174.42	6897.0
2015-03-13 06:00:00	ES	Futures	2174.69	2176.53	2170.74	2176.0	12717.0
2015-03-13 07:00:00	ES	Futures	2175.74	2176.27	2167.58	2167.58	15345.0
2015-03-13 08:00:00	ES	Futures	2167.58	2170.74	2166.53	2169.16	21435.0
2015-03-13 09:00:00	ES	Futures	2169.42	2172.58	2164.95	2167.32	73692.0
2015-03-13 10:00:00	ES	Futures	2167.32	2168.9	2153.11	2153.37	123608.0
2015-03-13 11:00:00	ES	Futures	2153.11	2157.85	2147.32	2152.85	108551.0
2015-03-13 12:00:00	ES	Futures	2152.85	2157.32	2148.9	2156.0	58859.0
2015-03-13 13:00:00	ES	Futures	2156.0	2156.0	2149.42	2152.58	41839.0
2015-03-13 14:00:00	ES	Futures	2152.58	2153.37	2148.11	2152.85	38208.0
2015-03-13 15:00:00	ES	Futures	2152.85	2163.9	2151.0	2160.74	93968.0
2015-03-13 16:00:00	ES	Futures	2160.74	2161.0	2156.53	2159.95	62548.0
2015-03-13 17:00:00	ES	Futures	2159.95	2159.95	2158.63	2158.63	692.0
2015-03-13 00:00:00	NQ	Futures	5092.85	5093.73	5090.21	5093.73	159.0
2015-03-13 01:00:00	NQ	Futures	5093.44	5096.67	5092.85	5096.08	137.0
2015-03-13 02:00:00	NQ	Futures	5095.79	5095.79	5090.5	5091.09	177.0
2015-03-13 03:00:00	NQ	Futures	5091.09	5094.32	5089.03	5094.32	273.0
2015-03-13 04:00:00	NQ	Futures	5094.32	5099.02	5092.56	5096.96	2392.0
2015-03-13 05:00:00	NQ	Futures	5097.55	5099.61	5096.08	5097.26	457.0
2015-03-13 06:00:00	NQ	Futures	5098.14	5098.43	5087.27	5097.26	1570.0
2015-03-13 07:00:00	NQ	Futures	5096.67	5097.84	5081.69	5081.98	1389.0
2015-03-13 08:00:00	NQ	Futures	5082.28	5088.74	5078.17	5084.33	1907.0
2015-03-13 09:00:00	NQ	Futures	5083.75	5107.24	5078.17	5094.61	17394.0
2015-03-13 10:00:00	NQ	Futures	5094.61	5097.55	5050.85	5051.44	26678.0
2015-03-13 11:00:00	NQ	Futures	5051.15	5062.89	5041.75	5053.2	25456.0
2015-03-13 12:00:00	NQ	Futures	5053.2	5060.54	5039.4	5055.26	17396.0
2015-03-13 13:00:00	NQ	Futures	5054.67	5056.14	5038.81	5047.33	8875.0
2015-03-13 14:00:00	NQ	Futures	5047.33	5050.56	5037.64	5048.5	10683.0
2015-03-13 15:00:00	NQ	Futures	5048.8	5076.11	5044.39	5069.36	21636.0
2015-03-13 16:00:00	NQ	Futures	5069.06	5069.36	5059.37	5067.01	3481.0
2015-03-13 17:00:00	NQ	Futures	5067.01	5067.59	5064.95	5064.95	57.0
2015-03-13 00:00:00	YM	Futures	18677.8	18677.8	18668.4	18676.8	156.0
2015-03-13 01:00:00	YM	Futures	18676.8	18691.4	18676.8	18689.3	362.0
2015-03-13 02:00:00	YM	Futures	18688.3	18688.3	18673.6	18673.6	301.0
2015-03-13 03:00:00	YM	Futures	18675.7	18688.3	18670.5	18687.2	653.0
2015-03-13 04:00:00	YM	Futures	18687.2	18692.5	18666.3	18670.5	2518.0
2015-03-13 05:00:00	YM	Futures	18669.4	18678.8	18663.1	18668.4	1148.0
2015-03-13 06:00:00	YM	Futures	18669.4	18685.1	18635.9	18680.9	3255.0
2015-03-13 07:00:00	YM	Futures	18679.9	18687.2	18612.8	18612.8	2428.0
2015-03-13 08:00:00	YM	Futures	18611.7	18633.8	18600.2	18619.1	3402.0
2015-03-13 09:00:00	YM	Futures	18619.1	18636.9	18582.4	18590.8	16722.0
2015-03-13 10:00:00	YM	Futures	18590.8	18600.2	18471.2	18471.2	19114.0
2015-03-13 11:00:00	YM	Futures	18471.2	18503.7	18401.0	18448.1	15667.0
2015-03-13 12:00:00	YM	Futures	18449.2	18496.4	18420.9	18486.9	9071.0
2015-03-13 13:00:00	YM	Futures	18485.9	18488.0	18417.7	18442.9	6798.0

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

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