PREVIEW / stock_1hour / 2011-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-25.parquet
  size:    933 KB
  rows:    44,507
  symbols: 3,539

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-07-25 05:00:00	AAPL	Stock	13.9536	13.9743	13.9464	13.9743	28000.0
2011-07-25 07:00:00	AAPL	Stock	13.9411	13.9932	13.9311	13.9661	693868.0
2011-07-25 08:00:00	AAPL	Stock	13.9686	13.9846	13.935	13.9482	2604532.0
2011-07-25 09:00:00	AAPL	Stock	13.9486	14.0711	13.915	14.0539	92558704.0
2011-07-25 10:00:00	AAPL	Stock	14.0539	14.1093	14.0243	14.0743	75491584.0
2011-07-25 11:00:00	AAPL	Stock	14.0729	14.2393	14.0711	14.2293	90171872.0
2011-07-25 12:00:00	AAPL	Stock	14.2257	14.2857	14.219	14.2757	89946948.0
2011-07-25 13:00:00	AAPL	Stock	14.2757	14.2782	14.2214	14.2429	52324328.0
2011-07-25 14:00:00	AAPL	Stock	14.2432	14.2857	14.2393	14.2614	62947416.0
2011-07-25 15:00:00	AAPL	Stock	14.2625	14.2668	14.1786	14.229	103611760.0
2011-07-25 16:00:00	AAPL	Stock	14.229	14.2608	14.0464	14.2354	12726336.0
2011-07-25 17:00:00	AAPL	Stock	14.235	14.2632	14.235	14.2536	947072.0
2011-07-25 18:00:00	AAPL	Stock	14.2525	14.2571	14.2321	14.2321	489916.0
2011-07-25 19:00:00	AAPL	Stock	14.2336	14.2454	14.225	14.2396	417900.0
2011-07-25 06:00:00	MSFT	Stock	27.24	27.24	27.24	27.24	1000.0
2011-07-25 07:00:00	MSFT	Stock	27.2	27.31	27.15	27.26	5000.0
2011-07-25 08:00:00	MSFT	Stock	27.3	27.33	27.15	27.2	58785.0
2011-07-25 09:00:00	MSFT	Stock	27.19	27.54	27.19	27.52	7517755.0
2011-07-25 10:00:00	MSFT	Stock	27.52	27.83	27.52	27.788	17876131.0
2011-07-25 11:00:00	MSFT	Stock	27.785	27.91	27.69	27.855	21905030.0
2011-07-25 12:00:00	MSFT	Stock	27.855	28.03	27.84	27.99	13316365.0
2011-07-25 13:00:00	MSFT	Stock	27.99	28.09	27.92	27.93	7135500.0
2011-07-25 14:00:00	MSFT	Stock	27.93	27.97	27.78	27.795	10132759.0
2011-07-25 15:00:00	MSFT	Stock	27.795	27.92	27.72	27.91	22725898.0
2011-07-25 16:00:00	MSFT	Stock	27.905	27.95	27.525	27.87	4511105.0
2011-07-25 17:00:00	MSFT	Stock	27.84	27.84	27.83	27.83	1511.0
2011-07-25 18:00:00	MSFT	Stock	27.85	27.91	27.81	27.85	55903.0
2011-07-25 19:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	3550.0
2011-07-25 07:00:00	NVDA	Stock	0.3688	0.3688	0.3668	0.3668	168000.0
2011-07-25 08:00:00	NVDA	Stock	0.3688	0.3703	0.3662	0.3692	577760.0
2011-07-25 09:00:00	NVDA	Stock	0.369	0.3708	0.3645	0.3678	86631840.0
2011-07-25 10:00:00	NVDA	Stock	0.3678	0.3688	0.365	0.3655	72193320.0
2011-07-25 11:00:00	NVDA	Stock	0.3655	0.3685	0.3638	0.3675	82088080.0
2011-07-25 12:00:00	NVDA	Stock	0.3678	0.3695	0.3668	0.3692	54087640.0
2011-07-25 13:00:00	NVDA	Stock	0.3695	0.3695	0.368	0.368	59336360.0
2011-07-25 14:00:00	NVDA	Stock	0.368	0.37	0.368	0.3684	61554200.0
2011-07-25 15:00:00	NVDA	Stock	0.3685	0.369	0.3662	0.3688	142648880.0
2011-07-25 16:00:00	NVDA	Stock	0.369	0.375	0.3675	0.3675	7138640.0
2011-07-25 17:00:00	NVDA	Stock	0.3682	0.3682	0.3678	0.3678	12000.0
2011-07-25 19:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	16000.0
2011-07-25 08:00:00	AMZN	Stock	10.7735	10.7735	10.7375	10.748	83880.0
2011-07-25 09:00:00	AMZN	Stock	10.7615	10.804	10.7255	10.77	9756420.0
2011-07-25 10:00:00	AMZN	Stock	10.77	10.7715	10.655	10.6705	10462340.0
2011-07-25 11:00:00	AMZN	Stock	10.668	10.724	10.66	10.7015	8187920.0
2011-07-25 12:00:00	AMZN	Stock	10.702	10.7595	10.6915	10.7408	7162480.0
2011-07-25 13:00:00	AMZN	Stock	10.7429	10.7519	10.703	10.7295	5838980.0
2011-07-25 14:00:00	AMZN	Stock	10.7295	10.754	10.706	10.7125	6955580.0
2011-07-25 15:00:00	AMZN	Stock	10.7145	10.715	10.65	10.6723	15635020.0
2011-07-25 16:00:00	AMZN	Stock	10.6745	10.6945	10.6575	10.69	268300.0
2011-07-25 17:00:00	AMZN	Stock	10.691	10.71	10.691	10.7	54020.0

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

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