PREVIEW / stock_1hour / 2012-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-16.parquet
  size:    927 KB
  rows:    43,850
  symbols: 3,476

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
2012-10-16 04:00:00	AAPL	Stock	22.7464	22.7679	22.7464	22.7679	19040.0
2012-10-16 05:00:00	AAPL	Stock	22.7571	22.8014	22.7429	22.7936	66836.0
2012-10-16 06:00:00	AAPL	Stock	22.7786	22.7936	22.7593	22.7936	85036.0
2012-10-16 07:00:00	AAPL	Stock	22.7986	22.7986	22.6357	22.6875	907396.0
2012-10-16 08:00:00	AAPL	Stock	22.7046	22.7686	22.6625	22.6807	2995412.0
2012-10-16 09:00:00	AAPL	Stock	22.6889	22.7107	22.5357	22.602	60550588.0
2012-10-16 10:00:00	AAPL	Stock	22.5932	22.8504	22.5625	22.8479	83076476.0
2012-10-16 11:00:00	AAPL	Stock	22.8446	23.0525	22.8214	22.9861	91805280.0
2012-10-16 12:00:00	AAPL	Stock	22.9889	23.1964	22.9614	23.11	87658452.0
2012-10-16 13:00:00	AAPL	Stock	23.11	23.1714	23.0636	23.0936	46865952.0
2012-10-16 14:00:00	AAPL	Stock	23.0929	23.1964	23.0411	23.1771	58011548.0
2012-10-16 15:00:00	AAPL	Stock	23.1761	23.225	23.1429	23.2004	92299396.0
2012-10-16 16:00:00	AAPL	Stock	23.2	23.2091	22.6821	23.1643	13909364.0
2012-10-16 17:00:00	AAPL	Stock	23.1607	23.1643	23.1536	23.155	685384.0
2012-10-16 18:00:00	AAPL	Stock	23.1557	23.1643	23.1254	23.1643	252448.0
2012-10-16 19:00:00	AAPL	Stock	23.1632	23.1782	23.1568	23.1646	238980.0
2012-10-16 06:00:00	MSFT	Stock	29.27	29.27	29.27	29.27	200.0
2012-10-16 07:00:00	MSFT	Stock	29.62	29.7	29.6	29.7	7100.0
2012-10-16 08:00:00	MSFT	Stock	29.78	29.78	29.5	29.5	59297.0
2012-10-16 09:00:00	MSFT	Stock	29.52	29.56	29.32	29.51	5002940.0
2012-10-16 10:00:00	MSFT	Stock	29.52	29.59	29.5	29.565	6348709.0
2012-10-16 11:00:00	MSFT	Stock	29.56	29.72	29.55	29.68	5829919.0
2012-10-16 12:00:00	MSFT	Stock	29.674	29.74	29.63	29.635	5503040.0
2012-10-16 13:00:00	MSFT	Stock	29.635	29.66	29.59	29.615	3125403.0
2012-10-16 14:00:00	MSFT	Stock	29.62	29.62	29.46	29.485	5991042.0
2012-10-16 15:00:00	MSFT	Stock	29.485	29.585	29.43	29.52	13117925.0
2012-10-16 16:00:00	MSFT	Stock	29.52	29.669	29.39	29.43	1848536.0
2012-10-16 17:00:00	MSFT	Stock	29.4	29.4	29.29	29.31	21922.0
2012-10-16 18:00:00	MSFT	Stock	29.3	29.43	29.3	29.42	1567.0
2012-10-16 19:00:00	MSFT	Stock	29.34	29.42	29.34	29.4	4902.0
2012-10-16 06:00:00	NVDA	Stock	0.3163	0.325	0.315	0.325	20000.0
2012-10-16 07:00:00	NVDA	Stock	0.3198	0.3198	0.3198	0.3198	4000.0
2012-10-16 08:00:00	NVDA	Stock	0.32	0.3225	0.32	0.3225	200000.0
2012-10-16 09:00:00	NVDA	Stock	0.3223	0.3255	0.3195	0.3245	55116840.0
2012-10-16 10:00:00	NVDA	Stock	0.3246	0.3255	0.323	0.3254	78685960.0
2012-10-16 11:00:00	NVDA	Stock	0.3253	0.329	0.3243	0.3286	74349880.0
2012-10-16 12:00:00	NVDA	Stock	0.3285	0.33	0.3273	0.3285	41701320.0
2012-10-16 13:00:00	NVDA	Stock	0.3285	0.3293	0.327	0.3278	19667640.0
2012-10-16 14:00:00	NVDA	Stock	0.3278	0.3283	0.3273	0.328	19443520.0
2012-10-16 15:00:00	NVDA	Stock	0.328	0.329	0.3275	0.3289	55833560.0
2012-10-16 16:00:00	NVDA	Stock	0.3288	0.3293	0.3238	0.3288	18106520.0
2012-10-16 17:00:00	NVDA	Stock	0.3265	0.3265	0.3265	0.3265	56000.0
2012-10-16 18:00:00	NVDA	Stock	0.3255	0.3283	0.325	0.3283	64000.0
2012-10-16 07:00:00	AMZN	Stock	12.2475	12.25	12.2475	12.25	47000.0
2012-10-16 08:00:00	AMZN	Stock	12.2695	12.2695	12.2365	12.2425	97420.0
2012-10-16 09:00:00	AMZN	Stock	12.2485	12.2485	12.104	12.1635	6882440.0
2012-10-16 10:00:00	AMZN	Stock	12.1655	12.2015	12.1285	12.174	7545220.0
2012-10-16 11:00:00	AMZN	Stock	12.167	12.237	12.1505	12.227	6631020.0
2012-10-16 12:00:00	AMZN	Stock	12.226	12.2885	12.222	12.245	5329460.0
2012-10-16 13:00:00	AMZN	Stock	12.247	12.269	12.173	12.1965	3697960.0

> showing 50 of 43,850 rows — these rows as CSV

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