PREVIEW / stock_1hour / 2016-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-08.parquet
  size:    1.0 MB
  rows:    48,279
  symbols: 3,277

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
2016-07-08 04:00:00	AAPL	Stock	24.0125	24.05	24.0125	24.05	9140.0
2016-07-08 05:00:00	AAPL	Stock	24.025	24.025	23.95	23.95	20580.0
2016-07-08 06:00:00	AAPL	Stock	23.9975	23.9975	23.9975	23.9975	2044.0
2016-07-08 07:00:00	AAPL	Stock	24.0075	24.025	23.9975	23.9975	14636.0
2016-07-08 08:00:00	AAPL	Stock	24.0	24.11	23.9675	24.09	343208.0
2016-07-08 09:00:00	AAPL	Stock	24.0975	24.2225	24.0125	24.1838	16926900.0
2016-07-08 10:00:00	AAPL	Stock	24.1825	24.195	24.105	24.16	14357976.0
2016-07-08 11:00:00	AAPL	Stock	24.1625	24.19	24.1325	24.135	12037680.0
2016-07-08 12:00:00	AAPL	Stock	24.135	24.185	24.1127	24.1475	13213676.0
2016-07-08 13:00:00	AAPL	Stock	24.15	24.1875	24.1438	24.16	7560584.0
2016-07-08 14:00:00	AAPL	Stock	24.1612	24.1737	24.125	24.1562	10110772.0
2016-07-08 15:00:00	AAPL	Stock	24.155	24.1875	24.145	24.17	21465532.0
2016-07-08 16:00:00	AAPL	Stock	24.1678	24.1725	24.125	24.15	10044988.0
2016-07-08 17:00:00	AAPL	Stock	24.145	24.1575	24.1425	24.145	73560.0
2016-07-08 18:00:00	AAPL	Stock	24.145	24.1575	24.145	24.145	71068.0
2016-07-08 19:00:00	AAPL	Stock	24.155	24.1575	24.15	24.15	5716.0
2016-07-08 06:00:00	MSFT	Stock	51.42	51.42	51.42	51.42	300.0
2016-07-08 07:00:00	MSFT	Stock	51.56	51.56	51.56	51.56	240.0
2016-07-08 08:00:00	MSFT	Stock	51.56	51.68	51.45	51.65	26539.0
2016-07-08 09:00:00	MSFT	Stock	51.6	52.155	51.55	52.01	3372997.0
2016-07-08 10:00:00	MSFT	Stock	52.02	52.26	51.93	52.24	3768433.0
2016-07-08 11:00:00	MSFT	Stock	52.25	52.36	52.19	52.315	3432328.0
2016-07-08 12:00:00	MSFT	Stock	52.32	52.355	52.21	52.26	2395368.0
2016-07-08 13:00:00	MSFT	Stock	52.26	52.32	52.23	52.235	1686216.0
2016-07-08 14:00:00	MSFT	Stock	52.235	52.36	52.21	52.3	2893428.0
2016-07-08 15:00:00	MSFT	Stock	52.3	52.35	52.18	52.3	6012036.0
2016-07-08 16:00:00	MSFT	Stock	52.3	52.3	52.219	52.22	3161394.0
2016-07-08 17:00:00	MSFT	Stock	52.25	52.25	52.22	52.22	1051.0
2016-07-08 04:00:00	NVDA	Stock	1.2213	1.2213	1.2213	1.2213	10000.0
2016-07-08 06:00:00	NVDA	Stock	1.2275	1.2275	1.2275	1.2275	4000.0
2016-07-08 07:00:00	NVDA	Stock	1.2315	1.2315	1.2275	1.2315	21040.0
2016-07-08 08:00:00	NVDA	Stock	1.2288	1.2338	1.2288	1.2338	1285640.0
2016-07-08 09:00:00	NVDA	Stock	1.2338	1.2492	1.2305	1.2485	55998240.0
2016-07-08 10:00:00	NVDA	Stock	1.2485	1.2668	1.2473	1.2668	109143680.0
2016-07-08 11:00:00	NVDA	Stock	1.2668	1.271	1.2635	1.2693	73446960.0
2016-07-08 12:00:00	NVDA	Stock	1.2691	1.27	1.2652	1.2661	37809920.0
2016-07-08 13:00:00	NVDA	Stock	1.2663	1.2773	1.2663	1.275	51193680.0
2016-07-08 14:00:00	NVDA	Stock	1.2751	1.2751	1.2708	1.2719	43888880.0
2016-07-08 15:00:00	NVDA	Stock	1.272	1.2752	1.2679	1.2713	77765960.0
2016-07-08 16:00:00	NVDA	Stock	1.2713	1.2713	1.264	1.27	10552160.0
2016-07-08 17:00:00	NVDA	Stock	1.2713	1.2725	1.2703	1.2703	24000.0
2016-07-08 18:00:00	NVDA	Stock	1.271	1.271	1.271	1.271	6000.0
2016-07-08 19:00:00	NVDA	Stock	1.2708	1.2708	1.27	1.27	59800.0
2016-07-08 07:00:00	AMZN	Stock	36.7505	36.8645	36.7505	36.8645	7140.0
2016-07-08 08:00:00	AMZN	Stock	36.865	37.087	36.8515	37.0735	542120.0
2016-07-08 09:00:00	AMZN	Stock	37.05	37.2	36.9	37.1745	9542960.0
2016-07-08 10:00:00	AMZN	Stock	37.175	37.2265	37.0836	37.1895	9241200.0
2016-07-08 11:00:00	AMZN	Stock	37.1925	37.2262	37.1515	37.1783	6710420.0
2016-07-08 12:00:00	AMZN	Stock	37.1776	37.21	37.138	37.1895	4147480.0
2016-07-08 13:00:00	AMZN	Stock	37.1855	37.217	37.1755	37.1955	4285280.0

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

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