PREVIEW / stock_1hour / 2015-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-13.parquet
  size:    1.0 MB
  rows:    48,832
  symbols: 3,489

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
2015-05-13 04:00:00	AAPL	Stock	31.625	31.65	31.6025	31.6025	4460.0
2015-05-13 05:00:00	AAPL	Stock	31.54	31.6425	31.54	31.62	34896.0
2015-05-13 06:00:00	AAPL	Stock	31.6125	31.6125	31.5375	31.5375	50176.0
2015-05-13 07:00:00	AAPL	Stock	31.5375	31.5625	31.4975	31.5625	148388.0
2015-05-13 08:00:00	AAPL	Stock	31.5625	31.5975	31.5	31.5425	600416.0
2015-05-13 09:00:00	AAPL	Stock	31.55	31.7975	31.495	31.6922	25230900.0
2015-05-13 10:00:00	AAPL	Stock	31.69	31.74	31.5925	31.62	22045416.0
2015-05-13 11:00:00	AAPL	Stock	31.6225	31.68	31.5675	31.6515	14369240.0
2015-05-13 12:00:00	AAPL	Stock	31.6525	31.6725	31.535	31.605	9784364.0
2015-05-13 13:00:00	AAPL	Stock	31.605	31.7	31.6	31.6858	10382160.0
2015-05-13 14:00:00	AAPL	Stock	31.6875	31.7025	31.5525	31.5788	12795424.0
2015-05-13 15:00:00	AAPL	Stock	31.5788	31.5925	31.4675	31.5	22090912.0
2015-05-13 16:00:00	AAPL	Stock	31.5025	31.5125	31.475	31.5025	5442716.0
2015-05-13 17:00:00	AAPL	Stock	31.505	31.5125	31.495	31.5075	93972.0
2015-05-13 18:00:00	AAPL	Stock	31.495	31.525	31.475	31.505	116864.0
2015-05-13 19:00:00	AAPL	Stock	31.5	31.5125	31.4625	31.4925	111536.0
2015-05-13 05:00:00	MSFT	Stock	47.7	48.0	47.7	47.92	68256.0
2015-05-13 06:00:00	MSFT	Stock	47.99	48.02	47.87	48.02	36021.0
2015-05-13 07:00:00	MSFT	Stock	47.97	48.1	47.97	48.1	33190.0
2015-05-13 08:00:00	MSFT	Stock	48.02	48.07	47.88	47.97	77839.0
2015-05-13 09:00:00	MSFT	Stock	47.99	48.32	47.88	48.08	6330550.0
2015-05-13 10:00:00	MSFT	Stock	48.08	48.23	47.84	47.95	6156740.0
2015-05-13 11:00:00	MSFT	Stock	47.95	48.07	47.84	47.98	3678844.0
2015-05-13 12:00:00	MSFT	Stock	47.98	48.01	47.82	47.855	2152337.0
2015-05-13 13:00:00	MSFT	Stock	47.85	48.01	47.85	47.96	2078403.0
2015-05-13 14:00:00	MSFT	Stock	47.96	47.98	47.7	47.74	3103977.0
2015-05-13 15:00:00	MSFT	Stock	47.74	47.81	47.57	47.63	5181215.0
2015-05-13 16:00:00	MSFT	Stock	47.625	47.72	47.57	47.64	3050184.0
2015-05-13 17:00:00	MSFT	Stock	47.63	47.63	47.63	47.63	900.0
2015-05-13 18:00:00	MSFT	Stock	47.65	47.65	47.65	47.65	300.0
2015-05-13 19:00:00	MSFT	Stock	47.62	47.68	47.53	47.68	507.0
2015-05-13 09:00:00	NVDA	Stock	0.5225	0.5285	0.522	0.5275	28635360.0
2015-05-13 10:00:00	NVDA	Stock	0.5275	0.5275	0.52	0.5202	33062760.0
2015-05-13 11:00:00	NVDA	Stock	0.5205	0.5215	0.519	0.5211	40233000.0
2015-05-13 12:00:00	NVDA	Stock	0.5211	0.5215	0.5188	0.5207	39983040.0
2015-05-13 13:00:00	NVDA	Stock	0.5207	0.5242	0.5207	0.5241	37509800.0
2015-05-13 14:00:00	NVDA	Stock	0.524	0.5245	0.523	0.5238	27288560.0
2015-05-13 15:00:00	NVDA	Stock	0.524	0.5247	0.5225	0.5238	53014080.0
2015-05-13 16:00:00	NVDA	Stock	0.5238	0.5245	0.5238	0.5245	1163160.0
2015-05-13 07:00:00	AMZN	Stock	21.608	21.636	21.608	21.636	4000.0
2015-05-13 09:00:00	AMZN	Stock	21.6	21.6764	21.479	21.5555	4715780.0
2015-05-13 10:00:00	AMZN	Stock	21.5845	21.6154	21.4305	21.461	5111220.0
2015-05-13 11:00:00	AMZN	Stock	21.4605	21.493	21.4175	21.48	3104000.0
2015-05-13 12:00:00	AMZN	Stock	21.4848	21.4975	21.425	21.4365	2487400.0
2015-05-13 13:00:00	AMZN	Stock	21.4355	21.466	21.3575	21.3855	6290800.0
2015-05-13 14:00:00	AMZN	Stock	21.3863	21.399	21.2965	21.322	3934100.0
2015-05-13 15:00:00	AMZN	Stock	21.322	21.367	21.29	21.3435	6320760.0
2015-05-13 16:00:00	AMZN	Stock	21.3435	21.3435	21.3415	21.3415	2049660.0
2015-05-13 18:00:00	AMZN	Stock	21.3435	21.3435	21.3435	21.3435	2000.0
2015-05-13 19:00:00	AMZN	Stock	21.343	21.355	21.343	21.355	4000.0

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

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