PREVIEW / stock_1hour / 2012-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-17.parquet
  size:    965 KB
  rows:    45,649
  symbols: 3,516

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
2012-12-17 04:00:00	AAPL	Stock	18.3929	18.3929	17.9	17.9	320908.0
2012-12-17 05:00:00	AAPL	Stock	17.885	17.885	17.7875	17.8375	415632.0
2012-12-17 06:00:00	AAPL	Stock	17.8514	17.8514	17.7389	17.8214	1071952.0
2012-12-17 07:00:00	AAPL	Stock	17.8393	18.0179	17.8214	18.0075	2185316.0
2012-12-17 08:00:00	AAPL	Stock	18.0214	18.3329	17.7461	18.2436	12507152.0
2012-12-17 09:00:00	AAPL	Stock	18.2446	18.3696	18.0646	18.0768	151622268.0
2012-12-17 10:00:00	AAPL	Stock	18.0768	18.175	17.9011	18.1057	152901252.0
2012-12-17 11:00:00	AAPL	Stock	18.105	18.36	18.0593	18.3507	106911700.0
2012-12-17 12:00:00	AAPL	Stock	18.3429	18.4643	18.2639	18.3946	83734980.0
2012-12-17 13:00:00	AAPL	Stock	18.3957	18.4643	18.2679	18.2821	62425020.0
2012-12-17 14:00:00	AAPL	Stock	18.2821	18.3536	18.22	18.3327	51181564.0
2012-12-17 15:00:00	AAPL	Stock	18.3386	18.5714	18.2857	18.5414	108774736.0
2012-12-17 16:00:00	AAPL	Stock	18.5418	18.58	18.0536	18.5679	14681576.0
2012-12-17 17:00:00	AAPL	Stock	18.5679	18.625	18.5611	18.6214	890932.0
2012-12-17 18:00:00	AAPL	Stock	18.6168	18.6339	18.5786	18.5786	812868.0
2012-12-17 19:00:00	AAPL	Stock	18.5786	18.5989	18.5786	18.5893	916860.0
2012-12-17 05:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	100.0
2012-12-17 07:00:00	MSFT	Stock	26.82	26.82	26.82	26.82	225.0
2012-12-17 08:00:00	MSFT	Stock	26.92	26.92	26.79	26.79	43697.0
2012-12-17 09:00:00	MSFT	Stock	26.81	27.04	26.68	27.005	4610319.0
2012-12-17 10:00:00	MSFT	Stock	27.005	27.11	26.7	26.975	5248708.0
2012-12-17 11:00:00	MSFT	Stock	26.975	27.17	26.97	27.13	5050612.0
2012-12-17 12:00:00	MSFT	Stock	27.13	27.215	27.06	27.06	3613677.0
2012-12-17 13:00:00	MSFT	Stock	27.065	27.09	26.94	26.95	3474412.0
2012-12-17 14:00:00	MSFT	Stock	26.95	26.985	26.84	26.87	5523624.0
2012-12-17 15:00:00	MSFT	Stock	26.87	27.1	26.85	27.1	8171109.0
2012-12-17 16:00:00	MSFT	Stock	27.09	27.161	26.94	27.12	5529524.0
2012-12-17 17:00:00	MSFT	Stock	27.11	27.14	26.974	27.1	86037.0
2012-12-17 18:00:00	MSFT	Stock	27.11	27.11	27.09	27.09	2047.0
2012-12-17 19:00:00	MSFT	Stock	27.1	27.12	27.07	27.12	6098.0
2012-12-17 09:00:00	NVDA	Stock	0.3145	0.3158	0.3088	0.3147	71690920.0
2012-12-17 10:00:00	NVDA	Stock	0.3145	0.3155	0.3109	0.3113	85285920.0
2012-12-17 11:00:00	NVDA	Stock	0.3115	0.3123	0.3093	0.3118	77541640.0
2012-12-17 12:00:00	NVDA	Stock	0.3118	0.3123	0.311	0.3113	29704440.0
2012-12-17 13:00:00	NVDA	Stock	0.3113	0.3119	0.3093	0.3108	55489920.0
2012-12-17 14:00:00	NVDA	Stock	0.3108	0.312	0.3098	0.3118	35596120.0
2012-12-17 15:00:00	NVDA	Stock	0.3116	0.3135	0.3115	0.3135	70099160.0
2012-12-17 16:00:00	NVDA	Stock	0.3134	0.3143	0.3125	0.3133	13143800.0
2012-12-17 18:00:00	NVDA	Stock	0.3133	0.3133	0.3133	0.3133	48000.0
2012-12-17 19:00:00	NVDA	Stock	0.3133	0.3133	0.3125	0.3125	32000.0
2012-12-17 04:00:00	AMZN	Stock	12.5175	12.5175	12.5175	12.5175	2000.0
2012-12-17 05:00:00	AMZN	Stock	12.5035	12.548	12.5035	12.548	6000.0
2012-12-17 06:00:00	AMZN	Stock	12.5085	12.5345	12.5085	12.5345	4000.0
2012-12-17 07:00:00	AMZN	Stock	12.4875	12.5	12.4875	12.5	17820.0
2012-12-17 08:00:00	AMZN	Stock	12.496	12.55	12.48	12.5185	285180.0
2012-12-17 09:00:00	AMZN	Stock	12.53	12.6225	12.463	12.5692	7660540.0
2012-12-17 10:00:00	AMZN	Stock	12.5695	12.577	12.5	12.5635	5460220.0
2012-12-17 11:00:00	AMZN	Stock	12.5635	12.6295	12.5535	12.6166	8021120.0
2012-12-17 12:00:00	AMZN	Stock	12.619	12.67	12.6044	12.6425	3916120.0
2012-12-17 13:00:00	AMZN	Stock	12.6445	12.6555	12.5643	12.583	4400640.0

> showing 50 of 45,649 rows — these rows as CSV

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