PREVIEW / stock_1hour / 2015-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-14.parquet
  size:    1.0 MB
  rows:    47,723
  symbols: 3,462

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-08-14 04:00:00	AAPL	Stock	28.725	28.77	28.7125	28.7125	2400.0
2015-08-14 05:00:00	AAPL	Stock	28.7125	28.7425	28.6625	28.6625	20168.0
2015-08-14 06:00:00	AAPL	Stock	28.7	28.7	28.6375	28.675	14492.0
2015-08-14 07:00:00	AAPL	Stock	28.6275	28.65	28.6125	28.6375	132868.0
2015-08-14 08:00:00	AAPL	Stock	28.6475	28.665	28.5475	28.665	421692.0
2015-08-14 09:00:00	AAPL	Stock	28.665	28.855	28.5025	28.7745	30132280.0
2015-08-14 10:00:00	AAPL	Stock	28.7775	28.92	28.6925	28.7575	32473552.0
2015-08-14 11:00:00	AAPL	Stock	28.755	28.8225	28.7025	28.805	17304816.0
2015-08-14 12:00:00	AAPL	Stock	28.8025	28.81	28.6575	28.71	14383104.0
2015-08-14 13:00:00	AAPL	Stock	28.7112	28.8475	28.6775	28.8202	13921604.0
2015-08-14 14:00:00	AAPL	Stock	28.82	28.8925	28.82	28.89	13506672.0
2015-08-14 15:00:00	AAPL	Stock	28.89	29.0775	28.89	28.99	33428980.0
2015-08-14 16:00:00	AAPL	Stock	28.99	29.005	28.7245	29.0025	5972644.0
2015-08-14 17:00:00	AAPL	Stock	29.0025	29.01	28.99	29.005	175592.0
2015-08-14 18:00:00	AAPL	Stock	29.0	29.01	28.9925	29.005	71172.0
2015-08-14 19:00:00	AAPL	Stock	29.01	29.035	29.0025	29.035	86784.0
2015-08-14 07:00:00	MSFT	Stock	46.67	46.68	46.67	46.68	540.0
2015-08-14 08:00:00	MSFT	Stock	46.6	46.65	46.6	46.6	1290.0
2015-08-14 09:00:00	MSFT	Stock	46.613	47.05	46.53	47.01	2133078.0
2015-08-14 10:00:00	MSFT	Stock	47.01	47.02	46.67	46.81	2559018.0
2015-08-14 11:00:00	MSFT	Stock	46.8	46.83	46.52	46.64	2746300.0
2015-08-14 12:00:00	MSFT	Stock	46.635	46.81	46.635	46.715	2519321.0
2015-08-14 13:00:00	MSFT	Stock	46.71	47.01	46.67	46.88	1492448.0
2015-08-14 14:00:00	MSFT	Stock	46.884	47.005	46.84	46.972	1582409.0
2015-08-14 15:00:00	MSFT	Stock	46.975	47.1	46.95	47.0	3143412.0
2015-08-14 16:00:00	MSFT	Stock	47.0	47.1	46.99	47.1	4304958.0
2015-08-14 17:00:00	MSFT	Stock	47.1	47.1	47.0	47.0	3655.0
2015-08-14 18:00:00	MSFT	Stock	47.03	47.03	47.03	47.03	1000.0
2015-08-14 19:00:00	MSFT	Stock	47.03	47.097	47.03	47.097	1111.0
2015-08-14 08:00:00	NVDA	Stock	0.588	0.588	0.5875	0.5875	24000.0
2015-08-14 09:00:00	NVDA	Stock	0.5875	0.592	0.584	0.5888	22027520.0
2015-08-14 10:00:00	NVDA	Stock	0.5886	0.5903	0.5853	0.5855	44328240.0
2015-08-14 11:00:00	NVDA	Stock	0.5853	0.5895	0.5848	0.5883	28068960.0
2015-08-14 12:00:00	NVDA	Stock	0.5885	0.5894	0.5863	0.5878	18822240.0
2015-08-14 13:00:00	NVDA	Stock	0.5876	0.5901	0.5872	0.5885	20456200.0
2015-08-14 14:00:00	NVDA	Stock	0.5885	0.5902	0.5875	0.5893	19642720.0
2015-08-14 15:00:00	NVDA	Stock	0.5894	0.5903	0.588	0.5886	46054280.0
2015-08-14 16:00:00	NVDA	Stock	0.5888	0.5888	0.5885	0.5885	10573160.0
2015-08-14 17:00:00	NVDA	Stock	0.5895	0.5895	0.5895	0.5895	58000.0
2015-08-14 05:00:00	AMZN	Stock	26.4025	26.4025	26.4025	26.4025	2000.0
2015-08-14 07:00:00	AMZN	Stock	26.484	26.484	26.484	26.484	8000.0
2015-08-14 08:00:00	AMZN	Stock	26.5	26.5	26.435	26.4505	65600.0
2015-08-14 09:00:00	AMZN	Stock	26.4815	26.612	26.4125	26.592	5510020.0
2015-08-14 10:00:00	AMZN	Stock	26.6015	26.6635	26.5575	26.5775	5308360.0
2015-08-14 11:00:00	AMZN	Stock	26.5715	26.705	26.5272	26.665	5315460.0
2015-08-14 12:00:00	AMZN	Stock	26.655	26.7055	26.568	26.5795	4441780.0
2015-08-14 13:00:00	AMZN	Stock	26.582	26.621	26.53	26.545	2789780.0
2015-08-14 14:00:00	AMZN	Stock	26.552	26.6135	26.5345	26.5615	2491380.0
2015-08-14 15:00:00	AMZN	Stock	26.576	26.6445	26.5595	26.576	6805740.0
2015-08-14 16:00:00	AMZN	Stock	26.576	26.5875	26.565	26.5765	1573280.0

> showing 50 of 47,723 rows — these rows as CSV

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