PREVIEW / stock_1hour / 2017-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-04.parquet
  size:    1.1 MB
  rows:    48,658
  symbols: 3,052

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-05-04 04:00:00	AAPL	Stock	36.72	36.72	36.7125	36.7125	800.0
2017-05-04 05:00:00	AAPL	Stock	36.7425	36.775	36.7275	36.775	7720.0
2017-05-04 06:00:00	AAPL	Stock	36.8225	36.84	36.7875	36.84	17348.0
2017-05-04 07:00:00	AAPL	Stock	36.8475	36.8625	36.7725	36.795	142224.0
2017-05-04 08:00:00	AAPL	Stock	36.8475	36.85	36.635	36.635	316200.0
2017-05-04 09:00:00	AAPL	Stock	36.635	36.785	36.46	36.5405	17869028.0
2017-05-04 10:00:00	AAPL	Stock	36.5382	36.61	36.5125	36.5675	12079568.0
2017-05-04 11:00:00	AAPL	Stock	36.5675	36.6225	36.53	36.5485	9942292.0
2017-05-04 12:00:00	AAPL	Stock	36.55	36.6415	36.4525	36.63	10603880.0
2017-05-04 13:00:00	AAPL	Stock	36.63	36.635	36.5625	36.6093	5769700.0
2017-05-04 14:00:00	AAPL	Stock	36.61	36.6475	36.55	36.59	7328348.0
2017-05-04 15:00:00	AAPL	Stock	36.59	36.6675	36.58	36.635	12470956.0
2017-05-04 16:00:00	AAPL	Stock	36.6325	36.655	36.6175	36.6375	7454236.0
2017-05-04 17:00:00	AAPL	Stock	36.6325	36.6575	36.6325	36.6575	28876.0
2017-05-04 18:00:00	AAPL	Stock	36.6425	36.65	36.6375	36.6375	8968.0
2017-05-04 19:00:00	AAPL	Stock	36.6425	36.65	36.6375	36.65	23116.0
2017-05-04 05:00:00	MSFT	Stock	69.14	69.14	69.14	69.14	111.0
2017-05-04 08:00:00	MSFT	Stock	68.96	69.37	68.96	69.07	1787.0
2017-05-04 09:00:00	MSFT	Stock	69.05	69.12	68.7	68.79	2093086.0
2017-05-04 10:00:00	MSFT	Stock	68.79	68.9	68.71	68.815	3623244.0
2017-05-04 11:00:00	MSFT	Stock	68.811	68.94	68.75	68.783	2555497.0
2017-05-04 12:00:00	MSFT	Stock	68.785	68.85	68.64	68.84	2048915.0
2017-05-04 13:00:00	MSFT	Stock	68.84	68.89	68.78	68.8	1767402.0
2017-05-04 14:00:00	MSFT	Stock	68.807	68.88	68.705	68.785	2460605.0
2017-05-04 15:00:00	MSFT	Stock	68.785	68.89	68.705	68.81	4020200.0
2017-05-04 16:00:00	MSFT	Stock	68.81	68.82	68.8	68.81	1186166.0
2017-05-04 17:00:00	MSFT	Stock	68.8	68.8	68.8	68.8	2000.0
2017-05-04 18:00:00	MSFT	Stock	68.81	68.81	68.81	68.81	190.0
2017-05-04 19:00:00	MSFT	Stock	68.8	68.8	68.8	68.8	101.0
2017-05-04 08:00:00	NVDA	Stock	2.6098	2.61	2.6075	2.6075	145160.0
2017-05-04 09:00:00	NVDA	Stock	2.605	2.6238	2.5968	2.5985	26101560.0
2017-05-04 10:00:00	NVDA	Stock	2.5982	2.6158	2.5898	2.5988	48351720.0
2017-05-04 11:00:00	NVDA	Stock	2.599	2.611	2.5965	2.605	22483000.0
2017-05-04 12:00:00	NVDA	Stock	2.604	2.6052	2.5883	2.5965	27359480.0
2017-05-04 13:00:00	NVDA	Stock	2.5975	2.6036	2.5958	2.5968	14918080.0
2017-05-04 14:00:00	NVDA	Stock	2.5965	2.6045	2.5938	2.5999	19701760.0
2017-05-04 15:00:00	NVDA	Stock	2.5998	2.601	2.5918	2.5962	32698120.0
2017-05-04 16:00:00	NVDA	Stock	2.5962	2.5988	2.5925	2.5958	2079880.0
2017-05-04 17:00:00	NVDA	Stock	2.598	2.598	2.598	2.598	60000.0
2017-05-04 18:00:00	NVDA	Stock	2.5962	2.5973	2.5925	2.5925	90560.0
2017-05-04 19:00:00	NVDA	Stock	2.5955	2.5962	2.5925	2.5962	52120.0
2017-05-04 05:00:00	AMZN	Stock	47.2495	47.255	47.2495	47.255	7640.0
2017-05-04 06:00:00	AMZN	Stock	47.3	47.315	47.3	47.3	12300.0
2017-05-04 07:00:00	AMZN	Stock	47.275	47.275	47.265	47.2725	14740.0
2017-05-04 08:00:00	AMZN	Stock	47.2065	47.2625	47.2	47.2	98600.0
2017-05-04 09:00:00	AMZN	Stock	47.182	47.25	46.726	46.8365	9090360.0
2017-05-04 10:00:00	AMZN	Stock	46.8125	46.938	46.7108	46.82	7889940.0
2017-05-04 11:00:00	AMZN	Stock	46.8235	46.879	46.7545	46.804	5580800.0
2017-05-04 12:00:00	AMZN	Stock	46.8065	46.9125	46.7545	46.896	4056460.0
2017-05-04 13:00:00	AMZN	Stock	46.9024	46.935	46.8384	46.876	2527040.0

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

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