PREVIEW / stock_1hour / 2012-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-03.parquet
  size:    960 KB
  rows:    45,691
  symbols: 3,526

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
2012-04-03 04:00:00	AAPL	Stock	22.1418	22.25	22.1418	22.2214	373744.0
2012-04-03 05:00:00	AAPL	Stock	22.2321	22.25	22.215	22.2157	198296.0
2012-04-03 06:00:00	AAPL	Stock	22.2268	22.2893	22.2171	22.2861	493752.0
2012-04-03 07:00:00	AAPL	Stock	22.2879	22.2996	22.1436	22.2411	3021424.0
2012-04-03 08:00:00	AAPL	Stock	22.2425	22.4268	22.2321	22.4243	11999064.0
2012-04-03 09:00:00	AAPL	Stock	22.4214	22.5461	22.3468	22.4589	193193196.0
2012-04-03 10:00:00	AAPL	Stock	22.4589	22.5714	22.3911	22.5714	123144084.0
2012-04-03 11:00:00	AAPL	Stock	22.5714	22.5789	22.4082	22.4353	115601052.0
2012-04-03 12:00:00	AAPL	Stock	22.4354	22.4461	22.2325	22.4371	112805280.0
2012-04-03 13:00:00	AAPL	Stock	22.4364	22.4986	22.4129	22.4964	46303208.0
2012-04-03 14:00:00	AAPL	Stock	22.4943	22.4964	22.3679	22.4186	91132272.0
2012-04-03 15:00:00	AAPL	Stock	22.4229	22.5104	22.378	22.4754	116053644.0
2012-04-03 16:00:00	AAPL	Stock	22.4706	22.4911	22.3933	22.4525	11152456.0
2012-04-03 17:00:00	AAPL	Stock	22.4525	22.4757	22.4411	22.4643	423696.0
2012-04-03 18:00:00	AAPL	Stock	22.4671	22.4911	22.4589	22.4893	951104.0
2012-04-03 19:00:00	AAPL	Stock	22.4936	22.495	22.4554	22.4911	1054788.0
2012-04-03 06:00:00	MSFT	Stock	32.28	32.28	32.28	32.28	100.0
2012-04-03 07:00:00	MSFT	Stock	32.28	32.42	32.28	32.42	300.0
2012-04-03 08:00:00	MSFT	Stock	32.28	32.3	32.21	32.23	5000.0
2012-04-03 09:00:00	MSFT	Stock	32.22	32.22	31.96	32.04	4379861.0
2012-04-03 10:00:00	MSFT	Stock	32.03	32.08	31.93	32.055	6464622.0
2012-04-03 11:00:00	MSFT	Stock	32.055	32.08	31.831	31.855	5567995.0
2012-04-03 12:00:00	MSFT	Stock	31.85	31.895	31.8	31.89	3790753.0
2012-04-03 13:00:00	MSFT	Stock	31.885	31.92	31.82	31.875	3745957.0
2012-04-03 14:00:00	MSFT	Stock	31.87	31.88	31.66	31.75	6484737.0
2012-04-03 15:00:00	MSFT	Stock	31.752	31.94	31.69	31.94	9625637.0
2012-04-03 16:00:00	MSFT	Stock	31.94	31.965	31.71	31.93	2237741.0
2012-04-03 17:00:00	MSFT	Stock	31.93	31.93	31.92	31.93	2351.0
2012-04-03 18:00:00	MSFT	Stock	31.93	31.93	31.8	31.86	33221.0
2012-04-03 19:00:00	MSFT	Stock	31.86	31.87	31.85	31.85	3180.0
2012-04-03 08:00:00	NVDA	Stock	0.3845	0.3915	0.3845	0.3898	832000.0
2012-04-03 09:00:00	NVDA	Stock	0.3898	0.3902	0.38	0.381	59516000.0
2012-04-03 10:00:00	NVDA	Stock	0.381	0.3833	0.38	0.3813	71338560.0
2012-04-03 11:00:00	NVDA	Stock	0.3814	0.3815	0.3775	0.3775	55190800.0
2012-04-03 12:00:00	NVDA	Stock	0.3775	0.3783	0.3763	0.3781	28960240.0
2012-04-03 13:00:00	NVDA	Stock	0.3783	0.3788	0.377	0.3778	32033200.0
2012-04-03 14:00:00	NVDA	Stock	0.3778	0.3778	0.3753	0.3768	80107240.0
2012-04-03 15:00:00	NVDA	Stock	0.3766	0.3778	0.375	0.377	85582000.0
2012-04-03 16:00:00	NVDA	Stock	0.377	0.3787	0.3753	0.3768	9474280.0
2012-04-03 17:00:00	NVDA	Stock	0.3755	0.378	0.3755	0.378	100000.0
2012-04-03 18:00:00	NVDA	Stock	0.3785	0.3785	0.3785	0.3785	48000.0
2012-04-03 08:00:00	AMZN	Stock	9.899	9.967	9.8725	9.9255	237020.0
2012-04-03 09:00:00	AMZN	Stock	9.929	10.0495	9.875	10.0425	18679020.0
2012-04-03 10:00:00	AMZN	Stock	10.041	10.1105	10.016	10.102	24723340.0
2012-04-03 11:00:00	AMZN	Stock	10.105	10.1195	10.0285	10.0515	13920100.0
2012-04-03 12:00:00	AMZN	Stock	10.0545	10.058	10.006	10.046	7641180.0
2012-04-03 13:00:00	AMZN	Stock	10.0472	10.05	10.0135	10.045	4965580.0
2012-04-03 14:00:00	AMZN	Stock	10.0415	10.0435	9.96	9.9905	10713280.0
2012-04-03 15:00:00	AMZN	Stock	9.9885	10.0045	9.9415	9.983	16620120.0
2012-04-03 16:00:00	AMZN	Stock	9.983	10.077	9.9615	9.975	2344440.0

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

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