PREVIEW / stock_1hour / 2011-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-17.parquet
  size:    908 KB
  rows:    43,536
  symbols: 3,515

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
2011-08-17 04:00:00	AAPL	Stock	13.58	13.58	13.5532	13.5532	5600.0
2011-08-17 05:00:00	AAPL	Stock	13.6246	13.6246	13.6246	13.6246	8400.0
2011-08-17 06:00:00	AAPL	Stock	13.5696	13.6475	13.5689	13.6475	25200.0
2011-08-17 07:00:00	AAPL	Stock	13.6075	13.6732	13.6071	13.6439	493388.0
2011-08-17 08:00:00	AAPL	Stock	13.6411	13.6643	13.5886	13.6482	2386412.0
2011-08-17 09:00:00	AAPL	Stock	13.6461	13.7329	13.6093	13.7104	58383472.0
2011-08-17 10:00:00	AAPL	Stock	13.7064	13.7214	13.6575	13.6582	59649240.0
2011-08-17 11:00:00	AAPL	Stock	13.6571	13.6782	13.5257	13.5456	77931924.0
2011-08-17 12:00:00	AAPL	Stock	13.5482	13.6304	13.5	13.5843	63006216.0
2011-08-17 13:00:00	AAPL	Stock	13.5846	13.5893	13.5064	13.5143	51262876.0
2011-08-17 14:00:00	AAPL	Stock	13.5139	13.5875	13.5125	13.561	42140420.0
2011-08-17 15:00:00	AAPL	Stock	13.5618	13.6389	13.5332	13.5789	52142692.0
2011-08-17 16:00:00	AAPL	Stock	13.5864	13.7128	13.5527	13.5539	29920296.0
2011-08-17 17:00:00	AAPL	Stock	13.5871	13.5871	13.5539	13.5696	1360884.0
2011-08-17 18:00:00	AAPL	Stock	13.5714	13.5871	13.5482	13.5536	82180.0
2011-08-17 19:00:00	AAPL	Stock	13.5482	13.591	13.5293	13.545	1505756.0
2011-08-17 06:00:00	MSFT	Stock	25.34	25.35	25.3	25.34	3200.0
2011-08-17 07:00:00	MSFT	Stock	25.35	25.35	25.32	25.35	4301.0
2011-08-17 08:00:00	MSFT	Stock	25.39	25.45	25.25	25.3	73837.0
2011-08-17 09:00:00	MSFT	Stock	25.35	25.7	25.21	25.65	6930130.0
2011-08-17 10:00:00	MSFT	Stock	25.66	25.678	25.33	25.35	6677736.0
2011-08-17 11:00:00	MSFT	Stock	25.35	25.47	25.15	25.24	7075850.0
2011-08-17 12:00:00	MSFT	Stock	25.245	25.31	25.08	25.16	5663884.0
2011-08-17 13:00:00	MSFT	Stock	25.16	25.16	24.93	25.05	5438586.0
2011-08-17 14:00:00	MSFT	Stock	25.06	25.17	25.01	25.14	4426092.0
2011-08-17 15:00:00	MSFT	Stock	25.138	25.27	25.08	25.25	10388697.0
2011-08-17 16:00:00	MSFT	Stock	25.245	25.35	25.122	25.16	2937718.0
2011-08-17 17:00:00	MSFT	Stock	25.2	25.245	25.16	25.16	332975.0
2011-08-17 18:00:00	MSFT	Stock	25.17	25.25	25.16	25.16	28127.0
2011-08-17 19:00:00	MSFT	Stock	25.16	25.281	25.14	25.14	443400.0
2011-08-17 08:00:00	NVDA	Stock	0.3248	0.326	0.3248	0.3253	300600.0
2011-08-17 09:00:00	NVDA	Stock	0.3245	0.3298	0.3208	0.3288	61743440.0
2011-08-17 10:00:00	NVDA	Stock	0.3285	0.3313	0.326	0.326	95272160.0
2011-08-17 11:00:00	NVDA	Stock	0.326	0.3275	0.3215	0.3233	92318800.0
2011-08-17 12:00:00	NVDA	Stock	0.3233	0.3243	0.3203	0.3213	58987040.0
2011-08-17 13:00:00	NVDA	Stock	0.3213	0.3216	0.316	0.3185	94032880.0
2011-08-17 14:00:00	NVDA	Stock	0.3183	0.321	0.3183	0.32	52638640.0
2011-08-17 15:00:00	NVDA	Stock	0.32	0.321	0.319	0.3205	91313320.0
2011-08-17 16:00:00	NVDA	Stock	0.3203	0.3229	0.3175	0.3195	5337640.0
2011-08-17 17:00:00	NVDA	Stock	0.3203	0.3203	0.3188	0.3195	1098800.0
2011-08-17 19:00:00	NVDA	Stock	0.319	0.319	0.319	0.319	28000.0
2011-08-17 06:00:00	AMZN	Stock	9.888	9.888	9.888	9.888	2000.0
2011-08-17 07:00:00	AMZN	Stock	9.9	9.9175	9.9	9.9175	4000.0
2011-08-17 08:00:00	AMZN	Stock	9.9445	9.95	9.9235	9.925	70720.0
2011-08-17 09:00:00	AMZN	Stock	9.925	9.98	9.825	9.9435	14513060.0
2011-08-17 10:00:00	AMZN	Stock	9.947	9.949	9.8525	9.8525	11103660.0
2011-08-17 11:00:00	AMZN	Stock	9.856	9.8705	9.7555	9.784	11318820.0
2011-08-17 12:00:00	AMZN	Stock	9.7865	9.792	9.72	9.7545	8604120.0
2011-08-17 13:00:00	AMZN	Stock	9.753	9.774	9.687	9.6915	6127300.0
2011-08-17 14:00:00	AMZN	Stock	9.698	9.791	9.6875	9.7316	9063220.0

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

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