PREVIEW / stock_1hour / 2013-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-18.parquet
  size:    994 KB
  rows:    46,262
  symbols: 3,515

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-18 06:00:00	AAPL	Stock	15.4746	15.4746	15.4746	15.4746	2800.0
2013-06-18 07:00:00	AAPL	Stock	15.4768	15.4768	15.4318	15.4468	40012.0
2013-06-18 08:00:00	AAPL	Stock	15.4671	15.4671	15.4107	15.4214	713748.0
2013-06-18 09:00:00	AAPL	Stock	15.4279	15.4761	15.3646	15.4511	35573020.0
2013-06-18 10:00:00	AAPL	Stock	15.4489	15.5321	15.4293	15.4946	37281384.0
2013-06-18 11:00:00	AAPL	Stock	15.4946	15.5229	15.4443	15.4621	26039888.0
2013-06-18 12:00:00	AAPL	Stock	15.4618	15.47	15.4143	15.4241	21699580.0
2013-06-18 13:00:00	AAPL	Stock	15.4264	15.4289	15.3893	15.4204	16296672.0
2013-06-18 14:00:00	AAPL	Stock	15.4218	15.4429	15.4054	15.4268	16726220.0
2013-06-18 15:00:00	AAPL	Stock	15.4268	15.4343	15.4004	15.4195	27087872.0
2013-06-18 16:00:00	AAPL	Stock	15.4195	15.4464	15.3971	15.4018	9562000.0
2013-06-18 17:00:00	AAPL	Stock	15.4	15.4204	15.3875	15.3946	1801716.0
2013-06-18 18:00:00	AAPL	Stock	15.3964	15.3979	15.3911	15.3911	38024.0
2013-06-18 19:00:00	AAPL	Stock	15.3911	15.4018	15.3911	15.4018	108696.0
2013-06-18 08:00:00	MSFT	Stock	35.0	35.06	34.99	35.0	28398.0
2013-06-18 09:00:00	MSFT	Stock	34.97	35.102	34.895	34.955	3818810.0
2013-06-18 10:00:00	MSFT	Stock	34.955	35.17	34.95	35.09	4593349.0
2013-06-18 11:00:00	MSFT	Stock	35.09	35.11	35.015	35.07	3364281.0
2013-06-18 12:00:00	MSFT	Stock	35.07	35.08	35.02	35.075	2187926.0
2013-06-18 13:00:00	MSFT	Stock	35.078	35.1	35.04	35.04	2190902.0
2013-06-18 14:00:00	MSFT	Stock	35.044	35.07	34.98	35.05	2739001.0
2013-06-18 15:00:00	MSFT	Stock	35.045	35.06	34.94	35.01	4450546.0
2013-06-18 16:00:00	MSFT	Stock	35.01	35.084	34.973	35.017	3853481.0
2013-06-18 17:00:00	MSFT	Stock	35.02	35.02	34.99	35.01	422677.0
2013-06-18 18:00:00	MSFT	Stock	35.01	35.05	35.01	35.04	1775.0
2013-06-18 19:00:00	MSFT	Stock	35.04	35.05	34.94	34.95	6285.0
2013-06-18 07:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	4000.0
2013-06-18 08:00:00	NVDA	Stock	0.3652	0.3655	0.3652	0.3655	32000.0
2013-06-18 09:00:00	NVDA	Stock	0.3638	0.368	0.3638	0.3652	22019520.0
2013-06-18 10:00:00	NVDA	Stock	0.3652	0.366	0.3612	0.3632	93600680.0
2013-06-18 11:00:00	NVDA	Stock	0.3632	0.3635	0.361	0.361	35299800.0
2013-06-18 12:00:00	NVDA	Stock	0.361	0.3615	0.3605	0.361	26165880.0
2013-06-18 13:00:00	NVDA	Stock	0.361	0.3615	0.3592	0.3608	36976320.0
2013-06-18 14:00:00	NVDA	Stock	0.3608	0.3624	0.3598	0.3621	34685080.0
2013-06-18 15:00:00	NVDA	Stock	0.3621	0.3622	0.357	0.3598	177599360.0
2013-06-18 16:00:00	NVDA	Stock	0.36	0.3617	0.36	0.3601	55843880.0
2013-06-18 17:00:00	NVDA	Stock	0.3615	0.3615	0.36	0.3612	1412000.0
2013-06-18 05:00:00	AMZN	Stock	13.9205	13.9375	13.9205	13.9375	6000.0
2013-06-18 07:00:00	AMZN	Stock	13.9275	13.9275	13.9275	13.9275	2000.0
2013-06-18 08:00:00	AMZN	Stock	13.8995	13.9495	13.8725	13.949	353760.0
2013-06-18 09:00:00	AMZN	Stock	13.9385	14.023	13.9055	13.994	6616800.0
2013-06-18 10:00:00	AMZN	Stock	13.9835	14.075	13.9695	14.0645	7354160.0
2013-06-18 11:00:00	AMZN	Stock	14.0635	14.0875	14.0445	14.0545	3913960.0
2013-06-18 12:00:00	AMZN	Stock	14.0515	14.085	14.023	14.0725	3807940.0
2013-06-18 13:00:00	AMZN	Stock	14.074	14.095	14.0532	14.0925	3298800.0
2013-06-18 14:00:00	AMZN	Stock	14.092	14.132	14.0655	14.132	6038920.0
2013-06-18 15:00:00	AMZN	Stock	14.128	14.1455	14.087	14.0878	8488640.0
2013-06-18 16:00:00	AMZN	Stock	14.088	14.1198	14.0593	14.11	497220.0
2013-06-18 17:00:00	AMZN	Stock	14.0715	14.1225	14.0715	14.1125	474000.0
2013-06-18 18:00:00	AMZN	Stock	14.12	14.1215	14.12	14.1215	9000.0

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

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