PREVIEW / stock_1hour / 2015-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-03.parquet
  size:    1.0 MB
  rows:    48,027
  symbols: 3,447

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-09-03 04:00:00	AAPL	Stock	28.1475	28.325	28.1475	28.2875	46660.0
2015-09-03 05:00:00	AAPL	Stock	28.28	28.375	28.235	28.25	59832.0
2015-09-03 06:00:00	AAPL	Stock	28.2375	28.285	28.1875	28.23	123576.0
2015-09-03 07:00:00	AAPL	Stock	28.215	28.2525	28.18	28.2	375048.0
2015-09-03 08:00:00	AAPL	Stock	28.1875	28.2875	28.1275	28.2	1545992.0
2015-09-03 09:00:00	AAPL	Stock	28.1875	28.195	27.82	27.8925	31071488.0
2015-09-03 10:00:00	AAPL	Stock	27.8925	28.095	27.87	28.0325	29837640.0
2015-09-03 11:00:00	AAPL	Stock	28.0338	28.115	27.8375	27.925	25177676.0
2015-09-03 12:00:00	AAPL	Stock	27.9225	27.9825	27.7675	27.8025	18647356.0
2015-09-03 13:00:00	AAPL	Stock	27.8025	27.8125	27.51	27.515	27454604.0
2015-09-03 14:00:00	AAPL	Stock	27.5175	27.7875	27.5125	27.6912	23585148.0
2015-09-03 15:00:00	AAPL	Stock	27.6925	27.7575	27.525	27.585	30675520.0
2015-09-03 16:00:00	AAPL	Stock	27.5925	28.0135	27.575	27.5925	7013548.0
2015-09-03 17:00:00	AAPL	Stock	27.6075	27.6075	27.5375	27.5475	155392.0
2015-09-03 18:00:00	AAPL	Stock	27.5475	27.6	27.54	27.5625	129744.0
2015-09-03 19:00:00	AAPL	Stock	27.57	27.605	27.5125	27.5875	109744.0
2015-09-03 04:00:00	MSFT	Stock	43.48	43.5	43.48	43.5	300.0
2015-09-03 07:00:00	MSFT	Stock	43.4	43.4	43.4	43.4	1050.0
2015-09-03 08:00:00	MSFT	Stock	43.45	43.79	43.45	43.62	30326.0
2015-09-03 09:00:00	MSFT	Stock	43.55	43.98	43.27	43.755	4394693.0
2015-09-03 10:00:00	MSFT	Stock	43.76	43.91	43.65	43.905	3727024.0
2015-09-03 11:00:00	MSFT	Stock	43.9	43.96	43.625	43.69	2655368.0
2015-09-03 12:00:00	MSFT	Stock	43.69	43.84	43.56	43.71	2191576.0
2015-09-03 13:00:00	MSFT	Stock	43.72	43.74	43.43	43.5	3057054.0
2015-09-03 14:00:00	MSFT	Stock	43.5	43.72	43.4	43.64	2430397.0
2015-09-03 15:00:00	MSFT	Stock	43.645	43.72	43.34	43.5	6378040.0
2015-09-03 16:00:00	MSFT	Stock	43.5	43.5	43.43	43.43	1915836.0
2015-09-03 18:00:00	MSFT	Stock	43.48	43.5	43.42	43.42	789.0
2015-09-03 19:00:00	MSFT	Stock	43.44	43.44	43.42	43.42	3020.0
2015-09-03 09:00:00	NVDA	Stock	0.56	0.5656	0.5592	0.5625	28887760.0
2015-09-03 10:00:00	NVDA	Stock	0.5624	0.5662	0.5615	0.5652	41775280.0
2015-09-03 11:00:00	NVDA	Stock	0.5652	0.5659	0.5618	0.5625	26791680.0
2015-09-03 12:00:00	NVDA	Stock	0.5625	0.5638	0.558	0.5589	18687320.0
2015-09-03 13:00:00	NVDA	Stock	0.559	0.5602	0.556	0.5576	19813000.0
2015-09-03 14:00:00	NVDA	Stock	0.5575	0.5605	0.557	0.5588	21760880.0
2015-09-03 15:00:00	NVDA	Stock	0.5588	0.5598	0.5558	0.5569	89857520.0
2015-09-03 16:00:00	NVDA	Stock	0.5568	0.5572	0.5568	0.5572	8108760.0
2015-09-03 06:00:00	AMZN	Stock	25.727	25.727	25.727	25.727	5000.0
2015-09-03 07:00:00	AMZN	Stock	25.675	25.7	25.645	25.7	47100.0
2015-09-03 08:00:00	AMZN	Stock	25.7	25.7705	25.65	25.65	331800.0
2015-09-03 09:00:00	AMZN	Stock	25.6375	25.792	25.4595	25.4993	10818040.0
2015-09-03 10:00:00	AMZN	Stock	25.5095	25.7115	25.489	25.6758	6161640.0
2015-09-03 11:00:00	AMZN	Stock	25.685	25.7694	25.5075	25.5505	6158940.0
2015-09-03 12:00:00	AMZN	Stock	25.5675	25.6615	25.4625	25.4945	5388740.0
2015-09-03 13:00:00	AMZN	Stock	25.4975	25.5165	25.253	25.262	5210180.0
2015-09-03 14:00:00	AMZN	Stock	25.2625	25.42	25.1285	25.369	6127440.0
2015-09-03 15:00:00	AMZN	Stock	25.376	25.425	25.1555	25.2485	10092720.0
2015-09-03 16:00:00	AMZN	Stock	25.236	25.738	25.2	25.236	1924160.0
2015-09-03 17:00:00	AMZN	Stock	25.2475	25.2475	25.2	25.2	10000.0
2015-09-03 18:00:00	AMZN	Stock	25.201	25.2225	25.201	25.2225	12000.0

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

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