PREVIEW / stock_1hour / 2011-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-09.parquet
  size:    938 KB
  rows:    44,549
  symbols: 3,500

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-11-09 04:00:00	AAPL	Stock	14.4643	14.4643	14.3571	14.3571	167860.0
2011-11-09 05:00:00	AAPL	Stock	14.3804	14.3804	14.2143	14.2143	181020.0
2011-11-09 06:00:00	AAPL	Stock	14.25	14.25	14.2254	14.2343	105000.0
2011-11-09 07:00:00	AAPL	Stock	14.2486	14.3132	14.1864	14.2107	3800860.0
2011-11-09 08:00:00	AAPL	Stock	14.2139	14.3014	14.2004	14.2411	9053380.0
2011-11-09 09:00:00	AAPL	Stock	14.2439	14.2536	14.15	14.1929	116749948.0
2011-11-09 10:00:00	AAPL	Stock	14.1929	14.2596	14.1654	14.2418	95475184.0
2011-11-09 11:00:00	AAPL	Stock	14.2414	14.3175	14.2361	14.2679	54703068.0
2011-11-09 12:00:00	AAPL	Stock	14.2679	14.2793	14.2307	14.2636	28798700.0
2011-11-09 13:00:00	AAPL	Stock	14.2636	14.2764	14.1696	14.1796	37644824.0
2011-11-09 14:00:00	AAPL	Stock	14.1796	14.1832	14.1075	14.1196	88647440.0
2011-11-09 15:00:00	AAPL	Stock	14.1193	14.15	14.0796	14.1182	99820280.0
2011-11-09 16:00:00	AAPL	Stock	14.1182	14.2343	14.0931	14.1179	19865692.0
2011-11-09 17:00:00	AAPL	Stock	14.1204	14.1214	14.1079	14.1107	250012.0
2011-11-09 18:00:00	AAPL	Stock	14.1139	14.1175	14.0357	14.0714	735840.0
2011-11-09 19:00:00	AAPL	Stock	14.0714	14.0846	14.0571	14.0725	246680.0
2011-11-09 04:00:00	MSFT	Stock	26.95	26.95	26.95	26.95	300.0
2011-11-09 05:00:00	MSFT	Stock	26.66	26.66	26.57	26.57	13100.0
2011-11-09 06:00:00	MSFT	Stock	26.5	26.5	26.5	26.5	500.0
2011-11-09 07:00:00	MSFT	Stock	26.6	26.74	26.58	26.59	22176.0
2011-11-09 08:00:00	MSFT	Stock	26.65	26.75	26.6	26.68	79015.0
2011-11-09 09:00:00	MSFT	Stock	26.68	26.7	26.44	26.507	5320644.0
2011-11-09 10:00:00	MSFT	Stock	26.5	26.63	26.45	26.57	8650402.0
2011-11-09 11:00:00	MSFT	Stock	26.57	26.7	26.52	26.69	4730472.0
2011-11-09 12:00:00	MSFT	Stock	26.685	26.75	26.61	26.74	3961494.0
2011-11-09 13:00:00	MSFT	Stock	26.74	26.75	26.36	26.385	5797177.0
2011-11-09 14:00:00	MSFT	Stock	26.38	26.389	26.07	26.09	11923918.0
2011-11-09 15:00:00	MSFT	Stock	26.1	26.27	26.06	26.2	16083105.0
2011-11-09 16:00:00	MSFT	Stock	26.2	26.66	26.06	26.26	3636152.0
2011-11-09 17:00:00	MSFT	Stock	26.2	26.28	26.2	26.25	74989.0
2011-11-09 18:00:00	MSFT	Stock	26.2	26.25	26.2	26.2	85757.0
2011-11-09 19:00:00	MSFT	Stock	26.2	26.2	26.1	26.11	11097.0
2011-11-09 07:00:00	NVDA	Stock	0.369	0.37	0.3675	0.3675	686320.0
2011-11-09 08:00:00	NVDA	Stock	0.3675	0.372	0.3658	0.3685	1219440.0
2011-11-09 09:00:00	NVDA	Stock	0.3685	0.373	0.3638	0.369	59575440.0
2011-11-09 10:00:00	NVDA	Stock	0.369	0.3695	0.364	0.3652	91526000.0
2011-11-09 11:00:00	NVDA	Stock	0.365	0.3685	0.3648	0.3672	41513480.0
2011-11-09 12:00:00	NVDA	Stock	0.367	0.368	0.365	0.366	26167120.0
2011-11-09 13:00:00	NVDA	Stock	0.3662	0.3672	0.36	0.3612	48629040.0
2011-11-09 14:00:00	NVDA	Stock	0.361	0.361	0.3568	0.359	87233560.0
2011-11-09 15:00:00	NVDA	Stock	0.3588	0.361	0.3565	0.358	154658080.0
2011-11-09 16:00:00	NVDA	Stock	0.358	0.364	0.358	0.358	18361080.0
2011-11-09 17:00:00	NVDA	Stock	0.3612	0.3615	0.3595	0.36	361600.0
2011-11-09 18:00:00	NVDA	Stock	0.36	0.3625	0.358	0.3625	803760.0
2011-11-09 19:00:00	NVDA	Stock	0.3625	0.3625	0.3582	0.3585	103000.0
2011-11-09 04:00:00	AMZN	Stock	10.844	10.844	10.75	10.75	10000.0
2011-11-09 05:00:00	AMZN	Stock	10.7625	10.7625	10.712	10.7495	24000.0
2011-11-09 06:00:00	AMZN	Stock	10.6845	10.6845	10.626	10.626	4000.0
2011-11-09 07:00:00	AMZN	Stock	10.655	10.7	10.655	10.695	25000.0
2011-11-09 08:00:00	AMZN	Stock	10.6875	10.74	10.6835	10.7275	450960.0

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

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