PREVIEW / stock_1hour / 2013-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-25.parquet
  size:    1005 KB
  rows:    46,435
  symbols: 3,495

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
2013-07-25 04:00:00	AAPL	Stock	15.7714	15.7857	15.7589	15.7589	11200.0
2013-07-25 05:00:00	AAPL	Stock	15.7493	15.7493	15.6786	15.6786	43120.0
2013-07-25 06:00:00	AAPL	Stock	15.6786	15.7036	15.6786	15.7036	19600.0
2013-07-25 07:00:00	AAPL	Stock	15.6911	15.7314	15.6893	15.7268	385756.0
2013-07-25 08:00:00	AAPL	Stock	15.7214	15.7679	15.6786	15.7536	1273076.0
2013-07-25 09:00:00	AAPL	Stock	15.7539	15.7643	15.5851	15.6414	57612184.0
2013-07-25 10:00:00	AAPL	Stock	15.6429	15.6721	15.5646	15.623	47624472.0
2013-07-25 11:00:00	AAPL	Stock	15.6282	15.6404	15.5864	15.6254	19300596.0
2013-07-25 12:00:00	AAPL	Stock	15.6286	15.7393	15.6179	15.7321	26543972.0
2013-07-25 13:00:00	AAPL	Stock	15.7314	15.7421	15.6743	15.6954	19612292.0
2013-07-25 14:00:00	AAPL	Stock	15.6893	15.705	15.6393	15.6586	18194540.0
2013-07-25 15:00:00	AAPL	Stock	15.6568	15.6932	15.6496	15.6607	27789664.0
2013-07-25 16:00:00	AAPL	Stock	15.6639	15.7142	15.6509	15.6607	7865536.0
2013-07-25 17:00:00	AAPL	Stock	15.6675	15.6729	15.6475	15.6529	216216.0
2013-07-25 18:00:00	AAPL	Stock	15.655	15.6643	15.6504	15.6589	150612.0
2013-07-25 19:00:00	AAPL	Stock	15.6518	15.6525	15.6518	15.6521	45248.0
2013-07-25 04:00:00	MSFT	Stock	31.94	31.94	31.94	31.94	600.0
2013-07-25 05:00:00	MSFT	Stock	31.94	31.94	31.57	31.57	2600.0
2013-07-25 06:00:00	MSFT	Stock	31.75	31.75	31.62	31.62	500.0
2013-07-25 07:00:00	MSFT	Stock	31.69	31.77	31.69	31.77	6348.0
2013-07-25 08:00:00	MSFT	Stock	31.9	31.91	31.7	31.88	17024.0
2013-07-25 09:00:00	MSFT	Stock	31.86	31.86	31.42	31.566	8600119.0
2013-07-25 10:00:00	MSFT	Stock	31.56	31.62	31.384	31.41	9530121.0
2013-07-25 11:00:00	MSFT	Stock	31.41	31.41	31.25	31.34	10071684.0
2013-07-25 12:00:00	MSFT	Stock	31.35	31.37	31.27	31.35	6120332.0
2013-07-25 13:00:00	MSFT	Stock	31.35	31.43	31.34	31.4	5043652.0
2013-07-25 14:00:00	MSFT	Stock	31.4	31.41	31.3	31.305	4328086.0
2013-07-25 15:00:00	MSFT	Stock	31.31	31.415	31.27	31.39	13790048.0
2013-07-25 16:00:00	MSFT	Stock	31.39	32.004	31.29	31.4	2867890.0
2013-07-25 17:00:00	MSFT	Stock	31.4	31.4	31.343	31.38	9174.0
2013-07-25 18:00:00	MSFT	Stock	31.38	31.38	31.35	31.35	4100.0
2013-07-25 19:00:00	MSFT	Stock	31.37	31.39	31.37	31.39	4329.0
2013-07-25 08:00:00	NVDA	Stock	0.3553	0.3553	0.3553	0.3553	8000.0
2013-07-25 09:00:00	NVDA	Stock	0.355	0.3575	0.3525	0.357	28578880.0
2013-07-25 10:00:00	NVDA	Stock	0.3572	0.3611	0.357	0.36	45127360.0
2013-07-25 11:00:00	NVDA	Stock	0.36	0.36	0.3542	0.3542	34133480.0
2013-07-25 12:00:00	NVDA	Stock	0.3542	0.3579	0.3535	0.3575	34018960.0
2013-07-25 13:00:00	NVDA	Stock	0.3575	0.3581	0.356	0.3562	12066880.0
2013-07-25 14:00:00	NVDA	Stock	0.356	0.3568	0.3554	0.3555	12907840.0
2013-07-25 15:00:00	NVDA	Stock	0.3555	0.3575	0.3548	0.3565	60951560.0
2013-07-25 16:00:00	NVDA	Stock	0.3565	0.3571	0.3553	0.3565	14079560.0
2013-07-25 04:00:00	AMZN	Stock	14.9375	14.9375	14.9375	14.9375	2000.0
2013-07-25 05:00:00	AMZN	Stock	14.9555	14.9555	14.954	14.954	42000.0
2013-07-25 07:00:00	AMZN	Stock	14.95	15.022	14.94	14.9925	36980.0
2013-07-25 08:00:00	AMZN	Stock	14.9975	15.02	14.95	15.0	250820.0
2013-07-25 09:00:00	AMZN	Stock	15.003	15.0238	14.8375	14.9229	11029380.0
2013-07-25 10:00:00	AMZN	Stock	14.9137	15.0025	14.8885	15.0015	8892360.0
2013-07-25 11:00:00	AMZN	Stock	15.0025	15.024	14.9375	14.9665	8399300.0
2013-07-25 12:00:00	AMZN	Stock	14.967	15.0885	14.9385	15.041	6959080.0
2013-07-25 13:00:00	AMZN	Stock	15.0336	15.132	15.0336	15.115	5639600.0

> showing 50 of 46,435 rows — these rows as CSV

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