PREVIEW / stock_1hour / 2013-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-08.parquet
  size:    999 KB
  rows:    46,741
  symbols: 3,510

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-07-08 04:00:00	AAPL	Stock	14.9629	14.9629	14.9629	14.9629	13468.0
2013-07-08 05:00:00	AAPL	Stock	15.0	15.0	15.0	15.0	4200.0
2013-07-08 06:00:00	AAPL	Stock	14.9989	14.9989	14.9929	14.9964	37688.0
2013-07-08 07:00:00	AAPL	Stock	14.9979	15.0089	14.9671	14.9732	270004.0
2013-07-08 08:00:00	AAPL	Stock	15.0	15.0	14.8571	14.9536	949284.0
2013-07-08 09:00:00	AAPL	Stock	14.955	15.0893	14.7775	14.7993	58284464.0
2013-07-08 10:00:00	AAPL	Stock	14.7993	14.8443	14.6661	14.7118	78657236.0
2013-07-08 11:00:00	AAPL	Stock	14.7111	14.8154	14.7111	14.7893	40312188.0
2013-07-08 12:00:00	AAPL	Stock	14.7879	14.7964	14.7375	14.7411	21317436.0
2013-07-08 13:00:00	AAPL	Stock	14.7411	14.7829	14.7257	14.7593	18006576.0
2013-07-08 14:00:00	AAPL	Stock	14.7596	14.7793	14.7161	14.7746	15971788.0
2013-07-08 15:00:00	AAPL	Stock	14.7756	14.8314	14.7521	14.825	40065956.0
2013-07-08 16:00:00	AAPL	Stock	14.8158	14.825	14.7643	14.8071	17104584.0
2013-07-08 17:00:00	AAPL	Stock	14.8118	14.8232	14.7946	14.8	1552572.0
2013-07-08 18:00:00	AAPL	Stock	14.8036	14.8036	14.7857	14.7857	91056.0
2013-07-08 19:00:00	AAPL	Stock	14.7875	14.7964	14.7786	14.7857	137032.0
2013-07-08 07:00:00	MSFT	Stock	34.21	34.21	34.21	34.21	102.0
2013-07-08 08:00:00	MSFT	Stock	34.2	34.33	34.16	34.26	7975.0
2013-07-08 09:00:00	MSFT	Stock	34.25	34.59	34.15	34.49	3867054.0
2013-07-08 10:00:00	MSFT	Stock	34.49	34.55	34.345	34.46	4020239.0
2013-07-08 11:00:00	MSFT	Stock	34.455	34.46	34.033	34.13	5470430.0
2013-07-08 12:00:00	MSFT	Stock	34.125	34.16	33.98	34.05	3778048.0
2013-07-08 13:00:00	MSFT	Stock	34.045	34.29	34.03	34.26	2104267.0
2013-07-08 14:00:00	MSFT	Stock	34.26	34.29	34.16	34.27	1547067.0
2013-07-08 15:00:00	MSFT	Stock	34.265	34.37	34.15	34.33	4803685.0
2013-07-08 16:00:00	MSFT	Stock	34.33	34.348	34.11	34.337	5721880.0
2013-07-08 17:00:00	MSFT	Stock	34.26	34.33	34.26	34.33	427585.0
2013-07-08 18:00:00	MSFT	Stock	34.27	34.27	34.27	34.27	200.0
2013-07-08 19:00:00	MSFT	Stock	34.32	34.32	34.32	34.32	1700.0
2013-07-08 05:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	40000.0
2013-07-08 09:00:00	NVDA	Stock	0.357	0.3585	0.3545	0.3549	26414600.0
2013-07-08 10:00:00	NVDA	Stock	0.355	0.3588	0.3545	0.3562	38585440.0
2013-07-08 11:00:00	NVDA	Stock	0.3565	0.3568	0.3544	0.3553	27540520.0
2013-07-08 12:00:00	NVDA	Stock	0.355	0.3555	0.353	0.3548	28162520.0
2013-07-08 13:00:00	NVDA	Stock	0.3545	0.3551	0.3534	0.3544	23789560.0
2013-07-08 14:00:00	NVDA	Stock	0.3545	0.3546	0.3522	0.3538	23081840.0
2013-07-08 15:00:00	NVDA	Stock	0.354	0.3551	0.353	0.3542	75021200.0
2013-07-08 16:00:00	NVDA	Stock	0.354	0.3564	0.3535	0.3535	18035640.0
2013-07-08 17:00:00	NVDA	Stock	0.354	0.354	0.354	0.354	1192320.0
2013-07-08 06:00:00	AMZN	Stock	14.3375	14.35	14.3375	14.35	4000.0
2013-07-08 07:00:00	AMZN	Stock	14.376	14.376	14.35	14.35	39100.0
2013-07-08 08:00:00	AMZN	Stock	14.35	14.35	14.275	14.338	254180.0
2013-07-08 09:00:00	AMZN	Stock	14.339	14.473	14.307	14.454	14691560.0
2013-07-08 10:00:00	AMZN	Stock	14.455	14.5395	14.43	14.446	11897460.0
2013-07-08 11:00:00	AMZN	Stock	14.446	14.519	14.446	14.487	5244720.0
2013-07-08 12:00:00	AMZN	Stock	14.4875	14.512	14.4545	14.4885	3981360.0
2013-07-08 13:00:00	AMZN	Stock	14.4896	14.5455	14.487	14.5395	4448560.0
2013-07-08 14:00:00	AMZN	Stock	14.541	14.5755	14.513	14.5625	5594620.0
2013-07-08 15:00:00	AMZN	Stock	14.559	14.5835	14.524	14.5375	10060060.0
2013-07-08 16:00:00	AMZN	Stock	14.537	14.5538	14.4808	14.5514	4021360.0

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

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