PREVIEW / stock_1hour / 2014-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-26.parquet
  size:    1.0 MB
  rows:    48,166
  symbols: 3,535

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-26 04:00:00	AAPL	Stock	18.6429	18.6429	18.5214	18.525	125664.0
2014-02-26 05:00:00	AAPL	Stock	18.5357	18.5868	18.5357	18.5821	39200.0
2014-02-26 06:00:00	AAPL	Stock	18.5714	18.6071	18.5671	18.6071	48244.0
2014-02-26 07:00:00	AAPL	Stock	18.6071	18.6607	18.6071	18.66	326844.0
2014-02-26 08:00:00	AAPL	Stock	18.62	18.75	18.62	18.7429	1119804.0
2014-02-26 09:00:00	AAPL	Stock	18.7407	18.75	18.4829	18.4843	43921024.0
2014-02-26 10:00:00	AAPL	Stock	18.4843	18.5954	18.4821	18.5021	47724880.0
2014-02-26 11:00:00	AAPL	Stock	18.5019	18.5761	18.4943	18.5218	23841468.0
2014-02-26 12:00:00	AAPL	Stock	18.5207	18.56	18.5179	18.5536	14874076.0
2014-02-26 13:00:00	AAPL	Stock	18.555	18.5586	18.5036	18.5123	17375008.0
2014-02-26 14:00:00	AAPL	Stock	18.5139	18.5321	18.4339	18.4821	28727356.0
2014-02-26 15:00:00	AAPL	Stock	18.4821	18.4821	18.4143	18.4762	43703856.0
2014-02-26 16:00:00	AAPL	Stock	18.4768	18.645	18.4321	18.44	4076324.0
2014-02-26 17:00:00	AAPL	Stock	18.4464	18.4771	18.4375	18.4643	295316.0
2014-02-26 18:00:00	AAPL	Stock	18.4639	18.4732	18.4639	18.4686	84252.0
2014-02-26 19:00:00	AAPL	Stock	18.4707	18.4707	18.4336	18.4336	92708.0
2014-02-26 08:00:00	MSFT	Stock	37.6	37.65	37.58	37.61	4398.0
2014-02-26 09:00:00	MSFT	Stock	37.79	37.79	37.58	37.64	2274303.0
2014-02-26 10:00:00	MSFT	Stock	37.65	37.74	37.51	37.64	7891909.0
2014-02-26 11:00:00	MSFT	Stock	37.64	37.66	37.5	37.545	4496184.0
2014-02-26 12:00:00	MSFT	Stock	37.545	37.55	37.48	37.485	2721645.0
2014-02-26 13:00:00	MSFT	Stock	37.49	37.54	37.42	37.505	5515599.0
2014-02-26 14:00:00	MSFT	Stock	37.51	37.51	37.19	37.46	6968537.0
2014-02-26 15:00:00	MSFT	Stock	37.47	37.51	37.375	37.47	6293920.0
2014-02-26 16:00:00	MSFT	Stock	37.47	37.504	37.421	37.46	3395814.0
2014-02-26 17:00:00	MSFT	Stock	37.44	37.48	37.44	37.47	28077.0
2014-02-26 18:00:00	MSFT	Stock	37.44	37.44	37.44	37.44	750.0
2014-02-26 09:00:00	NVDA	Stock	0.4675	0.474	0.4668	0.471	24851360.0
2014-02-26 10:00:00	NVDA	Stock	0.471	0.4745	0.4698	0.4718	56123760.0
2014-02-26 11:00:00	NVDA	Stock	0.4718	0.4725	0.4695	0.4698	24929960.0
2014-02-26 12:00:00	NVDA	Stock	0.4699	0.4718	0.4698	0.4705	22604680.0
2014-02-26 13:00:00	NVDA	Stock	0.4706	0.4718	0.4698	0.4702	36984600.0
2014-02-26 14:00:00	NVDA	Stock	0.4702	0.4705	0.467	0.4679	62607800.0
2014-02-26 15:00:00	NVDA	Stock	0.4679	0.4685	0.4662	0.4678	95197840.0
2014-02-26 16:00:00	NVDA	Stock	0.4678	0.4698	0.4678	0.4678	15212920.0
2014-02-26 17:00:00	NVDA	Stock	0.4678	0.4678	0.4678	0.4678	55240.0
2014-02-26 18:00:00	NVDA	Stock	0.468	0.468	0.468	0.468	12800.0
2014-02-26 04:00:00	AMZN	Stock	17.9875	17.9875	17.9875	17.9875	2000.0
2014-02-26 06:00:00	AMZN	Stock	18.025	18.025	18.025	18.025	2000.0
2014-02-26 08:00:00	AMZN	Stock	18.0	18.05	18.0	18.04	91120.0
2014-02-26 09:00:00	AMZN	Stock	18.0425	18.0965	17.889	17.962	9125360.0
2014-02-26 10:00:00	AMZN	Stock	17.974	18.1665	17.972	18.125	15530820.0
2014-02-26 11:00:00	AMZN	Stock	18.126	18.2375	18.1185	18.2098	8629100.0
2014-02-26 12:00:00	AMZN	Stock	18.2115	18.2285	18.132	18.132	4882760.0
2014-02-26 13:00:00	AMZN	Stock	18.1328	18.1445	18.0835	18.094	5135920.0
2014-02-26 14:00:00	AMZN	Stock	18.0955	18.1075	17.8585	17.9545	8636240.0
2014-02-26 15:00:00	AMZN	Stock	17.957	18.012	17.9095	17.9925	9582480.0
2014-02-26 16:00:00	AMZN	Stock	17.99	18.1458	17.98	17.99	3931460.0
2014-02-26 17:00:00	AMZN	Stock	17.99	17.991	17.9755	17.99	47340.0
2014-02-26 18:00:00	AMZN	Stock	18.01	18.01	18.01	18.01	2880.0

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

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