PREVIEW / stock_1hour / 2012-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-09.parquet
  size:    909 KB
  rows:    43,147
  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-09 04:00:00	AAPL	Stock	22.1179	22.1179	22.1179	22.1179	4200.0
2012-08-09 07:00:00	AAPL	Stock	22.0893	22.0907	22.0021	22.05	750008.0
2012-08-09 08:00:00	AAPL	Stock	22.0536	22.0889	22.0179	22.0714	1722532.0
2012-08-09 09:00:00	AAPL	Stock	22.075	22.2	22.0536	22.1593	37652832.0
2012-08-09 10:00:00	AAPL	Stock	22.1554	22.2046	22.1311	22.1793	35856576.0
2012-08-09 11:00:00	AAPL	Stock	22.1786	22.1871	22.1089	22.1254	24796464.0
2012-08-09 12:00:00	AAPL	Stock	22.1254	22.1732	22.1175	22.1671	18696804.0
2012-08-09 13:00:00	AAPL	Stock	22.165	22.1782	22.1471	22.1643	12644828.0
2012-08-09 14:00:00	AAPL	Stock	22.1657	22.1786	22.1482	22.1504	15545404.0
2012-08-09 15:00:00	AAPL	Stock	22.1504	22.1746	22.1314	22.1689	27496812.0
2012-08-09 16:00:00	AAPL	Stock	22.1689	22.1836	22.1536	22.1832	21321972.0
2012-08-09 17:00:00	AAPL	Stock	22.1829	22.1836	22.1689	22.1793	1341368.0
2012-08-09 18:00:00	AAPL	Stock	22.1789	22.1789	22.1757	22.1786	57092.0
2012-08-09 19:00:00	AAPL	Stock	22.1768	22.1829	22.1768	22.1786	115696.0
2012-08-09 08:00:00	MSFT	Stock	30.29	30.31	30.25	30.3	2459.0
2012-08-09 09:00:00	MSFT	Stock	30.35	30.57	30.26	30.53	2349525.0
2012-08-09 10:00:00	MSFT	Stock	30.53	30.65	30.495	30.61	4145141.0
2012-08-09 11:00:00	MSFT	Stock	30.62	30.62	30.3	30.35	4177986.0
2012-08-09 12:00:00	MSFT	Stock	30.35	30.47	30.332	30.46	2391394.0
2012-08-09 13:00:00	MSFT	Stock	30.46	30.48	30.42	30.425	1403145.0
2012-08-09 14:00:00	MSFT	Stock	30.43	30.53	30.42	30.48	2486490.0
2012-08-09 15:00:00	MSFT	Stock	30.48	30.5	30.42	30.5	4671158.0
2012-08-09 16:00:00	MSFT	Stock	30.5	30.551	30.463	30.466	1107012.0
2012-08-09 17:00:00	MSFT	Stock	30.55	30.56	30.5	30.55	384236.0
2012-08-09 18:00:00	MSFT	Stock	30.54	30.55	30.54	30.54	11050.0
2012-08-09 19:00:00	MSFT	Stock	30.52	30.52	30.52	30.52	700.0
2012-08-09 08:00:00	NVDA	Stock	0.3588	0.36	0.3575	0.359	340000.0
2012-08-09 09:00:00	NVDA	Stock	0.359	0.3595	0.3558	0.3565	80097960.0
2012-08-09 10:00:00	NVDA	Stock	0.3568	0.3598	0.3562	0.3595	122297000.0
2012-08-09 11:00:00	NVDA	Stock	0.3595	0.3602	0.3572	0.3578	57208240.0
2012-08-09 12:00:00	NVDA	Stock	0.3579	0.3588	0.3572	0.3582	36372760.0
2012-08-09 13:00:00	NVDA	Stock	0.3585	0.36	0.3572	0.36	50702920.0
2012-08-09 14:00:00	NVDA	Stock	0.3599	0.3632	0.3595	0.3629	101716080.0
2012-08-09 15:00:00	NVDA	Stock	0.363	0.3685	0.3625	0.368	293083760.0
2012-08-09 16:00:00	NVDA	Stock	0.3678	0.3928	0.359	0.3878	55700560.0
2012-08-09 17:00:00	NVDA	Stock	0.388	0.388	0.3678	0.3862	9527840.0
2012-08-09 18:00:00	NVDA	Stock	0.3865	0.3865	0.3828	0.3833	2601800.0
2012-08-09 19:00:00	NVDA	Stock	0.383	0.386	0.3825	0.3838	2300680.0
2012-08-09 09:00:00	AMZN	Stock	11.6965	11.7995	11.675	11.7365	4642560.0
2012-08-09 10:00:00	AMZN	Stock	11.737	11.768	11.707	11.711	4919060.0
2012-08-09 11:00:00	AMZN	Stock	11.7125	11.74	11.675	11.703	4240440.0
2012-08-09 12:00:00	AMZN	Stock	11.7015	11.728	11.689	11.728	3307500.0
2012-08-09 13:00:00	AMZN	Stock	11.7295	11.7765	11.72	11.771	3810080.0
2012-08-09 14:00:00	AMZN	Stock	11.771	11.7755	11.7255	11.7295	2891840.0
2012-08-09 15:00:00	AMZN	Stock	11.7285	11.7335	11.6915	11.703	5142980.0
2012-08-09 16:00:00	AMZN	Stock	11.7055	11.7355	11.703	11.7325	231420.0
2012-08-09 17:00:00	AMZN	Stock	11.725	11.725	11.703	11.703	352980.0
2012-08-09 18:00:00	AMZN	Stock	11.7275	11.7275	11.7275	11.7275	6000.0
2012-08-09 19:00:00	AMZN	Stock	11.7325	11.7325	11.725	11.725	4000.0
2012-08-09 04:00:00	META	Stock	20.6	20.6	20.6	20.6	100.0

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

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