PREVIEW / stock_1hour / 2012-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-14.parquet
  size:    917 KB
  rows:    43,674
  symbols: 3,515

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-06-14 04:00:00	AAPL	Stock	20.4996	20.4996	20.4464	20.4464	8260.0
2012-06-14 05:00:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	5600.0
2012-06-14 06:00:00	AAPL	Stock	20.4286	20.4454	20.4286	20.4454	14420.0
2012-06-14 07:00:00	AAPL	Stock	20.4643	20.4746	20.4036	20.4161	187796.0
2012-06-14 08:00:00	AAPL	Stock	20.4289	20.4568	20.375	20.4518	1108408.0
2012-06-14 09:00:00	AAPL	Stock	20.4461	20.4643	20.3046	20.4421	48944336.0
2012-06-14 10:00:00	AAPL	Stock	20.4343	20.4525	20.3289	20.4375	50658972.0
2012-06-14 11:00:00	AAPL	Stock	20.4332	20.4821	20.4004	20.4232	37706032.0
2012-06-14 12:00:00	AAPL	Stock	20.4268	20.4679	20.4143	20.4536	20033776.0
2012-06-14 13:00:00	AAPL	Stock	20.4529	20.4571	20.3443	20.3818	32182472.0
2012-06-14 14:00:00	AAPL	Stock	20.3804	20.3993	20.2596	20.2654	35876904.0
2012-06-14 15:00:00	AAPL	Stock	20.2646	20.4546	20.2593	20.4111	104371204.0
2012-06-14 16:00:00	AAPL	Stock	20.4209	20.4275	20.3525	20.4232	12202624.0
2012-06-14 17:00:00	AAPL	Stock	20.4268	20.4321	20.4118	20.4279	248948.0
2012-06-14 18:00:00	AAPL	Stock	20.4232	20.4325	20.4232	20.4286	248864.0
2012-06-14 19:00:00	AAPL	Stock	20.4286	20.4314	20.4136	20.4271	179900.0
2012-06-14 07:00:00	MSFT	Stock	29.17	29.17	29.17	29.17	1000.0
2012-06-14 08:00:00	MSFT	Stock	29.23	29.23	29.01	29.18	16664.0
2012-06-14 09:00:00	MSFT	Stock	29.2	29.36	28.88	29.05	5188670.0
2012-06-14 10:00:00	MSFT	Stock	29.04	29.32	29.02	29.29	6977632.0
2012-06-14 11:00:00	MSFT	Stock	29.295	29.39	29.26	29.31	4085490.0
2012-06-14 12:00:00	MSFT	Stock	29.32	29.35	29.23	29.3	2794488.0
2012-06-14 13:00:00	MSFT	Stock	29.3	29.37	29.21	29.29	3134567.0
2012-06-14 14:00:00	MSFT	Stock	29.29	29.31	29.09	29.1	2813909.0
2012-06-14 15:00:00	MSFT	Stock	29.1	29.46	29.09	29.33	10979447.0
2012-06-14 16:00:00	MSFT	Stock	29.315	29.4	29.149	29.4	3191722.0
2012-06-14 17:00:00	MSFT	Stock	29.39	29.39	29.39	29.39	200.0
2012-06-14 18:00:00	MSFT	Stock	29.36	29.39	29.33	29.39	2450.0
2012-06-14 19:00:00	MSFT	Stock	29.27	29.3	29.27	29.3	1000.0
2012-06-14 08:00:00	NVDA	Stock	0.3062	0.3068	0.3048	0.3062	44000.0
2012-06-14 09:00:00	NVDA	Stock	0.3073	0.3073	0.3002	0.3042	46126480.0
2012-06-14 10:00:00	NVDA	Stock	0.3042	0.3055	0.304	0.305	92650920.0
2012-06-14 11:00:00	NVDA	Stock	0.305	0.3052	0.3042	0.3042	43657840.0
2012-06-14 12:00:00	NVDA	Stock	0.3042	0.3065	0.3042	0.3058	36179080.0
2012-06-14 13:00:00	NVDA	Stock	0.3055	0.306	0.3035	0.3038	40826360.0
2012-06-14 14:00:00	NVDA	Stock	0.3035	0.3038	0.2995	0.2998	65741960.0
2012-06-14 15:00:00	NVDA	Stock	0.2995	0.3025	0.2978	0.3008	245119640.0
2012-06-14 16:00:00	NVDA	Stock	0.3008	0.3015	0.3005	0.301	3374000.0
2012-06-14 17:00:00	NVDA	Stock	0.301	0.301	0.3008	0.3008	56280.0
2012-06-14 18:00:00	NVDA	Stock	0.301	0.3018	0.301	0.3018	274400.0
2012-06-14 19:00:00	NVDA	Stock	0.302	0.302	0.3015	0.3015	24000.0
2012-06-14 07:00:00	AMZN	Stock	10.747	10.747	10.747	10.747	2000.0
2012-06-14 08:00:00	AMZN	Stock	10.7495	10.775	10.7495	10.75	22000.0
2012-06-14 09:00:00	AMZN	Stock	10.75	10.808	10.702	10.7934	6447080.0
2012-06-14 10:00:00	AMZN	Stock	10.793	10.825	10.7605	10.7925	8137580.0
2012-06-14 11:00:00	AMZN	Stock	10.7925	10.82	10.785	10.785	6141640.0
2012-06-14 12:00:00	AMZN	Stock	10.7855	10.8125	10.7855	10.792	2218680.0
2012-06-14 13:00:00	AMZN	Stock	10.791	10.7945	10.7025	10.713	8348960.0
2012-06-14 14:00:00	AMZN	Stock	10.7125	10.7178	10.628	10.6315	7450400.0
2012-06-14 15:00:00	AMZN	Stock	10.636	10.79	10.632	10.7195	18743980.0

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

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