PREVIEW / stock_1hour / 2011-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-16.parquet
  size:    953 KB
  rows:    45,168
  symbols: 3,513

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-03-16 04:00:00	AAPL	Stock	12.2643	12.2786	12.2007	12.25	234780.0
2011-03-16 05:00:00	AAPL	Stock	12.2521	12.2679	12.2254	12.2254	84000.0
2011-03-16 06:00:00	AAPL	Stock	12.2321	12.2411	12.2036	12.2107	611800.0
2011-03-16 07:00:00	AAPL	Stock	12.2107	12.2668	12.2107	12.2629	995708.0
2011-03-16 08:00:00	AAPL	Stock	12.2625	12.3368	12.2321	12.2564	7124040.0
2011-03-16 09:00:00	AAPL	Stock	12.2514	12.2679	12.0839	12.09	149602236.0
2011-03-16 10:00:00	AAPL	Stock	12.0934	12.1768	12.09	12.0997	127135596.0
2011-03-16 11:00:00	AAPL	Stock	12.1029	12.1104	11.8754	11.931	193098304.0
2011-03-16 12:00:00	AAPL	Stock	11.9304	11.9908	11.8761	11.9681	124008472.0
2011-03-16 13:00:00	AAPL	Stock	11.9657	11.9861	11.845	11.8718	90391336.0
2011-03-16 14:00:00	AAPL	Stock	11.8718	11.9332	11.6521	11.9071	251297144.0
2011-03-16 15:00:00	AAPL	Stock	11.9066	11.9482	11.7711	11.7868	180624360.0
2011-03-16 16:00:00	AAPL	Stock	11.7871	12.1026	11.7075	11.8254	16593164.0
2011-03-16 17:00:00	AAPL	Stock	11.8286	11.8286	11.7321	11.7489	5850628.0
2011-03-16 18:00:00	AAPL	Stock	11.7446	11.7536	11.6786	11.7036	1817900.0
2011-03-16 19:00:00	AAPL	Stock	11.7036	11.725	11.6682	11.675	3025512.0
2011-03-16 07:00:00	MSFT	Stock	25.35	25.37	25.35	25.37	2300.0
2011-03-16 08:00:00	MSFT	Stock	25.37	25.48	25.34	25.42	37508.0
2011-03-16 09:00:00	MSFT	Stock	25.43	25.43	24.95	25.02	12409918.0
2011-03-16 10:00:00	MSFT	Stock	25.029	25.28	25.01	25.01	10858573.0
2011-03-16 11:00:00	MSFT	Stock	25.01	25.03	24.75	24.8	20444551.0
2011-03-16 12:00:00	MSFT	Stock	24.799	24.94	24.75	24.91	10272842.0
2011-03-16 13:00:00	MSFT	Stock	24.91	25.04	24.8	24.86	14192622.0
2011-03-16 14:00:00	MSFT	Stock	24.85	24.97	24.68	24.91	11275323.0
2011-03-16 15:00:00	MSFT	Stock	24.918	24.99	24.78	24.79	14765847.0
2011-03-16 16:00:00	MSFT	Stock	24.79	25.168	24.78	24.8	3176758.0
2011-03-16 17:00:00	MSFT	Stock	24.79	24.81	24.7	24.76	884883.0
2011-03-16 18:00:00	MSFT	Stock	24.76	24.76	24.55	24.71	34363.0
2011-03-16 19:00:00	MSFT	Stock	24.69	24.76	24.62	24.75	32862.0
2011-03-16 08:00:00	NVDA	Stock	0.435	0.4492	0.4345	0.439	3590440.0
2011-03-16 09:00:00	NVDA	Stock	0.44	0.4538	0.4352	0.4515	219843640.0
2011-03-16 10:00:00	NVDA	Stock	0.4512	0.4588	0.4375	0.4508	283111560.0
2011-03-16 11:00:00	NVDA	Stock	0.4508	0.4538	0.4428	0.4438	245647480.0
2011-03-16 12:00:00	NVDA	Stock	0.444	0.447	0.4385	0.446	144518840.0
2011-03-16 13:00:00	NVDA	Stock	0.446	0.4475	0.441	0.444	99966200.0
2011-03-16 14:00:00	NVDA	Stock	0.4438	0.445	0.4325	0.4443	246212640.0
2011-03-16 15:00:00	NVDA	Stock	0.4445	0.4465	0.4368	0.4385	206879280.0
2011-03-16 16:00:00	NVDA	Stock	0.4385	0.4458	0.4375	0.4378	7746120.0
2011-03-16 17:00:00	NVDA	Stock	0.4385	0.4402	0.4382	0.4388	3633160.0
2011-03-16 18:00:00	NVDA	Stock	0.4382	0.4382	0.4362	0.4375	360000.0
2011-03-16 19:00:00	NVDA	Stock	0.438	0.438	0.4362	0.4362	812000.0
2011-03-16 08:00:00	AMZN	Stock	8.2915	8.2915	8.252	8.2815	41800.0
2011-03-16 09:00:00	AMZN	Stock	8.245	8.3382	8.2035	8.3067	13767220.0
2011-03-16 10:00:00	AMZN	Stock	8.3075	8.407	8.3075	8.3308	16102700.0
2011-03-16 11:00:00	AMZN	Stock	8.331	8.336	8.241	8.2495	17493980.0
2011-03-16 12:00:00	AMZN	Stock	8.2483	8.2845	8.2195	8.2738	8481420.0
2011-03-16 13:00:00	AMZN	Stock	8.274	8.279	8.206	8.2255	8516240.0
2011-03-16 14:00:00	AMZN	Stock	8.2255	8.294	8.1435	8.264	14072960.0
2011-03-16 15:00:00	AMZN	Stock	8.263	8.282	8.207	8.2355	21198820.0
2011-03-16 16:00:00	AMZN	Stock	8.237	8.2747	8.23	8.2365	3144400.0

> showing 50 of 45,168 rows — these rows as CSV

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