PREVIEW / stock_1hour / 2014-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-18.parquet
  size:    1.1 MB
  rows:    50,139
  symbols: 3,589

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-08-18 04:00:00	AAPL	Stock	24.495	24.65	24.495	24.6375	13420.0
2014-08-18 05:00:00	AAPL	Stock	24.63	24.645	24.625	24.625	7600.0
2014-08-18 06:00:00	AAPL	Stock	24.63	24.6475	24.625	24.625	47960.0
2014-08-18 07:00:00	AAPL	Stock	24.6325	24.665	24.63	24.65	189452.0
2014-08-18 08:00:00	AAPL	Stock	24.6525	24.6725	24.61	24.6425	895264.0
2014-08-18 09:00:00	AAPL	Stock	24.6425	24.6825	24.495	24.6775	31728500.0
2014-08-18 10:00:00	AAPL	Stock	24.6775	24.7475	24.635	24.745	24840320.0
2014-08-18 11:00:00	AAPL	Stock	24.745	24.7825	24.5625	24.7375	23141028.0
2014-08-18 12:00:00	AAPL	Stock	24.7385	24.77	24.715	24.77	14059800.0
2014-08-18 13:00:00	AAPL	Stock	24.7688	24.8425	24.7625	24.8142	18109520.0
2014-08-18 14:00:00	AAPL	Stock	24.8142	24.835	24.765	24.795	17672552.0
2014-08-18 15:00:00	AAPL	Stock	24.795	24.81	24.7675	24.785	24358132.0
2014-08-18 16:00:00	AAPL	Stock	24.79	24.805	24.7372	24.7925	22688552.0
2014-08-18 17:00:00	AAPL	Stock	24.8	25.7195	24.79	24.8125	725812.0
2014-08-18 18:00:00	AAPL	Stock	24.8125	24.8325	24.79	24.8125	346212.0
2014-08-18 19:00:00	AAPL	Stock	24.8225	24.8325	24.815	24.8325	104604.0
2014-08-18 07:00:00	MSFT	Stock	44.85	45.15	44.85	45.05	4110.0
2014-08-18 08:00:00	MSFT	Stock	45.05	45.11	44.98	45.0	18232.0
2014-08-18 09:00:00	MSFT	Stock	45.0	45.02	44.68	44.83	3447865.0
2014-08-18 10:00:00	MSFT	Stock	44.83	44.92	44.765	44.912	3568478.0
2014-08-18 11:00:00	MSFT	Stock	44.91	45.0	44.7	44.845	3247406.0
2014-08-18 12:00:00	MSFT	Stock	44.85	44.94	44.84	44.91	1415806.0
2014-08-18 13:00:00	MSFT	Stock	44.91	44.96	44.86	44.93	1534862.0
2014-08-18 14:00:00	MSFT	Stock	44.935	45.05	44.93	45.04	3335037.0
2014-08-18 15:00:00	MSFT	Stock	45.035	45.11	45.01	45.105	4224210.0
2014-08-18 16:00:00	MSFT	Stock	45.11	45.12	44.907	45.11	4395437.0
2014-08-18 17:00:00	MSFT	Stock	45.07	45.07	45.0	45.01	6531.0
2014-08-18 18:00:00	MSFT	Stock	45.11	45.11	45.02	45.07	7376.0
2014-08-18 19:00:00	MSFT	Stock	45.08	45.08	45.05	45.08	4080.0
2014-08-18 06:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	4000.0
2014-08-18 08:00:00	NVDA	Stock	0.4793	0.4795	0.4793	0.4795	184000.0
2014-08-18 09:00:00	NVDA	Stock	0.4778	0.48	0.4732	0.4795	26585800.0
2014-08-18 10:00:00	NVDA	Stock	0.4795	0.482	0.479	0.4805	45775000.0
2014-08-18 11:00:00	NVDA	Stock	0.4808	0.4818	0.4738	0.4809	28636480.0
2014-08-18 12:00:00	NVDA	Stock	0.4809	0.4812	0.4796	0.4798	26153720.0
2014-08-18 13:00:00	NVDA	Stock	0.4798	0.4818	0.4795	0.481	21230800.0
2014-08-18 14:00:00	NVDA	Stock	0.481	0.4812	0.4798	0.4808	21730120.0
2014-08-18 15:00:00	NVDA	Stock	0.4805	0.483	0.4805	0.4824	57777520.0
2014-08-18 16:00:00	NVDA	Stock	0.482	0.4826	0.4804	0.4825	1709640.0
2014-08-18 18:00:00	NVDA	Stock	0.4822	0.4838	0.4822	0.4838	68000.0
2014-08-18 19:00:00	NVDA	Stock	0.4805	0.4805	0.4805	0.4805	40000.0
2014-08-18 04:00:00	AMZN	Stock	16.775	16.775	16.775	16.775	2000.0
2014-08-18 07:00:00	AMZN	Stock	16.7935	16.7935	16.735	16.735	24160.0
2014-08-18 08:00:00	AMZN	Stock	16.7675	16.7995	16.7525	16.7825	164180.0
2014-08-18 09:00:00	AMZN	Stock	16.7995	16.89	16.772	16.8705	8716580.0
2014-08-18 10:00:00	AMZN	Stock	16.8745	16.881	16.801	16.8088	6506740.0
2014-08-18 11:00:00	AMZN	Stock	16.8065	16.888	16.7414	16.762	6036400.0
2014-08-18 12:00:00	AMZN	Stock	16.7625	16.803	16.7312	16.736	3999160.0
2014-08-18 13:00:00	AMZN	Stock	16.733	16.776	16.715	16.732	3927460.0
2014-08-18 14:00:00	AMZN	Stock	16.734	16.753	16.694	16.6995	3837000.0

> showing 50 of 50,139 rows — these rows as CSV

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