PREVIEW / stock_1hour / 2014-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-18.parquet
  size:    1.0 MB
  rows:    48,600
  symbols: 3,568

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
2014-02-18 04:00:00	AAPL	Stock	19.4982	19.4982	19.4643	19.4796	19600.0
2014-02-18 05:00:00	AAPL	Stock	19.4796	19.4796	19.4664	19.4664	19488.0
2014-02-18 06:00:00	AAPL	Stock	19.4604	19.4643	19.4264	19.4304	49196.0
2014-02-18 07:00:00	AAPL	Stock	19.4464	19.4886	19.4357	19.4804	189672.0
2014-02-18 08:00:00	AAPL	Stock	19.4768	19.5714	19.4107	19.5289	1537956.0
2014-02-18 09:00:00	AAPL	Stock	19.5343	19.5882	19.4861	19.5086	43886668.0
2014-02-18 10:00:00	AAPL	Stock	19.5071	19.6854	19.4861	19.635	51986060.0
2014-02-18 11:00:00	AAPL	Stock	19.6379	19.6407	19.5779	19.6025	18670540.0
2014-02-18 12:00:00	AAPL	Stock	19.6021	19.6439	19.5893	19.6079	16440536.0
2014-02-18 13:00:00	AAPL	Stock	19.6079	19.625	19.5693	19.6	13478528.0
2014-02-18 14:00:00	AAPL	Stock	19.6	19.6307	19.5718	19.5782	14576100.0
2014-02-18 15:00:00	AAPL	Stock	19.5786	19.5832	19.4925	19.495	35386764.0
2014-02-18 16:00:00	AAPL	Stock	19.4996	19.619	19.4929	19.5054	19895764.0
2014-02-18 17:00:00	AAPL	Stock	19.5025	19.5143	19.5025	19.5054	60760.0
2014-02-18 18:00:00	AAPL	Stock	19.4996	19.5089	19.4907	19.4907	663768.0
2014-02-18 19:00:00	AAPL	Stock	19.4875	19.4893	19.4729	19.4786	204820.0
2014-02-18 04:00:00	MSFT	Stock	37.55	37.55	37.55	37.55	7500.0
2014-02-18 07:00:00	MSFT	Stock	37.49	37.5	37.49	37.49	1000.0
2014-02-18 08:00:00	MSFT	Stock	37.5	37.65	37.34	37.52	13032.0
2014-02-18 09:00:00	MSFT	Stock	37.57	37.78	37.51	37.55	5462118.0
2014-02-18 10:00:00	MSFT	Stock	37.55	37.62	37.51	37.57	4909225.0
2014-02-18 11:00:00	MSFT	Stock	37.57	37.58	37.42	37.47	3548562.0
2014-02-18 12:00:00	MSFT	Stock	37.474	37.52	37.45	37.45	2304809.0
2014-02-18 13:00:00	MSFT	Stock	37.459	37.55	37.41	37.51	2903790.0
2014-02-18 14:00:00	MSFT	Stock	37.52	37.6	37.505	37.54	2752036.0
2014-02-18 15:00:00	MSFT	Stock	37.54	37.57	37.42	37.43	6467526.0
2014-02-18 16:00:00	MSFT	Stock	37.42	37.541	37.38	37.53	3483728.0
2014-02-18 17:00:00	MSFT	Stock	37.41	37.45	37.41	37.45	600.0
2014-02-18 18:00:00	MSFT	Stock	37.44	37.44	37.41	37.41	1000.0
2014-02-18 19:00:00	MSFT	Stock	37.4	37.45	37.39	37.4	4575.0
2014-02-18 08:00:00	NVDA	Stock	0.4478	0.4482	0.4478	0.4482	47400.0
2014-02-18 09:00:00	NVDA	Stock	0.4485	0.4495	0.4438	0.447	55939360.0
2014-02-18 10:00:00	NVDA	Stock	0.447	0.4495	0.446	0.4472	73184440.0
2014-02-18 11:00:00	NVDA	Stock	0.4472	0.4485	0.4465	0.448	29938240.0
2014-02-18 12:00:00	NVDA	Stock	0.448	0.4482	0.4465	0.4475	21293800.0
2014-02-18 13:00:00	NVDA	Stock	0.4478	0.4485	0.4468	0.4472	21075480.0
2014-02-18 14:00:00	NVDA	Stock	0.4472	0.4488	0.4472	0.4482	30861920.0
2014-02-18 15:00:00	NVDA	Stock	0.4482	0.4488	0.447	0.4474	58195840.0
2014-02-18 16:00:00	NVDA	Stock	0.4475	0.448	0.4468	0.4468	131363800.0
2014-02-18 17:00:00	NVDA	Stock	0.4468	0.448	0.4468	0.448	18000.0
2014-02-18 18:00:00	NVDA	Stock	0.4495	0.4495	0.448	0.448	18000.0
2014-02-18 19:00:00	NVDA	Stock	0.448	0.4495	0.448	0.448	84000.0
2014-02-18 07:00:00	AMZN	Stock	17.831	17.833	17.815	17.815	14000.0
2014-02-18 08:00:00	AMZN	Stock	17.8255	17.828	17.754	17.754	52440.0
2014-02-18 09:00:00	AMZN	Stock	17.789	17.789	17.5065	17.5085	18900180.0
2014-02-18 10:00:00	AMZN	Stock	17.5065	17.757	17.5005	17.675	19963940.0
2014-02-18 11:00:00	AMZN	Stock	17.675	17.6985	17.4725	17.4814	19835040.0
2014-02-18 12:00:00	AMZN	Stock	17.4776	17.5985	17.4776	17.5655	6700900.0
2014-02-18 13:00:00	AMZN	Stock	17.5605	17.592	17.53	17.5765	5446100.0
2014-02-18 14:00:00	AMZN	Stock	17.575	17.665	17.561	17.6314	7793560.0

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

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