PREVIEW / stock_1hour / 2015-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-18.parquet
  size:    1.0 MB
  rows:    48,891
  symbols: 3,527

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-18 04:00:00	AAPL	Stock	32.1125	32.1125	32.0375	32.08	55216.0
2015-02-18 05:00:00	AAPL	Stock	32.0825	32.13	32.075	32.13	56260.0
2015-02-18 06:00:00	AAPL	Stock	32.075	32.075	31.98	31.98	68724.0
2015-02-18 07:00:00	AAPL	Stock	31.98	32.0375	31.9625	31.9875	158876.0
2015-02-18 08:00:00	AAPL	Stock	31.99	32.03	31.84	31.8875	994632.0
2015-02-18 09:00:00	AAPL	Stock	31.8875	32.0725	31.85	32.0075	25192092.0
2015-02-18 10:00:00	AAPL	Stock	32.0075	32.0675	31.8825	32.045	32013536.0
2015-02-18 11:00:00	AAPL	Stock	32.045	32.0488	31.96	31.9775	15308296.0
2015-02-18 12:00:00	AAPL	Stock	31.9775	32.0125	31.91	31.9325	14524712.0
2015-02-18 13:00:00	AAPL	Stock	31.9325	31.9625	31.9125	31.925	10113780.0
2015-02-18 14:00:00	AAPL	Stock	31.9275	32.0175	31.8875	31.995	20089600.0
2015-02-18 15:00:00	AAPL	Stock	31.9975	32.195	31.9962	32.18	37133056.0
2015-02-18 16:00:00	AAPL	Stock	32.1788	32.1875	31.8632	32.15	11066976.0
2015-02-18 17:00:00	AAPL	Stock	31.9938	32.18	31.9628	32.145	2278212.0
2015-02-18 18:00:00	AAPL	Stock	32.15	32.1788	32.135	32.145	223756.0
2015-02-18 19:00:00	AAPL	Stock	32.1575	32.1575	32.13	32.1475	92572.0
2015-02-18 06:00:00	MSFT	Stock	43.45	43.45	43.45	43.45	200.0
2015-02-18 07:00:00	MSFT	Stock	43.57	43.57	43.57	43.57	200.0
2015-02-18 08:00:00	MSFT	Stock	43.56	43.56	43.46	43.47	6109.0
2015-02-18 09:00:00	MSFT	Stock	43.46	43.635	43.39	43.47	3777991.0
2015-02-18 10:00:00	MSFT	Stock	43.475	43.55	43.39	43.51	4163723.0
2015-02-18 11:00:00	MSFT	Stock	43.515	43.61	43.49	43.58	2431040.0
2015-02-18 12:00:00	MSFT	Stock	43.585	43.61	43.5	43.51	1922836.0
2015-02-18 13:00:00	MSFT	Stock	43.51	43.59	43.49	43.56	3077546.0
2015-02-18 14:00:00	MSFT	Stock	43.555	43.69	43.53	43.585	2562806.0
2015-02-18 15:00:00	MSFT	Stock	43.59	43.7	43.48	43.53	5483902.0
2015-02-18 16:00:00	MSFT	Stock	43.54	43.709	43.5	43.55	2697648.0
2015-02-18 17:00:00	MSFT	Stock	43.61	43.61	43.61	43.61	1899.0
2015-02-18 18:00:00	MSFT	Stock	43.55	43.55	43.55	43.55	4429.0
2015-02-18 19:00:00	MSFT	Stock	43.55	43.59	43.55	43.59	1300.0
2015-02-18 09:00:00	NVDA	Stock	0.5582	0.5598	0.557	0.5572	13080560.0
2015-02-18 10:00:00	NVDA	Stock	0.5572	0.5572	0.5532	0.5545	19908920.0
2015-02-18 11:00:00	NVDA	Stock	0.5545	0.5562	0.5539	0.5552	16016800.0
2015-02-18 12:00:00	NVDA	Stock	0.5554	0.5562	0.5532	0.554	17068880.0
2015-02-18 13:00:00	NVDA	Stock	0.554	0.5552	0.5539	0.5542	15543920.0
2015-02-18 14:00:00	NVDA	Stock	0.5544	0.5565	0.5538	0.5538	23209960.0
2015-02-18 15:00:00	NVDA	Stock	0.554	0.5552	0.552	0.5529	52437200.0
2015-02-18 16:00:00	NVDA	Stock	0.553	0.555	0.553	0.553	9551320.0
2015-02-18 18:00:00	NVDA	Stock	0.5562	0.5562	0.5538	0.5538	8000.0
2015-02-18 08:00:00	AMZN	Stock	18.74	18.74	18.7125	18.7125	14800.0
2015-02-18 09:00:00	AMZN	Stock	18.701	18.8	18.6425	18.7015	8782000.0
2015-02-18 10:00:00	AMZN	Stock	18.7	18.837	18.699	18.783	9923640.0
2015-02-18 11:00:00	AMZN	Stock	18.79	18.8065	18.713	18.74	4340160.0
2015-02-18 12:00:00	AMZN	Stock	18.7375	18.757	18.7005	18.7115	3427460.0
2015-02-18 13:00:00	AMZN	Stock	18.7164	18.7415	18.695	18.6965	2884880.0
2015-02-18 14:00:00	AMZN	Stock	18.7055	18.7609	18.685	18.7095	5016980.0
2015-02-18 15:00:00	AMZN	Stock	18.7145	18.735	18.662	18.6685	7587940.0
2015-02-18 16:00:00	AMZN	Stock	18.6695	18.7438	18.637	18.6685	2411460.0
2015-02-18 17:00:00	AMZN	Stock	18.7598	18.7598	18.6425	18.6425	2479780.0
2015-02-18 18:00:00	AMZN	Stock	18.65	18.665	18.65	18.665	14400.0

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

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