PREVIEW / stock_1hour / 2015-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-29.parquet
  size:    1.1 MB
  rows:    48,431
  symbols: 3,512

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-05-29 04:00:00	AAPL	Stock	32.8575	32.875	32.7825	32.8	58112.0
2015-05-29 05:00:00	AAPL	Stock	32.8175	32.825	32.8175	32.825	14848.0
2015-05-29 06:00:00	AAPL	Stock	32.8775	32.955	32.875	32.955	10800.0
2015-05-29 07:00:00	AAPL	Stock	32.95	32.97	32.8975	32.93	70804.0
2015-05-29 08:00:00	AAPL	Stock	32.9275	32.945	32.8375	32.85	698244.0
2015-05-29 09:00:00	AAPL	Stock	32.85	32.905	32.765	32.8105	20163824.0
2015-05-29 10:00:00	AAPL	Stock	32.815	32.86	32.475	32.545	36291420.0
2015-05-29 11:00:00	AAPL	Stock	32.5475	32.7	32.535	32.661	19730416.0
2015-05-29 12:00:00	AAPL	Stock	32.6625	32.815	32.6625	32.75	15048452.0
2015-05-29 13:00:00	AAPL	Stock	32.745	32.8	32.7025	32.7175	10726080.0
2015-05-29 14:00:00	AAPL	Stock	32.7175	32.72	32.5725	32.6475	19010064.0
2015-05-29 15:00:00	AAPL	Stock	32.6475	32.72	32.5575	32.58	31455052.0
2015-05-29 16:00:00	AAPL	Stock	32.57	32.66	32.5575	32.645	25907864.0
2015-05-29 17:00:00	AAPL	Stock	32.6375	32.65	32.635	32.635	197948.0
2015-05-29 18:00:00	AAPL	Stock	32.6375	32.6425	32.625	32.6325	72596.0
2015-05-29 19:00:00	AAPL	Stock	32.6275	32.6425	32.6275	32.6325	94940.0
2015-05-29 04:00:00	MSFT	Stock	47.28	47.28	47.28	47.28	100.0
2015-05-29 07:00:00	MSFT	Stock	47.38	47.4	47.38	47.4	400.0
2015-05-29 08:00:00	MSFT	Stock	47.31	47.45	47.31	47.35	6700.0
2015-05-29 09:00:00	MSFT	Stock	47.34	47.57	47.21	47.275	3478956.0
2015-05-29 10:00:00	MSFT	Stock	47.28	47.295	46.59	46.7	4415089.0
2015-05-29 11:00:00	MSFT	Stock	46.7	46.93	46.665	46.87	3000087.0
2015-05-29 12:00:00	MSFT	Stock	46.87	47.19	46.861	47.16	3118114.0
2015-05-29 13:00:00	MSFT	Stock	47.155	47.219	47.01	47.03	2253880.0
2015-05-29 14:00:00	MSFT	Stock	47.03	47.07	46.785	46.885	2350771.0
2015-05-29 15:00:00	MSFT	Stock	46.88	47.11	46.86	46.86	6860708.0
2015-05-29 16:00:00	MSFT	Stock	46.9	47.04	46.83	46.97	7072872.0
2015-05-29 17:00:00	MSFT	Stock	46.96	46.96	46.96	46.96	489400.0
2015-05-29 18:00:00	MSFT	Stock	46.95	46.95	46.95	46.95	1000.0
2015-05-29 08:00:00	NVDA	Stock	0.5562	0.5562	0.5562	0.5562	40000.0
2015-05-29 09:00:00	NVDA	Stock	0.5538	0.5562	0.5525	0.5545	21633560.0
2015-05-29 10:00:00	NVDA	Stock	0.5546	0.557	0.5532	0.554	53951480.0
2015-05-29 11:00:00	NVDA	Stock	0.554	0.5562	0.5525	0.5562	30830200.0
2015-05-29 12:00:00	NVDA	Stock	0.5562	0.557	0.5548	0.555	21271360.0
2015-05-29 13:00:00	NVDA	Stock	0.5548	0.5568	0.5545	0.5548	17654240.0
2015-05-29 14:00:00	NVDA	Stock	0.5548	0.5559	0.5535	0.5551	34096120.0
2015-05-29 15:00:00	NVDA	Stock	0.555	0.5564	0.5525	0.5535	95969080.0
2015-05-29 16:00:00	NVDA	Stock	0.554	0.5555	0.5522	0.5552	9165440.0
2015-05-29 17:00:00	NVDA	Stock	0.5568	0.557	0.5565	0.5565	56000.0
2015-05-29 19:00:00	NVDA	Stock	0.5565	0.5565	0.5565	0.5565	20000.0
2015-05-29 06:00:00	AMZN	Stock	21.275	21.275	21.275	21.275	4000.0
2015-05-29 08:00:00	AMZN	Stock	21.3435	21.382	21.3435	21.3735	45020.0
2015-05-29 09:00:00	AMZN	Stock	21.37	21.5572	21.35	21.539	10393060.0
2015-05-29 10:00:00	AMZN	Stock	21.542	21.625	21.5025	21.5405	12983880.0
2015-05-29 11:00:00	AMZN	Stock	21.533	21.55	21.4605	21.5315	6249180.0
2015-05-29 12:00:00	AMZN	Stock	21.523	21.6065	21.509	21.593	4305880.0
2015-05-29 13:00:00	AMZN	Stock	21.5898	21.6155	21.5165	21.53	4041280.0
2015-05-29 14:00:00	AMZN	Stock	21.5305	21.5375	21.423	21.464	6034180.0
2015-05-29 15:00:00	AMZN	Stock	21.4625	21.4995	21.4335	21.4635	9583940.0
2015-05-29 16:00:00	AMZN	Stock	21.469	21.4965	21.454	21.4775	2206320.0

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

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