PREVIEW / stock_1hour / 2014-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-20.parquet
  size:    1.0 MB
  rows:    48,201
  symbols: 3,551

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-02-20 04:00:00	AAPL	Stock	19.1068	19.1518	19.1068	19.1518	53200.0
2014-02-20 05:00:00	AAPL	Stock	19.14	19.14	19.14	19.14	2800.0
2014-02-20 06:00:00	AAPL	Stock	19.125	19.125	18.9532	19.0129	451780.0
2014-02-20 07:00:00	AAPL	Stock	19.0129	19.0357	18.9664	18.9911	1320312.0
2014-02-20 08:00:00	AAPL	Stock	19.0086	19.0661	18.9821	19.0446	1828820.0
2014-02-20 09:00:00	AAPL	Stock	19.0532	19.1786	18.9057	18.9675	63712096.0
2014-02-20 10:00:00	AAPL	Stock	18.9643	19.1268	18.9475	19.048	41697824.0
2014-02-20 11:00:00	AAPL	Stock	19.0493	19.0693	18.9368	18.9818	32512592.0
2014-02-20 12:00:00	AAPL	Stock	18.9821	18.9989	18.93	18.9504	23990596.0
2014-02-20 13:00:00	AAPL	Stock	18.9554	18.9904	18.9286	18.9596	23418780.0
2014-02-20 14:00:00	AAPL	Stock	18.96	18.9775	18.8936	18.8979	21933940.0
2014-02-20 15:00:00	AAPL	Stock	18.8986	18.9946	18.8929	18.9679	37991268.0
2014-02-20 16:00:00	AAPL	Stock	18.9664	19.0562	18.9661	18.9732	7773976.0
2014-02-20 17:00:00	AAPL	Stock	18.9804	18.9857	18.9696	18.9761	156156.0
2014-02-20 18:00:00	AAPL	Stock	18.9743	18.9814	18.9696	18.9786	94724.0
2014-02-20 19:00:00	AAPL	Stock	18.9768	18.9857	18.9721	18.9857	78652.0
2014-02-20 07:00:00	MSFT	Stock	37.35	37.35	37.35	37.35	200.0
2014-02-20 08:00:00	MSFT	Stock	37.32	37.48	37.32	37.48	7450.0
2014-02-20 09:00:00	MSFT	Stock	37.47	37.82	37.41	37.495	4442730.0
2014-02-20 10:00:00	MSFT	Stock	37.495	37.6	37.395	37.55	4239219.0
2014-02-20 11:00:00	MSFT	Stock	37.55	37.74	37.5	37.68	3183134.0
2014-02-20 12:00:00	MSFT	Stock	37.68	37.79	37.62	37.775	2418579.0
2014-02-20 13:00:00	MSFT	Stock	37.775	37.79	37.69	37.74	1773929.0
2014-02-20 14:00:00	MSFT	Stock	37.735	37.78	37.67	37.779	2279811.0
2014-02-20 15:00:00	MSFT	Stock	37.775	37.87	37.74	37.74	5493838.0
2014-02-20 16:00:00	MSFT	Stock	37.74	37.811	37.551	37.75	2515396.0
2014-02-20 17:00:00	MSFT	Stock	37.71	37.75	37.71	37.75	19790.0
2014-02-20 18:00:00	MSFT	Stock	37.75	37.75	37.73	37.73	1400.0
2014-02-20 19:00:00	MSFT	Stock	37.75	37.76	37.75	37.76	13500.0
2014-02-20 08:00:00	NVDA	Stock	0.45	0.4538	0.45	0.4538	370320.0
2014-02-20 09:00:00	NVDA	Stock	0.4545	0.4603	0.4538	0.4568	45694080.0
2014-02-20 10:00:00	NVDA	Stock	0.4568	0.4612	0.4562	0.4605	70064880.0
2014-02-20 11:00:00	NVDA	Stock	0.4606	0.4622	0.4603	0.461	41055040.0
2014-02-20 12:00:00	NVDA	Stock	0.461	0.4645	0.4608	0.4643	54099920.0
2014-02-20 13:00:00	NVDA	Stock	0.4644	0.465	0.4638	0.4648	21638360.0
2014-02-20 14:00:00	NVDA	Stock	0.4649	0.4678	0.4646	0.4673	48607440.0
2014-02-20 15:00:00	NVDA	Stock	0.4673	0.4704	0.467	0.4692	95487560.0
2014-02-20 16:00:00	NVDA	Stock	0.4695	0.47	0.4571	0.4695	10152560.0
2014-02-20 17:00:00	NVDA	Stock	0.4695	0.4695	0.4695	0.4695	105800.0
2014-02-20 04:00:00	AMZN	Stock	17.325	17.332	17.325	17.332	6000.0
2014-02-20 05:00:00	AMZN	Stock	17.3445	17.355	17.3445	17.355	4000.0
2014-02-20 07:00:00	AMZN	Stock	17.3375	17.338	17.3375	17.338	4000.0
2014-02-20 08:00:00	AMZN	Stock	17.347	17.395	17.347	17.3875	115240.0
2014-02-20 09:00:00	AMZN	Stock	17.419	17.44	17.219	17.3801	11415940.0
2014-02-20 10:00:00	AMZN	Stock	17.379	17.514	17.3266	17.4025	13579880.0
2014-02-20 11:00:00	AMZN	Stock	17.4125	17.502	17.3885	17.4065	9703540.0
2014-02-20 12:00:00	AMZN	Stock	17.408	17.418	17.2965	17.355	7766420.0
2014-02-20 13:00:00	AMZN	Stock	17.3575	17.483	17.356	17.4675	4716080.0
2014-02-20 14:00:00	AMZN	Stock	17.47	17.5215	17.447	17.4885	6608560.0
2014-02-20 15:00:00	AMZN	Stock	17.486	17.523	17.458	17.4885	8260160.0

> showing 50 of 48,201 rows — these rows as CSV

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