PREVIEW / stock_1hour / 2013-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-26.parquet
  size:    999 KB
  rows:    46,378
  symbols: 3,527

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-08-26 04:00:00	AAPL	Stock	17.9971	17.9982	17.9618	17.9618	35756.0
2013-08-26 05:00:00	AAPL	Stock	17.9643	17.9643	17.9561	17.9561	16800.0
2013-08-26 06:00:00	AAPL	Stock	17.9561	17.9561	17.9411	17.9411	5600.0
2013-08-26 07:00:00	AAPL	Stock	17.9411	17.9411	17.9071	17.9175	283948.0
2013-08-26 08:00:00	AAPL	Stock	17.9429	17.9429	17.8882	17.9043	1083068.0
2013-08-26 09:00:00	AAPL	Stock	17.9107	18.067	17.875	18.0279	53775064.0
2013-08-26 10:00:00	AAPL	Stock	18.0279	18.0568	17.9871	18.0477	37076480.0
2013-08-26 11:00:00	AAPL	Stock	18.0511	18.1592	18.0304	18.1343	43231692.0
2013-08-26 12:00:00	AAPL	Stock	18.1375	18.2214	18.1311	18.1696	38245732.0
2013-08-26 13:00:00	AAPL	Stock	18.1629	18.2179	18.1036	18.1371	27835108.0
2013-08-26 14:00:00	AAPL	Stock	18.1369	18.1625	18.1143	18.1493	17031616.0
2013-08-26 15:00:00	AAPL	Stock	18.15	18.1518	17.9425	17.9618	68544448.0
2013-08-26 16:00:00	AAPL	Stock	17.9632	18.2019	17.8787	17.9643	40534872.0
2013-08-26 17:00:00	AAPL	Stock	17.9696	17.9811	17.9632	17.9714	273980.0
2013-08-26 18:00:00	AAPL	Stock	17.9732	17.9811	17.9707	17.9718	104720.0
2013-08-26 19:00:00	AAPL	Stock	17.9718	17.9718	17.9561	17.9561	194740.0
2013-08-26 04:00:00	MSFT	Stock	34.61	34.61	34.61	34.61	400.0
2013-08-26 05:00:00	MSFT	Stock	34.56	34.56	34.53	34.53	1250.0
2013-08-26 06:00:00	MSFT	Stock	34.51	34.64	34.51	34.56	2149.0
2013-08-26 07:00:00	MSFT	Stock	34.58	34.75	34.55	34.6	27232.0
2013-08-26 08:00:00	MSFT	Stock	34.6	34.71	34.43	34.7	181005.0
2013-08-26 09:00:00	MSFT	Stock	34.7	34.7	34.05	34.22	13575318.0
2013-08-26 10:00:00	MSFT	Stock	34.215	34.29	34.03	34.155	13888065.0
2013-08-26 11:00:00	MSFT	Stock	34.15	34.41	34.15	34.355	9241761.0
2013-08-26 12:00:00	MSFT	Stock	34.36	34.64	34.33	34.64	6699929.0
2013-08-26 13:00:00	MSFT	Stock	34.634	34.65	34.395	34.44	6295747.0
2013-08-26 14:00:00	MSFT	Stock	34.44	34.45	34.26	34.41	5218415.0
2013-08-26 15:00:00	MSFT	Stock	34.42	34.42	34.1	34.16	10084007.0
2013-08-26 16:00:00	MSFT	Stock	34.15	34.319	34.08	34.18	3449989.0
2013-08-26 17:00:00	MSFT	Stock	34.15	34.15	34.09	34.09	2300.0
2013-08-26 18:00:00	MSFT	Stock	34.1	34.12	34.09	34.1	8673.0
2013-08-26 19:00:00	MSFT	Stock	34.1	34.12	34.07	34.09	6084.0
2013-08-26 08:00:00	NVDA	Stock	0.373	0.373	0.373	0.373	12000.0
2013-08-26 09:00:00	NVDA	Stock	0.3743	0.3758	0.3733	0.3745	41624080.0
2013-08-26 10:00:00	NVDA	Stock	0.3744	0.3755	0.374	0.3749	43191120.0
2013-08-26 11:00:00	NVDA	Stock	0.375	0.3753	0.3735	0.3739	31048240.0
2013-08-26 12:00:00	NVDA	Stock	0.3739	0.3755	0.3738	0.3748	24780600.0
2013-08-26 13:00:00	NVDA	Stock	0.3748	0.3755	0.3745	0.3754	21735320.0
2013-08-26 14:00:00	NVDA	Stock	0.3753	0.3755	0.3745	0.375	23775880.0
2013-08-26 15:00:00	NVDA	Stock	0.375	0.3751	0.3735	0.375	84705800.0
2013-08-26 16:00:00	NVDA	Stock	0.375	0.3751	0.374	0.374	29130640.0
2013-08-26 17:00:00	NVDA	Stock	0.3738	0.3738	0.3738	0.3738	4440.0
2013-08-26 04:00:00	AMZN	Stock	14.5	14.5205	14.5	14.5205	8000.0
2013-08-26 06:00:00	AMZN	Stock	14.5175	14.5175	14.4975	14.4975	8000.0
2013-08-26 08:00:00	AMZN	Stock	14.5	14.527	14.5	14.527	54020.0
2013-08-26 09:00:00	AMZN	Stock	14.511	14.5525	14.4138	14.433	4598640.0
2013-08-26 10:00:00	AMZN	Stock	14.43	14.488	14.418	14.436	5128120.0
2013-08-26 11:00:00	AMZN	Stock	14.4385	14.5	14.433	14.457	3846720.0
2013-08-26 12:00:00	AMZN	Stock	14.4575	14.4685	14.434	14.465	1937520.0
2013-08-26 13:00:00	AMZN	Stock	14.4647	14.47	14.427	14.447	3495940.0

> showing 50 of 46,378 rows — these rows as CSV

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