PREVIEW / stock_1hour / 2013-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-16.parquet
  size:    1.0 MB
  rows:    47,515
  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
2013-09-16 04:00:00	AAPL	Stock	16.7118	16.725	16.7029	16.7064	100296.0
2013-09-16 05:00:00	AAPL	Stock	16.7064	16.7071	16.6821	16.6821	55664.0
2013-09-16 06:00:00	AAPL	Stock	16.6964	16.7	16.6929	16.6996	53088.0
2013-09-16 07:00:00	AAPL	Stock	16.7	16.7179	16.6089	16.6371	644000.0
2013-09-16 08:00:00	AAPL	Stock	16.6375	16.7214	16.4314	16.5068	6542004.0
2013-09-16 09:00:00	AAPL	Stock	16.5136	16.5375	16.2082	16.2732	125549424.0
2013-09-16 10:00:00	AAPL	Stock	16.2693	16.3464	16.1821	16.2	92347360.0
2013-09-16 11:00:00	AAPL	Stock	16.2	16.2646	16.1493	16.2531	51298128.0
2013-09-16 12:00:00	AAPL	Stock	16.25	16.265	16.2054	16.2318	28271404.0
2013-09-16 13:00:00	AAPL	Stock	16.2325	16.26	16.1307	16.1489	35771288.0
2013-09-16 14:00:00	AAPL	Stock	16.1514	16.1721	16.0304	16.0307	73049116.0
2013-09-16 15:00:00	AAPL	Stock	16.0346	16.0768	15.9721	16.0754	106816612.0
2013-09-16 16:00:00	AAPL	Stock	16.0757	16.2857	16.0286	16.0286	14005012.0
2013-09-16 17:00:00	AAPL	Stock	16.0286	16.0757	15.9464	15.9668	2107560.0
2013-09-16 18:00:00	AAPL	Stock	15.9732	15.9768	15.9382	15.945	655116.0
2013-09-16 19:00:00	AAPL	Stock	15.9479	15.9636	15.9429	15.9464	598976.0
2013-09-16 04:00:00	MSFT	Stock	33.0	33.36	33.0	33.36	5273.0
2013-09-16 05:00:00	MSFT	Stock	33.34	33.34	33.34	33.34	100.0
2013-09-16 06:00:00	MSFT	Stock	33.34	33.4	33.34	33.4	4050.0
2013-09-16 07:00:00	MSFT	Stock	33.38	33.38	33.31	33.34	3915.0
2013-09-16 08:00:00	MSFT	Stock	33.34	33.34	33.27	33.3	21646.0
2013-09-16 09:00:00	MSFT	Stock	33.3	33.5	33.145	33.21	7909003.0
2013-09-16 10:00:00	MSFT	Stock	33.21	33.335	33.17	33.31	9021342.0
2013-09-16 11:00:00	MSFT	Stock	33.31	33.375	33.1	33.1	4998267.0
2013-09-16 12:00:00	MSFT	Stock	33.105	33.13	32.76	32.76	6077010.0
2013-09-16 13:00:00	MSFT	Stock	32.768	32.965	32.755	32.94	5229594.0
2013-09-16 14:00:00	MSFT	Stock	32.95	32.99	32.81	32.815	4264649.0
2013-09-16 15:00:00	MSFT	Stock	32.81	32.94	32.73	32.8	11557161.0
2013-09-16 16:00:00	MSFT	Stock	32.79	33.304	32.73	32.77	4670186.0
2013-09-16 17:00:00	MSFT	Stock	32.76	32.79	32.72	32.74	11240.0
2013-09-16 18:00:00	MSFT	Stock	32.72	32.73	32.7	32.7	6863.0
2013-09-16 19:00:00	MSFT	Stock	32.74	32.74	32.74	32.74	900.0
2013-09-16 08:00:00	NVDA	Stock	0.3975	0.3988	0.3975	0.3988	149200.0
2013-09-16 09:00:00	NVDA	Stock	0.3982	0.3988	0.3955	0.3955	18707640.0
2013-09-16 10:00:00	NVDA	Stock	0.3957	0.3968	0.3938	0.3964	31931080.0
2013-09-16 11:00:00	NVDA	Stock	0.3964	0.3995	0.3962	0.3982	29299480.0
2013-09-16 12:00:00	NVDA	Stock	0.3985	0.401	0.398	0.3982	52018000.0
2013-09-16 13:00:00	NVDA	Stock	0.398	0.3987	0.3965	0.398	16931880.0
2013-09-16 14:00:00	NVDA	Stock	0.398	0.3981	0.3958	0.396	17478200.0
2013-09-16 15:00:00	NVDA	Stock	0.3959	0.3965	0.3948	0.3954	49407760.0
2013-09-16 16:00:00	NVDA	Stock	0.3955	0.3986	0.3945	0.3958	17393360.0
2013-09-16 17:00:00	NVDA	Stock	0.3962	0.3962	0.3962	0.3962	6000.0
2013-09-16 06:00:00	AMZN	Stock	15.034	15.034	15.03	15.03	9900.0
2013-09-16 07:00:00	AMZN	Stock	15.07	15.07	15.053	15.0625	16000.0
2013-09-16 08:00:00	AMZN	Stock	15.038	15.05	14.9985	15.0005	146260.0
2013-09-16 09:00:00	AMZN	Stock	15.004	15.05	14.956	14.9905	4809940.0
2013-09-16 10:00:00	AMZN	Stock	14.994	15.0125	14.8705	14.89	5162220.0
2013-09-16 11:00:00	AMZN	Stock	14.8945	14.9215	14.842	14.9	4306280.0
2013-09-16 12:00:00	AMZN	Stock	14.8995	14.9115	14.8555	14.8608	1975320.0
2013-09-16 13:00:00	AMZN	Stock	14.8608	14.9065	14.8305	14.8425	2738920.0

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

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