PREVIEW / stock_1hour / 2012-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-22.parquet
  size:    934 KB
  rows:    43,978
  symbols: 3,438

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-10-22 04:00:00	AAPL	Stock	21.8571	21.8571	21.8129	21.8286	216468.0
2012-10-22 05:00:00	AAPL	Stock	21.8214	21.8929	21.8214	21.875	270340.0
2012-10-22 06:00:00	AAPL	Stock	21.875	21.8929	21.8304	21.8393	222320.0
2012-10-22 07:00:00	AAPL	Stock	21.85	21.9325	21.8393	21.8857	1112104.0
2012-10-22 08:00:00	AAPL	Stock	21.8896	21.9286	21.775	21.775	7349636.0
2012-10-22 09:00:00	AAPL	Stock	21.7757	22.2171	21.7571	22.1153	110599188.0
2012-10-22 10:00:00	AAPL	Stock	22.1125	22.2818	22.0846	22.1011	88593484.0
2012-10-22 11:00:00	AAPL	Stock	22.0957	22.3107	22.0575	22.2679	64942640.0
2012-10-22 12:00:00	AAPL	Stock	22.2679	22.3393	22.2325	22.3124	43132376.0
2012-10-22 13:00:00	AAPL	Stock	22.31	22.3479	22.1971	22.287	54949216.0
2012-10-22 14:00:00	AAPL	Stock	22.2818	22.4268	22.275	22.4046	46679276.0
2012-10-22 15:00:00	AAPL	Stock	22.4046	22.6921	22.3696	22.6486	99338484.0
2012-10-22 16:00:00	AAPL	Stock	22.6486	22.6964	21.9741	22.6925	16132592.0
2012-10-22 17:00:00	AAPL	Stock	22.6893	22.7107	22.6836	22.7039	805028.0
2012-10-22 18:00:00	AAPL	Stock	22.7054	22.7393	22.6936	22.7214	414008.0
2012-10-22 19:00:00	AAPL	Stock	22.7232	22.7411	22.7207	22.7411	403844.0
2012-10-22 06:00:00	MSFT	Stock	28.85	28.85	28.85	28.85	200.0
2012-10-22 07:00:00	MSFT	Stock	28.85	28.92	28.8	28.8	16520.0
2012-10-22 08:00:00	MSFT	Stock	28.8	28.92	28.71	28.71	50231.0
2012-10-22 09:00:00	MSFT	Stock	28.7	28.83	28.26	28.27	7915604.0
2012-10-22 10:00:00	MSFT	Stock	28.28	28.38	28.07	28.12	11875009.0
2012-10-22 11:00:00	MSFT	Stock	28.12	28.18	28.03	28.04	9337919.0
2012-10-22 12:00:00	MSFT	Stock	28.05	28.13	28.0	28.087	7743397.0
2012-10-22 13:00:00	MSFT	Stock	28.08	28.097	27.83	27.97	14005343.0
2012-10-22 14:00:00	MSFT	Stock	27.97	28.04	27.91	27.95	9652132.0
2012-10-22 15:00:00	MSFT	Stock	27.955	28.06	27.93	28.0	18224624.0
2012-10-22 16:00:00	MSFT	Stock	27.997	28.64	27.971	28.05	2890224.0
2012-10-22 17:00:00	MSFT	Stock	28.05	28.664	28.03	28.05	15214.0
2012-10-22 18:00:00	MSFT	Stock	28.06	28.07	28.03	28.06	7804.0
2012-10-22 19:00:00	MSFT	Stock	28.03	28.07	28.03	28.04	8300.0
2012-10-22 08:00:00	NVDA	Stock	0.303	0.3042	0.303	0.3042	68000.0
2012-10-22 09:00:00	NVDA	Stock	0.3038	0.3058	0.3008	0.3025	63409560.0
2012-10-22 10:00:00	NVDA	Stock	0.3026	0.3042	0.3	0.3	69889400.0
2012-10-22 11:00:00	NVDA	Stock	0.3	0.3008	0.2978	0.2992	73320120.0
2012-10-22 12:00:00	NVDA	Stock	0.299	0.3	0.2985	0.2998	43507040.0
2012-10-22 13:00:00	NVDA	Stock	0.2995	0.3002	0.2968	0.2978	52755720.0
2012-10-22 14:00:00	NVDA	Stock	0.298	0.2992	0.2978	0.2982	51795000.0
2012-10-22 15:00:00	NVDA	Stock	0.2982	0.2995	0.2978	0.2991	113287680.0
2012-10-22 16:00:00	NVDA	Stock	0.2992	0.3	0.2988	0.2993	2027320.0
2012-10-22 17:00:00	NVDA	Stock	0.303	0.303	0.303	0.303	394160.0
2012-10-22 18:00:00	NVDA	Stock	0.2998	0.3	0.2992	0.3	52000.0
2012-10-22 04:00:00	AMZN	Stock	12.0	12.0	12.0	12.0	4000.0
2012-10-22 05:00:00	AMZN	Stock	12.0	12.0	12.0	12.0	4000.0
2012-10-22 07:00:00	AMZN	Stock	12.025	12.025	12.025	12.025	10000.0
2012-10-22 08:00:00	AMZN	Stock	12.0175	12.0335	12.004	12.004	79300.0
2012-10-22 09:00:00	AMZN	Stock	12.0075	12.0075	11.788	11.8135	17163080.0
2012-10-22 10:00:00	AMZN	Stock	11.8195	11.868	11.7055	11.7135	16882400.0
2012-10-22 11:00:00	AMZN	Stock	11.7135	11.8	11.702	11.7675	9436080.0
2012-10-22 12:00:00	AMZN	Stock	11.766	11.768	11.681	11.7035	6364100.0
2012-10-22 13:00:00	AMZN	Stock	11.7035	11.73	11.628	11.651	9077320.0

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

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