PREVIEW / stock_1hour / 2014-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-01.parquet
  size:    1.1 MB
  rows:    49,776
  symbols: 3,561

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-12-01 04:00:00	AAPL	Stock	29.625	29.6575	29.6	29.6575	20000.0
2014-12-01 05:00:00	AAPL	Stock	29.67	29.67	29.635	29.635	8400.0
2014-12-01 06:00:00	AAPL	Stock	29.6375	29.6375	29.6375	29.6375	2000.0
2014-12-01 07:00:00	AAPL	Stock	29.6625	29.7625	29.645	29.645	138728.0
2014-12-01 08:00:00	AAPL	Stock	29.6575	29.74	29.605	29.64	832964.0
2014-12-01 09:00:00	AAPL	Stock	29.6475	29.8125	27.8175	28.955	92974820.0
2014-12-01 10:00:00	AAPL	Stock	28.9575	29.125	28.605	28.8205	73077468.0
2014-12-01 11:00:00	AAPL	Stock	28.825	29.0575	28.8175	28.8925	31203068.0
2014-12-01 12:00:00	AAPL	Stock	28.895	28.955	28.83	28.9225	19225020.0
2014-12-01 13:00:00	AAPL	Stock	28.9225	29.1175	28.9225	29.045	21262980.0
2014-12-01 14:00:00	AAPL	Stock	29.045	29.0475	28.6725	28.7925	28678028.0
2014-12-01 15:00:00	AAPL	Stock	28.7975	28.85	28.6125	28.7675	38291520.0
2014-12-01 16:00:00	AAPL	Stock	28.7675	28.9332	28.7232	28.7575	9512700.0
2014-12-01 17:00:00	AAPL	Stock	28.7575	28.7725	28.7325	28.7575	265784.0
2014-12-01 18:00:00	AAPL	Stock	28.76	28.7675	28.7375	28.74	473064.0
2014-12-01 19:00:00	AAPL	Stock	28.7375	28.7725	28.7325	28.75	64720.0
2014-12-01 04:00:00	MSFT	Stock	47.41	47.7	46.92	47.7	720.0
2014-12-01 07:00:00	MSFT	Stock	47.75	47.75	47.7	47.71	2100.0
2014-12-01 08:00:00	MSFT	Stock	47.76	47.76	47.7	47.7	2450.0
2014-12-01 09:00:00	MSFT	Stock	47.73	48.27	47.71	48.0	4100726.0
2014-12-01 10:00:00	MSFT	Stock	48.0	48.5	47.91	48.33	4230057.0
2014-12-01 11:00:00	MSFT	Stock	48.33	48.43	48.23	48.39	2528177.0
2014-12-01 12:00:00	MSFT	Stock	48.38	48.72	48.375	48.71	2770283.0
2014-12-01 13:00:00	MSFT	Stock	48.71	48.78	48.57	48.605	2334095.0
2014-12-01 14:00:00	MSFT	Stock	48.605	48.63	48.465	48.62	2225847.0
2014-12-01 15:00:00	MSFT	Stock	48.62	48.71	48.59	48.64	6100912.0
2014-12-01 16:00:00	MSFT	Stock	48.64	48.71	47.81	48.62	4867027.0
2014-12-01 17:00:00	MSFT	Stock	48.614	48.614	48.56	48.56	44387.0
2014-12-01 18:00:00	MSFT	Stock	48.57	48.57	48.56	48.56	679.0
2014-12-01 19:00:00	MSFT	Stock	48.59	48.6	48.59	48.6	1776.0
2014-12-01 08:00:00	NVDA	Stock	0.5242	0.5242	0.5242	0.5242	12744000.0
2014-12-01 09:00:00	NVDA	Stock	0.522	0.525	0.5202	0.5213	21524440.0
2014-12-01 10:00:00	NVDA	Stock	0.5218	0.524	0.5142	0.515	29745080.0
2014-12-01 11:00:00	NVDA	Stock	0.5148	0.5171	0.5138	0.514	22289320.0
2014-12-01 12:00:00	NVDA	Stock	0.514	0.5175	0.514	0.517	10955040.0
2014-12-01 13:00:00	NVDA	Stock	0.5173	0.518	0.5165	0.5168	12321520.0
2014-12-01 14:00:00	NVDA	Stock	0.5168	0.5171	0.514	0.5158	11172880.0
2014-12-01 15:00:00	NVDA	Stock	0.5158	0.5178	0.514	0.5145	52533200.0
2014-12-01 16:00:00	NVDA	Stock	0.5145	0.5152	0.5145	0.5145	10653560.0
2014-12-01 17:00:00	NVDA	Stock	0.5144	0.5179	0.5144	0.5145	366360.0
2014-12-01 18:00:00	NVDA	Stock	0.5145	0.5145	0.5145	0.5145	5840.0
2014-12-01 07:00:00	AMZN	Stock	16.9175	16.9175	16.8495	16.85	26400.0
2014-12-01 08:00:00	AMZN	Stock	16.932	16.932	16.85	16.925	568820.0
2014-12-01 09:00:00	AMZN	Stock	16.925	17.032	16.65	16.7015	14760680.0
2014-12-01 10:00:00	AMZN	Stock	16.6961	16.7374	16.335	16.4028	21240400.0
2014-12-01 11:00:00	AMZN	Stock	16.4065	16.5125	16.375	16.383	10191680.0
2014-12-01 12:00:00	AMZN	Stock	16.38	16.4915	16.373	16.4875	6766180.0
2014-12-01 13:00:00	AMZN	Stock	16.4895	16.5457	16.456	16.4863	5985660.0
2014-12-01 14:00:00	AMZN	Stock	16.482	16.488	16.35	16.3855	9441140.0
2014-12-01 15:00:00	AMZN	Stock	16.3815	16.424	16.2965	16.3	18352140.0

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

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