PREVIEW / stock_1hour / 2011-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-29.parquet
  size:    911 KB
  rows:    43,566
  symbols: 3,528

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
2011-11-29 05:00:00	AAPL	Stock	13.5	13.5414	13.5	13.5357	19600.0
2011-11-29 06:00:00	AAPL	Stock	13.5411	13.5411	13.5	13.5357	48300.0
2011-11-29 07:00:00	AAPL	Stock	13.4721	13.4904	13.4018	13.4018	421456.0
2011-11-29 08:00:00	AAPL	Stock	13.4107	13.4823	13.3961	13.4214	1203020.0
2011-11-29 09:00:00	AAPL	Stock	13.4286	13.4829	13.3532	13.4661	48981940.0
2011-11-29 10:00:00	AAPL	Stock	13.4768	13.5296	13.4161	13.4471	64275596.0
2011-11-29 11:00:00	AAPL	Stock	13.4471	13.45	13.2393	13.2846	62005104.0
2011-11-29 12:00:00	AAPL	Stock	13.2829	13.3289	13.2439	13.3	51020760.0
2011-11-29 13:00:00	AAPL	Stock	13.2957	13.3011	13.2214	13.2639	33985840.0
2011-11-29 14:00:00	AAPL	Stock	13.2582	13.41	13.25	13.3693	48608308.0
2011-11-29 15:00:00	AAPL	Stock	13.3693	13.4364	13.3249	13.3286	57379924.0
2011-11-29 16:00:00	AAPL	Stock	13.3286	13.4396	13.2968	13.3011	5475652.0
2011-11-29 17:00:00	AAPL	Stock	13.3043	13.3054	13.2775	13.3046	238700.0
2011-11-29 18:00:00	AAPL	Stock	13.3079	13.3286	13.2804	13.2821	190148.0
2011-11-29 19:00:00	AAPL	Stock	13.2821	13.3032	13.2821	13.2946	151956.0
2011-11-29 07:00:00	MSFT	Stock	24.9	24.9	24.9	24.9	100.0
2011-11-29 08:00:00	MSFT	Stock	24.87	24.87	24.73	24.8	19116.0
2011-11-29 09:00:00	MSFT	Stock	24.76	25.04	24.73	24.95	3881768.0
2011-11-29 10:00:00	MSFT	Stock	24.95	25.02	24.84	24.88	6480204.0
2011-11-29 11:00:00	MSFT	Stock	24.875	24.98	24.75	24.87	7223321.0
2011-11-29 12:00:00	MSFT	Stock	24.865	25.03	24.83	24.86	5540642.0
2011-11-29 13:00:00	MSFT	Stock	24.86	24.92	24.8	24.81	3205811.0
2011-11-29 14:00:00	MSFT	Stock	24.805	24.97	24.78	24.89	4100977.0
2011-11-29 15:00:00	MSFT	Stock	24.89	25.03	24.82	24.841	8447137.0
2011-11-29 16:00:00	MSFT	Stock	24.84	24.969	24.73	24.8	1306848.0
2011-11-29 17:00:00	MSFT	Stock	24.76	24.93	24.76	24.93	3150.0
2011-11-29 18:00:00	MSFT	Stock	24.93	24.94	24.84	24.89	4200.0
2011-11-29 19:00:00	MSFT	Stock	24.8	24.89	24.8	24.88	1480.0
2011-11-29 07:00:00	NVDA	Stock	0.3713	0.3713	0.3713	0.3713	4000.0
2011-11-29 08:00:00	NVDA	Stock	0.3713	0.3725	0.37	0.37	146400.0
2011-11-29 09:00:00	NVDA	Stock	0.368	0.3738	0.3662	0.3728	54954280.0
2011-11-29 10:00:00	NVDA	Stock	0.3728	0.375	0.3715	0.3725	97831200.0
2011-11-29 11:00:00	NVDA	Stock	0.3725	0.3755	0.37	0.3743	83299400.0
2011-11-29 12:00:00	NVDA	Stock	0.3745	0.3773	0.3735	0.3746	68866360.0
2011-11-29 13:00:00	NVDA	Stock	0.3745	0.3748	0.372	0.3725	75367640.0
2011-11-29 14:00:00	NVDA	Stock	0.3726	0.3765	0.3725	0.375	57660000.0
2011-11-29 15:00:00	NVDA	Stock	0.375	0.3775	0.372	0.3728	163936720.0
2011-11-29 16:00:00	NVDA	Stock	0.3728	0.3763	0.3708	0.3713	18710040.0
2011-11-29 17:00:00	NVDA	Stock	0.3713	0.3725	0.37	0.3718	640680.0
2011-11-29 05:00:00	AMZN	Stock	9.75	9.75	9.75	9.75	4000.0
2011-11-29 07:00:00	AMZN	Stock	9.7505	9.7805	9.7505	9.7575	53000.0
2011-11-29 08:00:00	AMZN	Stock	9.7675	9.785	9.75	9.751	353420.0
2011-11-29 09:00:00	AMZN	Stock	9.7505	9.775	9.605	9.737	17438380.0
2011-11-29 10:00:00	AMZN	Stock	9.74	9.765	9.5235	9.5605	23750300.0
2011-11-29 11:00:00	AMZN	Stock	9.557	9.557	9.4345	9.4605	25320360.0
2011-11-29 12:00:00	AMZN	Stock	9.4629	9.4829	9.365	9.4081	16939380.0
2011-11-29 13:00:00	AMZN	Stock	9.4085	9.4835	9.383	9.3981	11695980.0
2011-11-29 14:00:00	AMZN	Stock	9.396	9.528	9.3765	9.468	13052560.0
2011-11-29 15:00:00	AMZN	Stock	9.4675	9.525	9.4	9.421	20028500.0
2011-11-29 16:00:00	AMZN	Stock	9.42	9.7075	9.4025	9.4025	267720.0

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

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