PREVIEW / stock_1hour / 2012-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-08.parquet
  size:    924 KB
  rows:    43,965
  symbols: 3,482

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
2012-08-08 04:00:00	AAPL	Stock	22.1179	22.1179	22.0911	22.0971	11732.0
2012-08-08 05:00:00	AAPL	Stock	22.0971	22.0971	22.0971	22.0971	37800.0
2012-08-08 06:00:00	AAPL	Stock	22.0786	22.0857	22.0786	22.0857	25200.0
2012-08-08 07:00:00	AAPL	Stock	22.0968	22.1504	22.0879	22.1071	258720.0
2012-08-08 08:00:00	AAPL	Stock	22.1504	22.1504	22.0775	22.0989	1056944.0
2012-08-08 09:00:00	AAPL	Stock	22.1018	22.1921	22.0393	22.1064	41190044.0
2012-08-08 10:00:00	AAPL	Stock	22.1064	22.1382	22.0714	22.1246	32712008.0
2012-08-08 11:00:00	AAPL	Stock	22.1279	22.2386	22.1146	22.2196	39225956.0
2012-08-08 12:00:00	AAPL	Stock	22.2218	22.2814	22.1782	22.21	31099096.0
2012-08-08 13:00:00	AAPL	Stock	22.21	22.2229	22.1675	22.1918	17961356.0
2012-08-08 14:00:00	AAPL	Stock	22.1961	22.2089	22.1504	22.1743	18421536.0
2012-08-08 15:00:00	AAPL	Stock	22.1718	22.1964	22.1236	22.1375	37457896.0
2012-08-08 16:00:00	AAPL	Stock	22.1379	22.1859	22.1071	22.1389	8772568.0
2012-08-08 17:00:00	AAPL	Stock	22.1825	22.1825	22.1304	22.1429	505344.0
2012-08-08 18:00:00	AAPL	Stock	22.1443	22.1518	22.1436	22.1436	73500.0
2012-08-08 19:00:00	AAPL	Stock	22.1461	22.1564	22.1368	22.1375	563220.0
2012-08-08 07:00:00	MSFT	Stock	30.2	30.25	30.2	30.22	3380.0
2012-08-08 08:00:00	MSFT	Stock	30.21	30.21	30.15	30.15	2650.0
2012-08-08 09:00:00	MSFT	Stock	30.15	30.3	30.11	30.277	3138075.0
2012-08-08 10:00:00	MSFT	Stock	30.27	30.39	30.25	30.295	3680391.0
2012-08-08 11:00:00	MSFT	Stock	30.295	30.47	30.27	30.446	3973130.0
2012-08-08 12:00:00	MSFT	Stock	30.445	30.46	30.36	30.425	2557206.0
2012-08-08 13:00:00	MSFT	Stock	30.42	30.47	30.41	30.43	1866391.0
2012-08-08 14:00:00	MSFT	Stock	30.44	30.45	30.33	30.35	2475158.0
2012-08-08 15:00:00	MSFT	Stock	30.35	30.4	30.28	30.32	6141173.0
2012-08-08 16:00:00	MSFT	Stock	30.32	30.47	30.3	30.32	1968969.0
2012-08-08 17:00:00	MSFT	Stock	30.32	30.32	30.29	30.3	2344.0
2012-08-08 18:00:00	MSFT	Stock	30.3	30.3	30.29	30.29	951.0
2012-08-08 19:00:00	MSFT	Stock	30.31	30.31	30.3	30.3	200.0
2012-08-08 08:00:00	NVDA	Stock	0.3538	0.3545	0.3525	0.3545	178200.0
2012-08-08 09:00:00	NVDA	Stock	0.355	0.3595	0.3533	0.3555	54256480.0
2012-08-08 10:00:00	NVDA	Stock	0.3556	0.357	0.3525	0.3533	55009720.0
2012-08-08 11:00:00	NVDA	Stock	0.3533	0.3578	0.3533	0.3562	38810000.0
2012-08-08 12:00:00	NVDA	Stock	0.3564	0.3592	0.3562	0.3592	63833880.0
2012-08-08 13:00:00	NVDA	Stock	0.359	0.3592	0.3582	0.3588	37062240.0
2012-08-08 14:00:00	NVDA	Stock	0.3588	0.3589	0.356	0.3561	54514720.0
2012-08-08 15:00:00	NVDA	Stock	0.3562	0.3578	0.3545	0.3555	156181840.0
2012-08-08 16:00:00	NVDA	Stock	0.3558	0.358	0.3553	0.358	50952800.0
2012-08-08 17:00:00	NVDA	Stock	0.358	0.358	0.356	0.3565	196000.0
2012-08-08 18:00:00	NVDA	Stock	0.3565	0.3582	0.3565	0.3582	194000.0
2012-08-08 19:00:00	NVDA	Stock	0.3578	0.3588	0.3578	0.358	263200.0
2012-08-08 07:00:00	AMZN	Stock	11.7995	11.7995	11.78	11.7925	16000.0
2012-08-08 08:00:00	AMZN	Stock	11.7745	11.786	11.735	11.741	125900.0
2012-08-08 09:00:00	AMZN	Stock	11.7565	11.8225	11.7415	11.764	4586220.0
2012-08-08 10:00:00	AMZN	Stock	11.7625	11.8135	11.7104	11.7195	5711920.0
2012-08-08 11:00:00	AMZN	Stock	11.723	11.7935	11.706	11.763	3882040.0
2012-08-08 12:00:00	AMZN	Stock	11.764	11.7733	11.7035	11.7385	2996200.0
2012-08-08 13:00:00	AMZN	Stock	11.733	11.7375	11.6796	11.705	3790660.0
2012-08-08 14:00:00	AMZN	Stock	11.705	11.719	11.68	11.702	2775780.0
2012-08-08 15:00:00	AMZN	Stock	11.7015	11.7325	11.6975	11.7185	5565360.0

> showing 50 of 43,965 rows — these rows as CSV

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