PREVIEW / stock_1hour / 2012-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-21.parquet
  size:    1003 KB
  rows:    46,804
  symbols: 3,513

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-21 04:00:00	AAPL	Stock	18.5071	18.5071	18.2768	18.2857	617456.0
2012-12-21 05:00:00	AAPL	Stock	18.26	18.3036	18.26	18.2964	186172.0
2012-12-21 06:00:00	AAPL	Stock	18.3075	18.3921	18.3075	18.3875	93632.0
2012-12-21 07:00:00	AAPL	Stock	18.3393	18.3746	18.2321	18.3214	1654856.0
2012-12-21 08:00:00	AAPL	Stock	18.3214	18.375	18.2261	18.2946	6474356.0
2012-12-21 09:00:00	AAPL	Stock	18.2932	18.3464	18.2229	18.2982	172563104.0
2012-12-21 10:00:00	AAPL	Stock	18.2941	18.5	18.2736	18.4142	100263828.0
2012-12-21 11:00:00	AAPL	Stock	18.4132	18.4714	18.3321	18.3879	48905136.0
2012-12-21 12:00:00	AAPL	Stock	18.3821	18.3872	18.3218	18.3757	32503324.0
2012-12-21 13:00:00	AAPL	Stock	18.3783	18.4143	18.3361	18.3932	33009396.0
2012-12-21 14:00:00	AAPL	Stock	18.3934	18.4246	18.3668	18.4032	34176772.0
2012-12-21 15:00:00	AAPL	Stock	18.4029	18.5596	18.3807	18.5475	94314612.0
2012-12-21 16:00:00	AAPL	Stock	18.5436	18.5775	18.2863	18.57	58128168.0
2012-12-21 17:00:00	AAPL	Stock	18.5696	18.5804	18.5438	18.5743	729904.0
2012-12-21 18:00:00	AAPL	Stock	18.5714	18.5804	18.5714	18.575	207424.0
2012-12-21 19:00:00	AAPL	Stock	18.5729	18.5946	18.5729	18.5893	155400.0
2012-12-21 05:00:00	MSFT	Stock	27.38	27.38	27.17	27.17	5000.0
2012-12-21 06:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	200.0
2012-12-21 07:00:00	MSFT	Stock	27.37	27.38	27.23	27.25	4337.0
2012-12-21 08:00:00	MSFT	Stock	27.3	27.4	27.24	27.32	47947.0
2012-12-21 09:00:00	MSFT	Stock	27.32	27.48	27.1	27.25	32808628.0
2012-12-21 10:00:00	MSFT	Stock	27.25	27.27	27.14	27.172	7881554.0
2012-12-21 11:00:00	MSFT	Stock	27.18	27.19	27.05	27.144	6277313.0
2012-12-21 12:00:00	MSFT	Stock	27.14	27.16	27.0	27.06	5678998.0
2012-12-21 13:00:00	MSFT	Stock	27.06	27.22	27.05	27.13	6161112.0
2012-12-21 14:00:00	MSFT	Stock	27.14	27.24	27.13	27.22	5055109.0
2012-12-21 15:00:00	MSFT	Stock	27.22	27.49	27.15	27.49	12968171.0
2012-12-21 16:00:00	MSFT	Stock	27.48	27.654	27.066	27.49	19940651.0
2012-12-21 17:00:00	MSFT	Stock	27.46	27.5	27.45	27.5	14811.0
2012-12-21 18:00:00	MSFT	Stock	27.44	27.45	27.44	27.45	4200.0
2012-12-21 19:00:00	MSFT	Stock	27.45	27.5	27.45	27.5	1851.0
2012-12-21 08:00:00	NVDA	Stock	0.3103	0.312	0.31	0.3113	146080.0
2012-12-21 09:00:00	NVDA	Stock	0.3113	0.3118	0.3062	0.3093	134764480.0
2012-12-21 10:00:00	NVDA	Stock	0.3093	0.3109	0.308	0.308	55183880.0
2012-12-21 11:00:00	NVDA	Stock	0.308	0.3088	0.3052	0.3066	47480240.0
2012-12-21 12:00:00	NVDA	Stock	0.3068	0.308	0.306	0.3076	27790720.0
2012-12-21 13:00:00	NVDA	Stock	0.3075	0.3093	0.3073	0.3088	25169720.0
2012-12-21 14:00:00	NVDA	Stock	0.3088	0.3088	0.3075	0.3077	27680720.0
2012-12-21 15:00:00	NVDA	Stock	0.3078	0.3095	0.307	0.3093	75687840.0
2012-12-21 16:00:00	NVDA	Stock	0.3093	0.3098	0.3085	0.3088	56484040.0
2012-12-21 17:00:00	NVDA	Stock	0.3087	0.309	0.3087	0.309	454720.0
2012-12-21 19:00:00	NVDA	Stock	0.309	0.309	0.309	0.309	40000.0
2012-12-21 05:00:00	AMZN	Stock	12.89	12.89	12.8265	12.8265	18000.0
2012-12-21 06:00:00	AMZN	Stock	12.8455	12.8625	12.83	12.8625	18000.0
2012-12-21 07:00:00	AMZN	Stock	12.9075	12.925	12.8625	12.925	38220.0
2012-12-21 08:00:00	AMZN	Stock	12.912	12.9445	12.825	12.85	570560.0
2012-12-21 09:00:00	AMZN	Stock	12.8575	12.9	12.787	12.8235	37454600.0
2012-12-21 10:00:00	AMZN	Stock	12.8252	12.919	12.8105	12.841	12004920.0
2012-12-21 11:00:00	AMZN	Stock	12.8435	12.861	12.809	12.8442	8381520.0
2012-12-21 12:00:00	AMZN	Stock	12.8395	12.89	12.8155	12.8755	4992080.0

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

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