PREVIEW / stock_1hour / 2016-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-19.parquet
  size:    1.0 MB
  rows:    47,946
  symbols: 3,258

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
2016-08-19 04:00:00	AAPL	Stock	27.255	27.255	27.1975	27.1975	8944.0
2016-08-19 05:00:00	AAPL	Stock	27.2225	27.2225	27.215	27.215	2400.0
2016-08-19 06:00:00	AAPL	Stock	27.25	27.2525	27.24	27.24	5904.0
2016-08-19 07:00:00	AAPL	Stock	27.2425	27.25	27.225	27.2375	52560.0
2016-08-19 08:00:00	AAPL	Stock	27.22	27.265	27.22	27.25	171004.0
2016-08-19 09:00:00	AAPL	Stock	27.25	27.2675	27.09	27.205	20499680.0
2016-08-19 10:00:00	AAPL	Stock	27.205	27.3475	27.1688	27.3435	18158268.0
2016-08-19 11:00:00	AAPL	Stock	27.3438	27.3975	27.3225	27.393	10987300.0
2016-08-19 12:00:00	AAPL	Stock	27.395	27.4225	27.2975	27.33	9399356.0
2016-08-19 13:00:00	AAPL	Stock	27.33	27.335	27.2875	27.3112	7962612.0
2016-08-19 14:00:00	AAPL	Stock	27.31	27.335	27.265	27.2962	7841452.0
2016-08-19 15:00:00	AAPL	Stock	27.2975	27.35	27.29	27.34	12445328.0
2016-08-19 16:00:00	AAPL	Stock	27.3388	27.39	27.3	27.35	6313400.0
2016-08-19 17:00:00	AAPL	Stock	27.36	27.375	27.345	27.3525	65040.0
2016-08-19 18:00:00	AAPL	Stock	27.345	27.3675	27.34	27.34	242564.0
2016-08-19 19:00:00	AAPL	Stock	27.3525	27.3625	27.35	27.355	19216.0
2016-08-19 04:00:00	MSFT	Stock	57.5	57.5	57.5	57.5	2000.0
2016-08-19 07:00:00	MSFT	Stock	57.42	57.43	57.42	57.43	400.0
2016-08-19 08:00:00	MSFT	Stock	57.45	57.47	57.45	57.46	11599.0
2016-08-19 09:00:00	MSFT	Stock	57.5	57.5	57.244	57.28	3513794.0
2016-08-19 10:00:00	MSFT	Stock	57.28	57.73	57.2	57.605	2632138.0
2016-08-19 11:00:00	MSFT	Stock	57.6	57.71	57.585	57.68	1360222.0
2016-08-19 12:00:00	MSFT	Stock	57.675	57.725	57.4	57.46	1270408.0
2016-08-19 13:00:00	MSFT	Stock	57.45	57.57	57.42	57.505	1204648.0
2016-08-19 14:00:00	MSFT	Stock	57.505	57.62	57.5	57.594	1081102.0
2016-08-19 15:00:00	MSFT	Stock	57.6	57.68	57.56	57.62	2486915.0
2016-08-19 16:00:00	MSFT	Stock	57.61	57.62	57.52	57.53	2792413.0
2016-08-19 04:00:00	NVDA	Stock	1.5525	1.5525	1.5525	1.5525	36000.0
2016-08-19 05:00:00	NVDA	Stock	1.5475	1.5475	1.5475	1.5475	4000.0
2016-08-19 06:00:00	NVDA	Stock	1.5475	1.5475	1.5475	1.5475	16000.0
2016-08-19 07:00:00	NVDA	Stock	1.5475	1.5475	1.5475	1.5475	20000.0
2016-08-19 08:00:00	NVDA	Stock	1.55	1.5525	1.5405	1.5432	4495800.0
2016-08-19 09:00:00	NVDA	Stock	1.5438	1.5682	1.5438	1.564	49211280.0
2016-08-19 10:00:00	NVDA	Stock	1.5643	1.5678	1.5543	1.5546	56436040.0
2016-08-19 11:00:00	NVDA	Stock	1.5548	1.563	1.5538	1.5613	38653400.0
2016-08-19 12:00:00	NVDA	Stock	1.5611	1.5624	1.5544	1.5554	23237400.0
2016-08-19 13:00:00	NVDA	Stock	1.5552	1.5602	1.554	1.5598	25705680.0
2016-08-19 14:00:00	NVDA	Stock	1.5598	1.5615	1.5575	1.5602	23029720.0
2016-08-19 15:00:00	NVDA	Stock	1.5605	1.5608	1.5552	1.5563	50974000.0
2016-08-19 16:00:00	NVDA	Stock	1.5565	1.559	1.555	1.5568	6679760.0
2016-08-19 17:00:00	NVDA	Stock	1.5575	1.5605	1.5575	1.5605	68560.0
2016-08-19 18:00:00	NVDA	Stock	1.5588	1.56	1.5588	1.56	106000.0
2016-08-19 19:00:00	NVDA	Stock	1.5578	1.56	1.5578	1.56	172000.0
2016-08-19 06:00:00	AMZN	Stock	38.1255	38.1265	38.125	38.125	6000.0
2016-08-19 07:00:00	AMZN	Stock	38.125	38.133	38.101	38.12	62800.0
2016-08-19 08:00:00	AMZN	Stock	38.137	38.137	38.0	38.053	80840.0
2016-08-19 09:00:00	AMZN	Stock	38.0995	38.131	37.885	37.9345	12439920.0
2016-08-19 10:00:00	AMZN	Stock	37.935	38.016	37.8445	37.9275	7291040.0
2016-08-19 11:00:00	AMZN	Stock	37.9295	37.9975	37.925	37.964	4002100.0
2016-08-19 12:00:00	AMZN	Stock	37.96	37.989	37.8755	37.896	2864700.0

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

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