PREVIEW / stock_1hour / 2012-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-12.parquet
  size:    918 KB
  rows:    43,763
  symbols: 3,512

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-06-12 04:00:00	AAPL	Stock	20.4311	20.4582	20.4311	20.4582	5600.0
2012-06-12 05:00:00	AAPL	Stock	20.4586	20.4854	20.4586	20.4854	8400.0
2012-06-12 06:00:00	AAPL	Stock	20.5139	20.5264	20.4904	20.4904	33600.0
2012-06-12 07:00:00	AAPL	Stock	20.4582	20.5325	20.4375	20.4896	784168.0
2012-06-12 08:00:00	AAPL	Stock	20.5	20.5229	20.4518	20.4646	2094764.0
2012-06-12 09:00:00	AAPL	Stock	20.4725	20.5536	20.3986	20.4252	67751068.0
2012-06-12 10:00:00	AAPL	Stock	20.4214	20.4375	20.2393	20.3646	95787412.0
2012-06-12 11:00:00	AAPL	Stock	20.3637	20.5936	20.3571	20.5417	77317044.0
2012-06-12 12:00:00	AAPL	Stock	20.5429	20.5786	20.3846	20.4393	44779896.0
2012-06-12 13:00:00	AAPL	Stock	20.4396	20.5225	20.4164	20.4368	34985496.0
2012-06-12 14:00:00	AAPL	Stock	20.4378	20.5114	20.4207	20.4673	31142804.0
2012-06-12 15:00:00	AAPL	Stock	20.4702	20.5768	20.4321	20.5768	62685588.0
2012-06-12 16:00:00	AAPL	Stock	20.5764	20.5893	20.389	20.5825	9325120.0
2012-06-12 17:00:00	AAPL	Stock	20.5804	20.5954	20.5771	20.5929	455280.0
2012-06-12 18:00:00	AAPL	Stock	20.5936	20.6036	20.5918	20.6036	180320.0
2012-06-12 19:00:00	AAPL	Stock	20.6039	20.615	20.6021	20.6107	166012.0
2012-06-12 04:00:00	MSFT	Stock	28.96	29.02	28.96	29.02	1100.0
2012-06-12 07:00:00	MSFT	Stock	29.02	29.02	28.95	29.02	1788.0
2012-06-12 08:00:00	MSFT	Stock	29.02	29.07	29.0	29.03	83550.0
2012-06-12 09:00:00	MSFT	Stock	29.06	29.14	28.98	29.04	4490355.0
2012-06-12 10:00:00	MSFT	Stock	29.05	29.078	28.84	29.04	6084283.0
2012-06-12 11:00:00	MSFT	Stock	29.04	29.23	29.03	29.185	5307084.0
2012-06-12 12:00:00	MSFT	Stock	29.18	29.25	29.11	29.128	2911818.0
2012-06-12 13:00:00	MSFT	Stock	29.13	29.23	29.105	29.13	3494181.0
2012-06-12 14:00:00	MSFT	Stock	29.12	29.23	29.1	29.185	3086010.0
2012-06-12 15:00:00	MSFT	Stock	29.185	29.3	29.14	29.3	6589612.0
2012-06-12 16:00:00	MSFT	Stock	29.3	29.39	29.132	29.33	2469368.0
2012-06-12 17:00:00	MSFT	Stock	29.33	29.35	29.29	29.34	46362.0
2012-06-12 18:00:00	MSFT	Stock	29.34	29.38	29.3	29.38	6900.0
2012-06-12 19:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	300.0
2012-06-12 07:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	16000.0
2012-06-12 08:00:00	NVDA	Stock	0.3098	0.31	0.3098	0.3098	72000.0
2012-06-12 09:00:00	NVDA	Stock	0.3098	0.3158	0.3095	0.3126	82864640.0
2012-06-12 10:00:00	NVDA	Stock	0.3127	0.314	0.3098	0.313	77338640.0
2012-06-12 11:00:00	NVDA	Stock	0.313	0.3153	0.3128	0.3128	83681240.0
2012-06-12 12:00:00	NVDA	Stock	0.313	0.3136	0.31	0.3108	47753200.0
2012-06-12 13:00:00	NVDA	Stock	0.3107	0.3128	0.3103	0.3114	53993080.0
2012-06-12 14:00:00	NVDA	Stock	0.3113	0.313	0.3105	0.3115	45533880.0
2012-06-12 15:00:00	NVDA	Stock	0.3116	0.313	0.311	0.3128	92465000.0
2012-06-12 16:00:00	NVDA	Stock	0.3128	0.3133	0.3125	0.3125	11215720.0
2012-06-12 17:00:00	NVDA	Stock	0.3118	0.3118	0.3118	0.3118	36280.0
2012-06-12 18:00:00	NVDA	Stock	0.3128	0.3135	0.3128	0.3135	232000.0
2012-06-12 19:00:00	NVDA	Stock	0.3148	0.315	0.312	0.312	52000.0
2012-06-12 08:00:00	AMZN	Stock	10.8315	10.8655	10.8315	10.8545	115200.0
2012-06-12 09:00:00	AMZN	Stock	10.8595	10.8945	10.763	10.775	8297040.0
2012-06-12 10:00:00	AMZN	Stock	10.7755	10.7965	10.7261	10.744	9819400.0
2012-06-12 11:00:00	AMZN	Stock	10.744	10.9	10.734	10.846	8832860.0
2012-06-12 12:00:00	AMZN	Stock	10.8495	10.885	10.775	10.804	4375000.0
2012-06-12 13:00:00	AMZN	Stock	10.8045	10.8725	10.79	10.834	4643280.0
2012-06-12 14:00:00	AMZN	Stock	10.835	10.8845	10.821	10.8665	3476680.0

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

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