PREVIEW / stock_1hour / 2013-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-27.parquet
  size:    959 KB
  rows:    45,029
  symbols: 3,468

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
2013-03-27 05:00:00	AAPL	Stock	16.4821	16.4821	16.4332	16.4332	29260.0
2013-03-27 06:00:00	AAPL	Stock	16.445	16.445	16.4271	16.4271	41132.0
2013-03-27 07:00:00	AAPL	Stock	16.4179	16.4286	16.3075	16.375	661416.0
2013-03-27 08:00:00	AAPL	Stock	16.3696	16.4464	16.3136	16.3511	1507128.0
2013-03-27 09:00:00	AAPL	Stock	16.3507	16.3571	16.1946	16.2379	63857836.0
2013-03-27 10:00:00	AAPL	Stock	16.2421	16.2493	16.1543	16.2084	62913592.0
2013-03-27 11:00:00	AAPL	Stock	16.2093	16.2174	16.1339	16.1521	37342956.0
2013-03-27 12:00:00	AAPL	Stock	16.1525	16.1714	16.1214	16.1604	34435772.0
2013-03-27 13:00:00	AAPL	Stock	16.1604	16.1678	16.1154	16.1507	24363360.0
2013-03-27 14:00:00	AAPL	Stock	16.1521	16.2079	16.1421	16.1786	31352132.0
2013-03-27 15:00:00	AAPL	Stock	16.1786	16.19	16.0975	16.1454	57666756.0
2013-03-27 16:00:00	AAPL	Stock	16.1468	16.4671	16.1275	16.1382	8198764.0
2013-03-27 17:00:00	AAPL	Stock	16.1254	16.1457	16.1254	16.1457	406252.0
2013-03-27 18:00:00	AAPL	Stock	16.1393	16.1679	16.1375	16.1429	3874024.0
2013-03-27 19:00:00	AAPL	Stock	16.1425	16.1425	16.1268	16.1289	117516.0
2013-03-27 04:00:00	MSFT	Stock	28.21	28.25	28.21	28.25	200.0
2013-03-27 06:00:00	MSFT	Stock	28.08	28.08	28.08	28.08	100.0
2013-03-27 07:00:00	MSFT	Stock	28.03	28.04	28.03	28.04	650.0
2013-03-27 08:00:00	MSFT	Stock	28.07	28.08	28.03	28.08	7973.0
2013-03-27 09:00:00	MSFT	Stock	28.06	28.25	28.06	28.2	4006854.0
2013-03-27 10:00:00	MSFT	Stock	28.19	28.25	28.17	28.23	4532779.0
2013-03-27 11:00:00	MSFT	Stock	28.235	28.39	28.21	28.345	4629628.0
2013-03-27 12:00:00	MSFT	Stock	28.35	28.35	28.235	28.275	3136967.0
2013-03-27 13:00:00	MSFT	Stock	28.276	28.33	28.24	28.32	2607636.0
2013-03-27 14:00:00	MSFT	Stock	28.32	28.375	28.315	28.36	4512413.0
2013-03-27 15:00:00	MSFT	Stock	28.36	28.445	28.33	28.38	9348830.0
2013-03-27 16:00:00	MSFT	Stock	28.37	28.41	28.15	28.38	1840421.0
2013-03-27 17:00:00	MSFT	Stock	28.32	28.37	28.32	28.37	152129.0
2013-03-27 18:00:00	MSFT	Stock	28.32	28.32	28.32	28.32	1753.0
2013-03-27 19:00:00	MSFT	Stock	28.3	28.35	28.3	28.35	1003.0
2013-03-27 08:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	88000.0
2013-03-27 09:00:00	NVDA	Stock	0.3108	0.3133	0.3105	0.3123	20688480.0
2013-03-27 10:00:00	NVDA	Stock	0.312	0.3155	0.3113	0.3153	53215120.0
2013-03-27 11:00:00	NVDA	Stock	0.3153	0.3158	0.3145	0.3145	26369880.0
2013-03-27 12:00:00	NVDA	Stock	0.3148	0.3153	0.3143	0.3148	19397960.0
2013-03-27 13:00:00	NVDA	Stock	0.3148	0.317	0.3145	0.317	26194840.0
2013-03-27 14:00:00	NVDA	Stock	0.3169	0.318	0.3168	0.3173	37630040.0
2013-03-27 15:00:00	NVDA	Stock	0.3173	0.3178	0.316	0.3161	63708640.0
2013-03-27 16:00:00	NVDA	Stock	0.3163	0.3175	0.3163	0.3163	7254720.0
2013-03-27 17:00:00	NVDA	Stock	0.3163	0.3175	0.3163	0.3175	28000.0
2013-03-27 18:00:00	NVDA	Stock	0.3143	0.3163	0.3143	0.3163	38000.0
2013-03-27 08:00:00	AMZN	Stock	12.89	12.9775	12.8655	12.923	69000.0
2013-03-27 09:00:00	AMZN	Stock	12.9325	13.2135	12.895	13.1985	15114540.0
2013-03-27 10:00:00	AMZN	Stock	13.197	13.252	13.1405	13.199	12126920.0
2013-03-27 11:00:00	AMZN	Stock	13.1989	13.2965	13.18	13.2725	7885100.0
2013-03-27 12:00:00	AMZN	Stock	13.2745	13.2825	13.211	13.2375	4061000.0
2013-03-27 13:00:00	AMZN	Stock	13.232	13.2755	13.219	13.2583	2978800.0
2013-03-27 14:00:00	AMZN	Stock	13.26	13.27	13.2305	13.2395	3012160.0
2013-03-27 15:00:00	AMZN	Stock	13.2339	13.2775	13.218	13.265	9749340.0
2013-03-27 16:00:00	AMZN	Stock	13.265	13.296	13.0155	13.2648	2275980.0

> showing 50 of 45,029 rows — these rows as CSV

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