PREVIEW / stock_1hour / 2012-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-12.parquet
  size:    926 KB
  rows:    43,817
  symbols: 3,446

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-07-12 04:00:00	AAPL	Stock	21.5357	21.5357	21.4893	21.5018	85400.0
2012-07-12 06:00:00	AAPL	Stock	21.5	21.5179	21.4107	21.4107	63056.0
2012-07-12 07:00:00	AAPL	Stock	21.4607	21.4646	21.4054	21.4393	419804.0
2012-07-12 08:00:00	AAPL	Stock	21.4429	21.5522	21.4193	21.4225	2010568.0
2012-07-12 09:00:00	AAPL	Stock	21.4286	21.5071	21.3036	21.3495	71525020.0
2012-07-12 10:00:00	AAPL	Stock	21.3557	21.3642	21.1671	21.2657	87242876.0
2012-07-12 11:00:00	AAPL	Stock	21.265	21.4175	21.2571	21.4036	57981868.0
2012-07-12 12:00:00	AAPL	Stock	21.4014	21.4218	21.3436	21.3568	32523820.0
2012-07-12 13:00:00	AAPL	Stock	21.3589	21.5525	21.3584	21.4486	62270936.0
2012-07-12 14:00:00	AAPL	Stock	21.4468	21.5314	21.4183	21.5243	38026604.0
2012-07-12 15:00:00	AAPL	Stock	21.5273	21.5307	21.3793	21.3874	64018136.0
2012-07-12 16:00:00	AAPL	Stock	21.3893	21.3993	21.375	21.3982	4396700.0
2012-07-12 17:00:00	AAPL	Stock	21.3964	21.3993	21.3939	21.3946	63392.0
2012-07-12 18:00:00	AAPL	Stock	21.3971	21.4	21.2766	21.3936	190120.0
2012-07-12 19:00:00	AAPL	Stock	21.3964	21.3979	21.3571	21.3629	288148.0
2012-07-12 07:00:00	MSFT	Stock	29.22	29.32	29.14	29.24	24900.0
2012-07-12 08:00:00	MSFT	Stock	29.29	29.36	29.12	29.18	118501.0
2012-07-12 09:00:00	MSFT	Stock	29.15	29.3	28.7	28.76	9279837.0
2012-07-12 10:00:00	MSFT	Stock	28.76	28.84	28.71	28.79	10980914.0
2012-07-12 11:00:00	MSFT	Stock	28.8	28.89	28.78	28.87	6513462.0
2012-07-12 12:00:00	MSFT	Stock	28.87	28.88	28.72	28.74	4518234.0
2012-07-12 13:00:00	MSFT	Stock	28.745	28.875	28.72	28.79	6205682.0
2012-07-12 14:00:00	MSFT	Stock	28.79	28.84	28.75	28.78	8004149.0
2012-07-12 15:00:00	MSFT	Stock	28.78	28.79	28.54	28.63	15724116.0
2012-07-12 16:00:00	MSFT	Stock	28.63	28.774	28.6	28.63	1472628.0
2012-07-12 17:00:00	MSFT	Stock	28.62	28.64	28.61	28.62	9251.0
2012-07-12 18:00:00	MSFT	Stock	28.63	28.814	28.63	28.65	33925.0
2012-07-12 19:00:00	MSFT	Stock	28.65	28.65	28.61	28.61	4970.0
2012-07-12 07:00:00	NVDA	Stock	0.3125	0.3125	0.3113	0.3113	44000.0
2012-07-12 08:00:00	NVDA	Stock	0.3113	0.3138	0.3078	0.308	464040.0
2012-07-12 09:00:00	NVDA	Stock	0.3093	0.3123	0.3075	0.3093	63478840.0
2012-07-12 10:00:00	NVDA	Stock	0.3093	0.3103	0.3075	0.3085	87434120.0
2012-07-12 11:00:00	NVDA	Stock	0.3088	0.3108	0.308	0.3103	35464160.0
2012-07-12 12:00:00	NVDA	Stock	0.3103	0.3107	0.3071	0.3075	55371080.0
2012-07-12 13:00:00	NVDA	Stock	0.3075	0.311	0.3073	0.31	50570080.0
2012-07-12 14:00:00	NVDA	Stock	0.3098	0.312	0.3089	0.31	51676320.0
2012-07-12 15:00:00	NVDA	Stock	0.3098	0.312	0.3088	0.31	118580800.0
2012-07-12 16:00:00	NVDA	Stock	0.31	0.31	0.3094	0.31	9018120.0
2012-07-12 06:00:00	AMZN	Stock	10.85	10.85	10.85	10.85	2000.0
2012-07-12 08:00:00	AMZN	Stock	10.8575	10.8625	10.8255	10.833	48260.0
2012-07-12 09:00:00	AMZN	Stock	10.835	10.865	10.705	10.751	8446240.0
2012-07-12 10:00:00	AMZN	Stock	10.749	10.7584	10.6305	10.7009	11366780.0
2012-07-12 11:00:00	AMZN	Stock	10.702	10.7625	10.685	10.7435	9663500.0
2012-07-12 12:00:00	AMZN	Stock	10.742	10.751	10.6925	10.748	4883840.0
2012-07-12 13:00:00	AMZN	Stock	10.7436	10.8165	10.731	10.7575	6191060.0
2012-07-12 14:00:00	AMZN	Stock	10.7575	10.79	10.74	10.773	3360420.0
2012-07-12 15:00:00	AMZN	Stock	10.7745	10.804	10.756	10.7695	6819780.0
2012-07-12 16:00:00	AMZN	Stock	10.768	10.77	10.738	10.768	215720.0
2012-07-12 17:00:00	AMZN	Stock	10.76	10.7615	10.754	10.7615	21940.0
2012-07-12 18:00:00	AMZN	Stock	10.6951	10.6951	10.6951	10.6951	90000.0

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

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