PREVIEW / stock_1hour / 2010-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-13.parquet
  size:    908 KB
  rows:    43,358
  symbols: 3,484

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
2010-05-13 05:00:00	AAPL	Stock	9.3261	9.3511	9.3179	9.3179	24360.0
2010-05-13 06:00:00	AAPL	Stock	9.3339	9.3589	9.3339	9.3589	8400.0
2010-05-13 07:00:00	AAPL	Stock	9.3564	9.4107	9.3554	9.3986	528780.0
2010-05-13 08:00:00	AAPL	Stock	9.3964	9.4446	9.3893	9.4039	5226928.0
2010-05-13 09:00:00	AAPL	Stock	9.4032	9.4571	9.3532	9.442	96129292.0
2010-05-13 10:00:00	AAPL	Stock	9.4421	9.4643	9.4036	9.4114	98531104.0
2010-05-13 11:00:00	AAPL	Stock	9.4121	9.4275	9.3629	9.3717	63002688.0
2010-05-13 12:00:00	AAPL	Stock	9.3718	9.3868	9.3393	9.3596	48424320.0
2010-05-13 13:00:00	AAPL	Stock	9.3607	9.4107	9.3536	9.375	44850792.0
2010-05-13 14:00:00	AAPL	Stock	9.375	9.4007	9.3321	9.3504	43045884.0
2010-05-13 15:00:00	AAPL	Stock	9.35	9.3643	9.1571	9.2239	189485128.0
2010-05-13 16:00:00	AAPL	Stock	9.2232	9.4059	9.2014	9.2314	8538096.0
2010-05-13 17:00:00	AAPL	Stock	9.2325	9.2325	9.2179	9.2196	430556.0
2010-05-13 18:00:00	AAPL	Stock	9.2196	9.2371	9.2193	9.2321	256004.0
2010-05-13 19:00:00	AAPL	Stock	9.2286	9.2518	9.2286	9.25	512316.0
2010-05-13 08:00:00	MSFT	Stock	29.43	29.47	29.34	29.34	10930.0
2010-05-13 09:00:00	MSFT	Stock	29.35	29.67	29.2	29.57	6904152.0
2010-05-13 10:00:00	MSFT	Stock	29.57	29.73	29.48	29.62	8073379.0
2010-05-13 11:00:00	MSFT	Stock	29.62	29.65	29.42	29.42	3984114.0
2010-05-13 12:00:00	MSFT	Stock	29.42	29.56	29.4	29.52	3325734.0
2010-05-13 13:00:00	MSFT	Stock	29.52	29.64	29.48	29.55	3732925.0
2010-05-13 14:00:00	MSFT	Stock	29.54	29.615	29.4	29.41	4351793.0
2010-05-13 15:00:00	MSFT	Stock	29.42	29.45	29.18	29.24	12755664.0
2010-05-13 16:00:00	MSFT	Stock	29.23	29.474	29.2	29.44	1458689.0
2010-05-13 17:00:00	MSFT	Stock	29.3	29.3	29.22	29.23	497.0
2010-05-13 18:00:00	MSFT	Stock	29.24	29.25	29.24	29.25	11639.0
2010-05-13 19:00:00	MSFT	Stock	29.25	29.25	29.22	29.25	2100.0
2010-05-13 20:00:00	MSFT	Stock	29.56	29.56	29.56	29.56	200.0
2010-05-13 08:00:00	NVDA	Stock	0.372	0.375	0.3675	0.3682	1519200.0
2010-05-13 09:00:00	NVDA	Stock	0.3675	0.3783	0.3628	0.3742	169152760.0
2010-05-13 10:00:00	NVDA	Stock	0.374	0.3822	0.3692	0.3773	248841480.0
2010-05-13 11:00:00	NVDA	Stock	0.3774	0.3796	0.3733	0.3735	147779240.0
2010-05-13 12:00:00	NVDA	Stock	0.3735	0.375	0.3715	0.3728	65805320.0
2010-05-13 13:00:00	NVDA	Stock	0.3728	0.3728	0.369	0.3703	92860080.0
2010-05-13 14:00:00	NVDA	Stock	0.3703	0.373	0.37	0.3705	94850320.0
2010-05-13 15:00:00	NVDA	Stock	0.3704	0.3705	0.3648	0.3662	298319520.0
2010-05-13 16:00:00	NVDA	Stock	0.3662	0.3785	0.3482	0.3612	99560600.0
2010-05-13 17:00:00	NVDA	Stock	0.3622	0.3638	0.3525	0.3542	11003760.0
2010-05-13 18:00:00	NVDA	Stock	0.3542	0.3562	0.352	0.355	3081920.0
2010-05-13 19:00:00	NVDA	Stock	0.3542	0.355	0.3522	0.3525	1620120.0
2010-05-13 08:00:00	AMZN	Stock	6.725	6.725	6.685	6.6875	47920.0
2010-05-13 09:00:00	AMZN	Stock	6.6885	6.811	6.6715	6.788	16081760.0
2010-05-13 10:00:00	AMZN	Stock	6.787	6.8495	6.7515	6.7655	25037620.0
2010-05-13 11:00:00	AMZN	Stock	6.765	6.784	6.6785	6.687	14988560.0
2010-05-13 12:00:00	AMZN	Stock	6.6895	6.709	6.675	6.684	8825720.0
2010-05-13 13:00:00	AMZN	Stock	6.6845	6.731	6.6575	6.6665	9779160.0
2010-05-13 14:00:00	AMZN	Stock	6.6665	6.7015	6.6145	6.6305	12337960.0
2010-05-13 15:00:00	AMZN	Stock	6.6335	6.6585	6.55	6.5735	26786360.0
2010-05-13 16:00:00	AMZN	Stock	6.575	6.7672	6.55	6.574	1314960.0
2010-05-13 17:00:00	AMZN	Stock	6.5555	6.569	6.5555	6.565	14000.0

> showing 50 of 43,358 rows — these rows as CSV

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