PREVIEW / stock_1hour / 2012-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-22.parquet
  size:    912 KB
  rows:    43,121
  symbols: 3,460

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-22 04:00:00	AAPL	Stock	23.4286	23.5	23.4286	23.5	33600.0
2012-08-22 05:00:00	AAPL	Stock	23.5	23.5	23.475	23.4875	47684.0
2012-08-22 06:00:00	AAPL	Stock	23.4696	23.4839	23.4286	23.4286	51800.0
2012-08-22 07:00:00	AAPL	Stock	23.4143	23.4464	23.3611	23.4136	627956.0
2012-08-22 08:00:00	AAPL	Stock	23.4057	23.5479	23.3918	23.5179	2659076.0
2012-08-22 09:00:00	AAPL	Stock	23.5179	23.5179	23.1468	23.3918	109585616.0
2012-08-22 10:00:00	AAPL	Stock	23.3918	23.5957	23.3571	23.5236	116049304.0
2012-08-22 11:00:00	AAPL	Stock	23.5221	23.6768	23.515	23.6751	62554240.0
2012-08-22 12:00:00	AAPL	Stock	23.6764	23.7029	23.5304	23.5346	51250640.0
2012-08-22 13:00:00	AAPL	Stock	23.5346	23.6661	23.5175	23.5804	35801080.0
2012-08-22 14:00:00	AAPL	Stock	23.5804	23.8093	23.5804	23.8079	69852216.0
2012-08-22 15:00:00	AAPL	Stock	23.8079	23.8929	23.7657	23.8886	100432556.0
2012-08-22 16:00:00	AAPL	Stock	23.8914	23.9175	23.2762	23.9143	8461964.0
2012-08-22 17:00:00	AAPL	Stock	23.9107	23.9107	23.8882	23.9021	530936.0
2012-08-22 18:00:00	AAPL	Stock	23.9	23.9064	23.8125	23.8125	909412.0
2012-08-22 19:00:00	AAPL	Stock	23.8036	23.8929	23.7861	23.89	563192.0
2012-08-22 08:00:00	MSFT	Stock	30.69	30.73	30.64	30.65	81521.0
2012-08-22 09:00:00	MSFT	Stock	30.64	30.74	30.4	30.67	3237391.0
2012-08-22 10:00:00	MSFT	Stock	30.67	30.76	30.6	30.655	5266725.0
2012-08-22 11:00:00	MSFT	Stock	30.655	30.69	30.57	30.59	4199027.0
2012-08-22 12:00:00	MSFT	Stock	30.6	30.61	30.5	30.53	3414222.0
2012-08-22 13:00:00	MSFT	Stock	30.53	30.56	30.465	30.53	3493188.0
2012-08-22 14:00:00	MSFT	Stock	30.53	30.65	30.47	30.64	5520246.0
2012-08-22 15:00:00	MSFT	Stock	30.635	30.69	30.53	30.54	5519905.0
2012-08-22 16:00:00	MSFT	Stock	30.57	30.619	30.54	30.57	2095890.0
2012-08-22 17:00:00	MSFT	Stock	30.57	30.57	30.44	30.44	108617.0
2012-08-22 18:00:00	MSFT	Stock	30.54	30.57	30.4	30.44	7941.0
2012-08-22 19:00:00	MSFT	Stock	30.45	30.45	30.45	30.45	460.0
2012-08-22 08:00:00	NVDA	Stock	0.3642	0.3652	0.3642	0.3652	100000.0
2012-08-22 09:00:00	NVDA	Stock	0.3635	0.3651	0.3618	0.3641	18972000.0
2012-08-22 10:00:00	NVDA	Stock	0.3642	0.3668	0.3632	0.3635	56072120.0
2012-08-22 11:00:00	NVDA	Stock	0.3635	0.3645	0.3628	0.3635	29744160.0
2012-08-22 12:00:00	NVDA	Stock	0.3635	0.3638	0.3618	0.3622	26269080.0
2012-08-22 13:00:00	NVDA	Stock	0.3621	0.364	0.362	0.3635	18220760.0
2012-08-22 14:00:00	NVDA	Stock	0.3635	0.3672	0.363	0.3668	43665680.0
2012-08-22 15:00:00	NVDA	Stock	0.367	0.3675	0.3642	0.366	109329680.0
2012-08-22 16:00:00	NVDA	Stock	0.3662	0.3662	0.3648	0.366	10879520.0
2012-08-22 17:00:00	NVDA	Stock	0.3658	0.3658	0.3658	0.3658	4000.0
2012-08-22 18:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	16000.0
2012-08-22 19:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	36000.0
2012-08-22 08:00:00	AMZN	Stock	11.9545	11.9545	11.928	11.9425	71000.0
2012-08-22 09:00:00	AMZN	Stock	11.9425	12.1163	11.93	12.1045	6813540.0
2012-08-22 10:00:00	AMZN	Stock	12.1065	12.11	12.0	12.0145	7912420.0
2012-08-22 11:00:00	AMZN	Stock	12.015	12.0925	12.005	12.0845	4383640.0
2012-08-22 12:00:00	AMZN	Stock	12.0845	12.093	12.04	12.0738	2204800.0
2012-08-22 13:00:00	AMZN	Stock	12.07	12.1375	12.0635	12.1121	4098120.0
2012-08-22 14:00:00	AMZN	Stock	12.1115	12.225	12.098	12.2175	10198500.0
2012-08-22 15:00:00	AMZN	Stock	12.2155	12.245	12.155	12.155	11132800.0
2012-08-22 16:00:00	AMZN	Stock	12.1515	12.1946	12.1134	12.155	85180.0
2012-08-22 17:00:00	AMZN	Stock	12.1565	12.1565	12.155	12.155	21700.0

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

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