PREVIEW / stock_1hour / 2013-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-29.parquet
  size:    1.0 MB
  rows:    47,092
  symbols: 3,546

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
2013-10-29 04:00:00	AAPL	Stock	19.0575	19.0575	18.7143	18.875	303240.0
2013-10-29 05:00:00	AAPL	Stock	18.9032	18.9621	18.8571	18.9621	223944.0
2013-10-29 06:00:00	AAPL	Stock	18.9089	19.0407	18.9057	19.0004	339808.0
2013-10-29 07:00:00	AAPL	Stock	19.0029	19.15	18.8571	19.15	6773788.0
2013-10-29 08:00:00	AAPL	Stock	19.1386	19.15	18.7857	19.1004	11570608.0
2013-10-29 09:00:00	AAPL	Stock	19.0989	19.2589	18.9036	18.9929	163807224.0
2013-10-29 10:00:00	AAPL	Stock	18.9875	19.0246	18.7154	18.7571	114112768.0
2013-10-29 11:00:00	AAPL	Stock	18.7543	18.8257	18.6018	18.7064	75283488.0
2013-10-29 12:00:00	AAPL	Stock	18.7104	18.8571	18.6907	18.8211	41619928.0
2013-10-29 13:00:00	AAPL	Stock	18.8211	18.8268	18.6989	18.7411	25622744.0
2013-10-29 14:00:00	AAPL	Stock	18.7457	18.7461	18.6064	18.6821	44645132.0
2013-10-29 15:00:00	AAPL	Stock	18.6821	18.6846	18.3764	18.4648	126392644.0
2013-10-29 16:00:00	AAPL	Stock	18.465	18.9144	18.4241	18.4643	12857712.0
2013-10-29 17:00:00	AAPL	Stock	18.4607	18.6959	18.4571	18.4571	651784.0
2013-10-29 18:00:00	AAPL	Stock	18.4539	18.4639	18.4404	18.4511	857220.0
2013-10-29 19:00:00	AAPL	Stock	18.4561	18.4568	18.4429	18.4518	568708.0
2013-10-29 06:00:00	MSFT	Stock	35.49	35.49	35.49	35.49	100.0
2013-10-29 07:00:00	MSFT	Stock	35.55	35.64	35.55	35.61	1350.0
2013-10-29 08:00:00	MSFT	Stock	35.6	35.7	35.555	35.63	30229.0
2013-10-29 09:00:00	MSFT	Stock	35.65	35.72	35.3	35.385	4294927.0
2013-10-29 10:00:00	MSFT	Stock	35.38	35.45	35.26	35.358	6169349.0
2013-10-29 11:00:00	MSFT	Stock	35.35	35.46	35.35	35.455	2621776.0
2013-10-29 12:00:00	MSFT	Stock	35.46	35.559	35.44	35.54	3244655.0
2013-10-29 13:00:00	MSFT	Stock	35.54	35.57	35.52	35.55	2140182.0
2013-10-29 14:00:00	MSFT	Stock	35.56	35.63	35.54	35.61	2683430.0
2013-10-29 15:00:00	MSFT	Stock	35.61	35.62	35.49	35.53	6348206.0
2013-10-29 16:00:00	MSFT	Stock	35.52	35.7	35.477	35.557	2202601.0
2013-10-29 17:00:00	MSFT	Stock	35.52	35.52	35.432	35.52	17262.0
2013-10-29 18:00:00	MSFT	Stock	35.48	35.48	35.48	35.48	100.0
2013-10-29 19:00:00	MSFT	Stock	35.48	35.48	35.46	35.46	300.0
2013-10-29 09:00:00	NVDA	Stock	0.3798	0.3813	0.3773	0.3783	36942240.0
2013-10-29 10:00:00	NVDA	Stock	0.3783	0.38	0.3773	0.3788	75686720.0
2013-10-29 11:00:00	NVDA	Stock	0.379	0.3815	0.378	0.3783	79445360.0
2013-10-29 12:00:00	NVDA	Stock	0.3783	0.3788	0.3763	0.3778	45890080.0
2013-10-29 13:00:00	NVDA	Stock	0.3775	0.3785	0.3773	0.3785	32500400.0
2013-10-29 14:00:00	NVDA	Stock	0.3784	0.3788	0.3775	0.3788	38065520.0
2013-10-29 15:00:00	NVDA	Stock	0.3788	0.3808	0.3785	0.3806	66080480.0
2013-10-29 16:00:00	NVDA	Stock	0.3808	0.3808	0.3788	0.3808	2188040.0
2013-10-29 08:00:00	AMZN	Stock	17.9	17.95	17.9	17.95	86600.0
2013-10-29 09:00:00	AMZN	Stock	17.9565	18.032	17.825	17.8365	6106060.0
2013-10-29 10:00:00	AMZN	Stock	17.8455	18.0515	17.8145	17.8875	10496980.0
2013-10-29 11:00:00	AMZN	Stock	17.896	18.128	17.896	18.0405	6451000.0
2013-10-29 12:00:00	AMZN	Stock	18.0326	18.1445	18.0185	18.055	3406060.0
2013-10-29 13:00:00	AMZN	Stock	18.0465	18.075	18.0295	18.0644	2394320.0
2013-10-29 14:00:00	AMZN	Stock	18.0645	18.125	18.0345	18.115	5265700.0
2013-10-29 15:00:00	AMZN	Stock	18.111	18.1395	18.0555	18.1395	7136600.0
2013-10-29 16:00:00	AMZN	Stock	18.135	18.1375	18.0184	18.135	1903640.0
2013-10-29 17:00:00	AMZN	Stock	18.0364	18.15	18.0364	18.15	39140.0
2013-10-29 18:00:00	AMZN	Stock	18.1495	18.1495	18.1375	18.1425	50280.0
2013-10-29 19:00:00	AMZN	Stock	18.14	18.1495	18.12	18.1495	50740.0

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

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