PREVIEW / stock_1hour / 2014-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-25.parquet
  size:    1.0 MB
  rows:    49,284
  symbols: 3,522

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
2014-03-25 04:00:00	AAPL	Stock	19.2857	19.3039	19.2857	19.3039	5600.0
2014-03-25 05:00:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	2800.0
2014-03-25 06:00:00	AAPL	Stock	19.3021	19.3136	19.2786	19.2786	39256.0
2014-03-25 07:00:00	AAPL	Stock	19.2804	19.35	19.2804	19.3343	349104.0
2014-03-25 08:00:00	AAPL	Stock	19.3304	19.3304	19.2611	19.3093	1063188.0
2014-03-25 09:00:00	AAPL	Stock	19.3089	19.3882	19.2954	19.3754	39091164.0
2014-03-25 10:00:00	AAPL	Stock	19.3771	19.4286	19.3186	19.3343	43600760.0
2014-03-25 11:00:00	AAPL	Stock	19.3343	19.4018	19.3011	19.3279	20665372.0
2014-03-25 12:00:00	AAPL	Stock	19.3293	19.3604	19.2711	19.3507	20585712.0
2014-03-25 13:00:00	AAPL	Stock	19.3536	19.3968	19.3314	19.3689	17125220.0
2014-03-25 14:00:00	AAPL	Stock	19.3704	19.4204	19.3446	19.4186	15906352.0
2014-03-25 15:00:00	AAPL	Stock	19.4196	19.4911	19.4175	19.4643	49001568.0
2014-03-25 16:00:00	AAPL	Stock	19.4639	19.4702	19.2489	19.4429	9528288.0
2014-03-25 17:00:00	AAPL	Stock	19.4464	19.4639	19.4321	19.4411	589428.0
2014-03-25 18:00:00	AAPL	Stock	19.4482	19.4679	19.4482	19.4596	441168.0
2014-03-25 19:00:00	AAPL	Stock	19.4632	19.5018	19.4614	19.5018	407736.0
2014-03-25 07:00:00	MSFT	Stock	40.54	40.6	40.52	40.55	2948.0
2014-03-25 08:00:00	MSFT	Stock	40.56	40.78	40.48	40.75	28491.0
2014-03-25 09:00:00	MSFT	Stock	40.72	40.99	40.65	40.705	3887688.0
2014-03-25 10:00:00	MSFT	Stock	40.71	40.74	40.13	40.255	6984865.0
2014-03-25 11:00:00	MSFT	Stock	40.25	40.36	40.03	40.09	5577385.0
2014-03-25 12:00:00	MSFT	Stock	40.08	40.24	39.96	40.13	7706950.0
2014-03-25 13:00:00	MSFT	Stock	40.14	40.24	40.05	40.105	3649849.0
2014-03-25 14:00:00	MSFT	Stock	40.11	40.19	40.03	40.156	3101283.0
2014-03-25 15:00:00	MSFT	Stock	40.16	40.46	40.15	40.35	7481079.0
2014-03-25 16:00:00	MSFT	Stock	40.34	40.37	40.12	40.3	2179903.0
2014-03-25 17:00:00	MSFT	Stock	40.226	40.34	40.196	40.34	157805.0
2014-03-25 18:00:00	MSFT	Stock	40.34	40.37	40.34	40.34	14571.0
2014-03-25 19:00:00	MSFT	Stock	40.35	40.42	40.35	40.42	1425.0
2014-03-25 09:00:00	NVDA	Stock	0.4662	0.4662	0.4605	0.4631	21368920.0
2014-03-25 10:00:00	NVDA	Stock	0.463	0.4668	0.4615	0.4621	38907920.0
2014-03-25 11:00:00	NVDA	Stock	0.462	0.4628	0.458	0.4593	19144960.0
2014-03-25 12:00:00	NVDA	Stock	0.459	0.4609	0.4578	0.46	16958000.0
2014-03-25 13:00:00	NVDA	Stock	0.46	0.463	0.459	0.4626	17466560.0
2014-03-25 14:00:00	NVDA	Stock	0.4628	0.4645	0.4622	0.4643	59461240.0
2014-03-25 15:00:00	NVDA	Stock	0.4643	0.466	0.4598	0.4612	106027520.0
2014-03-25 16:00:00	NVDA	Stock	0.4612	0.4626	0.4605	0.4605	16632640.0
2014-03-25 17:00:00	NVDA	Stock	0.4605	0.4612	0.4605	0.4612	316560.0
2014-03-25 04:00:00	AMZN	Stock	17.6125	17.6125	17.6125	17.6125	2000.0
2014-03-25 08:00:00	AMZN	Stock	17.6995	17.708	17.674	17.6925	9680.0
2014-03-25 09:00:00	AMZN	Stock	17.6975	17.914	17.6686	17.904	10708780.0
2014-03-25 10:00:00	AMZN	Stock	17.912	17.9485	17.45	17.4965	15782800.0
2014-03-25 11:00:00	AMZN	Stock	17.4893	17.6452	17.442	17.5275	13981000.0
2014-03-25 12:00:00	AMZN	Stock	17.5315	17.6948	17.5035	17.6625	8202260.0
2014-03-25 13:00:00	AMZN	Stock	17.6595	17.81	17.5905	17.7702	9468680.0
2014-03-25 14:00:00	AMZN	Stock	17.7755	17.7985	17.686	17.7465	9105760.0
2014-03-25 15:00:00	AMZN	Stock	17.7465	17.773	17.67	17.7405	11127240.0
2014-03-25 16:00:00	AMZN	Stock	17.7335	17.76	17.5495	17.7355	575540.0
2014-03-25 17:00:00	AMZN	Stock	17.7355	17.7355	17.7355	17.7355	124620.0
2014-03-25 18:00:00	AMZN	Stock	17.75	17.7625	17.7355	17.7625	191260.0

> showing 50 of 49,284 rows — these rows as CSV

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