PREVIEW / stock_1hour / 2012-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-29.parquet
  size:    916 KB
  rows:    43,098
  symbols: 3,429

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-29 04:00:00	AAPL	Stock	24.1054	24.1054	24.1054	24.1054	22400.0
2012-08-29 05:00:00	AAPL	Stock	24.0986	24.105	24.0911	24.105	11200.0
2012-08-29 06:00:00	AAPL	Stock	24.1139	24.1139	24.1139	24.1139	5600.0
2012-08-29 07:00:00	AAPL	Stock	24.1143	24.125	24.0893	24.1064	127652.0
2012-08-29 08:00:00	AAPL	Stock	24.0954	24.1307	24.0464	24.1307	1026984.0
2012-08-29 09:00:00	AAPL	Stock	24.1339	24.2025	24.0832	24.1436	44420992.0
2012-08-29 10:00:00	AAPL	Stock	24.1446	24.1782	24.0229	24.0329	43725780.0
2012-08-29 11:00:00	AAPL	Stock	24.0304	24.1304	24.0304	24.1011	25803960.0
2012-08-29 12:00:00	AAPL	Stock	24.1005	24.1246	24.0771	24.1	12090064.0
2012-08-29 13:00:00	AAPL	Stock	24.1	24.1218	24.0786	24.0927	14496972.0
2012-08-29 14:00:00	AAPL	Stock	24.0936	24.0957	24.0421	24.06	16076480.0
2012-08-29 15:00:00	AAPL	Stock	24.06	24.0786	24.0214	24.0521	28892248.0
2012-08-29 16:00:00	AAPL	Stock	24.0582	24.1607	24.04	24.0475	11465664.0
2012-08-29 17:00:00	AAPL	Stock	24.0493	24.0536	24.0357	24.0518	382844.0
2012-08-29 18:00:00	AAPL	Stock	24.0521	24.0529	24.0357	24.0446	216216.0
2012-08-29 19:00:00	AAPL	Stock	24.0436	24.0507	24.0332	24.0507	262724.0
2012-08-29 06:00:00	MSFT	Stock	30.55	30.55	30.55	30.55	237.0
2012-08-29 08:00:00	MSFT	Stock	30.64	30.66	30.6	30.65	14182.0
2012-08-29 09:00:00	MSFT	Stock	30.64	30.75	30.58	30.63	2552931.0
2012-08-29 10:00:00	MSFT	Stock	30.635	30.71	30.44	30.485	3838591.0
2012-08-29 11:00:00	MSFT	Stock	30.48	30.6	30.45	30.595	2411658.0
2012-08-29 12:00:00	MSFT	Stock	30.6	30.63	30.56	30.61	1715933.0
2012-08-29 13:00:00	MSFT	Stock	30.6	30.68	30.6	30.68	3307360.0
2012-08-29 14:00:00	MSFT	Stock	30.68	30.7	30.65	30.65	2143777.0
2012-08-29 15:00:00	MSFT	Stock	30.65	30.69	30.62	30.63	5054636.0
2012-08-29 16:00:00	MSFT	Stock	30.62	30.738	30.512	30.65	1674957.0
2012-08-29 17:00:00	MSFT	Stock	30.65	30.67	30.65	30.67	21102.0
2012-08-29 18:00:00	MSFT	Stock	30.66	30.66	30.66	30.66	900.0
2012-08-29 19:00:00	MSFT	Stock	30.66	30.66	30.65	30.65	300.0
2012-08-29 08:00:00	NVDA	Stock	0.3562	0.3572	0.3562	0.3572	60000.0
2012-08-29 09:00:00	NVDA	Stock	0.357	0.3602	0.3568	0.359	19297360.0
2012-08-29 10:00:00	NVDA	Stock	0.359	0.3602	0.357	0.3572	30703160.0
2012-08-29 11:00:00	NVDA	Stock	0.3575	0.3582	0.3568	0.3575	37454360.0
2012-08-29 12:00:00	NVDA	Stock	0.3575	0.3578	0.357	0.3572	25510640.0
2012-08-29 13:00:00	NVDA	Stock	0.3572	0.3585	0.3572	0.3578	29117160.0
2012-08-29 14:00:00	NVDA	Stock	0.358	0.3585	0.3568	0.357	28015960.0
2012-08-29 15:00:00	NVDA	Stock	0.357	0.358	0.3562	0.3578	62492800.0
2012-08-29 16:00:00	NVDA	Stock	0.3578	0.3581	0.3569	0.3569	14805840.0
2012-08-29 17:00:00	NVDA	Stock	0.358	0.358	0.358	0.358	2512920.0
2012-08-29 18:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	36000.0
2012-08-29 07:00:00	AMZN	Stock	12.325	12.325	12.3	12.3	8000.0
2012-08-29 08:00:00	AMZN	Stock	12.31	12.31	12.3025	12.3025	15620.0
2012-08-29 09:00:00	AMZN	Stock	12.3175	12.357	12.255	12.2805	4285660.0
2012-08-29 10:00:00	AMZN	Stock	12.284	12.296	12.2295	12.247	5747220.0
2012-08-29 11:00:00	AMZN	Stock	12.249	12.2822	12.24	12.2745	3099800.0
2012-08-29 12:00:00	AMZN	Stock	12.2747	12.32	12.2715	12.3015	3376820.0
2012-08-29 13:00:00	AMZN	Stock	12.301	12.3805	12.2905	12.3645	5225140.0
2012-08-29 14:00:00	AMZN	Stock	12.3635	12.372	12.3405	12.357	4102120.0
2012-08-29 15:00:00	AMZN	Stock	12.357	12.38	12.3325	12.356	6727180.0
2012-08-29 16:00:00	AMZN	Stock	12.356	12.3674	12.2671	12.364	1747140.0

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

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