PREVIEW / stock_1hour / 2015-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-03.parquet
  size:    1.0 MB
  rows:    48,823
  symbols: 3,517

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
2015-03-03 04:00:00	AAPL	Stock	32.225	32.275	32.225	32.275	1000.0
2015-03-03 05:00:00	AAPL	Stock	32.2725	32.295	32.25	32.295	23672.0
2015-03-03 06:00:00	AAPL	Stock	32.295	32.325	32.275	32.3125	21388.0
2015-03-03 07:00:00	AAPL	Stock	32.3025	32.3375	32.2925	32.3	83696.0
2015-03-03 08:00:00	AAPL	Stock	32.2975	32.3325	32.1625	32.2275	529968.0
2015-03-03 09:00:00	AAPL	Stock	32.225	32.3675	32.1	32.235	24342656.0
2015-03-03 10:00:00	AAPL	Stock	32.2362	32.365	32.0825	32.125	27192256.0
2015-03-03 11:00:00	AAPL	Stock	32.125	32.1925	32.0525	32.1562	19440792.0
2015-03-03 12:00:00	AAPL	Stock	32.1572	32.2122	32.0225	32.2068	14234240.0
2015-03-03 13:00:00	AAPL	Stock	32.205	32.25	32.1875	32.22	10560800.0
2015-03-03 14:00:00	AAPL	Stock	32.22	32.38	32.175	32.26	17691556.0
2015-03-03 15:00:00	AAPL	Stock	32.2612	32.3525	32.2212	32.345	18309784.0
2015-03-03 16:00:00	AAPL	Stock	32.3375	32.372	32.2262	32.3225	7247336.0
2015-03-03 17:00:00	AAPL	Stock	32.3275	32.34	32.275	32.3075	90516.0
2015-03-03 18:00:00	AAPL	Stock	32.315	32.325	32.3075	32.325	56972.0
2015-03-03 19:00:00	AAPL	Stock	32.3275	32.3275	32.2575	32.2725	123744.0
2015-03-03 07:00:00	MSFT	Stock	43.84	43.84	43.76	43.76	1700.0
2015-03-03 08:00:00	MSFT	Stock	43.76	43.8	43.67	43.68	8250.0
2015-03-03 09:00:00	MSFT	Stock	43.63	43.88	43.4	43.61	3303250.0
2015-03-03 10:00:00	MSFT	Stock	43.61	43.63	43.175	43.18	5164789.0
2015-03-03 11:00:00	MSFT	Stock	43.185	43.289	43.11	43.205	4152640.0
2015-03-03 12:00:00	MSFT	Stock	43.21	43.4	43.09	43.299	2860415.0
2015-03-03 13:00:00	MSFT	Stock	43.3	43.35	43.185	43.25	2457891.0
2015-03-03 14:00:00	MSFT	Stock	43.26	43.34	43.22	43.29	2949000.0
2015-03-03 15:00:00	MSFT	Stock	43.295	43.33	43.2	43.27	6968415.0
2015-03-03 16:00:00	MSFT	Stock	43.28	43.347	43.2	43.29	2382839.0
2015-03-03 17:00:00	MSFT	Stock	43.28	43.28	43.28	43.28	11706.0
2015-03-03 18:00:00	MSFT	Stock	43.22	43.22	43.13	43.13	424.0
2015-03-03 19:00:00	MSFT	Stock	43.27	43.27	43.19	43.19	825.0
2015-03-03 08:00:00	NVDA	Stock	0.5648	0.5648	0.5648	0.5648	4000.0
2015-03-03 09:00:00	NVDA	Stock	0.561	0.5635	0.5585	0.5595	19619200.0
2015-03-03 10:00:00	NVDA	Stock	0.5595	0.5622	0.5582	0.5598	29648200.0
2015-03-03 11:00:00	NVDA	Stock	0.5596	0.5598	0.553	0.555	25355160.0
2015-03-03 12:00:00	NVDA	Stock	0.5551	0.5552	0.5528	0.5552	13343400.0
2015-03-03 13:00:00	NVDA	Stock	0.5554	0.557	0.555	0.5555	15121480.0
2015-03-03 14:00:00	NVDA	Stock	0.5556	0.5576	0.554	0.5545	13147680.0
2015-03-03 15:00:00	NVDA	Stock	0.5546	0.5565	0.5535	0.5545	29054600.0
2015-03-03 16:00:00	NVDA	Stock	0.5545	0.5617	0.5544	0.5544	10911960.0
2015-03-03 08:00:00	AMZN	Stock	19.239	19.242	19.21	19.2255	83640.0
2015-03-03 09:00:00	AMZN	Stock	19.213	19.214	19.08	19.1723	6646120.0
2015-03-03 10:00:00	AMZN	Stock	19.176	19.305	19.1505	19.183	9863020.0
2015-03-03 11:00:00	AMZN	Stock	19.182	19.1995	19.1095	19.172	4200560.0
2015-03-03 12:00:00	AMZN	Stock	19.1635	19.2025	19.1005	19.198	2716240.0
2015-03-03 13:00:00	AMZN	Stock	19.1995	19.23	19.179	19.225	1767260.0
2015-03-03 14:00:00	AMZN	Stock	19.2235	19.2442	19.1615	19.192	2965620.0
2015-03-03 15:00:00	AMZN	Stock	19.1925	19.246	19.1605	19.2295	4937040.0
2015-03-03 16:00:00	AMZN	Stock	19.2305	19.2328	19.1916	19.2328	2008480.0
2015-03-03 17:00:00	AMZN	Stock	19.2324	19.2324	19.2324	19.2324	4000.0
2015-03-03 18:00:00	AMZN	Stock	19.205	19.205	19.205	19.205	4160.0
2015-03-03 19:00:00	AMZN	Stock	19.2	19.2	19.2	19.2	2000.0

> showing 50 of 48,823 rows — these rows as CSV

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