PREVIEW / stock_1hour / 2014-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-06.parquet
  size:    1.0 MB
  rows:    48,591
  symbols: 3,525

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-06 04:00:00	AAPL	Stock	19.0525	19.0532	19.0525	19.0532	14000.0
2014-03-06 06:00:00	AAPL	Stock	19.0407	19.0407	19.0357	19.0357	11200.0
2014-03-06 07:00:00	AAPL	Stock	19.0321	19.0443	19.0286	19.0375	105140.0
2014-03-06 08:00:00	AAPL	Stock	19.0357	19.0529	19.0257	19.0464	459200.0
2014-03-06 09:00:00	AAPL	Stock	19.0429	19.0871	18.9643	18.9679	27000960.0
2014-03-06 10:00:00	AAPL	Stock	18.9679	19.0593	18.9546	19.0132	22703688.0
2014-03-06 11:00:00	AAPL	Stock	19.0125	19.0282	18.9786	18.9905	12308436.0
2014-03-06 12:00:00	AAPL	Stock	18.9904	19.0064	18.9643	18.9889	12606608.0
2014-03-06 13:00:00	AAPL	Stock	18.9864	18.9911	18.8936	18.8975	18617368.0
2014-03-06 14:00:00	AAPL	Stock	18.895	18.9518	18.8607	18.9404	16279284.0
2014-03-06 15:00:00	AAPL	Stock	18.9404	18.9696	18.9164	18.9579	22649284.0
2014-03-06 16:00:00	AAPL	Stock	18.9554	18.9757	18.9311	18.9554	12657680.0
2014-03-06 17:00:00	AAPL	Stock	18.9375	18.9591	18.9375	18.95	58184.0
2014-03-06 18:00:00	AAPL	Stock	18.95	18.95	18.9375	18.9375	14000.0
2014-03-06 19:00:00	AAPL	Stock	18.9554	18.9589	18.9343	18.9375	123648.0
2014-03-06 08:00:00	MSFT	Stock	38.11	38.24	38.11	38.2	7826.0
2014-03-06 09:00:00	MSFT	Stock	38.15	38.19	37.78	38.03	2639027.0
2014-03-06 10:00:00	MSFT	Stock	38.03	38.08	37.96	38.0	2600705.0
2014-03-06 11:00:00	MSFT	Stock	38.0	38.11	37.89	38.105	2406577.0
2014-03-06 12:00:00	MSFT	Stock	38.1	38.12	38.05	38.06	1192600.0
2014-03-06 13:00:00	MSFT	Stock	38.055	38.06	37.962	37.986	2099100.0
2014-03-06 14:00:00	MSFT	Stock	37.98	38.15	37.98	38.15	2334493.0
2014-03-06 15:00:00	MSFT	Stock	38.145	38.24	38.02	38.15	6705104.0
2014-03-06 16:00:00	MSFT	Stock	38.14	38.16	38.026	38.14	2408289.0
2014-03-06 17:00:00	MSFT	Stock	38.14	38.148	38.12	38.12	8474.0
2014-03-06 18:00:00	MSFT	Stock	38.12	38.12	38.12	38.12	200.0
2014-03-06 19:00:00	MSFT	Stock	38.14	38.15	38.11	38.15	22844.0
2014-03-06 09:00:00	NVDA	Stock	0.4668	0.4692	0.4606	0.4656	41210640.0
2014-03-06 10:00:00	NVDA	Stock	0.4655	0.4658	0.4615	0.4628	25498640.0
2014-03-06 11:00:00	NVDA	Stock	0.4628	0.4628	0.4588	0.4605	44095120.0
2014-03-06 12:00:00	NVDA	Stock	0.4605	0.4605	0.459	0.4599	20972400.0
2014-03-06 13:00:00	NVDA	Stock	0.46	0.461	0.4595	0.4596	21304840.0
2014-03-06 14:00:00	NVDA	Stock	0.4596	0.461	0.4595	0.4603	25096480.0
2014-03-06 15:00:00	NVDA	Stock	0.4605	0.461	0.4588	0.4598	73549160.0
2014-03-06 16:00:00	NVDA	Stock	0.4595	0.4613	0.4593	0.4596	33901080.0
2014-03-06 17:00:00	NVDA	Stock	0.4596	0.4596	0.4596	0.4596	11200.0
2014-03-06 04:00:00	AMZN	Stock	18.7075	18.7075	18.697	18.702	12680.0
2014-03-06 07:00:00	AMZN	Stock	18.703	18.703	18.653	18.6935	12580.0
2014-03-06 08:00:00	AMZN	Stock	18.703	18.725	18.615	18.7225	331360.0
2014-03-06 09:00:00	AMZN	Stock	18.7105	18.7665	18.591	18.591	12567820.0
2014-03-06 10:00:00	AMZN	Stock	18.5875	18.626	18.445	18.607	12737220.0
2014-03-06 11:00:00	AMZN	Stock	18.607	18.6555	18.51	18.619	5270780.0
2014-03-06 12:00:00	AMZN	Stock	18.615	18.669	18.592	18.63	3871280.0
2014-03-06 13:00:00	AMZN	Stock	18.6353	18.66	18.552	18.554	3738380.0
2014-03-06 14:00:00	AMZN	Stock	18.552	18.6422	18.52	18.634	3481000.0
2014-03-06 15:00:00	AMZN	Stock	18.6385	18.6485	18.5975	18.608	8375940.0
2014-03-06 16:00:00	AMZN	Stock	18.608	18.624	18.541	18.59	1924200.0
2014-03-06 17:00:00	AMZN	Stock	18.608	18.6117	18.59	18.59	9600.0
2014-03-06 19:00:00	AMZN	Stock	18.6075	18.608	18.6075	18.608	5480.0
2014-03-06 04:00:00	META	Stock	72.08	72.08	71.86	71.9	14321.0

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

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