PREVIEW / stock_1hour / 2017-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-09.parquet
  size:    1.1 MB
  rows:    48,747
  symbols: 3,091

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
2017-03-09 04:00:00	AAPL	Stock	34.81	34.8275	34.81	34.825	2696.0
2017-03-09 05:00:00	AAPL	Stock	34.7625	34.7625	34.7575	34.7575	2356.0
2017-03-09 06:00:00	AAPL	Stock	34.6775	34.6775	34.6425	34.6475	16492.0
2017-03-09 07:00:00	AAPL	Stock	34.675	34.675	34.6325	34.6525	79392.0
2017-03-09 08:00:00	AAPL	Stock	34.65	34.705	34.605	34.7	404800.0
2017-03-09 09:00:00	AAPL	Stock	34.7	34.7025	34.2625	34.61	22704032.0
2017-03-09 10:00:00	AAPL	Stock	34.6075	34.6788	34.5875	34.6612	11450500.0
2017-03-09 11:00:00	AAPL	Stock	34.6612	34.685	34.6295	34.655	5412952.0
2017-03-09 12:00:00	AAPL	Stock	34.655	34.6638	34.5875	34.6275	4147836.0
2017-03-09 13:00:00	AAPL	Stock	34.6287	34.6425	34.56	34.5772	4557024.0
2017-03-09 14:00:00	AAPL	Stock	34.5775	34.58	34.45	34.57	9174144.0
2017-03-09 15:00:00	AAPL	Stock	34.57	34.6725	34.5675	34.67	11207348.0
2017-03-09 16:00:00	AAPL	Stock	34.67	34.6775	34.6525	34.6625	10536688.0
2017-03-09 17:00:00	AAPL	Stock	34.68	34.68	34.6625	34.675	38764.0
2017-03-09 18:00:00	AAPL	Stock	34.6625	34.6825	34.6625	34.6825	18928.0
2017-03-09 19:00:00	AAPL	Stock	34.685	34.7125	34.685	34.7125	50652.0
2017-03-09 08:00:00	MSFT	Stock	64.88	65.01	64.88	65.01	6374.0
2017-03-09 09:00:00	MSFT	Stock	64.99	65.2	64.79	64.94	2927006.0
2017-03-09 10:00:00	MSFT	Stock	64.945	65.0	64.86	64.967	2302022.0
2017-03-09 11:00:00	MSFT	Stock	64.965	65.08	64.86	64.91	1639785.0
2017-03-09 12:00:00	MSFT	Stock	64.91	64.95	64.83	64.86	1291022.0
2017-03-09 13:00:00	MSFT	Stock	64.86	64.87	64.59	64.635	1500770.0
2017-03-09 14:00:00	MSFT	Stock	64.635	64.656	64.48	64.605	2402486.0
2017-03-09 15:00:00	MSFT	Stock	64.605	64.845	64.6	64.74	3715683.0
2017-03-09 16:00:00	MSFT	Stock	64.73	64.73	64.65	64.73	2251968.0
2017-03-09 17:00:00	MSFT	Stock	64.83	64.83	64.83	64.83	193.0
2017-03-09 18:00:00	MSFT	Stock	64.83	64.83	64.83	64.83	100.0
2017-03-09 19:00:00	MSFT	Stock	64.9	64.9	64.9	64.9	135.0
2017-03-09 04:00:00	NVDA	Stock	2.4598	2.4698	2.4598	2.4698	44000.0
2017-03-09 06:00:00	NVDA	Stock	2.4575	2.4575	2.4325	2.433	29520.0
2017-03-09 07:00:00	NVDA	Stock	2.441	2.4412	2.44	2.44	64360.0
2017-03-09 08:00:00	NVDA	Stock	2.4438	2.4462	2.4325	2.4415	3846120.0
2017-03-09 09:00:00	NVDA	Stock	2.4375	2.4838	2.434	2.4765	106638240.0
2017-03-09 10:00:00	NVDA	Stock	2.4775	2.4862	2.4483	2.4528	88086440.0
2017-03-09 11:00:00	NVDA	Stock	2.4532	2.457	2.44	2.446	58345800.0
2017-03-09 12:00:00	NVDA	Stock	2.4465	2.4558	2.4448	2.4548	28175240.0
2017-03-09 13:00:00	NVDA	Stock	2.4548	2.458	2.4503	2.4512	25511840.0
2017-03-09 14:00:00	NVDA	Stock	2.4521	2.4521	2.4405	2.4485	43333760.0
2017-03-09 15:00:00	NVDA	Stock	2.4488	2.4742	2.4488	2.4635	91160960.0
2017-03-09 16:00:00	NVDA	Stock	2.4635	2.4635	2.4588	2.4593	1703680.0
2017-03-09 17:00:00	NVDA	Stock	2.4593	2.4593	2.4538	2.4575	370560.0
2017-03-09 18:00:00	NVDA	Stock	2.4563	2.4575	2.4563	2.4575	49000.0
2017-03-09 19:00:00	NVDA	Stock	2.455	2.4598	2.455	2.4588	82000.0
2017-03-09 06:00:00	AMZN	Stock	42.529	42.529	42.529	42.529	6000.0
2017-03-09 07:00:00	AMZN	Stock	42.512	42.512	42.512	42.512	6980.0
2017-03-09 08:00:00	AMZN	Stock	42.4835	42.5495	42.4615	42.5495	10560.0
2017-03-09 09:00:00	AMZN	Stock	42.525	42.71	42.5225	42.6895	5953180.0
2017-03-09 10:00:00	AMZN	Stock	42.672	42.82	42.659	42.7139	8051580.0
2017-03-09 11:00:00	AMZN	Stock	42.725	42.759	42.691	42.691	2925700.0
2017-03-09 12:00:00	AMZN	Stock	42.6948	42.7125	42.6535	42.685	2108240.0

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

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