PREVIEW / stock_1hour / 2014-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-19.parquet
  size:    1.0 MB
  rows:    48,515
  symbols: 3,565

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
2014-11-19 04:00:00	AAPL	Stock	28.8475	28.8825	28.8475	28.8675	8400.0
2014-11-19 05:00:00	AAPL	Stock	28.865	28.865	28.85	28.86	28800.0
2014-11-19 06:00:00	AAPL	Stock	28.86	28.885	28.845	28.8525	64796.0
2014-11-19 07:00:00	AAPL	Stock	28.8625	28.875	28.8475	28.8575	119180.0
2014-11-19 08:00:00	AAPL	Stock	28.85	28.8825	28.8075	28.8375	398048.0
2014-11-19 09:00:00	AAPL	Stock	28.8375	28.935	28.665	28.7318	27698844.0
2014-11-19 10:00:00	AAPL	Stock	28.73	28.7475	28.525	28.5475	30271104.0
2014-11-19 11:00:00	AAPL	Stock	28.5475	28.6	28.45	28.575	20797148.0
2014-11-19 12:00:00	AAPL	Stock	28.5738	28.71	28.567	28.7	11449564.0
2014-11-19 13:00:00	AAPL	Stock	28.7	28.7638	28.6575	28.6928	13388892.0
2014-11-19 14:00:00	AAPL	Stock	28.69	28.785	28.6525	28.7012	14573260.0
2014-11-19 15:00:00	AAPL	Stock	28.7025	28.75	28.66	28.665	19358048.0
2014-11-19 16:00:00	AAPL	Stock	28.6675	28.7062	28.5692	28.6925	8192844.0
2014-11-19 17:00:00	AAPL	Stock	28.69	28.6975	28.6675	28.6675	230864.0
2014-11-19 18:00:00	AAPL	Stock	28.6825	28.6925	28.67	28.6775	28620.0
2014-11-19 19:00:00	AAPL	Stock	28.68	28.6875	28.6675	28.6825	143180.0
2014-11-19 06:00:00	MSFT	Stock	48.71	48.76	48.71	48.76	300.0
2014-11-19 07:00:00	MSFT	Stock	48.75	48.8	48.75	48.75	8210.0
2014-11-19 08:00:00	MSFT	Stock	48.75	48.75	48.67	48.67	5618.0
2014-11-19 09:00:00	MSFT	Stock	48.73	48.755	48.08	48.11	3645410.0
2014-11-19 10:00:00	MSFT	Stock	48.11	48.16	47.93	48.0	4260736.0
2014-11-19 11:00:00	MSFT	Stock	47.995	48.23	47.98	48.22	2137098.0
2014-11-19 12:00:00	MSFT	Stock	48.215	48.28	48.15	48.239	1533656.0
2014-11-19 13:00:00	MSFT	Stock	48.235	48.3	48.09	48.11	2064630.0
2014-11-19 14:00:00	MSFT	Stock	48.105	48.27	48.0	48.12	2768707.0
2014-11-19 15:00:00	MSFT	Stock	48.12	48.29	48.1	48.22	5394345.0
2014-11-19 16:00:00	MSFT	Stock	48.22	48.227	48.12	48.184	2543681.0
2014-11-19 17:00:00	MSFT	Stock	48.24	48.24	48.22	48.22	10478.0
2014-11-19 18:00:00	MSFT	Stock	48.23	48.24	48.23	48.24	600.0
2014-11-19 19:00:00	MSFT	Stock	48.2	48.24	48.2	48.24	200.0
2014-11-19 08:00:00	NVDA	Stock	0.5062	0.5065	0.5062	0.5065	98000.0
2014-11-19 09:00:00	NVDA	Stock	0.502	0.504	0.4988	0.5008	21956040.0
2014-11-19 10:00:00	NVDA	Stock	0.5008	0.5011	0.4958	0.4969	39308480.0
2014-11-19 11:00:00	NVDA	Stock	0.4968	0.499	0.495	0.4982	26437880.0
2014-11-19 12:00:00	NVDA	Stock	0.4981	0.4988	0.4978	0.4982	8378920.0
2014-11-19 13:00:00	NVDA	Stock	0.4982	0.4991	0.4978	0.4982	9592960.0
2014-11-19 14:00:00	NVDA	Stock	0.4985	0.4998	0.4975	0.4985	18348760.0
2014-11-19 15:00:00	NVDA	Stock	0.4982	0.5005	0.4978	0.5001	51350120.0
2014-11-19 16:00:00	NVDA	Stock	0.5003	0.5003	0.4986	0.4986	40779600.0
2014-11-19 19:00:00	NVDA	Stock	0.5013	0.5013	0.5013	0.5013	4000.0
2014-11-19 07:00:00	AMZN	Stock	16.305	16.305	16.305	16.305	7000.0
2014-11-19 08:00:00	AMZN	Stock	16.2705	16.4335	16.2705	16.425	142800.0
2014-11-19 09:00:00	AMZN	Stock	16.433	16.435	16.27	16.2965	12234100.0
2014-11-19 10:00:00	AMZN	Stock	16.2935	16.3365	16.201	16.2393	10613580.0
2014-11-19 11:00:00	AMZN	Stock	16.24	16.3865	16.2085	16.3325	8895360.0
2014-11-19 12:00:00	AMZN	Stock	16.331	16.3805	16.3285	16.3805	5554620.0
2014-11-19 13:00:00	AMZN	Stock	16.382	16.3925	16.3195	16.32	3797880.0
2014-11-19 14:00:00	AMZN	Stock	16.3185	16.3745	16.2555	16.2975	6326300.0
2014-11-19 15:00:00	AMZN	Stock	16.298	16.3412	16.2746	16.324	9563280.0
2014-11-19 16:00:00	AMZN	Stock	16.327	16.35	16.2837	16.3193	858140.0

> showing 50 of 48,515 rows — these rows as CSV

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