PREVIEW / stock_1hour / 2012-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-17.parquet
  size:    945 KB
  rows:    44,710
  symbols: 3,546

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-04-17 04:00:00	AAPL	Stock	20.6679	20.6679	20.2679	20.5179	614348.0
2012-04-17 05:00:00	AAPL	Stock	20.5143	20.6739	20.5143	20.6729	387828.0
2012-04-17 06:00:00	AAPL	Stock	20.6675	20.75	20.6321	20.75	507220.0
2012-04-17 07:00:00	AAPL	Stock	20.7321	20.7321	20.5446	20.6761	2467164.0
2012-04-17 08:00:00	AAPL	Stock	20.6654	20.8836	20.5821	20.7889	7513436.0
2012-04-17 09:00:00	AAPL	Stock	20.7929	21.0325	20.4254	20.9957	212469348.0
2012-04-17 10:00:00	AAPL	Stock	20.9914	21.3003	20.9375	21.2857	214290804.0
2012-04-17 11:00:00	AAPL	Stock	21.2875	21.4107	21.285	21.3774	118735624.0
2012-04-17 12:00:00	AAPL	Stock	21.378	21.5871	21.3657	21.5643	115124044.0
2012-04-17 13:00:00	AAPL	Stock	21.5643	21.651	21.4768	21.6075	99055404.0
2012-04-17 14:00:00	AAPL	Stock	21.6086	21.6418	21.5625	21.6379	65222836.0
2012-04-17 15:00:00	AAPL	Stock	21.6368	21.7857	21.6261	21.7607	154196224.0
2012-04-17 16:00:00	AAPL	Stock	21.7717	21.7794	20.6813	21.7143	12989172.0
2012-04-17 17:00:00	AAPL	Stock	21.73	21.775	21.7036	21.7157	5243532.0
2012-04-17 18:00:00	AAPL	Stock	21.7214	21.7746	21.7136	21.75	832916.0
2012-04-17 19:00:00	AAPL	Stock	21.7589	21.7589	21.735	21.75	338464.0
2012-04-17 20:00:00	AAPL	Stock	21.7586	21.7586	21.7586	21.7586	2800.0
2012-04-17 07:00:00	MSFT	Stock	31.25	31.25	31.2	31.25	822.0
2012-04-17 08:00:00	MSFT	Stock	31.22	31.25	31.16	31.25	5279.0
2012-04-17 09:00:00	MSFT	Stock	31.24	31.36	31.2	31.295	3792856.0
2012-04-17 10:00:00	MSFT	Stock	31.305	31.46	31.23	31.38	4969439.0
2012-04-17 11:00:00	MSFT	Stock	31.38	31.53	31.38	31.48	4089511.0
2012-04-17 12:00:00	MSFT	Stock	31.48	31.58	31.46	31.565	3204228.0
2012-04-17 13:00:00	MSFT	Stock	31.56	31.61	31.54	31.578	3419844.0
2012-04-17 14:00:00	MSFT	Stock	31.57	31.6	31.52	31.55	3627836.0
2012-04-17 15:00:00	MSFT	Stock	31.55	31.6	31.44	31.44	5751129.0
2012-04-17 16:00:00	MSFT	Stock	31.44	31.586	31.31	31.31	4154025.0
2012-04-17 17:00:00	MSFT	Stock	31.31	31.44	31.25	31.35	256280.0
2012-04-17 18:00:00	MSFT	Stock	31.29	31.29	31.29	31.29	700.0
2012-04-17 19:00:00	MSFT	Stock	31.38	31.38	31.3	31.3	310.0
2012-04-17 08:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	8000.0
2012-04-17 09:00:00	NVDA	Stock	0.3525	0.3542	0.3498	0.3533	36603360.0
2012-04-17 10:00:00	NVDA	Stock	0.3533	0.355	0.3513	0.3514	42174680.0
2012-04-17 11:00:00	NVDA	Stock	0.3513	0.3528	0.3513	0.3522	45809960.0
2012-04-17 12:00:00	NVDA	Stock	0.3522	0.3528	0.3513	0.3513	51388440.0
2012-04-17 13:00:00	NVDA	Stock	0.3515	0.3518	0.3493	0.3505	66358800.0
2012-04-17 14:00:00	NVDA	Stock	0.3502	0.3508	0.3495	0.35	37892640.0
2012-04-17 15:00:00	NVDA	Stock	0.35	0.3515	0.3498	0.3505	147298160.0
2012-04-17 16:00:00	NVDA	Stock	0.3502	0.3542	0.3475	0.3488	28264680.0
2012-04-17 17:00:00	NVDA	Stock	0.3495	0.3505	0.3495	0.3505	828800.0
2012-04-17 18:00:00	NVDA	Stock	0.349	0.349	0.349	0.349	12000.0
2012-04-17 19:00:00	NVDA	Stock	0.349	0.35	0.349	0.35	92000.0
2012-04-17 07:00:00	AMZN	Stock	9.333	9.333	9.333	9.333	2000.0
2012-04-17 08:00:00	AMZN	Stock	9.3025	9.345	9.3025	9.345	27860.0
2012-04-17 09:00:00	AMZN	Stock	9.3495	9.4115	9.3345	9.3835	6925120.0
2012-04-17 10:00:00	AMZN	Stock	9.3835	9.449	9.355	9.4415	9323340.0
2012-04-17 11:00:00	AMZN	Stock	9.442	9.4875	9.442	9.475	9409280.0
2012-04-17 12:00:00	AMZN	Stock	9.4751	9.502	9.4625	9.47	5151760.0
2012-04-17 13:00:00	AMZN	Stock	9.471	9.4785	9.435	9.4705	4960180.0
2012-04-17 14:00:00	AMZN	Stock	9.4735	9.4865	9.4665	9.4835	4194660.0

> showing 50 of 44,710 rows — these rows as CSV

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