PREVIEW / stock_1hour / 2017-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-14.parquet
  size:    1.0 MB
  rows:    48,176
  symbols: 3,066

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
2017-03-14 04:00:00	AAPL	Stock	34.75	34.75	34.75	34.75	1152.0
2017-03-14 05:00:00	AAPL	Stock	34.75	34.75	34.75	34.75	980.0
2017-03-14 06:00:00	AAPL	Stock	34.7875	34.7875	34.7875	34.7875	400.0
2017-03-14 07:00:00	AAPL	Stock	34.79	34.7925	34.7675	34.7675	6000.0
2017-03-14 08:00:00	AAPL	Stock	34.8	34.8	34.7125	34.7375	85572.0
2017-03-14 09:00:00	AAPL	Stock	34.7475	34.9125	34.745	34.8625	11140408.0
2017-03-14 10:00:00	AAPL	Stock	34.8625	34.8625	34.71	34.76	9776368.0
2017-03-14 11:00:00	AAPL	Stock	34.758	34.8025	34.725	34.8013	6652584.0
2017-03-14 12:00:00	AAPL	Stock	34.8025	34.81	34.745	34.76	4906748.0
2017-03-14 13:00:00	AAPL	Stock	34.76	34.79	34.7375	34.7525	4745220.0
2017-03-14 14:00:00	AAPL	Stock	34.7512	34.76	34.7125	34.7398	4673440.0
2017-03-14 15:00:00	AAPL	Stock	34.7388	34.775	34.7275	34.745	7325124.0
2017-03-14 16:00:00	AAPL	Stock	34.7475	34.77	34.7475	34.75	4882500.0
2017-03-14 17:00:00	AAPL	Stock	34.7475	34.755	34.7475	34.755	6204.0
2017-03-14 18:00:00	AAPL	Stock	34.7375	34.75	34.7375	34.75	9728.0
2017-03-14 19:00:00	AAPL	Stock	34.7525	34.7525	34.735	34.7375	51300.0
2017-03-14 07:00:00	MSFT	Stock	64.52	64.52	64.52	64.52	230.0
2017-03-14 08:00:00	MSFT	Stock	64.71	64.71	64.52	64.61	6400.0
2017-03-14 09:00:00	MSFT	Stock	64.61	64.7	64.35	64.405	1525548.0
2017-03-14 10:00:00	MSFT	Stock	64.4	64.43	64.15	64.315	2423710.0
2017-03-14 11:00:00	MSFT	Stock	64.32	64.41	64.26	64.37	1395516.0
2017-03-14 12:00:00	MSFT	Stock	64.38	64.4	64.23	64.355	1185270.0
2017-03-14 13:00:00	MSFT	Stock	64.36	64.51	64.34	64.42	1094133.0
2017-03-14 14:00:00	MSFT	Stock	64.42	64.43	64.335	64.365	1012271.0
2017-03-14 15:00:00	MSFT	Stock	64.37	64.46	64.364	64.39	2047090.0
2017-03-14 16:00:00	MSFT	Stock	64.41	64.48	64.36	64.48	2279865.0
2017-03-14 04:00:00	NVDA	Stock	2.5485	2.5485	2.5485	2.5485	6360.0
2017-03-14 05:00:00	NVDA	Stock	2.5333	2.5333	2.5325	2.5325	24000.0
2017-03-14 06:00:00	NVDA	Stock	2.5413	2.5413	2.5413	2.5413	25640.0
2017-03-14 07:00:00	NVDA	Stock	2.5475	2.5788	2.5475	2.5672	936480.0
2017-03-14 08:00:00	NVDA	Stock	2.5638	2.5678	2.545	2.5573	3548200.0
2017-03-14 09:00:00	NVDA	Stock	2.5573	2.5688	2.5282	2.5318	103486800.0
2017-03-14 10:00:00	NVDA	Stock	2.5325	2.5437	2.5192	2.526	110841240.0
2017-03-14 11:00:00	NVDA	Stock	2.5258	2.529	2.5118	2.5215	81906360.0
2017-03-14 12:00:00	NVDA	Stock	2.5218	2.525	2.5165	2.5206	39742120.0
2017-03-14 13:00:00	NVDA	Stock	2.5205	2.55	2.5204	2.527	41602640.0
2017-03-14 14:00:00	NVDA	Stock	2.527	2.5325	2.5188	2.5225	36185440.0
2017-03-14 15:00:00	NVDA	Stock	2.5222	2.545	2.5222	2.5438	76655200.0
2017-03-14 16:00:00	NVDA	Stock	2.5445	2.5445	2.5413	2.5422	6535120.0
2017-03-14 17:00:00	NVDA	Stock	2.5422	2.5433	2.541	2.541	1141880.0
2017-03-14 18:00:00	NVDA	Stock	2.5413	2.5435	2.5403	2.5435	485600.0
2017-03-14 19:00:00	NVDA	Stock	2.5375	2.5435	2.5375	2.5435	145200.0
2017-03-14 04:00:00	AMZN	Stock	42.674	42.674	42.674	42.674	8220.0
2017-03-14 07:00:00	AMZN	Stock	42.6	42.6	42.6	42.6	2000.0
2017-03-14 08:00:00	AMZN	Stock	42.7295	42.7295	42.601	42.6375	28480.0
2017-03-14 09:00:00	AMZN	Stock	42.635	42.6875	42.49	42.525	5580040.0
2017-03-14 10:00:00	AMZN	Stock	42.5302	42.55	42.3775	42.4615	8514280.0
2017-03-14 11:00:00	AMZN	Stock	42.464	42.5335	42.4085	42.5055	5234640.0
2017-03-14 12:00:00	AMZN	Stock	42.5125	42.525	42.4313	42.4585	2881960.0
2017-03-14 13:00:00	AMZN	Stock	42.464	42.528	42.45	42.5033	2421040.0

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

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