PREVIEW / stock_1hour / 2013-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-11.parquet
  size:    941 KB
  rows:    44,364
  symbols: 3,464

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
2013-01-11 04:00:00	AAPL	Stock	18.7321	18.7321	18.7143	18.7143	5600.0
2013-01-11 05:00:00	AAPL	Stock	18.7054	18.7057	18.7054	18.7054	152012.0
2013-01-11 06:00:00	AAPL	Stock	18.6964	18.7214	18.6961	18.6961	33600.0
2013-01-11 07:00:00	AAPL	Stock	18.6964	18.7036	18.6071	18.6071	361984.0
2013-01-11 08:00:00	AAPL	Stock	18.6225	18.6964	18.5589	18.5846	2637208.0
2013-01-11 09:00:00	AAPL	Stock	18.5807	18.7614	18.5364	18.6434	73704372.0
2013-01-11 10:00:00	AAPL	Stock	18.6457	18.6643	18.545	18.6411	51842112.0
2013-01-11 11:00:00	AAPL	Stock	18.6414	18.6525	18.55	18.6161	32157440.0
2013-01-11 12:00:00	AAPL	Stock	18.6204	18.6339	18.5857	18.6082	19201560.0
2013-01-11 13:00:00	AAPL	Stock	18.6093	18.6996	18.5943	18.6368	38613204.0
2013-01-11 14:00:00	AAPL	Stock	18.6368	18.6807	18.6	18.6214	32305448.0
2013-01-11 15:00:00	AAPL	Stock	18.6221	18.6314	18.5532	18.5757	67024636.0
2013-01-11 16:00:00	AAPL	Stock	18.5783	18.6179	18.5679	18.5732	26225528.0
2013-01-11 17:00:00	AAPL	Stock	18.5764	18.5821	18.5732	18.5739	265272.0
2013-01-11 18:00:00	AAPL	Stock	18.575	18.58	18.5736	18.5796	136808.0
2013-01-11 19:00:00	AAPL	Stock	18.58	18.5893	18.5764	18.5893	218176.0
2013-01-11 04:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	100.0
2013-01-11 05:00:00	MSFT	Stock	26.48	26.49	26.44	26.44	5600.0
2013-01-11 06:00:00	MSFT	Stock	26.47	26.47	26.47	26.47	2200.0
2013-01-11 07:00:00	MSFT	Stock	26.47	26.57	26.45	26.56	5600.0
2013-01-11 08:00:00	MSFT	Stock	26.46	26.5	26.4	26.49	29426.0
2013-01-11 09:00:00	MSFT	Stock	26.48	26.5	26.28	26.325	7890137.0
2013-01-11 10:00:00	MSFT	Stock	26.325	26.47	26.32	26.445	8757051.0
2013-01-11 11:00:00	MSFT	Stock	26.445	26.75	26.44	26.65	8061036.0
2013-01-11 12:00:00	MSFT	Stock	26.65	26.74	26.64	26.726	4983323.0
2013-01-11 13:00:00	MSFT	Stock	26.725	26.78	26.71	26.72	4699083.0
2013-01-11 14:00:00	MSFT	Stock	26.725	26.8	26.7	26.795	3845637.0
2013-01-11 15:00:00	MSFT	Stock	26.8	26.93	26.76	26.83	13110034.0
2013-01-11 16:00:00	MSFT	Stock	26.83	26.85	26.479	26.8	3586057.0
2013-01-11 17:00:00	MSFT	Stock	26.8	26.84	26.8	26.84	1637.0
2013-01-11 18:00:00	MSFT	Stock	26.81	26.84	26.81	26.84	2149.0
2013-01-11 19:00:00	MSFT	Stock	26.84	26.84	26.84	26.84	5010.0
2013-01-11 08:00:00	NVDA	Stock	0.3058	0.3058	0.3058	0.3058	456000.0
2013-01-11 09:00:00	NVDA	Stock	0.3073	0.3073	0.3042	0.3045	52225960.0
2013-01-11 10:00:00	NVDA	Stock	0.3045	0.305	0.3028	0.3041	104215480.0
2013-01-11 11:00:00	NVDA	Stock	0.3042	0.3052	0.3035	0.3042	60033000.0
2013-01-11 12:00:00	NVDA	Stock	0.3042	0.3042	0.3025	0.3034	47453560.0
2013-01-11 13:00:00	NVDA	Stock	0.3032	0.3039	0.3022	0.3029	62510040.0
2013-01-11 14:00:00	NVDA	Stock	0.303	0.3042	0.3025	0.3038	52753920.0
2013-01-11 15:00:00	NVDA	Stock	0.3036	0.3062	0.3028	0.305	113696480.0
2013-01-11 16:00:00	NVDA	Stock	0.305	0.3061	0.304	0.305	17344920.0
2013-01-11 17:00:00	NVDA	Stock	0.3058	0.306	0.3058	0.306	100000.0
2013-01-11 19:00:00	NVDA	Stock	0.3055	0.3055	0.3055	0.3055	44000.0
2013-01-11 05:00:00	AMZN	Stock	13.2495	13.276	13.2495	13.276	8000.0
2013-01-11 07:00:00	AMZN	Stock	13.249	13.2645	13.248	13.248	8000.0
2013-01-11 08:00:00	AMZN	Stock	13.24	13.251	13.22	13.2275	76600.0
2013-01-11 09:00:00	AMZN	Stock	13.2275	13.338	13.2055	13.2935	7721760.0
2013-01-11 10:00:00	AMZN	Stock	13.294	13.382	13.289	13.3675	7562760.0
2013-01-11 11:00:00	AMZN	Stock	13.361	13.376	13.2925	13.368	7233820.0
2013-01-11 12:00:00	AMZN	Stock	13.3675	13.3745	13.343	13.363	3640140.0

> showing 50 of 44,364 rows — these rows as CSV

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