PREVIEW / stock_1hour / 2013-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-29.parquet
  size:    984 KB
  rows:    45,676
  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-08-29 04:00:00	AAPL	Stock	17.5821	17.6464	17.5821	17.6429	75040.0
2013-08-29 05:00:00	AAPL	Stock	17.6136	17.6136	17.5821	17.5821	14000.0
2013-08-29 07:00:00	AAPL	Stock	17.6036	17.6786	17.5893	17.6589	254576.0
2013-08-29 08:00:00	AAPL	Stock	17.66	17.6607	17.5893	17.6393	1589308.0
2013-08-29 09:00:00	AAPL	Stock	17.6389	17.7321	17.5439	17.7125	56323680.0
2013-08-29 10:00:00	AAPL	Stock	17.7139	17.7321	17.6461	17.6516	41914376.0
2013-08-29 11:00:00	AAPL	Stock	17.6536	17.7275	17.65	17.7232	25782120.0
2013-08-29 12:00:00	AAPL	Stock	17.7236	17.7261	17.6504	17.6646	18861528.0
2013-08-29 13:00:00	AAPL	Stock	17.6643	17.6861	17.6129	17.6357	24068520.0
2013-08-29 14:00:00	AAPL	Stock	17.635	17.6568	17.6196	17.6389	18850580.0
2013-08-29 15:00:00	AAPL	Stock	17.6379	17.6386	17.5404	17.5579	40828508.0
2013-08-29 16:00:00	AAPL	Stock	17.5618	17.6726	17.5411	17.5679	7394072.0
2013-08-29 17:00:00	AAPL	Stock	17.5579	17.5689	17.5579	17.5689	209916.0
2013-08-29 18:00:00	AAPL	Stock	17.5711	17.5814	17.57	17.5743	220220.0
2013-08-29 19:00:00	AAPL	Stock	17.5768	17.5857	17.5768	17.5818	203644.0
2013-08-29 07:00:00	MSFT	Stock	33.24	33.26	33.05	33.05	3000.0
2013-08-29 08:00:00	MSFT	Stock	33.25	33.25	33.1	33.1	12380.0
2013-08-29 09:00:00	MSFT	Stock	33.1	33.27	32.8	33.21	6202888.0
2013-08-29 10:00:00	MSFT	Stock	33.2	33.35	33.18	33.291	6373919.0
2013-08-29 11:00:00	MSFT	Stock	33.3	33.6	33.26	33.503	5722575.0
2013-08-29 12:00:00	MSFT	Stock	33.51	33.51	33.3	33.405	3794756.0
2013-08-29 13:00:00	MSFT	Stock	33.41	33.42	33.27	33.35	3476048.0
2013-08-29 14:00:00	MSFT	Stock	33.35	33.45	33.34	33.41	5221360.0
2013-08-29 15:00:00	MSFT	Stock	33.41	33.56	33.33	33.55	11543765.0
2013-08-29 16:00:00	MSFT	Stock	33.56	33.6	33.338	33.5	2165194.0
2013-08-29 17:00:00	MSFT	Stock	33.5	33.55	33.5	33.55	4100.0
2013-08-29 18:00:00	MSFT	Stock	33.49	33.55	33.48	33.5	7665.0
2013-08-29 19:00:00	MSFT	Stock	33.56	33.56	33.5	33.55	5400.0
2013-08-29 09:00:00	NVDA	Stock	0.3688	0.3728	0.3678	0.3703	20978960.0
2013-08-29 10:00:00	NVDA	Stock	0.3703	0.3725	0.3703	0.372	33713160.0
2013-08-29 11:00:00	NVDA	Stock	0.372	0.3723	0.3699	0.3701	16110520.0
2013-08-29 12:00:00	NVDA	Stock	0.37	0.3705	0.3692	0.3695	15036200.0
2013-08-29 13:00:00	NVDA	Stock	0.3695	0.3703	0.3688	0.3697	17835040.0
2013-08-29 14:00:00	NVDA	Stock	0.3698	0.3705	0.3692	0.3692	24288080.0
2013-08-29 15:00:00	NVDA	Stock	0.3694	0.3698	0.3688	0.3692	37516000.0
2013-08-29 16:00:00	NVDA	Stock	0.3692	0.3704	0.3678	0.3692	10321800.0
2013-08-29 17:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	40000.0
2013-08-29 07:00:00	AMZN	Stock	14.145	14.145	14.103	14.103	4800.0
2013-08-29 08:00:00	AMZN	Stock	14.13	14.1375	14.13	14.1375	30000.0
2013-08-29 09:00:00	AMZN	Stock	14.1135	14.1625	14.0	14.0995	3955440.0
2013-08-29 10:00:00	AMZN	Stock	14.1045	14.255	14.103	14.233	9215380.0
2013-08-29 11:00:00	AMZN	Stock	14.2355	14.271	14.211	14.2675	2064580.0
2013-08-29 12:00:00	AMZN	Stock	14.265	14.2785	14.2375	14.268	2137580.0
2013-08-29 13:00:00	AMZN	Stock	14.2653	14.294	14.1935	14.215	2256560.0
2013-08-29 14:00:00	AMZN	Stock	14.2165	14.299	14.208	14.2825	2501220.0
2013-08-29 15:00:00	AMZN	Stock	14.2792	14.294	14.1985	14.1995	7120240.0
2013-08-29 16:00:00	AMZN	Stock	14.2	14.2458	14.0625	14.2	730580.0
2013-08-29 17:00:00	AMZN	Stock	14.1655	14.1655	14.1655	14.1655	2000.0
2013-08-29 19:00:00	AMZN	Stock	14.1755	14.1755	14.1755	14.1755	2600.0
2013-08-29 04:00:00	META	Stock	40.55	40.85	40.55	40.85	1800.0

> showing 50 of 45,676 rows — these rows as CSV

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