PREVIEW / stock_1hour / 2012-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-13.parquet
  size:    928 KB
  rows:    43,906
  symbols: 3,491

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-13 06:00:00	AAPL	Stock	21.4536	21.4889	21.4536	21.4821	32200.0
2012-07-13 07:00:00	AAPL	Stock	21.4821	21.4821	21.4286	21.4504	274904.0
2012-07-13 08:00:00	AAPL	Stock	21.4464	21.5461	21.4214	21.5357	2112292.0
2012-07-13 09:00:00	AAPL	Stock	21.5389	21.5893	21.4286	21.5358	55530888.0
2012-07-13 10:00:00	AAPL	Stock	21.5396	21.5679	21.4821	21.5221	45350620.0
2012-07-13 11:00:00	AAPL	Stock	21.5186	21.5304	21.4743	21.5282	28416332.0
2012-07-13 12:00:00	AAPL	Stock	21.525	21.6071	21.5243	21.5846	35157864.0
2012-07-13 13:00:00	AAPL	Stock	21.5867	21.6579	21.5811	21.6229	37096416.0
2012-07-13 14:00:00	AAPL	Stock	21.6263	21.6543	21.605	21.6543	25278092.0
2012-07-13 15:00:00	AAPL	Stock	21.6543	21.6854	21.5929	21.6	65511488.0
2012-07-13 16:00:00	AAPL	Stock	21.6061	21.6324	21.5172	21.6054	13009836.0
2012-07-13 17:00:00	AAPL	Stock	21.6079	21.6079	21.5911	21.6043	154224.0
2012-07-13 18:00:00	AAPL	Stock	21.6061	21.61	21.6039	21.61	73276.0
2012-07-13 19:00:00	AAPL	Stock	21.6071	21.6161	21.6071	21.6071	125608.0
2012-07-13 07:00:00	MSFT	Stock	28.77	28.77	28.77	28.77	200.0
2012-07-13 08:00:00	MSFT	Stock	28.7	28.78	28.67	28.72	24265.0
2012-07-13 09:00:00	MSFT	Stock	28.72	29.14	28.7	29.134	4825116.0
2012-07-13 10:00:00	MSFT	Stock	29.14	29.33	29.1	29.205	5542395.0
2012-07-13 11:00:00	MSFT	Stock	29.21	29.24	29.16	29.221	4109749.0
2012-07-13 12:00:00	MSFT	Stock	29.23	29.25	29.17	29.19	3280767.0
2012-07-13 13:00:00	MSFT	Stock	29.19	29.29	29.19	29.28	3272975.0
2012-07-13 14:00:00	MSFT	Stock	29.288	29.33	29.25	29.27	4409430.0
2012-07-13 15:00:00	MSFT	Stock	29.265	29.48	29.26	29.4	11162017.0
2012-07-13 16:00:00	MSFT	Stock	29.39	29.44	29.186	29.44	1905693.0
2012-07-13 17:00:00	MSFT	Stock	29.44	29.44	29.41	29.41	3767.0
2012-07-13 18:00:00	MSFT	Stock	29.41	29.44	29.41	29.44	3400.0
2012-07-13 19:00:00	MSFT	Stock	29.41	29.42	29.41	29.41	4238.0
2012-07-13 08:00:00	NVDA	Stock	0.3125	0.3125	0.3093	0.31	502000.0
2012-07-13 09:00:00	NVDA	Stock	0.31	0.3135	0.3083	0.3095	36102800.0
2012-07-13 10:00:00	NVDA	Stock	0.3096	0.3113	0.309	0.3099	52693800.0
2012-07-13 11:00:00	NVDA	Stock	0.31	0.3118	0.3088	0.3115	56054240.0
2012-07-13 12:00:00	NVDA	Stock	0.3114	0.3135	0.311	0.3128	29110520.0
2012-07-13 13:00:00	NVDA	Stock	0.3125	0.3136	0.312	0.3132	26937520.0
2012-07-13 14:00:00	NVDA	Stock	0.3131	0.3138	0.3128	0.3135	19953320.0
2012-07-13 15:00:00	NVDA	Stock	0.3138	0.3154	0.3135	0.3138	88675120.0
2012-07-13 16:00:00	NVDA	Stock	0.314	0.314	0.312	0.314	13601480.0
2012-07-13 17:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	36000.0
2012-07-13 18:00:00	NVDA	Stock	0.314	0.314	0.314	0.314	10000.0
2012-07-13 19:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	4000.0
2012-07-13 08:00:00	AMZN	Stock	10.7815	10.822	10.7519	10.8135	23420.0
2012-07-13 09:00:00	AMZN	Stock	10.8055	10.835	10.694	10.73	5731840.0
2012-07-13 10:00:00	AMZN	Stock	10.73	10.808	10.7175	10.75	8546460.0
2012-07-13 11:00:00	AMZN	Stock	10.7535	10.8594	10.7445	10.858	6394960.0
2012-07-13 12:00:00	AMZN	Stock	10.856	10.9125	10.852	10.908	5755020.0
2012-07-13 13:00:00	AMZN	Stock	10.9095	10.9375	10.8881	10.9005	3958680.0
2012-07-13 14:00:00	AMZN	Stock	10.9005	10.9245	10.8885	10.921	2852820.0
2012-07-13 15:00:00	AMZN	Stock	10.922	10.9655	10.9085	10.9195	9277880.0
2012-07-13 16:00:00	AMZN	Stock	10.9225	10.9325	10.8442	10.9195	1839300.0
2012-07-13 17:00:00	AMZN	Stock	10.9295	10.9295	10.9205	10.9205	6000.0
2012-07-13 18:00:00	AMZN	Stock	10.92	10.9225	10.92	10.9205	8000.0

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

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