PREVIEW / stock_1hour / 2012-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-21.parquet
  size:    977 KB
  rows:    45,487
  symbols: 3,505

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-09-21 04:00:00	AAPL	Stock	24.9911	25.045	24.9911	25.045	42000.0
2012-09-21 05:00:00	AAPL	Stock	25.0446	25.0475	25.0446	25.0475	14000.0
2012-09-21 06:00:00	AAPL	Stock	25.0214	25.0475	25.0214	25.0393	34580.0
2012-09-21 07:00:00	AAPL	Stock	25.0654	25.1546	25.0307	25.1304	1384656.0
2012-09-21 08:00:00	AAPL	Stock	25.1304	25.1518	25.0671	25.1293	4631032.0
2012-09-21 09:00:00	AAPL	Stock	25.1304	25.1546	25.0539	25.1136	131655160.0
2012-09-21 10:00:00	AAPL	Stock	25.1139	25.1811	25.0954	25.1536	74644892.0
2012-09-21 11:00:00	AAPL	Stock	25.1532	25.1768	25.1429	25.1714	32169340.0
2012-09-21 12:00:00	AAPL	Stock	25.1714	25.1761	25.1504	25.1682	25861472.0
2012-09-21 13:00:00	AAPL	Stock	25.1683	25.1707	25.0914	25.0929	35360248.0
2012-09-21 14:00:00	AAPL	Stock	25.0921	25.1179	25.0093	25.0771	63192724.0
2012-09-21 15:00:00	AAPL	Stock	25.081	25.085	24.9772	25.025	99164828.0
2012-09-21 16:00:00	AAPL	Stock	25.025	25.1517	24.9925	25.0004	71170988.0
2012-09-21 17:00:00	AAPL	Stock	25.0018	25.0254	24.9921	25.0036	2330132.0
2012-09-21 18:00:00	AAPL	Stock	25.0029	25.0254	24.9943	25.0025	432712.0
2012-09-21 19:00:00	AAPL	Stock	25.0021	25.0036	24.9925	25.0036	472780.0
2012-09-21 04:00:00	MSFT	Stock	31.45	31.45	31.44	31.45	500.0
2012-09-21 07:00:00	MSFT	Stock	31.45	31.46	31.4	31.46	6600.0
2012-09-21 08:00:00	MSFT	Stock	31.45	31.46	31.36	31.4	29434.0
2012-09-21 09:00:00	MSFT	Stock	31.44	31.61	31.39	31.54	23668594.0
2012-09-21 10:00:00	MSFT	Stock	31.54	31.59	31.32	31.32	9024959.0
2012-09-21 11:00:00	MSFT	Stock	31.32	31.33	31.15	31.245	7105452.0
2012-09-21 12:00:00	MSFT	Stock	31.245	31.34	31.24	31.34	2571660.0
2012-09-21 13:00:00	MSFT	Stock	31.33	31.37	31.27	31.27	3872618.0
2012-09-21 14:00:00	MSFT	Stock	31.27	31.28	31.09	31.155	6318440.0
2012-09-21 15:00:00	MSFT	Stock	31.155	31.33	31.14	31.29	21868627.0
2012-09-21 16:00:00	MSFT	Stock	31.29	31.41	31.13	31.231	24350180.0
2012-09-21 17:00:00	MSFT	Stock	31.226	31.242	31.226	31.242	158124.0
2012-09-21 18:00:00	MSFT	Stock	31.23	31.23	31.19	31.19	62911.0
2012-09-21 19:00:00	MSFT	Stock	31.16	31.16	31.11	31.11	8354.0
2012-09-21 09:00:00	NVDA	Stock	0.3405	0.3435	0.34	0.3428	71298200.0
2012-09-21 10:00:00	NVDA	Stock	0.3429	0.3429	0.34	0.3404	28550320.0
2012-09-21 11:00:00	NVDA	Stock	0.3403	0.3413	0.3395	0.3408	31078400.0
2012-09-21 12:00:00	NVDA	Stock	0.3408	0.3433	0.3405	0.3433	27958360.0
2012-09-21 13:00:00	NVDA	Stock	0.3433	0.3438	0.3425	0.343	20314360.0
2012-09-21 14:00:00	NVDA	Stock	0.343	0.3433	0.3413	0.3419	34369120.0
2012-09-21 15:00:00	NVDA	Stock	0.3415	0.3422	0.341	0.342	78361760.0
2012-09-21 16:00:00	NVDA	Stock	0.3418	0.342	0.3405	0.3415	41680640.0
2012-09-21 17:00:00	NVDA	Stock	0.3416	0.3418	0.341	0.341	1127680.0
2012-09-21 04:00:00	AMZN	Stock	13.05	13.055	13.05	13.055	4000.0
2012-09-21 07:00:00	AMZN	Stock	13.0505	13.075	13.0505	13.075	16600.0
2012-09-21 08:00:00	AMZN	Stock	13.085	13.118	13.075	13.1	107580.0
2012-09-21 09:00:00	AMZN	Stock	13.1	13.1	12.9775	12.9856	25622040.0
2012-09-21 10:00:00	AMZN	Stock	12.985	12.9935	12.945	12.9525	34171640.0
2012-09-21 11:00:00	AMZN	Stock	12.9525	12.999	12.9505	12.969	4838700.0
2012-09-21 12:00:00	AMZN	Stock	12.9675	12.977	12.9275	12.936	7024600.0
2012-09-21 13:00:00	AMZN	Stock	12.9366	12.9425	12.9125	12.918	5477740.0
2012-09-21 14:00:00	AMZN	Stock	12.9205	12.9265	12.875	12.8755	6833260.0
2012-09-21 15:00:00	AMZN	Stock	12.8765	12.905	12.837	12.8755	15261820.0
2012-09-21 16:00:00	AMZN	Stock	12.875	13.0611	12.851	12.8535	18575960.0

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

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