PREVIEW / stock_1hour / 2015-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-04.parquet
  size:    1.0 MB
  rows:    47,903
  symbols: 3,458

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
2015-08-04 04:00:00	AAPL	Stock	29.375	29.5375	29.35	29.4875	215456.0
2015-08-04 05:00:00	AAPL	Stock	29.5	29.5375	29.5	29.5375	64888.0
2015-08-04 06:00:00	AAPL	Stock	29.525	29.5325	29.4	29.4125	189148.0
2015-08-04 07:00:00	AAPL	Stock	29.4125	29.425	29.31	29.3525	564032.0
2015-08-04 08:00:00	AAPL	Stock	29.35	29.5125	29.2825	29.335	1395144.0
2015-08-04 09:00:00	AAPL	Stock	29.35	29.47	28.8775	28.9925	70936760.0
2015-08-04 10:00:00	AAPL	Stock	28.9958	29.0625	28.3125	28.4	132903916.0
2015-08-04 11:00:00	AAPL	Stock	28.4	28.8025	28.36	28.7825	74126816.0
2015-08-04 12:00:00	AAPL	Stock	28.7815	28.87	28.5375	28.625	38762176.0
2015-08-04 13:00:00	AAPL	Stock	28.6275	28.85	28.6025	28.6775	30807604.0
2015-08-04 14:00:00	AAPL	Stock	28.68	28.91	28.6675	28.9042	32997036.0
2015-08-04 15:00:00	AAPL	Stock	28.905	28.9625	28.54	28.6575	57125124.0
2015-08-04 16:00:00	AAPL	Stock	28.66	28.7662	28.5525	28.575	6928660.0
2015-08-04 17:00:00	AAPL	Stock	28.5625	28.826	28.5425	28.5425	704992.0
2015-08-04 18:00:00	AAPL	Stock	28.55	28.575	28.52	28.575	239764.0
2015-08-04 19:00:00	AAPL	Stock	28.575	28.575	28.445	28.45	689228.0
2015-08-04 08:00:00	MSFT	Stock	46.79	46.79	46.79	46.79	2000.0
2015-08-04 09:00:00	MSFT	Stock	46.79	47.33	46.68	47.24	2985662.0
2015-08-04 10:00:00	MSFT	Stock	47.235	47.535	47.22	47.41	5615544.0
2015-08-04 11:00:00	MSFT	Stock	47.402	47.52	47.35	47.395	3079044.0
2015-08-04 12:00:00	MSFT	Stock	47.38	47.59	47.29	47.29	2845677.0
2015-08-04 13:00:00	MSFT	Stock	47.3	47.63	47.27	47.39	2572168.0
2015-08-04 14:00:00	MSFT	Stock	47.38	47.67	47.31	47.662	2976378.0
2015-08-04 15:00:00	MSFT	Stock	47.67	47.71	47.53	47.55	7624963.0
2015-08-04 16:00:00	MSFT	Stock	47.55	48.3	46.81	47.59	2882792.0
2015-08-04 17:00:00	MSFT	Stock	47.6	47.6	47.54	47.55	69516.0
2015-08-04 19:00:00	MSFT	Stock	47.607	47.65	47.607	47.64	5900.0
2015-08-04 08:00:00	NVDA	Stock	0.5072	0.5072	0.5072	0.5072	4000.0
2015-08-04 09:00:00	NVDA	Stock	0.5055	0.5088	0.5035	0.5061	23341320.0
2015-08-04 10:00:00	NVDA	Stock	0.5061	0.5104	0.5048	0.5048	50047440.0
2015-08-04 11:00:00	NVDA	Stock	0.5049	0.5085	0.5043	0.5059	53610480.0
2015-08-04 12:00:00	NVDA	Stock	0.506	0.5075	0.5035	0.5053	15451480.0
2015-08-04 13:00:00	NVDA	Stock	0.5053	0.5082	0.5053	0.5075	19514120.0
2015-08-04 14:00:00	NVDA	Stock	0.5075	0.5105	0.506	0.5099	30492000.0
2015-08-04 15:00:00	NVDA	Stock	0.51	0.5108	0.5082	0.5093	47365840.0
2015-08-04 16:00:00	NVDA	Stock	0.5093	0.5093	0.5082	0.5082	11488520.0
2015-08-04 06:00:00	AMZN	Stock	26.74	26.74	26.725	26.725	6760.0
2015-08-04 07:00:00	AMZN	Stock	26.7255	26.7255	26.725	26.725	27120.0
2015-08-04 08:00:00	AMZN	Stock	26.725	26.725	26.6825	26.6825	9280.0
2015-08-04 09:00:00	AMZN	Stock	26.7195	26.7195	26.4585	26.5435	8648440.0
2015-08-04 10:00:00	AMZN	Stock	26.5425	26.7575	26.511	26.6135	9428020.0
2015-08-04 11:00:00	AMZN	Stock	26.622	26.8475	26.593	26.7555	6191580.0
2015-08-04 12:00:00	AMZN	Stock	26.7415	26.8255	26.5908	26.627	4850420.0
2015-08-04 13:00:00	AMZN	Stock	26.6175	26.8015	26.585	26.6275	4880980.0
2015-08-04 14:00:00	AMZN	Stock	26.605	26.748	26.533	26.693	6050500.0
2015-08-04 15:00:00	AMZN	Stock	26.7065	26.7445	26.577	26.592	10644340.0
2015-08-04 16:00:00	AMZN	Stock	26.595	26.5995	26.55	26.55	932960.0
2015-08-04 17:00:00	AMZN	Stock	26.5025	26.595	26.5025	26.595	23300.0
2015-08-04 18:00:00	AMZN	Stock	26.5425	26.585	26.525	26.585	110640.0
2015-08-04 09:00:00	GOOGL	Stock	33.2415	33.4	33.0852	33.1085	2450940.0

> showing 50 of 47,903 rows — these rows as CSV

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