PREVIEW / stock_1hour / 2012-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-12.parquet
  size:    901 KB
  rows:    42,768
  symbols: 3,441

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-10-12 06:00:00	AAPL	Stock	22.4886	22.5107	22.4886	22.5107	25452.0
2012-10-12 07:00:00	AAPL	Stock	22.5107	22.5804	22.4668	22.5786	666428.0
2012-10-12 08:00:00	AAPL	Stock	22.5821	22.5996	22.4818	22.4996	2367232.0
2012-10-12 09:00:00	AAPL	Stock	22.4936	22.5657	22.3321	22.5657	89468428.0
2012-10-12 10:00:00	AAPL	Stock	22.5657	22.6921	22.5232	22.6436	101851876.0
2012-10-12 11:00:00	AAPL	Stock	22.6437	22.6589	22.4786	22.5829	64250116.0
2012-10-12 12:00:00	AAPL	Stock	22.5805	22.6243	22.4857	22.4893	30167424.0
2012-10-12 13:00:00	AAPL	Stock	22.4929	22.5161	22.4107	22.4873	45278072.0
2012-10-12 14:00:00	AAPL	Stock	22.4914	22.57	22.4357	22.5429	36007524.0
2012-10-12 15:00:00	AAPL	Stock	22.5443	22.5475	22.4529	22.4843	54027652.0
2012-10-12 16:00:00	AAPL	Stock	22.4943	22.5223	22.4107	22.4768	22132264.0
2012-10-12 17:00:00	AAPL	Stock	22.4736	22.4804	22.4654	22.4661	238252.0
2012-10-12 18:00:00	AAPL	Stock	22.4732	22.4846	22.4721	22.4821	189532.0
2012-10-12 19:00:00	AAPL	Stock	22.4821	22.4832	22.4643	22.4643	183736.0
2012-10-12 07:00:00	MSFT	Stock	29.05	29.17	29.02	29.02	3200.0
2012-10-12 08:00:00	MSFT	Stock	29.03	29.04	28.98	28.98	12268.0
2012-10-12 09:00:00	MSFT	Stock	28.98	29.1	28.8	29.08	6773336.0
2012-10-12 10:00:00	MSFT	Stock	29.09	29.13	28.995	29.02	5857875.0
2012-10-12 11:00:00	MSFT	Stock	29.025	29.038	28.86	28.91	4873976.0
2012-10-12 12:00:00	MSFT	Stock	28.91	29.05	28.89	29.05	3539429.0
2012-10-12 13:00:00	MSFT	Stock	29.047	29.22	29.02	29.21	5174086.0
2012-10-12 14:00:00	MSFT	Stock	29.21	29.26	29.17	29.248	4533121.0
2012-10-12 15:00:00	MSFT	Stock	29.24	29.32	29.18	29.2	10386034.0
2012-10-12 16:00:00	MSFT	Stock	29.2	29.27	28.926	29.24	3242218.0
2012-10-12 17:00:00	MSFT	Stock	29.24	29.24	29.24	29.24	1522.0
2012-10-12 18:00:00	MSFT	Stock	29.21	29.24	29.2	29.24	3605.0
2012-10-12 19:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	1000.0
2012-10-12 07:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	20000.0
2012-10-12 09:00:00	NVDA	Stock	0.3183	0.3188	0.3138	0.3175	47066320.0
2012-10-12 10:00:00	NVDA	Stock	0.3175	0.3178	0.315	0.317	43828120.0
2012-10-12 11:00:00	NVDA	Stock	0.3168	0.317	0.3148	0.3164	50350040.0
2012-10-12 12:00:00	NVDA	Stock	0.3163	0.3165	0.3155	0.316	13453160.0
2012-10-12 13:00:00	NVDA	Stock	0.316	0.3163	0.315	0.3158	13575360.0
2012-10-12 14:00:00	NVDA	Stock	0.3154	0.3173	0.3154	0.317	24663720.0
2012-10-12 15:00:00	NVDA	Stock	0.317	0.317	0.3153	0.3158	49873000.0
2012-10-12 16:00:00	NVDA	Stock	0.3158	0.316	0.3148	0.3158	3066880.0
2012-10-12 05:00:00	AMZN	Stock	12.211	12.211	12.211	12.211	4000.0
2012-10-12 06:00:00	AMZN	Stock	12.211	12.211	12.211	12.211	4000.0
2012-10-12 07:00:00	AMZN	Stock	12.211	12.234	12.211	12.234	33100.0
2012-10-12 08:00:00	AMZN	Stock	12.2275	12.24	12.1755	12.211	298960.0
2012-10-12 09:00:00	AMZN	Stock	12.188	12.2355	12.1015	12.2285	7459560.0
2012-10-12 10:00:00	AMZN	Stock	12.228	12.273	12.1855	12.265	8849060.0
2012-10-12 11:00:00	AMZN	Stock	12.2672	12.2695	12.11	12.1815	7222120.0
2012-10-12 12:00:00	AMZN	Stock	12.1825	12.201	12.1395	12.142	3219600.0
2012-10-12 13:00:00	AMZN	Stock	12.142	12.1545	12.109	12.145	3359440.0
2012-10-12 14:00:00	AMZN	Stock	12.1465	12.1715	12.1275	12.1385	3236840.0
2012-10-12 15:00:00	AMZN	Stock	12.1385	12.147	12.0955	12.114	7630540.0
2012-10-12 16:00:00	AMZN	Stock	12.1135	12.2159	12.0875	12.1	2603460.0
2012-10-12 18:00:00	AMZN	Stock	12.095	12.095	12.095	12.095	4000.0
2012-10-12 19:00:00	AMZN	Stock	12.108	12.108	12.097	12.101	10000.0

> showing 50 of 42,768 rows — these rows as CSV

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