PREVIEW / stock_1hour / 2012-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-13.parquet
  size:    952 KB
  rows:    45,324
  symbols: 3,507

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-13 04:00:00	AAPL	Stock	19.2682	19.2739	19.2346	19.2346	8400.0
2012-12-13 05:00:00	AAPL	Stock	19.2146	19.2146	19.1929	19.1964	55160.0
2012-12-13 06:00:00	AAPL	Stock	19.1964	19.1964	19.1429	19.1607	106092.0
2012-12-13 07:00:00	AAPL	Stock	19.1464	19.2143	19.1464	19.1586	459984.0
2012-12-13 08:00:00	AAPL	Stock	19.1614	19.2143	18.8857	18.9193	11334064.0
2012-12-13 09:00:00	AAPL	Stock	18.9282	19.1357	18.9036	18.9489	109628232.0
2012-12-13 10:00:00	AAPL	Stock	18.9545	19.2014	18.9104	19.05	101655876.0
2012-12-13 11:00:00	AAPL	Stock	19.0518	19.0932	18.9821	19.0264	56912996.0
2012-12-13 12:00:00	AAPL	Stock	19.024	19.0521	18.8746	18.8746	63774284.0
2012-12-13 13:00:00	AAPL	Stock	18.875	18.9446	18.8286	18.8904	65400160.0
2012-12-13 14:00:00	AAPL	Stock	18.8912	18.9036	18.7786	18.8507	70207844.0
2012-12-13 15:00:00	AAPL	Stock	18.8464	18.9382	18.8075	18.9143	89457536.0
2012-12-13 16:00:00	AAPL	Stock	18.9251	19.2306	18.8425	18.8714	34014680.0
2012-12-13 17:00:00	AAPL	Stock	18.8714	18.8714	18.8304	18.8482	787528.0
2012-12-13 18:00:00	AAPL	Stock	18.8429	18.9	18.8429	18.8664	506324.0
2012-12-13 19:00:00	AAPL	Stock	18.8664	18.8746	18.825	18.8257	324772.0
2012-12-13 05:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	196.0
2012-12-13 08:00:00	MSFT	Stock	27.26	27.26	27.19	27.24	19664.0
2012-12-13 09:00:00	MSFT	Stock	27.25	27.52	27.2	27.36	4806317.0
2012-12-13 10:00:00	MSFT	Stock	27.36	27.46	27.3	27.41	4825835.0
2012-12-13 11:00:00	MSFT	Stock	27.405	27.41	27.075	27.14	5474217.0
2012-12-13 12:00:00	MSFT	Stock	27.14	27.15	27.01	27.02	6201745.0
2012-12-13 13:00:00	MSFT	Stock	27.02	27.09	26.98	27.03	5891885.0
2012-12-13 14:00:00	MSFT	Stock	27.03	27.08	26.95	27.08	3743346.0
2012-12-13 15:00:00	MSFT	Stock	27.075	27.2	27.01	27.11	10636774.0
2012-12-13 16:00:00	MSFT	Stock	27.1	27.224	27.038	27.14	1903823.0
2012-12-13 17:00:00	MSFT	Stock	27.11	27.15	27.06	27.06	5144.0
2012-12-13 18:00:00	MSFT	Stock	27.11	27.16	27.11	27.13	1826.0
2012-12-13 19:00:00	MSFT	Stock	27.13	27.13	27.1	27.1	8296.0
2012-12-13 09:00:00	NVDA	Stock	0.3113	0.3145	0.311	0.314	26340840.0
2012-12-13 10:00:00	NVDA	Stock	0.314	0.3193	0.314	0.3178	77085680.0
2012-12-13 11:00:00	NVDA	Stock	0.3176	0.3183	0.313	0.3163	51949560.0
2012-12-13 12:00:00	NVDA	Stock	0.3161	0.3163	0.3103	0.3128	46246360.0
2012-12-13 13:00:00	NVDA	Stock	0.3125	0.3138	0.3118	0.3138	32333480.0
2012-12-13 14:00:00	NVDA	Stock	0.3138	0.3143	0.3124	0.314	41205080.0
2012-12-13 15:00:00	NVDA	Stock	0.314	0.315	0.3123	0.3134	87743560.0
2012-12-13 16:00:00	NVDA	Stock	0.3134	0.3165	0.3115	0.315	13486120.0
2012-12-13 17:00:00	NVDA	Stock	0.3133	0.3133	0.3133	0.3133	15600.0
2012-12-13 18:00:00	NVDA	Stock	0.315	0.3163	0.314	0.314	208000.0
2012-12-13 05:00:00	AMZN	Stock	12.5455	12.5455	12.5455	12.5455	2000.0
2012-12-13 06:00:00	AMZN	Stock	12.55	12.55	12.545	12.545	4000.0
2012-12-13 07:00:00	AMZN	Stock	12.56	12.6	12.56	12.5755	8000.0
2012-12-13 08:00:00	AMZN	Stock	12.563	12.615	12.5625	12.5625	92060.0
2012-12-13 09:00:00	AMZN	Stock	12.575	12.5925	12.5255	12.5745	3585620.0
2012-12-13 10:00:00	AMZN	Stock	12.5722	12.727	12.563	12.6625	11575440.0
2012-12-13 11:00:00	AMZN	Stock	12.6625	12.687	12.5785	12.5985	4886220.0
2012-12-13 12:00:00	AMZN	Stock	12.598	12.61	12.5085	12.537	5566180.0
2012-12-13 13:00:00	AMZN	Stock	12.536	12.5875	12.501	12.5875	5344160.0
2012-12-13 14:00:00	AMZN	Stock	12.588	12.592	12.5265	12.543	4129360.0
2012-12-13 15:00:00	AMZN	Stock	12.546	12.6	12.521	12.5625	12209120.0

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

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