PREVIEW / stock_1hour / 2014-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-04.parquet
  size:    1.1 MB
  rows:    50,554
  symbols: 3,547

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-03-04 04:00:00	AAPL	Stock	18.9175	18.9643	18.9175	18.9214	16800.0
2014-03-04 05:00:00	AAPL	Stock	18.9586	19.025	18.9586	19.025	105896.0
2014-03-04 06:00:00	AAPL	Stock	19.0357	19.0357	18.9804	19.0046	181524.0
2014-03-04 07:00:00	AAPL	Stock	19.0068	19.0307	18.995	19.0	280336.0
2014-03-04 08:00:00	AAPL	Stock	19.0036	19.0236	18.9379	18.9718	1626240.0
2014-03-04 09:00:00	AAPL	Stock	18.9718	19.0229	18.9	18.9675	32169424.0
2014-03-04 10:00:00	AAPL	Stock	18.9721	18.9904	18.9329	18.9736	29454292.0
2014-03-04 11:00:00	AAPL	Stock	18.9718	19.0071	18.9561	18.9657	22012984.0
2014-03-04 12:00:00	AAPL	Stock	18.9671	18.9896	18.9482	18.9653	15165836.0
2014-03-04 13:00:00	AAPL	Stock	18.9629	18.9711	18.8779	18.8807	20327888.0
2014-03-04 14:00:00	AAPL	Stock	18.8796	18.9404	18.8489	18.9311	21050400.0
2014-03-04 15:00:00	AAPL	Stock	18.9307	18.9729	18.9147	18.9729	37665880.0
2014-03-04 16:00:00	AAPL	Stock	18.9729	18.9767	18.9529	18.9704	10999520.0
2014-03-04 17:00:00	AAPL	Stock	18.9696	18.9729	18.9664	18.9671	67564.0
2014-03-04 18:00:00	AAPL	Stock	18.9696	18.9729	18.9643	18.9643	202160.0
2014-03-04 19:00:00	AAPL	Stock	18.9521	18.9643	18.9475	18.9589	156464.0
2014-03-04 05:00:00	MSFT	Stock	37.99	38.02	37.99	38.02	300.0
2014-03-04 06:00:00	MSFT	Stock	38.05	38.11	38.05	38.11	286.0
2014-03-04 07:00:00	MSFT	Stock	38.1	38.25	38.1	38.15	2668.0
2014-03-04 08:00:00	MSFT	Stock	38.11	38.15	38.0	38.01	11489.0
2014-03-04 09:00:00	MSFT	Stock	38.02	38.48	38.02	38.435	3437204.0
2014-03-04 10:00:00	MSFT	Stock	38.44	38.48	38.21	38.22	3694433.0
2014-03-04 11:00:00	MSFT	Stock	38.22	38.265	38.12	38.14	2894158.0
2014-03-04 12:00:00	MSFT	Stock	38.15	38.27	38.14	38.255	2706720.0
2014-03-04 13:00:00	MSFT	Stock	38.25	38.38	38.24	38.3	2419165.0
2014-03-04 14:00:00	MSFT	Stock	38.3	38.38	38.27	38.35	1799392.0
2014-03-04 15:00:00	MSFT	Stock	38.36	38.45	38.35	38.4	6028490.0
2014-03-04 16:00:00	MSFT	Stock	38.41	38.52	37.72	38.384	2699761.0
2014-03-04 17:00:00	MSFT	Stock	38.44	38.44	38.36	38.36	2181.0
2014-03-04 18:00:00	MSFT	Stock	38.41	38.41	38.35	38.35	60532.0
2014-03-04 19:00:00	MSFT	Stock	38.35	38.35	38.3	38.3	5399.0
2014-03-04 08:00:00	NVDA	Stock	0.4582	0.4582	0.4582	0.4582	8000.0
2014-03-04 09:00:00	NVDA	Stock	0.462	0.465	0.4588	0.4628	45296640.0
2014-03-04 10:00:00	NVDA	Stock	0.4628	0.4633	0.4598	0.4626	41216760.0
2014-03-04 11:00:00	NVDA	Stock	0.4628	0.4635	0.4618	0.4629	20622880.0
2014-03-04 12:00:00	NVDA	Stock	0.4628	0.4643	0.462	0.4621	17438200.0
2014-03-04 13:00:00	NVDA	Stock	0.4621	0.464	0.4615	0.4619	23851520.0
2014-03-04 14:00:00	NVDA	Stock	0.4619	0.4633	0.4612	0.4626	20835720.0
2014-03-04 15:00:00	NVDA	Stock	0.4628	0.4636	0.462	0.462	38455600.0
2014-03-04 16:00:00	NVDA	Stock	0.462	0.4624	0.4619	0.4619	43970440.0
2014-03-04 18:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	134960.0
2014-03-04 19:00:00	NVDA	Stock	0.459	0.459	0.459	0.459	40000.0
2014-03-04 04:00:00	AMZN	Stock	18.0625	18.1225	18.0625	18.1225	4000.0
2014-03-04 06:00:00	AMZN	Stock	18.183	18.195	18.183	18.195	12600.0
2014-03-04 07:00:00	AMZN	Stock	18.2	18.2	18.1465	18.1505	106940.0
2014-03-04 08:00:00	AMZN	Stock	18.164	18.1645	18.119	18.1645	76260.0
2014-03-04 09:00:00	AMZN	Stock	18.1405	18.225	18.123	18.175	8130220.0
2014-03-04 10:00:00	AMZN	Stock	18.184	18.284	18.1365	18.273	8714180.0
2014-03-04 11:00:00	AMZN	Stock	18.27	18.2775	18.166	18.199	9807640.0
2014-03-04 12:00:00	AMZN	Stock	18.1985	18.244	18.1951	18.205	4323000.0

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

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