PREVIEW / stock_1hour / 2014-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-09.parquet
  size:    1.0 MB
  rows:    47,963
  symbols: 3,519

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-01-09 04:00:00	AAPL	Stock	19.4586	19.5225	19.4586	19.4643	16800.0
2014-01-09 05:00:00	AAPL	Stock	19.4864	19.4979	19.4743	19.4979	21000.0
2014-01-09 06:00:00	AAPL	Stock	19.4821	19.4846	19.4714	19.4846	16800.0
2014-01-09 07:00:00	AAPL	Stock	19.4714	19.5757	19.4714	19.5361	497980.0
2014-01-09 08:00:00	AAPL	Stock	19.4843	19.5482	19.4843	19.5211	981260.0
2014-01-09 09:00:00	AAPL	Stock	19.5147	19.535	19.4464	19.5096	34244616.0
2014-01-09 10:00:00	AAPL	Stock	19.51	19.5175	19.3289	19.3594	41587868.0
2014-01-09 11:00:00	AAPL	Stock	19.3586	19.3586	19.2429	19.2675	30139116.0
2014-01-09 12:00:00	AAPL	Stock	19.2664	19.3243	19.2321	19.3014	23643368.0
2014-01-09 13:00:00	AAPL	Stock	19.3011	19.3179	19.1814	19.1843	17674132.0
2014-01-09 14:00:00	AAPL	Stock	19.1861	19.2089	19.1196	19.1702	31483956.0
2014-01-09 15:00:00	AAPL	Stock	19.1707	19.2218	19.1457	19.1607	37971696.0
2014-01-09 16:00:00	AAPL	Stock	19.1611	19.33	19.1486	19.1486	15160936.0
2014-01-09 17:00:00	AAPL	Stock	19.1489	19.1636	19.1468	19.1493	968576.0
2014-01-09 18:00:00	AAPL	Stock	19.1511	19.1596	19.1432	19.1432	162960.0
2014-01-09 19:00:00	AAPL	Stock	19.1482	19.1639	19.1482	19.1518	162092.0
2014-01-09 06:00:00	MSFT	Stock	35.87	35.87	35.87	35.87	500.0
2014-01-09 07:00:00	MSFT	Stock	35.86	35.86	35.86	35.86	317.0
2014-01-09 08:00:00	MSFT	Stock	35.8	35.9	35.8	35.88	11910.0
2014-01-09 09:00:00	MSFT	Stock	35.88	35.91	35.72	35.9	4762474.0
2014-01-09 10:00:00	MSFT	Stock	35.9	35.9	35.51	35.555	5168852.0
2014-01-09 11:00:00	MSFT	Stock	35.55	35.56	35.4	35.48	4941705.0
2014-01-09 12:00:00	MSFT	Stock	35.49	35.61	35.43	35.58	3434339.0
2014-01-09 13:00:00	MSFT	Stock	35.58	35.6	35.505	35.525	3219512.0
2014-01-09 14:00:00	MSFT	Stock	35.525	35.56	35.445	35.512	2994665.0
2014-01-09 15:00:00	MSFT	Stock	35.515	35.65	35.49	35.53	8060806.0
2014-01-09 16:00:00	MSFT	Stock	35.53	35.76	35.35	35.53	2771436.0
2014-01-09 17:00:00	MSFT	Stock	35.53	35.6	35.53	35.6	6109.0
2014-01-09 18:00:00	MSFT	Stock	35.6	35.6	35.53	35.53	2355.0
2014-01-09 19:00:00	MSFT	Stock	35.6	35.6	35.58	35.58	1800.0
2014-01-09 05:00:00	NVDA	Stock	0.4038	0.4038	0.4035	0.4035	30000.0
2014-01-09 07:00:00	NVDA	Stock	0.4022	0.4035	0.4022	0.4032	603000.0
2014-01-09 08:00:00	NVDA	Stock	0.4038	0.4038	0.4028	0.4038	185720.0
2014-01-09 09:00:00	NVDA	Stock	0.404	0.4053	0.3993	0.4005	54646040.0
2014-01-09 10:00:00	NVDA	Stock	0.4003	0.4003	0.3933	0.3948	63098760.0
2014-01-09 11:00:00	NVDA	Stock	0.3948	0.395	0.3925	0.3942	33871520.0
2014-01-09 12:00:00	NVDA	Stock	0.3945	0.397	0.394	0.3955	25676400.0
2014-01-09 13:00:00	NVDA	Stock	0.3955	0.3958	0.394	0.3941	19016360.0
2014-01-09 14:00:00	NVDA	Stock	0.394	0.395	0.393	0.3944	21692920.0
2014-01-09 15:00:00	NVDA	Stock	0.3944	0.395	0.3938	0.3939	52187880.0
2014-01-09 16:00:00	NVDA	Stock	0.3938	0.3966	0.3938	0.3938	1400960.0
2014-01-09 17:00:00	NVDA	Stock	0.3938	0.3955	0.3938	0.3955	16200.0
2014-01-09 19:00:00	NVDA	Stock	0.394	0.394	0.394	0.394	20000.0
2014-01-09 04:00:00	AMZN	Stock	20.1515	20.17	20.1515	20.17	6000.0
2014-01-09 05:00:00	AMZN	Stock	20.1875	20.1875	20.1875	20.1875	2000.0
2014-01-09 06:00:00	AMZN	Stock	20.18	20.18	20.18	20.18	18020.0
2014-01-09 08:00:00	AMZN	Stock	20.126	20.2	20.096	20.1875	121220.0
2014-01-09 09:00:00	AMZN	Stock	20.2	20.3445	20.15	20.1809	9679220.0
2014-01-09 10:00:00	AMZN	Stock	20.186	20.2215	20.0125	20.044	8525580.0
2014-01-09 11:00:00	AMZN	Stock	20.0445	20.092	19.98	20.044	4112200.0

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

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