PREVIEW / stock_1hour / 2013-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-31.parquet
  size:    1.0 MB
  rows:    47,869
  symbols: 3,519

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-05-31 04:00:00	AAPL	Stock	16.0893	16.0893	16.0282	16.0282	27720.0
2013-05-31 05:00:00	AAPL	Stock	16.0289	16.0357	16.0268	16.0268	19600.0
2013-05-31 06:00:00	AAPL	Stock	16.0268	16.0504	16.0268	16.0286	36400.0
2013-05-31 07:00:00	AAPL	Stock	16.0357	16.1064	16.0357	16.0668	249452.0
2013-05-31 08:00:00	AAPL	Stock	16.0789	16.1429	16.0289	16.1143	2074548.0
2013-05-31 09:00:00	AAPL	Stock	16.1143	16.2961	16.1096	16.2564	68993288.0
2013-05-31 10:00:00	AAPL	Stock	16.2579	16.3011	16.2343	16.2567	60295844.0
2013-05-31 11:00:00	AAPL	Stock	16.2561	16.325	16.2414	16.3129	39520936.0
2013-05-31 12:00:00	AAPL	Stock	16.3132	16.3177	16.2761	16.3036	20048420.0
2013-05-31 13:00:00	AAPL	Stock	16.3036	16.3221	16.2429	16.2446	28912380.0
2013-05-31 14:00:00	AAPL	Stock	16.245	16.2529	16.1618	16.1782	44295328.0
2013-05-31 15:00:00	AAPL	Stock	16.1775	16.2196	16.0536	16.0536	78050672.0
2013-05-31 16:00:00	AAPL	Stock	16.0632	16.2286	16.0536	16.06	27276816.0
2013-05-31 17:00:00	AAPL	Stock	16.0704	16.0732	16.0586	16.0586	2897860.0
2013-05-31 18:00:00	AAPL	Stock	16.0575	16.06	16.0268	16.0321	853804.0
2013-05-31 19:00:00	AAPL	Stock	16.0321	16.0518	16.0321	16.0414	120204.0
2013-05-31 08:00:00	MSFT	Stock	34.87	35.03	34.87	34.92	28154.0
2013-05-31 09:00:00	MSFT	Stock	34.87	35.05	34.79	35.045	4762929.0
2013-05-31 10:00:00	MSFT	Stock	35.045	35.15	34.94	35.1	5048427.0
2013-05-31 11:00:00	MSFT	Stock	35.091	35.28	35.091	35.165	5332396.0
2013-05-31 12:00:00	MSFT	Stock	35.165	35.19	35.07	35.11	2746871.0
2013-05-31 13:00:00	MSFT	Stock	35.11	35.21	35.11	35.2	2685024.0
2013-05-31 14:00:00	MSFT	Stock	35.195	35.266	35.16	35.165	4230647.0
2013-05-31 15:00:00	MSFT	Stock	35.165	35.2	34.87	34.88	13860289.0
2013-05-31 16:00:00	MSFT	Stock	34.88	35.042	34.75	34.88	15486522.0
2013-05-31 17:00:00	MSFT	Stock	34.74	35.18	34.74	34.75	316868.0
2013-05-31 18:00:00	MSFT	Stock	34.77	35.18	34.77	35.15	5102.0
2013-05-31 19:00:00	MSFT	Stock	34.77	34.77	34.77	34.77	125.0
2013-05-31 09:00:00	NVDA	Stock	0.364	0.3672	0.3632	0.3665	23425320.0
2013-05-31 10:00:00	NVDA	Stock	0.3665	0.369	0.366	0.367	60426640.0
2013-05-31 11:00:00	NVDA	Stock	0.367	0.369	0.3665	0.367	32036800.0
2013-05-31 12:00:00	NVDA	Stock	0.367	0.3671	0.365	0.365	30183000.0
2013-05-31 13:00:00	NVDA	Stock	0.365	0.366	0.3648	0.366	26756960.0
2013-05-31 14:00:00	NVDA	Stock	0.3658	0.3661	0.3642	0.3649	38250160.0
2013-05-31 15:00:00	NVDA	Stock	0.3648	0.3652	0.3618	0.3618	93989240.0
2013-05-31 16:00:00	NVDA	Stock	0.362	0.3748	0.3615	0.3624	60669480.0
2013-05-31 17:00:00	NVDA	Stock	0.3622	0.3622	0.3622	0.3622	81040.0
2013-05-31 18:00:00	NVDA	Stock	0.3622	0.3622	0.3622	0.3622	6080.0
2013-05-31 19:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	12000.0
2013-05-31 07:00:00	AMZN	Stock	13.2885	13.291	13.2885	13.291	8000.0
2013-05-31 08:00:00	AMZN	Stock	13.3	13.3465	13.3	13.3205	189160.0
2013-05-31 09:00:00	AMZN	Stock	13.3185	13.525	13.2865	13.501	9834260.0
2013-05-31 10:00:00	AMZN	Stock	13.501	13.5375	13.4645	13.486	7377400.0
2013-05-31 11:00:00	AMZN	Stock	13.489	13.5955	13.484	13.5725	10016700.0
2013-05-31 12:00:00	AMZN	Stock	13.5706	13.5738	13.51	13.5422	3799660.0
2013-05-31 13:00:00	AMZN	Stock	13.5415	13.595	13.5415	13.5762	4053500.0
2013-05-31 14:00:00	AMZN	Stock	13.5775	13.58	13.501	13.5045	5882980.0
2013-05-31 15:00:00	AMZN	Stock	13.5025	13.5365	13.45	13.4515	12937380.0
2013-05-31 16:00:00	AMZN	Stock	13.461	13.5352	13.4402	13.5027	3280240.0
2013-05-31 17:00:00	AMZN	Stock	13.4552	13.4552	13.44	13.44	526660.0

> showing 50 of 47,869 rows — these rows as CSV

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