PREVIEW / stock_1hour / 2015-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-25.parquet
  size:    1.0 MB
  rows:    48,730
  symbols: 3,508

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-02-25 04:00:00	AAPL	Stock	32.9675	33.05	32.9675	33.025	14320.0
2015-02-25 05:00:00	AAPL	Stock	32.9875	32.9875	32.9875	32.9875	4180.0
2015-02-25 06:00:00	AAPL	Stock	32.95	32.9525	32.9	32.93	25360.0
2015-02-25 07:00:00	AAPL	Stock	32.935	32.94	32.85	32.8725	175572.0
2015-02-25 08:00:00	AAPL	Stock	32.8725	33.0425	32.8625	32.9125	883040.0
2015-02-25 09:00:00	AAPL	Stock	32.9125	32.95	32.6325	32.77	38585024.0
2015-02-25 10:00:00	AAPL	Stock	32.76	32.835	32.565	32.7225	40990848.0
2015-02-25 11:00:00	AAPL	Stock	32.7225	32.815	32.6725	32.7152	20542760.0
2015-02-25 12:00:00	AAPL	Stock	32.7152	32.785	32.68	32.741	13169956.0
2015-02-25 13:00:00	AAPL	Stock	32.745	32.7525	32.5675	32.57	17979764.0
2015-02-25 14:00:00	AAPL	Stock	32.57	32.5725	32.07	32.2875	76445308.0
2015-02-25 15:00:00	AAPL	Stock	32.2875	32.3325	32.0375	32.195	62541260.0
2015-02-25 16:00:00	AAPL	Stock	32.1975	32.8572	32.1525	32.1575	6222164.0
2015-02-25 17:00:00	AAPL	Stock	32.1575	32.1975	32.1575	32.175	1247728.0
2015-02-25 18:00:00	AAPL	Stock	32.175	32.1825	32.1625	32.165	108184.0
2015-02-25 19:00:00	AAPL	Stock	32.1725	32.1875	32.15	32.16	211476.0
2015-02-25 07:00:00	MSFT	Stock	43.88	43.89	43.88	43.89	1715.0
2015-02-25 08:00:00	MSFT	Stock	43.88	43.9	43.82	43.86	4562.0
2015-02-25 09:00:00	MSFT	Stock	43.86	44.09	43.82	43.95	4521817.0
2015-02-25 10:00:00	MSFT	Stock	43.95	44.09	43.92	44.06	3292558.0
2015-02-25 11:00:00	MSFT	Stock	44.06	44.08	43.95	43.965	2465993.0
2015-02-25 12:00:00	MSFT	Stock	43.965	44.01	43.91	43.93	2346549.0
2015-02-25 13:00:00	MSFT	Stock	43.93	44.01	43.9	43.98	2592859.0
2015-02-25 14:00:00	MSFT	Stock	43.98	43.99	43.81	43.865	3884057.0
2015-02-25 15:00:00	MSFT	Stock	43.86	43.99	43.8	43.98	5970023.0
2015-02-25 16:00:00	MSFT	Stock	43.98	44.0	43.898	43.95	3156018.0
2015-02-25 17:00:00	MSFT	Stock	43.96	43.99	43.96	43.99	650.0
2015-02-25 18:00:00	MSFT	Stock	43.99	44.04	43.98	43.99	5215.0
2015-02-25 19:00:00	MSFT	Stock	43.96	43.96	43.95	43.96	4689.0
2015-02-25 09:00:00	NVDA	Stock	0.5612	0.5612	0.5539	0.556	11975400.0
2015-02-25 10:00:00	NVDA	Stock	0.5562	0.558	0.554	0.554	22099840.0
2015-02-25 11:00:00	NVDA	Stock	0.554	0.555	0.5519	0.5543	16660720.0
2015-02-25 12:00:00	NVDA	Stock	0.5545	0.5552	0.5533	0.5541	9229600.0
2015-02-25 13:00:00	NVDA	Stock	0.554	0.5565	0.5538	0.5565	9728200.0
2015-02-25 14:00:00	NVDA	Stock	0.5565	0.5569	0.5531	0.5532	12123600.0
2015-02-25 15:00:00	NVDA	Stock	0.5532	0.554	0.5509	0.5535	31288840.0
2015-02-25 16:00:00	NVDA	Stock	0.5535	0.5541	0.5535	0.5535	1747800.0
2015-02-25 18:00:00	NVDA	Stock	0.5568	0.5568	0.5568	0.5568	12000.0
2015-02-25 19:00:00	NVDA	Stock	0.5562	0.5562	0.5562	0.5562	20000.0
2015-02-25 04:00:00	AMZN	Stock	18.909	18.909	18.909	18.909	4000.0
2015-02-25 08:00:00	AMZN	Stock	18.915	18.9365	18.915	18.9365	31000.0
2015-02-25 09:00:00	AMZN	Stock	18.9	19.062	18.827	19.0417	6097500.0
2015-02-25 10:00:00	AMZN	Stock	19.0355	19.238	19.029	19.231	11261020.0
2015-02-25 11:00:00	AMZN	Stock	19.2345	19.2975	19.1665	19.234	7905500.0
2015-02-25 12:00:00	AMZN	Stock	19.24	19.2745	19.1925	19.2745	4937380.0
2015-02-25 13:00:00	AMZN	Stock	19.2745	19.3925	19.239	19.3815	6705140.0
2015-02-25 14:00:00	AMZN	Stock	19.3855	19.3855	19.208	19.2648	7396940.0
2015-02-25 15:00:00	AMZN	Stock	19.2585	19.2865	19.2005	19.274	8850600.0
2015-02-25 16:00:00	AMZN	Stock	19.2685	19.2975	18.856	19.2825	492040.0
2015-02-25 17:00:00	AMZN	Stock	19.2685	19.2685	19.2685	19.2685	134520.0

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

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