PREVIEW / stock_1hour / 2012-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-09.parquet
  size:    938 KB
  rows:    44,742
  symbols: 3,473

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-09 04:00:00	AAPL	Stock	22.5711	22.5743	22.5089	22.5321	196532.0
2012-10-09 05:00:00	AAPL	Stock	22.5354	22.5857	22.5321	22.575	306796.0
2012-10-09 06:00:00	AAPL	Stock	22.5893	22.6429	22.5893	22.6429	223216.0
2012-10-09 07:00:00	AAPL	Stock	22.65	22.7764	22.6364	22.7429	1470728.0
2012-10-09 08:00:00	AAPL	Stock	22.7357	22.775	22.6704	22.7214	2945404.0
2012-10-09 09:00:00	AAPL	Stock	22.7214	22.8479	22.5529	22.5568	100198056.0
2012-10-09 10:00:00	AAPL	Stock	22.5575	22.6429	22.2696	22.37	197294832.0
2012-10-09 11:00:00	AAPL	Stock	22.3686	22.5357	22.3307	22.5246	108669428.0
2012-10-09 12:00:00	AAPL	Stock	22.5239	22.6904	22.4904	22.6121	101532704.0
2012-10-09 13:00:00	AAPL	Stock	22.6121	22.8096	22.6032	22.73	95527964.0
2012-10-09 14:00:00	AAPL	Stock	22.7268	22.8746	22.7036	22.8604	88352208.0
2012-10-09 15:00:00	AAPL	Stock	22.8606	22.8746	22.6155	22.7204	104812344.0
2012-10-09 16:00:00	AAPL	Stock	22.7089	22.7679	22.6114	22.7564	13887328.0
2012-10-09 17:00:00	AAPL	Stock	22.7918	22.7918	22.6786	22.6821	853468.0
2012-10-09 18:00:00	AAPL	Stock	22.6929	22.7304	22.6929	22.7264	261660.0
2012-10-09 19:00:00	AAPL	Stock	22.7196	22.7321	22.6911	22.6911	410256.0
2012-10-09 06:00:00	MSFT	Stock	29.98	29.98	29.98	29.98	100.0
2012-10-09 08:00:00	MSFT	Stock	29.9	29.9	29.78	29.85	10000.0
2012-10-09 09:00:00	MSFT	Stock	29.83	29.84	29.43	29.48	4527515.0
2012-10-09 10:00:00	MSFT	Stock	29.48	29.55	29.26	29.35	6586347.0
2012-10-09 11:00:00	MSFT	Stock	29.35	29.39	29.285	29.335	7129403.0
2012-10-09 12:00:00	MSFT	Stock	29.335	29.38	29.26	29.3	4692615.0
2012-10-09 13:00:00	MSFT	Stock	29.29	29.33	29.27	29.29	4157659.0
2012-10-09 14:00:00	MSFT	Stock	29.29	29.32	29.25	29.282	4157582.0
2012-10-09 15:00:00	MSFT	Stock	29.285	29.3	29.18	29.28	10123519.0
2012-10-09 16:00:00	MSFT	Stock	29.28	29.78	29.21	29.78	2031327.0
2012-10-09 17:00:00	MSFT	Stock	29.31	29.34	29.3	29.3	5887.0
2012-10-09 18:00:00	MSFT	Stock	29.376	29.376	29.3	29.3	1236.0
2012-10-09 19:00:00	MSFT	Stock	29.31	29.31	29.23	29.23	9024.0
2012-10-09 06:00:00	NVDA	Stock	0.3238	0.3325	0.3238	0.3325	8000.0
2012-10-09 07:00:00	NVDA	Stock	0.3293	0.33	0.3293	0.33	80000.0
2012-10-09 08:00:00	NVDA	Stock	0.3305	0.3305	0.3305	0.3305	60000.0
2012-10-09 09:00:00	NVDA	Stock	0.331	0.331	0.3253	0.3263	37377520.0
2012-10-09 10:00:00	NVDA	Stock	0.3265	0.328	0.3233	0.3235	71138880.0
2012-10-09 11:00:00	NVDA	Stock	0.3235	0.3238	0.3213	0.3213	89493000.0
2012-10-09 12:00:00	NVDA	Stock	0.3213	0.3233	0.3213	0.322	30436520.0
2012-10-09 13:00:00	NVDA	Stock	0.322	0.3238	0.3215	0.3225	36584800.0
2012-10-09 14:00:00	NVDA	Stock	0.3225	0.3233	0.3223	0.3225	34194040.0
2012-10-09 15:00:00	NVDA	Stock	0.3228	0.3229	0.3215	0.3223	56791440.0
2012-10-09 16:00:00	NVDA	Stock	0.322	0.3236	0.3215	0.3223	8905320.0
2012-10-09 17:00:00	NVDA	Stock	0.323	0.3233	0.323	0.3233	208000.0
2012-10-09 18:00:00	NVDA	Stock	0.323	0.3235	0.323	0.3235	77880.0
2012-10-09 19:00:00	NVDA	Stock	0.323	0.323	0.323	0.323	4000.0
2012-10-09 07:00:00	AMZN	Stock	12.9495	12.9495	12.9495	12.9495	2000.0
2012-10-09 08:00:00	AMZN	Stock	12.956	12.956	12.9465	12.95	12000.0
2012-10-09 09:00:00	AMZN	Stock	12.9705	12.977	12.788	12.7955	6482640.0
2012-10-09 10:00:00	AMZN	Stock	12.795	12.8215	12.65	12.6675	11504600.0
2012-10-09 11:00:00	AMZN	Stock	12.663	12.686	12.6025	12.6295	10658720.0
2012-10-09 12:00:00	AMZN	Stock	12.6305	12.672	12.5365	12.5365	9950240.0
2012-10-09 13:00:00	AMZN	Stock	12.5365	12.6375	12.5365	12.6015	6192700.0

> showing 50 of 44,742 rows — these rows as CSV

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