PREVIEW / stock_1hour / 2015-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-18.parquet
  size:    1.0 MB
  rows:    49,464
  symbols: 3,437

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-11-18 04:00:00	AAPL	Stock	28.445	28.7525	28.445	28.6325	80044.0
2015-11-18 05:00:00	AAPL	Stock	28.6375	28.6725	28.6125	28.6625	20836.0
2015-11-18 06:00:00	AAPL	Stock	28.62	28.6875	28.6175	28.685	299724.0
2015-11-18 07:00:00	AAPL	Stock	28.685	28.9025	28.675	28.9	484484.0
2015-11-18 08:00:00	AAPL	Stock	28.9	28.925	28.65	28.91	949856.0
2015-11-18 09:00:00	AAPL	Stock	28.9	29.3725	28.875	29.2895	42394916.0
2015-11-18 10:00:00	AAPL	Stock	29.2888	29.3125	29.165	29.25	29360844.0
2015-11-18 11:00:00	AAPL	Stock	29.2475	29.34	28.875	29.225	18285600.0
2015-11-18 12:00:00	AAPL	Stock	29.2225	29.24	29.0925	29.125	17086724.0
2015-11-18 13:00:00	AAPL	Stock	29.125	29.1925	29.1	29.108	10427472.0
2015-11-18 14:00:00	AAPL	Stock	29.1075	29.2525	29.0525	29.2128	19615264.0
2015-11-18 15:00:00	AAPL	Stock	29.2125	29.36	29.145	29.3202	28283848.0
2015-11-18 16:00:00	AAPL	Stock	29.3225	29.35	29.243	29.335	6831380.0
2015-11-18 17:00:00	AAPL	Stock	29.335	29.37	29.3225	29.355	758060.0
2015-11-18 18:00:00	AAPL	Stock	29.3675	29.3725	29.3225	29.3625	232072.0
2015-11-18 19:00:00	AAPL	Stock	29.3625	29.375	29.34	29.375	119912.0
2015-11-18 04:00:00	MSFT	Stock	52.95	52.95	52.95	52.95	100.0
2015-11-18 05:00:00	MSFT	Stock	52.87	52.87	52.87	52.87	100.0
2015-11-18 06:00:00	MSFT	Stock	52.95	52.95	52.94	52.94	3100.0
2015-11-18 07:00:00	MSFT	Stock	52.94	53.05	52.94	52.95	4543.0
2015-11-18 08:00:00	MSFT	Stock	52.95	53.1	52.92	53.07	36087.0
2015-11-18 09:00:00	MSFT	Stock	53.09	53.32	52.98	53.169	3265223.0
2015-11-18 10:00:00	MSFT	Stock	53.17	53.425	53.16	53.315	3804495.0
2015-11-18 11:00:00	MSFT	Stock	53.3	53.55	53.19	53.42	3418557.0
2015-11-18 12:00:00	MSFT	Stock	53.42	53.51	53.35	53.43	1921985.0
2015-11-18 13:00:00	MSFT	Stock	53.43	53.58	53.375	53.49	2048438.0
2015-11-18 14:00:00	MSFT	Stock	53.49	53.76	53.405	53.69	4120458.0
2015-11-18 15:00:00	MSFT	Stock	53.68	53.98	53.51	53.84	6482924.0
2015-11-18 16:00:00	MSFT	Stock	53.85	53.93	53.84	53.88	2082407.0
2015-11-18 17:00:00	MSFT	Stock	53.9	53.9	53.85	53.89	41543.0
2015-11-18 18:00:00	MSFT	Stock	53.89	53.92	53.85	53.85	11700.0
2015-11-18 19:00:00	MSFT	Stock	53.92	53.92	53.89	53.91	1664.0
2015-11-18 09:00:00	NVDA	Stock	0.7603	0.7618	0.7545	0.7548	18403240.0
2015-11-18 10:00:00	NVDA	Stock	0.7548	0.759	0.7519	0.7586	48954040.0
2015-11-18 11:00:00	NVDA	Stock	0.7585	0.764	0.7572	0.764	30013200.0
2015-11-18 12:00:00	NVDA	Stock	0.7638	0.766	0.762	0.7658	35569960.0
2015-11-18 13:00:00	NVDA	Stock	0.766	0.7689	0.7652	0.7668	35245640.0
2015-11-18 14:00:00	NVDA	Stock	0.7668	0.7732	0.7665	0.7731	30042440.0
2015-11-18 15:00:00	NVDA	Stock	0.773	0.7768	0.7723	0.7758	87375080.0
2015-11-18 16:00:00	NVDA	Stock	0.7758	0.7758	0.7748	0.7758	14045720.0
2015-11-18 17:00:00	NVDA	Stock	0.7758	0.7758	0.7748	0.7748	386000.0
2015-11-18 18:00:00	NVDA	Stock	0.7748	0.785	0.7748	0.785	18120.0
2015-11-18 07:00:00	AMZN	Stock	32.3	32.3195	32.2995	32.2995	15640.0
2015-11-18 08:00:00	AMZN	Stock	32.3075	32.395	32.2675	32.39	238420.0
2015-11-18 09:00:00	AMZN	Stock	32.39	32.5735	32.3185	32.4875	12307340.0
2015-11-18 10:00:00	AMZN	Stock	32.4875	32.7675	32.468	32.7594	15273040.0
2015-11-18 11:00:00	AMZN	Stock	32.7585	32.9245	32.7187	32.8605	11009400.0
2015-11-18 12:00:00	AMZN	Stock	32.8605	32.8844	32.6788	32.78	6932280.0
2015-11-18 13:00:00	AMZN	Stock	32.776	32.8875	32.764	32.8545	6026800.0
2015-11-18 14:00:00	AMZN	Stock	32.85	32.979	32.7955	32.952	10712080.0

> showing 50 of 49,464 rows — these rows as CSV

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