PREVIEW / stock_1hour / 2013-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-23.parquet
  size:    1009 KB
  rows:    47,103
  symbols: 3,531

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-05-23 04:00:00	AAPL	Stock	15.7857	15.7857	15.5696	15.57	86016.0
2013-05-23 05:00:00	AAPL	Stock	15.5539	15.5539	15.5	15.5179	243880.0
2013-05-23 06:00:00	AAPL	Stock	15.5036	15.5904	15.5036	15.575	127064.0
2013-05-23 07:00:00	AAPL	Stock	15.5671	15.6429	15.5671	15.5943	552440.0
2013-05-23 08:00:00	AAPL	Stock	15.6029	15.7143	15.5714	15.6118	3384836.0
2013-05-23 09:00:00	AAPL	Stock	15.6132	15.7068	15.5607	15.6482	66743908.0
2013-05-23 10:00:00	AAPL	Stock	15.6511	15.9343	15.6307	15.8543	109442732.0
2013-05-23 11:00:00	AAPL	Stock	15.8579	15.9092	15.8146	15.8379	32621876.0
2013-05-23 12:00:00	AAPL	Stock	15.8318	15.8704	15.7882	15.8379	30390948.0
2013-05-23 13:00:00	AAPL	Stock	15.8404	15.8407	15.7371	15.7957	27205696.0
2013-05-23 14:00:00	AAPL	Stock	15.7925	15.8793	15.7821	15.85	30431156.0
2013-05-23 15:00:00	AAPL	Stock	15.8521	15.8675	15.7875	15.7925	40191200.0
2013-05-23 16:00:00	AAPL	Stock	15.7921	15.8651	15.7843	15.8254	8900640.0
2013-05-23 17:00:00	AAPL	Stock	15.8214	15.8289	15.7907	15.825	277032.0
2013-05-23 18:00:00	AAPL	Stock	15.8246	15.8282	15.8246	15.8279	57456.0
2013-05-23 19:00:00	AAPL	Stock	15.8268	15.8482	15.7907	15.8429	344708.0
2013-05-23 04:00:00	MSFT	Stock	34.11	34.2	34.02	34.02	4495.0
2013-05-23 05:00:00	MSFT	Stock	34.11	34.13	34.11	34.13	700.0
2013-05-23 06:00:00	MSFT	Stock	34.15	34.3	34.13	34.3	7877.0
2013-05-23 07:00:00	MSFT	Stock	34.2	34.29	34.15	34.24	32683.0
2013-05-23 08:00:00	MSFT	Stock	34.18	34.25	34.15	34.21	85818.0
2013-05-23 09:00:00	MSFT	Stock	34.2	34.46	33.9	34.02	10340411.0
2013-05-23 10:00:00	MSFT	Stock	34.02	34.35	33.98	34.15	9243843.0
2013-05-23 11:00:00	MSFT	Stock	34.14	34.55	34.13	34.45	5742702.0
2013-05-23 12:00:00	MSFT	Stock	34.45	34.48	34.26	34.3	3523271.0
2013-05-23 13:00:00	MSFT	Stock	34.3	34.32	34.17	34.27	3652619.0
2013-05-23 14:00:00	MSFT	Stock	34.27	34.335	34.19	34.287	3628414.0
2013-05-23 15:00:00	MSFT	Stock	34.285	34.305	34.1	34.15	8779814.0
2013-05-23 16:00:00	MSFT	Stock	34.15	34.393	34.05	34.13	2507777.0
2013-05-23 17:00:00	MSFT	Stock	34.14	34.16	34.1	34.1	28669.0
2013-05-23 18:00:00	MSFT	Stock	34.17	34.2	34.17	34.2	3384.0
2013-05-23 19:00:00	MSFT	Stock	34.15	34.15	34.15	34.15	7800.0
2013-05-23 04:00:00	NVDA	Stock	0.3575	0.3575	0.3502	0.3502	128000.0
2013-05-23 06:00:00	NVDA	Stock	0.3545	0.3545	0.3545	0.3545	16000.0
2013-05-23 07:00:00	NVDA	Stock	0.3545	0.3545	0.3545	0.3545	4000.0
2013-05-23 08:00:00	NVDA	Stock	0.3545	0.3555	0.353	0.353	633040.0
2013-05-23 09:00:00	NVDA	Stock	0.3538	0.3648	0.3538	0.3598	54775600.0
2013-05-23 10:00:00	NVDA	Stock	0.3595	0.366	0.3592	0.364	115534480.0
2013-05-23 11:00:00	NVDA	Stock	0.3641	0.3652	0.3625	0.364	41288000.0
2013-05-23 12:00:00	NVDA	Stock	0.3641	0.365	0.3635	0.3642	28036040.0
2013-05-23 13:00:00	NVDA	Stock	0.3642	0.365	0.3632	0.365	26495680.0
2013-05-23 14:00:00	NVDA	Stock	0.3648	0.3669	0.3645	0.366	42578960.0
2013-05-23 15:00:00	NVDA	Stock	0.3661	0.3668	0.3655	0.3658	71023480.0
2013-05-23 16:00:00	NVDA	Stock	0.3658	0.3668	0.3637	0.3662	12123800.0
2013-05-23 17:00:00	NVDA	Stock	0.3658	0.3658	0.3658	0.3658	71760.0
2013-05-23 04:00:00	AMZN	Stock	13.04	13.04	12.9625	12.9625	16000.0
2013-05-23 05:00:00	AMZN	Stock	12.97	12.97	12.97	12.97	2000.0
2013-05-23 06:00:00	AMZN	Stock	12.9675	12.995	12.954	12.995	25640.0
2013-05-23 07:00:00	AMZN	Stock	13.0225	13.035	12.975	12.975	148420.0
2013-05-23 08:00:00	AMZN	Stock	13.0	13.075	12.95	12.9975	309520.0

> showing 50 of 47,103 rows — these rows as CSV

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