PREVIEW / stock_1hour / 2013-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-17.parquet
  size:    992 KB
  rows:    46,372
  symbols: 3,526

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-06-17 04:00:00	AAPL	Stock	15.4361	15.4661	15.3571	15.4657	37156.0
2013-06-17 05:00:00	AAPL	Stock	15.4664	15.4664	15.4664	15.4664	2800.0
2013-06-17 06:00:00	AAPL	Stock	15.4679	15.4732	15.4664	15.4693	29456.0
2013-06-17 07:00:00	AAPL	Stock	15.4671	15.4814	15.4175	15.4396	639492.0
2013-06-17 08:00:00	AAPL	Stock	15.4421	15.4679	15.4011	15.4286	1537088.0
2013-06-17 09:00:00	AAPL	Stock	15.4271	15.4518	15.3701	15.4057	46325580.0
2013-06-17 10:00:00	AAPL	Stock	15.4061	15.525	15.3771	15.5072	57902404.0
2013-06-17 11:00:00	AAPL	Stock	15.5089	15.5243	15.44	15.4632	30740024.0
2013-06-17 12:00:00	AAPL	Stock	15.4614	15.4996	15.4525	15.4993	14354508.0
2013-06-17 13:00:00	AAPL	Stock	15.4977	15.5607	15.4977	15.5387	27931232.0
2013-06-17 14:00:00	AAPL	Stock	15.5411	15.5518	15.3929	15.4329	33084660.0
2013-06-17 15:00:00	AAPL	Stock	15.435	15.4643	15.408	15.4318	37057608.0
2013-06-17 16:00:00	AAPL	Stock	15.4286	15.4996	15.4204	15.435	7582064.0
2013-06-17 17:00:00	AAPL	Stock	15.4307	15.435	15.4286	15.4307	188048.0
2013-06-17 18:00:00	AAPL	Stock	15.4314	15.4318	15.4221	15.425	144060.0
2013-06-17 19:00:00	AAPL	Stock	15.425	15.4304	15.425	15.4304	23072.0
2013-06-17 04:00:00	MSFT	Stock	34.54	34.54	34.54	34.54	100.0
2013-06-17 05:00:00	MSFT	Stock	34.6	34.61	34.6	34.61	800.0
2013-06-17 06:00:00	MSFT	Stock	34.62	34.62	34.62	34.62	400.0
2013-06-17 07:00:00	MSFT	Stock	34.6	34.62	34.6	34.62	2046.0
2013-06-17 08:00:00	MSFT	Stock	34.54	34.63	34.54	34.61	10810.0
2013-06-17 09:00:00	MSFT	Stock	34.6	34.98	34.58	34.82	6067087.0
2013-06-17 10:00:00	MSFT	Stock	34.82	34.94	34.785	34.93	6643631.0
2013-06-17 11:00:00	MSFT	Stock	34.93	35.02	34.91	34.99	9284282.0
2013-06-17 12:00:00	MSFT	Stock	35.0	35.13	34.975	35.128	6164496.0
2013-06-17 13:00:00	MSFT	Stock	35.12	35.16	35.09	35.131	2411047.0
2013-06-17 14:00:00	MSFT	Stock	35.14	35.15	34.7	34.775	4714344.0
2013-06-17 15:00:00	MSFT	Stock	34.77	35.02	34.745	34.99	7483081.0
2013-06-17 16:00:00	MSFT	Stock	34.99	35.0	34.75	34.75	4913545.0
2013-06-17 17:00:00	MSFT	Stock	34.98	35.11	34.98	35.11	508.0
2013-06-17 19:00:00	MSFT	Stock	34.98	35.0	34.98	35.0	2460.0
2013-06-17 08:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	560000.0
2013-06-17 09:00:00	NVDA	Stock	0.3615	0.3655	0.3605	0.3638	32604040.0
2013-06-17 10:00:00	NVDA	Stock	0.364	0.3654	0.3637	0.3646	27093400.0
2013-06-17 11:00:00	NVDA	Stock	0.3648	0.3652	0.363	0.3635	22129840.0
2013-06-17 12:00:00	NVDA	Stock	0.3634	0.3635	0.3615	0.3632	16803760.0
2013-06-17 13:00:00	NVDA	Stock	0.363	0.3635	0.3624	0.363	18842240.0
2013-06-17 14:00:00	NVDA	Stock	0.3628	0.3632	0.3598	0.3602	35510840.0
2013-06-17 15:00:00	NVDA	Stock	0.3602	0.363	0.3595	0.3622	85378920.0
2013-06-17 16:00:00	NVDA	Stock	0.3622	0.3626	0.3622	0.3622	5059680.0
2013-06-17 06:00:00	AMZN	Stock	13.85	13.85	13.85	13.85	4000.0
2013-06-17 07:00:00	AMZN	Stock	13.8445	13.8445	13.842	13.842	6000.0
2013-06-17 08:00:00	AMZN	Stock	13.761	13.825	13.725	13.81	43340.0
2013-06-17 09:00:00	AMZN	Stock	13.8145	13.95	13.7825	13.886	10058040.0
2013-06-17 10:00:00	AMZN	Stock	13.885	13.97	13.8615	13.9605	9042800.0
2013-06-17 11:00:00	AMZN	Stock	13.9595	14.0055	13.9435	14.0018	6536540.0
2013-06-17 12:00:00	AMZN	Stock	13.996	14.01	13.9545	13.9805	4122380.0
2013-06-17 13:00:00	AMZN	Stock	13.9845	13.9895	13.945	13.956	3381720.0
2013-06-17 14:00:00	AMZN	Stock	13.9578	13.966	13.8	13.824	7746640.0
2013-06-17 15:00:00	AMZN	Stock	13.821	13.946	13.8017	13.9095	11920620.0

> showing 50 of 46,372 rows — these rows as CSV

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