PREVIEW / stock_1hour / 2014-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-21.parquet
  size:    1.1 MB
  rows:    49,961
  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-03-21 05:00:00	AAPL	Stock	18.9286	18.9286	18.8339	18.8339	57960.0
2014-03-21 06:00:00	AAPL	Stock	18.9171	18.9271	18.9171	18.9271	5600.0
2014-03-21 07:00:00	AAPL	Stock	18.9246	18.9643	18.9089	18.9268	216188.0
2014-03-21 08:00:00	AAPL	Stock	18.9279	18.9393	18.9118	18.9211	499548.0
2014-03-21 09:00:00	AAPL	Stock	18.9282	19.1129	18.8971	18.8986	80522764.0
2014-03-21 10:00:00	AAPL	Stock	18.8987	18.9196	18.8482	18.9125	29514940.0
2014-03-21 11:00:00	AAPL	Stock	18.9132	18.9286	18.8954	18.8996	14265300.0
2014-03-21 12:00:00	AAPL	Stock	18.9011	18.9154	18.8489	18.8511	12688648.0
2014-03-21 13:00:00	AAPL	Stock	18.8511	18.8575	18.8011	18.8375	23061472.0
2014-03-21 14:00:00	AAPL	Stock	18.8393	18.8675	18.7975	18.8486	21810208.0
2014-03-21 15:00:00	AAPL	Stock	18.8482	18.9875	18.8229	18.9868	71489628.0
2014-03-21 16:00:00	AAPL	Stock	19.0311	19.06	18.9091	19.0143	74742388.0
2014-03-21 17:00:00	AAPL	Stock	19.0111	19.0311	19.0039	19.0039	1351868.0
2014-03-21 18:00:00	AAPL	Stock	19.0046	19.0114	18.9929	19.0114	199024.0
2014-03-21 19:00:00	AAPL	Stock	19.0086	19.0171	19.0046	19.0171	89908.0
2014-03-21 06:00:00	MSFT	Stock	40.34	40.5	40.34	40.5	800.0
2014-03-21 07:00:00	MSFT	Stock	40.55	40.56	40.48	40.48	5245.0
2014-03-21 08:00:00	MSFT	Stock	40.47	40.66	40.47	40.5	14791.0
2014-03-21 09:00:00	MSFT	Stock	40.52	40.94	40.37	40.498	28750635.0
2014-03-21 10:00:00	MSFT	Stock	40.5	40.52	40.06	40.315	10648109.0
2014-03-21 11:00:00	MSFT	Stock	40.31	40.36	40.21	40.33	4110569.0
2014-03-21 12:00:00	MSFT	Stock	40.33	40.4	40.28	40.375	3375945.0
2014-03-21 13:00:00	MSFT	Stock	40.375	40.43	40.285	40.35	4220996.0
2014-03-21 14:00:00	MSFT	Stock	40.359	40.43	40.165	40.22	5329960.0
2014-03-21 15:00:00	MSFT	Stock	40.21	40.29	40.01	40.17	10911152.0
2014-03-21 16:00:00	MSFT	Stock	40.16	40.85	40.15	40.452	8137873.0
2014-03-21 17:00:00	MSFT	Stock	40.16	40.19	40.16	40.17	2533487.0
2014-03-21 18:00:00	MSFT	Stock	40.19	40.24	40.161	40.24	6810.0
2014-03-21 19:00:00	MSFT	Stock	40.24	40.24	40.24	40.24	200.0
2014-03-21 08:00:00	NVDA	Stock	0.4643	0.4643	0.4643	0.4643	1332000.0
2014-03-21 09:00:00	NVDA	Stock	0.464	0.472	0.4608	0.4702	111497360.0
2014-03-21 10:00:00	NVDA	Stock	0.4703	0.4708	0.4655	0.4668	57664040.0
2014-03-21 11:00:00	NVDA	Stock	0.4668	0.4678	0.4658	0.4666	19727320.0
2014-03-21 12:00:00	NVDA	Stock	0.4668	0.4683	0.4661	0.4679	16858240.0
2014-03-21 13:00:00	NVDA	Stock	0.4678	0.4679	0.463	0.4635	23031960.0
2014-03-21 14:00:00	NVDA	Stock	0.4633	0.4645	0.4615	0.464	30868720.0
2014-03-21 15:00:00	NVDA	Stock	0.464	0.4641	0.461	0.4628	132082520.0
2014-03-21 16:00:00	NVDA	Stock	0.4635	0.4683	0.4631	0.4635	141180920.0
2014-03-21 17:00:00	NVDA	Stock	0.4635	0.4635	0.4635	0.4635	998240.0
2014-03-21 08:00:00	AMZN	Stock	18.525	18.55	18.5025	18.55	65860.0
2014-03-21 09:00:00	AMZN	Stock	18.563	18.6745	18.273	18.4255	22859920.0
2014-03-21 10:00:00	AMZN	Stock	18.426	18.448	18.2255	18.2715	12255420.0
2014-03-21 11:00:00	AMZN	Stock	18.275	18.308	18.2	18.29	8201940.0
2014-03-21 12:00:00	AMZN	Stock	18.289	18.348	18.247	18.2788	3853940.0
2014-03-21 13:00:00	AMZN	Stock	18.281	18.281	18.0645	18.0675	7771020.0
2014-03-21 14:00:00	AMZN	Stock	18.0675	18.0992	17.9765	18.0135	11549100.0
2014-03-21 15:00:00	AMZN	Stock	18.0075	18.0415	17.92	18.029	18540280.0
2014-03-21 16:00:00	AMZN	Stock	18.031	18.642	18.0005	18.0125	6120360.0
2014-03-21 17:00:00	AMZN	Stock	18.031	18.031	18.03	18.031	163800.0
2014-03-21 18:00:00	AMZN	Stock	18.003	18.003	17.9525	18.0	21400.0

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

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