PREVIEW / stock_1hour / 2013-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-22.parquet
  size:    959 KB
  rows:    44,851
  symbols: 3,467

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
2013-02-22 04:00:00	AAPL	Stock	15.9946	16.035	15.9875	15.9875	19236.0
2013-02-22 05:00:00	AAPL	Stock	16.0214	16.0214	16.0214	16.0214	2800.0
2013-02-22 06:00:00	AAPL	Stock	15.9789	16.0357	15.9732	16.0357	88256.0
2013-02-22 07:00:00	AAPL	Stock	16.0357	16.0889	16.0179	16.0675	1030372.0
2013-02-22 08:00:00	AAPL	Stock	16.0582	16.0857	15.9286	16.0357	3021760.0
2013-02-22 09:00:00	AAPL	Stock	16.0357	16.1286	15.9661	15.9807	62412280.0
2013-02-22 10:00:00	AAPL	Stock	15.9879	16.0393	15.95	16.0114	59233076.0
2013-02-22 11:00:00	AAPL	Stock	16.0114	16.0421	15.9775	16.0061	33365052.0
2013-02-22 12:00:00	AAPL	Stock	16.0079	16.0496	15.99	16.0432	24758216.0
2013-02-22 13:00:00	AAPL	Stock	16.0459	16.0814	16.025	16.0745	32028052.0
2013-02-22 14:00:00	AAPL	Stock	16.075	16.0768	16.0371	16.0586	21716940.0
2013-02-22 15:00:00	AAPL	Stock	16.0593	16.1071	16.04	16.0939	61700744.0
2013-02-22 16:00:00	AAPL	Stock	16.0964	16.1025	15.9996	16.0857	12948852.0
2013-02-22 17:00:00	AAPL	Stock	16.0875	16.1004	16.0868	16.0954	353360.0
2013-02-22 18:00:00	AAPL	Stock	16.0982	16.1	16.0982	16.0982	47600.0
2013-02-22 19:00:00	AAPL	Stock	16.0982	16.1018	16.0957	16.1018	271684.0
2013-02-22 07:00:00	MSFT	Stock	27.62	27.66	27.62	27.63	4400.0
2013-02-22 08:00:00	MSFT	Stock	27.62	27.69	27.45	27.66	118850.0
2013-02-22 09:00:00	MSFT	Stock	27.65	27.71	27.48	27.52	4438258.0
2013-02-22 10:00:00	MSFT	Stock	27.53	27.65	27.5	27.57	4958312.0
2013-02-22 11:00:00	MSFT	Stock	27.56	27.63	27.53	27.575	3352053.0
2013-02-22 12:00:00	MSFT	Stock	27.58	27.685	27.57	27.666	2283195.0
2013-02-22 13:00:00	MSFT	Stock	27.664	27.69	27.61	27.669	2496047.0
2013-02-22 14:00:00	MSFT	Stock	27.665	27.67	27.59	27.645	2976258.0
2013-02-22 15:00:00	MSFT	Stock	27.64	27.76	27.63	27.75	6849223.0
2013-02-22 16:00:00	MSFT	Stock	27.76	27.76	27.528	27.73	3503223.0
2013-02-22 17:00:00	MSFT	Stock	27.66	27.7	27.65	27.7	4200.0
2013-02-22 18:00:00	MSFT	Stock	27.7	27.7	27.67	27.69	2050.0
2013-02-22 19:00:00	MSFT	Stock	27.69	27.71	27.68	27.71	2242.0
2013-02-22 08:00:00	NVDA	Stock	0.3088	0.31	0.3088	0.3088	272000.0
2013-02-22 09:00:00	NVDA	Stock	0.3088	0.3118	0.3075	0.309	41132880.0
2013-02-22 10:00:00	NVDA	Stock	0.309	0.3118	0.3083	0.3106	71546120.0
2013-02-22 11:00:00	NVDA	Stock	0.3105	0.3108	0.309	0.3103	32309000.0
2013-02-22 12:00:00	NVDA	Stock	0.3103	0.3125	0.31	0.3118	37706440.0
2013-02-22 13:00:00	NVDA	Stock	0.312	0.3123	0.3108	0.3116	30470800.0
2013-02-22 14:00:00	NVDA	Stock	0.3115	0.3118	0.3093	0.3103	34420760.0
2013-02-22 15:00:00	NVDA	Stock	0.31	0.3133	0.31	0.3125	102487480.0
2013-02-22 16:00:00	NVDA	Stock	0.313	0.3138	0.3068	0.3128	5068640.0
2013-02-22 04:00:00	AMZN	Stock	13.35	13.35	13.35	13.35	2000.0
2013-02-22 05:00:00	AMZN	Stock	13.3625	13.3625	13.3625	13.3625	2000.0
2013-02-22 07:00:00	AMZN	Stock	13.39	13.39	13.39	13.39	17600.0
2013-02-22 08:00:00	AMZN	Stock	13.39	13.4	13.297	13.385	107660.0
2013-02-22 09:00:00	AMZN	Stock	13.392	13.392	13.1725	13.2062	9529920.0
2013-02-22 10:00:00	AMZN	Stock	13.205	13.2235	13.1255	13.133	13774420.0
2013-02-22 11:00:00	AMZN	Stock	13.1325	13.192	13.0805	13.168	11222260.0
2013-02-22 12:00:00	AMZN	Stock	13.1708	13.2085	13.155	13.188	5438480.0
2013-02-22 13:00:00	AMZN	Stock	13.1878	13.265	13.1878	13.2479	4673520.0
2013-02-22 14:00:00	AMZN	Stock	13.2505	13.262	13.1955	13.224	4287280.0
2013-02-22 15:00:00	AMZN	Stock	13.224	13.281	13.2235	13.2715	8459920.0
2013-02-22 16:00:00	AMZN	Stock	13.2775	13.3125	13.271	13.275	688880.0

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

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