PREVIEW / stock_1hour / 2012-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-07.parquet
  size:    935 KB
  rows:    44,234
  symbols: 3,503

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-03-07 04:00:00	AAPL	Stock	19.0129	19.0429	19.0129	19.025	82460.0
2012-03-07 05:00:00	AAPL	Stock	19.0286	19.1393	19.0286	19.0571	89600.0
2012-03-07 06:00:00	AAPL	Stock	19.0625	19.0625	19.0357	19.0536	206136.0
2012-03-07 07:00:00	AAPL	Stock	19.0411	19.0714	19.0357	19.0464	1099644.0
2012-03-07 08:00:00	AAPL	Stock	19.0482	19.1507	18.975	19.1436	9811788.0
2012-03-07 09:00:00	AAPL	Stock	19.1432	19.2064	19.0257	19.0457	96029052.0
2012-03-07 10:00:00	AAPL	Stock	19.0418	19.0989	19.0186	19.0692	71285956.0
2012-03-07 11:00:00	AAPL	Stock	19.0658	19.1407	19.0411	19.1379	61039692.0
2012-03-07 12:00:00	AAPL	Stock	19.1375	19.1486	19.0811	19.1111	41450752.0
2012-03-07 13:00:00	AAPL	Stock	19.112	19.1604	18.8611	18.9775	192113684.0
2012-03-07 14:00:00	AAPL	Stock	18.9804	19.0671	18.7575	18.8193	137529840.0
2012-03-07 15:00:00	AAPL	Stock	18.8159	19.0143	18.6893	18.9511	165513264.0
2012-03-07 16:00:00	AAPL	Stock	18.9509	19.1328	18.8778	18.9786	9138248.0
2012-03-07 17:00:00	AAPL	Stock	18.9789	18.9943	18.9575	18.9589	1016820.0
2012-03-07 18:00:00	AAPL	Stock	18.9571	18.9732	18.9393	18.9618	1245860.0
2012-03-07 19:00:00	AAPL	Stock	18.9636	18.9725	18.9589	18.9711	593600.0
2012-03-07 07:00:00	MSFT	Stock	31.69	31.73	31.69	31.73	1425.0
2012-03-07 08:00:00	MSFT	Stock	31.72	31.8	31.65	31.75	32119.0
2012-03-07 09:00:00	MSFT	Stock	31.74	31.82	31.6	31.66	4603649.0
2012-03-07 10:00:00	MSFT	Stock	31.665	31.72	31.53	31.71	5973994.0
2012-03-07 11:00:00	MSFT	Stock	31.7	31.85	31.7	31.79	3888425.0
2012-03-07 12:00:00	MSFT	Stock	31.79	31.92	31.78	31.89	2713528.0
2012-03-07 13:00:00	MSFT	Stock	31.892	31.91	31.81	31.815	3509729.0
2012-03-07 14:00:00	MSFT	Stock	31.82	31.88	31.8	31.822	4406360.0
2012-03-07 15:00:00	MSFT	Stock	31.825	31.89	31.77	31.84	5738423.0
2012-03-07 16:00:00	MSFT	Stock	31.84	31.909	31.779	31.89	2231411.0
2012-03-07 17:00:00	MSFT	Stock	31.84	31.84	31.84	31.84	1031.0
2012-03-07 18:00:00	MSFT	Stock	31.84	31.84	31.84	31.84	100.0
2012-03-07 19:00:00	MSFT	Stock	31.84	31.85	31.84	31.85	269.0
2012-03-07 08:00:00	NVDA	Stock	0.3645	0.3708	0.3645	0.3708	502160.0
2012-03-07 09:00:00	NVDA	Stock	0.3713	0.373	0.365	0.3688	41428880.0
2012-03-07 10:00:00	NVDA	Stock	0.3688	0.3703	0.3662	0.367	64155480.0
2012-03-07 11:00:00	NVDA	Stock	0.367	0.3713	0.367	0.3708	70563000.0
2012-03-07 12:00:00	NVDA	Stock	0.3708	0.3713	0.3675	0.3675	34135840.0
2012-03-07 13:00:00	NVDA	Stock	0.3678	0.369	0.3662	0.3688	83932720.0
2012-03-07 14:00:00	NVDA	Stock	0.369	0.3718	0.3688	0.37	57733080.0
2012-03-07 15:00:00	NVDA	Stock	0.3703	0.371	0.3688	0.3703	71926880.0
2012-03-07 16:00:00	NVDA	Stock	0.3703	0.3716	0.3695	0.3703	86400.0
2012-03-07 17:00:00	NVDA	Stock	0.37	0.3703	0.37	0.3703	45360.0
2012-03-07 06:00:00	AMZN	Stock	9.0675	9.0675	9.0675	9.0675	2000.0
2012-03-07 07:00:00	AMZN	Stock	9.115	9.15	9.115	9.15	122000.0
2012-03-07 08:00:00	AMZN	Stock	9.1475	9.16	9.1265	9.16	456460.0
2012-03-07 09:00:00	AMZN	Stock	9.15	9.2694	9.12	9.2165	23993840.0
2012-03-07 10:00:00	AMZN	Stock	9.215	9.249	9.175	9.2265	15637280.0
2012-03-07 11:00:00	AMZN	Stock	9.2255	9.275	9.207	9.224	13664180.0
2012-03-07 12:00:00	AMZN	Stock	9.2261	9.242	9.197	9.2205	7728020.0
2012-03-07 13:00:00	AMZN	Stock	9.2225	9.224	9.15	9.1995	8600620.0
2012-03-07 14:00:00	AMZN	Stock	9.1995	9.2245	9.162	9.2135	10284380.0
2012-03-07 15:00:00	AMZN	Stock	9.213	9.2265	9.175	9.1885	14964220.0
2012-03-07 16:00:00	AMZN	Stock	9.1885	9.2244	9.1735	9.1889	2629500.0

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

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