PREVIEW / stock_1hour / 2014-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-03.parquet
  size:    1.0 MB
  rows:    49,205
  symbols: 3,534

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-04-03 06:00:00	AAPL	Stock	19.3929	19.3929	19.3918	19.3918	5600.0
2014-04-03 07:00:00	AAPL	Stock	19.3779	19.3779	19.295	19.3568	69748.0
2014-04-03 08:00:00	AAPL	Stock	19.3464	19.375	19.3143	19.32	1013880.0
2014-04-03 09:00:00	AAPL	Stock	19.3246	19.375	19.3075	19.3668	20074712.0
2014-04-03 10:00:00	AAPL	Stock	19.3657	19.3661	19.275	19.2846	28082544.0
2014-04-03 11:00:00	AAPL	Stock	19.2814	19.3011	19.2504	19.2632	16535204.0
2014-04-03 12:00:00	AAPL	Stock	19.2625	19.2821	19.2014	19.2293	17467324.0
2014-04-03 13:00:00	AAPL	Stock	19.2286	19.2804	19.225	19.2618	11250344.0
2014-04-03 14:00:00	AAPL	Stock	19.2607	19.2639	19.2123	19.2586	13493592.0
2014-04-03 15:00:00	AAPL	Stock	19.2561	19.2786	19.2325	19.2437	18529252.0
2014-04-03 16:00:00	AAPL	Stock	19.2425	19.2776	19.2386	19.2571	5274248.0
2014-04-03 17:00:00	AAPL	Stock	19.2521	19.4087	19.2425	19.255	460740.0
2014-04-03 18:00:00	AAPL	Stock	19.2518	19.2554	19.2425	19.25	194152.0
2014-04-03 19:00:00	AAPL	Stock	19.2554	19.2604	19.2504	19.2604	15960.0
2014-04-03 05:00:00	MSFT	Stock	41.31	41.39	41.31	41.39	200.0
2014-04-03 06:00:00	MSFT	Stock	41.35	41.35	41.35	41.35	500.0
2014-04-03 07:00:00	MSFT	Stock	41.36	41.36	41.35	41.35	600.0
2014-04-03 08:00:00	MSFT	Stock	41.38	41.4	41.29	41.4	6065.0
2014-04-03 09:00:00	MSFT	Stock	41.39	41.43	40.85	41.09	5158502.0
2014-04-03 10:00:00	MSFT	Stock	41.08	41.09	40.87	41.03	4310823.0
2014-04-03 11:00:00	MSFT	Stock	41.03	41.1	40.86	40.895	2608005.0
2014-04-03 12:00:00	MSFT	Stock	40.895	40.91	40.71	40.8	2234521.0
2014-04-03 13:00:00	MSFT	Stock	40.79	41.04	40.79	40.99	2720994.0
2014-04-03 14:00:00	MSFT	Stock	40.995	41.01	40.845	40.939	2340162.0
2014-04-03 15:00:00	MSFT	Stock	40.945	41.03	40.91	41.01	6002831.0
2014-04-03 16:00:00	MSFT	Stock	41.0	41.02	40.95	40.99	1016885.0
2014-04-03 17:00:00	MSFT	Stock	40.99	41.01	40.99	41.01	144010.0
2014-04-03 18:00:00	MSFT	Stock	40.92	41.0	40.92	41.0	9890.0
2014-04-03 09:00:00	NVDA	Stock	0.4643	0.479	0.464	0.4768	145750320.0
2014-04-03 10:00:00	NVDA	Stock	0.4766	0.4796	0.4718	0.4732	134199480.0
2014-04-03 11:00:00	NVDA	Stock	0.4735	0.4742	0.47	0.4725	37288720.0
2014-04-03 12:00:00	NVDA	Stock	0.4724	0.4738	0.4702	0.4713	29111400.0
2014-04-03 13:00:00	NVDA	Stock	0.4713	0.4715	0.4678	0.4689	37674160.0
2014-04-03 14:00:00	NVDA	Stock	0.4689	0.4711	0.4658	0.4676	64486480.0
2014-04-03 15:00:00	NVDA	Stock	0.4678	0.4698	0.4675	0.468	103243480.0
2014-04-03 16:00:00	NVDA	Stock	0.4683	0.4719	0.4682	0.4685	21400000.0
2014-04-03 17:00:00	NVDA	Stock	0.4683	0.4683	0.4683	0.4683	391840.0
2014-04-03 19:00:00	NVDA	Stock	0.4685	0.4685	0.4685	0.4685	116000.0
2014-04-03 04:00:00	AMZN	Stock	17.13	17.13	17.13	17.13	2000.0
2014-04-03 05:00:00	AMZN	Stock	17.13	17.13	17.13	17.13	2000.0
2014-04-03 06:00:00	AMZN	Stock	17.13	17.13	17.13	17.13	2000.0
2014-04-03 07:00:00	AMZN	Stock	17.1425	17.154	17.071	17.0735	99220.0
2014-04-03 08:00:00	AMZN	Stock	17.064	17.1	17.064	17.074	110840.0
2014-04-03 09:00:00	AMZN	Stock	17.0745	17.13	16.73	16.843	17755980.0
2014-04-03 10:00:00	AMZN	Stock	16.8445	16.8635	16.6845	16.827	18864780.0
2014-04-03 11:00:00	AMZN	Stock	16.8335	16.8345	16.629	16.631	14200080.0
2014-04-03 12:00:00	AMZN	Stock	16.6325	16.693	16.423	16.4509	22239640.0
2014-04-03 13:00:00	AMZN	Stock	16.45	16.648	16.45	16.6275	11813800.0
2014-04-03 14:00:00	AMZN	Stock	16.6235	16.641	16.444	16.612	12007620.0
2014-04-03 15:00:00	AMZN	Stock	16.6081	16.7085	16.594	16.681	16836280.0

> showing 50 of 49,205 rows — these rows as CSV

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